newttster
Members-
Posts
514 -
Joined
-
Last visited
-
Days Won
14
Content Type
Profiles
Forums
Events
Everything posted by newttster
-
And another one gets bitten in the ass by our infamous friend. Sorry this happened to ya, mate. Let's hope this works as a warning to others, (Again) to not deal with him.
-
What errors are you having when adding users? Cities? Could you be a little more specific?
-
I believe he is talking about the staff_items file. It's not the best of solutions but what I did to by pass this was to enter them via phpMyAdmin. Then use the edit items to fix/add to the items once that was done ... basically the effects.
-
I've tried to edit the file ... but when I open it to edit it ... there are no spaces though they are clearly visible when not in edit. Which line are you getting the query error for? I would like to make sure it is all running fine for every one. =) It works fine for me but it's probable when I copied the files I missed something as I adjusted the files for general use as opposed to the way I have them set for my future game. Thank you both. I found the column count error ... it is in the sqls ... bingo four ... removed `number41`. Sorry about that. If there are any more errors, please post them and I will do my best to fix them.
-
One thing that you might try is a dns flush ... sometimes that will work when all else has failed. Start menu -> run->type ipconfig /flushdns Make sure there is a space between g and / Hope this helps.
-
Can you explain "very dodgy" ... what is it doing. Some scrren shots would help.=))
-
Here are some screenshots of the way I have it set up for my future game. Obviously you would do the changes to the file to suit your needs.
-
Name this file fullcard.php <?php include "globals.php"; //fullcard.php //------------------------------------------------ //Mod created by Tina Gatien aka Newttster for the MWG community. //Thanks to Spudinksi and sniko for their suggestions on arrays //This is a free mod and not to be sold //------------------------------------------------ $m=($db->fetch_row($db->query("SELECT * FROM bingonine WHERE userid={$ir['userid']}"))); $t=($db->fetch_row($db->query("SELECT * FROM bingo WHERE userid = {$ir['userid']}"))); echo"<center><font color=steelblue>Your matching numbers for a full card appear in red.</font></center><br />"; echo "<center><table width=\"50%\" border=\"2\" bordercolor=\"blue\">"; //if they don't have enough money they have to start over if ($ir['money'] < 10000) { echo"<center>You don't have enough money to try for the full card.<br /> You have to start from the beginning.<br /><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); exit; } else { $db->query("UPDATE users SET money=money-10000 WHERE userid = {$ir['userid']}"); } //Compares and matches the numbers if (in_array($t['bingob1'], $m)) { $db->query("UPDATE bingothree SET bingob1=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob1'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob1'] . '</font></center></td>'; } if (in_array($t['bingoi1'], $m)) { $db->query("UPDATE bingothree SET bingoi1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi1'] . '</font></center></td>'; } if (in_array($t['bingon1'], $m)) { $db->query("UPDATE bingothree SET bingon1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon1'] . '</font></center></td>'; } if (in_array($t['bingog1'], $m)) { $db->query("UPDATE bingothree SET bingog1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog1'] . '</font></center></td>'; } if (in_array($t['bingoo1'], $m)) { $db->query("UPDATE bingothree SET bingoo1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo1'] . '</font></center></td></tr>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo1'] . '</font></center></td></tr>'; } if (in_array($t['bingob2'], $m)) { $db->query("UPDATE bingothree SET bingob2=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob2'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob2'] . '</font></center></td>'; } if (in_array($t['bingoi2'], $m)) { $db->query("UPDATE bingothree SET bingoi2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi2'] . '</font></center></td>'; } if (in_array($t['bingon2'], $m)) { $db->query("UPDATE bingothree SET bingon2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon2'] . '</font></center></td>'; } if (in_array($t['bingog2'], $m)) { $db->query("UPDATE bingothree SET bingog2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog2'] . '</font></center></td>'; } if (in_array($t['bingoo2'], $m)) { $db->query("UPDATE bingothree SET bingoo2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo2'] . '</font></center></td>'; } if (in_array($t['bingob3'], $m)) { $db->query("UPDATE bingothree SET bingob3=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob3'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob3'] . '</font></center></td>'; } if (in_array($t['bingoi3'], $m)) { $db->query("UPDATE bingothree SET bingoi3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi3'] . '</font></center></td>'; } echo"<td><center><font size=3 color=darkred>FREE</font></center></td>"; if (in_array($t['bingog3'], $m)) { $db->query("UPDATE bingothree SET bingog3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog3'] . '</font></center></td>'; } if (in_array($t['bingoo3'], $m)) { $db->query("UPDATE bingothree SET bingoo3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo3'] . '</font></center></td>'; } if (in_array($t['bingob4'], $m)) { $db->query("UPDATE bingothree SET bingob4=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob4'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob4'] . '</font></center></td>'; } if (in_array($t['bingoi4'], $m)) { $db->query("UPDATE bingothree SET bingoi4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi4'] . '</font></center></td>'; } if (in_array($t['bingon3'], $m)) { $db->query("UPDATE bingothree SET bingon3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon3'] . '</font></center></td>'; } if (in_array($t['bingog4'], $m)) { $db->query("UPDATE bingothree SET bingog4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog4'] . '</font></center></td>'; } if (in_array($t['bingoo4'], $m)) { $db->query("UPDATE bingothree SET bingoo4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo4'] . '</font></center></td>'; } if (in_array($t['bingob5'], $m)) { $db->query("UPDATE bingothree SET bingob5=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob5'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob5'] . '</font></center></td>'; } if (in_array($t['bingoi5'], $m)) { $db->query("UPDATE bingothree SET bingoi5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi5'] . '</font></center></td>'; } if (in_array($t['bingon4'], $m)) { $db->query("UPDATE bingothree SET bingon4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon4'] . '</font></center></td>'; } if (in_array($t['bingog5'], $m)) { $db->query("UPDATE bingothree SET bingog5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog5'] . '</font></center></td>'; } if (in_array($t['bingoo5'], $m)) { $db->query("UPDATE bingothree SET bingoo5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo5'] . '</font></center></td>'; } echo"</table></center><br />"; //Determines if there is a match $line=($db->fetch_row($db->query("SELECT * FROM bingothree WHERE userid = {$ir['userid']}"))); if (($line['bingob1']==1) && ($line['bingob2']==1) && ($line['bingob3']==1) && ($line['bingob4']==1) && ($line['bingob5']==1) && ($line['bingoi1']==1) && ($line['bingoi2']==1) && ($line['bingoi3']==1) && ($line['bingoi4']==1) && ($line['bingoi5']==1) && ($line['bingon1']==1) && ($line['bingon2']==1) && ($line['bingon3']==1) && ($line['bingon4']==1) && ($line['bingog1']==1) && ($line['bingog2']==1) && ($line['bingog3']==1) && ($line['bingog4']==1) && ($line['bingog5']==1) && ($line['bingoo1']==1) && ($line['bingoo2']==1) && ($line['bingoo3']==1) && ($line['bingoo4']==1) && ($line['bingoo5']==1)) { echo"<center>Congratulations! You have won on the Full card. You won $150,000.<br /> Would you like to play again<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+150000 WHERE userid = {$ir['userid']}"); } else { echo" <center>You did not win on the full card. Would you like to play again<br /> It will cost you $10,000 to do so.<br /><br /></center>"; } $db->query("DELETE FROM bingo WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingotwo WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingothree WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingofour WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingofive WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingosix WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingoseven WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingoeight WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingonine WHERE userid={$ir['userid']}"); echo"<center><a href='bingo.php'>Play Again</a><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); ?>
-
Name this file lettern.php <?php include "globals.php"; //lettern.php //------------------------------------------------ //Mod created by Tina Gatien aka Newttster for the MWG community. //Thanks to Spudinksi and sniko for their suggestions on arrays //This is a free mod and not to be sold //------------------------------------------------ $m=($db->fetch_row($db->query("SELECT * FROM bingoeight WHERE userid={$ir['userid']}"))); $t=($db->fetch_row($db->query("SELECT * FROM bingo WHERE userid = {$ir['userid']}"))); echo"<center><font color=steelblue>Your matching numbers for the Letter N appear in red.</font></center><br />"; echo "<center><table width=\"50%\" border=\"2\" bordercolor=\"blue\">"; //if they don't have enough money they have to start over if ($ir['money'] < 10000) { echo"<center>You don't have enough money to try for the letter n.<br /> You have to start from the beginning.<br /><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); exit; } else { $db->query("UPDATE users SET money=money-10000 WHERE userid = {$ir['userid']}"); } //Compares and matches the numbers if (in_array($t['bingob1'], $m)) { $db->query("UPDATE bingothree SET bingob1=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob1'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob1'] . '</font></center></td>'; } if (in_array($t['bingoi1'], $m)) { $db->query("UPDATE bingothree SET bingoi1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi1'] . '</font></center></td>'; } if (in_array($t['bingon1'], $m)) { $db->query("UPDATE bingothree SET bingon1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon1'] . '</font></center></td>'; } if (in_array($t['bingog1'], $m)) { $db->query("UPDATE bingothree SET bingog1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog1'] . '</font></center></td>'; } if (in_array($t['bingoo1'], $m)) { $db->query("UPDATE bingothree SET bingoo1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo1'] . '</font></center></td></tr>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo1'] . '</font></center></td></tr>'; } if (in_array($t['bingob2'], $m)) { $db->query("UPDATE bingothree SET bingob2=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob2'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob2'] . '</font></center></td>'; } if (in_array($t['bingoi2'], $m)) { $db->query("UPDATE bingothree SET bingoi2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi2'] . '</font></center></td>'; } if (in_array($t['bingon2'], $m)) { $db->query("UPDATE bingothree SET bingon2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon2'] . '</font></center></td>'; } if (in_array($t['bingog2'], $m)) { $db->query("UPDATE bingothree SET bingog2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog2'] . '</font></center></td>'; } if (in_array($t['bingoo2'], $m)) { $db->query("UPDATE bingothree SET bingoo2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo2'] . '</font></center></td>'; } if (in_array($t['bingob3'], $m)) { $db->query("UPDATE bingothree SET bingob3=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob3'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob3'] . '</font></center></td>'; } if (in_array($t['bingoi3'], $m)) { $db->query("UPDATE bingothree SET bingoi3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi3'] . '</font></center></td>'; } echo"<td><center><font size=3 color=darkred>FREE</font></center></td>"; if (in_array($t['bingog3'], $m)) { $db->query("UPDATE bingothree SET bingog3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog3'] . '</font></center></td>'; } if (in_array($t['bingoo3'], $m)) { $db->query("UPDATE bingothree SET bingoo3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo3'] . '</font></center></td>'; } if (in_array($t['bingob4'], $m)) { $db->query("UPDATE bingothree SET bingob4=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob4'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob4'] . '</font></center></td>'; } if (in_array($t['bingoi4'], $m)) { $db->query("UPDATE bingothree SET bingoi4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi4'] . '</font></center></td>'; } if (in_array($t['bingon3'], $m)) { $db->query("UPDATE bingothree SET bingon3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon3'] . '</font></center></td>'; } if (in_array($t['bingog4'], $m)) { $db->query("UPDATE bingothree SET bingog4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog4'] . '</font></center></td>'; } if (in_array($t['bingoo4'], $m)) { $db->query("UPDATE bingothree SET bingoo4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo4'] . '</font></center></td>'; } if (in_array($t['bingob5'], $m)) { $db->query("UPDATE bingothree SET bingob5=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob5'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob5'] . '</font></center></td>'; } if (in_array($t['bingoi5'], $m)) { $db->query("UPDATE bingothree SET bingoi5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi5'] . '</font></center></td>'; } if (in_array($t['bingon4'], $m)) { $db->query("UPDATE bingothree SET bingon4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon4'] . '</font></center></td>'; } if (in_array($t['bingog5'], $m)) { $db->query("UPDATE bingothree SET bingog5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog5'] . '</font></center></td>'; } if (in_array($t['bingoo5'], $m)) { $db->query("UPDATE bingothree SET bingoo5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo5'] . '</font></center></td>'; } echo"</table></center><br />"; //Determines if there is a match $line=($db->fetch_row($db->query("SELECT * FROM bingothree WHERE userid = {$ir['userid']}"))); if (($line['bingob1']==1) && ($line['bingob2']==1) && ($line['bingob3']==1) && ($line['bingob4']==1) && ($line['bingob5']==1) && ($line['bingoi2']==1) && ($line['bingog4']==1) && ($line['bingoo5']==1) && ($line['bingoo4']==1) && ($line['bingoo3']==1) && ($line['bingoo2']==1) && ($line['bingoo1']==1)) { echo"<center>Congratulations! You have won on the letter N. You won $120,000.<br /> Would you like to continue for the full card?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+120000 WHERE userid = {$ir['userid']}"); } else { echo" <center>You did not win on the letter N. Would you like to continue for a full card?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; } echo"<center><a href='fullcard.php'>Full Card</a><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); ?>
-
Name this file letterx.php <?php include "globals.php"; //letterx.php //------------------------------------------------ //Mod created by Tina Gatien aka Newttster for the MWG community. //Thanks to Spudinksi and sniko for their suggestions on arrays //This is a free mod and not to be sold //------------------------------------------------ $m=($db->fetch_row($db->query("SELECT * FROM bingoseven WHERE userid={$ir['userid']}"))); $t=($db->fetch_row($db->query("SELECT * FROM bingo WHERE userid = {$ir['userid']}"))); echo"<center><font color=steelblue>Your matching numbers for the Letter X appear in red.</font></center><br />"; echo "<center><table width=\"50%\" border=\"2\" bordercolor=\"blue\">"; //if they don't have enough money they have to start over if ($ir['money'] < 10000) { echo"<center>You don't have enough money to try for the letter x.<br /> You have to start from the beginning.<br /><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); exit; } else { $db->query("UPDATE users SET money=money-10000 WHERE userid = {$ir['userid']}"); } //Compares and matches the numbers if (in_array($t['bingob1'], $m)) { $db->query("UPDATE bingothree SET bingob1=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob1'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob1'] . '</font></center></td>'; } if (in_array($t['bingoi1'], $m)) { $db->query("UPDATE bingothree SET bingoi1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi1'] . '</font></center></td>'; } if (in_array($t['bingon1'], $m)) { $db->query("UPDATE bingothree SET bingon1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon1'] . '</font></center></td>'; } if (in_array($t['bingog1'], $m)) { $db->query("UPDATE bingothree SET bingog1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog1'] . '</font></center></td>'; } if (in_array($t['bingoo1'], $m)) { $db->query("UPDATE bingothree SET bingoo1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo1'] . '</font></center></td></tr>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo1'] . '</font></center></td></tr>'; } if (in_array($t['bingob2'], $m)) { $db->query("UPDATE bingothree SET bingob2=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob2'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob2'] . '</font></center></td>'; } if (in_array($t['bingoi2'], $m)) { $db->query("UPDATE bingothree SET bingoi2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi2'] . '</font></center></td>'; } if (in_array($t['bingon2'], $m)) { $db->query("UPDATE bingothree SET bingon2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon2'] . '</font></center></td>'; } if (in_array($t['bingog2'], $m)) { $db->query("UPDATE bingothree SET bingog2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog2'] . '</font></center></td>'; } if (in_array($t['bingoo2'], $m)) { $db->query("UPDATE bingothree SET bingoo2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo2'] . '</font></center></td>'; } if (in_array($t['bingob3'], $m)) { $db->query("UPDATE bingothree SET bingob3=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob3'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob3'] . '</font></center></td>'; } if (in_array($t['bingoi3'], $m)) { $db->query("UPDATE bingothree SET bingoi3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi3'] . '</font></center></td>'; } echo"<td><center><font size=3 color=darkred>FREE</font></center></td>"; if (in_array($t['bingog3'], $m)) { $db->query("UPDATE bingothree SET bingog3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog3'] . '</font></center></td>'; } if (in_array($t['bingoo3'], $m)) { $db->query("UPDATE bingothree SET bingoo3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo3'] . '</font></center></td>'; } if (in_array($t['bingob4'], $m)) { $db->query("UPDATE bingothree SET bingob4=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob4'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob4'] . '</font></center></td>'; } if (in_array($t['bingoi4'], $m)) { $db->query("UPDATE bingothree SET bingoi4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi4'] . '</font></center></td>'; } if (in_array($t['bingon3'], $m)) { $db->query("UPDATE bingothree SET bingon3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon3'] . '</font></center></td>'; } if (in_array($t['bingog4'], $m)) { $db->query("UPDATE bingothree SET bingog4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog4'] . '</font></center></td>'; } if (in_array($t['bingoo4'], $m)) { $db->query("UPDATE bingothree SET bingoo4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo4'] . '</font></center></td>'; } if (in_array($t['bingob5'], $m)) { $db->query("UPDATE bingothree SET bingob5=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob5'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob5'] . '</font></center></td>'; } if (in_array($t['bingoi5'], $m)) { $db->query("UPDATE bingothree SET bingoi5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi5'] . '</font></center></td>'; } if (in_array($t['bingon4'], $m)) { $db->query("UPDATE bingothree SET bingon4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon4'] . '</font></center></td>'; } if (in_array($t['bingog5'], $m)) { $db->query("UPDATE bingothree SET bingog5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog5'] . '</font></center></td>'; } if (in_array($t['bingoo5'], $m)) { $db->query("UPDATE bingothree SET bingoo5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo5'] . '</font></center></td>'; } echo"</table></center><br />"; //Determines if there is a match $line=($db->fetch_row($db->query("SELECT * FROM bingothree WHERE userid = {$ir['userid']}"))); if (($line['bingob1']==1) && ($line['bingoi2']==1) && ($line['bingoi4']==1) && ($line['bingob5']==1) && ($line['bingoo1']==1) && ($line['bingog2']==1) && ($line['bingog4']==1) && ($line['bingoo5']==1)) { echo"<center>Congratulations! You have won on the letter X. You won $100,000.<br /> Would you like to continue for the letter N?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+100000 WHERE userid = {$ir['userid']}"); } else { echo" <center>You did not win on the letter X. Would you like to continue for the letter N?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; } echo"<center><a href='lettern.php'>Letter N</a><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); ?>
-
Name this file lettert.php <?php //lettert.php //------------------------------------------------ //Mod created by Tina Gatien aka Newttster for the MWG community. //Thanks to Spudinksi and sniko for their suggestions on arrays //This is a free mod and not to be sold //------------------------------------------------ include "globals.php"; $m=($db->fetch_row($db->query("SELECT * FROM bingosix WHERE userid={$ir['userid']}"))); $t=($db->fetch_row($db->query("SELECT * FROM bingo WHERE userid = {$ir['userid']}"))); echo"<center><font >Your matching numbers for the Letter T appear in red.</font></center><br />"; echo "<center><table width=\"50%\" border=\"2\" bordercolor=\"blue\">"; //if they don't have enough money they have to start over if ($ir['money'] < 10000) { echo"<center>You don't have enough money to try for the letter t.<br /> You have to start from the beginning.<br /><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); exit; } else { $db->query("UPDATE users SET money=money-10000 WHERE userid = {$ir['userid']}"); } //Compares and matches the numbers if (in_array($t['bingob1'], $m)) { $db->query("UPDATE bingothree SET bingob1=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob1'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob1'] . '</font></center></td>'; } if (in_array($t['bingoi1'], $m)) { $db->query("UPDATE bingothree SET bingoi1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi1'] . '</font></center></td>'; } if (in_array($t['bingon1'], $m)) { $db->query("UPDATE bingothree SET bingon1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon1'] . '</font></center></td>'; } if (in_array($t['bingog1'], $m)) { $db->query("UPDATE bingothree SET bingog1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog1'] . '</font></center></td>'; } if (in_array($t['bingoo1'], $m)) { $db->query("UPDATE bingothree SET bingoo1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo1'] . '</font></center></td></tr>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo1'] . '</font></center></td></tr>'; } if (in_array($t['bingob2'], $m)) { $db->query("UPDATE bingothree SET bingob2=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob2'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob2'] . '</font></center></td>'; } if (in_array($t['bingoi2'], $m)) { $db->query("UPDATE bingothree SET bingoi2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi2'] . '</font></center></td>'; } if (in_array($t['bingon2'], $m)) { $db->query("UPDATE bingothree SET bingon2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon2'] . '</font></center></td>'; } if (in_array($t['bingog2'], $m)) { $db->query("UPDATE bingothree SET bingog2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog2'] . '</font></center></td>'; } if (in_array($t['bingoo2'], $m)) { $db->query("UPDATE bingothree SET bingoo2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo2'] . '</font></center></td>'; } if (in_array($t['bingob3'], $m)) { $db->query("UPDATE bingothree SET bingob3=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob3'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob3'] . '</font></center></td>'; } if (in_array($t['bingoi3'], $m)) { $db->query("UPDATE bingothree SET bingoi3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi3'] . '</font></center></td>'; } echo"<td><center><font size=3 color=darkred>FREE</font></center></td>"; if (in_array($t['bingog3'], $m)) { $db->query("UPDATE bingothree SET bingog3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog3'] . '</font></center></td>'; } if (in_array($t['bingoo3'], $m)) { $db->query("UPDATE bingothree SET bingoo3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo3'] . '</font></center></td>'; } if (in_array($t['bingob4'], $m)) { $db->query("UPDATE bingothree SET bingob4=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob4'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob4'] . '</font></center></td>'; } if (in_array($t['bingoi4'], $m)) { $db->query("UPDATE bingothree SET bingoi4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi4'] . '</font></center></td>'; } if (in_array($t['bingon3'], $m)) { $db->query("UPDATE bingothree SET bingon3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon3'] . '</font></center></td>'; } if (in_array($t['bingog4'], $m)) { $db->query("UPDATE bingothree SET bingog4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog4'] . '</font></center></td>'; } if (in_array($t['bingoo4'], $m)) { $db->query("UPDATE bingothree SET bingoo4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo4'] . '</font></center></td>'; } if (in_array($t['bingob5'], $m)) { $db->query("UPDATE bingothree SET bingob5=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob5'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob5'] . '</font></center></td>'; } if (in_array($t['bingoi5'], $m)) { $db->query("UPDATE bingothree SET bingoi5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi5'] . '</font></center></td>'; } if (in_array($t['bingon4'], $m)) { $db->query("UPDATE bingothree SET bingon4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon4'] . '</font></center></td>'; } if (in_array($t['bingog5'], $m)) { $db->query("UPDATE bingothree SET bingog5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog5'] . '</font></center></td>'; } if (in_array($t['bingoo5'], $m)) { $db->query("UPDATE bingothree SET bingoo5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo5'] . '</font></center></td>'; } echo"</table></center><br />"; //Determines if there is a match $line=($db->fetch_row($db->query("SELECT * FROM bingothree WHERE userid = {$ir['userid']}"))); if (($line['bingob1']==1) && ($line['bingoi1']==1) && ($line['bingon1']==1) && ($line['bingog1']==1) && ($line['bingoo1']==1) && ($line['bingon2']==1) && ($line['bingon3']==1) && ($line['bingon4']==1)) { echo"<center>Congratulations! You have won on the letter T. You won $80,000.<br /> Would you like to continue for the letter X?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+80000 WHERE userid = {$ir['userid']}"); } else { echo" <center>You did not win on the letter T. Would you like to continue for the letter X?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; } echo"<center><a href='letterx.php'>Letter X</a><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); ?>
-
Name this file lettery.php <?php //lettery.php //------------------------------------------------ //Mod created by Tina Gatien aka Newttster for the MWG community. //Thanks to Spudinksi and sniko for their suggestions on arrays //This is a free mod and not to be sold //------------------------------------------------ include "globals.php"; $m=($db->fetch_row($db->query("SELECT * FROM bingofive WHERE userid={$ir['userid']}"))); $t=($db->fetch_row($db->query("SELECT * FROM bingo WHERE userid = {$ir['userid']}"))); echo"<center><font >Your matching numbers for the Letter Y appear in red.</font></center><br />"; echo "<center><table width=\"50%\" border=\"2\" bordercolor=\"blue\">"; //if they don't have enough money they have to start over if ($ir['money'] < 10000) { echo"<center>You don't have enough money to try for the letter y.<br /> You have to start from the beginning.<br /><br /> <a href='explore.php'>Back</a></center>"; $h->endpage(); exit; } else { $db->query("UPDATE users SET money=money-10000 WHERE userid = {$ir['userid']}"); } //Compares and matches the numbers if (in_array($t['bingob1'], $m)) { $db->query("UPDATE bingothree SET bingob1=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob1'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob1'] . '</font></center></td>'; } if (in_array($t['bingoi1'], $m)) { $db->query("UPDATE bingothree SET bingoi1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi1'] . '</font></center></td>'; } if (in_array($t['bingon1'], $m)) { $db->query("UPDATE bingothree SET bingon1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon1'] . '</font></center></td>'; } if (in_array($t['bingog1'], $m)) { $db->query("UPDATE bingothree SET bingog1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog1'] . '</font></center></td>'; } if (in_array($t['bingoo1'], $m)) { $db->query("UPDATE bingothree SET bingoo1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo1'] . '</font></center></td></tr>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo1'] . '</font></center></td></tr>'; } if (in_array($t['bingob2'], $m)) { $db->query("UPDATE bingothree SET bingob2=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob2'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob2'] . '</font></center></td>'; } if (in_array($t['bingoi2'], $m)) { $db->query("UPDATE bingothree SET bingoi2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi2'] . '</font></center></td>'; } if (in_array($t['bingon2'], $m)) { $db->query("UPDATE bingothree SET bingon2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon2'] . '</font></center></td>'; } if (in_array($t['bingog2'], $m)) { $db->query("UPDATE bingothree SET bingog2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog2'] . '</font></center></td>'; } if (in_array($t['bingoo2'], $m)) { $db->query("UPDATE bingothree SET bingoo2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo2'] . '</font></center></td>'; } if (in_array($t['bingob3'], $m)) { $db->query("UPDATE bingothree SET bingob3=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob3'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob3'] . '</font></center></td>'; } if (in_array($t['bingoi3'], $m)) { $db->query("UPDATE bingothree SET bingoi3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi3'] . '</font></center></td>'; } echo"<td><center><font size=3 color=darkred>FREE</font></center></td>"; if (in_array($t['bingog3'], $m)) { $db->query("UPDATE bingothree SET bingog3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog3'] . '</font></center></td>'; } if (in_array($t['bingoo3'], $m)) { $db->query("UPDATE bingothree SET bingoo3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo3'] . '</font></center></td>'; } if (in_array($t['bingob4'], $m)) { $db->query("UPDATE bingothree SET bingob4=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob4'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob4'] . '</font></center></td>'; } if (in_array($t['bingoi4'], $m)) { $db->query("UPDATE bingothree SET bingoi4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi4'] . '</font></center></td>'; } if (in_array($t['bingon3'], $m)) { $db->query("UPDATE bingothree SET bingon3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon3'] . '</font></center></td>'; } if (in_array($t['bingog4'], $m)) { $db->query("UPDATE bingothree SET bingog4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog4'] . '</font></center></td>'; } if (in_array($t['bingoo4'], $m)) { $db->query("UPDATE bingothree SET bingoo4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo4'] . '</font></center></td>'; } if (in_array($t['bingob5'], $m)) { $db->query("UPDATE bingothree SET bingob5=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob5'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob5'] . '</font></center></td>'; } if (in_array($t['bingoi5'], $m)) { $db->query("UPDATE bingothree SET bingoi5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi5'] . '</font></center></td>'; } if (in_array($t['bingon4'], $m)) { $db->query("UPDATE bingothree SET bingon4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon4'] . '</font></center></td>'; } if (in_array($t['bingog5'], $m)) { $db->query("UPDATE bingothree SET bingog5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog5'] . '</font></center></td>'; } if (in_array($t['bingoo5'], $m)) { $db->query("UPDATE bingothree SET bingoo5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo5'] . '</font></center></td>'; } echo"</table></center><br />"; //Determines if there is a match $line=($db->fetch_row($db->query("SELECT * FROM bingothree WHERE userid = {$ir['userid']}"))); if (($line['bingob1']==1) && ($line['bingoi2']==1) && ($line['bingog2']==1) && ($line['bingoo1']==1) && ($line['bingon3']==1) && ($line['bingon4']==1)) { echo"<center>Congratulations! You have won on the letter Y. You won $60,000.<br /> Would you like to continue for the letter T?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+60000 WHERE userid = {$ir['userid']}"); } else { echo" <center>You did not win on the letter Y. Would you like to continue for the letter T?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; } echo"<center><a href='lettert.php'>Letter T</a><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); ?>
-
Name this file onelinematch.php <?php //onelinematch.php //------------------------------------------------ //Mod created by Tina Gatien aka Newttster for the MWG community. //Thanks to Spudinksi and sniko for their suggestions on arrays //This is a free mod and not to be sold //------------------------------------------------ include "globals.php"; $m=($db->fetch_row($db->query("SELECT * FROM bingofour WHERE userid={$ir['userid']}"))); $t=($db->fetch_row($db->query("SELECT * FROM bingo WHERE userid = {$ir['userid']}"))); echo"<center>Your matching numbers for one line appear in red.</center><br />"; echo "<center><table width=\"50%\" border=\"2\" bordercolor=\"blue\">"; //if they don't have enough money they have to start over if ($ir['money'] < 10000) { echo"<center>You don't have enough money to try for one line.<br /> You have to start from the beginning.<br /><br /> <a href='explore.php'>Back</a></center>"; $h->endpage(); exit; } else { $db->query("UPDATE users SET money=money-10000 WHERE userid = {$ir['userid']}"); } //Compares and matches the numbers if (in_array($t['bingob1'], $m)) { $db->query("UPDATE bingothree SET bingob1=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob1'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob1'] . '</font></center></td>'; } if (in_array($t['bingoi1'], $m)) { $db->query("UPDATE bingothree SET bingoi1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi1'] . '</font></center></td>'; } if (in_array($t['bingon1'], $m)) { $db->query("UPDATE bingothree SET bingon1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon1'] . '</font></center></td>'; } if (in_array($t['bingog1'], $m)) { $db->query("UPDATE bingothree SET bingog1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog1'] . '</font></center></td>'; } if (in_array($t['bingoo1'], $m)) { $db->query("UPDATE bingothree SET bingoo1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo1'] . '</font></center></td></tr>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo1'] . '</font></center></td></tr>'; } if (in_array($t['bingob2'], $m)) { $db->query("UPDATE bingothree SET bingob2=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob2'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob2'] . '</font></center></td>'; } if (in_array($t['bingoi2'], $m)) { $db->query("UPDATE bingothree SET bingoi2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi2'] . '</font></center></td>'; } if (in_array($t['bingon2'], $m)) { $db->query("UPDATE bingothree SET bingon2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon2'] . '</font></center></td>'; } if (in_array($t['bingog2'], $m)) { $db->query("UPDATE bingothree SET bingog2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog2'] . '</font></center></td>'; } if (in_array($t['bingoo2'], $m)) { $db->query("UPDATE bingothree SET bingoo2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo2'] . '</font></center></td>'; } if (in_array($t['bingob3'], $m)) { $db->query("UPDATE bingothree SET bingob3=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob3'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob3'] . '</font></center></td>'; } if (in_array($t['bingoi3'], $m)) { $db->query("UPDATE bingothree SET bingoi3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi3'] . '</font></center></td>'; } echo"<td><center><font size=3 color=darkred>FREE</font></center></td>"; if (in_array($t['bingog3'], $m)) { $db->query("UPDATE bingothree SET bingog3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog3'] . '</font></center></td>'; } if (in_array($t['bingoo3'], $m)) { $db->query("UPDATE bingothree SET bingoo3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo3'] . '</font></center></td>'; } if (in_array($t['bingob4'], $m)) { $db->query("UPDATE bingothree SET bingob4=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob4'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob4'] . '</font></center></td>'; } if (in_array($t['bingoi4'], $m)) { $db->query("UPDATE bingothree SET bingoi4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi4'] . '</font></center></td>'; } if (in_array($t['bingon3'], $m)) { $db->query("UPDATE bingothree SET bingon3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon3'] . '</font></center></td>'; } if (in_array($t['bingog4'], $m)) { $db->query("UPDATE bingothree SET bingog4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog4'] . '</font></center></td>'; } if (in_array($t['bingoo4'], $m)) { $db->query("UPDATE bingothree SET bingoo4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo4'] . '</font></center></td>'; } if (in_array($t['bingob5'], $m)) { $db->query("UPDATE bingothree SET bingob5=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob5'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob5'] . '</font></center></td>'; } if (in_array($t['bingoi5'], $m)) { $db->query("UPDATE bingothree SET bingoi5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi5'] . '</font></center></td>'; } if (in_array($t['bingon4'], $m)) { $db->query("UPDATE bingothree SET bingon4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon4'] . '</font></center></td>'; } if (in_array($t['bingog5'], $m)) { $db->query("UPDATE bingothree SET bingog5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog5'] . '</font></center></td>'; } if (in_array($t['bingoo5'], $m)) { $db->query("UPDATE bingothree SET bingoo5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo5'] . '</font></center></td>'; } echo"</table></center><br />"; //Determines if there is a match $line=($db->fetch_row($db->query("SELECT * FROM bingothree WHERE userid = {$ir['userid']}"))); if (($line['bingob1']==1) && ($line['bingob2']==1) && ($line['bingob3']==1) && ($line['bingob4']==1) && ($line['bingob5']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingoi1']==1) && ($line['bingoi2']==1) && ($line['bingoi3']==1) && ($line['bingoi4']==1) && ($line['bingoi5']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingon1']==1) && ($line['bingon2']==1) && ($line['bingon3']==1) && ($line['bingon4']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingog1']==1) && ($line['bingog2']==1) && ($line['bingog3']==1) && ($line['bingog4']==1) && ($line['bingog5']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingoo1']==1) && ($line['bingoo2']==1) && ($line['bingoo3']==1) && ($line['bingoo4']==1) && ($line['bingoo5']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingob1']==1) && ($line['bingoi1']==1) && ($line['bingon1']==1) && ($line['bingog1']==1) && ($line['bingoo1']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingob2']==1) && ($line['bingoi2']==1) && ($line['bingon2']==1) && ($line['bingog2']==1) && ($line['bingoo2']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingob3']==1) && ($line['bingoi3']==1) && ($line['bingog3']==1) && ($line['bingoo3']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingob4']==1) && ($line['bingoi4']==1) && ($line['bingon3']==1) && ($line['bingog4']==1) && ($line['bingoo4']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingob5']==1) && ($line['bingoi5']==1) && ($line['bingon4']==1) && ($line['bingog5']==1) && ($line['bingoo5']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingob1']==1) && ($line['bingoi2']==1) && ($line['bingog4']==1) && ($line['bingoo5']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } elseif (($line['bingob5']==1) && ($line['bingoi4']==1) && ($line['bingog2']==1) && ($line['bingoo1']==1)) { echo"<center>Congratulations! You have won a one line bingo. You won $40,000.<br /> Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+40000 WHERE userid = {$ir['userid']}"); } else { echo" <center>You did not win on the one line. Would you like to continue for the letter Y?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; } echo"<center><a href='lettery.php'>Letter Y</a><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); ?>
-
Name this file displaymatching.php <?php //displaymatching.php //------------------------------------------------ //Mod created by Tina Gatien aka Newttster for the MWG community. //Thanks to Spudinksi and sniko for their suggestions on arrays //This is a free mod and not to be sold //------------------------------------------------ include "globals.php"; $m=($db->fetch_row($db->query("SELECT * FROM bingotwo WHERE userid={$ir['userid']}"))); $t=($db->fetch_row($db->query("SELECT * FROM bingo WHERE userid = {$ir['userid']}"))); echo"<center>Your matching numbers for your 4 corners appear in red.</center><br />"; echo "<center><table width=\"50%\" border=\"2\" bordercolor=\"blue\">"; //Compares and matches the numbers if (in_array($t['bingob1'], $m)) { $db->query("UPDATE bingothree SET bingob1=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob1'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob1'] . '</font></center></td>'; } if (in_array($t['bingoi1'], $m)) { $db->query("UPDATE bingothree SET bingoi1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi1'] . '</font></center></td>'; } if (in_array($t['bingon1'], $m)) { $db->query("UPDATE bingothree SET bingon1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon1'] . '</font></center></td>'; } if (in_array($t['bingog1'], $m)) { $db->query("UPDATE bingothree SET bingog1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog1'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog1'] . '</font></center></td>'; } if (in_array($t['bingoo1'], $m)) { $db->query("UPDATE bingothree SET bingoo1=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo1'] . '</font></center></td></tr>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo1'] . '</font></center></td></tr>'; } if (in_array($t['bingob2'], $m)) { $db->query("UPDATE bingothree SET bingob2=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob2'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob2'] . '</font></center></td>'; } if (in_array($t['bingoi2'], $m)) { $db->query("UPDATE bingothree SET bingoi2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi2'] . '</font></center></td>'; } if (in_array($t['bingon2'], $m)) { $db->query("UPDATE bingothree SET bingon2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon2'] . '</font></center></td>'; } if (in_array($t['bingog2'], $m)) { $db->query("UPDATE bingothree SET bingog2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog2'] . '</font></center></td>'; } if (in_array($t['bingoo2'], $m)) { $db->query("UPDATE bingothree SET bingoo2=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo2'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo2'] . '</font></center></td>'; } if (in_array($t['bingob3'], $m)) { $db->query("UPDATE bingothree SET bingob3=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob3'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob3'] . '</font></center></td>'; } if (in_array($t['bingoi3'], $m)) { $db->query("UPDATE bingothree SET bingoi3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi3'] . '</font></center></td>'; } echo"<td><center><font size=3 color=darkred>FREE</font></center></td>"; if (in_array($t['bingog3'], $m)) { $db->query("UPDATE bingothree SET bingog3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog3'] . '</font></center></td>'; } if (in_array($t['bingoo3'], $m)) { $db->query("UPDATE bingothree SET bingoo3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo3'] . '</font></center></td>'; } if (in_array($t['bingob4'], $m)) { $db->query("UPDATE bingothree SET bingob4=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob4'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob4'] . '</font></center></td>'; } if (in_array($t['bingoi4'], $m)) { $db->query("UPDATE bingothree SET bingoi4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi4'] . '</font></center></td>'; } if (in_array($t['bingon3'], $m)) { $db->query("UPDATE bingothree SET bingon3=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon3'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon3'] . '</font></center></td>'; } if (in_array($t['bingog4'], $m)) { $db->query("UPDATE bingothree SET bingog4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog4'] . '</font></center></td>'; } if (in_array($t['bingoo4'], $m)) { $db->query("UPDATE bingothree SET bingoo4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo4'] . '</font></center></td>'; } if (in_array($t['bingob5'], $m)) { $db->query("UPDATE bingothree SET bingob5=1 WHERE userid = {$ir['userid']}"); echo '<tr height=50><td width=200><center><font size=3 color=darkred>' . $t['bingob5'] . '</font></center></td>'; } else { echo '<tr height=50><td width=200><center><font size=3>' . $t['bingob5'] . '</font></center></td>'; } if (in_array($t['bingoi5'], $m)) { $db->query("UPDATE bingothree SET bingoi5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoi5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoi5'] . '</font></center></td>'; } if (in_array($t['bingon4'], $m)) { $db->query("UPDATE bingothree SET bingon4=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingon4'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingon4'] . '</font></center></td>'; } if (in_array($t['bingog5'], $m)) { $db->query("UPDATE bingothree SET bingog5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingog5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingog5'] . '</font></center></td>'; } if (in_array($t['bingoo5'], $m)) { $db->query("UPDATE bingothree SET bingoo5=1 WHERE userid = {$ir['userid']}"); echo '<td width=200><center><font size=3 color=darkred>' . $t['bingoo5'] . '</font></center></td>'; } else { echo '<td width=200><center><font size=3>' . $t['bingoo5'] . '</font></center></td>'; } echo"</table></center><br />"; //Determines if there is a match $corners=($db->fetch_row($db->query("SELECT * FROM bingothree WHERE userid = {$ir['userid']}"))); if (($corners['bingob1']==1) && ($corners['bingob5']==1) && ($corners['bingoo1']==1) && ($corners['bingoo5']==1)) { echo"<center>Congratulations! You have won a four corner bingo. You won $20,000.<br /> Would you like to continue for one line?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; $db->query("UPDATE users SET money=money+20000 WHERE userid = {$ir['userid']}"); } else { echo" <center>You did not win on the four corners.Would you like to continue for one line?<br /> It will cost you $10,000 to do so.<br /><br /></center>"; } echo"<center><a href='onelinematch.php'>One Line</a><br> <a href='explore.php'>Back</a></center>"; $h->endpage(); ?>
-
Name this file bingo.php <?php //bingo.php //------------------------------------------------ //Mod created by Tina Gatien aka Newttster for the MWG community. //Thanks to Spudinksi and sniko for their suggestions on arrays //This is a free mod and not to be sold //------------------------------------------------ include "globals.php"; switch ($_GET['action']) { case 'bingocardget':bingocard_get();break; case 'callersnumbers': callers_numbers();break; default:bingo_home();break; } function bingo_home() { global $db,$ir,$c,$userid,$h; echo"<center><h2><u>Welcome to the Bingo Hall</u></h2> In order to play bingo, it will cost you $10,000 per card.<br /> This entitles you to play for a chance at 4 corners.<br /> You then have the option to go on to play further.<br /> Be sure that you have the money on hand to do so, <br /> otherwise you have to start with a new card.<br /> Do you want to play?<br /> Click on the 'Get My Card' link.<br /><br /> <a href='bingo.php?action=bingocardget'>Get My Card</a><br> <a href='explore.php'>No thanks</a></center>"; } function bingocard_get() { global $db,$ir,$c,$userid,$h; // deletes previous cards from tables $db->query("DELETE FROM bingo WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingotwo WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingothree WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingofour WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingofive WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingosix WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingoseven WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingoeight WHERE userid={$ir['userid']}"); $db->query("DELETE FROM bingonine WHERE userid={$ir['userid']}"); if ($ir['money']<10000) //This can be changed to suit your game needs { echo"<center>You do not have enough money to play.<br /><br /> <a href='explore.php'>Back</a></center>"; $h->endpage(); exit; } else { // sets up the players numbers for their card $bingob=array(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15); $bingoi=array(16,17,18,19,20,21,22,23,24,25,26,27,28,29,30); $bingon=array(31,32,33,34,35,36,37,38,39,40,41,42,43,44,45); $bingog=array(46,47,48,49,50,51,52,53,54,55,56,57,58,59,60); $bingoo=array(61,62,63,64,65,66,67,68,69,70,71,72,73,74,75); shuffle($bingob); $bingob1=($bingob[0]); $bingob2=($bingob[1]); $bingob3=($bingob[2]); $bingob4=($bingob[3]); $bingob5=($bingob[4]); shuffle($bingoi); $bingoi1=($bingoi[0]); $bingoi2=($bingoi[1]); $bingoi3=($bingoi[2]); $bingoi4=($bingoi[3]); $bingoi5=($bingoi[4]); shuffle($bingon); $bingon1=($bingon[0]); $bingon2=($bingon[1]); $bingon3=($bingon[2]); $bingon4=($bingon[3]); shuffle($bingog); $bingog1=($bingog[0]); $bingog2=($bingog[1]); $bingog3=($bingog[2]); $bingog4=($bingog[3]); $bingog5=($bingog[4]); shuffle($bingoo); $bingoo1=($bingoo[0]); $bingoo2=($bingoo[1]); $bingoo3=($bingoo[2]); $bingoo4=($bingoo[3]); $bingoo5=($bingoo[4]); $db->query("UPDATE users SET money=money-10000 WHERE userid={$ir['userid']}"); $db->query("INSERT INTO bingo VALUES ('',{$ir['userid']}, {$bingob1}, {$bingob2}, {$bingob3}, {$bingob4}, {$bingob5}, {$bingoi1}, {$bingoi2}, {$bingoi3}, {$bingoi4}, {$bingoi5}, {$bingon1}, {$bingon2}, {$bingon3}, {$bingon4}, {$bingog1}, {$bingog2}, {$bingog3}, {$bingog4}, {$bingog5}, {$bingoo1}, {$bingoo2}, {$bingoo3}, {$bingoo4}, {$bingoo5})"); $db->query("INSERT INTO bingothree VALUES ('', {$ir['userid']}, 0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0)"); echo"<center>Here is your bingo card. Good Luck!</center><br />"; // This is just a basic table set up. Set it up to suit your game echo "<center><table width=\"50%\" border=\"2\" bordercolor=\"blue\"> <tr height=50><td width=200><center><font size=3>{$bingob1}</font></center></td> <td width=200><center><font size=3>{$bingoi1}</font></center></td> <td width=200><center><font size=\"3\">{$bingon1}</font></center></td> <td width=200><center><font size=\"3\">{$bingog1}</font></center></td> <td width=200><center><font size=\"3\">{$bingoo1}</font></center></td></tr> <tr height=50><td><center><font size=\"3\">{$bingob2}</font></center></td> <td ><center><font size=\"3\">{$bingoi2}</font></center></td> <td><center><font size=\"3\">{$bingon2}</font></center></td> <td><center><font size=\"3\">{$bingog2}</font></center></td> <td><center><font size=\"3\">{$bingoo2}</font></center></td></tr> <tr height=50><td><center><font size=\"3\">{$bingob3}</font></center></td> <td><center><font size=\"3\">{$bingoi3}</font></center></td> <td><center><font size=\"3\">FREE</font></center></td> <td><center><font size=\"3\">{$bingog3}</font></center></td> <td><center><font size=\"3\">{$bingoo3}</font></center></td></tr> <tr height=50><td><center><font size=\"3\">{$bingob4}</font></center></td> <td><center><font size=\"3\">{$bingoi4}</font></center></td> <td><center><font size=\"3\">{$bingon3}</font></center></td> <td><center><font size=\"3\">{$bingog4}</font></center></td> <td><center><font size=\"3\">{$bingoo4}</font></center></td></tr> <tr height=50><td><center><font size=\"3\">{$bingob5}</font></center></td> <td><center><font size=\"3\">{$bingoi5}</font></center></td> <td><center><font size=\"3\">{$bingon4}</font></center></td> <td><center><font size=\"3\">{$bingog5}</font></center></td> <td><center><font size=\"3\">{$bingoo5}</font></center></td></tr> </table></center><br /><br />"; echo"<center>Click on the 'Callers Numbers' link to get the numbers to check against your card.<br /><br /> <a href='bingo.php?action=callersnumbers'>Callers Numbers</center></a>"; } } function callers_numbers() { global $db,$ir,$c,$userid,$h; $t=($db->fetch_row($db->query("SELECT * FROM bingo WHERE userid = {$ir['userid']}"))); echo"<center>Your callers numbers have been chosen.<br /> Click on the 'Matching Numbers' to show which numbers you matched.</center><br />"; echo "<center><table width=\"50%\" border=\"2\" bordercolor=\"blue\"> <tr height=50><td width=200><center><font size=\"3\">{$t['bingob1']}</font></center></td> <td width=200><center><font size=\"3\">{$t['bingoi1']}</font></center></td> <td width=200><center><font size=\"3\">{$t['bingon1']}</font></center></td> <td width=200><center><font size=\"3\">{$t['bingog1']}</font></center></td> <td width=200><center><font size=\"3\">{$t['bingoo1']}</font></center></td></tr> <tr height=50><td><center><font size=\"3\">{$t['bingob2']}</font></center></td> <td ><center><font size=\"3\">{$t['bingoi2']}</font></center></td> <td><center><font size=\"3\">{$t['bingon2']}</font></center></td> <td><center><font size=\"3\">{$t['bingog2']}</font></center></td> <td><center><font size=\"3\">{$t['bingoo2']}</font></center></td></tr> <tr height=50><td><center><font size=\"3\">{$t['bingob3']}</font></center></td> <td><center><font size=\"3\">{$t['bingoi3']}</font></center></td> <td><center><font size=\"3\">FREE</font></center></td> <td><center><font size=\"3\">{$t['bingog3']}</font></center></td> <td><center><font size=\"3\">{$t['bingoo3']}</font></center></td></tr> <tr height=50><td><center><font size=\"3\">{$t['bingob4']}</font></center></td> <td><center><font size=\"3\">{$t['bingoi4']}</font></center></td> <td><center><font size=\"3\">{$t['bingon3']}</font></center></td> <td><center><font size=\"3\">{$t['bingog4']}</font></center></td> <td><center><font size=\"3\">{$t['bingoo4']}</font></center></td></tr> <tr height=50><td><center><font size=\"3\">{$t['bingob5']}</font></center></td> <td><center><font size=\"3\">{$t['bingoi5']}</font></center></td> <td><center><font size=\"3\">{$t['bingon4']}</font></center></td> <td><center><font size=\"3\">{$t['bingog5']}</font></center></td> <td><center><font size=\"3\">{$t['bingoo5']}</font></center></td></tr> </table></center><br /><br />"; //Shuffles the typical 75 numbers for the caller numbers $set=array(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30, 31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60, 61,62,63,64,65,66,67,68,69,70,71,72,73,74,75); shuffle($set); $numberone=($set[0]); $numbertwo=($set[1]); $numberthree=($set[2]); $numberfour=($set[3]); $numberfive=($set[4]); $numbersix=($set[5]); $numberseven=($set[6]); $numbereight=($set[7]); $numbernine=($set[8]); $numberten=($set[9]); $numbereleven=($set[10]); $numbertwelve=($set[11]); $numberthirteen=($set[12]); $numberfourteen=($set[13]); $numberfifteen=($set[14]); $numbersixteen=($set[15]); $numberseventeen=($set[16]); $numbereighteen=($set[17]); $numbernineteen=($set[18]); $numbertwenty=($set[19]); $numbertwentyone=($set[20]); $numbertwentytwo=($set[21]); $numbertwentythree=($set[22]); $numbertwentyfour=($set[23]); $numbertwentyfive=($set[24]); $numbertwentysix=($set[25]); $numbertwentyseven=($set[26]); $numbertwentyeight=($set[27]); $numbertwentynine=($set[28]); $numberthirty=($set[29]); $numberthirtyone=($set[30]); $numberthirtytwo=($set[31]); $numberthirtythree=($set[32]); $numberthirtyfour=($set[33]); $numberthirtyfive=($set[34]); $numberthirtysix=($set[35]); $numberthirtyseven=($set[36]); $numberthirtyeight=($set[37]); $numberthirtynine=($set[38]); $numberfourty=($set[39]); $numberfourtyone=($set[40]); $numberfourtytwo=($set[41]); $numberfourtythree=($set[42]); $numberfourtyfour=($set[43]); $numberfourtyfive=($set[44]); $numberfourtysix=($set[45]); $numberfourtyseven=($set[46]); $numberfourtyeight=($set[47]); $numberfourtynine=($set[48]); $numberfifty=($set[49]); $numberfiftyone=($set[50]); $numberfiftytwo=($set[51]); $numberfiftythree=($set[52]); $numberfiftyfour=($set[53]); $numberfiftyfive=($set[54]); //Places the caller numbers into the tables for comparison $db->query("INSERT INTO bingotwo VALUES ('',{$ir['userid']}, {$numberone}, {$numbertwo}, {$numberthree}, {$numberfour}, {$numberfive}, {$numbersix}, {$numberseven}, {$numbereight}, {$numbernine}, {$numberten}, {$numbereleven}, {$numbertwelve}, {$numberthirteen}, {$numberfourteen}, {$numberfifteen}, {$numbersixteen}, {$numberseventeen}, {$numbereighteen}, {$numbernineteen}, {$numbertwenty}, {$numbertwentyone}, {$numbertwentytwo}, {$numbertwentythree}, {$numbertwentyfour},{$numbertwentyfive}, {$numbertwentysix}, {$numbertwentyseven}, {$numbertwentyeight},{$numbertwentynine}, {$numberthirty} )"); $db->query("INSERT INTO bingofour VALUES ('',{$ir['userid']}, {$numberone}, {$numbertwo}, {$numberthree}, {$numberfour}, {$numberfive}, {$numbersix}, {$numberseven}, {$numbereight}, {$numbernine}, {$numberten}, {$numbereleven}, {$numbertwelve}, {$numberthirteen}, {$numberfourteen}, {$numberfifteen}, {$numbersixteen}, {$numberseventeen}, {$numbereighteen}, {$numbernineteen}, {$numbertwenty}, {$numbertwentyone}, {$numbertwentytwo}, {$numbertwentythree}, {$numbertwentyfour},{$numbertwentyfive}, {$numbertwentysix}, {$numbertwentyseven}, {$numbertwentyeight},{$numbertwentynine}, {$numberthirty},{$numberthirtyone}, {$numberthirtytwo},{$numberthirtythree}, {$numberthirtyfour},{$numberthirtyfive},{$numberthirtysix},{$numberthirtyseven},{$numberthirtyeight},{$numberthirtynine},{$numberfourty} )"); $db->query("INSERT INTO bingofive VALUES ('',{$ir['userid']}, {$numberone}, {$numbertwo}, {$numberthree}, {$numberfour}, {$numberfive}, {$numbersix}, {$numberseven}, {$numbereight}, {$numbernine}, {$numberten}, {$numbereleven}, {$numbertwelve}, {$numberthirteen}, {$numberfourteen}, {$numberfifteen}, {$numbersixteen}, {$numberseventeen}, {$numbereighteen}, {$numbernineteen}, {$numbertwenty}, {$numbertwentyone}, {$numbertwentytwo}, {$numbertwentythree}, {$numbertwentyfour},{$numbertwentyfive}, {$numbertwentysix}, {$numbertwentyseven}, {$numbertwentyeight},{$numbertwentynine}, {$numberthirty},{$numberthirtyone}, {$numberthirtytwo},{$numberthirtythree}, {$numberthirtyfour},{$numberthirtyfive},{$numberthirtysix},{$numberthirtyseven},{$numberthirtyeight},{$numberthirtynine},{$numberfourty}, {$numberfourtyone},{$numberfourtytwo},{$numberfourtythree} )"); $db->query("INSERT INTO bingosix VALUES ('',{$ir['userid']}, {$numberone}, {$numbertwo}, {$numberthree}, {$numberfour}, {$numberfive}, {$numbersix}, {$numberseven}, {$numbereight}, {$numbernine}, {$numberten}, {$numbereleven}, {$numbertwelve}, {$numberthirteen}, {$numberfourteen}, {$numberfifteen}, {$numbersixteen}, {$numberseventeen}, {$numbereighteen}, {$numbernineteen}, {$numbertwenty}, {$numbertwentyone}, {$numbertwentytwo}, {$numbertwentythree}, {$numbertwentyfour},{$numbertwentyfive}, {$numbertwentysix}, {$numbertwentyseven}, {$numbertwentyeight},{$numbertwentynine}, {$numberthirty},{$numberthirtyone}, {$numberthirtytwo},{$numberthirtythree}, {$numberthirtyfour},{$numberthirtyfive},{$numberthirtysix},{$numberthirtyseven},{$numberthirtyeight},{$numberthirtynine},{$numberfourty}, {$numberfourtyone},{$numberfourtytwo},{$numberfourtythree},{$numberfourtyfour},{$numberfourtyfive} )"); $db->query("INSERT INTO bingoseven VALUES ('',{$ir['userid']}, {$numberone}, {$numbertwo}, {$numberthree}, {$numberfour}, {$numberfive}, {$numbersix}, {$numberseven}, {$numbereight}, {$numbernine}, {$numberten}, {$numbereleven}, {$numbertwelve}, {$numberthirteen}, {$numberfourteen}, {$numberfifteen}, {$numbersixteen}, {$numberseventeen}, {$numbereighteen}, {$numbernineteen}, {$numbertwenty}, {$numbertwentyone}, {$numbertwentytwo}, {$numbertwentythree}, {$numbertwentyfour},{$numbertwentyfive}, {$numbertwentysix}, {$numbertwentyseven}, {$numbertwentyeight},{$numbertwentynine}, {$numberthirty},{$numberthirtyone}, {$numberthirtytwo},{$numberthirtythree}, {$numberthirtyfour},{$numberthirtyfive},{$numberthirtysix},{$numberthirtyseven},{$numberthirtyeight},{$numberthirtynine},{$numberfourty}, {$numberfourtyone},{$numberfourtytwo},{$numberfourtythree},{$numberfourtyfour},{$numberfourtyfive},{$numberfourtysix},{$numberfourtyseven}, {$numberfourtyeight} )"); $db->query("INSERT INTO bingoeight VALUES ('',{$ir['userid']}, {$numberone}, {$numbertwo}, {$numberthree}, {$numberfour}, {$numberfive}, {$numbersix}, {$numberseven}, {$numbereight}, {$numbernine}, {$numberten}, {$numbereleven}, {$numbertwelve}, {$numberthirteen}, {$numberfourteen}, {$numberfifteen}, {$numbersixteen}, {$numberseventeen}, {$numbereighteen}, {$numbernineteen}, {$numbertwenty}, {$numbertwentyone}, {$numbertwentytwo}, {$numbertwentythree}, {$numbertwentyfour},{$numbertwentyfive}, {$numbertwentysix}, {$numbertwentyseven}, {$numbertwentyeight},{$numbertwentynine}, {$numberthirty},{$numberthirtyone}, {$numberthirtytwo},{$numberthirtythree}, {$numberthirtyfour},{$numberthirtyfive},{$numberthirtysix},{$numberthirtyseven},{$numberthirtyeight},{$numberthirtynine},{$numberfourty}, {$numberfourtyone},{$numberfourtytwo},{$numberfourtythree},{$numberfourtyfour},{$numberfourtyfive},{$numberfourtysix},{$numberfourtyseven}, {$numberfourtyeight},{$numberfourtynine},{$numberfifty} )"); $db->query("INSERT INTO bingonine VALUES ('',{$ir['userid']}, {$numberone}, {$numbertwo}, {$numberthree}, {$numberfour}, {$numberfive}, {$numbersix}, {$numberseven}, {$numbereight}, {$numbernine}, {$numberten}, {$numbereleven}, {$numbertwelve}, {$numberthirteen}, {$numberfourteen}, {$numberfifteen}, {$numbersixteen}, {$numberseventeen}, {$numbereighteen}, {$numbernineteen}, {$numbertwenty}, {$numbertwentyone}, {$numbertwentytwo}, {$numbertwentythree}, {$numbertwentyfour},{$numbertwentyfive}, {$numbertwentysix}, {$numbertwentyseven}, {$numbertwentyeight},{$numbertwentynine}, {$numberthirty},{$numberthirtyone}, {$numberthirtytwo},{$numberthirtythree}, {$numberthirtyfour},{$numberthirtyfive},{$numberthirtysix},{$numberthirtyseven},{$numberthirtyeight},{$numberthirtynine},{$numberfourty}, {$numberfourtyone},{$numberfourtytwo},{$numberfourtythree},{$numberfourtyfour},{$numberfourtyfive},{$numberfourtysix},{$numberfourtyseven}, {$numberfourtyeight},{$numberfourtynine},{$numberfifty},{$numberfiftyone},{$numberfiftytwo},{$numberfiftythree},{$numberfiftyfour}, {$numberfiftyfive} )"); echo"<center><a href='displaymatching.php'>Matching Numbers for 4 corners</a></center>"; } $h->endpage(); ?>
-
Here is a free bingo game that I made. I'm sure others could do it more efficiently than I have, but I am proud of it none the less. No ... it's not secured, as I have no idea how do that. If someone else in the community wishes to do that, then that would be great. Enjoy!! The tables are cleared when the player clicks play again on the full card or when they start on the bingo.php. Tables: CREATE TABLE IF NOT EXISTS `bingo` ( `bingoID` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL,`bingob1` int(11) NOT NULL, `bingob2` int(11) NOT NULL, `bingob3` int(11) NOT NULL, `bingob4` int(11) NOT NULL, `bingob5` int(11) NOT NULL, `bingoi1` int(11) NOT NULL, `bingoi2` int(11) NOT NULL, `bingoi3` int(11) NOT NULL, `bingoi4` int(11) NOT NULL, `bingoi5` int(11) NOT NULL, `bingon1` int(11) NOT NULL, `bingon2` int(11) NOT NULL, `bingon3` int(11) NOT NULL, `bingon4` int(11) NOT NULL, `bingog1` int(11) NOT NULL, `bingog2` int(11) NOT NULL, `bingog3` int(11) NOT NULL, `bingog4` int(11) NOT NULL, `bingog5` int(11) NOT NULL, `bingoo1` int(11) NOT NULL, `bingoo2` int(11) NOT NULL, `bingoo3` int(11) NOT NULL, `bingoo4` int(11) NOT NULL, `bingoo5` int(11) NOT NULL, PRIMARY KEY (`bingoID`) ) TYPE=MYISAM ; CREATE TABLE IF NOT EXISTS `bingotwo` ( `bingoID` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL, `number1` int(11) NOT NULL, `number2` int(11) NOT NULL, `number3` int(11) NOT NULL, `number4` int(11) NOT NULL, `number5` int(11) NOT NULL, `number6` int(11) NOT NULL, `number7` int(11) NOT NULL, `number8` int(11) NOT NULL, `number9` int(11) NOT NULL, `number10` int(11) NOT NULL, `number11` int(11) NOT NULL, `number12` int(11) NOT NULL, `number13` int(11) NOT NULL, `number14` int(11) NOT NULL, `number15` int(11) NOT NULL, `number16` int(11) NOT NULL, `number17` int(11) NOT NULL, `number18` int(11) NOT NULL, `number19` int(11) NOT NULL, `number20` int(11) NOT NULL, `number21` int(11) NOT NULL, `number22` int(11) NOT NULL, `number23` int(11) NOT NULL, `number24` int(11) NOT NULL, `number25` int(11) NOT NULL, `number26` int(11) NOT NULL, `number27` int(11) NOT NULL, `number28` int(11) NOT NULL, `number29` int(11) NOT NULL, `number30` int(11) NOT NULL, PRIMARY KEY (`bingoID`) ) TYPE=MYISAM ; CREATE TABLE IF NOT EXISTS `bingothree` ( `bingoID` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL, `bingob1` int(11) NOT NULL, `bingob2` int(11) NOT NULL, `bingob3` int(11) NOT NULL, `bingob4` int(11) NOT NULL, `bingob5` int(11) NOT NULL, `bingoi1` int(11) NOT NULL, `bingoi2` int(11) NOT NULL, `bingoi3` int(11) NOT NULL, `bingoi4` int(11) NOT NULL, `bingoi5` int(11) NOT NULL, `bingon1` int(11) NOT NULL, `bingon2` int(11) NOT NULL, `bingon3` int(11) NOT NULL, `bingon4` int(11) NOT NULL, `bingon5` int(11) NOT NULL, `bingog1` int(11) NOT NULL, `bingog2` int(11) NOT NULL, `bingog3` int(11) NOT NULL, `bingog4` int(11) NOT NULL, `bingog5` int(11) NOT NULL, `bingoo1` int(11) NOT NULL, `bingoo2` int(11) NOT NULL, `bingoo3` int(11) NOT NULL, `bingoo4` int(11) NOT NULL, `bingoo5` int(11) NOT NULL, PRIMARY KEY (`bingoID`) ) TYPE=MYISAM ; CREATE TABLE IF NOT EXISTS `bingofour` ( `bingoID` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL, `number1` int(11) NOT NULL, `number2` int(11) NOT NULL, `number3` int(11) NOT NULL, `number4` int(11) NOT NULL, `number5` int(11) NOT NULL, `number6` int(11) NOT NULL, `number7` int(11) NOT NULL, `number8` int(11) NOT NULL, `number9` int(11) NOT NULL, `number10` int(11) NOT NULL, `number11` int(11) NOT NULL, `number12` int(11) NOT NULL, `number13` int(11) NOT NULL, `number14` int(11) NOT NULL, `number15` int(11) NOT NULL, `number16` int(11) NOT NULL, `number17` int(11) NOT NULL, `number18` int(11) NOT NULL, `number19` int(11) NOT NULL, `number20` int(11) NOT NULL, `number21` int(11) NOT NULL, `number22` int(11) NOT NULL, `number23` int(11) NOT NULL, `number24` int(11) NOT NULL, `number25` int(11) NOT NULL, `number26` int(11) NOT NULL, `number27` int(11) NOT NULL, `number28` int(11) NOT NULL, `number29` int(11) NOT NULL, `number30` int(11) NOT NULL, `number31` int(11) NOT NULL, `number32` int(11) NOT NULL, `number33` int(11) NOT NULL, `number34` int(11) NOT NULL, `number35` int(11) NOT NULL, `number36` int(11) NOT NULL, `number37` int(11) NOT NULL, `number38` int(11) NOT NULL, `number39` int(11) NOT NULL, `number40` int(11) NOT NULL, PRIMARY KEY (`bingoID`) ) TYPE=MYISAM ; CREATE TABLE IF NOT EXISTS `bingofive` ( `bingoID` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL, `number1` int(11) NOT NULL, `number2` int(11) NOT NULL, `number3` int(11) NOT NULL, `number4` int(11) NOT NULL, `number5` int(11) NOT NULL, `number6` int(11) NOT NULL, `number7` int(11) NOT NULL, `number8` int(11) NOT NULL, `number9` int(11) NOT NULL, `number10` int(11) NOT NULL, `number11` int(11) NOT NULL, `number12` int(11) NOT NULL, `number13` int(11) NOT NULL, `number14` int(11) NOT NULL, `number15` int(11) NOT NULL, `number16` int(11) NOT NULL, `number17` int(11) NOT NULL, `number18` int(11) NOT NULL, `number19` int(11) NOT NULL, `number20` int(11) NOT NULL, `number21` int(11) NOT NULL, `number22` int(11) NOT NULL, `number23` int(11) NOT NULL, `number24` int(11) NOT NULL, `number25` int(11) NOT NULL, `number26` int(11) NOT NULL, `number27` int(11) NOT NULL, `number28` int(11) NOT NULL, `number29` int(11) NOT NULL, `number30` int(11) NOT NULL, `number31` int(11) NOT NULL, `number32` int(11) NOT NULL, `number33` int(11) NOT NULL, `number34` int(11) NOT NULL, `number35` int(11) NOT NULL, `number36` int(11) NOT NULL, `number37` int(11) NOT NULL, `number38` int(11) NOT NULL, `number39` int(11) NOT NULL, `number40` int(11) NOT NULL, `number41` int(11) NOT NULL, `number42` int(11) NOT NULL, `number43` int(11) NOT NULL, PRIMARY KEY (`bingoID`) ) TYPE=MYISAM ; CREATE TABLE IF NOT EXISTS `bingosix` ( `bingoID` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL, `number1` int(11) NOT NULL, `number2` int(11) NOT NULL, `number3` int(11) NOT NULL, `number4` int(11) NOT NULL, `number5` int(11) NOT NULL, `number6` int(11) NOT NULL, `number7` int(11) NOT NULL, `number8` int(11) NOT NULL, `number9` int(11) NOT NULL, `number10` int(11) NOT NULL, `number11` int(11) NOT NULL, `number12` int(11) NOT NULL, `number13` int(11) NOT NULL, `number14` int(11) NOT NULL, `number15` int(11) NOT NULL, `number16` int(11) NOT NULL, `number17` int(11) NOT NULL, `number18` int(11) NOT NULL, `number19` int(11) NOT NULL, `number20` int(11) NOT NULL, `number21` int(11) NOT NULL, `number22` int(11) NOT NULL, `number23` int(11) NOT NULL, `number24` int(11) NOT NULL, `number25` int(11) NOT NULL, `number26` int(11) NOT NULL, `number27` int(11) NOT NULL, `number28` int(11) NOT NULL, `number29` int(11) NOT NULL, `number30` int(11) NOT NULL, `number31` int(11) NOT NULL, `number32` int(11) NOT NULL, `number33` int(11) NOT NULL, `number34` int(11) NOT NULL, `number35` int(11) NOT NULL, `number36` int(11) NOT NULL, `number37` int(11) NOT NULL, `number38` int(11) NOT NULL, `number39` int(11) NOT NULL, `number40` int(11) NOT NULL, `number41` int(11) NOT NULL, `number42` int(11) NOT NULL, `number43` int(11) NOT NULL, `number44` int(11) NOT NULL, `number45` int(11) NOT NULL, PRIMARY KEY (`bingoID`) ) TYPE=MYISAM ; CREATE TABLE IF NOT EXISTS `bingoseven` ( `bingoID` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL, `number1` int(11) NOT NULL, `number2` int(11) NOT NULL, `number3` int(11) NOT NULL, `number4` int(11) NOT NULL, `number5` int(11) NOT NULL, `number6` int(11) NOT NULL, `number7` int(11) NOT NULL, `number8` int(11) NOT NULL, `number9` int(11) NOT NULL, `number10` int(11) NOT NULL, `number11` int(11) NOT NULL, `number12` int(11) NOT NULL, `number13` int(11) NOT NULL, `number14` int(11) NOT NULL, `number15` int(11) NOT NULL, `number16` int(11) NOT NULL, `number17` int(11) NOT NULL, `number18` int(11) NOT NULL, `number19` int(11) NOT NULL, `number20` int(11) NOT NULL, `number21` int(11) NOT NULL, `number22` int(11) NOT NULL, `number23` int(11) NOT NULL, `number24` int(11) NOT NULL, `number25` int(11) NOT NULL, `number26` int(11) NOT NULL, `number27` int(11) NOT NULL, `number28` int(11) NOT NULL, `number29` int(11) NOT NULL, `number30` int(11) NOT NULL, `number31` int(11) NOT NULL, `number32` int(11) NOT NULL, `number33` int(11) NOT NULL, `number34` int(11) NOT NULL, `number35` int(11) NOT NULL, `number36` int(11) NOT NULL, `number37` int(11) NOT NULL, `number38` int(11) NOT NULL, `number39` int(11) NOT NULL, `number40` int(11) NOT NULL, `number41` int(11) NOT NULL, `number42` int(11) NOT NULL, `number43` int(11) NOT NULL, `number44` int(11) NOT NULL, `number45` int(11) NOT NULL, `number46` int(11) NOT NULL, `number47` int(11) NOT NULL, `number48` int(11) NOT NULL, PRIMARY KEY (`bingoID`) ) TYPE=MYISAM ; CREATE TABLE IF NOT EXISTS `bingoeight` ( `bingoID` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL, `number1` int(11) NOT NULL, `number2` int(11) NOT NULL, `number3` int(11) NOT NULL, `number4` int(11) NOT NULL, `number5` int(11) NOT NULL, `number6` int(11) NOT NULL, `number7` int(11) NOT NULL, `number8` int(11) NOT NULL, `number9` int(11) NOT NULL, `number10` int(11) NOT NULL, `number11` int(11) NOT NULL, `number12` int(11) NOT NULL, `number13` int(11) NOT NULL, `number14` int(11) NOT NULL, `number15` int(11) NOT NULL, `number16` int(11) NOT NULL, `number17` int(11) NOT NULL, `number18` int(11) NOT NULL, `number19` int(11) NOT NULL, `number20` int(11) NOT NULL, `number21` int(11) NOT NULL, `number22` int(11) NOT NULL, `number23` int(11) NOT NULL, `number24` int(11) NOT NULL, `number25` int(11) NOT NULL, `number26` int(11) NOT NULL, `number27` int(11) NOT NULL, `number28` int(11) NOT NULL, `number29` int(11) NOT NULL, `number30` int(11) NOT NULL, `number31` int(11) NOT NULL, `number32` int(11) NOT NULL, `number33` int(11) NOT NULL, `number34` int(11) NOT NULL, `number35` int(11) NOT NULL, `number36` int(11) NOT NULL, `number37` int(11) NOT NULL, `number38` int(11) NOT NULL, `number39` int(11) NOT NULL, `number40` int(11) NOT NULL, `number41` int(11) NOT NULL, `number42` int(11) NOT NULL, `number43` int(11) NOT NULL, `number44` int(11) NOT NULL, `number45` int(11) NOT NULL, `number46` int(11) NOT NULL, `number47` int(11) NOT NULL, `number48` int(11) NOT NULL, `number49` int(11) NOT NULL, `number50` int(11) NOT NULL, PRIMARY KEY (`bingoID`) ) TYPE=MYISAM ; CREATE TABLE IF NOT EXISTS `bingonine` ( `bingoID` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL, `number1` int(11) NOT NULL, `number2` int(11) NOT NULL, `number3` int(11) NOT NULL, `number4` int(11) NOT NULL, `number5` int(11) NOT NULL, `number6` int(11) NOT NULL, `number7` int(11) NOT NULL, `number8` int(11) NOT NULL, `number9` int(11) NOT NULL, `number10` int(11) NOT NULL, `number11` int(11) NOT NULL, `number12` int(11) NOT NULL, `number13` int(11) NOT NULL, `number14` int(11) NOT NULL, `number15` int(11) NOT NULL, `number16` int(11) NOT NULL, `number17` int(11) NOT NULL, `number18` int(11) NOT NULL, `number19` int(11) NOT NULL, `number20` int(11) NOT NULL, `number21` int(11) NOT NULL, `number22` int(11) NOT NULL, `number23` int(11) NOT NULL, `number24` int(11) NOT NULL, `number25` int(11) NOT NULL, `number26` int(11) NOT NULL, `number27` int(11) NOT NULL, `number28` int(11) NOT NULL, `number29` int(11) NOT NULL, `number30` int(11) NOT NULL, `number31` int(11) NOT NULL, `number32` int(11) NOT NULL, `number33` int(11) NOT NULL, `number34` int(11) NOT NULL, `number35` int(11) NOT NULL, `number36` int(11) NOT NULL, `number37` int(11) NOT NULL, `number38` int(11) NOT NULL, `number39` int(11) NOT NULL, `number40` int(11) NOT NULL, `number41` int(11) NOT NULL, `number42` int(11) NOT NULL, `number43` int(11) NOT NULL, `number44` int(11) NOT NULL, `number45` int(11) NOT NULL, `number46` int(11) NOT NULL, `number47` int(11) NOT NULL, `number48` int(11) NOT NULL, `number49` int(11) NOT NULL, `number50` int(11) NOT NULL, `number51` int(11) NOT NULL, `number52` int(11) NOT NULL, `number53` int(11) NOT NULL, `number54` int(11) NOT NULL, `number55` int(11) NOT NULL, PRIMARY KEY (`bingoID`) ) TYPE=MYISAM ;
-
OR ... you could have it stalemate at 100 hits. Just a thought.
-
Why would you want to restart it? What exactly is it that you want to restart?
-
Thank you, Spudinski. Sorry for the delay in responding to this. This works wonderfully. I do have a question though. With the shuffle of the second set of numbers ... I actually only use 55 of them. The way it works is this ... the first compare is 30 numbers, then the next 5, then the next five and so on until all 55 numbers have been compared. These 55 numbers stay constant throughout all the compares being done. It's like in a real life bingo where the numbers are called and compared. My question is this ... is there a way to just compare the first 30 numbers pulled. Then in the next compare adding the next 5 numbers giving 35 to compare and so on?
-
if ($ir['money'] < $total) { echo"You don't have enough money to do this." } else { mysql_query("UPDATE users SET money=money- '$total' WHERE username='$username'"); } I wonder why you are using the username as opposed to the userid though. The userid stays constant whereas the username does not. Oops. Just noticed that sniko stated that as well.
-
Just because something looks similar does not mean that it was/is someone elses mod. Not all mods posted are original ideas. People can have the same idea and work it in different ways.
-
Best of luck to you ruler ... you will be missed.
-
That's not really fair to those of us who DO come here looking for help, advice, do research, contacting others etc.
-
Such as? I've looked at comparison type functions, obviously I am missing something because none seem to fit the bill. Perhaps a little more explanation; 1. A shuffle of 75 numbers is done and the base 25 is pulled. 2. A second shuffle of 75 numbers is done. 3. For the first comparison ... it takes 30 numbers from the second shuffle and compares each of those 30 against the base 25 of the first shuffle.
-
Okay ... so I've managed to create a bingo game for my game. The problem I am having is trying to reduce the number of queries being done. For each variation it has to check upwards to 55 numbers and compare them against a base of 25 numbers. You can see based on that the length of code that is involved by the way I have done this. I am sure there is a shorter way of doing this, if anyone has any ideas. I am just including one snippet of it for you to see. This is just comparing the first number of the base 25. It works fine the way it is now. No errors. Displays the way it should etc. I just know there is a way to reduce the code and queries ... I just can't figure it out. I would like to put this out there as a free mod ... posting all of that code would take hours. *laughs* Thanks in advance for your ideas and suggestions. Here's the snippet; if ($m['number1']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number2']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number3']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number4']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number5']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number6']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number7']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number8']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number9']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number10']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number11']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number12']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number13']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number14']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number15']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number16']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number17']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number18']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number19']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number20']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number21']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number22']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number23']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number24']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number25']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number26']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number27']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number28']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number29']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } elseif ($m['number30']==$t['bingob1']) { echo"<tr height=50><td width=200><center><font size=3 color=darkred>{$t['bingob1']}</font></center></td>"; $db->query("UPDATE bingothree SET bingob1=1 WHERE userid={$ir['userid']}"); } else { echo"<tr height=50><td width=200><center><font size=3>{$t['bingob1']}</font></center></td>"; }