[Logician]

Why is this step needed?

-----------------------------------------------------------------
3. Find in showthread.php (around line 58):
-----------------------------------------------------------------

LEFT JOIN user ON user.userid=post.userid

REPLACE with:

LEFT JOIN user ON user.userid=post.userid,ratetradetotal

-----------------------------------------------------------------
//END showthread.php
-----------------------------------------------------------------

As far as I can see "ratetradetotal" field is part of user table (ALTER TABLE user ADD ratetradetotal SMALLINT(5) DEFAULT '0' NOT NULL and all user table fields are already received in the query in part:

PHP Code:

 user.* 


So you don't need to change this query to get "ratetradetotal" field's value.

Besides this syntax is wrong and it produces database errors if "showpost" action is called in showthread.php like: http://www.........com/forums/showth...t&postid=64275

If I'm not missing something, removing this section from the hack does not bother anything and also fixes database errors.

Just FYI.