Reply to thread

Message

<blockquote data-quote="TropicalSkittles" data-source="post: 71120" data-attributes="member: 10011">Hello i have nearly done my shop but cant get the page working...&nbsp;photoshot: <a href="http://prntscr.com/5vwim" target="_blank">http://prntscr.com/5vwim</a> (shop_furni.php)photoshot: <a href="http://prntscr.com/5vwjl" target="_blank">http://prntscr.com/5vwjl </a>(shop_badge.php)&nbsp;Here is the code for the shop_furni&nbsp;[PHP]&lt;?php/*===================================================+|| # HoloCMS - Website and Content Management System|+===================================================+|| # Copyright © 2008 Meth0d. All rights reserved.|| # http://www.meth0d.org|+===================================================+|| # HoloCMS is provided &quot;as is&quot; and comes without|| # warrenty of any kind. HoloCMS is free software!|+===================================================+|| # HoloShop 1.0 Coded By Yifan Lu|+===================================================*/&nbsp;$allow_guests = true;&nbsp;include('core.php');include('includes/session.php');&nbsp;$pagename = &quot;Furni Shop&quot;;$pageid = &quot;fshop&quot;;&nbsp;include('templates/community/subheader.php');include('templates/community/header.php');&nbsp;$search = FilterText($_POST['search']);$category = FilterText($_GET['category']);if($category == &quot;&quot;){ $category = 1; }$page = FilterText($_GET['page']);if($page == &quot;&quot; || $page &lt; 1){ $page = 1; }$page = $page - 1;&nbsp;$userrow = mysql_fetch_assoc(mysql_query(&quot;SELECT rank FROM users WHERE id = '&quot;.$my_id.&quot;' LIMIT 1&quot;));$rank = $userrow['rank'];&nbsp;if(isset($_POST['quantity']) == true){$quantity = FilterText($_POST['quantity']);if(is_numeric($quantity) == false){ $quantity = 1; }$boughtid = FilterText($_POST['furniID']);if(function_exists(SendMUSData) !== true){ include('./includes/mus.php'); }$furnirow = mysql_fetch_assoc(mysql_query(&quot;SELECT * FROM catalogue_items WHERE tid = '&quot;.$boughtid.&quot;' LIMIT 1&quot;));$price = $furnirow['catalogue_cost'] * $quantity;$furnicat = mysql_fetch_assoc(mysql_query(&quot;SELECT minrank FROM catalogue_pages WHERE indexid = '&quot;.$furnirow['catalogue_id_page'].&quot;' LIMIT 1&quot;));if($furnicat['minrank'] &lt;= $user_rank){if($price &lt;= $myrow['credits']){mysql_query(&quot;UPDATE users SET credits = credits - &quot;.$price.&quot; WHERE id='&quot;.$my_id.&quot;' LIMIT 1&quot;) or die(mysql_error());$i = 0;while($i &lt; $quantity){$i++;mysql_query(&quot;INSERT INTO furniture (ownerid,roomid,tid) VALUES ('&quot;.$my_id.&quot;','0','&quot;.$boughtid.&quot;')&quot;) or die(mysql_error());}mysql_query(&quot;INSERT INTO cms_transactions (userid,amount,date,descr) VALUES ('&quot;.$my_id.&quot;','&quot;.$price.&quot;','&quot;.$date_full.&quot;','Bought &quot;.$quantity.&quot; &quot;.$furnirow['catalogue_name'].&quot;')&quot;) or die(mysql_error());// katsjing sound@SendMUSData('UPRC' . $my_id);// reload hand@SendMUSData('UPRH' . $my_id);// Now we say in a message he has the furniture!$text = &quot;Successfuly purchased &quot;.$quantity.&quot; &quot;.$furnirow['catalogue_name'].&quot;.&quot;;$color = &quot;green&quot;;}else{$text = &quot;You do not have enough credits to purchase this item.&quot;;$color = &quot;red&quot;;}}else{$text = &quot;You do not have the privilege to purchase this item.&quot;;$color = &quot;red&quot;;}}&nbsp;?&gt;&lt;script src=&quot;web-gallery/static/js/shop_furni.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;&lt;?php$pagessql = mysql_query(&quot;SELECT * FROM catalogue_pages WHERE minrank &lt;= '&quot;.$rank.&quot;' ORDER BY indexid ASC&quot;);?&gt;&nbsp;&lt;div id=&quot;container&quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;content&quot; style=&quot;position: relative; left: 0px; top: 0px;&quot; class=&quot;clearfix&quot;&gt;&nbsp;&lt;div class=&quot;column&quot; style=&quot;width: 212px&quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix blue &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;Search&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;credits-safety&quot; class=&quot;box-content credits-info&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;text-align: center&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;form action=&quot;./shop_furni.php&quot; method=&quot;post&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;search&quot; value=&quot;&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;Search&quot; class=&quot;submit&quot; id=&quot;submit-button&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/form&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix blue &quot;&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;Categories&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;credits-safety&quot; class=&quot;box-content credits-info&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;credit-info-text clearfix&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_assoc($pagessql)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($category == $row['indexid']){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;strong&gt;&quot;.$row['displayname'].&quot;&lt;/strong&gt;&lt;br /&gt;\n&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;a href=\&quot;./shop_furni.php?category=&quot;.$row['indexid'].&quot;\&quot;&gt;&quot;.$row['displayname'].&quot;&lt;/a&gt;&lt;br /&gt;\n&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;column&quot; style=&quot;width: 527px&quot;&gt;&lt;?php if(isset($text)){ ?&gt;&lt;div class=&quot;rounded rounded-&lt;?php echo $color; ?&gt;&quot;&gt;&nbsp; &nbsp; &lt;?php echo $text; ?&gt;&lt;/div&gt;&lt;?php } ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix notitle &quot;&gt;&nbsp;&lt;?php if($search == &quot;&quot;){ ?&gt;&lt;?php if($category == 1){ ?&gt;&lt;div id=&quot;credits-safety&quot; class=&quot;box-content credits-info&quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;credit-info-text clearfix&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;center&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&lt;img src=&quot;./web-gallery/images/catalogue/headers/Frontpage.gif&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;Select a category from the left to begin browsing the shop&nbsp; &nbsp; &nbsp; &nbsp; &lt;/center&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;?php }else{ ?&gt;&lt;div id=&quot;credits-safety&quot; class=&quot;box-content credits-info&quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;credit-info-text clearfix&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;center&gt;&lt;?php$currentcat = mysql_fetch_assoc(mysql_query(&quot;SELECT displayname FROM catalogue_pages WHERE indexid = '&quot;.$category.&quot;' LIMIT 1&quot;));$catname = $currentcat['displayname'];?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img src=&quot;./web-gallery/images/catalogue/headers/&lt;?php echo $catname; ?&gt;.gif&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/center&gt;&lt;?php$sql = mysql_query(&quot;SELECT * FROM catalogue_items WHERE catalogue_id_page = '&quot;.$category.&quot;' ORDER BY catalogue_name ASC LIMIT 20 OFFSET &quot;.$page*20);$i = 0;&nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_assoc($sql)) {&nbsp; &nbsp; &nbsp; &nbsp; $i++;&nbsp; &nbsp; &nbsp; &nbsp; if(IsEven($i)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $even = &quot;even&quot;;&nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $even = &quot;odd&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;&lt;?php echo $even; ?&gt;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table style=&quot;width: 100%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr align=&quot;center&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 25%&quot;&gt;&lt;img src=&quot;./web-gallery/images/catalogue/&lt;?php echo $row['picture']; ?&gt;&quot; /&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 35%&quot;&gt;&lt;b&gt;&lt;?php echo $row['catalogue_name']; ?&gt;&lt;/b&gt;&lt;br /&gt;&lt;?php echo $row['catalogue_description']; ?&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 15%&quot;&gt;&lt;?php echo $row['catalogue_cost']; ?&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 25%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a class=&quot;new-button fill&quot; onclick=&quot;habboclub.buttonClick(&lt;?php echo $row['tid']; ?&gt;,'Confirm Purchase'); return false;&quot; href=&quot;#&quot;&gt;&lt;b&gt;Buy Now&lt;/b&gt;&lt;i&gt;&lt;/i&gt;&lt;/a&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php }$sql = mysql_query(&quot;SELECT * FROM catalogue_items WHERE catalogue_id_page = '&quot;.$category.&quot;'&quot;);$numofitems = mysql_num_rows($sql);$pages = ceil($numofitems / 20);$i = 1;?&gt;&lt;center&gt;&lt;?phpwhile($i &lt;= $pages){if($i == $pages){&nbsp; &nbsp; if($page + 1 == $i){&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;strong&gt;&quot;.$i.&quot;&lt;/strong&gt;&quot;;&nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;a href=\&quot;./shop_furni.php?category=&quot;.$category.&quot;&amp;page=&quot;.$i.&quot;\&quot;&gt;&quot;.$i.&quot;&lt;/a&gt;&quot;;&nbsp; &nbsp; }}else{&nbsp; &nbsp; if($page + 1 == $i){&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;strong&gt;&quot;.$i.&quot;&lt;/strong&gt; | &quot;;&nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;a href=\&quot;./shop_furni.php?category=&quot;.$category.&quot;&amp;page=&quot;.$i.&quot;\&quot;&gt;&quot;.$i.&quot;&lt;/a&gt; | &quot;;&nbsp; &nbsp; }}$i++;} ?&gt;&lt;/center&gt;&lt;/div&gt;&lt;?php } ?&gt;&lt;?php }else{ #Search ?&gt;&lt;div id=&quot;credits-safety&quot; class=&quot;box-content credits-info&quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;credit-info-text clearfix&quot;&gt;&lt;?php$sql = mysql_query(&quot;SELECT * FROM catalogue_items,catalogue_pages WHERE catalogue_items.catalogue_id_page = catalogue_pages.indexid AND (catalogue_name LIKE '%&quot;.$search.&quot;%' OR catalogue_description LIKE '%&quot;.$search.&quot;%' OR name_cct LIKE '%&quot;.$search.&quot;%') AND minrank &lt;= '&quot;.$rank.&quot;' LIMIT 20&quot;);$i = 0;&nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_assoc($sql)) {&nbsp; &nbsp; &nbsp; &nbsp; $i++;&nbsp; &nbsp; &nbsp; &nbsp; if(IsEven($i)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $even = &quot;even&quot;;&nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $even = &quot;odd&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;&lt;?php echo $even; ?&gt;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table style=&quot;width: 100%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr align=&quot;center&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 25%&quot;&gt;&lt;img src=&quot;./web-gallery/images/catalogue/&lt;?php echo $row['picture']; ?&gt;&quot; /&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 35%&quot;&gt;&lt;b&gt;&lt;?php echo $row['catalogue_name']; ?&gt;&lt;/b&gt;&lt;br /&gt;&lt;?php echo $row['catalogue_description']; ?&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 15%&quot;&gt;&lt;?php echo $row['catalogue_cost']; ?&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 25%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a class=&quot;new-button fill&quot; onclick=&quot;habboclub.buttonClick(&lt;?php echo $row['tid']; ?&gt;,'Confirm Purchase'); return false;&quot; href=&quot;#&quot;&gt;&lt;b&gt;Buy Now&lt;/b&gt;&lt;i&gt;&lt;/i&gt;&lt;/a&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/li&gt;&lt;?php } ?&gt;&lt;center&gt;Only the top 20 results are shown.&lt;/center&gt;&lt;/div&gt;&lt;?php}?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; HabboView.run();&nbsp; &nbsp; &lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }&lt;/script&gt;&nbsp;&nbsp;&lt;/div&gt;&lt;?php&nbsp;include('templates/community/footer.php');&nbsp;?&gt;[/PHP]&nbsp;Here is the code for my shop_badge&nbsp;[PHP]&lt;?php/*===================================================+|| # HoloCMS - Website and Content Management System|+===================================================+|| # Copyright © 2008 Meth0d. All rights reserved.|| # http://www.meth0d.org|+===================================================+|| # HoloCMS is provided &quot;as is&quot; and comes without|| # warrenty of any kind. HoloCMS is free software!|+===================================================+|| # HoloShop 1.0 Coded By Yifan Lu|+===================================================*/&nbsp;$allow_guests = true;&nbsp;include('core.php');include('includes/session.php');&nbsp;$pagename = &quot;Badge Shop&quot;;$pageid = &quot;bshop&quot;;&nbsp;include('templates/community/subheader.php');include('templates/community/header.php');&nbsp;$search = FilterText($_POST['search']);$category = FilterText($_GET['category']);if($category == &quot;&quot;){ $category = 1; }$page = FilterText($_GET['page']);if($page == &quot;&quot; || $page &lt; 1){ $page = 1; }$page = $page - 1;&nbsp;$userrow = mysql_fetch_assoc(mysql_query(&quot;SELECT rank FROM users WHERE id = '&quot;.$my_id.&quot;' LIMIT 1&quot;));$rank = $userrow['rank'];&nbsp;?&gt;&lt;script src=&quot;web-gallery/static/js/shop_badge.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;&lt;?php$pagessql = mysql_query(&quot;SELECT * FROM cms_badge_shop GROUP BY category ORDER BY category ASC&quot;);?&gt;&nbsp;&lt;div id=&quot;container&quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;content&quot; style=&quot;position: relative; left: 0px; top: 0px;&quot; class=&quot;clearfix&quot;&gt;&nbsp;&lt;div class=&quot;column&quot; style=&quot;width: 212px&quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix blue &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;Search&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;credits-safety&quot; class=&quot;box-content credits-info&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;text-align: center&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;form action=&quot;./shop_badge.php&quot; method=&quot;post&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;search&quot; value=&quot;&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;Search&quot; class=&quot;submit&quot; id=&quot;submit-button&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/form&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix blue &quot;&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;Categories&lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;credits-safety&quot; class=&quot;box-content credits-info&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;credit-info-text clearfix&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_assoc($pagessql)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($category == $row['category']){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;strong&gt;&quot;.$row['category'].&quot;&lt;/strong&gt;&lt;br /&gt;\n&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;a href=\&quot;./shop_badge.php?category=&quot;.$row['category'].&quot;\&quot;&gt;&quot;.$row['category'].&quot;&lt;/a&gt;&lt;br /&gt;\n&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;div class=&quot;column&quot; style=&quot;width: 527px&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix notitle &quot;&gt;&nbsp;&lt;?php if($search == &quot;&quot;){ ?&gt;&lt;?php if($category == 1){ ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;center&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&lt;img src=&quot;./web-gallery/images/catalogue/headers/Frontpage.gif&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;Select a category from the left to begin browsing the shop&nbsp; &nbsp; &nbsp; &nbsp; &lt;/center&gt;&lt;?php }else{ ?&gt;&lt;div id=&quot;credits-safety&quot; class=&quot;box-content credits-info&quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;credit-info-text clearfix&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;center&gt;&lt;?php$catname = $category;$sql = mysql_query(&quot;SELECT * FROM cms_badge_shop WHERE category = '&quot;.$category.&quot;' AND enabled = '1' AND minrank &lt;= '&quot;.$rank.&quot;' ORDER BY id ASC LIMIT 20 OFFSET &quot;.$page*20);$i = 0;&nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_assoc($sql)) {&nbsp; &nbsp; &nbsp; &nbsp; $i++;&nbsp; &nbsp; &nbsp; &nbsp; if(IsEven($i)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $even = &quot;even&quot;;&nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $even = &quot;odd&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;&lt;?php echo $even; ?&gt;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table style=&quot;width: 100%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr align=&quot;center&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 25%&quot;&gt;&lt;img src=&quot;&lt;?php echo $cimagesurl.$badgesurl.$row['image'].&quot;.gif&quot;; ?&gt;&quot; /&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 35%&quot;&gt;&lt;b&gt;&lt;?php echo $row['name']; ?&gt;&lt;/b&gt;&lt;br /&gt;&lt;?php echo $row['description']; ?&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 15%&quot;&gt;&lt;?php echo $row['cost']; ?&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 25%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a class=&quot;new-button fill&quot; onclick=&quot;habboclub.buttonClick(&lt;?php echo $row['id']; ?&gt;,'Confirm Purchase'); return false;&quot; href=&quot;#&quot;&gt;&lt;b&gt;Buy Now&lt;/b&gt;&lt;i&gt;&lt;/i&gt;&lt;/a&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/li&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;?php }$sql = mysql_query(&quot;SELECT * FROM cms_badge_shop WHERE category = '&quot;.$category.&quot;' AND enabled = '1' AND minrank &lt;= '&quot;.$rank.&quot;'&quot;);$numofitems = mysql_num_rows($sql);$pages = ceil($numofitems / 20);$i = 1;?&gt;&lt;center&gt;&lt;?phpwhile($i &lt;= $pages){if($i == $pages){&nbsp; &nbsp; if($page + 1 == $i){&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;strong&gt;&quot;.$i.&quot;&lt;/strong&gt;&quot;;&nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;a href=\&quot;./shop_furni.php?category=&quot;.$category.&quot;&amp;page=&quot;.$i.&quot;\&quot;&gt;&quot;.$i.&quot;&lt;/a&gt;&quot;;&nbsp; &nbsp; }}else{&nbsp; &nbsp; if($page + 1 == $i){&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;strong&gt;&quot;.$i.&quot;&lt;/strong&gt; | &quot;;&nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;a href=\&quot;./shop_furni.php?category=&quot;.$category.&quot;&amp;page=&quot;.$i.&quot;\&quot;&gt;&quot;.$i.&quot;&lt;/a&gt; | &quot;;&nbsp; &nbsp; }}$i++;} ?&gt;&lt;/center&gt;&lt;/div&gt;&lt;?php } ?&gt;&lt;?php }else{ #Search ?&gt;&lt;div id=&quot;credits-safety&quot; class=&quot;box-content credits-info&quot;&gt;&nbsp; &nbsp; &lt;div class=&quot;credit-info-text clearfix&quot;&gt;&lt;?php$sql = mysql_query(&quot;SELECT * FROM cms_badge_shop WHERE (name LIKE '&quot;.$search.&quot;%' OR description LIKE '%&quot;.$search.&quot;%') AND enabled = '1' AND minrank &lt;= '&quot;.$rank.&quot;' ORDER BY id ASC LIMIT 20&quot;);$i = 0;&nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_assoc($sql)) {&nbsp; &nbsp; &nbsp; &nbsp; $i++;&nbsp; &nbsp; &nbsp; &nbsp; if(IsEven($i)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $even = &quot;even&quot;;&nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $even = &quot;odd&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class=&quot;&lt;?php echo $even; ?&gt;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;table style=&quot;width: 100%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr align=&quot;center&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr align=&quot;center&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 25%&quot;&gt;&lt;img src=&quot;&lt;?php echo $cimagesurl.$badgesurl.$row['image'].&quot;.gif&quot;; ?&gt;&quot; /&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 35%&quot;&gt;&lt;b&gt;&lt;?php echo $row['name']; ?&gt;&lt;/b&gt;&lt;br /&gt;&lt;?php echo $row['description']; ?&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 15%&quot;&gt;&lt;?php echo $row['cost']; ?&gt;&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td style=&quot;width: 25%&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a class=&quot;new-button fill&quot; onclick=&quot;habboclub.buttonClick(&lt;?php echo $row['id']; ?&gt;,'Confirm Purchase'); return false;&quot; href=&quot;#&quot;&gt;&lt;b&gt;Buy Now&lt;/b&gt;&lt;i&gt;&lt;/i&gt;&lt;/a&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/li&gt;&lt;?php } ?&gt;&lt;center&gt;Only the top 20 results are shown.&lt;/center&gt;&lt;/div&gt;&lt;?php}?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; HabboView.run();&nbsp; &nbsp; &lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }&lt;/script&gt;&nbsp;&nbsp;&lt;/div&gt;&lt;?php&nbsp;include('templates/community/footer.php');&nbsp;?&gt;[/PHP]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</blockquote>

[QUOTE="TropicalSkittles, post: 71120, member: 10011"] Hello i have nearly done my shop but cant get the page working... photoshot: [URL]http://prntscr.com/5vwim[/URL] (shop_furni.php) photoshot: [URL='http://prntscr.com/5vwjl']http://prntscr.com/5vwjl [/URL](shop_badge.php) [COLOR=#ff0000]Here is the code for the shop_furni[/COLOR] [PHP]<?php /*===================================================+ || # HoloCMS - Website and Content Management System |+===================================================+ || # Copyright © 2008 Meth0d. All rights reserved. || # http://www.meth0d.org |+===================================================+ || # HoloCMS is provided "as is" and comes without || # warrenty of any kind. HoloCMS is free software! |+===================================================+ || # HoloShop 1.0 Coded By Yifan Lu |+===================================================*/ $allow_guests = true; include('core.php'); include('includes/session.php'); $pagename = "Furni Shop"; $pageid = "fshop"; include('templates/community/subheader.php'); include('templates/community/header.php'); $search = FilterText($_POST['search']); $category = FilterText($_GET['category']); if($category == ""){ $category = 1; } $page = FilterText($_GET['page']); if($page == "" || $page < 1){ $page = 1; } $page = $page - 1; $userrow = mysql_fetch_assoc(mysql_query("SELECT rank FROM users WHERE id = '".$my_id."' LIMIT 1")); $rank = $userrow['rank']; if(isset($_POST['quantity']) == true){ $quantity = FilterText($_POST['quantity']); if(is_numeric($quantity) == false){ $quantity = 1; } $boughtid = FilterText($_POST['furniID']); if(function_exists(SendMUSData) !== true){ include('./includes/mus.php'); } $furnirow = mysql_fetch_assoc(mysql_query("SELECT * FROM catalogue_items WHERE tid = '".$boughtid."' LIMIT 1")); $price = $furnirow['catalogue_cost'] * $quantity; $furnicat = mysql_fetch_assoc(mysql_query("SELECT minrank FROM catalogue_pages WHERE indexid = '".$furnirow['catalogue_id_page']."' LIMIT 1")); if($furnicat['minrank'] <= $user_rank){ if($price <= $myrow['credits']){ mysql_query("UPDATE users SET credits = credits - ".$price." WHERE id='".$my_id."' LIMIT 1") or die(mysql_error()); $i = 0; while($i < $quantity){ $i++; mysql_query("INSERT INTO furniture (ownerid,roomid,tid) VALUES ('".$my_id."','0','".$boughtid."')") or die(mysql_error()); } mysql_query("INSERT INTO cms_transactions (userid,amount,date,descr) VALUES ('".$my_id."','".$price."','".$date_full."','Bought ".$quantity." ".$furnirow['catalogue_name']."')") or die(mysql_error()); // katsjing sound @SendMUSData('UPRC' . $my_id); // reload hand @SendMUSData('UPRH' . $my_id); // Now we say in a message he has the furniture! $text = "Successfuly purchased ".$quantity." ".$furnirow['catalogue_name']."."; $color = "green"; }else{ $text = "You do not have enough credits to purchase this item."; $color = "red"; } }else{ $text = "You do not have the privilege to purchase this item."; $color = "red"; } } ?><script src="web-gallery/static/js/shop_furni.js" type="text/javascript"></script><?php $pagessql = mysql_query("SELECT * FROM catalogue_pages WHERE minrank <= '".$rank."' ORDER BY indexid ASC"); ?> <div id="container"> <div id="content" style="position: relative; left: 0px; top: 0px;" class="clearfix"> <div class="column" style="width: 212px"> <div class="habblet-container "> <div class="cbb clearfix blue "> <h2 class="title">Search</h2> <div id="credits-safety" class="box-content credits-info"> <div style="text-align: center"> <form action="./shop_furni.php" method="post"> <input type="text" name="search" value="" /> <input type="submit" value="Search" class="submit" id="submit-button" /> </form> </div> </div> </div> </div> <div class="habblet-container "> <div class="cbb clearfix blue "> <h2 class="title">Categories</h2> <div id="credits-safety" class="box-content credits-info"> <div class="credit-info-text clearfix"> <?php while($row = mysql_fetch_assoc($pagessql)) { if($category == $row['indexid']){ echo "".$row['displayname']." \n"; }else{ echo "<a href=\"./shop_furni.php?category=".$row['indexid']."\">".$row['displayname']."</a> \n"; } } ?> </div> </div> </div> </div> </div> <div class="column" style="width: 527px"> <?php if(isset($text)){ ?> <div class="rounded rounded-<?php echo $color; ?>"> <?php echo $text; ?> </div> <?php } ?> <div class="habblet-container "> <div class="cbb clearfix notitle "> <?php if($search == ""){ ?> <?php if($category == 1){ ?> <div id="credits-safety" class="box-content credits-info"> <div class="credit-info-text clearfix"> <center> <img src="./web-gallery/images/catalogue/headers/Frontpage.gif" /> Select a category from the left to begin browsing the shop </center> </div> </div> <?php }else{ ?> <div id="credits-safety" class="box-content credits-info"> <div class="credit-info-text clearfix"> <center> <?php $currentcat = mysql_fetch_assoc(mysql_query("SELECT displayname FROM catalogue_pages WHERE indexid = '".$category."' LIMIT 1")); $catname = $currentcat['displayname']; ?> <img src="./web-gallery/images/catalogue/headers/<?php echo $catname; ?>.gif" /> </center> <?php $sql = mysql_query("SELECT * FROM catalogue_items WHERE catalogue_id_page = '".$category."' ORDER BY catalogue_name ASC LIMIT 20 OFFSET ".$page*20); $i = 0; while($row = mysql_fetch_assoc($sql)) { $i++; if(IsEven($i)){ $even = "even"; } else { $even = "odd"; } ?> <li class="<?php echo $even; ?>"> <table style="width: 100%"> <tr align="center"> <td style="width: 25%"><img src="./web-gallery/images/catalogue/<?php echo $row['picture']; ?>" /></td> <td style="width: 35%"><?php echo $row['catalogue_name']; ?> <?php echo $row['catalogue_description']; ?></td> <td style="width: 15%"><?php echo $row['catalogue_cost']; ?></td> <td style="width: 25%"> <a class="new-button fill" onclick="habboclub.buttonClick(<?php echo $row['tid']; ?>,'Confirm Purchase'); return false;" href="#">Buy Now</a> </td> </tr> </table> </li> <?php } $sql = mysql_query("SELECT * FROM catalogue_items WHERE catalogue_id_page = '".$category."'"); $numofitems = mysql_num_rows($sql); $pages = ceil($numofitems / 20); $i = 1; ?><center><?php while($i <= $pages){ if($i == $pages){ if($page + 1 == $i){ echo "".$i.""; }else{ echo "<a href=\"./shop_furni.php?category=".$category."&page=".$i."\">".$i."</a>"; } }else{ if($page + 1 == $i){ echo "".$i." | "; }else{ echo "<a href=\"./shop_furni.php?category=".$category."&page=".$i."\">".$i."</a> | "; } } $i++; } ?></center></div> <?php } ?> <?php }else{ #Search ?> <div id="credits-safety" class="box-content credits-info"> <div class="credit-info-text clearfix"> <?php $sql = mysql_query("SELECT * FROM catalogue_items,catalogue_pages WHERE catalogue_items.catalogue_id_page = catalogue_pages.indexid AND (catalogue_name LIKE '%".$search."%' OR catalogue_description LIKE '%".$search."%' OR name_cct LIKE '%".$search."%') AND minrank <= '".$rank."' LIMIT 20"); $i = 0; while($row = mysql_fetch_assoc($sql)) { $i++; if(IsEven($i)){ $even = "even"; } else { $even = "odd"; } ?> <li class="<?php echo $even; ?>"> <table style="width: 100%"> <tr align="center"> <td style="width: 25%"><img src="./web-gallery/images/catalogue/<?php echo $row['picture']; ?>" /></td> <td style="width: 35%"><?php echo $row['catalogue_name']; ?> <?php echo $row['catalogue_description']; ?></td> <td style="width: 15%"><?php echo $row['catalogue_cost']; ?></td> <td style="width: 25%"> <a class="new-button fill" onclick="habboclub.buttonClick(<?php echo $row['tid']; ?>,'Confirm Purchase'); return false;" href="#">Buy Now</a> </td> </tr> </table> </li> <?php } ?> <center>Only the top 20 results are shown.</center> </div> <?php } ?> </div> </div> </div> <script type="text/javascript"> HabboView.run(); </script> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script> </div> <?php include('templates/community/footer.php'); ?>[/PHP] [COLOR=#ff0000]Here is the code for my shop_badge[/COLOR] [PHP]<?php /*===================================================+ || # HoloCMS - Website and Content Management System |+===================================================+ || # Copyright © 2008 Meth0d. All rights reserved. || # http://www.meth0d.org |+===================================================+ || # HoloCMS is provided "as is" and comes without || # warrenty of any kind. HoloCMS is free software! |+===================================================+ || # HoloShop 1.0 Coded By Yifan Lu |+===================================================*/ $allow_guests = true; include('core.php'); include('includes/session.php'); $pagename = "Badge Shop"; $pageid = "bshop"; include('templates/community/subheader.php'); include('templates/community/header.php'); $search = FilterText($_POST['search']); $category = FilterText($_GET['category']); if($category == ""){ $category = 1; } $page = FilterText($_GET['page']); if($page == "" || $page < 1){ $page = 1; } $page = $page - 1; $userrow = mysql_fetch_assoc(mysql_query("SELECT rank FROM users WHERE id = '".$my_id."' LIMIT 1")); $rank = $userrow['rank']; ?><script src="web-gallery/static/js/shop_badge.js" type="text/javascript"></script><?php $pagessql = mysql_query("SELECT * FROM cms_badge_shop GROUP BY category ORDER BY category ASC"); ?> <div id="container"> <div id="content" style="position: relative; left: 0px; top: 0px;" class="clearfix"> <div class="column" style="width: 212px"> <div class="habblet-container "> <div class="cbb clearfix blue "> <h2 class="title">Search</h2> <div id="credits-safety" class="box-content credits-info"> <div style="text-align: center"> <form action="./shop_badge.php" method="post"> <input type="text" name="search" value="" /> <input type="submit" value="Search" class="submit" id="submit-button" /> </form> </div> </div> </div> </div> <div class="habblet-container "> <div class="cbb clearfix blue "> <h2 class="title">Categories</h2> <div id="credits-safety" class="box-content credits-info"> <div class="credit-info-text clearfix"> <?php while($row = mysql_fetch_assoc($pagessql)) { if($category == $row['category']){ echo "".$row['category']." \n"; }else{ echo "<a href=\"./shop_badge.php?category=".$row['category']."\">".$row['category']."</a> \n"; } } ?> </div> </div> </div> </div> </div> <div class="column" style="width: 527px"> <div class="habblet-container "> <div class="cbb clearfix notitle "> <?php if($search == ""){ ?> <?php if($category == 1){ ?> <center> <img src="./web-gallery/images/catalogue/headers/Frontpage.gif" /> Select a category from the left to begin browsing the shop </center> <?php }else{ ?> <div id="credits-safety" class="box-content credits-info"> <div class="credit-info-text clearfix"> <center> <?php $catname = $category; $sql = mysql_query("SELECT * FROM cms_badge_shop WHERE category = '".$category."' AND enabled = '1' AND minrank <= '".$rank."' ORDER BY id ASC LIMIT 20 OFFSET ".$page*20); $i = 0; while($row = mysql_fetch_assoc($sql)) { $i++; if(IsEven($i)){ $even = "even"; } else { $even = "odd"; } ?> <li class="<?php echo $even; ?>"> <table style="width: 100%"> <tr align="center"> <td style="width: 25%"><img src="<?php echo $cimagesurl.$badgesurl.$row['image'].".gif"; ?>" /></td> <td style="width: 35%"><?php echo $row['name']; ?> <?php echo $row['description']; ?></td> <td style="width: 15%"><?php echo $row['cost']; ?></td> <td style="width: 25%"> <a class="new-button fill" onclick="habboclub.buttonClick(<?php echo $row['id']; ?>,'Confirm Purchase'); return false;" href="#">Buy Now</a> </td> </tr> </table> </li> <?php } $sql = mysql_query("SELECT * FROM cms_badge_shop WHERE category = '".$category."' AND enabled = '1' AND minrank <= '".$rank."'"); $numofitems = mysql_num_rows($sql); $pages = ceil($numofitems / 20); $i = 1; ?><center><?php while($i <= $pages){ if($i == $pages){ if($page + 1 == $i){ echo "".$i.""; }else{ echo "<a href=\"./shop_furni.php?category=".$category."&page=".$i."\">".$i."</a>"; } }else{ if($page + 1 == $i){ echo "".$i." | "; }else{ echo "<a href=\"./shop_furni.php?category=".$category."&page=".$i."\">".$i."</a> | "; } } $i++; } ?></center></div> <?php } ?> <?php }else{ #Search ?> <div id="credits-safety" class="box-content credits-info"> <div class="credit-info-text clearfix"> <?php $sql = mysql_query("SELECT * FROM cms_badge_shop WHERE (name LIKE '".$search."%' OR description LIKE '%".$search."%') AND enabled = '1' AND minrank <= '".$rank."' ORDER BY id ASC LIMIT 20"); $i = 0; while($row = mysql_fetch_assoc($sql)) { $i++; if(IsEven($i)){ $even = "even"; } else { $even = "odd"; } ?> <li class="<?php echo $even; ?>"> <table style="width: 100%"> <tr align="center"> <tr align="center"> <td style="width: 25%"><img src="<?php echo $cimagesurl.$badgesurl.$row['image'].".gif"; ?>" /></td> <td style="width: 35%"><?php echo $row['name']; ?> <?php echo $row['description']; ?></td> <td style="width: 15%"><?php echo $row['cost']; ?></td> <td style="width: 25%"> <a class="new-button fill" onclick="habboclub.buttonClick(<?php echo $row['id']; ?>,'Confirm Purchase'); return false;" href="#">Buy Now</a> </td> </tr> </table> </li> <?php } ?> <center>Only the top 20 results are shown.</center> </div> <?php } ?> </div> </div> </div> <script type="text/javascript"> HabboView.run(); </script> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script> </div> <?php include('templates/community/footer.php'); ?>[/PHP] [U][U][COLOR=#ff0000][/COLOR][/U][/U] [U][COLOR=#ff0000][/COLOR][/U] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members