[Help Thread] Please post your questions here.

Page 219 of 590

219

03/09/2014 03:10 berkmen1#3271

please post or give me 5.2 decoded sframe

03/09/2014 03:11 ismokedrow#3272

Please create me an ice cream defecating space alien taco please

03/09/2014 12:27 eziorav#3273

Quote:

Originally Posted by ismokedrow

Please create me an ice cream defecating space alien taco please

:eek:

03/09/2014 20:35 Aurorauser#3274

[Only registered and activated users can see links. Click Here To Register...]

Add item help me pls pls?? :( :(

03/09/2014 22:27 berkmen1#3275

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

03/09/2014 22:39 ThunderNikk#3276

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.

03/10/2014 16:36 Prentis#3277

Can someone give me the black widow resource files plz.

03/11/2014 05:17 Makenci#3278

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

03/11/2014 06:55 [ADM]RaZoR#3279

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','[Only registered and activated users can see links. Click Here To Register...]',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

03/11/2014 08:09 eziorav#3280

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','[Only registered and activated users can see links. Click Here To Register...]',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

03/11/2014 08:59 Cyborg2009#3281

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

03/11/2014 12:42 ThunderNikk#3282

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.

03/11/2014 15:50 Cyborg2009#3283

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 ....

03/11/2014 17:04 ThunderNikk#3284

ID should auto populate

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

03/11/2014 17:30 ismokedrow#3285

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

Page 219 of 590

219