0 Members and 1 Guest are viewing this topic.
<style type="text/css">input.lottobutton{ background-color:#33CC00; border: none; font: 100% Verdana, Arial, Helvetica, sans-serif; margin: 1px 1px 1px 1px; width: 26px; height: 26px;}input.lottobutton2{ background-color: #CCCCCC; border: none; font: 100% Verdana, Arial, Helvetica, sans-serif; margin: 1px 1px 1px 1px; width: 26px; height: 26px;}input.lottobutton3{ background-color: #FFFF00; border: none; font: 100% Verdana, Arial, Helvetica, sans-serif; margin: 1px 1px 1px 1px; width: 26px; height: 26px;}</style><?php//$cklotq=$Db1->query("SELECT * FROM ls_config WHERE ls_id='1'");$lot_config=$Db1->fetch_array($cklotq);$includes[title]="Lottery"; if($lot_config['ls_loton'] == "1"){ if($_POST) { if($newbalance<=-0.00001) { $money = $thismemberinfo['balance']; } else { $money = $newbalance; } if($money>$lot_config["ls_price"]) { $ticketprice=$lot_config["ls_price"]; $username=$thismemberinfo['username']; $number=$_POST['nr']; $ticketquery = "INSERT INTO jackpot (username,ticket_num) VALUES('$username','$number')"; $Db1->query($ticketquery); $ticketprice=$lot_config["ls_price"]; $newbalance=$thismemberinfo[balance]-$ticketprice; $Db1->query("UPDATE user SET balance='$newbalance' WHERE username='$username'"); $money=$newbalance; $nrticketquery = $Db1->query("SELECT COUNT(*) AS tot FROM jackpot"); $rows=$Db1->num_rows($nrticketquery); $i=0; if($rows > $i) { while($x = $Db1->fetch_array($nrticketquery)) { $ticketsbought = $x['tot']; } } else { $ticketsbought=0; } $error_msg="You have just purchased a ticket ... Good luck !!!"; } //--------------------------------- IF ALL TICKETS ARE BOUGHT --------------------------------------- if($ticketsbought>=100) { //These variables are the real amount of money the user will recieve. You can change them if you want. $prize1=$lot_config["ls_prize1"]; $prize2=$lot_config["ls_prize2"]; $prize3=$lot_config["ls_prize3"]; $prize4=$lot_config["ls_prize4"]; $queryinsertnr = "INSERT INTO jackpot (username,ticket_num) VALUES('$username','$numberofticket')"; $Db1->query($queryinsertnr); $winningnr1 = mt_rand(1,100); $selectw1 = $Db1->query("SELECT * FROM jackpot WHERE ticket_num='$winningnr1'"); $username1 = $Db1->fetch_array($selectw1); $winner1 = $username1['username']; $luckynr1 = $username1['ticket_num']; $userwinner1 = $Db1->query("SELECT * FROM user WHERE username='$winner1'"); $userwin1 = $Db1->fetch_array($userwinner1); $newbalance1 = $userwin1['balance']+$prize1; $Db1->query("UPDATE user SET balance='$newbalance1' WHERE username='$winner1'"); $winningnr2 = mt_rand(1,100); if($winningnr2=$winningnr1) { $winningnr2 = mt_rand(1,100); } $selectw2 = $Db1->query("SELECT * FROM jackpot WHERE ticket_num='$winningnr2'"); $username2 = $Db1->fetch_array($selectw2); $winner2 = $username2['username']; $luckynr2 = $username2['ticket_num']; $userwinner2 = $Db1->query("SELECT * FROM user WHERE username='$winner2'"); $userwin2 = $Db1->fetch_array($userwinner2); $newbalance2 = $userwin2['balance']+$prize2; $Db1->query("UPDATE user SET balance='$newbalance2' WHERE username='$winner2'"); $winningnr3 = mt_rand(1,100); if($winningnr3=$winningnr1) { if($winningnr3=$winningnr2) { $winningnr3 = mt_rand(1,100); } } $selectw3 = $Db1->query("SELECT * FROM jackpot WHERE ticket_num='$winningnr3'"); $username3 = $Db1->fetch_array($selectw3); $winner3 = $username3['username']; $luckynr3 = $username3['ticket_num']; $userwinner3 = $Db1->query("SELECT * FROM user WHERE username='$winner3'"); $userwin3 = $Db1->fetch_array($userwinner3); $newbalance3 = $userwin3['balance']+$prize3; $Db1->query("UPDATE user SET balance='$newbalance3' WHERE username='$winner3'"); $winningnr4 = mt_rand(1,100); if($winningnr4=$winningnr1) { if($winningnr4=$winningnr2) { if($winningnr4=$winningnr3) { $winningnr4 = mt_rand(1,100); } } } $selectw4 = $Db1->query("SELECT * FROM jackpot WHERE ticket_num='$winningnr4'"); $username4 = $Db1->fetch_array($selectw4); $winner4 = $username4['username']; $luckynr4 = $username4['ticket_num']; $userwinner4 = $Db1->query("SELECT * FROM user WHERE username='$winner4'"); $userwin4 = $Db1->fetch_array($userwinner4); $newbalance4 = $userwin4['balance']+$prize4; $Db1->query("UPDATE user SET balance='$newbalance4' WHERE username='$winner4'"); $Db1->query("INSERT INTO lottowinners (username1,ticket_num1,username2,ticket_num2,username3,ticket_num3,username4,ticket_num4) VALUES('$winner1','$winningnr1','$winner2','$winningnr2','$winner3','$winningnr3','$winner4','$winningnr4')"); //As all tickets were bought, balance was given and data inserted into the new database, we can now remove all data from the ticket info, so that we can start the lottery again. $Db1->query("TRUNCATE TABLE jackpot"); }}$includes[content]="<div style='background-color:#000000; float: left; border: 1px solid #000000; height: 280px; width: 282px'><form method='post' action='index.php?view=account&ac=lottery&{$url_variables}'>";//This will check the user's balanceif($newbalance<=-0.00001){ $money = $thismemberinfo['balance'];} else { $money = $newbalance;}if($money<=$lot_config["ls_price"]){ $ticketnumcheck = 1; while($ticketnumcheck<=100) { $result = $Db1->query("SELECT * FROM jackpot WHERE ticket_num='{$ticketnumcheck}'"); if($Db1->num_rows($result) == 0) { $includes[content].="<input type='button' class='lottobutton' value='{$ticketnumcheck}'>"; } else { $ticketname=$result['username']; $sqlquerycheck = "SELECT * FROM jackpot WHERE ticket_num='{$ticketnumcheck}'"; $resultquerycheck = $Db1->query($sqlquerycheck); $checker = $Db1->fetch_array($resultquerycheck); if($thismemberinfo[username]!=$checker['username']) { $includes[content].="<input type='button' class='lottobutton2' value='{$ticketnumcheck}'>"; } else { $includes[content].="<input type='button' class='lottobutton3' value='{$ticketnumcheck}'>"; } } //Adding the ticket number to check . If it's still less than 100 it'll do this again. Otherwise it'll show the message next ++$ticketnumcheck; } $includes[content].="</div><br>If you want to purchase a ticket, you will need $".$lot_config["ls_price"]." in your balance. <br> You currently have \${$money} in your balance. </form>"; //If the user has enough money...}else{ $ticketnumcheck = 1; while($ticketnumcheck<=100) { $result = $Db1->query("SELECT * FROM jackpot WHERE ticket_num='{$ticketnumcheck}'"); //If there is no value there if($Db1->num_rows($result) == 0) { $includes[content].="<input type='submit' name='nr' class='lottobutton' value='{$ticketnumcheck}' onMouseOver='goLite(this.form.name,this.name)' onMouseOut='goDim(this.form.name,this.name)'>"; } else { //Checking everything (This is the same as before) $name=$result['username']; $sqlquerycheck = "SELECT * FROM jackpot WHERE ticket_num='{$ticketnumcheck}'"; $resultquerycheck = $Db1->query($sqlquerycheck); $checker = $Db1->fetch_array($resultquerycheck); if($thismemberinfo[username]!=$checker['username']) { $includes[content].="<input type='button' class='lottobutton2' value='{$ticketnumcheck}'>"; } else { $includes[content].="<input type='button' class='lottobutton3' value='{$ticketnumcheck}'>"; } } ++$ticketnumcheck; } $money=abs($money); $includes[content].="</div>You currently have \${$money} in your balance.</form><br><br>";}$includes[content].="<div style='margin-left: 10px; float:left'><table style='font-size: 11px;' width='300px;' border='0'> <tr> <td style='margin: 2px 2px 2px 2px;'width='50%'> <p align='left'><br><br> <b>First prize:</b> ${$lot_config[ls_prize1]}<br> <b>Second prize:</b> ${$lot_config[ls_prize2]}<br> <b>Third prize:</b> ${$lot_config[ls_prize3]}<br> <b>Fourth prize:</b> ${$lot_config[ls_prize4]}<br> <p> </td> <td width='50%'><strong>Price per ticket:</strong><br> ${$lot_config[ls_price]}</td> </tr></table><p align='left'>Instructions:<br>-A Green box means the ticket is still available.<br>-A Gray box means the ticket is unavailable.<br>-A Yellow box means you bought that ticket.</p><br class='clearfloat'>";$includes[content].="<br><br>Last drawings winners: <br><table><tr><th><center>Round</center></th><th><center>1st #</center></th><th><center>2nd #</center></th><th><center>3rd #</center></th><th><center>4th #</center></th></tr>";$result = $Db1->query("SELECT * FROM lottowinners ORDER BY id DESC limit 5");while($checker = $Db1->fetch_array($result)){ $includes[content].="<tr> <td><center>{$checker['id']}</center></td> <td><center>{$checker[ticket_num1]}</center></td> <td><center>{$checker[ticket_num2]}</center></td> <td><center>{$checker[ticket_num3]}</center></td> <td><center>{$checker[ticket_num4]}</center></td> </tr>";}$includes[content].="</table></div>";}else {echo "Lottery is not enabled in this site";}?>
<?$includes[title]="Lottery Settings";//**S**//if(($action == "save") && ($working == 1)) { $enabled = $lot_enabled; $price = $ls_price; $l1st = $ls_prize1; $l2nd = $ls_prize2; $l3rd = $ls_prize3; $l4th = $ls_prize4; $Db1->query("UPDATE ls_config SET ls_loton='".$enabled."', ls_price='".$price."', ls_prize1='".$l1st."', ls_prize2='".$l2nd."', ls_prize3='".$l3rd."', ls_prize4='".$l4th."' WHERE ls_id='1' LIMIT 1"); $Db1->sql_close(); header("Location: admin.php?view=admin&ac=settings&type=lottery&saved=1&".$url_variables."");}$lsconf=$Db1->query("SELECT * FROM ls_config WHERE ls_id='1' LIMIT 1");$lot_config=$Db1->fetch_array($lsconf);$includes[content]="".iif($saved==1,"<font color=\"darkgreen\">The settings have been saved</font>")."<form action=\"admin.php?view=admin&ac=settings&action=save&type=lottery&".$url_variables."\" method=\"post\" name=\"form\"><input type=\"hidden\" name=\"working\" value=\"1\"><table width=\"100%\"> <tr> <td width=\"250\"><b>Lottery Enabled?: </b></td> <td><input type=\"checkbox\" name=\"lot_enabled\" value=\"1\"".iif($lot_config[ls_loton] == 1," checked=\"checked\"")."></td> </tr> <tr> <td width=\"250\"><b>Lottery Ticket Price: </b></td> <td><input type=\"text\" name=\"ls_price\" value=\"$lot_config[ls_price]\">( How much a member needs to pay for a number)</td> </tr> <tr> <td width=\"250\"><b>How much win 1st Winner: </b></td> <td><input type=\"text\" name=\"ls_prize1\" value=\"$lot_config[ls_prize1]\"> (Winning amount for 1st ticket draw)</td> </tr> <tr> <td width=\"250\"><b>How much win 2nd Winner: </b></td> <td><input type=\"text\" name=\"ls_prize2\" value=\"$lot_config[ls_prize2]\"> </td> </tr> <tr> <td width=\"250\"><b>How much win the 3rd Winner?: </b></td> <td><input type=\"text\" name=\"ls_prize3\" value=\"$lot_config[ls_prize3]\"> </td> </tr> <tr> <td width=\"250\"><b>How much win the 4th Winner?: </b></td> <td><input type=\"text\" name=\"ls_prize4\" value=\"$lot_config[ls_prize4]\"> </td> </tr> <tr> <td colspan=2 align=\"right\"><input type=\"submit\" value=\"Save\"></td> </tr></table><div align=\"right\"></div></form>";?>
$module['account'] = array("Account","members/account.php",1);
$module['lottery'] = array("Lottery","members/lottery.php",1);
CREATE TABLE IF NOT EXISTS `ls_config` (`ls_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,`ls_loton` TINYINT( 1 ) NOT NULL ,`ls_price` DECIMAL( 12, 5 ) NOT NULL ,`ls_prize1` DECIMAL( 12, 5 ) NOT NULL ,`ls_prize2` DECIMAL( 12, 5 ) NOT NULL ,`ls_prize3` DECIMAL( 12, 5 ) NOT NULL ,`ls_prize4` DECIMAL( 12, 5 ) NOT NULL) ENGINE = MYISAM ;INSERT INTO `ls_config` (`ls_id`, `ls_loton`, `ls_price`, `ls_prize1`, `ls_prize2`, `ls_prize3`, `ls_prize4`) VALUES (NULL, '1', '0.50', '0.80', '0.70', '0.60', '0.50');CREATE TABLE IF NOT EXISTS `jackpot` ( `username` varchar(100) NOT NULL, `ticket_num` varchar(100) NOT NULL, UNIQUE KEY `ticket_num` (`ticket_num`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;CREATE TABLE IF NOT EXISTS `lottowinners` ( `id` int(11) NOT NULL auto_increment, `username1` varchar(100) NOT NULL, `ticket_num1` varchar(100) NOT NULL, `username2` varchar(100) NOT NULL, `ticket_num2` varchar(100) NOT NULL, `username3` varchar(100) NOT NULL, `ticket_num3` varchar(100) NOT NULL, `username4` varchar(100) NOT NULL, `ticket_num4` varchar(100) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `lottowinners` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user' at line 1
error in query partQuote#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS `lottowinners` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user' at line 1
CREATE TABLE IF NOT EXISTS `lottowinners` ( `id` int(11) NOT NULL auto_increment, `username1` varchar(100) NOT NULL, `ticket_num1` varchar(100) NOT NULL, `username2` varchar(100) NOT NULL, `ticket_num2` varchar(100) NOT NULL, `username3` varchar(100) NOT NULL, `ticket_num3` varchar(100) NOT NULL, `username4` varchar(100) NOT NULL, `ticket_num4` varchar(100) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Its working but only problem. You can check problem yourself.
<b>First prize:</b> \${$lot_config[ls_prize1]}<br> <b>Second prize:</b> \${$lot_config[ls_prize2]}<br> <b>Third prize:</b> \${$lot_config[ls_prize3]}<br> <b>Fourth prize:</b> \${$lot_config[ls_prize4]}<br> <p> </td> <td width='50%'><strong>Price per ticket:</strong><br> \${$lot_config[ls_price]}</td>
b>First prize:</b> $".$lot_config[ls_prize1]."<br> <b>Second prize:</b> $".$lot_config[ls_prize2]."<br> <b>Third prize:</b> $".$lot_config[ls_prize3]."<br> <b>Fourth prize:</b> $".$lot_config[ls_prize4]."<br> <p> </td> <td width='50%'><strong>Price per ticket:</strong><br> $".$lot_config[ls_price]."</td>