Check online time

Hello

here have way to check how many time online each-each player? I want make ranking with online time.

i wrote a "Write-Through-Hook" to write Data from MainServer direct into the SQL Server. Id make a Thread with an incremental SQL Statment. Here a snippet:

PHP Code:

---

while (1){
.
.
.
Sleep(60000);
h<<"UPDATE Player SET Online = (CASE WHEN PID = 545";
        for (int i = 0; i<playerObjectIDList.Size(); i++) {
            IPlayer* tempplayer = damn->QueryPlayer(playerObjectIDList.GetNthUID(i));    
                        int PID = tempplayer->GetPID();
    h<<" OR PID = "<<PID;
}
h<<" THEN 1 ELSE 0 END), Min = (CASE WHEN Online = 1 THEN Min + 1 ELSE Min END)";
} 


---

So this Thread sleeps 1 Min then looks wich Players are online in this loop and builds up an SQL Statement, that increases an Integer called Min, wich i added into Playertable. If the Player is online the Statement counts up his Min Number and you know how many Minutes a Player was Online on your Server.

Quote:

---

Originally Posted by MadKnight

i wrote a "Write-Through-Hook" to write Data from MainServer direct into the SQL Server. Id make a Thread with an incremental SQL Statment. Here a snippet:

PHP Code:

---

while (1){
.
.
.
Sleep(60000);
h<<"UPDATE Player SET Online = (CASE WHEN PID = 545";
        for (int i = 0; i<playerObjectIDList.Size(); i++) {
            IPlayer* tempplayer = damn->QueryPlayer(playerObjectIDList.GetNthUID(i));    
                        int PID = tempplayer->GetPID();
    h<<" OR PID = "<<PID;
}
h<<" THEN 1 ELSE 0 END), Min = (CASE WHEN Online = 1 THEN Min + 1 ELSE Min END)";
} 


---

So this Thread sleeps 1 Min then looks wich Players are online in this loop and builds up an SQL Statement, that increases an Integer called Min, wich i added into Playertable. If the Player is online the Statement counts up his Min Number and you know how many Minutes a Player was Online on your Server.

---

Nice one! Good idea!
Wouldnt it be possible to get an approximate online time via the Log table?

Uppa i dont think so, because i dont see there a Value from wich i could get the Onlinetime of a Player, sure there are other ways to make a min counter for players but i have no idea how to solve it simple ^^

Quote:

---

Originally Posted by MadKnight

Uppa i dont think so, because i dont see there a Value from wich i could get the Onlinetime of a Player, sure there are other ways to make a min counter for players but i have no idea how to solve it simple ^^

---

you can make a SP in to login SP that insert a value in a table and a SP in logout that set other value after logout

Quote:

---

Originally Posted by MadKnight

i wrote a "Write-Through-Hook" to write Data from MainServer direct into the SQL Server. Id make a Thread with an incremental SQL Statment. Here a snippet:

PHP Code:

---

while (1){
.
.
.
Sleep(60000);
h<<"UPDATE Player SET Online = (CASE WHEN PID = 545";
        for (int i = 0; i<playerObjectIDList.Size(); i++) {
            IPlayer* tempplayer = damn->QueryPlayer(playerObjectIDList.GetNthUID(i));    
                        int PID = tempplayer->GetPID();
    h<<" OR PID = "<<PID;
}
h<<" THEN 1 ELSE 0 END), Min = (CASE WHEN Online = 1 THEN Min + 1 ELSE Min END)";
} 


---

So this Thread sleeps 1 Min then looks wich Players are online in this loop and builds up an SQL Statement, that increases an Integer called Min, wich i added into Playertable. If the Player is online the Statement counts up his Min Number and you know how many Minutes a Player was Online on your Server.

---

Thanks. But where i need insert this? :D xD

Quote:

---

Originally Posted by DELUXX

you can make a SP in to login SP that insert a value in a table and a SP in logout that set other value after logout

---

you can just put a SP anywhere? :D
how would i insert a SP while logging out?