.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: October 27, 2010    Points: 0   Category :ASP.Net

Hey Guys,

I am making a 8-ball pool ladder for my work, the system is going to be pretty straight forward.
We decided on a ladder based system with a 50% gain in position, so for example if I am rank 5 and I beat the player in rank 1 I move up to 3rd.

The way this is calculated I have already built, you can see this in action here: http://www.digital-inspired.co.uk/ladder/default.aspx

The bit I need help with is the database, consider the layout below:

This is an example of how my user table is going to look, I will then fire a stored procedure to return the list in asc order of the rank, what I am stuck on is updating of a persons rank.

So using the example I mentioned above, I would update my rank to 3rd but then need to update the previous rank 3 and 4 to move down 1.
Does anyone have an idea on how I do this? Or any advice on best practises etc ?


View Complete Post

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend