How to update ugrade donor

**rhys918** · 25-12-11

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">&nbsp;</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">&nbsp;</td>

                                            <td width="440" colspan="2">

                                            <img border="0" src="img/inf/shop.png"></td>

                                            <td width="30">&nbsp;</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">

                                            &nbsp;</td>

                                        </tr>



                                        <tr>

                                                                                <?

                                        while($item = mssql_fetch_assoc($res)) {

                                            if ($count == 2) {

                                                $count = 1;

                                                echo "

                                                    </tr><tr>

                                                        <td width='184'>&nbsp;</td>

                                                        <td width='184'>&nbsp;</td>

                                                        <td width='184'>&nbsp;</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">&nbsp;</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">&nbsp;</td>

                                                </tr>

                                                <tr>

                                                    <td width="105">&nbsp;</td>

                                                    <td width="106">&nbsp;</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">&nbsp;</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">&nbsp;</td>

                                                </tr>

                                                <tr>

                                                    <td width="105">&nbsp;</td>

                                                    <td width="110">&nbsp;</td>

                                                </tr>

                                            </table>



</body>



</html>

</td>                                                <?

                                                 $count++;

                                            }

                                        }   ?>

                                            <td width="30">

                                            &nbsp;<p>&nbsp;</p>

                                            <p>&nbsp;</p>

                                            <p>&nbsp;</td>

                                        </tr>



                                        <tr>

                                            <td width="445" colspan="2">&nbsp;</td>

                                        </tr>



                                        <tr>

                                            <td width="12" colspan="2"></td>

                                        </tr>

                                        </table>

                                </div>

                                </td>

                            </tr>

                            <tr>

                                <td background="img/cont_top.jpg" height="27">&nbsp;</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">&nbsp;</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">&nbsp;</td>

                                            <td width="429">

                                            <img border="0" src="img/inf/itemdetails.png" width="413" height="18"></td>

                                            <td width="8">&nbsp;</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">&nbsp;</td>

                                                            <td width="91">&nbsp;</td>

                                                            <td width="14">&nbsp;</td>

                                                        </tr>

                                                        <tr>

                                                            <td width="11">&nbsp;</td>

                                                            <td width="91">

                                                            <img border="2" src="img/shop/<?=$item['WebImgName']?>" width="100" height="100"></td>

                                                            <td width="14">&nbsp;</td>

                                                        </tr>

                                                        <tr>

                                                            <td width="11">&nbsp;</td>

                                                            <td width="91">&nbsp;</td>

                                                            <td width="14">&nbsp;</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">&nbsp;</td>

                                                            <td width="251">&nbsp;</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">&nbsp;</td>

                                                                        <td width="146" height="27" colspan="3">&nbsp;</td>

                                                                        <td width="128" height="27" colspan="3">&nbsp;</td>

                                                                    </tr>

                                                                    <tr>

                                                                        <td width="7">&nbsp;</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')">&nbsp;</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')">&nbsp;</td>

                                                                        <td width="67">

                                                                        <b>FR</b></td>

                                                                        <td width="62" align="right">

                                                                        <?=$item['FR']?></td>

                                                                        <td width="4">&nbsp;</td>

                                                                    </tr>

                                                                    <tr>

                                                                        <td width="7">&nbsp;</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')">&nbsp;</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')">&nbsp;</td>

                                                                        <td width="67">

                                                                        <b>PR</b></td>

                                                                        <td width="62" align="right">

                                                                        <?=$item['PR']?></td>

                                                                        <td width="4">&nbsp;</td>

                                                                    </tr>

                                                                    <tr>

                                                                        <td width="7">&nbsp;</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')">&nbsp;</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')">&nbsp;</td>

                                                                        <td width="67">

                                                                        <b>CR</b></td>

                                                                        <td width="62" align="right">

                                                                        <?=$item['CR']?></td>

                                                                        <td width="4">&nbsp;</td>

                                                                    </tr>

                                                                    <tr>

                                                                        <td width="7">&nbsp;</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')">&nbsp;</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')">&nbsp;</td>

                                                                        <td width="67">

                                                                        <b>LR</b></td>

                                                                        <td width="62" align="right">

                                                                        <?=$item['LR']?></td>

                                                                        <td width="4">&nbsp;</td>

                                                                    </tr>

                                                                    <tr>

                                                                        <td width="4">&nbsp;</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')">&nbsp;</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')">&nbsp;</td>

                                                                        <td width="67">&nbsp;</td>

                                                                        <td width="62">&nbsp;</td>

                                                                        <td width="4">&nbsp;</td>

                                                                    </tr>

                                                                    <tr>

                                                                        <td width="7">&nbsp;</td>

                                                                        <td width="75">&nbsp;</td>

                                                                        <td width="51" colspan="2">&nbsp;</td>

                                                                        <td width="88">&nbsp;</td>

                                                                        <td width="54" colspan="2">&nbsp;</td>

                                                                        <td width="67">&nbsp;</td>

                                                                        <td width="68" colspan="2">&nbsp;</td>

                                                                    </tr>

                                                                </table>

                                                                </td>

                                                            </tr>

                                                        </table>

                                                    </div>

                                                    </td>

                                                </tr>

                                                <tr>

                                                    <td width="432" valign="top" colspan="2">&nbsp;</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>&nbsp;

                                                    <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">&nbsp;</td>

                                                </tr>

                                            </table>

                                            </td>

                                        </tr>



                                        <tr>

                                            <td width="1"></td>

                                        </tr>

                                        </table>

                                </div>

                                </td>

                            </tr>

                            <tr>

                                <td background="img/cont_top.jpg" height="27">&nbsp;</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">&nbsp;</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">&nbsp;</td>

                                            <td width="429">

                                            <img border="0" src="img/inf/buyitem.png" width="414" height="19"></td>

                                            <td width="8">&nbsp;</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">&nbsp;</td>

                                                    <td width="8" valign="top">&nbsp;</td>

                                                    <td width="222" valign="top">&nbsp;</td>

                                                </tr>

                                                <tr>

                                                    <td width="200" valign="top">

                                                    <p align="right">Name of 

                                                    item</td>

                                                    <td width="8" valign="top">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</td>

                                                    <td width="8" valign="top">&nbsp;</td>

                                                    <td width="222" valign="top">&nbsp;</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">&nbsp;</td>

                                                    <td width="8" valign="top">&nbsp;</td>

                                                    <td width="222" valign="top">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</td>

                                            <td width="429">

                                            <img border="0" src="img/inf/gift3.png" width="414" height="19"></td>

                                            <td width="8">&nbsp;</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">&nbsp;</td>

                                                    <td width="8" valign="top">&nbsp;</td>

                                                    <td width="222" valign="top">&nbsp;</td>

                                                </tr>

                                                <tr>

                                                    <td width="200" valign="top">

                                                    <p align="right">Name of 

                                                    item</td>

                                                    <td width="8" valign="top">&nbsp;</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">&nbsp;</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">

                                            &nbsp;</td>

                                            <td width="279">

                                            <input type="text" name="id" size="26">&nbsp;

                                            </td>

                                        </tr>

                                                <tr>

                                                    <td width="200" valign="top">

                                                    <p align="right">Price</td>

                                                    <td width="8" valign="top">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</td>

                                                    <td width="8" valign="top">&nbsp;</td>

                                                    <td width="222" valign="top">&nbsp;</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">&nbsp;</td>

                                                    <td width="8" valign="top">&nbsp;</td>

                                                    <td width="222" valign="top">&nbsp;</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">&nbsp;</td>

                            </tr>

                        </table>

                    </div>





<?

    }

}





switch($_GET['sub']){

    case "listallitems";

        ListAllItems();

    break;

    case "details";

        ShowItemsDetails();

    break;

    case "buyitem";

        ShowBuyItem();

    break;

    case "giftitem";

        ShowGiftItem();

    break;

}











?>

       </div>

**MentaL**

**qet123** · 25-12-11

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

**sahar042** · 25-12-11

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">&nbsp;</td>

                                                <td width="315" colspan="3">&nbsp;</td>

                                                <td width="11">&nbsp;</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">&nbsp;</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">&nbsp;</td>

                                            </tr>

                                            <tr>

                                                <td width="10">&nbsp;</td>

                                                <td width="315" colspan="3"><br /></td>

                                                <td width="11">&nbsp;</td>

                                            </tr>

                                            <tr>

                                                <td width="10">&nbsp;</td>

                                                <td width="181">

                                                <p align="right">Select the color</td>

                                                <td width="13">&nbsp;</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">&nbsp;</td>

                                            </tr>

                                            <tr>

                                                <td width="10">&nbsp;</td>

                                                <td width="315" colspan="3">&nbsp;</td>

                                                <td width="11">&nbsp;</td>

                                            </tr>

                                            <tr>

                                                <td width="10">&nbsp;</td>

                                                <td width="181">

                                                <p align="right">Price:</td>

                                                <td width="13">&nbsp;</td>

                                                <td width="190"><b>50 Events Coins</b></td>

                                                <td width="11">&nbsp;</td>

                                            </tr>

                                            <tr>

                                                <td width="10">&nbsp;</td>

                                                <td width="181">

                                                <p align="right">Actual Event coins:</td>

                                                <td width="13">&nbsp;</td>

                                                <td width="190"><b><?=$infoacc->EventCoins?></b></td>

                                                <td width="11">&nbsp;</td>

                                            </tr>

                                            <tr>

                                                <td width="10">&nbsp;</td>

                                                <td width="181">

                                                <p align="right">Coins remaining::</td>

                                                <td width="13">&nbsp;</td>

                                                <td width="190"><b><?=$infoacc->EventCoins-50?></b></td>

                                                <td width="11">&nbsp;</td>

                                            </tr>

                                          

                                            <tr>

                                                <td width="10">&nbsp;</td>

                                                <td width="315" colspan="3">&nbsp;</td>

                                                <td width="11">&nbsp;</td>

                                            </tr>

                                            <tr>

                                                <td width="10">&nbsp;</td>

                                                <td colspan="3">

                                                <p align="center">

                                                <input type="submit" value="Buy Color Name" name="submit"></td>

                                                <td width="11">&nbsp;</td>

                                            </tr>

                                        </table></form>

                                    </div>

                                    </td>

                                </tr>

                            </table>

                        </div>

                        <p align="center">&nbsp;</td>

                        <td width="171" valign="top">

                        <div align="center">

                            <? include "blocks/block_login.php" ?>

                        </div>

                        </td>

                    </tr>

                </table>

How to update ugrade donor

Thread Tools

Search Thread

How to update ugrade donor

Re: How to update ugrade donor

Re: How to update ugrade donor

Advertisement