NXP Online

Hangin' Around Joined: Apr 11, 2009 Posts: 48

Hello,

is the "NXP Online" by http://www.phpnuke-nederland.com/downloadview-details-2.html compatible with raven?

Yours sincerely

Posted: Sat Dec 12, 2009 10:57 am

I have some doubts it will work flawless but try it out. Set display_errors to true in config.php and in rnconfig: $error_reporting = E_ALL;
to test it.

Posted: Sat Dec 12, 2009 5:39 pm

I have tried to up the instalieren showed me 29%, and these errors:

Code:




Creating Tables & Inserting Data


The tables and data required to run this block will now be created in your database.





   


Creating table nuke_nxp_botlist    Failed To Create


Creating table nuke_nxp_online    Table Created


Creating table nuke_nxp_online_config    Table Created


Creating table nuke_nxp_online_icons    Table Created


Inserting data into nuke_nxp_botlist


[Number of lines to insert: 433]    Data Missing


0 Lines Inserted


Inserting data into nuke_nxp_online_config


[Number of lines to insert: 69]    Data Inserted


69 Lines Verified





It appears that one or more the tables have not inserted the data correctly into your tables, to try again click RE-CHECK or go to PHP Nuke Nederland for help

Posted: Sat Dec 12, 2009 6:11 pm

Via PhpMyAdmin you can manually create the table nuke_nxp_botlist and add the missing lines there too or try the "Re-Check".
I have never used the block and can´t tell you if it will work.

Posted: Sat Dec 12, 2009 7:09 pm

through PhpMyAdmin, I can not paste it because there is no SQL file. There is only one instalation folder where I can´t find files, no SQL

Posted: Sat Dec 12, 2009 8:13 pm

Open /nxp_online_install/nxp_online_step_4.php and find line 49:

Code:




'nxp_botlist_vers` int(5) NOT NULL default '',

Change it to:

Code:




`nxp_botlist_vers` int(5) NOT NULL default 0,

Posted: Sat Dec 12, 2009 8:26 pm

Also this makes reference to a includes/my_header.php. Disregard this and do the following.

Create includes/custom_files/custom_header.php and put the following code in it:

Code:




<?php





// NXP Online [BETA 3] --------------------------------------------------------------------------|


include_once("includes/my_header_nxp_online.php");


// End ---------------------------------------------------------------------------------------------------|





?>

Open /nxp_online_install/nxp_online_step_5.php and find line 42:

Code:




$lines = file("includes/my_header.php");

Change it to

Code:




$lines = file("includes/custom_files/custom_header.php");

Posted: Sat Dec 12, 2009 8:53 pm

The block also needs a fix for the security code.

Open /blocks/nxp_online/nxp_online_login.php and find lines 68-79:

Code:




      if (extension_loaded ("gd") AND ($gfx_chk == 2 OR $gfx_chk == 4 OR $gfx_chk == 5 OR $gfx_chk == 7))


   {


      $content .= "         <td align='left' valign='middle' colspan='2' height='18' class='boxcontent'>\n";


      $content .= "            " . _TYPESECCODE . "</td>\n";


      $content .= "      </tr>\n";


      $content .= "      <tr>\n";


      $content .= "         <td align='left' valign='middle'>\n";


      $content .= "            <input type='text' name='gfx_check' size='7' maxlength='6'></td>\n";


      $content .= "         <td align='right' valign='middle'>\n";


      $content .= "            <img src='modules.php?name=Your_Account&op=gfx&random_num=" . $random_num . "' border='1' width='77' height='20' align='center' alt='" . _SECURITYCODE . "' title='" . _SECURITYCODE . "'></td>\n";


      $content .= "            <input type='hidden' name='random_num' value='" . $random_num . "' /></td>\n";


   }

Replace with:

Code:




      if (extension_loaded ("gd") AND ($gfx_chk == 2 OR $gfx_chk == 4 OR $gfx_chk == 5 OR $gfx_chk == 7))


   {


      $content .= "         <td align='left' valign='middle' colspan='2' height='18' class='boxcontent'>\n";


      $content .= "            " . _TYPESECCODE . "</td>\n";


      $content .= "      </tr>\n";


      $content .= "      <tr>\n";


      $content .= "         <td align='left' valign='middle' colspan='2'>\n";


      $content .=             security_code(array(2,4,5,7), 'stacked');


      $content .= "            </td>\n";


   }

Posted: Sat Dec 12, 2009 9:26 pm

Thank you for your help.

if you find a new security vulnerabilities please inform me.

With Kind regards, thanks

New Member Joined: Jan 03, 2010 Posts: 16

Palbin,
Thank you for all the fixes!
Block installed without a problem!
It seems like the iplookup table is out of date.
Could you show us how to update the nuke_nxp_online_iplookup table?

New Member Joined: Feb 18, 2009 Posts: 1

With the new update v2,51 , I'm getting:

i.e.
Warning: mysql_list_tables() [function.mysql-list-tables]: Access denied for user 'root'@'localhost' (using password: NO)

Are there any easy fix to this block or should I scrap it?
I red about Coppermine was old and outdated, and will not work with 2,51, is it the same here?

Posted: Sat Oct 12, 2013 11:15 pm

if will be difficult for anyone to say without seeing the code itself, but mysql_list_tables is a depreciated function and also an indicator that the code is likely in need of other updates as well.

There could be a fix but I can't say it would be easy... depending on your skill level.

"This function is deprecated. It is preferable to use mysql_query() to issue an SQL SHOW TABLES [FROM db_name] [LIKE 'pattern'] statement instead." [ Only registered users can see links on this board! Get registered or login! ]

note the actual syntax you use would have to be based upon our database class.
// where $sql is your db query, also making sure $db is added to your globals
$db->sql_query($sql)

I can't really give you a better example off the top of my head, although someone else may be familiar with the block but I've never used/seen it.

On a side note.... For a more capable and up-to-date Gallery try RN Gallery [ Only registered users can see links on this board! Get registered or login! ]

Posted: Sun Oct 13, 2013 1:52 am

Code:







$table = $prefix . '_yourtable';


if($db->sql_numrows($db->sql_query('SHOW TABLES LIKE \'' . $table . '\''))==1) {


    //yourcode.....


   


}