Help on Making Daily Rank

[ebash43]

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 |

[oldjayy]

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.

[SnickQ]

select count(*) from actionlog where ActionType='103' and ActionTime >= DATEADD(day, -1, GETDATE()) and CharID=@CharID

[ebash43]

Originally Posted by SnickQ

select count(*) from actionlog where ActionType='103' and ActionTime >= DATEADD(day, -1, GETDATE()) and CharID=@CharID

i dont get it the current code goes like this


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.