|
You last visited: Today at 03:49
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.
01/29/2014, 17:17
|
#2971
|
Moderator
elite*gold: 1 
Join Date: Dec 2012
Posts: 4,915
Received Thanks: 1,492
|
You need to create your own in
Telecaster.dbo.AllowedCommandsForPermission table
Although even with a limited minor permission granted like "Notice" I am not sure if their chat will appear in orange unless they are a full GM
|
|
|
|
01/29/2014, 17:24
|
#2972
|
elite*gold: 0
Join Date: Mar 2011
Posts: 23
Received Thanks: 1
|
Quote:
Originally Posted by thndr
You need to create your own in
Telecaster.dbo.AllowedCommandsForPermission table
Although even with a limited minor permission granted like "Notice" I am not sure if their chat will appear in orange unless they are a full GM
|
I know it's possible to make someone talk in orange even without full permissions, I just don't know how , I'm also checked that table and it's empty. and I got GM's already in the server.
|
|
|
|
01/29/2014, 18:24
|
#2973
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,915
Received Thanks: 1,492
|
Quote:
Originally Posted by rappelzmail
I know it's possible to make someone talk in orange even without full permissions, I just don't know how , I'm also checked that table and it's empty. and I got GM's already in the server.
|
Permission level 100 works, weather the table has entries for 100 or not.
If you want a lower level permission you will have to create entries for the lower level permission.
Example create an entry for permission level 80 and give that entry permission to run notice messages.
|
|
|
|
|
01/29/2014, 23:53
|
#2974
|
elite*gold: 0
Join Date: Aug 2011
Posts: 48
Received Thanks: 1
|
Hello again,
This time I've been pestering you with a question that may be easy for you more for who I do not understand how complicated and well 
Is there any way to accept the emulator graphic accents?
As I already said I'm Brazilian, and here in Brazil we use many accents on letters, if anyone knows, I appreciate it once more hugs and thanks for all the help 
EDIT: Another thing I was wondering, those of DB tables with various translations of stringresouce need them or even it can be deleted?
|
|
|
|
|
01/30/2014, 15:07
|
#2975
|
elite*gold: 78
Join Date: Jul 2012
Posts: 263
Received Thanks: 141
|
Register problem
Hello all,
i have a little problem with my Register Script! I have this Script here:
PHP Code:
<?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,block,withdraw_remain_time,age ,auth_ok,pcbang,last_login_server_idx,event_code,result ) VALUES('$username','$converted_password',0,0,18,1,1,1,0,1)";
$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_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['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=\"launcherUS.exe\">Here</a>, <br />and <a href=\"\">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: "reg.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: 5px;">
<p>
<img src="" alt=""><br /><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></i></br>
but in my auth Database is this:
PHP Code:
account_id, account, password, email, pk_, creationDate, updateDate_, creatorId_, portId_, type_, accesDate_, paaword2
This in my Auth have the name dbo.Account not dbo.Accounts. When i changed all in the script to my db , i become errors^^ Where can i fix it pls???
|
|
|
|
|
01/30/2014, 15:53
|
#2976
|
elite*gold: 70
Join Date: Dec 2012
Posts: 278
Received Thanks: 156
|
Quote:
Originally Posted by Cyborg2009
Hello all,
i have a little problem with my Register Script! I have this Script here:
PHP Code:
<?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,block,withdraw_remain_time,age ,auth_ok,pcbang,last_login_server_idx,event_code,result ) VALUES('$username','$converted_password',0,0,18,1,1,1,0,1)";
$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_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['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=\"launcherUS.exe\">Here</a>, <br />and <a href=\"\">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: "reg.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: 5px;">
<p>
<img src="" alt=""><br /><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></i></br>
but in my auth Database is this:
PHP Code:
account_id, account, password, email, pk_, creationDate, updateDate_, creatorId_, portId_, type_, accesDate_, paaword2
This in my Auth have the name dbo.Account not dbo.Accounts. When i changed all in the script to my db , i become errors^^ Where can i fix it pls??? |
Change $query like on your Database .
PHP Code:
$query = "INSERT Account( account, password, email, pk_, creationDate, updateDate_, creatorId_, portId_, type_, accesDate_, paaword2) VALUES('$username','$converted_password',' ',0,0,18,1,1,1,0,1)";
|
|
|
|
|
01/30/2014, 16:44
|
#2977
|
elite*gold: 78
Join Date: Jul 2012
Posts: 263
Received Thanks: 141
|
thx, but when i used this query, i become this error:
PHP Code:
Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'creationDate'. (severity 16) in C:\AppServ\www\reg.php on line 79
Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'accesDate_'. (severity 16) in C:\AppServ\www\reg.php on line 79
Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'paaword2'. (severity 16) in C:\AppServ\www\reg.php on line 79
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\reg.php on line 79
|
|
|
|
|
01/30/2014, 17:29
|
#2978
|
elite*gold: 70
Join Date: Dec 2012
Posts: 278
Received Thanks: 156
|
Quote:
Originally Posted by Cyborg2009
thx, but when i used this query, i become this error:
PHP Code:
Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'creationDate'. (severity 16) in C:\AppServ\www\reg.php on line 79
Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'accesDate_'. (severity 16) in C:\AppServ\www\reg.php on line 79
Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'paaword2'. (severity 16) in C:\AppServ\www\reg.php on line 79
Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\reg.php on line 79
|
Columns names are like you said . Check your columns names again & type of values .
|
|
|
|
|
01/30/2014, 17:47
|
#2979
|
elite*gold: 0
Join Date: Aug 2011
Posts: 48
Received Thanks: 1
|
Hello again,
This time I've been pestering you with a question that may be easy for you more for who I do not understand how complicated and well
Is there any way to accept the emulator graphic accents?
As I already said I'm Brazilian, and here in Brazil we use many accents on letters, if anyone knows, I appreciate it once more hugs and thanks for all the help
EDIT: Another thing I was wondering, those of DB tables with various translations of stringresouce need them or even it can be deleted?
|
|
|
|
|
01/31/2014, 19:50
|
#2980
|
elite*gold: 100
Join Date: Mar 2009
Posts: 198
Received Thanks: 40
|
hi @ all..
bei dem soul taming vom royal 8,1/8,2 muss man sich immer ausloggen das die skills bei den pets da sind, wie kann man das umstellen das die wie bei jedem anderen pet sofot da sind ohne erst relog.....??
|
|
|
|
|
02/01/2014, 12:04
|
#2981
|
elite*gold: 0
Join Date: Sep 2009
Posts: 103
Received Thanks: 0
|
how to give player a certain skill ?
how do i give player a certain command ?
i have tried at dbo.AllowedCommandsForPermission to give only permision 1 warp command but i didn't get it... may i have some help here please ?
this what i did put in SQL " sid 3 , permision 1, command warp, perameter 100" is this good or no?
i would like to know make this say player level ? when they log-in
local abc = gv("permission")
local adf = name
if abc == 100 then
announce(name.. " Has Log-in.")
else
end
thank in advaince
|
|
|
|
|
02/01/2014, 20:28
|
#2982
|
elite*gold: 0
Join Date: Oct 2011
Posts: 13
Received Thanks: 0
|
Good evening
I am trying to make a private server, I've done everything as in the guide but when I run " CaptainHerlockServer.exe" it gives me the following error:
GAME DB INIT ERROR : Login failed for user ;rappelz_game'.
I hope any of you got an answer to resolve my problem
P.S: all passwords set to blank as the guide says.
|
|
|
|
|
02/01/2014, 21:54
|
#2983
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,915
Received Thanks: 1,492
|
Quote:
Originally Posted by ayman ayoub
Good evening
I am trying to make a private server, I've done everything as in the guide but when I run " CaptainHerlockServer.exe" it gives me the following error:
GAME DB INIT ERROR : Login failed for user ;rappelz_game'.
I hope any of you got an answer to resolve my problem
P.S: all passwords set to blank as the guide says.
|
If it is trying to log in as user rappelz_game you have not followed the guide.
|
|
|
|
|
02/02/2014, 11:46
|
#2984
|
elite*gold: 0
Join Date: Jul 2013
Posts: 50
Received Thanks: 1
|
Möchte gerne die deutsche 5.2 sframe haben.Hätten tu ich sie,aber wie kann ich sie bearbeiten das der gameguard da draußen ist?
|
|
|
|
|
02/02/2014, 18:06
|
#2985
|
elite*gold: 0
Join Date: Jan 2014
Posts: 19
Received Thanks: 0
|
Hi @ll , i have a message error for my connection a SQL 2012...
Cannot connect to NAME-PC\SQLEXPRESS.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
firewall ? Avast ? or SQL2012 bad configuration ?
Windows Seven X64 SP1.
Sorry for my 2 post but this is urgent.
|
|
|
|
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 03:52.
|
|
![[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}
