Reply to thread

Message

[CODE=php]
$enable = array(
"buyLotteryTicket" => true,
"lottery" => true
);

function randomChance($min, $max) {
Return random_int($min, $max) ;
}

public function randomLotteryNumber() {
$randomNum1 = randomChance(0, 9);
$randomNum2 = randomChance(0, 9);
$randomNum3 = randomChance(0, 9);
$randomNum4 = randomChance(0, 9);
$lotteryNumber = $randomNum1.$randomNum2.$randomNum3.$randomNum4;
return $lotteryNumber;
}

public function lottery() {
global $db, $enable;
if ($enable['lottery'] == true) {
if (isset($_POST['lottery'])) {
$getLottery = $db->prepare("
SELECT * FROM cms_lottery WHERE active = '1'
");
$getLottery->execute();
if ($getLottery->RowCount() > 0) {
$winningTicketNumbers = $getLottery->fetch();
$getLotteryTickets = $db->prepare("SELECT * FROM cms_lottery_tickets WHERE ticket_number = :winninglotteryticket");
$getLotteryTickets->bindParam(":winninglotteryticket", $winningTicketNumbers['lottery_ticket']);
$getLotteryTickets->execute();
if ($getLotteryTickets->RowCount() > 0) {
while ($winners = $getLotteryTickets->fetch()) {
$giftPrize = $db->prepare("UPDATE users SET {$winningTicketNumbers['type']} = coins + {$winningTicketNumbers['amount']} WHERE id = :user_id");
$giftPrize->bindParam(":user_id", $winners['user_id']);
$giftPrize->execute();
}
$deleteWinningTicket = $db->prepare("DELETE from cms_lottery WHERE id = :winninglotteryticket");
$deleteWinningTicket->bindParam(":winninglotteryticket", $winningTicketNumbers['id']);
$deleteWinningTicket->execute();
$deleteOldTickets = $db->prepare("TRUNCATE TABLE cms_lottery_tickets");
$deleteOldTickets->execute();
} else {
echo "No tickets were bought this week";
}
}
}
}
}

public function buyLotteryTicket() {
global $db, $enable;
if ($enable['buyLotteryTicket'] == true) {
if (isset($_POST['buyLotteryTicket'])) {
if (!empty($_POST['num1']) && $_POST['num1'] < 10 && ctype_digit($_POST['num1'])) {
if (!empty($_POST['num2']) && $_POST['num2'] < 10 && ctype_digit($_POST['num2'])) {
if (!empty($_POST['num3']) && $_POST['num3'] < 10 && ctype_digit($_POST['num3'])) {
if (!empty($_POST['num4']) && $_POST['num4'] < 10 && ctype_digit($_POST['num4'])) {
$lotteryTicket = $_POST['num1'].$_POST['num2'].$_POST['num3'].$_POST['num4'];
$date = 123;
$getLotteryTicket = $db->prepare("
INSERT INTO cms_lottery_tickets (user_id, ticket_number, buy_date) VALUES (:user_id, :ticket_number, :buy_date)
");
$getLotteryTicket->bindParam(":user_id", $_SESSION['id']);
$getLotteryTicket->bindParam(":ticket_number", $lotteryTicket);
$getLotteryTicket->bindParam(":buy_date", $date);
$getLotteryTicket->execute();
} else {
echo "Something wrong with number picker field 4";
}
} else {
echo "Something wrong with number picker field 3";
}
} else {
echo "Something wrong with number picker field 2";
}
} else {
echo "Something wrong with number picker field 1";
}
}
}
}[/CODE]

[CODE=html]<form method='POST'>
<input name="num1" type="number" min="0" max="9" placeholder="0-9"></input>
<input name="num2" type="number" min="0" max="9" placeholder="0-9"></input>
<input name="num3" type="number" min="0" max="9" placeholder="0-9"></input>
<input name="num4" type="number" min="0" max="9" placeholder="0-9"></input>
<button type="submit" name="buyLotteryTicket">buy ticket</button>
</form>

<form method="POST">
<button name="lottery" type="submit">run the lottery</button>
</form>[/CODE]

lottery sql:
[URL unfurl="true"]https://mega.nz/file/rJlD1QQT#ECmDgT7mGeHNJa33EhToToagi3Gqsk8_KpiplP8tVd8[/URL]

tickets sql:
[URL unfurl="true"]https://mega.nz/file/KFlFEAxQ#B-xkkEM6fJsg9K8F40BA70jC8lGFAB7iS2N5LA4ItpU[/URL]

i couldnt be arsed to sort the dates out do it yourself

<blockquote data-quote="Dec" data-source="post: 467497" data-attributes="member: 75952">[CODE=php]$enable = array(&nbsp; &nbsp; &quot;buyLotteryTicket&quot; =&gt; true,&nbsp; &nbsp; &quot;lottery&quot; =&gt; true);function randomChance($min, $max) {&nbsp; &nbsp; Return random_int($min, $max) ;}public function randomLotteryNumber() {&nbsp; &nbsp; &nbsp; &nbsp; $randomNum1 = randomChance(0, 9);&nbsp; &nbsp; &nbsp; &nbsp; $randomNum2 = randomChance(0, 9);&nbsp; &nbsp; &nbsp; &nbsp; $randomNum3 = randomChance(0, 9);&nbsp; &nbsp; &nbsp; &nbsp; $randomNum4 = randomChance(0, 9);&nbsp; &nbsp; &nbsp; &nbsp; $lotteryNumber = $randomNum1.$randomNum2.$randomNum3.$randomNum4;&nbsp; &nbsp; &nbsp; &nbsp; return $lotteryNumber;&nbsp; &nbsp; }&nbsp; &nbsp; public function lottery() {&nbsp; &nbsp; &nbsp; &nbsp; global $db, $enable;&nbsp; &nbsp; &nbsp; &nbsp; if ($enable['lottery'] == true) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (isset($_POST['lottery'])) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getLottery = $db-&gt;prepare(&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECT * FROM cms_lottery WHERE active = '1'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getLottery-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($getLottery-&gt;RowCount() &gt; 0) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $winningTicketNumbers = $getLottery-&gt;fetch();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getLotteryTickets = $db-&gt;prepare(&quot;SELECT * FROM cms_lottery_tickets WHERE ticket_number = :winninglotteryticket&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getLotteryTickets-&gt;bindParam(&quot;:winninglotteryticket&quot;, $winningTicketNumbers['lottery_ticket']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getLotteryTickets-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($getLotteryTickets-&gt;RowCount() &gt; 0) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while ($winners = $getLotteryTickets-&gt;fetch()) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $giftPrize = $db-&gt;prepare(&quot;UPDATE users SET {$winningTicketNumbers['type']} = coins + {$winningTicketNumbers['amount']} WHERE id = :user_id&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $giftPrize-&gt;bindParam(&quot;:user_id&quot;, $winners['user_id']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $giftPrize-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $deleteWinningTicket = $db-&gt;prepare(&quot;DELETE from cms_lottery WHERE id = :winninglotteryticket&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $deleteWinningTicket-&gt;bindParam(&quot;:winninglotteryticket&quot;, $winningTicketNumbers['id']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $deleteWinningTicket-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $deleteOldTickets = $db-&gt;prepare(&quot;TRUNCATE TABLE cms_lottery_tickets&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $deleteOldTickets-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;No tickets were bought this week&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; public function buyLotteryTicket() {&nbsp; &nbsp; &nbsp; &nbsp; global $db, $enable;&nbsp; &nbsp; &nbsp; &nbsp; if ($enable['buyLotteryTicket'] == true) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (isset($_POST['buyLotteryTicket'])) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!empty($_POST['num1']) &amp;&amp; $_POST['num1'] &lt; 10 &amp;&amp; ctype_digit($_POST['num1'])) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!empty($_POST['num2']) &amp;&amp; $_POST['num2'] &lt; 10 &amp;&amp; ctype_digit($_POST['num2'])) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!empty($_POST['num3']) &amp;&amp; $_POST['num3'] &lt; 10 &amp;&amp; ctype_digit($_POST['num3'])) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!empty($_POST['num4']) &amp;&amp; $_POST['num4'] &lt; 10 &amp;&amp; ctype_digit($_POST['num4'])) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $lotteryTicket = $_POST['num1'].$_POST['num2'].$_POST['num3'].$_POST['num4'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $date = 123;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getLotteryTicket = $db-&gt;prepare(&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INSERT INTO cms_lottery_tickets (user_id, ticket_number, buy_date) VALUES (:user_id, :ticket_number, :buy_date)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getLotteryTicket-&gt;bindParam(&quot;:user_id&quot;, $_SESSION['id']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getLotteryTicket-&gt;bindParam(&quot;:ticket_number&quot;, $lotteryTicket);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getLotteryTicket-&gt;bindParam(&quot;:buy_date&quot;, $date);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getLotteryTicket-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;Something wrong with number picker field 4&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;Something wrong with number picker field 3&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;Something wrong with number picker field 2&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;Something wrong with number picker field 1&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }[/CODE][CODE=html]&lt;form method='POST'&gt;&lt;input name=&quot;num1&quot; type=&quot;number&quot; min=&quot;0&quot; max=&quot;9&quot; placeholder=&quot;0-9&quot;&gt;&lt;/input&gt;&lt;input name=&quot;num2&quot; type=&quot;number&quot; min=&quot;0&quot; max=&quot;9&quot; placeholder=&quot;0-9&quot;&gt;&lt;/input&gt;&lt;input name=&quot;num3&quot; type=&quot;number&quot; min=&quot;0&quot; max=&quot;9&quot; placeholder=&quot;0-9&quot;&gt;&lt;/input&gt;&lt;input name=&quot;num4&quot; type=&quot;number&quot; min=&quot;0&quot; max=&quot;9&quot; placeholder=&quot;0-9&quot;&gt;&lt;/input&gt;&lt;button type=&quot;submit&quot; name=&quot;buyLotteryTicket&quot;&gt;buy ticket&lt;/button&gt;&lt;/form&gt;&lt;form method=&quot;POST&quot;&gt;&lt;button name=&quot;lottery&quot; type=&quot;submit&quot;&gt;run the lottery&lt;/button&gt;&lt;/form&gt;[/CODE]lottery sql:[URL unfurl=&quot;true&quot;]https://mega.nz/file/rJlD1QQT#ECmDgT7mGeHNJa33EhToToagi3Gqsk8_KpiplP8tVd8[/URL]tickets sql:[URL unfurl=&quot;true&quot;]https://mega.nz/file/KFlFEAxQ#B-xkkEM6fJsg9K8F40BA70jC8lGFAB7iS2N5LA4ItpU[/URL]i couldnt be arsed to sort the dates out do it yourself</blockquote>

[QUOTE="Dec, post: 467497, member: 75952"] [CODE=php] $enable = array( "buyLotteryTicket" => true, "lottery" => true ); function randomChance($min, $max) { Return random_int($min, $max) ; } public function randomLotteryNumber() { $randomNum1 = randomChance(0, 9); $randomNum2 = randomChance(0, 9); $randomNum3 = randomChance(0, 9); $randomNum4 = randomChance(0, 9); $lotteryNumber = $randomNum1.$randomNum2.$randomNum3.$randomNum4; return $lotteryNumber; } public function lottery() { global $db, $enable; if ($enable['lottery'] == true) { if (isset($_POST['lottery'])) { $getLottery = $db->prepare(" SELECT * FROM cms_lottery WHERE active = '1' "); $getLottery->execute(); if ($getLottery->RowCount() > 0) { $winningTicketNumbers = $getLottery->fetch(); $getLotteryTickets = $db->prepare("SELECT * FROM cms_lottery_tickets WHERE ticket_number = :winninglotteryticket"); $getLotteryTickets->bindParam(":winninglotteryticket", $winningTicketNumbers['lottery_ticket']); $getLotteryTickets->execute(); if ($getLotteryTickets->RowCount() > 0) { while ($winners = $getLotteryTickets->fetch()) { $giftPrize = $db->prepare("UPDATE users SET {$winningTicketNumbers['type']} = coins + {$winningTicketNumbers['amount']} WHERE id = :user_id"); $giftPrize->bindParam(":user_id", $winners['user_id']); $giftPrize->execute(); } $deleteWinningTicket = $db->prepare("DELETE from cms_lottery WHERE id = :winninglotteryticket"); $deleteWinningTicket->bindParam(":winninglotteryticket", $winningTicketNumbers['id']); $deleteWinningTicket->execute(); $deleteOldTickets = $db->prepare("TRUNCATE TABLE cms_lottery_tickets"); $deleteOldTickets->execute(); } else { echo "No tickets were bought this week"; } } } } } public function buyLotteryTicket() { global $db, $enable; if ($enable['buyLotteryTicket'] == true) { if (isset($_POST['buyLotteryTicket'])) { if (!empty($_POST['num1']) && $_POST['num1'] < 10 && ctype_digit($_POST['num1'])) { if (!empty($_POST['num2']) && $_POST['num2'] < 10 && ctype_digit($_POST['num2'])) { if (!empty($_POST['num3']) && $_POST['num3'] < 10 && ctype_digit($_POST['num3'])) { if (!empty($_POST['num4']) && $_POST['num4'] < 10 && ctype_digit($_POST['num4'])) { $lotteryTicket = $_POST['num1'].$_POST['num2'].$_POST['num3'].$_POST['num4']; $date = 123; $getLotteryTicket = $db->prepare(" INSERT INTO cms_lottery_tickets (user_id, ticket_number, buy_date) VALUES (:user_id, :ticket_number, :buy_date) "); $getLotteryTicket->bindParam(":user_id", $_SESSION['id']); $getLotteryTicket->bindParam(":ticket_number", $lotteryTicket); $getLotteryTicket->bindParam(":buy_date", $date); $getLotteryTicket->execute(); } else { echo "Something wrong with number picker field 4"; } } else { echo "Something wrong with number picker field 3"; } } else { echo "Something wrong with number picker field 2"; } } else { echo "Something wrong with number picker field 1"; } } } }[/CODE] [CODE=html]<form method='POST'> <input name="num1" type="number" min="0" max="9" placeholder="0-9"></input> <input name="num2" type="number" min="0" max="9" placeholder="0-9"></input> <input name="num3" type="number" min="0" max="9" placeholder="0-9"></input> <input name="num4" type="number" min="0" max="9" placeholder="0-9"></input> <button type="submit" name="buyLotteryTicket">buy ticket</button> </form> <form method="POST"> <button name="lottery" type="submit">run the lottery</button> </form>[/CODE] lottery sql: [URL unfurl="true"]https://mega.nz/file/rJlD1QQT#ECmDgT7mGeHNJa33EhToToagi3Gqsk8_KpiplP8tVd8[/URL] tickets sql: [URL unfurl="true"]https://mega.nz/file/KFlFEAxQ#B-xkkEM6fJsg9K8F40BA70jC8lGFAB7iS2N5LA4ItpU[/URL] i couldnt be arsed to sort the dates out do it yourself [/QUOTE]

Reply to thread

Connect with us

Newest members