Free VIP script in REVCMS

[Muhd Nazmi]

in me.php : i put this on but it doesn't works

<?php

mysql_query("UPDATE users rank='2' WHERE rank ='1' AND id="'".$SESSION['id'].'";")
?>

[MentaL]

[Nate Curry]

i think it is <?php

mysql_query("UPDATE users rank= WHERE rank ='2' AND id="'".$SESSION['id'].'";")
?>
idk but i think its that sory if its not

[MrSpooks]

try this



<?php

mysql_query("UPDATE users SET rank = '2' WHERE rank = '1'.$SESSION['id'].'";")
?>

[Sledmore]

Right, if you want to give users it by default (when they sign up), go to app/class.users.php - search for this:

$this->addUser($template->form->reg_username, $core->hashed($template->form->reg_password), $template->form->reg_email, $_CONFIG['hotel']['motto'], $_CONFIG['hotel']['credits'], $_CONFIG['hotel']['pixels'], 1, 

Replace ONLY that bit with:

$this->addUser($template->form->reg_username, $core->hashed($template->form->reg_password), $template->form->reg_email, $_CONFIG['hotel']['motto'], $_CONFIG['hotel']['credits'], $_CONFIG['hotel']['pixels'], 2, 

Then every user will have rank 2.

Now if you want the current users to have VIP, run this SQL query in Navicat/PHPMyAdmin or whatever else:

UPDATE `users` SET `rank` = '2';

Or, if you want to run it on a page, just stick this on:

mysql_query("UPDATE `users` SET `rank` = '2'"); 

That should do the trick.

[Muhd Nazmi]

Thanks !