Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 17:00

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

Advertisement



[Requests] Who needs ... ?

Discussion on [Requests] Who needs ... ? within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old 11/05/2009, 14:01   #61
 
janvier123's Avatar
 
elite*gold: 20
Join Date: Nov 2007
Posts: 2,854
Received Thanks: 1,891
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
janvier123 is offline  
Old 11/05/2009, 15:31   #62
 
Bigshow107's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 700
Received Thanks: 228
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
Bigshow107 is offline  
Old 11/06/2009, 00:05   #63
 
҉ THT ҉'s Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 912
Received Thanks: 250
no, i mean just 1~64 for draco = 65~79 = for python ,, etc
҉ THT ҉ is offline  
Old 11/06/2009, 00:28   #64
 
Decima's Avatar
 
elite*gold: 0
Join Date: Aug 2009
Posts: 1,297
Received Thanks: 928
DELETE character_name FROM character.dbo.user_character WHERE wLevel < 60 AND wIndex = 19
Decima is offline  
Old 02/13/2010, 00:16   #65
 
elite*gold: 0
Join Date: Jun 2009
Posts: 38
Received Thanks: 2
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?
alan0049 is offline  
Old 02/13/2010, 01:52   #66
 
janvier123's Avatar
 
elite*gold: 20
Join Date: Nov 2007
Posts: 2,854
Received Thanks: 1,891
not now, iam to busy atm ...
ill get on it later
janvier123 is offline  
Old 02/13/2010, 04:43   #67
 
҉ THT ҉'s Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 912
Received Thanks: 250
Janvier , What about auto coins system like "elite/eg/ dekaron" pay and get coins
҉ THT ҉ is offline  
Old 02/26/2011, 16:39   #68
 
elite*gold: 0
Join Date: Dec 2010
Posts: 40
Received Thanks: 13
Can you please make email verification script for account registration?
Truax is offline  
Old 02/27/2011, 11:53   #69
 
elite*gold: 0
Join Date: Mar 2007
Posts: 149
Received Thanks: 10
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




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
NeedHelpAti is offline  
Old 02/27/2011, 12:01   #70
 
elite*gold: 0
Join Date: Mar 2007
Posts: 149
Received Thanks: 10
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
NeedHelpAti is offline  
Old 03/27/2011, 19:15   #71
 
elite*gold: 0
Join Date: Mar 2007
Posts: 149
Received Thanks: 10
U guys still taking request??
Can you make scrip that cAn edit skill point and stats point give item by index thanks
NeedHelpAti is offline  
Old 03/29/2011, 22:50   #72
 
elite*gold: 0
Join Date: Oct 2010
Posts: 168
Received Thanks: 22
looks Awesome
h96vy is offline  
Old 03/30/2011, 08:49   #73
 
elite*gold: 0
Join Date: Mar 2007
Posts: 149
Received Thanks: 10
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 ??
NeedHelpAti is offline  
Old 09/15/2012, 03:17   #74
 
elite*gold: 0
Join Date: Aug 2009
Posts: 367
Received Thanks: 309
Hello guys, if u are bored?. Can someone help me.
Here we go! I need DK-coins script afther logged into account

Also for rectiving password (Enter email end they sends password in the inbox of mail)


I'm sorry for my bad english. If i need explain something msg me.
Thanks Hope i get scripts
Hesorio1u is offline  
Old 09/15/2012, 04:26   #75
 
elite*gold: 0
Join Date: Jun 2011
Posts: 159
Received Thanks: 2
janvier123 can you make php script for website?
yepee22 is offline  
Reply


Similar Threads Similar Threads
Few Requests
10/25/2008 - CO2 Private Server - 2 Replies
hey all i tried to make my own job center and the npcs but i have problems with the npcs so does anyone has the full working code for the job npcs 2nd request how can u make more rbs then 2 ? like that someone can rb 3-4 or more times ? i'll appreciate every helpfull post u can post it here or add my msn [email protected]
Some Requests
04/27/2008 - Conquer Online 2 - 0 Replies
First i need To Know Whats Should I Do With The Petals And White Flowers I get From The Second Reb Quest Second My Friend Tell me That He Upgrade The Lvl Of His Super Bow From Lvl 115 To 120 With Just 31 Meteors Not Db Is That Right
Requests---PLEASE D:
01/26/2008 - CO2 Weapon, Armor, Effects & Interface edits - 1 Replies
Ok. Im getting pretty bored with the blue stuff from cyclone. I know someone has made a cyclone mod before but i didnt like it :/ It had these weird wings and it sortve ruined it. I was wondering if someone would make me a red/green cyclone which was like the winged one in this forum (cant remember what page it was-it was an old one though...). I also play a Fire Taoist and a Trojan (hence the cyclone). Do you, the reader, think that you could make a mod that makes Taoist's Backswords glow?...
2 Requests
10/24/2006 - World of Warcraft - 3 Replies
Also ich weiss nicht, wie genau das abläuft, aber ich möchte fragen, ob es geht, dass wenn ich meinen Char spiele und egal welches Equip Teil ich habe, jedesmal das gleiche andere angezeigt wird. Also zB bei meinem Jäger.. Wenn ich nun T0 anhab, soll T1 angezeigt werden, aber auch wenn ich T2 oder was ganz anderes anhab. Und für meinen Schurken hätte ich gerne ganzes T1. Wäre toll wenn mir da jemand was machen könnte, wenn es überhaupt umsetzbar ist. Wichtiger ist mir btw der Schurke. :) ...



All times are GMT +1. The time now is 17:01.


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.