can some give me idea how to make daily rank records (php)
ex.
Name | Rank | Kills | Kills for Today|
User1 | 1 | 432 | +3 |
User1 | 1 | 243 | +64 |
ex.
Name | Rank | Kills | Kills for Today|
User1 | 1 | 432 | +3 |
User1 | 1 | 243 | +64 |
Help on Making Daily Rank
08/23/2017 22:42
ebash43#1
08/25/2017 11:34
oldjayy#2
Making a table in SQL and inserting the kills there daily would help, you will need a trigger to insert there from actionlog tho. You can make it to delete all the data inside the table every 12/24 hours. Good luck.
08/25/2017 16:55
SnickQ#3
select count(*) from actionlog where ActionType='103' and ActionTime >= DATEADD(day, -1, GETDATE()) and CharID=@CharID
08/26/2017 07:47
ebash43#4
i dont get it the current code goes like thisQuote:
select count(*) from actionlog where ActionType='103' and ActionTime >= DATEADD(day, -1, GETDATE()) and CharID=@CharID
echo '<td class="center">'.$char['CharName'].'</td>'; // Prints user1
echo '<td class="center">'.$i.'</td>'; // prints rank number
echo '<td class="center">'.$char['K1'].'</td>'; // prints current kills
please help and tnx in advance.