How to add Startitems (Offi) + Register(Captcha)

**Caith1991** · 27-11-09

Startitems

Spoiler:

English trnaslation by: HolySinX

Spoiler:

===

Registerpage (mit einfachen Captcha)

Spoiler:

Code:

<?php
    $MD5Code = "kikugalanet";        // Your Neuz MD5 Code
    $dbAddr = 'YOURSERVER';        // Your MSSQL Host IP
    $dbUser = 'sa';            // Your Database user
    $dbPass = 'YOURSQLPASS';        // Your Database User password
    $dbName = "ACCOUNT_DBF";        // Your Account Database
    $server_name = "FlyForEver";    // Define your Servername here
    $reg_allow = 1;            // Um Registrierung anzuschalten eine "1" hinschreiben
    if(!extension_loaded("mssql")) {
        echo "Das benötigte Modul MSSQL ist auf Ihren Server nicht aktiviert. Bitte aktivieren Sie es.";
        exit();
    }
    
    $link = mssql_connect($dbAddr, $dbUser, $dbPass) or die ("Es konnte keine Verbindung zur Datenbank hergestellt werden. Bitte überprüfen sie Ihre Einstellungen.");
    mssql_select_db($dbName, $link);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en">
<head>
    <title><?php echo ('..:: '.$server_name.' - Registrierung ::..'); ?></title>
</head>
<body>
<?php
if ($reg_allow == 1) {
    
    function cleanFormData($text) {
        $data = strtolower($text);
        $data = trim($text);
        $data = htmlentities($text);
        $data = strip_tags($text);
        return $data;
    }

    if(isset($_POST['submit'])) {
        $userName = cleanFormData($_POST['user']);    // Username
        $userPass = cleanFormData($_POST['pass']);    // Password non-encrypted
        $userPass2 = cleanFormData($_POST['pass2']);    // Password non-encrypted
        $captcha = cleanFormData($_POST['captcha']);    // Password non-encrypted
        
        $checkUserName = mssql_query("SELECT account FROM ACCOUNT_TBL WHERE account='".$userName."'");
        
        if(empty($userName) || empty($userPass) || empty($userPass2) || empty($captcha)) {
            echo "Bitte alle Felder ausfüllen!";
        exit();
        }elseif(mssql_num_rows($checkUserName) >= 1) {
            echo "Der Nutzername <b>".$_POST['user']."</b> ist bereits in Verwendung.";
        exit();
        }elseif($_POST['pass'] != $_POST['pass2']) {
            echo "Passwörter stimmen nicht überein.";
        exit();
        }elseif($_POST['captcha'] != $_POST['captcha_check']) {
            echo "Captcha stimmt nicht.";
        exit();
        } else {
            $passHash = md5($MD5Code . $userPass);
            
            // Create a new stored prodecure
            $stmt = mssql_init("createaccount", $link);
            
            // Bind the field names
            mssql_bind($stmt, '@account', $userName, SQLVARCHAR, false, false, 15);
            mssql_bind($stmt, '@password', $passHash, SQLVARCHAR, false, false, 15);
            
            // Execute
            mssql_execute($stmt) or die ("Something is wrong on the execution");
            
            // Free statement
            mssql_free_statement($stmt);
            
            echo "Der Account <b>".$_POST['user']."</b> wurde erfolgreich erstellt!<br><br>Wir wünschen euch viel Spaß beim Spielen.";
        }
    } else {
$zahl1 = rand(10,20); //Erste Zahl 10-20
$zahl2 = rand(1,10);  //Zweite Zahl 1-10
$operator = rand(1,2); // + oder -
if($operator == "1"){
   $operatorzeichen = " + ";
   $ergebnis = $zahl1 + $zahl2;
}else{
   $operatorzeichen = " - ";
   $ergebnis = $zahl1 - $zahl2;
}
$rechnung = $zahl1.$operatorzeichen.$zahl2." = ?";
echo'
<form method="post">
    <table border="0" cellpadding="0" cellspacing="0" >
        <tr><td width="75">Username:</td><td><input type="text" name="user" size="15" maxlenght="15" /></td></tr>
        <tr><td>Password:</td><td><input type="password" name="pass" size="15" /></td></tr>
        <tr><td><font size="-2">Passwort<br>(wiederholen)<font></td><td><input type="password" name="pass2" size="15" /></td></tr>
        <tr><td>'.$rechnung.'</td><td><input type="text" name="captcha" size="15" /></td></tr>
    <input type="hidden" name="captcha_check" value="'.$ergebnis.'">
    </table>
    <br>
        <tr><td></td><td><input type="submit" name="submit" value="Register" /></td></tr>
</form>';
    }
}
else
{
echo 'Derzeit sind keine Registrierungen möglich!';
exit();
}
?>
</body>
</html>

English translation by: Creed0116

Spoiler:

Code:

<?php
    $MD5Code = "kikugalanet";        // Your Neuz MD5 Code
    $dbAddr = 'YOURHOST';        // Your MSSQL Host IP
    $dbUser = 'sa';            // Your Database user
    $dbPass = 'YOURPASSWORD';        // Your Database User password
    $dbName = "ACCOUNT_DBF";        // Your Account Database
    $server_name = "Flyff";    // Define your Servername here
    $reg_allow = 1;            // To turn on registering a write "1"
    if(!extension_loaded("mssql")) {
        echo "The required module is not enabled on your MSSQL server. Please enable it.";
        exit();
    }
    
    $link = mssql_connect($dbAddr, $dbUser, $dbPass) or die ("Could not connect to the database. Please check your settings.");
    mssql_select_db($dbName, $link);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en">
<head>
    <title><?php echo ('..:: '.$server_name.' - Registration ::..'); ?></title>
</head>
<body>
<?php
if ($reg_allow == 1) {
    
    function cleanFormData($text) {
        $data = strtolower($text);
        $data = trim($text);
        $data = htmlentities($text);
        $data = strip_tags($text);
        return $data;
    }

    if(isset($_POST['submit'])) {
        $userName = cleanFormData($_POST['user']);    // Username
        $userPass = cleanFormData($_POST['pass']);    // Password non-encrypted
        $userPass2 = cleanFormData($_POST['pass2']);    // Password non-encrypted
        $captcha = cleanFormData($_POST['captcha']);    // Password non-encrypted
        
        $checkUserName = mssql_query("SELECT account FROM ACCOUNT_TBL WHERE account='".$userName."'");
        
        if(empty($userName) || empty($userPass) || empty($userPass2) || empty($captcha)) {
            echo "Please complete all fields!";
        exit();
        }elseif(mssql_num_rows($checkUserName) >= 1) {
            echo "The username <b>".$_POST['user']."</b> is already in use.";
        exit();
        }elseif($_POST['pass'] != $_POST['pass2']) {
            echo "Passwords do not match.";
        exit();
        }elseif($_POST['captcha'] != $_POST['captcha_check']) {
            echo "Captcha is not true.";
        exit();
        } else {
            $passHash = md5($MD5Code . $userPass);
            
            // Create a new stored prodecure
            $stmt = mssql_init("createaccount", $link);
            
            // Bind the field names
            mssql_bind($stmt, '@account', $userName, SQLVARCHAR, false, false, 15);
            mssql_bind($stmt, '@password', $passHash, SQLVARCHAR, false, false, 15);
            
            // Execute
            mssql_execute($stmt) or die ("Something is wrong on the execution");
            
            // Free statement
            mssql_free_statement($stmt);
            
            echo "The Account <b>".$_POST['user']."</b> was successfully created!<br><br>We wish you much fun playing.";
        }
    } else {
$zahl1 = rand(10,20); //First Number 10-20
$zahl2 = rand(1,10);  //Second number 1-10
$operator = rand(1,2); // + Or --
if($operator == "1"){
   $operatorzeichen = " + ";
   $ergebnis = $zahl1 + $zahl2;
}else{
   $operatorzeichen = " - ";
   $ergebnis = $zahl1 - $zahl2;
}
$rechnung = $zahl1.$operatorzeichen.$zahl2." = ?";
echo'
<form method="post">
    <table border="0" cellpadding="0" cellspacing="0" >
        <tr><td width="75">Username:</td><td><input type="text" name="user" size="15" maxlenght="15" /></td></tr>
        <tr><td>Password:</td><td><input type="password" name="pass" size="15" /></td></tr>
        <tr><td><font size="-2">Password<br>(repeat)<font></td><td><input type="password" name="pass2" size="15" /></td></tr>
        <tr><td>'.$rechnung.'</td><td><input type="text" name="captcha" size="15" /></td></tr>
    <input type="hidden" name="captcha_check" value="'.$ergebnis.'">
    </table>
    <br>
        <tr><td></td><td><input type="submit" name="submit" value="Register" /></td></tr>
</form>';
    }
}
else
{
echo 'Currently, no registrations are available!';
exit();
}
?>
</body>
</html>

Bevor jemand sagt das das mit den Startitems von Godlikerz[MMORPG-Core] geleecht ist möchte ich vorweg sagen das Rejun und ich ein und die selbe Person sind.

Change here the startpenya, Above the part for the startitems

Spoiler:

Code:

                INSERT CHARACTER_TBL
                            (
                                m_idPlayer,
                                serverindex,
                                account,
                                m_szName,
                                playerslot,
                                dwWorldID,
                                m_dwIndex,
                                m_vScale_x,
                                m_dwMotion,
                                m_vPos_x,

                                m_vPos_y,
                                m_vPos_z,
                                m_fAngle,
                                m_szCharacterKey,
                                m_nHitPoint,
                                m_nManaPoint,
                                m_nFatiguePoint,
                                m_nFuel,
                                m_dwSkinSet,
                                m_dwHairMesh,
                                m_dwHairColor,
                                m_dwHeadMesh,
                                m_dwSex,
                                m_dwRideItemIdx,
                                m_dwGold,
                                m_nJob,
                                m_pActMover,
                                m_nStr,
                                m_nSta,
                                m_nDex,
                                m_nInt,
                                m_nLevel,
                                m_nMaximumLevel,
                                m_nExp1,
                                m_nExp2,
                                m_aJobSkill,
                                m_aLicenseSkill,
                                m_aJobLv,
                                m_dwExpertLv,
                                m_idMarkingWorld,
                                m_vMarkingPos_x,
                                m_vMarkingPos_y,
                                m_vMarkingPos_z,
                                m_nRemainGP,
                                m_nRemainLP,
                                m_nFlightLv,
                                m_nFxp,
                                m_nTxp,
                                m_lpQuestCntArray,
                                m_aCompleteQuest,
                                m_chAuthority,
                                m_dwMode,
                                m_idparty,
                                m_idCompany,
                                --m_nNumKill,
                                m_idMuerderer,
                                --m_nSlaughter,
                                m_nFame,
                                m_nDeathExp,
                                m_nDeathLevel,

                                m_dwFlyTime,
                                m_nMessengerState,
                                blockby,
                                TotalPlayTime,
                                isblock,
                                End_Time,
                                BlockTime,
                                CreateTime,
                                m_tmAccFuel,
                                m_tGuildMember,
                                m_dwSkillPoint,
                                m_dwReturnWorldID,
                                m_vReturnPos_x,
                                m_vReturnPos_y,
                                m_vReturnPos_z
                            )
                VALUES
                            (
                                @om_idPlayer,
                                @iserverindex,
                                @iaccount,
                                @im_szName,
                                @iplayerslot,
                                @idwWorldID,
                                @im_dwIndex,
                                '1',

                                '0',
                                @im_vPos_x,
                                @im_vPos_y,
                                @im_vPos_z,
                                '0',
                                @im_szCharacterKey,
                                '230',
                                '63',
                                '32',
                                -1, --m_nFuel
                                @im_dwSkinSet,
                                @im_dwHairMesh,
                                @im_dwHairColor,
                                @im_dwHeadMesh,
                                @im_dwSex,
                                '0',
                                '1000', --Start Gold
                                '0',
                                '1,0',
                                '15',
                                '15',
                                '15',
                                '15',
                                '1',
                                '1', --m_nMaximumLevel
                                '0',
                                '0',
                                '',
                                '',
                                '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$',
                                '0',
                                '0',
                                '0',
                                '0',
                                '0',
                                '0',
                                '0',
                                '0',
                                '0',
                                '0',
                                '$',
                                '$', -- m_aCompleteQuest
                                'F',
                                '131072',
                                '0',
                                '0', -- m_idCompany
                                --@om_nNumKill,
                                '0',
                                --@om_nSlaughter,
                                '0',
                                '0',
                                '0',
                                '0'    ,
                                '0',
                                @oblockby,
                                '0',
                                'F',
                                '200811030000',
                                CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112),
                                GETDATE(),
                                0,
                                CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112)
                                    + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,-1,GETDATE()))),2)
                                    + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,-1,GETDATE()))),2)
                                    + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,-1,GETDATE()))),2),
                                0, --m_dwSkillPoint
                            1,
                            0,
                            0,
                            0
                            )

**MentaL**

How to add Startitems (Offi) + Register(Captcha)

**Johnatan28** · 27-11-09

in english?

**Looky** · 27-11-09

Thanks Caith1991

and where change start penya please?

**Looky** · 27-11-09

Thanks Caith1991 but this query it's for start penya?

**Caith1991** · 27-11-09

no change this in the stored procedure [CHARACTER_STR]
if you dont know how to make this, then you should think about make a server

Edit: Thanks Glaphan^^

**GlaphanKing** · 27-11-09

I merged your posts so that everything is in the same spot.

**Looky** · 27-11-09

that is why I ask

**thennek501** · 11-12-09

can someone explain what this means???
0,512,0,0,,1,0,4500000,0,0,0,-1118993182,0,0,0,0,0/1,504,0,0,,1,0,9000000,0,0,0,946307614,0,0,0,0,0/2,2801,0,0,,1,0,-1,0,0,2,1695360208,0,0,0,0,0/42,26809,0,0,,1,0,5850000,0,0,0,750110947,0,0,0,0,0/43,2800,0,0,,5,0,-1,0,0,2,-440263533,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,-2111939376,0,0,0,0,0/45,4805,0,0,,5,0,-1,0,0,2,579001730,0,0,0,0,0/$

**creed0116** · 11-12-09

Originally Posted by thennek501

can someone explain what this means???
0,512,0,0,,1,0,4500000,0,0,0,-1118993182,0,0,0,0,0/1,504,0,0,,1,0,9000000,0,0,0,946307614,0,0,0,0,0/2,2801,0,0,,1,0,-1,0,0,2,1695360208,0,0,0,0,0/42,26809,0,0,,1,0,5850000,0,0,0,750110947,0,0,0,0,0/43,2800,0,0,,5,0,-1,0,0,2,-440263533,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,-2111939376,0,0,0,0,0/45,4805,0,0,,5,0,-1,0,0,2,579001730,0,0,0,0,0/$

thats for the startiing penya

Spoiler:

Code:

<?php
    $MD5Code = "kikugalanet";        // Your Neuz MD5 Code
    $dbAddr = 'YOURHOST';        // Your MSSQL Host IP
    $dbUser = 'sa';            // Your Database user
    $dbPass = 'YOURPASSWORD';        // Your Database User password
    $dbName = "ACCOUNT_DBF";        // Your Account Database
    $server_name = "Flyff";    // Define your Servername here
    $reg_allow = 1;            // To turn on registering a write "1"
    if(!extension_loaded("mssql")) {
        echo "The required module is not enabled on your MSSQL server. Please enable it.";
        exit();
    }
    
    $link = mssql_connect($dbAddr, $dbUser, $dbPass) or die ("Could not connect to the database. Please check your settings.");
    mssql_select_db($dbName, $link);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en">
<head>
    <title><?php echo ('..:: '.$server_name.' - Registration ::..'); ?></title>
</head>
<body>
<?php
if ($reg_allow == 1) {
    
    function cleanFormData($text) {
        $data = strtolower($text);
        $data = trim($text);
        $data = htmlentities($text);
        $data = strip_tags($text);
        return $data;
    }

    if(isset($_POST['submit'])) {
        $userName = cleanFormData($_POST['user']);    // Username
        $userPass = cleanFormData($_POST['pass']);    // Password non-encrypted
        $userPass2 = cleanFormData($_POST['pass2']);    // Password non-encrypted
        $captcha = cleanFormData($_POST['captcha']);    // Password non-encrypted
        
        $checkUserName = mssql_query("SELECT account FROM ACCOUNT_TBL WHERE account='".$userName."'");
        
        if(empty($userName) || empty($userPass) || empty($userPass2) || empty($captcha)) {
            echo "Please complete all fields!";
        exit();
        }elseif(mssql_num_rows($checkUserName) >= 1) {
            echo "The username <b>".$_POST['user']."</b> is already in use.";
        exit();
        }elseif($_POST['pass'] != $_POST['pass2']) {
            echo "Passwords do not match.";
        exit();
        }elseif($_POST['captcha'] != $_POST['captcha_check']) {
            echo "Captcha is not true.";
        exit();
        } else {
            $passHash = md5($MD5Code . $userPass);
            
            // Create a new stored prodecure
            $stmt = mssql_init("createaccount", $link);
            
            // Bind the field names
            mssql_bind($stmt, '@account', $userName, SQLVARCHAR, false, false, 15);
            mssql_bind($stmt, '@password', $passHash, SQLVARCHAR, false, false, 15);
            
            // Execute
            mssql_execute($stmt) or die ("Something is wrong on the execution");
            
            // Free statement
            mssql_free_statement($stmt);
            
            echo "The Account <b>".$_POST['user']."</b> was successfully created!<br><br>We wish you much fun playing.";
        }
    } else {
$zahl1 = rand(10,20); //First Number 10-20
$zahl2 = rand(1,10);  //Second number 1-10
$operator = rand(1,2); // + Or --
if($operator == "1"){
   $operatorzeichen = " + ";
   $ergebnis = $zahl1 + $zahl2;
}else{
   $operatorzeichen = " - ";
   $ergebnis = $zahl1 - $zahl2;
}
$rechnung = $zahl1.$operatorzeichen.$zahl2." = ?";
echo'
<form method="post">
    <table border="0" cellpadding="0" cellspacing="0" >
        <tr><td width="75">Username:</td><td><input type="text" name="user" size="15" maxlenght="15" /></td></tr>
        <tr><td>Password:</td><td><input type="password" name="pass" size="15" /></td></tr>
        <tr><td><font size="-2">Password<br>(repeat)<font></td><td><input type="password" name="pass2" size="15" /></td></tr>
        <tr><td>'.$rechnung.'</td><td><input type="text" name="captcha" size="15" /></td></tr>
    <input type="hidden" name="captcha_check" value="'.$ergebnis.'">
    </table>
    <br>
        <tr><td></td><td><input type="submit" name="submit" value="Register" /></td></tr>
</form>';
    }
}
else
{
echo 'Currently, no registrations are available!';
exit();
}
?>
</body>
</html>

of here is the English Version of the Registration Page!!! Thanks Caith

**gmerindol** · 12-12-09

Good job dude!

**maisqueporra** · 12-12-09

i understand the script for start item,lol anyone can post in english ?

**uneprobleme** · 12-12-09

dduuuhh? was heisst denn das?

Das benötigte Modul MSSQL ist auf Ihren Server nicht aktiviert. Bitte aktivieren Sie es.

**Caith1991** · 13-12-09

Thanks Creed for the translation, I will add this to the first post^^

**HolySinX** · 13-12-09

Heres a translation of that Start items thingy. Of course I translated it by myself. (Might not be that accurate, because the sentences that Caith wrote were "unusual" sentences)

Start items

Spoiler:

===

**creed0116** · 14-12-09

Originally Posted by Caith1991

Thanks Creed for the translation, I will add this to the first post^^

welcome..^_^ its my pleasure to help

**Markiska** · 02-01-10

Are that for v14 Server Files / Database?
____

Ist das für v14 Server Files / Datenbank ?

**Caith1991** · 17-01-10

grundbau ist in v14 genauso aber vorher lieber immer ein backup machen^^

@HolySinX ty i will edit the translation in my first post

**djhulk001** · 24-02-10

i get
The required module is not enabled on your MSSQL server. Please enable it.

anything wrong? i did everything right

**ryuchao009** · 24-02-10

Originally Posted by djhulk001

i get
The required module is not enabled on your MSSQL server. Please enable it.

anything wrong? i did everything right

There is one significant thing wrong.

You just necro posted!

**djhulk001** · 25-02-10

Originally Posted by ryuchao009

There is one significant thing wrong.

You just necro posted!

sorry about that. i was just needing some help i have been looking and could not find one that works. sorry.

**ecKo9321** · 25-02-10

Originally Posted by djhulk001

i get
The required module is not enabled on your MSSQL server. Please enable it.

anything wrong? i did everything right

lol necro poster, at least now i can post

you did everything right my ass

"The required module is not enabled on your MSSQL server. Please enable it." IS TELLING YOU SOMETHING?

Noob ~~

Originally Posted by RayWIlliamJohnson

That reply was FAKE and GAY

**djhulk001** · 25-02-10

just delete my posts and say i was never here. but it is great coding. thanks. :)

**Detox** · 25-02-10

Originally Posted by djhulk001

just delete my posts and say i was never here. but it is great coding. thanks. :)

LOL, Okai :)

Nice bump.

**oOBlissOo** · 28-02-10

lolz i know from experience this regipage is extremely vulnerable to sql injections took me awhile to fix it <_<

**caspaas** · 28-02-10

The required module is not enabled on your MSSQL server. Please enable it. help me here

How to add Startitems (Offi) + Register(Captcha)

Thread Tools

Search Thread

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Re: How to add Startitems (Offi) + Register(Captcha)

Advertisement