Weekly SportsBox Pool

Have fun with our free scripts...

Postby admin » Thu Jun 08, 2006 11:02 am

The script was designed for used in a "normal' super squares type. But it can be modified for other used like yours.

here are the few changes that you have to make manually in the index.php file to accomplish what you want;

for ($i=1; $i<=5; $i++) {
$Home[$i]="";
$Visitor[$i]="";
}

...

while ($record = mysql_fetch_assoc($result)) {
//added for 25 squares
if ($record['SQUARE'] > 24) { break; }


if ($cnt_row==0) {$i++; echo"<td align='center'> $VISITOR_TEAM<br/><font size='3'><strong>".$Visitor[$i]."</strong></font> </td>";}
if ($record['NAME'] == "AVAILABLE") {
echo "<td width='20%' title='only $".$BET."'><a href=\"signup.php?square=".$record['SQUARE']."\">".stripslashes($record['NAME'])."<br/>".$record['SQUARE']."</a></td>";
} else if ($record['NAME']!="AVAILABLE" && $record['CONFIRM']==1) {
echo "<td width='20%' bgcolor='#99ff66' align='center' title=\"".$record['NOTES']."\"><strong>".stripslashes($record['NAME'])."</strong><br/>Confirmed</td>";
} else {
echo "<td width='20%' bgcolor='#ff9966' align='center' title=\"".$record['NOTES']."\"><strong>".stripslashes($record['NAME'])."</strong><br/>Pending</td>";
}

$cnt_row++;
if ($cnt_row==5) {
$cnt_row=0;
echo "</tr><tr>";
}
}


Hope that will work for you.
User avatar
admin
Site Admin
 
Posts: 938
Joined: Tue Jun 14, 2005 3:41 pm

Postby admin » Thu Jun 08, 2006 1:43 pm

What you are looking for will required some work on modification on the index.php file to limit the number of picks to 25.

If you under stand PHP, d othe following:
- query the database for "AVAILABE"
- if the number is 75 then you know 25 limit has been reached.
- displce the contain of "NAME" from the database without any hyperlink.

I hope that is enough info for you to modify the scripts to your needs

Sorry but I cannot customize the scripts for indivisual without contribution.
User avatar
admin
Site Admin
 
Posts: 938
Joined: Tue Jun 14, 2005 3:41 pm


Return to Free PHP/mySQL Scripts

Who is online

Users browsing this forum: No registered users and 5 guests

cron