Quote:
|
Originally Posted by VooDoo427
i just installed your visitors block but now i get the error about line 286 of sql_layer.php :? does anyone know how to fix this? below is a picture of the error...
 |
Hi again,
I think I have found where the problem is:
In fact you have two lines Hard Coded in block-Site_Visitors (prefix)
Line 120 and 126
Quote:
// Executing SQL Today
$sql2 = "SELECT COUNT(user_id) AS userCount from nuke_users WHERE user_regdate LIKE '$curDate2'";
$result2 = sql_query( $sql2, $dbi );
list( $userCount ) = sql_fetch_row( $result2, $dbi );
// end
// Executing SQL Yesterday
$sql3 = "SELECT COUNT(user_id) AS userCount from nuke_users WHERE user_regdate LIKE '$curDateP'";
$result3 = sql_query( $sql3, $dbi );
list( $userCount2 ) = sql_fetch_row( $result3, $dbi );
|
For those who have same problem it means that you are using prefix different from nuke_
You have to change nuke_users to $prefix"._users."
Quote:
// Executing SQL Today
$sql2 = "SELECT COUNT(user_id) AS userCount from $prefix"._users." WHERE user_regdate LIKE '$curDate2'";
$result2 = sql_query( $sql2, $dbi );
list( $userCount ) = sql_fetch_row( $result2, $dbi );
// end
// Executing SQL Yesterday
$sql3 = "SELECT COUNT(user_id) AS userCount from $prefix"._users." WHERE user_regdate LIKE '$curDateP'";
$result3 = sql_query( $sql3, $dbi );
list( $userCount2 ) = sql_fetch_row( $result3, $dbi );
|
Keep going
dc