Reply to thread

Message

<blockquote data-quote="thewicard" data-source="post: 191850" data-attributes="member: 8814">So, I used a few hours figuring this out xPHope you enjoy. Sorry about insanely long code.Price is now configured in DB.&nbsp;What does this code do?It allows you to sell furniture in limited quantities.Is it secure?It has double money-in-pocket check (1 in whatever page it's placed in AND 1 when delivering furniture)It has double furniture-not-sold-out check (1 in whatever page it's placed in AND 1 when delivering furniture)Will not work to refresh page to get another furniture unless there are still available AND you have money for it.Added POST Filter (Now only allow numeric posts) //Thanks to Leenster for telling me it was needed.&nbsp;First: Run this queue[PHP]DROP TABLE IF EXISTS `rev_ltd`;CREATE TABLE `rev_ltd` (&nbsp;`furni_id` int(255) NOT NULL,&nbsp;`furni_left` int(255) NOT NULL DEFAULT '100',&nbsp;`furni_sold` int(255) NOT NULL DEFAULT '0',&nbsp;`furni_price` int(255) NOT NULL DEFAULT '5000',&nbsp;PRIMARY KEY (`furni_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;INSERT INTO `rev_ltd` VALUES ('227', '15', '0', '5000');[/PHP]&nbsp;Second: Create a file in app/tpl/skins/YOURSKIN/ named buyltd.phpPlace this content in the file and save:[PHP]&lt;?php$ltd_id = preg_replace('/[^0-9]/', '', $_POST[&quot;ltd_id&quot;]);$user_id = $_SESSION['user']['id'];$selectfromusers = mysql_query(&quot;SELECT * FROM users WHERE id = '&quot;.$user_id.&quot;'&quot;) or die(mysql_error());while ($getmoney = mysql_fetch_array($selectfromusers))$money_current = $getmoney['credits'];$selectfromfurninum = mysql_query(&quot;SELECT * FROM rev_ltd WHERE furni_id = '&quot;.$ltd_id.&quot;'&quot;) or die(mysql_error());while ($getfurninum = mysql_fetch_array($selectfromfurninum))$furnileft = $getfurninum['furni_left'] and$furnisold = $getfurninum['furni_sold'] and$ltd_price = $getfurninum['furni_price'];if($furnileft &gt; '0'){if($money_current &lt; $ltd_price){echo &quot;You don't have enough money for this item&quot;;}else{$newmoney = $money_current - $ltd_price;mysql_query(&quot;UPDATE users SET credits='&quot;.$newmoney.&quot;' WHERE id='&quot;.$user_id.&quot;'&quot;) or die(mysql_error());$newfurnileft = $furnileft - '1';$newfurnisold = $furnisold + '1';mysql_query(&quot;UPDATE rev_ltd SET furni_sold='&quot;.$newfurnisold.&quot;'&quot;) or die(mysql_error());mysql_query(&quot;UPDATE rev_ltd SET furni_left='&quot;.$newfurnileft.&quot;'&quot;) or die(mysql_error());$highestid = mysql_query(&quot;SELECT * from items ORDER BY id DESC LIMIT 1&quot;) or die(mysql_error());while ($checknewid2 = mysql_fetch_array($highestid))$newid2 = $checknewid2['id'];$newid = $newid2 + '1';mysql_query(&quot;INSERT INTO items (id, user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos) VALUES ('&quot;.$newid.&quot;','&quot;.$user_id.&quot;',0,'&quot;.$ltd_id.&quot;',0,0,0,0,0,0)&quot;) or die(mysql_error());echo &quot;Item bough successfully!&quot;;}}else{echo &quot;All of furniture is already sold, sorry&quot;;}?&gt;&lt;meta http-equiv=&quot;refresh&quot; content=&quot;1; URL=me&quot;&gt;[/PHP]&nbsp;Third:Goto whatever page you want this in, add this at the top:[PHP]&lt;?php$user_id = $_SESSION['user']['id'];$selectfromusers = mysql_query(&quot;SELECT * FROM users WHERE id = '&quot;.$user_id.&quot;'&quot;) or die(mysql_error());while ($getmoney = mysql_fetch_array($selectfromusers))$money_current = $getmoney['credits'];?&gt;[/PHP]&nbsp;Forth:Add this wherever you want the output, this is made for Priv theme.[PHP]&lt;?php//Furniconfiguration$ltd_id = &quot;227&quot;; //furni_id in the database$ltd_name = &quot;Dragonegg&quot;; //The name of your furni$image_url = &quot;http://habboxwiki.com/wiki/images/1/12/Black_Dino_Egg.png&quot;; //Image URL (optional)&nbsp;&nbsp;//Collects data from database$selectfromltd = mysql_query(&quot;SELECT * FROM rev_ltd WHERE furni_id = '&quot;.$ltd_id.&quot;'&quot;) or die(mysql_error());while ($getltd = mysql_fetch_array($selectfromltd))$getltd_num = $getltd['furni_left'] and$getltd_sold = $getltd['furni_sold'] and$ltd_price = $getltd['furni_price'];$getltd_total = $getltd_sold + $getltd_num;$money_lack = $ltd_price - $money_current; ?&gt;&nbsp;&lt;!-- The part that you can see, may need to be changed to fit other theme (currently for Priv theme)&nbsp;&nbsp; --&gt;&lt;div class=&quot;left page round&quot;&gt;&lt;ul&gt; &lt;?phpif($getltd_num == '0') {$money_lack = $ltd_price - $money_current;echo &quot;This item is no longer available, sorry.&quot;;?&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;h3&gt;&lt;?php echo &quot;$ltd_name&quot;?&gt;&lt;/h3&gt;&lt;img src=&quot;&lt;?php echo &quot;$image_url&quot; ?&gt;&quot; style=&quot;float: right&quot;&gt;&lt;br&gt;Sold out.&lt;br&gt;&lt;br&gt;&lt;?php }else{if($money_current &lt; $ltd_price){echo &quot;You need $money_lack more credits in order to buy this item.&quot;;?&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;h3&gt;&lt;?php echo &quot;$ltd_name&quot;?&gt;&lt;/h3&gt;&lt;img src=&quot;&lt;?php echo &quot;$image_url&quot; ?&gt;&quot; style=&quot;float: right&quot;&gt;&lt;br&gt;Out of credits.&lt;br&gt;&lt;br&gt;&lt;?php} else{ ?&gt;&lt;img src=&quot;&lt;?php echo &quot;$image_url&quot; ?&gt;&quot; style=&quot;float: right&quot;&gt;&lt;font size=&quot;2&quot; color=&quot;white&quot;&gt; &lt;h3&gt;Buy&lt;/h3&gt;&lt;p&gt;Buy your &lt;?php echo &quot;$ltd_name&quot;?&gt; for just &lt;?php echo &quot;$ltd_price&quot;?&gt; credits.&lt;br&gt;&lt;/font&gt;&lt;font size=&quot;2&quot; color=&quot;purple&quot;&gt;Only &lt;?php echo &quot;$getltd_num&quot;; ?&gt; of &lt;?php echo &quot;$getltd_total&quot;; ?&gt; left!&lt;/p&gt;&lt;/font&gt;&lt;form action=&quot;buyltd&quot; method=&quot;post&quot;&gt;&lt;input type=&quot;hidden&quot; name=&quot;ltd_id&quot; value=&quot;&lt;?php echo &quot;$ltd_id&quot;; ?&gt;&quot;&gt;&lt;input type=&quot;submit&quot; type=&quot;submit&quot; name=&quot;help&quot; value=&quot;Buy&quot; class=&quot;button round&quot;&gt; &lt;/form&gt;&lt;/b&gt; &lt;?php }}?&gt;&lt;/div&gt;&lt;/ul&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;[/PHP]This code is made for Priv theme, so if you use other you proberbly need to edit it.&nbsp;Each time you want to add a new furniture, you have to duplicate this code, edit in database table rev_ltd (insert record for each furniture you want to add), furni_id should be the same as 'id' of the furniture is in table 'furniture'.&nbsp;Images:<img src="http://puu.sh/2pQSa" alt="" class="fr-fic fr-dii fr-draggable " style="" /></blockquote>

[QUOTE="thewicard, post: 191850, member: 8814"] So, I used a few hours figuring this out xP Hope you enjoy. Sorry about insanely long code. Price is now configured in DB. What does this code do? It allows you to sell furniture in limited quantities. Is it secure? It has double money-in-pocket check [B](1 in whatever page it's placed in AND 1 when delivering furniture)[/B] It has double furniture-not-sold-out check [B](1 in whatever page it's placed in AND 1 when delivering furniture)[/B] Will not work to refresh page to get another furniture unless there are still available AND you have money for it. Added POST Filter [B](Now only allow numeric posts)[/B] //Thanks to Leenster for telling me it was needed. First: Run this queue [PHP]DROP TABLE IF EXISTS `rev_ltd`; CREATE TABLE `rev_ltd` ( `furni_id` int(255) NOT NULL, `furni_left` int(255) NOT NULL DEFAULT '100', `furni_sold` int(255) NOT NULL DEFAULT '0', `furni_price` int(255) NOT NULL DEFAULT '5000', PRIMARY KEY (`furni_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `rev_ltd` VALUES ('227', '15', '0', '5000');[/PHP] Second: Create a file in app/tpl/skins/YOURSKIN/ named buyltd.php Place this content in the file and save: [PHP]<?php $ltd_id = preg_replace('/[^0-9]/', '', $_POST["ltd_id"]); $user_id = $_SESSION['user']['id']; $selectfromusers = mysql_query("SELECT * FROM users WHERE id = '".$user_id."'") or die(mysql_error()); while ($getmoney = mysql_fetch_array($selectfromusers)) $money_current = $getmoney['credits']; $selectfromfurninum = mysql_query("SELECT * FROM rev_ltd WHERE furni_id = '".$ltd_id."'") or die(mysql_error()); while ($getfurninum = mysql_fetch_array($selectfromfurninum)) $furnileft = $getfurninum['furni_left'] and $furnisold = $getfurninum['furni_sold'] and $ltd_price = $getfurninum['furni_price']; if($furnileft > '0') { if($money_current < $ltd_price) { echo "You don't have enough money for this item"; } else { $newmoney = $money_current - $ltd_price; mysql_query("UPDATE users SET credits='".$newmoney."' WHERE id='".$user_id."'") or die(mysql_error()); $newfurnileft = $furnileft - '1'; $newfurnisold = $furnisold + '1'; mysql_query("UPDATE rev_ltd SET furni_sold='".$newfurnisold."'") or die(mysql_error()); mysql_query("UPDATE rev_ltd SET furni_left='".$newfurnileft."'") or die(mysql_error()); $highestid = mysql_query("SELECT * from items ORDER BY id DESC LIMIT 1") or die(mysql_error()); while ($checknewid2 = mysql_fetch_array($highestid)) $newid2 = $checknewid2['id']; $newid = $newid2 + '1'; mysql_query("INSERT INTO items (id, user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos) VALUES ('".$newid."','".$user_id."',0,'".$ltd_id."',0,0,0,0,0,0)") or die(mysql_error()); echo "Item bough successfully!"; } } else { echo "All of furniture is already sold, sorry"; } ?> <meta http-equiv="refresh" content="1; URL=me">[/PHP] Third: Goto whatever page you want this in, add this at the top: [PHP]<?php $user_id = $_SESSION['user']['id']; $selectfromusers = mysql_query("SELECT * FROM users WHERE id = '".$user_id."'") or die(mysql_error()); while ($getmoney = mysql_fetch_array($selectfromusers)) $money_current = $getmoney['credits']; ?>[/PHP] Forth: Add this wherever you want the output, this is made for Priv theme. [PHP]<?php //Furniconfiguration $ltd_id = "227"; //furni_id in the database $ltd_name = "Dragonegg"; //The name of your furni $image_url = "http://habboxwiki.com/wiki/images/1/12/Black_Dino_Egg.png"; //Image URL (optional) //Collects data from database $selectfromltd = mysql_query("SELECT * FROM rev_ltd WHERE furni_id = '".$ltd_id."'") or die(mysql_error()); while ($getltd = mysql_fetch_array($selectfromltd)) $getltd_num = $getltd['furni_left'] and $getltd_sold = $getltd['furni_sold'] and $ltd_price = $getltd['furni_price']; $getltd_total = $getltd_sold + $getltd_num; $money_lack = $ltd_price - $money_current; ?>  <div class="left page round"><ul> <?php if($getltd_num == '0') { $money_lack = $ltd_price - $money_current; echo "This item is no longer available, sorry.";?> <h3><?php echo "$ltd_name"?></h3><img src="<?php echo "$image_url" ?>" style="float: right"> Sold out. <?php } else { if($money_current < $ltd_price) { echo "You need $money_lack more credits in order to buy this item.";?> <h3><?php echo "$ltd_name"?></h3><img src="<?php echo "$image_url" ?>" style="float: right"> Out of credits. <?php } else{ ?> <img src="<?php echo "$image_url" ?>" style="float: right"> <h3>Buy</h3> Buy your <?php echo "$ltd_name"?> for just <?php echo "$ltd_price"?> credits. Only <?php echo "$getltd_num"; ?> of <?php echo "$getltd_total"; ?> left! <form action="buyltd" method="post"> <input type="hidden" name="ltd_id" value="<?php echo "$ltd_id"; ?>"> <input type="submit" type="submit" name="help" value="Buy" class="button round"> </form> <?php }}?> </div></ul> [/PHP] This code is made for Priv theme, so if you use other you proberbly need to edit it. Each time you want to add a new furniture, you have to duplicate this code, edit in database table rev_ltd (insert record for each furniture you want to add), furni_id should be the same as 'id' of the furniture is in table 'furniture'. Images: [IMG]http://puu.sh/2pQSa[/IMG] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members