In commbull.php
Search for SUBSTRING(birthday,6)
The string there probably reads...
$DB_Site->query("SELECT userid,username,birthday FROM user WHERE SUBSTRING(birthday,6)>='11-29' AND SUBSTRING(birthday,6)<='12-13' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10");
It should be
$DB_Site->query("SELECT userid,username,birthday FROM user WHERE ".SUBSTRING(birthday,6).">='11-29' AND ".SUBSTRING(birthday,6)."<='12-13' ORDER BY ".SUBSTRING(birthday,6)." LIMIT 0,10");
Mind you, I've never seen this script, but that's what appears to be the problem and solution to me.
|