Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 339212" data-attributes="member: 36373">Alright I am now on my computer. Okay so what you are trying to do from what I can tell is this:You want to create a form to allow users to purchase 5 thrones from the CMS part.Easiest way and will save you this stress is to create a catalog item and put it under any page or whateverset the amount = 5 and set the cost_snow = 4 and cost_pixels = 500 (this will be 500 points)Okay so how you will code this in php is like this:[PHP]&lt;?phpif (isset($_POST['throne'])){$cost = 500;$grabID = dbquery(&quot;SELECT * FROM items ORDER BY id DESC LIMIT 0,1&quot;);$fetchID = mysql_fetch_array($getidd);$newID = $fetchID['id'] + 1;$userInformation = mysql_query(&quot;SELECT * FROM users WHERE id = '&quot; . $_SESSION['user']['id'] . &quot;'&quot;);while($info = mysql_fetch_array($userInformation)){if($info['vip_points'] &gt;= $cost){&nbsp; &nbsp; if($info['online'] == 0){&nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;UPDATE `users` SET vip_points = vip_points - $cost WHERE id = '&quot; . $_SESSION['user']['id'] . &quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;INSERT into items (id, user_id, room_id, base_item, x, y, z, rot, wall_pos) VALUES ('&quot; . $newID . &quot;','&quot; . $_SESSION['user']['id'] . &quot;', '0', 'THRONEID', '0', '0', '0', '0', '0')&quot;);&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;The Transaction was successful. You just purchased 5 thrones&quot;;&nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;Please be offline to make this transaction&quot;;&nbsp; &nbsp; }}else{&nbsp; &nbsp; echo &quot;The current cost is $cost and you only have $info['vip_points']&quot;;}}}?&gt;[/PHP]</blockquote>

[QUOTE="JayC, post: 339212, member: 36373"] Alright I am now on my computer. Okay so what you are trying to do from what I can tell is this: You want to create a form to allow users to purchase 5 thrones from the CMS part. Easiest way and will save you this stress is to create a catalog item and put it under any page or whatever set the amount = 5 and set the cost_snow = 4 and cost_pixels = 500 (this will be 500 points) Okay so how you will code this in php is like this: [PHP] <?php if (isset($_POST['throne'])) { $cost = 500; $grabID = dbquery("SELECT * FROM items ORDER BY id DESC LIMIT 0,1"); $fetchID = mysql_fetch_array($getidd); $newID = $fetchID['id'] + 1; $userInformation = mysql_query("SELECT * FROM users WHERE id = '" . $_SESSION['user']['id'] . "'"); while($info = mysql_fetch_array($userInformation)){ if($info['vip_points'] >= $cost){ if($info['online'] == 0){ mysql_query("UPDATE `users` SET vip_points = vip_points - $cost WHERE id = '" . $_SESSION['user']['id'] . "'"); mysql_query("INSERT into items (id, user_id, room_id, base_item, x, y, z, rot, wall_pos) VALUES ('" . $newID . "','" . $_SESSION['user']['id'] . "', '0', 'THRONEID', '0', '0', '0', '0', '0')"); echo "The Transaction was successful. You just purchased 5 thrones"; }else{ echo "Please be offline to make this transaction"; } }else{ echo "The current cost is $cost and you only have $info['vip_points']"; } } } ?> [/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members