index.php
trade.phpCode:<form action="trade.php" method="post"> Type your Account Charname1: <input type="text" name="char1"> Type your Account Charname2: <input type="text" name="char2"> <input type="submit" value="Trade"> </form>
Code:<?php include ur config file... $char1 = $_POST['char1']; $char2 = $_POST['char2']; //QUERY THE CHARNAMES $qcn1 = mssql_query("SELECT * FROM KAL_DB.dbo.Player WHERE Name = '$char1'"); $qcn2 = mssql_query("SELECT * FROM KAL_DB.dbo.Player WHERE Name = '$char2'"); //fetch data $qcnf1 = mssql_fetch_array($qcn1); $qcnf2 = mssql_fetch_array($qcn2); //set UIDs in vars $uid1 = $qcnf1['UID']; $uid2 = $qcnf2['UID']; //change UIDS $uc1 = mssql_query("UPDATE KAL_DB.dbo.Player SET UID = '$uid2' WHERE Name = '$char1'"); $uc2 = mssql_query("UPDATE KAL_DB.dbo.Player SET UID = '$uid1' WHERE Name = '$char2'"); //change names $cn1 = mssql_query("UPDATE KAL_DB.dbo.Player SET Name = 'r4nd0mn4m3f0rtr4d3' WHERE Name = '$char1'"); $cn2 = mssql_query("UPDATE KAL_DB.dbo.Player SET Name = '$char1' WHERE Name = '$char2'"); $cn3 = mssql_query("UPDATE KAL_DB.dbo.Player SET Name = '$char2' WHERE Name = 'r4nd0mn4m3f0rtr4d3'"); ?>
dunno if its useful for u , for me it is ...



LinkBack URL
About LinkBacks






Reply With Quote




