Akenatehm

Sweet, thanks very much. Can you show me in comments what all these new editions are doing. I like to learn how things work. It works great.!! Thanks!

Ok, I changed that. Now the page just shows up blank. Code Update: <?php $host = "localhost"; $name = "username"; $pass = "pass"; $db = "db"; $con = mysql_connect($host,$name,$pass); if (!$con) { die('Failed to Connect:' . mysql_error()); } $selectdb = mysql_select_db($db); if (!$selectdb) { die('Failed to Select Database:' . mysql_error()); } $getitems = mysql_query("SELECT itemid FROM rewards"); if(!$getitems) { die('Failed to Get Items') . mysql_error(); } else { $allitems = array(); while($items = mysql_fetch_array($getitems, MYSQL_ASSOC)) { $allitems[] = $items['itemid']; } $allitems = implode(', ', $allitems); // changed this to allitems $searchitems = mysql_query("SELECT * FROM items WHERE entry IN( $allitems)"); if(!$searchitems) { die('Could Not Search for Items' . mysql_error()); } else { while($allrows = mysql_fetch_array($searchitems, MYSQL_ASSOC)) { $numrows = mysql_num_rows($searchitems); $name1 = $allrows['name1']; $displayid = $allrows['displayid']; $requiredlevel = $allrows['requiredlevel']; $unique = $allrows['Unique']; $quality = $allrows['quality']; $description = $allrows['description']; } $i = 0; while ($i < $num){ echo "Name: $name1<br /> Display ID:$displayid<br /> Required Level: $requiredlevel <br /> Unique: $unique <br /> Quality: $quality <br /> Description: $description <br /> "; } } } ?>

Here's the code in the area that's not working: $getitems = mysql_query("SELECT itemid FROM rewards"); if(!$getitems) { die('Failed to Get Items') . mysql_error(); } else { $allitems = array(); while($items = mysql_fetch_array($getitems, MYSQL_ASSOC)) { $allitems[] = $items['itemid']; } $items = implode(', ', $allitems); $searchitems = mysql_query("SELECT * FROM items WHERE entry IN( $allitems)"); if(!$searchitems) { die('Could Not Search for Items' . mysql_error()); After changing what you suggeted I now get these errors:

Anyone know how to do this?

@corbin Well. It is only showing one record. @Cosizzle The while loop it is in is counting how many times it needs to re write it. So I don't know how to transfer that across. Any ideas?

Hey Guys, I am trying to make a script that will repeat a block of code for each entry in the database and fill each one with the fields of the respective rows. Here's the part of the code that I think is neccessary: <?php $getitems = mysql_query("SELECT itemid FROM rewards"); if(!$getitems) { die('Failed to Get Items') . mysql_error(); } else { while($items = mysql_fetch_array($getitems, MYSQL_ASSOC)) { $allitems = $items['itemid']; } $searchitems = mysql_query("SELECT * FROM items WHERE entry = '$allitems'"); if(!$searchitems) { die('Could Not Search for Items' . mysql_error()); } else { while($allrows = mysql_fetch_array($searchitems, MYSQL_ASSOC)) { $numrows = mysql_num_rows($searchitems); $name1 = $allrows['name1']; $displayid = $allrows['displayid']; $requiredlevel = $allrows['requiredlevel']; $unique = $allrows['Unique']; $quality = $allrows['quality']; $description = $allrows['description']; } $i = 0; while ($i < $num){ echo "Name: $name1<br /> Display ID:$displayid<br /> Required Level: $requiredlevel <br /> Unique: $unique <br /> Quality: $quality <br /> Description: $description <br /> "; } } } ?>

Thanks. That fixed it. Much appreciated

Hey Guys, I am getting this error: with the following code: <?php $host = "localhost"; $name = "username"; $pass = "pass"; $db = "db"; $con = mysql_connect($host,$name,$pass); if (!$con) { die('Failed to Connect:' . mysql_error()); } $selectdb = mysql_select_db($db); if (!$selectdb) { die('Failed to Select Database:' . mysql_error()); } $username = $_COOKIE['Username']; $item = $_POST['item']; $checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' "); if(!$checkusername) { die('Failed to Check Your Username' . mysql_error()); } elseif(mysql_num_rows($checkusername) == 0) { echo "Your Username Does not Exist on the Database"; } else { $enoughpoints = mysql_query("SELECT requiredpoints FROM rewards WHERE name = '$item'"); if(!$enoughpoints) { die('Failed to Check Points of Item' . mysql_error()); } else { while ($results = mysql_fetch_array($enoughpoints, MYSQL_ASSOC)) { $cost = $results['requiredpoints']; } $userpoints = mysql_query("SELECT * FROM points WHERE account = '$username'"); $userpointsresults = mysql_fetch_array($userpoints, MYSQL_ASSOC); $userhaspoints = $userpointsresults['points']; if(!$userpoints) { die('Failed to Check Your Points' . mysql_error()); } else { if($cost > $userhaspoints) { echo "You do not have enough points"; } else{ $character = $_POST['charactername']; $amount = $cost; $deduct = mysql_query("UPDATE points SET points = points - " . $amount . " WHERE account = '" . $username . "' AND points >= '" . $amount . "';"); if (!$deduct) { die('Failed to Deduct Gold' . mysql_error()); } else{ $getguid = mysql_query("SELECT guid FROM characters WHERE name = '$character'"); if(!$getguid) { die('Could Not Find GUID of User' . mysql_error()); } else{ $sortguid = mysql_fetch_array($getguid, MYSQL_ASSOC); $userhaspoints = $sortguid['guid']; $getitemid = mysql_query("SELECT itemid FROM rewards WHERE name = '$item'"); if(!$getitemid) { die('Could Not Find ID of Item' . mysql_error()); } else{ $sortitemid = mysql_fetch_array($getitemid, MYSQL_ASSOC); $itemid = $sortitemid['itemid']; /*Email Form Starts Hereeeeeeeeeeeeeeeeeeeeeeeeeeeee ########################################################################################################################################################################################################################*/ echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">'; echo '<html xmlns="http://www.w3.org/1999/xhtml">'; echo '<head>'; echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />'; echo '<title>Ingame Mail</title>'; echo '<link href="style.css" rel="stylesheet" type="text/css">'; echo '</head><body>'; echo '<table border="0" align="center">'; // connect to the db mysql_connect($host, $name, $pass) or die("Cannot connect: ".mysql_error()); mysql_select_db($db) or die("Cannot select database. ".mysql_error()); // get user inputs $sender_guid = "The Admin Team at Server"; $receiver_guid = $character; $subject = "Thanks for Voting and Purchasing an Item from Our Store! "; $body = "Here is the item you have purchased from the CorpseWoW Website Voting Rewards System"; $stationary = ''; $money = $_POST['money']; $item_id = "$itemid"; // $receiver_guid = mysql_real_escape_string(html_entity_decode(htmlentities($receiver_guid))); $subject = mysql_real_escape_string(html_entity_decode(htmlentities($subject))); $body = mysql_real_escape_string(html_entity_decode(htmlentities($body))); $stationary = mysql_real_escape_string(html_entity_decode(htmlentities($stationary))); $money = mysql_real_escape_string(html_entity_decode(htmlentities($money))); $item_id = mysql_real_escape_string(html_entity_decode(htmlentities($item_id))); $query = mysql_query("SELECT * from characters WHERE name = '".$receiver_guid."'"); while($result = mysql_fetch_array($query)) { $guid = $result['guid']; $query1 = "INSERT INTO mailbox_insert_queue(sender_guid, receiver_guid, subject, body, stationary, money, item_id,) VALUES('$sender_guid', '$guid', '$subject', '$body', '$stationary', '$money', '$item_id')"; $result = mysql_query($query1) or die(mysql_error()); echo "<tr><td align=center>"; echo "Mail Sent."; echo "</td></tr>"; } mysql_close(); } } } } } } } ?>

Hmmmm. I just realised that I was echoing nothing on the last line lol. Fixed the variable and now everything works.!! Thanks guys for all your help! It's been great! See you guys in the near future (hopefully not). Lol. Thanks Again!

Ok, It wasn't echoing. So I searched. and realised that $cost = ['points'] when it needed to be $cost = ['requiredpoints'] So i fixed it. Now it echos it. I removed teh echo. But the final part of the script about getting the guid is not doing anything just showing up blank on the screen.. Help with that wud be great.

Still didn't work.. Anyone?

This means is throwing an error because it isnt executing properly. Just taking a quick stab, i would guess you need to change UPDATE characters SET gold = gold - " . $amount . " to UPDATE characters SET gold = 'gold - " . $amount . "' I think the "gold - " is messing up the query, maybe by adding the (') it MIGHT work. I am not 100% sure, I am just trying to help ya out, may want some second advice, but thats what i would try first. Unfortunately, that didn't work. Sorry.

From this area of code: $username = $_COOKIE['Username']; $item = $_POST['item']; $checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' "); if(!$checkusername) { die('Failed to Check Your Username' . mysql_error()); } elseif(mysql_num_rows($checkusername) == 0) { echo "Your Username Does not Exist on the Database"; } Wow..This is turning into a mess. The cookie expired and that is why i was getting that error. The error still is the same. From <?php $host = "localhost"; $name = "username"; $pass = "pass"; $db = "db"; $con = mysql_connect($host,$name,$pass); if (!$con) { die('Failed to Connect:' . mysql_error()); } $selectdb = mysql_select_db($db); if (!$selectdb) { die('Failed to Select Database:' . mysql_error()); } $username = $_COOKIE['Username']; $item = $_POST['item']; $checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' "); if(!$checkusername) { die('Failed to Check Your Username' . mysql_error()); } elseif(mysql_num_rows($checkusername) == 0) { echo "Your Username Does not Exist on the Database"; } else { $enoughpoints = mysql_query("SELECT requiredpoints FROM rewards WHERE name = '$item'"); if(!$enoughpoints) { die('Failed to Check Points of Item' . mysql_error()); } else { while ($results = mysql_fetch_array($enoughpoints, MYSQL_ASSOC)) { $cost = $results['points']; } $userpoints = mysql_query("SELECT * FROM points WHERE account = '$username'"); $userpointsresults = mysql_fetch_array($userpoints, MYSQL_ASSOC); $userhaspoints = $userpointsresults['points']; if(!$userpoints) { die('Failed to Check Your Points' . mysql_error()); } else { if($cost > $userhaspoints) { echo "You do not have enough points"; } else{ $character = $_POST['charactername']; $amount = $cost; $deduct = mysql_query("UPDATE points SET points = points - " . $amount . " WHERE account = '" . $username . "' AND points >= '" . $amount . "';"); if (!$deduct) { die('Failed to Deduct Gold' . mysql_error()); } else{ $getguid = mysql_query("SELECT guid FROM characters WHERE name = '$username'"); if(!$getguid) { die('Could Not Find GUID of User' . mysql_error()); } else{ $sortguid = mysql_fetch_array($getguid, MYSQL_ASSOC); $userhaspoints = $sortguid['guid']; echo "$guid"; } } } } } } ?>

Ok. Turns out I hadn't fixed the setting properly when transferring it from another script. I am getting this weird error though: From this area of code: $username = $_COOKIE['Username']; $item = $_POST['item']; $checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' "); if(!$checkusername) { die('Failed to Check Your Username' . mysql_error()); } elseif(mysql_num_rows($checkusername) == 0) { echo "Your Username Does not Exist on the Database"; }

Really.. Well ok.. Uhm I am getting a problem in using the same script on another document. <?php $host = "localhost"; $name = "username"; $pass = "pass"; $db = "db"; $con = mysql_connect($host,$name,$pass); if (!$con) { die('Failed to Connect:' . mysql_error()); } $selectdb = mysql_select_db($db); if (!$selectdb) { die('Failed to Select Database:' . mysql_error()); } $username = $_COOKIE['Username']; $item = $_POST['item']; $checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' "); if(!$checkusername) { die('Failed to Check Your Username' . mysql_error()); } elseif(mysql_num_rows($checkusername) == 0) { echo "Your Username Does not Exist on the Database"; } else { $enoughpoints = mysql_query("SELECT requiredpoints FROM rewards WHERE name = '$item'"); if(!$enoughpoints) { die('Failed to Check Points of Item' . mysql_error()); } else { while ($results = mysql_fetch_array($enoughpoints, MYSQL_ASSOC)) { $cost = $results['points']; } $userpoints = mysql_query("SELECT * FROM points WHERE account = '$username'"); $userpointsresults = mysql_fetch_array($userpoints, MYSQL_ASSOC); $userhaspoints = $userpointsresults['points']; if(!$userpoints) { die('Failed to Check Your Points' . mysql_error()); } else { if($cost > $userhaspoints) { echo "You do not have enough points"; } else{ $character = $_POST['charactername']; $amount = $cost; $deduct = mysql_query("UPDATE characters SET gold = gold - " . $amount . " WHERE name = '" . $character . "' AND gold >= '" . $amount . "';"); if (!$deduct) { die('Failed to Deduct Gold' . mysql_error()); } else{ $getguid = mysql_query("SELECT guid FROM characters WHERE name = '$username'"); if(!$getguid) { die('Could Not Find GUID of User' . mysql_error()); } else{ $sortguid = mysql_fetch_array($getguid, MYSQL_ASSOC); $userhaspoints = $sortguid['guid']; echo "$guid"; } } } } } } ?> That is outputting this error: Where Cody is my username.

OMG. Thank you so much! It works like a charm. Outputs: You have200points Anyway I can put a space in there before and after 200?

Any Idea anyone?

Yes. The table name is points and the field name is points.

I fixed that. AND it still shows the same thing <?php $host = "localhost"; $name = "user"; $pass = "pass"; $db = "db"; $con = mysql_connect($host,$name,$pass); if (!$con) { die('Failed to Connect:' . mysql_error()); } $selectdb = mysql_select_db($db); if (!$selectdb) { die('Failed to Select Database:' . mysql_error()); } $username = $_COOKIE['Username']; $checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' "); if(!$checkusername) { die('Failed to Check Your Username' . mysql_error()); } elseif(mysql_num_rows($checkusername) == 0) { echo "Your Username Does not Exist on the Database"; } else { $findpoints = mysql_query("SELECT points FROM points WHERE account = '$username'"); if(!$findpoints) { die('Failed to Find Your Points' . mysql_error()); } else { while ($results = mysql_fetch_array($findpoints, MYSQL_NUM)){ echo "You have" . $results['points'] . "points"; } } } ?>

Omg wow...such a stupid mistake.. Thanks for pointing out to me. Much appreciated

Hey Guys, I am trying to find out how many points someone has and displaying it on the screen. The code is here: <?php $host = "localhost"; $name = "username"; $pass = "pass"; $db = "db"; $con = mysql_connect($host,$name,$pass); if (!$con) { die('Failed to Connect:' . mysql_error()); } $selectdb = mysql_select_db($db); if (!$selectdb) { die('Failed to Select Database:' . mysql_error()); } $username = $_COOKIE['Username']; $checkusername = mysql_query("SELECT * FROM points WHERE account = '$username' "); if(!$checkusername) { die('Failed to Check Your Username' . mysql_error()); } elseif(mysql_num_rows($checkusername) == 0) { echo "Your Username Does not Exist on the Database"; } else { $findpoints = mysql_query("SELECT * FROM points WHERE account = '$username'"); if(!$findpoints) { die('Failed to Find Your Points' . mysql_error()); } else { while ($results = mysql_fetch_array($findpoints, MYSQL_NUM)){ echo "You have" . $row['points'] . "points"; } } } ?> The output is just: You havepoints But I need it to say You have 50 points. Where 50 is the number from the DB. Help would be Great!

Ok. I messed around and saw that it was only not accepting 10,000 and would accept 10,0001 so I have set the required amount to 9,999 which shud fix that.

Thanks for that. I fixed that. and now it is deducting. Now I just need it to read it properly.

Hey Guys, Here's my code: <?php $host = "localhost"; $name = "username"; $pass = "password"; $db = "badasstoolz"; $con = mysql_connect($host,$name,$pass); if (!$con) { die('Failed to Connect:' . mysql_error()); } $selectdb = mysql_select_db($db); if (!$selectdb) { die('Failed to Select Database:' . mysql_error()); } if(isset($_POST['submitBtn'])) { $charactername = $_POST['charactername']; $charactername = mysql_real_escape_string($charactername); $location = $_POST['location']; $checkdb = mysql_query("SELECT * FROM characters where name = '$charactername'"); if (!$checkdb) { die('Character Name Incorrect:' . mysql_error()); } else { $checkgold = mysql_query("SELECT gold FROM characters WHERE name = '$charactername'"); $gold = mysql_result($checkgold, 0); if (!$checkdb) { die('Could Not Find Gold Amount:' . mysql_error()); } if ($gold < 10000) { echo "Not Enough Gold"; } else{ if($_POST['location'] == "stormwind"){ $move = mysql_query("UPDATE characters SET positionX = '-8913.230469', positionY = '554.632996', positionZ = '93.795525', mapId = '0', zoneId = '1519', orientation = '0.600044' WHERE name = '$charactername'"); } elseif($_POST['location'] == "darnassus"){ $move = mysql_query("UPDATE characters SET positionX = '1502.709961', positionY = '-4415.419922', positionZ = '21.552721', mapId = '1', zoneId = '1637', orientation = '0.000000' WHERE name = '$charactername'"); } elseif($_POST['location'] == "ironforge"){ $move = mysql_query("UPDATE characters SET positionX = '1502.709961', positionY = '-4415.419922', positionZ = '21.552721', mapId = '1', zoneId = '1637', orientation = '0.000000' WHERE name = '$charactername'"); } elseif($_POST['location'] == "exodar"){ $move = mysql_query("UPDATE characters SET positionX = '1502.709961', positionY = '-4415.419922', positionZ = '21.552721', mapId = '1', zoneId = '1637', orientation = '0.000000' WHERE name = '$charactername'"); } elseif($_POST['location'] == "orgrimmar"){ $move = mysql_query("UPDATE characters SET positionX = '1502.709961', positionY = '-4415.419922', positionZ = '21.552721', mapId = '1', zoneId = '1637', orientation = '0.000000' WHERE name = '$charactername'"); } elseif($_POST['location'] == "thunderbluff"){ $move = mysql_query("UPDATE characters SET positionX = '1502.709961', positionY = '-4415.419922', positionZ = '21.552721', mapId = '1', zoneId = '1637', orientation = '0.000000' WHERE name = '$charactername'"); } elseif($_POST['location'] == "silvermoon"){ $move = mysql_query("UPDATE characters SET positionX = '1502.709961', positionY = '-4415.419922', positionZ = '21.552721', mapId = '1', zoneId = '1637', orientation = '0.000000' WHERE name = '$charactername'"); } elseif($_POST['location'] == "undercity"){ $move = mysql_query("UPDATE characters SET positionX = '1502.709961', positionY = '-4415.419922', positionZ = '21.552721', mapId = '1', zoneId = '1637', orientation = '0.000000' WHERE name = '$charactername'"); } elseif($_POST['location'] == "dalaran"){ $move = mysql_query("UPDATE characters SET positionX = '1502.709961', positionY = '-4415.419922', positionZ = '21.552721', mapId = '1', zoneId = '1637', orientation = '0.000000' WHERE name = '$charactername'"); } elseif($_POST['location'] == "shattrath"){ $move = mysql_query("UPDATE characters SET positionX = '1502.709961', positionY = '-4415.419922', positionZ = '21.552721', mapId = '1', zoneId = '1637', orientation = '0.000000' WHERE name = '$charactername'"); } else { echo "You did not select a Location"; } if (!$move) { die('Failed to Move Player:' . mysql_error()); } else { $amount = 10000; $query = "UPDATE characters SET gold = gold - " . $amount . " WHERE name = '" . $charactername . "' AND gold >= '" . $amount . "';"; echo "You succesfully moved your character"; } } } } ?> Ok, this script is supposed to get their name from a field (username) that is in another php document, and teleport them to the location they select in a dropdown on the other page (location). It is then supposed to check if they have more then 10,000 gold. if they dont, it should tell them that they don't have enough. if they do, it finds out which location they picked, and updates that in the characters database. Then, if it is succesful, it is supposed to deduct 10,000 gold from their account. This DOESN'T seem to be happening. I put in 100,000 gold in the DB and it says I have enough but 30,000 gold is not enough. AND it is not deducting gold. Help would be great! Cody

Thank guys. With a bit of editing to both of your guys solutions I came up with exactly what I needed. Tyvm for your guys help, much appreciated.