Answer to Question #3637 in Databases | SQL | Oracle | MS Access for Thomas

Question

I've got a table(kills) that contains every individual kill made on my game server (killer, killed_by, timeOfKill, killer_userID etc..)

I want to create a leaderboard from this information, I've had a look through some leaderboard threads/questions and they all seem to be created from already summed values (eg. Each user would already have their kills totaled) and that's fine but my dataset won't be that big for a while so I'm happy to calculate it on the fly.

Also there are records in the kills table that need to be excluded such as kills by environment and such but I believe that can be easily handled with a:

WHERE killed='playerType' AND killed_by NOT IN (<list of environment IDs>)

So basically I need to sum each separate user ID (which I'm not sure how to do) then order,limit and display them (which I'm fine with).

Note: There is no total of kills for each user, each kill is a separate entry in the kills table.

Answer 1

Unfortunately, your question requires a lot of work and cannot be done for free. Submit it with all requirements as an assignment to our control panel and we'll assist you.