Shaiya PHP Ranking script

[catalinbebe]

Hello there, i was wondering if anyone could help me with my pvp ranking script. At the moment my server is running shared kills and my pvp ranking is showing up all characters from account. How can i reduce it to just 1 character?

[killer2p]

make a clause where it reads slot 1, 2 ,3 ,4 etc

[catalinbebe]

Well i've tryed to make it show just slot 0 characters, but there are people that arent showing on ranks because they are using another slot, so i wonder how can i make it really work. I think i need to put like a condition

[killer2p]

if slot is empty check slot b else c else etc

[HellRevenger]

You can show us your query which is showing the players, and we will probably help you

[catalinbebe]

Atm using this one but it just shows slot 0 characters.

//--------------Database Connection-----------------
$conn = @odbc_connect("Driver={SQL Server};Server=$server;", $dbuser, $dbpass) or die("Database Connection Error!");;

$query = "SELECT TOP ".$MaxRank." c.CharName,c.K1,c.K2,c.Job,c.Level,umg.Country
FROM PS_GameData.dbo.Chars c
INNER JOIN PS_UserData.dbo.Users_Master um ON c.useruid=um.useruid
INNER JOIN PS_GameData.dbo.UserMaxGrow umg ON umg.UserUID=c.UserUID
WHERE um.status=0 AND c.Del=0 AND c.Slot=0 AND c.K1 > 1 ORDER BY c.k1 DESC";
$result = odbc_exec($conn, $query);

[AxelMac]

Originally Posted by catalinbebe

Atm using this one but it just shows slot 0 characters.

try this query

 Spoiler

"SELECT top $max [c].* FROM [PS_GameData].[dbo].[Chars] AS [c]
INNER JOIN [PS_UserData].[dbo].[Users_Master] AS [u] ON [u].[UserUID] = [c].[UserUID]
WHERE [c].[Del] = 0 AND [u].[Status] = 0 AND [c].[Slot] =
(SELECT min (c.[Slot])
FROM [PS_GameData].[dbo].[Chars] AS [c]
INNER JOIN [PS_UserData].[dbo].[Users_Master] AS [u] ON [u].[UserUID] = [c].[UserUID]
WHERE c.[Del] <> 1) $where
ORDER BY [c].[K1] DESC, [c].[K2] ASC, [c].[CharName] ASC";

after change your value.