thanks, i will test this.
I will try, At the moment my sketch:
PHP Code:
sql = "SELECT COUNT(killszom) FROM Accounts WHERE login != '" + self.stats["loginname"] + "' AND killszom >= '" + self.lastkillplayers + "' AND killszom < '" + self.killplayers + "'";
mysql_query(level.mysql, sql);
result = mysql_store_result(level.mysql);
row = mysql_fetch_row(result);
countstrings = int(row[0]);//number of players in the interval killings
if(countstrings>=1)//continue to execute queries if there are ahead
{
sql = "SELECT `login` FROM Accounts WHERE `login` != '" + self.stats["loginname"] + "' AND killszom >= '" + self.lastkillplayers + "' AND killszom < '" + self.killplayers + "'";//this query displays logins players below us in a position, then you can give one to each array, thereby relegating them
mysql_query(level.mysql, sql);
result = mysql_store_result(level.mysql);
row = mysql_fetch_row(result);
list=[];
for(i=0;i<countstrings;i++)
{
list[i]=row[0];
sql = "UPDATE `Accounts` SET toppos=toppos+1 WHERE login='" + list[i] + "'";
mysql_query(level.mysql, sql);
}
sql = "SELECT MAX(toppos) FROM Accounts WHERE `login` != '" + self.stats["loginname"] + "' AND killszom = '" + self.lastkillplayers + "'";
mysql_query(level.mysql, sql);
result = mysql_store_result(level.mysql);
row = mysql_fetch_row(result);
max=row[0];
sql = "SELECT MIN(toppos) FROM Accounts WHERE `login` != '" + self.stats["loginname"] + "' AND killszom = '" + self.lastkillplayers + "'";
mysql_query(level.mysql, sql);
result = mysql_store_result(level.mysql);
row = mysql_fetch_row(result);
min=row[0];
sql = "UPDATE `Accounts` SET toppos=toppos-'"+(max-min+1)+"' WHERE login='" + self.stats["loginname"] + "'";
mysql_query(level.mysql, sql);
}