Reply to thread

Message

<blockquote data-quote="Brad" data-source="post: 279594" data-attributes="member: 17995">Heres a preview<a href="http://prntscr.com/3amzye" target="_blank">http://prntscr.com/3amzye</a>And here is the full code[PHP]&lt;?php$n1 = dbquery(&quot;SELECT * FROM lottery_tickets WHERE username = '&quot; . TICKET . &quot;'&quot;); ?&gt;&lt;?php$getSettings = dbquery(&quot;SELECT * FROM users WHERE username = '&quot; . USER_NAME . &quot;'&quot;);$userAccount = mysql_fetch_assoc($getSettings);?&gt;&lt;?phpif (!defined('IN_HK') || !IN_HK){&nbsp; &nbsp; exit;}if (!HK_LOGGED_IN || !$users-&gt;hasFuse(USER_ID, 'fuse_housekeeping_moderation')){&nbsp; &nbsp; exit;}if(isset($_POST['pick'])){&nbsp; &nbsp; $N1 = rand('&quot; . TICKET . &quot;');&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; $WINNER = mysql_fetch_assoc(dbquery(&quot;SELECT username FROM lottery_tickets WHERE username = '&quot;. $N1 .&quot;'&quot;));&nbsp; &nbsp; if($WINNER['username'] == &quot;&quot;){ $WINNER['username'] = &quot;NONE&quot;; }&nbsp;&nbsp; &nbsp; &nbsp; fMessage('ok', 'Winner: &lt;b&gt;'. $WINNER['username'] .'&lt;/b&gt; ('. $N1 .')');}require_once &quot;top.php&quot;;&nbsp;&nbsp; $countEnter = mysql_num_rows(dbquery(&quot;SELECT null FROM lottery_tickets&quot;));&nbsp; &nbsp; &nbsp;&nbsp; echo '&lt;h1&gt;Lotto System Records ('. $countEnter .' Entries) - ('. $countEnter * 1 .' tokens Earned) - ('. $countEnter * 1 * 2 .' Tokens Prize)&lt;/h1&gt;';?&gt;&lt;p&gt;This tool allows you to view all the user enteries for the lotto system.&lt;/p&gt;&lt;br&gt;&lt;form method=&quot;post&quot;&gt;&nbsp; &nbsp; &lt;center&gt;&lt;input type=&quot;submit&quot; name=&quot;pick&quot; value=&quot;Select Random Winner&quot;&gt;&lt;/center&gt;&lt;/form&gt;&lt;br&gt;&lt;br&gt;&lt;table align=&quot;center&quot;&gt;&lt;tr&gt;&lt;td align=&quot;center&quot; width=&quot;150&quot;&gt;&lt;b&gt;Username&lt;/b&gt;&lt;/td&gt;&lt;td align=&quot;center&quot;&gt;&lt;b&gt;Numbers&lt;/b&gt;&lt;/td&gt;&lt;td align=&quot;center&quot; width=&quot;300&quot;&gt;&lt;b&gt;Date Entered&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;?php$query = dbquery(&quot;SELECT username,ticket_number FROM lottery_tickets&quot;);while($assoc = mysql_fetch_assoc($query)){&nbsp; &nbsp; echo '&lt;tr&gt;&lt;td align=&quot;center&quot;&gt;'. $assoc['username'] .'&lt;/td&gt;&lt;td align=&quot;center&quot;&gt;&lt;b&gt;'. $assoc['ticket_number'] .'&lt;/b&gt;&lt;/td&gt;&lt;td align=&quot;center&quot;&gt;'. date('r', $assoc['date']) .'&lt;/td&gt;&lt;/tr&gt;';}?&gt;&lt;/table&gt;[/PHP]</blockquote>

[QUOTE="Brad, post: 279594, member: 17995"] Heres a preview [url]http://prntscr.com/3amzye[/url] And here is the full code [PHP]<?php $n1 = dbquery("SELECT * FROM lottery_tickets WHERE username = '" . TICKET . "'"); ?> <?php $getSettings = dbquery("SELECT * FROM users WHERE username = '" . USER_NAME . "'"); $userAccount = mysql_fetch_assoc($getSettings); ?> <?php if (!defined('IN_HK') || !IN_HK) { exit; } if (!HK_LOGGED_IN || !$users->hasFuse(USER_ID, 'fuse_housekeeping_moderation')) { exit; } if(isset($_POST['pick'])) { $N1 = rand('" . TICKET . "'); $WINNER = mysql_fetch_assoc(dbquery("SELECT username FROM lottery_tickets WHERE username = '". $N1 ."'")); if($WINNER['username'] == ""){ $WINNER['username'] = "NONE"; } fMessage('ok', 'Winner: '. $WINNER['username'] .' ('. $N1 .')'); } require_once "top.php"; $countEnter = mysql_num_rows(dbquery("SELECT null FROM lottery_tickets")); echo '<h1>Lotto System Records ('. $countEnter .' Entries) - ('. $countEnter * 1 .' tokens Earned) - ('. $countEnter * 1 * 2 .' Tokens Prize)</h1>'; ?> This tool allows you to view all the user enteries for the lotto system. <form method="post"> <center><input type="submit" name="pick" value="Select Random Winner"></center> </form> <table align="center"> <tr><td align="center" width="150">Username</td><td align="center">Numbers</td><td align="center" width="300">Date Entered</td></tr> <?php $query = dbquery("SELECT username,ticket_number FROM lottery_tickets"); while($assoc = mysql_fetch_assoc($query)) { echo '<tr><td align="center">'. $assoc['username'] .'</td><td align="center">'. $assoc['ticket_number'] .'</td><td align="center">'. date('r', $assoc['date']) .'</td></tr>'; } ?> </table>[/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members