[Help Thread] Please post your questions here.

KirieZ · 02/07/2014, 18:10

@thndr Thank you, I wrote the port number in wrong field in sql configuration tcp/ip, now it's working.

Queeni · 02/08/2014, 01:59

hi have a problem with the 5.2 server I can plusen no skill card

sona998 · 02/08/2014, 08:50

This is using the 5.2 client/server files provided. Autoattack ranges on pets are not calculated correctly, i.e. every pet (the ones possible) attacks from screen length, and some pets cannot autoattack at all --> only can use skills.

How to fix this?

laminou45 · 02/08/2014, 12:39

need auth database please link 8.1

ThunderNikk · 02/08/2014, 14:17

Quote:

Originally Posted by laminou45

need auth database please link 8.1

Use the one from the 7.4 files, that is what everyone else is doing.

Or download the one from the guide which was re hosted on page 16. That is also the one from the 7.4 files.

laminou45 · 02/08/2014, 15:05

link please where i can find 7.4

.BlackCat. · 02/08/2014, 15:18

Quote:

Originally Posted by laminou45

link please where i can find 7.4

this should do the job :

ari997 · 02/08/2014, 15:30

Hello I have a problem

i have sql server 2012 express + Files8.1_By_AL7roB_123 + auth 7.4 + client official gpotato + SFramePH (8.1)
need other client 8.1? or other problem? galaxy and other items working but no pets :S

laminou45 · 02/08/2014, 15:50

Please do you have link where i can find tuto for creat privat server rappelz please ?

.BlackCat. · 02/08/2014, 15:55

Quote:

Originally Posted by laminou45

Please do you have link where i can find tuto for creat privat server rappelz please ?

You will need a Client 8.1
Because gPotato are using Epic 8.2 Client

アルカード · 02/08/2014, 16:38

Is there command where i can find some item id in sherlock or aurora?

ThunderNikk · 02/08/2014, 18:21

@ari997 You need the 8.1 client 8.2 will not work with the 8.1 server files.

@laminou45 It is not hard to find you just need to look through the sticky posts...

@needsellfast No but there are SQL queries to do that.

Queeni · 02/08/2014, 19:03

hello, I can not combine objects anyone know what it is have the 5.2 files

Myntii · 02/08/2014, 19:54

Hello all,

i haved ask here for a while, but nobody can't help me. I have a problem with the Register Script! What must i do for 100% funktion this script? I have changed this Script for "Auth dbo.Account" (i have 8.1)

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>Arcadia Test Server</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 INTO Account (account,password,email,pk_,creationDate_,updateDate_,creatorId_,updatorId_,portId_,type_,accessDate_,password2,true_pass,ban,bantime) VALUES('$usr','$md5','',1,0,0,0,0,0,0,0,0,0,0,0");
$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['account'];
if ($result_total >= $max_accounts){
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['username'];
}
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="Unbenannt.jpg" alt="Arcadia Dev"><br /><h2></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>

When i used this , i become error:

Spoiler

Who can help me fast??? pls give me answer^^

アルカード · 02/08/2014, 20:37

Anyone got Pit Of Tartarus files(dungeon)