okay i am trying to mod IVPB 2.0 and i currently have one stubbern error that i can not figure out

the line of error

LINES 1206-1242

PHP Code:

        
                $subres = mysql_query("SELECT * FROM users WHERE username='".$member['name']."'") ;
$CURUSER=mysql_fetch_array($subres);


if ($CURUSER["downloaded"])
                {
                  $ratio = $CURUSER["uploaded"] / $CURUSER["downloaded"];
                  if ($ratio < 0.1)
                    $s = "<font color=#ff0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.2)
                    $s = "<font color=#ee0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.3)
                    $s = "<font color=#dd0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.4)
                    $s = "<font color=#cc0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.5)
                    $s = "<font color=#bb0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.6)
                    $s = "<font color=#aa0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.7)
                    $s = "<font color=#990000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.8)
                    $s = "<font color=#880000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.9)
                    $s = "<font color=#770000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 1)
                    $s = "<font color=#660000>" . number_format($ratio, 2) . "</font>";
                  else
                    $s =  number_format($ratio, 2) ;
                }
                else
                  if ($CURUSER["uploaded"])
                    $s = "Inf.";
                  else
                    $s = "---"; 


error

IPB WARNING [2] mysql_fetch_array(): supplied argument is not a valid MySQL result resource (Line: 1208 of /sources/topics.php)

if you want the entire script please let me know and i'll post the page in a zip file

It means the query failed, and since the query failed, it is not a valid result resource, and thus, you cannot fetch from it You probably need to call on the user table with the database prefix you used when installing, I believe it is 'ibf_' by default.

so it would be ibf_user?


of course i am trying to mod it here... here are the install instruction it tells me to do
Used to be

$member['member_joined'] = $this->html->member_joined( $std->get_date( $member['joined'], 'JOINED' ) );
$member['member_group']  = $this->html->member_group( $ibforums->cache['group_cache'][ $member['mgroup'] ]['g_title'] );
$member['member_posts']  = $this->html->member_posts( $std->do_number_format($member['posts']) );

Replaced With

        $subres = mysql_query("SELECT * FROM users WHERE username='".$member['name']."'") ;
$CURUSER=mysql_fetch_array($subres);


if ($CURUSER["downloaded"])
                {
                  $ratio = $CURUSER["uploaded"] / $CURUSER["downloaded"];
                  if ($ratio < 0.1)
                    $s = "<font color=#ff0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.2)
                    $s = "<font color=#ee0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.3)
                    $s = "<font color=#dd0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.4)
                    $s = "<font color=#cc0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.5)
                    $s = "<font color=#bb0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.6)
                    $s = "<font color=#aa0000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.7)
                    $s = "<font color=#990000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.8)
                    $s = "<font color=#880000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 0.9)
                    $s = "<font color=#770000>" . number_format($ratio, 2) . "</font>";
                  else if ($ratio < 1)
                    $s = "<font color=#660000>" . number_format($ratio, 2) . "</font>";
                  else
                    $s =  number_format($ratio, 2) ;
                }
                else
                  if ($CURUSER["uploaded"])
                    $s = "Inf.";
                  else
                    $s = "---";

$torrentinfo = "<br>Downloaded:<font color='blue'> ".mksize($CURUSER["downloaded"])."</font><br>Uploaded:<font color='green'> ".mksize($CURUSER["uploaded"])."</font></b><br>Ratio: ".$s."<br>";

		$member['member_joined'] = $this->html->member_joined( $std->get_date( $member['joined'], 'JOINED' ) );
		$member['member_group']  = $this->html->member_group( $ibforums->cache['group_cache'][ $member['mgroup'] ]['g_title'] );
		$member['member_posts']  = $this->html->member_posts( $std->do_number_format($member['posts']) ).$torrentinfo;

I have a small question...What does the "->" do exactly..?

your asking me.... i start the fourm software... this is by ivision power board. the hack is at phpsoft.com under IPB TT or something like that.

i could never write something this complitcated right now..

so your guess would be as good as mine. i am goin to try and get in contact with the writer tomarrow to find out why i am having issues. i might ask some friends at another forum to help me get mine setup. as i am basing some on my current setup off of theirs.

Originally Posted by amw_drizz

so it would be ibf_user?

Yes, I believe so. Go into phpMyAdmin and check if it does not work. Unless you specifically cleared the 'table prefix' field on install, it will be something.

Originally Posted by Zeal

I have a small question...What does the "->" do exactly..?

It is how you must access an objects methods or properties (when an instance is created). For example, you might have a car instance with a $max_speed property, to access it, you would do something like $car->max_speed. Within a class, the special $this reference points to the instance itself. See the manual for more examples.

the mod i am adding is a front end tracker. and i belive that the information is require a connect to the tracker db which is not the same db as the forums. so that may be what is needing to be. as it is only parsing the error after inculding 2 files which length double the scripts legnth.

....... problems..... argh

Add an error message to see specifically what the problem is:

PHP Code:

 $subres = mysql_query("SELECT * FROM users WHERE username='".$member['name']."'");

if(!$subres)
    trigger_error('Error with mySQL query: ' . mysql_error()); 


That way we can get a better idea of what the error actually is.

This is the entire topics file..... the entire THING
<mod edit>

This is 2336 lines of code. PROBLOMATIC AREAS ARE MARKED WITH --->
Lines 767, 775, 793

All have invalid MySQL arrarys. Chroder when i applied your code the error disapered so that fixed it but look through it those are the problomatic lines

You can't show the source file here, IPB is not free software

My code should have given you a mySQL error. IPB might be using some kind of output buffering, try using a 'die' just once to see if you can catch the error

if(!$subres)
    die('Error with mySQL query: ' . mysql_error());

no thats not the source.... that may be part of it. alls that does is shows tells how to displays the topics.

trust me the kernal in the IPB folder is the core. and that is only one file

Will try the die command to see if i can catch the error

I AM SO DUMB

when i installed the tracker i forgot to install it into the same db as the forums. so thats why i got all the errors...