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

[TECK]

did you tried:

PHP Code:

$warning='<img src="{imagefolder}/warn1.jpg"> $warnphraze' 


?

[E]

hmm...

[E]

theres still the error with this line :

PHP Code:

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


i also tried changing it too:

PHP Code:

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


[Logician]

insert:
echo "warnfield=$warnfield <br>";
echo "bbuserinfo=$bbuserinfo<br>";
before
$warnlevel = $DB_site->query_first("SELECT $warnfield FROM userfield WHERE userid='$bbuserinfo'");

and see what your variables have before entering the query.

BTW isnt it the variable "$bbuserinfo[userid]" you should use in your query if I got what you're trying to do right?

if yes try this:
$new_var_323= $bbuserinfo[userid];
$warnlevel = $DB_site->query_first("SELECT $warnfield FROM userfield WHERE userid='$new_var_323'");

Hope this helps..

Regards,
Logician

[E]

it seems no matter what i do i get this error:

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

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

[E]

it doesnt like this code:
echo "warnfield=$warnfield <br>";

if thats not there it doesnt like this code:
$new_var_323= $bbuserinfo[userid];

if thats not there it doesnt like the query

[Logician]

what editor program do you use? Cant you see which line produced the error? I strongly suggest you using an editor that can show you line numbers and then you can easily point which line is causing you trouble. It would be a real headache to trace and fix the problem without even knowing which line causes the problem!

[E]

PHP Code:

//Drakks Warning Hack
$warnfield="field10" //make x the field for ur warning level
echo "warnfield=$warnfield <br>";
echo "bbuserinfo=$bbuserinfo<br>";

$warnlevel = $DB_site->query_first("SELECT $warnfield FROM userfield WHERE userid='$new_var_323'");
$warnlevel=$warnlevel[$warnfield]; 


in that case this is the line:

PHP Code:

echo "warnfield=$warnfield <br>"; 


if u get rid of that and the bit after it and this is in there this is the line:

PHP Code:

$new_var_323= $bbuserinfo[userid]; 


but.. if that aint there this is the line:

PHP Code:

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


and so on

[E]

o and the first line of this bit of code is the reference too the sessions.php

PHP Code:

  // get pertinient user info
  if (!isset($bbuserinfo) or $bbuserinfo['userid']!=$session['userid']) {
    $bbuserinfo=getuserinfo($session['userid']);
    $bbuserinfo['realstyleid'] = $bbuserinfo['styleid'];
  }