GunZ Rankings Page

[shadow-xx]

!CLOSED ready for release..

The page looks like this.. 
(i know the screens are a bit blurry blame tinypic.. imageshack doesn't work here for some reason)

[IMG]https://forum.ragezone.com/images/404_image.png[/IMG]

[IMG]https://forum.ragezone.com/images/404_image.png[/IMG]

[IMG]https://forum.ragezone.com/images/404_image.png[/IMG]

Config file is inside the /includes/ folder

[B]Update - 7[/B]
- Fixed some error that caused names to show up wrong
[B]Update - 6[/B]
- Added userlegend (+ options for place and alignment) (idea from wesman2232)
[B]Update - 5[/B]
- Fixed some stupid mistake i made
- Updated comments in config.php
[B]Update - 4[/B]
- Updated Query's
- Added Name coloring (on request by wesman2232)
- Added setting to order by other fields (Mocro needed that)
[B]Update - 3[/B]
- Updated query
[B]Update - 2[/B]
- Fixed ratio
- Cleaned code a bit
- Changed mssql_functions.php
[B]Update - 1[/B]
- Fixed Query

 

[eele]

Looks nice,
i get this error.

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., SQL state 21000 in SQLExecDirect in C:\wamp\www\nlgunz\include\includes\odbc_functions.php on line 34

Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\wamp\www\nlgunz\include\includes\odbc_functions.php on line 38

 

[hiii]

Ill test it

 

[shadow-xx]

Updated the file with a new query (works here but i dont have a filled db)

Note : i know the code is a mess with all the $new and $tab..
will clean the code later

 

[wesman2232]

I'll test the updated one

 

[eele]

Worked good now! Oh yah, the mssql connection string is wrong look @ it.

 

[shadow-xx]

can u please post the error u got from that?

 

[Solaire]

Replace

mssql_select_db($dbname,$dbc);

With

mssql_select_db($dbname);

Also, mssql_query does NOT need the connection function. You can use MSSQL the same way as MySQL, by using mssql_query("UPDATE xxx");. Same for the mssql_fetch_array.

 

[wesman2232]

Warning: Division by zero in C:\AppServ\www\GunZ\rank\includes\general_functions.php on line 34

Now just to make this for Clans

 

[alfredao]

Thanks!

 

[shadow-xx]

Warning: Division by zero in C:\AppServ\www\GunZ\rank\includes\general_functions.php on line 34

Now just to make this for Clans

Will fix some stuff later today got to go to school first

might make one for clans some other time


Edit
Updated first post with new rar
Edit
And again...

 

[lol1992]

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC-stuurprogrammabeheer] De naam van de gegevensbron is niet gevonden en er is geen standaardstuurprogramma opgegeven, SQL state IM002 in SQLConnect in C:\AppServ\www\rank\includes\odbc_functions.php on line 31

Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\AppServ\www\rank\includes\odbc_functions.php on line 34

Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\AppServ\www\rank\includes\odbc_functions.php on line 38

That was the ODBC error
&
This is the Mysql Error

Fatal error: Call to undefined function mssql_connect() in C:\AppServ\www\rank\includes\mssql_functions.php on line 31

 

[shadow-xx]

Eele tested it on his server here are the results..
it has some strange blank names outputed tried to fix it
by adding a check for a null in a name field but that
doesent work...

if anyone knows why gunz has those rows with blank
usernames post the problem here so i will be able to
fix it..

oh and can someone please test the mssql connection

 

[Solaire]

SELECT xxxxxxxxxxxxx FROM Character WHERE Name != ''

 

[nanowarior]

Nice death points

 

[wesman2232]

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'., SQL state 37000 in SQLExecDirect in C:\AppServ\www\GunZ\rank\includes\odbc_functions.php on line 34

Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\AppServ\www\GunZ\rank\includes\odbc_functions.php on line 38

EDIT : Nvm I fixed this, it was cause I deleted everything between the "s on the excluded characters line.
Hey can you make it so that the Admin's names are Green and the Dev's names are red?

 

[Solaire]

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'., SQL state 37000 in SQLExecDirect in C:\AppServ\www\GunZ\rank\includes\odbc_functions.php on line 34

Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\AppServ\www\GunZ\rank\includes\odbc_functions.php on line 38

EDIT : Nvm I fixed this, it was cause I deleted everything between the "s on the excluded characters line.
Hey can you make it so that the Admin's names are Green and the Dev's names are red?

Join the AID on the Account table, get the UGradeID with it.

Then if (ugradeid == 254) $color = "red"; else $color="black"; <font color='$color'>Charname</font>

Above code can not be used but it's a good clue.

 

[shadow-xx]

Account And character table are put together in 1 query already

I will work some more on this page later bussy on some other stuff atm

Hey can you make it so that the Admin's names are Green and the Dev's names are red?

Sure when im working on the page again i will add it

 

[wesman2232]

Join the AID on the Account table, get the UGradeID with it.

Then if (ugradeid == 254) $color = "red"; else $color="black"; <font color='$color'>Charname</font>

Above code can not be used but it's a good clue.

thanks, I got it

 

[dacharles]

SELECT xxxxxxxxxxxxx FROM Character WHERE Name != ''

would b better

SELECT*FROM Character WHERE DeleteFlag=0???