Posted: 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.
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.