|
|
| View previous topic :: View next topic |
| Author |
Message |
caykroyd
Joined: 11 Jul 2007
Posts: 99
|
 Posted: Sat Aug 18, 2007 11:00 pm Post subject: updated summaryweek |
 |
|
Use this update to show all ranks even if a user's score is 0
Add this below the first $users[] declaration.
| Code: | $sql="select user from ".$football->prefix."users where user != '".$football->admin_username."' and user NOT IN (select u.user
from ".$football->prefix."users as u, ".$football->prefix."picks as p, ".$football->prefix."schedule as s
where s.week = ".$week."
and p.gameid = s.gameid
and u.user = p.user
and p.pick = s.result
and p.pick != \"\")";
$rs=$football->dbQuery($sql);
while($row=mysql_fetch_object($rs)) {
$users[] = $football->userSummary($row->user);
}
|
|
|
| Back to top |
|
 |
ghgarcia
Site Admin
Joined: 27 Jul 2005
Posts: 695
|
| Posted: Sun Aug 19, 2007 7:28 am Post subject: |
|
|
Hi,
Can you supply more detals as to exactly where in summary.php and what to replace or add.
Thanks,
G |
|
| Back to top |
|
|
caykroyd
Joined: 11 Jul 2007
Posts: 99
|
| Posted: Sun Aug 19, 2007 4:50 pm Post subject: |
|
|
I've changed some things so I don't know the exact line number. Somewhere around line 40-50. Add the previous supplied code below | Code: | while($row=mysql_fetch_object($rs)) {
$users[] = $football->userSummary($row->user);
}
|
|
|
| Back to top |
|
|
gangeli
Joined: 07 Aug 2005
Posts: 71
|
| Posted: Sun Aug 19, 2007 9:52 pm Post subject: |
|
|
i put the code in, and went and looked at the 1st week, since there was only one game. everyone shows they have 1 win, even though i know only one person picked the game correctly.
not saying its not me though, that certainly could be the case  |
|
| Back to top |
|
|
caykroyd
Joined: 11 Jul 2007
Posts: 99
|
| Posted: Mon Aug 20, 2007 12:02 am Post subject: |
|
|
oops. Forgot to tell you to clear a couple variables.
around line 132 you should find
Below that add two lines:
| Code: | $scoreweek = 0;
$score = 0;
|
This should fix you problem. Again sorry for not posting the new files, but mine are hacked up to be unworkable with the original files.
Also check the autoscores forum, as I have a new perl cronjob since myFFL is not working right now. |
|
| Back to top |
|
|
gangeli
Joined: 07 Aug 2005
Posts: 71
|
| Posted: Mon Aug 20, 2007 10:07 am Post subject: |
|
|
| thank you, that appears to do the trick |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
|
Powered by phpBB © 2001, 2002 phpBB Grou
p
design by boo ©eZ-Life.net A designer community
|
