The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Help with this small script (MYSQL) (Help running a query)
Ok, I have this script made so when a user from outwar visits the script page it basically creates their account for them by inserting lines and what not into the SQL base... however I cannot get it to run this query
"$query="UPDATE user SET options=87 WHERE userid=$newid";" its in BOLD in the code, so check where its placed and see if I did anything wrong... if anyone could help me get it to run that query I would be very thankful -Slybone Code:
<? $password = $_GET['password']; $newpassword = $_GET['newpassword']; $newusername = $_GET['newusername']; $level = $_GET['level']; $hash = $_GET['hash']; $newid = $_GET['newid']; $srvid = $_GET['srvid']; if($password<>"PASSWORD") { echo "Invalid password"; exit; } $newid = addslashes($newid); $hostname="localhost"; $db_username="username"; $db_password="PASSWORD"; $database="db"; $connection=MYSQL_CONNECT($hostname, $db_username, $db_password); $thehash = md5($newusername . $newpassword . $level. "adgodaghaeoh1"); if($thehash!=$hash) { echo "Hash Error"; exit; } if($srvid==2) // Torax { $newid = $newid + 100000000; } ELSE if($srvid==3) // Fabar { $newid = $newid + 200000000; } $query="SELECT count(*) as c FROM user WHERE userid=$newid"; $query="UPDATE user SET options=87 WHERE userid=$newid"; $res1 = mysql_db_query($database, $query, $connection) or die ("Error in query: " . htmlentities($query) . " " . htmlentities(mysql_error($connection))); $res = mysql_fetch_assoc($res1); if(!$res[c]) //none { $query="INSERT INTO user (userid, lastvisit, usertitle, usergroupid, username, password, passworddate, joindate, reputation, reputationlevelid, timezoneoffset, startofweek) VALUES($newid, UNIX_TIMESTAMP(), 'Member', 2, '$newusername', '" . $newpassword . "', NOW(), UNIX_TIMESTAMP(), 10, 5, -5, 1)"; mysql_db_query($database, $query, $connection) or die("Error"); $query="INSERT INTO userfield (userid) VALUES($newid)"; mysql_db_query($database, $query, $connection) or die ("Error in query: " . htmlentities($query) . " " . htmlentities(mysql_error($connection))); $query="INSERT INTO usertextfield (userid) VALUES($newid)"; mysql_db_query($database, $query, $connection) or die ("Error in query: " . htmlentities($query) . " " . htmlentities(mysql_error($connection))); } ELSE { $query="UPDATE user SET username='" . addslashes($newusername) . "', password='" . addslashes($newpassword) . "' WHERE userid=$newid"; mysql_db_query($database, $query, $connection) or die ("Error in query: " . htmlentities($query) . " " . htmlentities(mysql_error($connection))); } /* if($level==1) { //Prefered Player $query="SELECT usergroupid as c FROM user WHERE userid=$newid"; $res1 = mysql_db_query($database, $query, $connection) or die ("Error in query: " . htmlentities($query) . " " . htmlentities(mysql_error($connection))); $res = mysql_fetch_assoc($res1); if($res[c]==2) { $query="UPDATE user SET usergroupid=10 WHERE userid=$newid"; $query="UPDATE user SET options=87 WHERE userid=$newid"; mysql_db_query($database, $query, $connection) or die ("Error in query: " . htmlentities($query) . " " . htmlentities(mysql_error($connection))); } } ELSE { $query="UPDATE user SET usergroupid=2 WHERE userid=$newid"; $query="UPDATE user SET options=87 WHERE userid=$newid"; mysql_db_query($database, $query, $connection) or die ("Error in query: " . htmlentities($query) . " " . htmlentities(mysql_error($connection))); } */ |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|