|
You last visited: Today at 19:35
Advertisement
[Help Thread] Please post your questions here.
Discussion on [Help Thread] Please post your questions here. within the Rappelz Private Server forum part of the Rappelz category.
03/09/2014, 03:10
|
#3271
|
elite*gold: 0 
Join Date: Feb 2012
Posts: 47
Received Thanks: 1
|
please post or give me 5.2 decoded sframe
|
|
|
|
03/09/2014, 03:11
|
#3272
|
elite*gold: 0
Join Date: Oct 2010
Posts: 2,555
Received Thanks: 2,460
|
Please create me an ice cream defecating space alien taco please
|
|
|
|
|
03/09/2014, 12:27
|
#3273
|
elite*gold: 0
Join Date: Jul 2012
Posts: 227
Received Thanks: 65
|
Quote:
Originally Posted by ismokedrow
Please create me an ice cream defecating space alien taco please
|
|
|
|
|
|
03/09/2014, 20:35
|
#3274
|
elite*gold: 0
Join Date: Feb 2014
Posts: 146
Received Thanks: 35
|
|
|
|
|
|
03/09/2014, 22:27
|
#3275
|
elite*gold: 0
Join Date: Feb 2012
Posts: 47
Received Thanks: 1
|
[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
|
#3276
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,912
Received Thanks: 1,490
|
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
|
#3277
|
elite*gold: 0
Join Date: Jan 2014
Posts: 65
Received Thanks: 15
|
Can someone give me the black widow resource files plz.
|
|
|
|
|
03/11/2014, 05:17
|
#3278
|
elite*gold: 100
Join Date: Mar 2009
Posts: 198
Received Thanks: 40
|
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
|
#3279
|
elite*gold: 0
Join Date: Jan 2010
Posts: 151
Received Thanks: 48
|
Help for 8.1 reg script
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
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"><!-- 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
|
#3280
|
elite*gold: 0
Join Date: Jul 2012
Posts: 227
Received Thanks: 65
|
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
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"><!-- 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 |
you have to edit the querry it self since account table changed
|
|
|
|
|
03/11/2014, 08:59
|
#3281
|
elite*gold: 78
Join Date: Jul 2012
Posts: 263
Received Thanks: 141
|
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
|
#3282
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,912
Received Thanks: 1,490
|
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
|
#3283
|
elite*gold: 78
Join Date: Jul 2012
Posts: 263
Received Thanks: 141
|
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
|
#3284
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,912
Received Thanks: 1,490
|
ID should auto populate
Why are you trying to force it to put a value in there?
|
|
|
|
|
03/11/2014, 17:30
|
#3285
|
elite*gold: 0
Join Date: Oct 2010
Posts: 2,555
Received Thanks: 2,460
|
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
|
|
|
|
Similar Threads
|
[Helping Topic] 24/7 Helping Services!
08/27/2008 - EO PServer Hosting - 31 Replies
stucked on anything while setuping your server?
post your problem here and you will get answer as fast as possible better than spamming with posts :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""
|
All times are GMT +1. The time now is 19:37.
|
|
![[Help Thread] Please post your questions here.](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/help-thread-please-post-your-questions-here_ltr.gif){kind=small}
