This forum has been a great help in the past as well as the previous two posts. I use TD for our league and Rank'em for our website and with some tweeks here and there I have been able to get it running pretty smoothly.
I currently use the formula in Tournament Director N - R + 1 with a bonus of 5 pts for a buyin. Now when I translate this to Rank'em the formula looks like this (bolded type):
strSQL = "SELECT "& round_count & " round((1+((T.tournament_players)-(S.placement)+5)),0) " _
& "FROM scores S INNER JOIN tournament T ON S.tournament_id = T.tournament_id " _
& "WHERE S.player_id = "& dbRS(0) & " "
if session("date_range") > "" then
strSQL = strSQL & " AND T.tournament_date BETWEEN #"& session("begindate") &"# AND #"& session("enddate") &"# "
end if
strSQL = strSQL & "ORDER BY 1 DESC"
What I am requesting help on is this if anyone can possibly help out.
Using the code above I am looking to change N – R + 1 which it is above to use the formula
N – R + 1 + if(r == 1, 5)
Thank you in advance to any help one could give. DestaDula
Side note: I have asked the author of Rank’em to both contact TD and try to get the programs hooked up and to also proved formulas as an input much the way TD does, but no answer yet.