FULL TopPos with overtaking

[Paho]

zom.gsc CallbackKilled:
if(attacker.position>1)
attacker thread scripts\top::kilstat();

		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.

[Paho]

pls help

[IzNoGoD]

I have no idea what you're trying to accomplish.

[maxdamage99]

TOP PLAYERS, PLAYERS SORT BY KILLS, UNDERSTAND?
EXAMPLE:

TOP POS:  NAME PLAYER:     KILLS(PTS):
==1==     ^1Freddy           312511
==2==     Unknown Soldier    286388
==3==     Played.nL.28       175262

[IzNoGoD]

		SELECT name, kills FROM tablename_here ORDER BY kills DESC LIMIT 10 
	

I'm pretty sure this is NOT exactly what you want, but this follows your request. So please clarify your request.

[maxdamage99]

your query make TOP10, we want TOP(ALLPLAYERS)

[IzNoGoD]

then change the 10 to whatever number you want.

If that does not answer your question, ask it again, provide some paint image, tell the same thing 3x in different wording. Try to get your question past the language barrier.

I'm fine with doing some MySQL query writing for you, if you provide information about your database and can actually make your question clear.

[Paho]

need to display each player's position, number of kills to the next position, if the player has overtaken - changing position + iprint new pos.
looking at the script does not understand?
working script with file operations:

		init()
{
precacheString(&"^4“^7во¤ ^4н^7ова¤ ^4п^7озици¤^2:^2");
precacheString(&"^4Y^7our ^4n^7ew ^4p^7osition^2:^2");
}
onPlayerConnecting()
{
p=self;
f=openfile("yourlogin/"+p.pers["loginname"]+".txt","read");
if(f==-1)
p.killplayers=0;
else
{
freadln(f);
p.killplayers = int(fgetarg(f,0));
closefile(f);
}
f=openfile("killstatlogin/"+p.pers["loginname"]+".txt","read");
if(f==-1)
{
f=openfile("lastpos1/"+"statistik1"+".txt","read");
freadln(f);
p.lastpos = int(fgetarg(f,0));
closefile(f);
p.lastpos++;
p.position = p.lastpos;
f=openfile("lastpos1/"+"statistik1"+".txt", "write");
fprintln(f, p.lastpos);
closefile(f);
f=openfile("killstatlogin/"+p.pers["loginname"]+".txt", "write");
fprintln(f, p.position);
closefile(f);
f=openfile("yourpos1/"+p.position+".txt", "write");
fprintln(f, p.pers["loginname"]);
closefile(f);
}
else
{
freadln(f);
p.position = int(fgetarg(f,0));
closefile(f);
}
f=openfile("yourlogin/"+p.pers["loginname"]+".txt","write");
fprintln(f, p.killplayers);
fprintln(f, p.name);
closefile(f);
}
kilstat()
{
player=self;
f=openfile("killstatlogin/"+self.pers["loginname"]+".txt","read");
freadln(f);
self.position = int(fgetarg(f,0));
closefile(f);
f=openfile("yourlogin/"+self.pers["loginname"]+".txt","write");
fprintln(f, self.killplayers);
fprintln(f, self.name);
closefile(f);
if(self.position > 1 )
{
self.playetop = self.position;
self.playetop--;
f=openfile("yourpos1/"+self.playetop+".txt","read");
freadln(f);
self.playerguid = fgetarg(f,0);
closefile(f);
f=openfile("yourlogin/"+self.playerguid+".txt","read");
freadln(f);
self.playerfrags = int(fgetarg(f,0));
closefile(f);
if(self.killplayers>self.playerfrags)
{
f=openfile("yourpos1/"+self.playetop+".txt", "write");
fprintln(f, self.pers["loginname"]);
closefile(f);
f=openfile("yourpos1/"+self.position+".txt", "write");
fprintln(f, self.playerguid);
closefile(f);
f=openfile("killstatlogin/"+self.playerguid+".txt", "write");
fprintln(f, self.position);
closefile(f);
f=openfile("killstatlogin/"+self.pers["loginname"]+".txt", "write");
fprintln(f, self.playetop);
closefile(f);
self.position = self.playetop;
players = getEntArray("player", "classname");
for(x = 0; x < players.size; x++)
{
if(players[x].pers["loginname"]==self.playerguid)
{
players[x].position = (self.playetop+1);
}
}
fuck=0;
self.posintop destroy();
self.posintop = newClientHudElem(self);
self.posintop.alignX = "center";
self.posintop.alignY = "middle";
self.posintop.x = 320;
self.posintop.y = 150;
self.posintop.fontscale = 1;
self.posintop.alpha = 0.25;
if(self.pers["language"]=="1")
self.posintop.label = &"^4“^7во¤ ^4н^7ова¤ ^4п^7озици¤^2:^2";
else
self.posintop.label = &"^4Y^7our ^4n^7ew ^4p^7osition^2:^2";
self.posintop setValue(self.position);
for(i = 0; i < 10; i++)
{
self.posintop.fontscale = 1+fuck;
self.posintop.alpha = 0.5+fuck;
self.posintop setValue(self.position);
fuck+=0.15;
wait 0.05;
}
wait 1;
fuck=0;
for(i = 0; i < 10; i++)
{
self.posintop.alpha = 0.5-fuck;
self.posintop setValue(self.position);
fuck+=0.15;
wait 0.1;
}
self.posintop destroy();
self endon("gandon");//предотвращаем написание текстовки более одного раза, например при взрыве с C4
wait 0.05;//все вайты вход¤т в промежуток endon - notify
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);
}
self notify("gandon");
}
}
} 
	

[maxdamage99]

Omfg, man you think SERVER NO CRASH by query:

		SELECT name, kills FROM tablename_here ORDER BY kills DESC LIMIT 6000 
	

per every 2-3 seconds

[IzNoGoD]

What do you need the top 6000 for.

EXPLAIN YOUR DAMN QUESTION.