This code works correctly. ;]
ADD: /functions/updatevip.php
PHP Code:
<?php
define('USERNAME_REQUIRED', TRUE);
define('ACCOUNT_REQUIRED', TRUE);
include("../global.php");
$username = $_SESSION['username'];
$code = ($_POST['vipCode']);
$userq = mysql_query("SELECT * FROM users WHERE username = '".$username."' LIMIT 1");
$user = mysql_fetch_array($userq);
$check = mysql_query("SELECT * FROM vip WHERE code = '".$code."'");
if(mysql_num_rows($check) > 0)
{
mysql_query("UPDATE users SET rank = '3' WHERE username = '".$username."'");
mysql_query("DELETE FROM vip WHERE code = '".$code."'");
header("location: ../settings.php?page=vip&success=true");
}
else
{
header("location: ../settings.php?page=vip&success=false");
}
?>
Open settings.php and add:
Add this code into the FIRST column
Code:
<a href="?page=vip" <?php if($_GET['page'] == 'vip') echo 'class="selected"'; ?>>VIP Settings</a>
This code goes into the other columnn.
Code:
<?php
}
if($_GET['page'] == 'vip')
{
?>
<div class="boxHeaderGrey"><h1>VIP Subscription</h1></div>
<div class="boxContent">
<?php
if(isset($_GET['success']) && $_GET['success'] == 'false')
{
?>
<div class="errormsg" id="habbo_name_message_box">
<?php echo $lang['settings_general_error']; ?>
</div>
<?php
}
elseif(isset($_GET['success']) && $_GET['success'] == 'true')
{
?>
<div class="goodmsg" id="habbo_name_message_box">
<?php echo $lang['settings_general_updated']; ?>
</div>
<?php
}
?>
<form name="UserVIP" action="functions/updatevip.php" method="post">
<label for="vip">VIP code:</label><br/>
<input type="vip" name="vipCode" id="vip" /><br/>
<div class="Submitbtn right">
<button type="submit" class="positive" name="submitcomment"><?php echo $lang['submit']; ?></button>
</div>
</form>
</div>
<?php
}
?>
SQL query
Code:
--
-- Table structure for table `vip`
--
CREATE TABLE IF NOT EXISTS `vip` (
`code` varchar(20) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;