How to update ugrade donor

rhys918 · Dec 25, 2011

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

PHP:

<?
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">
												<!-- //left item picture -->
												<!-- right item info box -->
															<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>

qet123 · Dec 25, 2011

Use the search button please they already released it

sahar042 · Dec 25, 2011

PHP:

<?


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>

Welcome!

How to update ugrade donor

rhys918

Skilled Illusionist

qet123

Good Guy George

sahar042

Fuck Army.

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners