Register for your free account! | Forgot your password?

Go Back   elitepvpers › MMORPGs › Dekaron › Dekaron Private Server
[HELP]Character.php Script [HELP]Character.php Script
You last visited: Today at 07:42

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

[HELP]Character.php Script

Discussion on [HELP]Character.php Script within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2011
Posts: 159
Received Thanks: 2
[HELP]Character.php Script

Can anyone fix this script?

when i try to add Free Stat points and Skill points it says Its done.

when i try to login in game nothings happened. please help me

here's the script.

script name should be "character.php"

PHP Code:
<center>
<?php

// Please fill in your MSSQL Info
//<--! begin MSSQL info !-->
$mssql = array(
        'host' => "5.94.130.10",    // Normaly "localhost" or "XXX.XXX.XXX.XXX"
        'user' => "sa",            // Your username for MSSQL server, normaly "sa"
        'pass' => "1234"        // 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.";
            echo "<center><br><a href='character.php'>Take me back now.</a></center>";
        }

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


?>
</center>
yepee22 is offline  
Reply

« GFX artist looking for work. | [HELP]IP Banned Script »

Similar Threads Similar Threads
Unlocking character script(req)
10/06/2011 - Metin2 Private Server - 0 Replies
Hy,everyone.Can you please give me a workking unlocking character script? I've tried more script and neither don't work.Pls help me.:handsdown:
[RELEASE] character unstuck script
04/29/2011 - EO PServer Guides & Releases - 8 Replies
hi all i aim proud to release a character unstuck script i created it whit the help of funhacker (he gave me the info i needed to start creating it , becouse i dint know how i needed to start whit it :P , for the rest is it a complete fresh script) for the rest is it just a simple script where you can input your charname to get teleported back to cronus the script is ready to use on a standart instalation of a server (standart pass/username/db)



All times are GMT +2. The time now is 07:42.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.