need help with auto vip script

[xforlife]

Hey,

I'm busy with this code

<?php 
$con = mysql_connect("localhost","root","mypass"); 
if (!$con) 
  { 
  die('Could not connect: ' . mysql_error()); 
  } 


mysql_query("UPDATE users SET vip = 1 WHERE username = '".$_SESSION['user']['username']."' LIMIT 1");
mysql_query("UPDATE users SET rank = 2 WHERE username = '".$_SESSION['user']['username']."' LIMIT 1");  


mysql_close($con); 
?>

But it doesn't work i hope someone can help me, i'm using rev 1.9.9.9

my idea, after paying this php file wil run on the background so the users get automatic vip

sorry if i had bad english

[MentaL]

[xforlife]

someone?

[azaidi]

First of all use mysqli: mysqli_query etc.
You don't have to close the connection at the end of your script, PHP will do it for you.

Try putting the 1 and 2 between single quotes:
mysqli_query("UPDATE users SET vip = '1' WHERE username = '".$_SESSION['user']['username']."' LIMIT 1");
mysqli_query("UPDATE users SET rank = '2' WHERE username = '".$_SESSION['user']['username']."' LIMIT 1");

[Quackster]

you haven't selected the database.

[iRetro™]

You haven't selected the db, also this is really bad as anyone could get vip with this script.

[xforlife]

Okee, i got this code now (btw i dont know anything about php/mysql)

<?php

$con=mysqli_connect("localhost","root","123","hotel");

if (mysqli_connect_errno($con))
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

mysqli_query($con,"UPDATE users SET vip = '1' WHERE username = '".$_SESSION['user']['username']."' LIMIT 1");
mysqli_query($con,"UPDATE users SET rank = '2' WHERE username = '".$_SESSION['user']['username']."' LIMIT 1");
  
?>

but it still doesn't update in phpmyadmin/mysql

[FullmetalPride]

Okee, i got this code now (btw i dont know anything about php/mysql)

<?php

$con=mysqli_connect("localhost","root","123","hotel");

if (mysqli_connect_errno($con))
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

mysqli_query($con,"UPDATE users SET vip = '1' WHERE username = '".$_SESSION['user']['username']."' LIMIT 1");
mysqli_query($con,"UPDATE users SET rank = '2' WHERE username = '".$_SESSION['user']['username']."' LIMIT 1");
  
?>

but it still doesn't update in phpmyadmin/mysql

My first question is why ever write a page specifically for giving free VIP? :l

If you're going to be giving VIP to everyone, just write an extra query in registration.

[Spheral]

I use auto ipn for payment, lol.