FULL TopPos with overtaking
zom.gsc CallbackKilled:
if(attacker.position>1)
attacker thread scripts\top::kilstat();
PHP Code:
init() {
precacheString( & "^4Т^7воя ^4н^7овая ^4п^7озиция^2:^2");
precacheString( & "^4Y^7our ^4n^7ew ^4p^7osition^2:^2");
}
onPlayerConnecting() //read all stats when a player connected
{
self.killplayers = self.stats["killszom"];
if (self.killplayers == 0) {
sql = "SELECT killszom FROM `Accounts`";
mysql_query(level.mysql, sql);
result = mysql_store_result(level.mysql);
self.position = mysql_num_rows(result); //how many positions
self scripts\ _mysql::mysql_write();
} else {
self.position = self.stats["toppos"];
}
}
kilstat() //when a zombie killing
{
self.position = self.stats["toppos"];
statik1 = int(self.position - 1);
sql = "SELECT killszom, login FROM `Accounts` WHERE `toppos`='" + statik1 + "'"; //position to know where to make a request to find out how many kills the player below us
mysql_query(level.mysql, sql);
result = mysql_store_result(level.mysql);
row = mysql_fetch_row(result);
ab = int(row[0]); //kills below us Player
ba = row[1]; //login below us Player
if (self.killplayers > ab) //if the player's previous kills more kills in the top, then go ahead
{
statik2 = int(self.position);
sql = "UPDATE `Accounts` SET " +
"toppos='" + statik2 + "' " +
"WHERE login='" + ba + "'"; //up, who have overtaken, we give him our position
mysql_query(level.mysql, sql);
player = self;
players = getEntArray("player", "classname");
for (x = 0; x < players.size; x++) {
if (players[x].pers["loginname"] == ba) //if the one overtaken - online? - Write it in a variable position, and say that it surpassed
{
players[x].position = self.position;
players[x] iprintlnbold("Have overtaken ", self.name);
}
}
self.position--; //give yourself a position on one line below
sql = "UPDATE `Accounts` SET " +
"toppos='" + self.position + "' " +
"WHERE login='" + self.stats["loginname"] + "'";
mysql_query(level.mysql, sql);
mysql_free_result(result);
///
player = self;
players = getEntArray("player", "classname");
for (i = 0; i < players.size; i++) {
if (players[i].pers["language"] == "1")
players[i] iprintln(self.name + " ^4н^7овая ^4п^7озиция^2:^7" + self.position);
else if (players[i].pers["language"] == "0")
players[i] iprintln(self.name + " ^4n^7ew ^4p^7osition^2:^7" + self.position);
}
if (self.pers["language"] == "1")
self iprintlnbold("^4Т^7воя ^4н^7овая ^4п^7озиция^2:^2" + self.position);
else if (self.pers["language"] == "0")
self iprintlnbold("^4Y^7our ^4n^7ew ^4p^7osition^2:^2" + self.position);
}
}
BUT during the game at some moment straying column toppos. ONLY toppos! WHY!? pls Help
For example, who was in the first position is reset to the last.