a bit of code in need of fixing

part of a hack im making:

PHP Code:

 //Drakks Warning Hack
$warnifield="field10" //make x the field for ur warning level
$warnlevel = $DB_site->query_first("SELECT $warnifield FROM userfield WHERE $userid=$bbuserinfo");
        if ($warnlevel >= "10") {
                $warnphraze="NEEDS BANNING";    //u may set the warn phraze for each one
        } elseif ($warnlevel >= "7") {
                $warnphraze="Very Bad";
        } elseif ($warnlevel >= "4") {
                $warnphraze="Thats Rough";
        } elseif ($warnlevel >= "1") {
                $warnphraze="Evil's Apprentice";
        } else {
                $warnphraze= "Goody Goody";
        }
        if ($warnfield >= "10") {
                $warning='<img src="{imagefolder}/warn1.jpg"> $warnphraze';
        } elseif ($warnlevel >= "7") {
                $warning='<img src="{imagefolder}/warn2.jpg"> $warnphraze';
        } elseif ($warnlevel >= "4") {
                $warning='<img src="{imagefolder}/warn3.gif"> $warnphraze';
        } elseif ($warnlevel >= "1") {
                $warning='<img src="{imagefolder}/warn4.gif"> $warnphraze';
        } else {
                $warning='<img src="{imagefolder}/warn5.gif"> $warnphraze';
        }
//End Warning hack 


Theres also an error with the query,,, but... how can i get $warning too =<img src="{imagefolder}/warn5.gif"> and so on?

i know that Wont work.. how can i change it too make it work

[E]

^^

[Logician]

if your code gives an error in a line like
echo "warnfield=$warnfield <br>";

then you better check your { and }s

This line is a simple PHP code which cant produce any errors, so it is obvious that your problem is something else. Generally wrong use of {}s produce such "awkward" errors and unfortunately they're the hardest ones to trace

[E]

ok.. ill have a look thru my code now thx

[E]

Lol.. .i dont know how... but all of a sudden my code works...
damn thats amazing.. i just hope the rest of the hack works

[E]

aww....****... i found the problem.. i was looking at the wrong sessions.php file (not the one on my site)

Error=
Parse error: parse error in /home/fiendwor/public_html/forum/admin/functions.php on line 214

Fatal error: Call to undefined function: getuserinfo() in /home/fiendwor/public_html/forum/admin/sessions.php on line 323

Here is line 214 on functions.php:

PHP Code:

warnlevel = $DB_site->query_first("SELECT $warnifield FROM userfield WHERE $userid=$bbuserinfo"); 


^^and ive tried evrything for that line.....

Here is line 323 on sessions.php:

PHP Code:

$bbuserinfo=getuserinfo($session['userid']); 


U mightve guessed the problem came backk

[Logician]

parse error is because you missed the $ in the beginning of warnlevel

As for getuserinfo function error well it seems obvious that script cant find your function "getuserinfo". Are you sure it's defined and if it's in another script is it included properly?

[E]

OK what line would work.... if i want too select field10 from the userfield where the userid is equal to the person it displays for

[E]

^^^word

[E]

appreciate any help

[Logician]

Originally posted by E

PHP Code:

warnlevel = $DB_site->query_first("SELECT $warnifield FROM userfield WHERE $userid=$bbuserinfo"); 


^^and ive tried evrything for that line.....

This query does what you asked:

SELECT field10 FROM userfield WHERE userid=8

so this should work:

$warnifield='field10';
$variable1223=$bbuserinfo['userid'];
$warnlevel = $DB_site->query_first("SELECT $warnifield FROM userfield WHERE userid='$variable1223');