[PKRWUD]

Originally Posted by sv1cec

Did you take care of the "TABLE_PREFIX"???

Yes, you should change the code in that other place as well.

Rgds

I'm sorry, but I'm not sure what you mean. In any case, this code gave me that error:

PHP Code:

if ($_GET['act'] == "viewstats2") 
{ 
    $get_warns=$DB_site->query("select wt.userid, wt.username, wt.usergroupid++from 
    ".TABLE_PREFIX."user wt WHERE (usergroupid=5 OR usergroupid=6 OR usergroupid=7) ORDER BY userid"); 


While this code worked:

PHP Code:

if ($_GET['act'] == "viewstats2") 
{
$get_warns=$DB_site->query("select wt.userid, wt.username, wt.usergroupid  from
".TABLE_PREFIX."user wt WHERE (usergroupid=5 OR usergroupid=6 OR usergroupid=7) ORDER BY userid"); 


Like I said, it doesn't really matter because it works now. I was just curious why one worked and the other caused an error, when both look pretty much the same, to me anyway.

I figured out the second part, too.

I went through all the files in the download package, and all the template edits, and the only other place I found that needed to be changed was the MEMBERINFO template, so I changed it. To the best of my knowledge, everything is working great.