uberCMS - Lottery Feature.

[Brad]

Hey people I'm releasing a little Lottery Feature for uberCMS I believe this will also work with RevCMS (Haven't tried on Rev)

Screenshot:

You must be registered for see links

<div class="habblet-container ">       
    <div class="cbb clearfix blue">
        <h2 class="title">Lottery</h2>
<center><i><b>Each ticket Costs 2000 Duckets</b></i><p></p><?php

    if(isset($_POST["BUY"]))
    {
   
    $lotto_number = $_POST['os1'] . $_POST['os2'] . $_POST['os3'];
    $user_has = $users->GetUserVar(USER_ID, 'activity_points');
    $current_numbs = mysql_num_rows(mysql_query("SELECT * FROM lottery_tickets WHERE username = '" . $_POST['custom'] . "';"));
        if($user_has < 2000)
        {
            echo '<div class="rounded rounded-red" width="20%">
                You do not have enough Duckets for a lottery ticket.<br />
                </div>
                <div>&nbsp;</div>';
        }
        else if($current_numbs > 1)
        {
       
        echo '<div class="rounded rounded-red" width="20%">
                You can only purchase 1 ticket per week<br />
                </div>
                <div>&nbsp;</div>';
       
        }
        else
        {
        mysql_query("INSERT INTO lottery_tickets (username, ticket_number) VALUES ('" .  $_POST['custom'] . "', '".$lotto_number."');");
        mysql_query("UPDATE users SET activity_points = activity_points - 2000 WHERE username = '" . $_POST['custom'] . "';");
        echo '
            You successfully purchased a lottery ticket.<br />.<br />
           
            <div>&nbsp;</div>';
        }
    }


{
?>
<form method="post">
<table>
<center>Pick your numbers!</center>
<tr><td><select name="os1">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    <option value="5">5</option>
    <option value="6">6</option>
</select>

<select name="os2">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    <option value="5">5</option>
    <option value="6">6</option>
</select>

<select name="os3">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    <option value="5">5</option>
    <option value="6">6</option>
</select>

 
</td></tr>

                           
                       
               
               
                                </div>
<tr><td><br><center><input type="hidden" class="textBox" id="custom" name="custom" value="%habboname%" size="22" maxlength="255" /></center></td></tr>
</table></center>
<center><input type="submit" class="new-button green-button" value="Buy Ticket!" name="BUY"/></center>
</form>
</center>
<?php } ?>
</div>    </div>

Run This Query:

DROP TABLE IF EXISTS `lottery_tickets`;
CREATE TABLE `lottery_tickets` (
  `username` varchar(50) NOT NULL,
  `ticket_number` int(11) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Thanks! nothing special but still.

 

[Jerry]

Nice release. Will be using this maybe..

 

[Prizm]

Nice release! I'm not sure, but shouldn't you include mysql_real_escape_string too?