top killer not working.

[Groovy]

Hy bois.

Code Select Expand

function TopKillers()
{ 
local
query = "SELECT Name, Mato FROM Accounts ORDER BY Name DESC LIMIT 5", //Top 5
q,
Name1, Name2, Name3, Name4, Name5,
Top1, Top2, Top3, Top4, Top5, i = 1; 
q = QuerySQL( db, query );
while( GetSQLColumnData( q, 0 ) )
{
switch(i)
{
case 1:
Name1 = GetSQLColumnData( q, 0 );
Top1 = GetSQLColumnData( q, 1 );
break;
case 2:
Name2 = GetSQLColumnData( q, 0 );
Top2 = GetSQLColumnData( q, 1 );
break;
case 3:
Name3 = GetSQLColumnData( q, 0 );
Top3 = GetSQLColumnData( q, 1 );
break; 
case 4:
Name4 = GetSQLColumnData( q, 0 );
Top4 = GetSQLColumnData( q, 1 );
break;
case 5:
Name5 = GetSQLColumnData( q, 0 ); 
Top5 = GetSQLColumnData( q, 1 );
break; 
}
GetSQLNextRow( q );
i++;
}
FreeSQLQuery(q);
Message("[#00ffff]Top 5 Matadores | Killers[#000000]: [#00bfff]" + Name1 + " [#ffffff]: [#00ff00]" + Top1 + ", [#00bfff]" + Name2 + " [#ffffff]: [#00ff00]" + Top2 + ", [#00bfff]" + Name3 + " [#ffffff]: [#00ff00]" + Top3 + ", [#00bfff]" + Name4 + " [#ffffff]: [#00ff00]" + Top4 + ", [#00bfff]" + Name5 + " [#ffffff]: [#00ff00]" + Top5 + "");
}
else if (cmd =="topkiller")
{
TopKiller();
}

this ain't working. please help bois

[habi]

what error you get in console?

else if (cmd =="topkiller")
{
TopKiller();
}

or is that you forgot s in 'TopKillers()'

[Groovy]

i did still not working bruh.



182th Line:

Code Select Expand

q = QuerySQL( db, query );
28th Line:

Code Select Expand

TopKillers();

[umar4911]

and what is the error being displayed?

[habi]

see q is null.
I think I the  sqlite module failed to load, since there seems no error in query.

 Is there any error in the beginning when u start the server

[Groovy]

and what is the error being displayed?

there is no error when i open the console.

[habi]

ok Groovy. do you think this is correct?

query = "SELECT Name, Mato FROM Accounts ORDER BY Name DESC LIMIT 5",

It must be the other one here. ie. your 'Mato'

[Groovy]

@habi thanks for finding out the bug.

but one problem that when i write /topkiller it shows players with low kills not high killers...

[habi]

can u post onPlayerKill code? I think player and killer got twisted.
it should be
onPlayerKiller( killer, player, reason, body part)
so that killer killed theplayer.

[Groovy]

Solved - The problem was in code. my friend fixed it.lock topic

habi brother thanks for your help.