Leaderboard help

hilln2

hey

was trying to set up a leaderboard for different teams.

I have set up in the members homePage all their individual players points, i.e.

Name: weekPts: totalPts:
D. Seaman 8 24
O. Luzhny 6 17
...etc

These points are called directly from the database using a simple SQL statement.

How do I calculate a members total score for this week and an overall score?, i.e. D. Seaman + O. Luzhny + x + y + ....

From this then Ill need to set up a scoreboard page which displays an overall leaderboard and also a leaderboard for this weeks results.

Anyone got any ideas? :rolleyes:

trooper

I'd create another table that is for the team and then make each player be a member of that team.

From then on its simply a mathematical equation to find out the points of all the players that belong to that team

HTH

ir4z0r

if you don't want to create new tables for various reasons,
you would have to use a query like this:
"SELECT count(pts) AS score FROM players WHERE (player1='$player1) OR (player2='$player2) OR ... OR (player11='$player11')"

do this for every team (in a loop)

each time retrieve the total score of a team with
$row = mysql_fetch_array($result);
$score[] = $row['score'];

afterwards, all scores are stored in the array $score, in the same order as the teams.

now some kind of sort/search function is needed, which sorts the scores and keeps the
corresponding teamname

Did anyone understand more than 10% I've written? :rolleyes:

hilln2

thanx for reply

I set up a table with column's username, team name, weekPts and TotalPts.

Each members_homepage has a variable $sum which returns their teams totalPts.

I printed that in the new table leaderboard.php and it worked.

my query was as follows:

$q01=mysql_query("update leaderboard set totalPts = $sum where username = 'SESSION_UNAME' ");

just thought id let u know!

Thanx 4 the help
😃

keep up d good work 😛

ir4z0r

:rolleyes: oops, saw a "typo", count() must of course be replaced with sum(), but if you got your plans working ... never mind