showthread php question

[gengar003]

So, i've got my showthread.php file right?


Now, you'd think if i put something at the top of the page, it would execute upon loading of the page, right? well it doesn't... This is probably because of some inadequacy of mine, but I don't get what, so there you are. Anyway, I've got a simple code to check the user's Points (from lesane store hack) and I know it does indeed pull them from the DB and assign it to a variable, because is can make the points print @ the top of the page. I have this set to work ONLY in forum id #51.


However, when I try to put that into an "If" statement, and show the points ONLY if they've less than 1000, it ONLY works when, on the forum main page, I click the "goto newest" arrow thing by the time and poster....


Anywhere else, it does nothing. Any Ideas why?

PHP Code:


require('./global.php');
$userstuff = $DB_site->query_first("SELECT storep FROM user WHERE userid=$bbuserinfo[userid]");
$points=$userstuff[storep];
if ($points < 1000 && $forumid == 51){
echo $points;
} 


[mr e]

have you tried adding an else?

[gengar003]

Hmm... Yes, actually, but I had the "else" containing the rest of the file. Would that have caused a problem?

[mr e]

and right now your file looks like this?

PHP Code:

require('./global.php');
$userstuff = $DB_site->query_first("SELECT storep FROM user WHERE userid=$bbuserinfo[userid]");
$points=$userstuff[storep];
if ($points < 1000 && $forumid == 51){
echo $points;
}

rest of file 


[noppid]

The reason it fails is you are requiring global.php, then later in the file it tries to include it again and the page fails. Try moving your code below the forms actual call to require(global.php).

At least that's what bit us once.

[gengar003]

Yesterday at 07:14 PM mr e said this in Post #4
and right now your file looks like this?

PHP Code:

require('./global.php');
$userstuff = $DB_site->query_first("SELECT storep FROM user WHERE userid=$bbuserinfo[userid]");
$points=$userstuff[storep];
if ($points < 1000 && $forumid == 51){
echo $points;
}

rest of file 


yes

[gengar003]

Today at 03:30 PM noppid said this in Post #5
The reason it fails is you are requiring global.php, then later in the file it tries to include it again and the page fails. Try moving your code below the forms actual call to require(global.php).

At least that's what bit us once.

Hm? The page runs, but my code doesn't... and the call to require etc that was originally there is halfway down the page, (roughly) and there's code above it I want to run AFTER the check is preformed... I'll try it, though.

[gengar003]

anyone?

[Boofo]

Try this:

$userstuff = $DB_site->query_first("SELECT storep AS points FROM user WHERE userid=$bbuserinfo[userid]");
if ($userstuff[points] < 1000 && $forumid == 51){
echo $userstuff[points];
}

[Link14716]

05-02-03 at 09:08 PM gengar003 said this in Post #1

PHP Code:


require('./global.php');
$userstuff = $DB_site->query_first("SELECT storep FROM user WHERE userid=$bbuserinfo[userid]");
$points=$userstuff[storep];
if ($points < 1000 && $forumid == 51){
echo $points;
} 


Why do so many people select from the user table for something already in the $bbuserinfo array?

PHP Code:

$points=$bbuserinfo[storep];
if ($points < 1000 && $forumid == 51){
echo $points;
} 


Put that under this:

PHP Code:

$templatesused = 'showthread_ratingdisplay,postbit_search,postbit_buddy,postbit_ignore,postbit_useremail,icq,aim,yahoo,postbit_homepage,postbit_profile,postbit_ip_show,postbit_ip_hidden,postbit,postbit_sendpm,postbit_avatar,postbit_offline,postbit_online,postbit_editedby,postbit_signature,postbit_attachment,postbit_attachmentimage,showthread_adminoptions,showthread_threadrate,showthread_pollresults_voted,showthread_pollresults_closed,showthread_pollresults_cantvote,showthread_firstunread,showthread_nextnewestthread,showthread_nextoldestthread,forumrules,showthread';
require('./global.php');