Mpog itemshop

I have a problem organizing the items in the shop

here's a pic
http://up351.siz.co.il/up2/yyoezwiu2yyj.png

and here is the mod_itemshop.php

PHP Code:

<? include "anti_inject.php"; include "sql_check.php"; if ($_GET['expand'] == 1){ ?> <tr> <td width="917" colspan="5" height="26" style="background-image: url('images/subbar.jpg'); background-repeat: no-repeat; background-position: center top"> <p align="center"> <a href="index.php?do=myaccount&act=viewmyitems"> <img border="0" src="http://forum.ragezone.com/images/subbar/myitems.jpg" width="64" height="13"></a><a href="index.php?do=itemshop&sub=listallitems&expand=1"><img border="0" src="http://forum.ragezone.com/images/subbar/listallitems.jpg" width="100" height="13"></a><a href="index.php?do=itemshop&sub=help&expand=1"><img border="0" src="http://forum.ragezone.com/images/subbar/help.jpg" width="52" height="13"></a></td> </tr> <? } if(!function_exists("ListAllItems")){ function ListAllItems(){ if(!isset($_GET['type'])){ $type = ""; }else{ $type = "Slot = '".antisql($_GET['type'])."' AND"; } if(($_GET['type']) == 10){ msgbox ("Press Ok to go to Change Character Name page","index.php?do=ccn"); } $res = mssql_query("SELECT * FROM CashShop WHERE ".$type." Opened = '1'"); ?> <div align="center"> <table border="0" width="456" style="border-collapse: collapse"> <tr> <td background="http://forum.ragezone.com/images/cont_up.jpg"> </td> </tr> <tr> <td background="http://forum.ragezone.com/images/cont_bg.jpg"> <div align="center"> <table border="0" style="border-collapse: collapse" width="454" height="100%"> <tr> <td width="4" rowspan="11"> </td> <td width="440" colspan="2"> <img border="0" src="http://forum.ragezone.com/images/inf/listallitems.jpg"></td> <td width="30"> </td> </tr> <tr> <td width="12" colspan="2"></td> </tr> <tr> <td width="449" colspan="2"> <form name="itemtype"><select size="1" name="type" onchange="SwitchItem()"> <optgroup label="Select a Item Category"> <option value="2">Meele Weapons </option> <option value="3">Armor</option> <option value="4">Full Set </option> <option value="10">Change Character Name</option> <option value="5">Special Items </option> <option value="1">Ranged Weapons </option></optgroup> </select></form></td> </tr> <tr> <td width="449" colspan="2">  </td> </tr> <tr> <? while($item = mssql_fetch_assoc($res)) { if ($count == 2) { $count = 1; echo " </tr><tr> <td width='184'> </td> <td width='184'> </td> <td width='184'> </td> </tr><tr>"; ?> <td width="208"> <table border="0" style="border-collapse: collapse" width="102%" height="100%"> <tr> <td width="105" rowspan="8" valign="top"> <p align="center"> <img border="2" src="http://forum.ragezone.com/images/shop/<?=$item['WebImgName']?>"></td> <td width="106" valign="top"> <font color="#FF9933"><?=$item['Name']?></font></td> </tr> <tr> <td width="106" valign="top"> </td> </tr> <tr> <td width="106" valign="top"> Type: <? switch ( $item['Slot'] ){ case "1"; $slot = "Ranged"; break; case "2"; $slot = "Melee"; break; case "3"; $slot = "Armor"; break; case "4"; $slot = "Set"; break; case "5"; $slot = "Special"; break; } echo $slot; ?></td> </tr> <tr> <td width="106" valign="top"> Sex: <? switch ($item['ResSex']){ case "0"; $sex = "Man"; break; case "1"; $sex = "Woman"; break; case "2"; $sex = "All"; break; } echo $sex; ?></td> </tr> <tr> <td width="106" valign="top"> Lv. Min: <?=$item['ResLevel']?></td> </tr> <tr> <td width="106" valign="top"> Price: <?=$item['CashPrice']?></td> </tr> <tr> <td width="106"> <p align="center"> <a href="index.php?do=itemshop&sub=details&id=<?=$item['CSID']?>"><img border="0" src="http://forum.ragezone.com/images/buy_btn.jpg" width="47" height="19"></a></td> </tr> <tr> <td width="106"> </td> </tr> <tr> <td width="105"> </td> <td width="106"> </td> </tr> </table> </body> </html> </td> <? }else{ ?> <td width="208"> <table border="0" style="border-collapse: collapse" width="100%" height="100%"> <tr> <td width="105" rowspan="8" valign="top"> <p align="center"> <img border="2" src="http://forum.ragezone.com/images/shop/<?=$item['WebImgName']?>"></td> <td width="110" valign="top"> <font color="#FF9933"><?=$item['Name']?></font></td> </tr> <tr> <td width="110" valign="top"> </td> </tr> <tr> <td width="110" valign="top"> Type: <? switch ( $item['Slot'] ){ case "1"; $slot = "Ranged"; break; case "2"; $slot = "Melee"; break; case "3"; $slot = "Armor"; break; case "4"; $slot = "Set"; break; case "5"; $slot = "Special"; break; } echo $slot; ?></td> </tr> <tr> <td width="110" valign="top"> Sex: <? switch ($item['ResSex']){ case "0"; $sex = "Man"; break; case "1"; $sex = "Woman"; break; case "2"; $sex = "All"; break; } echo $sex; ?></td> </tr> <tr> <td width="110" valign="top"> Lv. Min: <?=$item['ResLevel']?></td> </tr> <tr> <td width="110" valign="top"> Price: <?=$item['CashPrice']?></td> </tr> <tr> <td width="110"> <p align="center"> <a href="index.php?do=itemshop&sub=details&id=<?=$item['CSID']?>"><img border="0" src="http://forum.ragezone.com/images/buy_btn.jpg" width="47" height="19"></a></td> </tr> <tr> <td width="110"> </td> </tr> <tr> <td width="105"> </td> <td width="110"> </td> </tr> </table> </body> </html> </td> <? $count++; } } ?> <td width="30">  <p> </p> <p> </p> <p> </td> </tr> <tr> <td width="445" colspan="2"> </td> </tr> <tr> <td width="12" colspan="2"></td> </tr> </table> </div> </td> </tr> <tr> <td background="http://forum.ragezone.com/images/cont_top.jpg" height="27"> </td> </tr> </table> </div> <? } } //Items details if(!function_exists("ShowItemsDetails")){ function ShowItemsDetails(){ if($_GET['id'] == ""){ re_dir("index.php"); } $itemid = antisql($_GET['id']); $res = mssql_query("SELECT * FROM CashShop WHERE CSID = '$itemid'"); $item = mssql_fetch_assoc($res); ?> <div align="center"> <table border="0" width="456" style="border-collapse: collapse"> <tr> <td background="http://forum.ragezone.com/images/cont_up.jpg"> </td> </tr> <tr> <td background="http://forum.ragezone.com/images/cont_bg.jpg"> <div align="center"> <table border="0" style="border-collapse: collapse" width="454" height="100%"> <tr> <td width="4" rowspan="7"> </td> <td width="429"> <img border="0" src="http://forum.ragezone.com/images/inf/itemdetails.jpg" width="413" height="18"></td> <td width="8"> </td> </tr> <tr> <td width="1"></td> </tr> <tr> <td width="438"> <table border="0" style="border-collapse: collapse" width="436" height="100%"> <tr> <td width="122" valign="top"> <table border="0" style="border-collapse: collapse" width="122"> <tr> <td width="11"> </td> <td width="91"> </td> <td width="14"> </td> </tr> <tr> <td width="11"> </td> <td width="91"> <img border="2" src="http://forum.ragezone.com/images/shop/<?=$item['WebImgName']?>" width="100" height="100"></td> <td width="14"> </td> </tr> <tr> <td width="11"> </td> <td width="91"> </td> <td width="14"> </td> </tr> </table> </td> <td width="310" valign="top"> <table border="0" style="border-collapse: collapse" width="310" height="100%"> <tr> <td height="15" width="308" colspan="2"> </td> </tr> <tr> <td height="15" width="308" colspan="2">   <div class="item_name"> <b> <span class="item_name"> <?=$item['Name']?></span></b></div> </td> </tr> <tr> <td width="55" height="15"> </td> <td width="251" height="15"> </td> </tr> <tr> <td width="55"><b>Type:</b></td> <td width="251"><? switch ( $item['Slot'] ){ case "1"; $slot = "Ranged"; break; case "2"; $slot = "Melee"; break; case "3"; $slot = "Armor"; break; case "4"; $slot = "Set"; break; case "5"; $slot = "Special"; break; } echo $slot; ?></td> </tr> <tr> <td width="55"><b>Sex:</b></td> <td width="251"> <? switch ($item['ResSex']){ case "0"; $sex = "Man"; break; case "1"; $sex = "Woman"; break; case "2"; $sex = "All"; break; } echo $sex; ?></td> </tr> <tr> <td width="55"><b>Level:</b></td> <td width="251"><?=$item['ResLevel']?></td> </tr> <tr> <td width="55"> <b>Weight:</b></td> <td width="251"><?=$item['Weight']?></td> </tr> <tr> <td width="55"><b>Price:</b></td> <td width="251"><?=$item['CashPrice']?></td> </tr> <tr> <td width="55"> </td> <td width="251"> </td> </tr> </table> </td> </tr> <tr> <td width="432" valign="top" colspan="2"> <div align="center"> <table border="0" style="border-collapse: collapse; background-image: url('images/iteminfo.jpg'); background-repeat: no-repeat; background-position: center top" width="422" height="110"> <tr> <td> <table border="0" style="border-collapse: collapse" width="420" height="100%"> <tr> <td width="130" height="27" colspan="4"> </td> <td width="146" height="27" colspan="3"> </td> <td width="128" height="27" colspan="3"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> <b> Damage</b></td> <td width="44" align="right"> <?=$item['Damage']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="88"> <b>AP</b></td> <td width="48" align="right"> <?=$item['AP']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="67"> <b>FR</b></td> <td width="62" align="right"> <?=$item['FR']?></td> <td width="4"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> <b>Delay</b></td> <td width="44" align="right"> <?=$item['Delay']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="88"> <b>HP</b></td> <td width="48" align="right"> <?=$item['HP']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="67"> <b>PR</b></td> <td width="62" align="right"> <?=$item['PR']?></td> <td width="4"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> <b> Magazine</b></td> <td width="44" align="right"> <?=$item['Magazine']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="88"> <b>Max Weight</b></td> <td width="48" align="right"> <?=$item['MaxWeight']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="67"> <b>CR</b></td> <td width="62" align="right"> <?=$item['CR']?></td> <td width="4"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> <b>Max Bullet</b></td> <td width="44" align="right"> <?=$item['MaxBullet']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="88"> <b> Reload Time</b></td> <td width="48" align="right"> <?=$item['ReloadTime']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="67"> <b>LR</b></td> <td width="62" align="right"> <?=$item['LR']?></td> <td width="4"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> <b> Control</b></td> <td width="44" align="right"> <?=$item['Control']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="88"> <b> <font color=ff0000>Hours</font></b></td> <td width="48" align="right"> <?=$item['Duration']?></td> <td width="4" style="background-image: url('images/table_sep.jpg')"> </td> <td width="67"> </td> <td width="62"> </td> <td width="4"> </td> </tr> <tr> <td width="7"> </td> <td width="75"> </td> <td width="51" colspan="2"> </td> <td width="88"> </td> <td width="54" colspan="2"> </td> <td width="67"> </td> <td width="68" colspan="2"> </td> </tr> </table> </td> </tr> </table> </div> </td> </tr> <tr> <td width="432" valign="top" colspan="2"> </td> </tr> <tr> <td width="432" valign="top" colspan="2"> <p align="center"> <a href="index.php?do=itemshop&sub=buyitem&expand=1&itemid=<?=$item['CSID']?>"> <img border="0" src="http://forum.ragezone.com/images/buyitem.jpg" width="70" height="27"></a>  <img border="0" src="http://forum.ragezone.com/images/giftitem.jpg" width="70" height="27" onclick="alert('Gift function will be available soon!')"></td> </tr> <tr> <td width="432" valign="top" colspan="2"> </td> </tr> </table> </td> </tr> <tr> <td width="1"></td> </tr> </table> </div> </td> </tr> <tr> <td background="http://forum.ragezone.com/images/cont_top.jpg" height="27"> </td> </tr> </table> </div> <? } } if(!function_exists("ShowBuyItem")){ function ShowBuyItem(){ if($_SESSION['AID'] == ""){ re_dir("index.php?do=login"); } $item2 = antisql($_GET['itemid']); $res = mssql_query("SELECT * FROM CashShop WHERE CSID = '$item2'"); $item = mssql_fetch_assoc($res); //And another one. $res2 = mssql_query("SELECT euCoins FROM Login WHERE AID = '" . antisql($_SESSION['AID']) . "'"); $acc = mssql_fetch_assoc($res2); if(isset($_POST['submit'])){ $itemid = antisql($_POST['ItemID']); $res = mssql_query("SELECT * FROM CashShop WHERE CSID = '$itemid'"); $item = mssql_fetch_assoc($res); //Oops? $res2 = mssql_query("SELECT euCoins FROM Login WHERE AID = '" . antisql($_SESSION['AID']) . "'"); $acc = mssql_fetch_assoc($res2); //Why create it here when you've used it without variable above? //Anyway. Antisql function applied. $aid = antisql($_SESSION['AID']); $updatecoins = $acc['euCoins'] - $item['CashPrice']; $zitemid = $item['zItemID']; if($updatecoins < 0){ die("No Bug here :) DreamGunz™"); } mssql_query("INSERT INTO AccountItem ([AID], [ItemID], [RentDate], [RentHourPeriod], [Cnt])VALUES('$aid', '$itemid', GETDATE(), 168, 0)"); mssql_query("UPDATE Login SET euCoins = '$updatecoins' WHERE AID = '$aid'"); msgbox("Item purchased correctly, you will be introduced in Storage","index.php?do=itemshop&expand=1"); } ?> <div align="center"> <table border="0" width="456" style="border-collapse: collapse"> <tr> <td background="http://forum.ragezone.com/images/cont_up.jpg"> </td> </tr> <tr> <td background="http://forum.ragezone.com/images/cont_bg.jpg"> <div align="center"> <table border="0" style="border-collapse: collapse" width="454" height="100%"> <tr> <td width="4" rowspan="7"> </td> <td width="429"> <img border="0" src="http://forum.ragezone.com/images/inf/buyitem.jpg" width="414" height="19"></td> <td width="8"> </td> </tr> <tr> <td width="1"></td> </tr> <tr> <td width="438"> <table border="0" style="border-collapse: collapse" width="436" height="100%"> <tr> <td width="200" valign="top"> </td> <td width="8" valign="top"> </td> <td width="222" valign="top"> </td> </tr> <tr> <td width="200" valign="top"> <p align="right">Name of item</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$item['Name']?></b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">Bill Current</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$_SESSION['UserID']?></b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">Price</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$item['CashPrice']?>,- </b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">DG Coins you have</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$acc['euCoins']?>,- </b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">DG Coins To you later</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><? $result = $acc['euCoins']-$item['CashPrice']; if($result < 0){ $boton = "<b>You Don't have enough DGCoins to make this purchase</b>"; }else{ $boton = "<input type='submit' value='Buy item' name='submit'>"; } echo $acc['euCoins']-$item['CashPrice'];?>,- </b></td> </tr> <tr> <td width="200" valign="top"> </td> <td width="8" valign="top"> </td> <td width="222" valign="top"> </td> </tr> <tr> <td width="430" valign="top" colspan="3"> <p align="center"> <font color="#FF0000"><b> NOTE: If you buy an item and then do not want, or is mistaken, we are not responsible</b></font></td> </tr> <tr> <td width="200" valign="top"> </td> <td width="8" valign="top"> </td> <td width="222" valign="top"> </td> </tr> <tr> <td width="430" valign="top" colspan="3"> <form method="POST" action="index.php?do=itemshop&sub=buyitem"> <p align="center"> <?=$boton?> <input type="hidden" value="<?=$_GET['itemid']?>" name="ItemID"> </p> </form> </td> </tr> </table> </td> </tr> <tr> <td width="1"></td> </tr> </table> </div> </td> </tr> <tr> <td background="http://forum.ragezone.com/images/cont_top.jpg" height="27"> </td> </tr> </table> </div> <? } } if($_GET['expand'] == 0){ switch($_GET['sub']){ case "listallitems"; ListAllItems(); break; case "details"; ShowItemsDetails(); break; case "buyitem"; ShowBuyItem(); break; } } ?>]

its not only me who having this problem..
please help guys
thanks