[Requests] Who needs ... ?

Page 5 of 7 « First 34 5 67
11/05/2009 14:01 janvier123#61
Quote:
Originally Posted by [GM]iHacker View Post
Can you make a script

That checks user map index + level, and needed lvl for that map, if the lvl lower that he get banned/deleted/moved/killed etc

Lets says
I am lvl 1 and i go to draco with 0:0 hack
So script;
check me lvl = 1
check me map index = .. (dunno :P)
check the= needed lvl for that map index
if lower i get a ban or something like that

:O Fking Hard To Do Maybe Impossible!
DELETE character_name FROM character.dbo.user_character WHERE wLevel = 1 AND wIndex = 19
( i think draco is 19 )

ye thats a job for zombe
11/05/2009 15:31 Bigshow107#62
Quote:
Originally Posted by janvier123 View Post
DELETE character_name FROM character.dbo.user_character WHERE wLevel = 1 AND wIndex = 19
( i think droco is 19 )

ye thats a job for zombe
lol lv 2 then can escape to easy
is there any command makes something like these : wLevel = -64
why these script is bad ?
answer
lvl 1 can get lv 20 by killing 1 mob in loa so its useless to set it 1
11/06/2009 00:05 ҉ THT ҉#63
no, i mean just 1~64 for draco = 65~79 = for python ,, etc
11/06/2009 00:28 Decima#64
DELETE character_name FROM character.dbo.user_character WHERE wLevel < 60 AND wIndex = 19
02/13/2010 00:16 alan0049#65
can you make a script for dekaron rusaki so they can post it on the forum or/and on the launcher so e can see who's online and how many?
02/13/2010 01:52 janvier123#66
not now, iam to busy atm ...
ill get on it later
02/13/2010 04:43 ҉ THT ҉#67
Janvier , What about auto coins system like "elite/eg/ dekaron" pay and get coins
02/26/2011 16:39 Truax#68
Can you please make email verification script for account registration?
02/27/2011 11:53 NeedHelpAti#69
Quote:
Originally Posted by janvier123 View Post
i have one also, ill post it

EDIT: zombe was too slow again so ..
gedimazs here is your script

[Only registered and activated users can see links. Click Here To Register...]


Call it: usercharacter.php !!
PHP Code:
<?php
// written by janvier123
// Please fill in your MSSQL Info
//<--! begin MSSQL info !-->
$mssql = array(
        'host' => "localhost",    // Normaly "localhost" or "XXX.XXX.XXX.XXX"
        'user' => "sa",            // Your username for MSSQL server, normaly "sa"
        'pass' => "server"        // Your password for MSSQL server
    );

//<--! end MSSQL info !-->
$accname = $_POST['accname'];


if ($_GET['step'] == ""){    
    echo'<center><Form Name ="form" action="usercharacter.php?step=2" Method ="POST">';
    echo'Enter <b>Account</b> Name<p>';
    echo'<input name="accname" type="text" value="">';
    echo'<br>';
    echo'<input type="hidden" name="select" value="1">';
    echo'<input name="submit" type="submit" value="Next ...">';
    echo'</form></center>';

} else if ($_GET['step'] == "2"){    
if($_POST['select']) {
    $accname = $_POST['accname'];

        echo "<center><form action='usercharacter.php?step=3' method='POST'>
            <table class='innertab'>
                <tr>
                    <td colspan='2' align='left'><b><u>Character(s) found! Please select one.</b></u></td>
                </tr>
                <tr>
                    <td colspan='2' align='left'>&nbsp;</td>
                </tr>
                <tr>
                    <td align='left'>Character Name</td>
                        <td><select name='accname'>"; 
                                $ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
                                $result2 = mssql_query("SELECT * FROM account.dbo.USER_PROFILE WHERE user_id = '".$accname."'",$ms_con); 
                                $row2 = mssql_fetch_row($result2); 

                                $result3 = mssql_query("SELECT character_name FROM character.dbo.user_character WHERE user_no = '".$row2[0]."'",$ms_con); 
                                while($row3 = mssql_fetch_row($result3)) 
                    
                        echo "<option value='".$row2[0]."'>".$row3[0]."</option>";
                        }
                    echo "</select></td>
            </tr>
            <tr>
                <td align='left' colspan='2'>
                    <input type='hidden' name='user_no' value='".$row2[0]."'>
                    <input type='submit' value='Show character stats'>
                </td>
            </tr>
        </table>
    </form></center>";    
    


    } else if ($_GET['step'] == "3"){    
//        ------------------------------
    if($_POST['user_no']) {

            $classes = array('0' => "Azure Knight", '1' => "Segita Hunter", '2' => "Incar Magician", '3' => "Vicious Summoner", '4' => "Segnale", '5' => "Bagi Warrior"); 
            $statreset = array('0' => "Unused", '1' => "Used"); 
            $skillreset = array('0' => "Unused", '1' => "Used"); 
            
            $ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
            
            // IF you dont have the "Reborn" table in your mssql database under character.dbo.user_character
            // please remove the "Reborn" from the list below.
            $result5 = mssql_query("SELECT character_no,user_no,dwExp,dwMoney,dwStoreMoney,wStr,wDex,wCon,wSpr,wRetPosX,wRetPosY,wRetMapIndex,wStatPoint,wSkillPoint,wLevel,byPCClass,wPKCount,wChaoticLevel,dwPVPPoint,wWinRecord,wLoseRecord,wDrawRecord,Reborn,bySkillClearCount,byStatClearCount,character_name,dwAdv FROM character.dbo.user_character WHERE user_no = '".$_POST['user_no']."'",$ms_con);
            $row5 = mssql_fetch_row($result5);
            echo "<center><br>
                <table class='innertab'>
                    <tr>
                        <td colspan='3' align='left'><b><u>Character Stats</b></u></td>
                    </tr>
                    <tr>
                        <td colspan='3' align='left'>&nbsp;</td>
                    </tr>
                    <tr>
                        <td align='left'>---------- Type ----------</td>
                        <td align='left'>---------- Current Stats ----------</td>
                    </tr>
                    <tr>
                        <td align='left'>Character Name</td>
                        <td align='left'>".$row5[25]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Experience</td>
                        <td align='left'>".$row5[2]."</td>
                    </tr>
                        <tr>
                        <td align='left'>Adv</td>
                        <td align='left'>".$row5[26]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Level</td>
                        <td align='left'>".$row5[14]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Class</td>
                        <td align='left'>".$classes[$row5[15]]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Str</td>
                        <td align='left'>".$row5[5]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Dex</td>
                        <td align='left'>".$row5[6]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Con</td>
                        <td align='left'>".$row5[7]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Spr</td>
                        <td align='left'>".$row5[8]."</td>
                    </tr>
                    <tr>
                        <td align='left'>DIL Inventory</td>
                        <td align='left'>".$row5[3]."</td>
                    </tr>
                    <tr>
                        <td align='left'>DIL Warehouse</td>
                        <td align='left'>".$row5[4]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Return Map</td>
                        <td align='left'>".$row5[11]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Free stats points</td>
                        <td align='left'>".$row5[12]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Free skill points</td>
                        <td align='left'>".$row5[13]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Total PvP</td>
                        <td align='left'>".$row5[18]."</td>
                    </tr>
                    <tr>
                        <td align='left'>PvP Obtained</td>
                        <td align='left'>".$row5[19]."</td>
                    </tr>
                    <tr>
                        <td align='left'>PvP Lost</td>
                        <td align='left'>".$row5[20]."</td>
                    </tr>
                    <tr>
                        <td align='left'>PvP Draw</td>
                        <td align='left'>".$row5[21]."</td>
                    </tr>
                    <tr>
                        <td align='left'>PK points</td>
                        <td align='left'>".$row5[16]."</td>
                    </tr>
                    <tr>
                        <td align='left'>Chaotic Level (IP)</td>
                        <td align='left'>".$row5[17]."</td>
                    </tr>";
            // IF you dont have the "Reborn" table in your mssql database under character.dbo.user_character
            // please remove the "Reborn" from the list below.
                    echo "
                        <tr>
                        <td align='left'>Reborn</td>
                        <td align='left'>".$row5[22]."</td>
                    </tr>
                        <tr>
                        <td align='left'>Skill Reset</td>
                        <td align='left'>".$skillreset[$row5[23]]."</td>
                    </tr>
                        <tr>
                        <td align='left'>Stats Reset</td>
                        <td align='left'>".$statreset[$row5[24]]."</td>
                    </tr>
                    <tr>
                    </tr>
                </table>
            </center>";
        }
    } 
?>
i had this erro Jan can u fix it pls

Notice: Undefined index: accname in C:\xampp\htdocs\usercharacter.php on line 12

Notice: Undefined index: step in C:\xampp\htdocs\usercharacter.php on line 15
02/27/2011 12:01 NeedHelpAti#70
Quote:
Originally Posted by janvier123 View Post
PHP Code:
<?php

$mssql = array(
        [B][COLOR="Red"]'host' => "5.228.62.50",   <---My Hamchi IP
        'user' => "sa",                 <----- mssql User
        'pass' => "1234"               <------Pass its when i use to log in Query Analyzer[/COLOR][/B]    );
    
echo "<center>Player Online List<br><br>";
echo "<table border='1'>
    <tr>
        <td align='center'>Character Name</td>
        <td align='center'>Level</td>
        <td align='center'>Map</td>
        <td align='center'>Login</td>

    </tr>";

$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);

$result1 = mssql_query("SELECT user_no FROM account.dbo.USER_PROFILE WHERE login_flag = '1100'",$con);


while($row1 = mssql_fetch_row($result1)) {
    
    $result2 = mssql_query("SELECT character_name,wLevel,wMapIndex,login_time FROM character.dbo.user_character WHERE user_no = '".$row1[0]."' ORDER by login_time DESC",$con);
    $row2 = mssql_fetch_row($result2);

        echo "<tr>
            <td align='left'>".$row2[0]."</td>
            <td align='center'>".$row2[1]."</td>
            <td align='center'>".$row2[2]."</td>
            <td align='center'>".$row2[3]."</td>

        </tr>";

}
echo "</table></center>";
?>
DONE! i win, zombe :)
sry for again the problem i cant get in to it i was wondering if it dont work with hamachi?
Player Online List

Character Name Level Map Login

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\user.php on line 19
03/27/2011 19:15 NeedHelpAti#71
U guys still taking request??
Can you make scrip that cAn edit skill point and stats point give item by index thanks
03/29/2011 22:50 h96vy#72
looks Awesome
03/30/2011 08:49 NeedHelpAti#73
Quote:
Originally Posted by janvier123 View Post
Call it 'character.php' !!!

You may have to remove "reborn" from the list if you dont have it
PHP Code:
<center>
<?php

// Please fill in your MSSQL Info
//<--! begin MSSQL info !-->
$mssql = array(
        'host' => "localhost",    // Normaly "localhost" or "XXX.XXX.XXX.XXX"
        'user' => "sa",            // Your username for MSSQL server, normaly "sa"
        'pass' => "server"        // Your password for MSSQL server
    );
//<--! ind MSSQL info !-->
    if(empty($_POST['select'])) {
        echo "<center><br><form action='character.php' method='POST'>
            <table class='innertab'>
                <tr>
                    <td colspan='2' align='left'><b><u>Change Character Stats</b></u></td>
                </tr>
                <tr>
                    <td colspan='2' align='left'>&nbsp;</td>
                </tr>
                <tr>
                    <td align='left'>Character Name</td>
                    <td><input type='text' name='charname' maxlength='20'></td>
                </tr>
                <tr>
                    <td align='left' colspan='2'>
                        <input type='hidden' name='select' value='1'>
                        <input type='submit' value='Set new Character Stats'>
                    </td>
                </tr>
            </table>
        </form></center>";

    } elseif($_POST['select'] == '1') {
        $ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
        $result1 = mssql_query("SELECT * FROM character.dbo.user_character WHERE character_name = '".$_POST['charname']."'",$ms_con);
        $count1 = mssql_num_rows($result1);

        if($count1 < '1') {
            echo "<br>Could not find the character name.<br><a href='javascript:history.back()'>Back</a>";
        } elseif($count > '1') {
            echo "<br>There were several characters with the same name found. <br>Please check that name in the database.<br><a href='javascript:history.back()'>Back</a>";
        } else {
            $classes = array('0' => "Azure Knight", '1' => "Segita Hunter", '2' => "Incar Magician", '3' => "Vicious Summoner", '4' => "Segnale", '5' => "Bagi Warrior"); 
            $statreset = array('0' => "Unused", '1' => "Used"); 
            $skillreset = array('0' => "Unused", '1' => "Used"); 


            $result2 = mssql_query("SELECT character_no,user_no,dwExp,dwMoney,dwStoreMoney,wStr,wDex,wCon,wSpr,wRetPosX,wRetPosY,wRetMapIndex,wStatPoint,wSkillPoint,wLevel,byPCClass,wPKCount,wChaoticLevel,dwPVPPoint,wWinRecord,wLoseRecord,wDrawRecord,Reborn,bySkillClearCount,byStatClearCount,dwAdv,nHP,nMP,nShield FROM character.dbo.user_character WHERE character_name = '".$_POST['charname']."'",$ms_con);
            $row2 = mssql_fetch_row($result2);
            echo "<center><br><form action='character.php' method='POST'>
                <table class='innertab'>
                    <tr>
                        <td colspan='3' align='left'><b><u>Change Character Stats</b></u></td>
                    </tr>
                    <tr>
                        <td colspan='3' align='left'>&nbsp;</td>
                    </tr>
                    <tr>
                        <td align='left'>Type</td>
                        <td align='left'>Current Stats</td>
                        <td align='left'>New Stats</td>
                    </tr>
                    <tr>
                        <td align='left'>Character Name</td>
                        <td align='left'>".$_POST[charname]."</td>
                        <td align='left'><input type='text' name='new_charname' maxlength='20' value='".$_POST[charname]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Experience</td>
                        <td align='left'>".$row2[2]."</td>
                        <td align='left'><input type='text' name='new_exp' maxlength='20' value='".$row2[2]."'></td>
                    </tr>
                        <tr>
                        <td align='left'>Adv</td>
                        <td align='left'>".$row2[25]."</td>
                        <td align='left'><input type='text' name='new_adv' maxlength='20' value='".$row2[25]."'></td>
                    </tr>
                        <tr>
                        <td align='left'>Hp</td>
                        <td align='left'>".$row2[26]."</td>
                        <td align='left'><input type='text' name='new_hp' maxlength='20' value='".$row2[26]."'></td>
                    </tr>
                        <tr>
                        <td align='left'>Mp</td>
                        <td align='left'>".$row2[27]."</td>
                        <td align='left'><input type='text' name='new_mp' maxlength='20' value='".$row2[27]."'></td>
                    </tr>
                        <tr>
                        <td align='left'>Shield</td>
                        <td align='left'>".$row2[28]."</td>
                        <td align='left'><input type='text' name='new_shield' maxlength='20' value='".$row2[28]."'></td>
                    </tr>

                    <tr>
                        <td align='left'>Level</td>
                        <td align='left'>".$row2[14]."</td>
                        <td align='left'><input type='text' name='new_lvl' maxlength='20' value='".$row2[14]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Class</td>
                        <td align='left'>".$classes[$row2[15]]."</td>
                        <td align='left'><select name='new_class' class='input'>";
                                if($row2[15] == '0') {
                                    echo "<option value='0' selected>Azure Knight</option>";
                                } else {
                                    echo "<option value='0'>Azure Knight</option>";
                                }
                                if($row2[15] == '1') {
                                    echo "<option value='1' selected>Segita Hunter</option>";
                                } else {
                                    echo "<option value='1'>Segita Hunter</option>";
                                }
                                if($row2[15] == '2') {
                                    echo "<option value='2' selected>Incar Magician</option>";
                                } else {
                                    echo "<option value='2'>Incar Magician</option>";
                                }
                                if($row2[15] == '3') {
                                    echo "<option value='3' selected>Vicious Summoner</option>";
                                } else {
                                    echo "<option value='3'>Vicious Summoner</option>";
                                }
                                if($row2[15] == '4') {
                                    echo "<option value='4' selected>Segnale</option>";
                                } else {
                                    echo "<option value='4'>Segnale</option>";
                                }
                                if($row2[15] == '5') {
                                    echo "<option value='5' selected>Bagi Warrior</option>";
                                } else {
                                    echo "<option value='5'>Bagi Warrior</option>";
                                }
                        echo "</select>
                        </td>
                    </tr>
                    <tr>
                        <td align='left'>Str points</td>
                        <td align='left'>".$row2[5]."</td>
                        <td align='left'><input type='text' name='new_str' maxlength='20' value='".$row2[5]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Dex points</td>
                        <td align='left'>".$row2[6]."</td>
                        <td align='left'><input type='text' name='new_dex' maxlength='20' value='".$row2[6]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Con points</td>
                        <td align='left'>".$row2[7]."</td>
                        <td align='left'><input type='text' name='new_con' maxlength='20' value='".$row2[7]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Spr points</td>
                        <td align='left'>".$row2[8]."</td>
                        <td align='left'><input type='text' name='new_spr' maxlength='20' value='".$row2[8]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>DIL Inventory</td>
                        <td align='left'>".$row2[3]."</td>
                        <td align='left'><input type='text' name='new_inv_money' maxlength='20' value='".$row2[3]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>DIL Warehouse</td>
                        <td align='left'>".$row2[4]."</td>
                        <td align='left'><input type='text' name='new_war_money' maxlength='20' value='".$row2[4]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Return Pos.X</td>
                        <td align='left'>".$row2[9]."</td>
                        <td align='left'><input type='text' name='new_ret_x' maxlength='20' value='".$row2[9]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Return Pos.Y</td>
                        <td align='left'>".$row2[10]."</td>
                        <td align='left'><input type='text' name='new_ret_y' maxlength='20' value='".$row2[10]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Return Map</td>
                        <td align='left'>".$row2[11]."</td>
                        <td align='left'><select name='new_ret_map' class='input'>";
                                if($row2[11] == '7') {
                                    echo "<option value='7' selected>Loa Castle</option>";
                                } else {
                                    echo "<option value='7'>Loa Castle</option>";
                                }
                                if($row2[11] == '0') {
                                    echo "<option value='0' selected>Braiken Castle</option>";
                                } else {
                                    echo "<option value='0'>Braiken Castle</option>";
                                }
                    echo "</select></td>
                    </tr>
                    <tr>
                        <td align='left'>Stats points</td>
                        <td align='left'>".$row2[12]."</td>
                        <td align='left'><input type='text' name='new_stats' maxlength='20' value='".$row2[12]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Skill points</td>
                        <td align='left'>".$row2[13]."</td>
                        <td align='left'><input type='text' name='new_skill' maxlength='20' value='".$row2[13]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Total PvP</td>
                        <td align='left'>".$row2[18]."</td>
                        <td align='left'><input type='text' name='new_pvp_t' maxlength='20' value='".$row2[18]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>PvP Obtained</td>
                        <td align='left'>".$row2[19]."</td>
                        <td align='left'><input type='text' name='new_pvp_w' maxlength='20' value='".$row2[19]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>PvP Lost</td>
                        <td align='left'>".$row2[20]."</td>
                        <td align='left'><input type='text' name='new_pvp_l' maxlength='20' value='".$row2[20]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>PvP Draw</td>
                        <td align='left'>".$row2[21]."</td>
                        <td align='left'><input type='text' name='new_pvp_d' maxlength='20' value='".$row2[21]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>PK points</td>
                        <td align='left'>".$row2[16]."</td>
                        <td align='left'><input type='text' name='new_pk' maxlength='20' value='".$row2[16]."'></td>
                    </tr>
                    <tr>
                        <td align='left'>Chaotic Level (IP)</td>
                        <td align='left'>".$row2[17]."</td>
                        <td align='left'><input type='text' name='new_chaotic' maxlength='20' value='".$row2[17]."'></td>
                    </tr>
                        <tr>
                        <td align='left'>Reborn</td>
                        <td align='left'>".$row2[22]."</td>
                        <td align='left'><input type='text' name='new_reborn' maxlength='20' value='".$row2[22]."'></td>
                    </tr>
                                            <tr>
                        <td align='left'>Skill Reset</td>
                        <td align='left'>".$skillreset[$row2[23]]."</td>
                        <td align='left'><select name='new_skillreset' class='input'>";
                                if($row2[23] == '1') {
                                    echo "<option value='1' selected>Used</option>";
                                } else {
                                    echo "<option value='1'>Used</option>";
                                }
                                if($row2[23] == '0') {
                                    echo "<option value='0' selected>Unused</option>";
                                } else {
                                    echo "<option value='0'>Unused</option>";
                                }

                    echo "</select></td>
                    </tr>

                        <tr>
                        <td align='left'>Stats Reset</td>
                        <td align='left'>".$statreset[$row2[24]]."</td>
                        <td align='left'><select name='new_statreset' class='input'>";
                                if($row2[24] == '1') {
                                    echo "<option value='1' selected>Used</option>";
                                } else {
                                    echo "<option value='1'>Used</option>";
                                }
                                if($row2[24] == '0') {
                                    echo "<option value='0' selected>Unused</option>";
                                } else {
                                    echo "<option value='0'>Unused</option>";
                                }

                    echo "</select></td>
                    </tr>


                    <tr>
                        <td align='left' colspan='3'>
                            <input type='hidden' name='select' value='2'>
                            <input type='hidden' name='char_no' value='".$row2[0]."'>
                            <input type='hidden' name='user_no' value='".$row2[1]."'>
                            <input type='hidden' name='char_name' value='".$_POST['charname']."'>
                            <input type='submit' value='Set new Character Stats'>
                        </td>
                    </tr>
                </table>
            </form></center>";
                    
        }

    } elseif($_POST['select'] == '2') {

        $ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
        $result1 = mssql_query("SELECT login_flag FROM account.dbo.USER_PROFILE WHERE user_no = '".$_POST['user_no']."'",$ms_con);
        $row1 = mssql_fetch_row($result1);
        if($row1[0] == '1100') {
            $result2 = mssql_query("SELECT character_no FROM character.dbo.user_character WHERE user_no = '".$_POST['user_no']."' ORDER by login_time DESC",$ms_con);
            $row2 = mssql_fetch_row($result2);
        }

        if($row1[0] == '1100' && $row2[0] == $_POST['char_no']) {
            echo "<br>This character can not currently be edited, since it is online.<br><a href='javascript:history.back()'>Back</a>";
            echo "<br>The new character's name is not just letters and numbers or is shorter than 3 characters or longer than 20 characters.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_exp'])) {
            echo "<br>Experience does not only consist of numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_lvl'])) {
            echo "<br>The level indication does not only consist of numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_str'])) {
            echo "<br>The data points Str consists not only of numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_dex'])) {
            echo "<br>The Dex data points is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_con'])) {
            echo "<br>The Con data points is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_spr'])) {
            echo "<br>The Spr data points is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_inv_money'])) {
            echo "<br>The new DIL Inventory consists not only of numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_war_money'])) {
            echo "<br>The new DIL Warehouse does not only consist of numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_ret_x'])) {
            echo "<br>The new return point X is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_ret_y'])) {
            echo "<br>The new return point Y is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_stats'])) {
            echo "<br>The stats point is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_skill'])) {
            echo "<br>The skill points is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_pk'])) {
            echo "<br>The PK count is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_chaotic'])) {
            echo "<br>The Chaotic level does not only consist of numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_reborn'])) {
            echo "<br>Invalid Reborn Number<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_skillreset'])) {
            echo "<br>Invalid Skill Reset Number Can only be 1 of 0<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_statreset'])) {
            echo "<br>Invalid Stats Reset Number Can only be 1 of 0<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_adv'])) {
            echo "<br>The Adv count is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_hp'])) {
            echo "<br>The HP count is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_mp'])) {
            echo "<br>The MP count is not just numbers.<br><a href='javascript:history.back()'>Back</a>";
        } elseif(!preg_match("/[0-9]?/", $_POST['new_shield'])) {
            echo "<br>The Shield count is not just numbers.<br><a href='javascript:history.back()'>Back</a>";




        } else {
            mssql_query("UPDATE
                    character.dbo.user_character 
                SET
                    character_name = '".$_POST['new_charname']."',
                    dwExp = '".$_POST['new_exp']."',
                    dwMoney = '".$_POST['new_inv_money']."',
                    dwStoreMoney = '".$_POST['new_war_money']."',
                    wStr = '".$_POST['new_str']."',
                    wDex = '".$_POST['new_dex']."',
                    wCon = '".$_POST['new_con']."',
                    wSpr = '".$_POST['new_spr']."',
                    wRetPosX = '".$_POST['new_ret_x']."',
                    wRetPosY = '".$_POST['new_ret_y']."',
                    wRetMapIndex = '".$_POST['new_ret_map']."',
                    wStatPoint = '".$_POST['new_statsreset']."',
                    wSkillPoint = '".$_POST['new_skillreset']."',
                    wLevel = '".$_POST['new_lvl']."',
                    byPCClass = '".$_POST['new_class']."',
                    wPKCount = '".$_POST['new_pk']."',
                    wChaoticLevel = '".$_POST['new_chaotic']."',
                    dwPVPPoint = '".$_POST['new_pvp_t']."',
                    wWinRecord = '".$_POST['new_pvp_w']."',
                    wLoseRecord = '".$_POST['new_pvp_l']."',
                    wDrawRecord = '".$_POST['new_pvp_d']."',
                    Reborn = '".$_POST['new_reborn']."',
                    bySkillClearCount = '".$_POST['new_skillreset']."',
                    byStatClearCount = '".$_POST['new_statreset']."',
                    dwAdv = '".$_POST['new_adv']."',
                    nHP = '".$_POST['new_hp']."',
                    nMP = '".$_POST['new_mp']."',
                    nShield = '".$_POST['new_shield']."'


                WHERE
                    character_no = '".$_POST['char_no']."'",$ms_con);

            echo "<br>".$_POST['new_charname']." Edited!<br> Remember the changes successfully.<br> You can close the page now.";
        }

    } else {
        echo "<br>This function does not exist.";
    }


?>
</center>
this is a good script but i had bug when i try edit skill and stats point after i edited and hit Submit all my skill points and stats went to 0 Can you fix tat bug thanks....Also im requesting Send Items Script can you make one ??
09/15/2012 03:17 Hesorio1u#74
Hello guys, if u are bored?. Can someone help me.
Here we go! I need DK-coins script afther logged into account
[Only registered and activated users can see links. Click Here To Register...]
Also for rectiving password (Enter email end they sends password in the inbox of mail)
[Only registered and activated users can see links. Click Here To Register...]

I'm sorry for my bad english. If i need explain something msg me.
Thanks ;) Hope i get scripts ;)
09/15/2012 04:26 yepee22#75
janvier123 can you make php script for website?
Page 5 of 7 « First 34 5 67