[Requests] Who needs ... ?

10/11/2009 21:13 janvier123#31
Quote:
Originally Posted by seias View Post
what about Edit characters , like Hp, dil, MP , name , reborn , dill, stats etc ...
iam on it :)
10/11/2009 21:27 2bartz#32
Quote:
Originally Posted by janvier123 View Post
iam on it :)
:D i think you can edit stats, coins, map location, ingame items, stash inventoy but not the character's name might have an exploit on that one.. or only an admin can change unless you can restrict to input any special characters.. :handsdown:
10/11/2009 21:33 janvier123#33
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>
10/13/2009 04:56 Mozo_#34
janvier123 I have a question, i'am working on a new desogn for a hompeage can u help me at the coding if its ready?

(sorry for my bad english :D)
10/13/2009 06:58 DXtrmeHack#35
any 1 can help me..?
for skill hacking
in rusaki..
pls..
ty
10/13/2009 07:13 gedimazs#36
Quote:
Originally Posted by DXtrmeHack View Post
any 1 can help me..?
for skill hacking
in rusaki..
pls..
ty
Can't you read where you are posting at?
10/13/2009 09:16 janvier123#37
Quote:
Originally Posted by hallopla View Post
janvier123 I have a question, i'am working on a new desogn for a hompeage can u help me at the coding if its ready?

(sorry for my bad english :D)
srr i only do coding for dk servers
10/13/2009 16:50 lol2k1#38
no that wasnt for me .
i wanted aloken create screen and they ignored me

huh
10/13/2009 22:17 janvier123#39
Quote:
Originally Posted by lol2k1 View Post
no that wasnt for me .
i wanted aloken create screen and they ignored me

huh
yes, i said USEFULL
that script would be totaly USELESS, why ?
cuz you can create chars ingame, its build that way
and its not possible
and if you want aloken do the efford to actualy getting the files and make them work
iam not gonna write a script for it
10/14/2009 08:13 Zombe#40
Quote:
Originally Posted by janvier123 View Post
yes, i said USEFULL
that script would be totaly USELESS, why ?
cuz you can create chars ingame, its build that way
and its not possible
and if you want aloken do the efford to actualy getting the files and make them work
iam not gonna write a script for it
It's possible, ofc. I already started working on it, it's just really hard.
Would be better if u create any char, and u change it to aloken on php...
Would be a LOT easier.
10/25/2009 02:56 twiggy345#41
I have a request for a php script if your up to the test. This is what i would like to do.. I wanna sell custom items for cash. The object is let them select the Armor\weapon add a price tag to that. then allow different options be added all for a price per option. It would also need a purchase button where they could purchase the item with cash then after successfully paying for it submit the setup to a character. there are more details to it but i wanted to see if u were up for the challenge before going further into it,
10/25/2009 12:22 janvier123#42
cash coins or cash real money ?
i think i can make something like that
10/25/2009 12:49 gedimazs#43
I think he means cash coins
10/25/2009 15:55 xfactorbowler#44
I could use a php script just for dk coins, i don't need any other features just a coins php it self.. the one i currently have calls for cash.html and i don't have a cash.html.
10/25/2009 18:45 twiggy345#45
I mean for cash money. Here is the idea. when they select an armor/weapon $5.00 is added to the total. then for every socket they add to it will add 2 dollars. for every option they add will make it 3 dollars per option and for legendary items is 15.00 dollars then be able to purchase the item via paypal. then after the purchase is complete submit the item to the characters Mailbox. and then when they log in they will recieve it in the mail.