Warning : Mssql

[Lunatic]

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'TANTRARESET'. (severity 16) in C:\xampp\neo\sections\ranking\ranking.php on line 174Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\neo\sections\ranking\ranking.php on line 174Inicia sesión para conocer que puesto ocupas en el Ranking.Warning: mssql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\neo\sections\ranking\ranking.php on line 236Please help me to fix this one

 

[metan0ia]

it needs its database bro

 

[John]

Table TantraResets not exists in your database. Check the line 174 in your /sections/ranking/ranking.php file.

 

[Lunatic]

Can you check the ranking.php Sir ?

 

[John]

Can you check the ranking.php Sir ?

You need the table TantraResets to work correctly, i deleted that part of the code where consult that table


Line 179 of the file
before:

$query = mssql_query("SELECT TOP 9999 A.UserID, a.CharacterName, a.CharacterLevel, TotalMoney, BrahmanPoint, ISNULL(Events,0) Events, ISNULL(ResetNumber,0) ResetNumber FROM TantraBackup00 A LEFT JOIN (SELECT MAX(ResetNumber) ResetNumber, UserID from TANTRARESET group by UserID) B ON A.USERID COLLATE DATABASE_DEFAULT = B.USERID COLLATE DATABASE_DEFAULT WHERE A.CharacterName != '' AND A.UserID != '$GM1' AND A.UserID != '$GM2' AND A.UserID != '$GM3' AND A.UserID != '$GM4' AND A.UserID != '$GM5' AND A.UserID != '$GM6' AND A.CharacterName != '$MateoChar' $dios $tribe AND idx >= 0 ORDER BY [$order] DESC");

after:

$query = mssql_query("SELECT TOP 9999 UserID, CharacterName, CharacterLevel, TotalMoney, BrahmanPoint FROM TantraBackup00 WHERE CharacterName != '' AND UserID != '$GM1' AND UserID != '$GM2' AND UserID != '$GM3' AND UserID != '$GM4' AND UserID != '$GM5' AND UserID != '$GM6' AND CharacterName != '$MateoChar' $dios $tribe AND idx >= 0 ORDER BY [$order] DESC");

test