How to update ugrade donor

How do i make the webshop have an option to buy color name?

PHP Code:

<? if ($_SESSION['AID'] == ""){ re_dir("index.php?do=login"); } ?> <div id="shopitems"> <? if(!function_exists("ListAllItems")){ function ListAllItems(){ if(!isset($_GET['type'])){ $type = ""; }else{ $type = "Slot = '".clean($_GET['type'])."' AND"; } $res = mssql_query_logged("SELECT * FROM CashShop WHERE ".$type." Opened = '1'"); ?> <div align="center"> <table border="0" width="456" style="border-collapse: collapse"> <tr> <td background="img/cont_up.jpg"> </td> </tr> <tr> <td background="img/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="img/inf/shop.png"></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=""> <option>SELECT ITEM CATEGORY</option> <option value="1">Melee Weapons</option> <option value="2">Ranged Weapons</option> <option value="3">Armor</option> <option value="5">Special Items</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="img/shop/<?=$item['WebImgName']?>" width="100" height="100"></td> <td width="106" valign="top"> <font color="#FF00FF"><?=$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 = "Melee"; break; case "2"; $slot = "Ranged"; 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?rg=shop&sub=details&id=<?=$item['CSID']?>"><img border="0" src="img/buy_btn.jpg" width="50" height="20"></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="img/shop/<?=$item['WebImgName']?>" width="100" height="100"></td> <td width="110" valign="top"> <font color="#FF00FF"><?=$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 = "Melee"; break; case "2"; $slot = "Ranged"; 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?rg=shop&sub=details&id=<?=$item['CSID']?>"><img border="0" src="img/buy_btn.jpg" width="50" height="20"></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="img/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 = clean($_GET['id']); $res = mssql_query_logged("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="img/cont_up.jpg"> </td> </tr> <tr> <td background="img/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="img/inf/itemdetails.png" 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="img/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"> <font color="#FF00FF"><?=$item['Name']?></fonts></span></b></div> <br><font color="#FFFFFF"><?=$item['Description']?></fonts> </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 = "Melee"; break; case "2"; $slot = "Ranged"; 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('img/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('img/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('img/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('img/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('img/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('img/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('img/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>Reload Time</b></td> <td width="44" align="right"> <?=$item['ReloadTime']?></td> <td width="4" style="background-image: url('img/table_sep.jpg')"> </td> <td width="88"> <b> Control</b></td> <td width="48" align="right"> <?=$item['Control']?></td> <td width="4" style="background-image: url('img/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="4"> </td> <td width="88"> <b>Max Bullet</b></td> <td width="44" align="right"> <?=$item['MaxBullet']?></td> <td width="7" style="background-image: url('img/table_sep.jpg')"> </td> <td width="75"> <b> Duration</b></td> <td width="48" align="right"> Unlimited</td> <td width="4" style="background-image: url('img/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?rg=shop&sub=buyitem&expand=1&itemid=<?=$item['CSID']?>"> <img border="0" src="img/buyitem.jpg" width="50" height="20"></a>  <a href="index.php?rg=shop&sub=giftitem&expand=1&itemid=<?=$item['CSID']?>"> <img border="0" src="img/giftitem.jpg" width="50" height="20"></a></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="img/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 = clean($_GET['itemid']); $res = mssql_query_logged("SELECT * FROM CashShop WHERE CSID = '$item2'"); $item = mssql_fetch_assoc($res); $res2 = mssql_query_logged("SELECT SCoins FROM Account WHERE AID = '".$_SESSION['AID']."'"); $acc = mssql_fetch_assoc($res2); if(isset($_POST['submit'])){ $itemid = clean($_POST['ItemID']); $res = mssql_query_logged("SELECT * FROM CashShop WHERE CSID = '$itemid'"); $item = mssql_fetch_assoc($res); $res2 = mssql_query_logged("SELECT SCoins FROM Account WHERE AID = '".$_SESSION['AID']."'"); $acc = mssql_fetch_assoc($res2); $aid = $_SESSION['AID']; $updatecoins = $acc['SCoins'] - $item['CashPrice']; $zitemid = $item['ItemID']; if($updatecoins < 0){ die("No Bug here :) CoDeD By LaMbDa FrOm SpAiN!!! :)"); } mssql_query_logged("INSERT INTO AccountItem ([ShopitemID], [AID], [ItemID], [RentDate], [Cnt])VALUES('$itemid', '$aid', '$zitemid', GETDATE(), 0)"); mssql_query_logged("UPDATE Account SET SCoins = '$updatecoins' WHERE AID = '$aid'"); echo "<script>alert('Item purchased correctly, you can get it in Last GunZ central bank !');document.location = 'index.php?rg=shop&sub=listallitems&expand=1&type=1'</script>"; } ?> <div align="center"> <table border="0" width="456" style="border-collapse: collapse"> <tr> <td background="img/cont_up.jpg"> </td> </tr> <tr> <td background="img/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="img/inf/buyitem.png" 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">LG Coins you have</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$acc['SCoins']?></b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">LG Coins To you later</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><? $result = $acc['SCoins']-$item['CashPrice']; if($result < 0){ $boton = "<b>LG Coins insufficient</b>"; }else{ $boton = "<input type='submit' value='Buy item' name='submit'>"; } echo $acc['SCoins']-$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?rg=shop&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="img/cont_top.jpg" height="27"> </td> </tr> </table> </div> <? } } if(!function_exists("ShowGiftItem")){ function ShowGiftItem(){ if($_SESSION['AID'] == ""){ re_dir("index.php?do=login"); } $item2 = clean($_GET['itemid']); $res = mssql_query_logged("SELECT * FROM CashShop WHERE CSID = '$item2'"); $item = mssql_fetch_assoc($res); $res2 = mssql_query_logged("SELECT SCoins FROM Account WHERE AID = '".$_SESSION['AID']."'"); $acc = mssql_fetch_assoc($res2); if (isset($_POST['submit'])){ $type = clean($_POST['type']); $id = clean($_POST['id']); $reason = clean($_POST['reason']); $custom = clean($_POST['cstom']); $itemid = clean($_POST['ItemID']); $item2 = clean($_GET['itemid']); //-- if($reason == 1){ $reason = $custom; $custom = str_replace(" ","</br>",$custom); } //-- if ($type == 1){ $res = mssql_query_logged("SELECT * FROM Account WHERE UserID = '$id'"); if(mssql_num_rows($res) == 0){ echo "<script>alert('UserID $id doesnt exist!');document.location = 'index.php?rg=shop&sub=listallitems&expand=1&type=1'</script>"; }else{ $data = mssql_fetch_assoc($res); $userID = $data['UserID']; $UserAID = $data['AID']; $res = mssql_query_logged("SELECT * FROM CashShop WHERE CSID = '$itemid'"); $item = mssql_fetch_assoc($res); $res2 = mssql_query_logged("SELECT SCoins FROM Account WHERE AID = '".$_SESSION['AID']."'"); $acc = mssql_fetch_assoc($res2); $aid = $_SESSION['AID']; $updatecoins = $acc['SCoins'] - $item['CashPrice']; $zitemid = $item['ItemID']; if($updatecoins < 0){ die("No Bug here :) CoDeD By NoLiFe_X!!! :)"); } mssql_query_logged("INSERT INTO AccountItem ([ShopItemID], [AID], [ItemID], [RentDate], [Cnt])VALUES('$itemid', '$UserAID', '$zitemid', GETDATE(), 0)"); mssql_query_logged("UPDATE Account SET SCoins = '$updatecoins' WHERE AID = '$aid'"); echo "<script>alert('Item purchased and gifted correctly, your friend can get it in Last GunZ central bank!');document.location = 'index.php?rg=shop&sub=listallitems&expand=1&type=1'</script>"; } }else{ $res = mssql_query_logged("SELECT * FROM Character WHERE Name = '$id'"); if(mssql_num_rows($res) == 0){ echo "<script>alert('The character $id doesnt exist!');document.location = 'index.php?rg=shop&sub=listallitems&expand=1&type=1'</script>"; }else{ $res = mssql_query_logged("SELECT * FROM Character WHERE Name = '$id'"); $data = mssql_fetch_assoc($res); $UserAID = $data['AID']; $res = mssql_query_logged("SELECT * FROM CashShop WHERE CSID = '$item2'"); $item = mssql_fetch_assoc($res); $res2 = mssql_query_logged("SELECT SCoins FROM Account WHERE AID = '".$_SESSION['AID']."'"); $acc = mssql_fetch_assoc($res2); $res = mssql_query_logged("SELECT * FROM CashShop WHERE CSID = '$itemid'"); $item = mssql_fetch_assoc($res); $res2 = mssql_query_logged("SELECT SCoins FROM Account WHERE AID = '".$_SESSION['AID']."'"); $acc = mssql_fetch_assoc($res2); $aid = $_SESSION['AID']; $updatecoins = $acc['SCoins'] - $item['CashPrice']; $zitemid = $item['ItemID']; if($updatecoins < 0){ die("No Bug here :) CoDeD By NoLiFe_X!!! :)"); } mssql_query_logged("INSERT INTO AccountItem ([ShopitemID], [AID], [ItemID], [RentDate], [Cnt])VALUES('$itemid', '$UserAID', '$zitemid', GETDATE(), 0)"); mssql_query_logged("UPDATE Account SET SCoins = '$updatecoins' WHERE AID = '$aid'"); echo "<script>alert('Item purchased and gifted correctly, your friend can get it in Last GunZ central bank!');document.location = 'index.php?rg=shop&sub=listallitems&expand=1&type=1'</script>"; } } } ?> <head> <meta http-equiv="Content-Language" content="es"> <link rel="stylesheet" type="text/css" href="img/style.css"> </head> <body bgcolor="#312F30"> <div align="center"> <table border="0" width="456" style="border-collapse: collapse"> <tr> <td background="img/cont_up.jpg"> </td> </tr> <tr> <td background="img/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="img/inf/gift3.png" width="414" height="19"></td> <td width="8"> </td> </tr> <tr> <td width="1"></td> </tr> <tr> <td width="438"> <form name="gift" method="POST" action=""> <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="149"> <p align="right"> <select size="1" name="type"> <option selected value="1">Gifting User ID </option> <option value="2">Gifting Character Name </option> </select></td> <td width="4">  </td> <td width="279"> <input type="text" name="id" size="26">  </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">LG Coins you have</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><?=$acc['SCoins']?></b></td> </tr> <tr> <td width="200" valign="top"> <p align="right">LG Coins To you later</td> <td width="8" valign="top"> </td> <td width="222" valign="top"> <b><? $result = $acc['SCoins']-$item['CashPrice']; if($result < 0){ $boton = "<b>LG Coins insufficient</b>"; }else{ $boton = "<input type='submit' value='Gift Item' name='submit'>"; } echo $acc['SCoins']-$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 gift 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?rg=shop&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="img/cont_top.jpg" height="27"> </td> </tr> </table> </div> <? } } switch($_GET['sub']){ case "listallitems"; ListAllItems(); break; case "details"; ShowItemsDetails(); break; case "buyitem"; ShowBuyItem(); break; case "giftitem"; ShowGiftItem(); break; } ?> </div>

Re: How to update ugrade donor

Use the search button please they already released it
Posted via Mobile Device

Re: How to update ugrade donor

PHP Code:

<? if( $_SESSION['AID'] == "" ) { SetURL("index.php?do=buycolorname"); SetMessage("Message from System", array("You must be logged in to buy Color name")); header("Location: index.php?do=login"); die(); } $query00 = mssql_query("SELECT CID FROM Character(nolock) WHERE AID = '{$_SESSION['AID']}' AND CharNum != '-1' AND Name != '' "); // Have characters? if (mssql_num_rows($query00) < 1) { SetMessage("Message from System", array("You don't have any character!")); header("Location: index.php"); die(); } SetTitle("EuroGunz - Buy Color Name"); if (isset($_POST['submit'])) { $aid = clean($_SESSION['AID']); $grade = clean($_POST['color']); $price = intval(50); if (!is_numeric($grade)) { SetMessage("Message from System", array("Invalid Color name!")); header("Location: index.php?do=buycolorname"); die(); } // Color is valid? switch($grade){ case 1; $grade = "^1"; break; case 2; $grade = "^2"; break; case 3; $grade = "^3"; break; case 4; $grade = "^4"; break; case 5; $grade = "^5"; break; case 6; $grade = "^6"; break; case 7; $grade = "^7"; break; case 8; $grade = "^8"; break; case 9; $grade = "^9"; break; default: SetMessage("Message from System", array("The color id is invalid!")); header("Location: index.php?do=shopitem"); die(); } // Color empty? useless if (empty($grade)) { SetMessage("Message from System", array("You don't select a Color name!")); header("Location: index.php?do=buycolorname"); die(); } else { // Suficients coins ? $query = mssql_query("SELECT EventCoins FROM Account(nolock) WHERE AID = '$aid'"); $info = mssql_fetch_assoc($query); $updatecoins = $info['EventCoins'] - $price; if ($updatecoins < 0) { SetMessage("Message from System", array("You don't have suficient Event Coins")); header("Location: index.php"); die(); } else { // Update $coin = mssql_query_logged("UPDATE Account SET EventCoins = '$updatecoins' WHERE AID = '$aid'"); $color = mssql_query_logged("UPDATE Character SET Name = '$grade'+Name WHERE AID = '$aid'"); if ($coin && $color) { SetMessage("Message from System", array("Succesfully purchased color name!")); header("Location: index.php"); die(); } else { SetMessage("Message from System", array("There were problems with the server, try later!")); header("Location: index.php"); die(); } } } } else { // Get some info $query01 = mssql_query("SELECT EventCoins FROM Account(nolock) WHERE AID = '{$_SESSION[AID]}'"); $infoacc = mssql_fetch_object($query01); } ?> <style type="text/css"> OPTION { background-color:#666; } OPTION.red { color:#F00; font-weight:bold; } OPTION.white { color:#FFF; font-weight:bold; } OPTION.blue { color:#00F; font-weight: bold; } </style> <table border="0" style="border-collapse: collapse" width="100%"> <tr> <td width="183" valign="top"> <div align="center"> <? include "blocks/block_ranking.php" ?> </div> </td> <td valign="top"> <div align="center"> <table border="1" style="border-collapse: collapse" width="100%" bordercolor="#000000"> <tr> <td background="http://forum.ragezone.com/images/content_bar.jpg" height="24" style="background-image: url('images/content_bar.jpg'); background-repeat: no-repeat; background-position: center top"> <div align="center"> <b><font face="Tahoma" size="2">Buy Color Name</font></b></td> </tr> <tr> <td bgcolor="#2C2A2A"> <div align="center"><form method="POST" action="index.php?do=buycolorname" name="buycolorname"> <table border="0" style="border-collapse: collapse" width="414" height="100%"> <tr> <td width="10"> </td> <td width="315" colspan="3"> </td> <td width="11"> </td> <img border="0" src="images/shop/Especial/buycolorname.gif" width="100" height="100" style="border: 2px solid #1D1B1C"></td> </tr> <tr> <td width="10"> </td> <td width="315" colspan="3">You can buy a Color name for Gunz.<br /> The price is 50 Event coins.</td> <td width="11"> </td> </tr> <tr> <td width="10"> </td> <td width="315" colspan="3"><br /></td> <td width="11"> </td> </tr> <tr> <td width="10"> </td> <td width="181"> <p align="right">Select the color</td> <td width="13"> </td> <td width="190"> <select name="color" class="cero"> <option selected value="">Select color</option> <option class="^1" value="1">^1</option> <option class="^2" value="2">^2</option> <option class="^3" value="3">^3</option> <option class="^4" value="4">^4</option> <option class="^5" value="5">^5</option> <option class="^6" value="6">^6</option> <option class="^7" value="7">^7</option> <option class="^8" value="8">^8</option> <option class="^9" value="9">^9</option> </select></td> <td width="11"> </td> </tr> <tr> <td width="10"> </td> <td width="315" colspan="3"> </td> <td width="11"> </td> </tr> <tr> <td width="10"> </td> <td width="181"> <p align="right">Price:</td> <td width="13"> </td> <td width="190"><b>50 Events Coins</b></td> <td width="11"> </td> </tr> <tr> <td width="10"> </td> <td width="181"> <p align="right">Actual Event coins:</td> <td width="13"> </td> <td width="190"><b><?=$infoacc->EventCoins?></b></td> <td width="11"> </td> </tr> <tr> <td width="10"> </td> <td width="181"> <p align="right">Coins remaining::</td> <td width="13"> </td> <td width="190"><b><?=$infoacc->EventCoins-50?></b></td> <td width="11"> </td> </tr> <tr> <td width="10"> </td> <td width="315" colspan="3"> </td> <td width="11"> </td> </tr> <tr> <td width="10"> </td> <td colspan="3"> <p align="center"> <input type="submit" value="Buy Color Name" name="submit"></td> <td width="11"> </td> </tr> </table></form> </div> </td> </tr> </table> </div> <p align="center"> </td> <td width="171" valign="top"> <div align="center"> <? include "blocks/block_login.php" ?> </div> </td> </tr> </table>