[Help Thread] Please post your questions here.

berkmen1 · 03/09/2014, 03:10

please post or give me 5.2 decoded sframe

~~ismokedrow~~ · 03/09/2014, 03:11

Please create me an ice cream defecating space alien taco please

eziorav · 03/09/2014, 12:27

Quote:

Originally Posted by ismokedrow

Please create me an ice cream defecating space alien taco please

Aurorauser · 03/09/2014, 20:35

Add item help me pls pls??

berkmen1 · 03/09/2014, 22:27

[FOR NPC]I'm adding the lua code correctly, but the place is added where and how can I find?

ThunderNikk · 03/09/2014, 22:39

Quote:

Originally Posted by berkmen1

[FOR NPC]I'm adding the lua code correctly, but the place is added where and how can I find?

The NPCs X , Y coordinate values

In game type...

/position...

to return where you are located.

Prentis · 03/10/2014, 16:36

Can someone give me the black widow resource files plz.

Makenci · 03/11/2014, 05:17

moin... hätte man ne frage, wie stelle ich das ein wei lich komme einfach nicht drauf hehe

ein mob drop eine box aus der box sollen diese sachen rauskommen die er normal dropen würde. meine frage ist jetzt wie verlinke ich das ganze das der das macht...

wenn ich jetzt vom mob (monsterresourcen)drop_table_link_id beibehalte und dann nur in (monsterdroptableresourcen)drop_item_id_00 änder dann würde er ja die box dropen.. so jetzt kommt mein problem wie bekomme ich das hin das aus dieser box die drop kommen die er normal dropen würde was trage ich jetzt bei (dropgroupresourcen) ein.

mfg

[ADM]RaZoR · 03/11/2014, 06:55

Hello all,

i have used the old register script from NCarbon (Arcadia) and have change the old tables form the php in the 8.1 Auth tables.
old = dbo.Accounts
new = dbo.Account

Spoiler

PHP Code:


			
<!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">

    <head>

    <title>Rappelz Register</title>

<?php

require("conf.php");

if ($registration ==0){

?>

                <h1>Registrations closed</h1>

            </div>

        </div>

<?php

exit;

}

if(isset($_SERVER['HTTP_REFERER']) 

    && $_SERVER['HTTP_REFERER']!=''

    && substr($_SERVER['HTTP_REFERER'], 7, strlen($_SERVER['SERVER_NAME'])) != $_SERVER['SERVER_NAME'])

    {

        $_POST = array();

        $_GET = array();

    }    

function connect(){

    require("conf.php");

    $db = $Auth_db;

    $connect = mssql_connect($sql_host, $sql_user, $sql_password);

    if (!$connect) {echo 'connection error'; exit;}

    mssql_select_db($db, $connect) or die("Couldn't open database $db"); 

    return $connect;

}

$do = $_POST['do'];

switch($do){

case "register":

$data_array = &$_POST;

$array_char = array("'","/","\\","*",":","!","?",".", "&", "%", "ù","^", "$", "=","¨","}","{","(",")","~","#","[","]","ç","à","é","€","§",";","¤","°","£","`","<",">");

$username = $data_array['name'];

$username = str_replace($array_char, "", $username);        

$password = $data_array['pwd'];

$password = str_replace($array_char, "", $password);

$passwordconf = $data_array['pwdconf'];        

$passwordconf = str_replace($array_char, "", $passwordconf);

$combine_password = $md5_key.$password;

$converted_password = md5($combine_password);

if ($password != $passwordconf){

echo "<span style=\"color:red\">Passwords don't match !</br><a href=\"javascript:refreshpage()\">Back</a></span>";

exit;

}

if (strlen($username) <= 5){

echo "<span style=\"color:red\">You need 5 characters at least in your account name</br><a href=\"javascript:refreshpage()\">Back</a></span>";

exit;

} 

if (strlen($password) <= 6){

echo "<span style=\"color:red\">You need 5 characters at least in your account password</br><a href=\"javascript:refreshpage()\">Back</a></span>";

exit;

} 

if (strstr ($username, " ") !== False){

echo "<span style=\"color:red\">You need to use alpha/numeric characters! </br><a href=\"javascript:refreshpage()\">Back</a></span>";

exit;

}

if (strstr ($password, " ") !== False){

echo "<span style=\"color:red\">You need to use alpha/numeric characters! </br><a href=\"javascript:refreshpage()\">Back</a></span>";

exit;

}

$db = connect();

$query_check ="SELECT account from Account WHERE account='$username'";

$query = "INSERT Account( account,password,email,pk_,creationDate_,updateDate_,creatorId_,updatorId_,portId_,type_,accessDate_,password2,true_pass,ban,bantime ) VALUES('$username','$password','',1,'$create_time',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)";

$query_total = mssql_query("SELECT count(account_id) FROM Account");

$results_check = mssql_query($query_check);

$results_total = mssql_fetch_row($query_total);

$result_total = $results_total['0'];

if ($result_total >= $max_Account){

echo "<span style=\"color:red\">Max accounts limit has been reached, sorry..</br><a href=\"javascript:refreshpage()\">Back</a></span>";

exit;

}

while ($row_check = mssql_fetch_array($results_check)){

$check_username = $row_check['account'];

}

if ($check_username == $username){

echo "<span style=\"color:red\">Account already exist!</br><a href=\"javascript:refreshpage()\">Back</a></span>";

exit;

}

else

$results = mssql_query($query);

echo "Success, you can now download the launcher</br><a href=\"launcher.exe\">Here</a>, <br />and <a href=\"client.zip\">Client Here</a>";

break;

}

?>

        <link rel="stylesheet" type="text/css" media="screen" href="style.css" />

        <script type="text/javascript" src="http://code.jquery.com/jquery-latest.js"></script>

        <script type="text/javascript">

            function refreshpage() 

            { 

                setTimeout("location.reload(true);",20); 

            }

            $(document).ready( function () 

            { 

            $("#register").submit( function() 

                {    // à la soumission du formulaire                         

                    $.ajax(

                    { // fonction permettant de faire de lajax

                        type: "POST", // methode de transmission des données au fichier php

                        url: "index.php", // url du fichier php

                        data: "do=register&"+"name="+$("#name").val()+"&pwd="+$("#pwd").val()+"&pwdconf="+$("#pwdconf").val(),// données à transmettre

                        success: function(msg)

                        { // si lappel a bien fonctionné                            

                            if (msg)

                            {                            

                                $("div#connexion").hide().fadeIn(1200).html(msg);

                            }

                            else

                            {

                                $("div#erreur").hide().fadeIn(1200).fadeOut(5200).html("<p style=\"color:red\"><img src=\"../client/help/img/error.png\" width=\"20px\" heigth=\"20px\"/>&nbsp;An error occured</p></br>");

                            }

                        }

                    });

                    return false; // permet de rester sur la même page à la soumission du formulaire

                });

            });

            $(document).ready(function()

            {

                $("#loadpage").fadeIn(920);

            });

    </script>

    </head>

    <body>

        <div id="loadpage" style="display:none">

            <noscript><div id="loadpage"></div></noscript>

            <div style="text-align: center; width: 100%; margin-top: 150px;">

            <p>

                <img src="logo.png" alt="Arcadia Dev"><br /><h2>Rappelz Game-Account Register</h2><br /><br />

            </p>

                    <div id="connexion">

            <form name="register" id="register" action="#" class="main_form"><!-- Form begin -->   

                <div class="main_form">

                    <label for="name">Username</label>

                    <div class="div_textbox">

                        <input type="text" name="name" id="name" /><!-- Login Value -->

                    </div>

                </div>

                <div class="main_form">

                    <label for="pwd">Password</label>

                    <div class="div_textbox"><!-- Password Field -->

                        <input type="password" name="pwd" id="pwd" />

                    </div>

                </div>

                <div class="main_form">

                    <label for="pwdconf">Confirm password</label>

                    <div class="div_textbox">

                        <input type="password" name="pwdconf" id="pwdconf" /></br>

                    </div>

                </div>

                <div class="clear"></div>

                <p style="text-align: center; margin: auto; margin-top: 10px;">

                    <!-- Submit Button -->

                    <input type="submit" value="Create Account" style="margin: auto;" />

                </p>

            </form><!-- End of form -->

        </div></br>

        <div id="erreur"></div><!-- span qui contiendra les éventuels messages derreur -->

        <span id="confirmMsg"></span>

    </div></div><i>Don't use special char in your password or username, it will be deleted by our internal security system</i></br>

But when i used this Script, i become a Error, that will write to row 0 , but it must write 1,2,3,4,....
Can anybody help me for use this old reg script, or can give me a nice reg script for xampp, pls?
I don't use IIS!
PLS

eziorav · 03/11/2014, 08:09

Quote:

Originally Posted by [ADM]RaZoR

Hello all,

i have used the old register script from NCarbon (Arcadia) and have change the old tables form the php in the 8.1 Auth tables.
old = dbo.Accounts
new = dbo.Account

Spoiler

PHP Code:

<!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"> <head> <title>Rappelz Register</title> <?php require("conf.php"); if ($registration ==0){ ?> <h1>Registrations closed</h1> </div> </div> <?php exit; } if(isset($_SERVER['HTTP_REFERER']) && $_SERVER['HTTP_REFERER']!='' && substr($_SERVER['HTTP_REFERER'], 7, strlen($_SERVER['SERVER_NAME'])) != $_SERVER['SERVER_NAME']) { $_POST = array(); $_GET = array(); } function connect(){ require("conf.php"); $db = $Auth_db; $connect = mssql_connect($sql_host, $sql_user, $sql_password); if (!$connect) {echo 'connection error'; exit;} mssql_select_db($db, $connect) or die("Couldn't open database $db"); return $connect; } $do = $_POST['do']; switch($do){ case "register": $data_array = &$_POST; $array_char = array("'","/","\\","*",":","!","?",".", "&", "%", "ù","^", "$", "=","¨","}","{","(",")","~","#","[","]","ç","à","é","€","§",";","¤","°","£","`","<",">"); $username = $data_array['name']; $username = str_replace($array_char, "", $username); $password = $data_array['pwd']; $password = str_replace($array_char, "", $password); $passwordconf = $data_array['pwdconf']; $passwordconf = str_replace($array_char, "", $passwordconf); $combine_password = $md5_key.$password; $converted_password = md5($combine_password); if ($password != $passwordconf){ echo "<span style=\"color:red\">Passwords don't match !</br><a href=\"javascript:refreshpage()\">Back</a></span>"; exit; } if (strlen($username) <= 5){ echo "<span style=\"color:red\">You need 5 characters at least in your account name</br><a href=\"javascript:refreshpage()\">Back</a></span>"; exit; } if (strlen($password) <= 6){ echo "<span style=\"color:red\">You need 5 characters at least in your account password</br><a href=\"javascript:refreshpage()\">Back</a></span>"; exit; } if (strstr ($username, " ") !== False){ echo "<span style=\"color:red\">You need to use alpha/numeric characters! </br><a href=\"javascript:refreshpage()\">Back</a></span>"; exit; } if (strstr ($password, " ") !== False){ echo "<span style=\"color:red\">You need to use alpha/numeric characters! </br><a href=\"javascript:refreshpage()\">Back</a></span>"; exit; } $db = connect(); $query_check ="SELECT account from Account WHERE account='$username'"; $query = "INSERT Account( account,password,email,pk_,creationDate_,updateDate_,creatorId_,updatorId_,portId_,type_,accessDate_,password2,true_pass,ban,bantime ) VALUES('$username','$password','',1,'$create_time',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)"; $query_total = mssql_query("SELECT count(account_id) FROM Account"); $results_check = mssql_query($query_check); $results_total = mssql_fetch_row($query_total); $result_total = $results_total['0']; if ($result_total >= $max_Account){ echo "<span style=\"color:red\">Max accounts limit has been reached, sorry..</br><a href=\"javascript:refreshpage()\">Back</a></span>"; exit; } while ($row_check = mssql_fetch_array($results_check)){ $check_username = $row_check['account']; } if ($check_username == $username){ echo "<span style=\"color:red\">Account already exist!</br><a href=\"javascript:refreshpage()\">Back</a></span>"; exit; } else $results = mssql_query($query); echo "Success, you can now download the launcher</br><a href=\"launcher.exe\">Here</a>, <br />and <a href=\"client.zip\">Client Here</a>"; break; } ?> <link rel="stylesheet" type="text/css" media="screen" href="style.css" /> <script type="text/javascript" src="http://code.jquery.com/jquery-latest.js"></script> <script type="text/javascript"> function refreshpage() { setTimeout("location.reload(true);",20); } $(document).ready( function () { $("#register").submit( function() { // à la soumission du formulaire $.ajax( { // fonction permettant de faire de lajax type: "POST", // methode de transmission des données au fichier php url: "index.php", // url du fichier php data: "do=register&"+"name="+$("#name").val()+"&pwd="+$("#pwd").val()+"&pwdconf="+$("#pwdconf").val(),// données à transmettre success: function(msg) { // si lappel a bien fonctionné if (msg) { $("div#connexion").hide().fadeIn(1200).html(msg); } else { $("div#erreur").hide().fadeIn(1200).fadeOut(5200).html("<p style=\"color:red\"><img src=\"../client/help/img/error.png\" width=\"20px\" heigth=\"20px\"/> An error occured</p></br>"); } } }); return false; // permet de rester sur la même page à la soumission du formulaire }); }); $(document).ready(function() { $("#loadpage").fadeIn(920); }); </script> </head> <body> <div id="loadpage" style="display:none"> <noscript><div id="loadpage"></div></noscript> <div style="text-align: center; width: 100%; margin-top: 150px;"> <p> <img src="logo.png" alt="Arcadia Dev"><br /><h2>Rappelz Game-Account Register</h2><br /><br /> </p> <div id="connexion"> <form name="register" id="register" action="#" class="main_form"> <div class="main_form"> <label for="name">Username</label> <div class="div_textbox"> <input type="text" name="name" id="name" /> </div> </div> <div class="main_form"> <label for="pwd">Password</label> <div class="div_textbox"> <input type="password" name="pwd" id="pwd" /> </div> </div> <div class="main_form"> <label for="pwdconf">Confirm password</label> <div class="div_textbox"> <input type="password" name="pwdconf" id="pwdconf" /></br> </div> </div> <div class="clear"></div> <p style="text-align: center; margin: auto; margin-top: 10px;">  <input type="submit" value="Create Account" style="margin: auto;" /> </p> </form> </div></br> <div id="erreur"></div> <span id="confirmMsg"></span> </div></div><i>Don't use special char in your password or username, it will be deleted by our internal security system</i></br>

But when i used this Script, i become a Error, that will write to row 0 , but it must write 1,2,3,4,....
Can anybody help me for use this old reg script, or can give me a nice reg script for xampp, pls?
I don't use IIS!
PLS

you have to edit the querry it self since account table changed

Cyborg2009 · 03/11/2014, 08:59

Quote:

Originally Posted by eziorav

you have to edit the querry it self since account table changed

Okay, i have change the tables , but what must i change in querys? that this script worked for register auto, in new tables

ThunderNikk · 03/11/2014, 12:42

You can't or shouldn't change the table names in the database.

You need to edit the script to match what your tables were.

If the script says dbo.accounts and your table is dbo.account then change dbo.accounts in the script to dbo.account

Change the script not the database table names.

Cyborg2009 · 03/11/2014, 15:50

have i maked, but don't work for me, this script will insert account from id 0 not for id 1, id 2, id 3 ....

ThunderNikk · 03/11/2014, 17:04

ID should auto populate

Why are you trying to force it to put a value in there?

~~ismokedrow~~ · 03/11/2014, 17:30

Ha ha, I would go into trying to explain what a seeded identity field is, but I doubt it would do much good anyways. The bigger question here is how he removed the identity switch that is naturally on the Auth .dbo.Accounts table, but now that I think he might mean he is trying to make a script who inserts id when registering a new account, BUDDEH you can't do that, you insert everything BUT the id.

On a final note:

Who "DOESN'T USE IIS" man it's WAYYYYYYY more simple than XAMPP could ever even dream of being, three times more powerful and has an installer that will rock your fudging world, it's called Microsoft Web-Platform Installer!

1. Download Web-Platform Installer
2. In product search type IIS
3. Choose 7.5 (NOT 8.0)
4. Type PHP in the product search
5. Select PHP 5.4 + PHP Driver 5.4 (Microsoft Sql Php Driver)
6. Press Install
7. Restart your PC
8. Use IIS