Eroare UCP Register

[SamiHQ]

Salut, am urcat pe host un User Control Panel, care are si funcția de register, pentru înregistrarea contului In Game la un server de roleplay. Problema este următoarea, trec de intrebări, ajung la completarea datelor caracterului și când dau pe înregistrare îmi dă eroarea ”Your name must contain character _” deși numele avea ”_” .

Aici e site-ul cu înregistrarea: http://st-rp.com/register/part-1/

Vă las și eror_log și register.php, de acolo e problema.

[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 12

	[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 13

	[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 13

	[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 14

	[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 14

	[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 15

	[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 15

	[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 16

	[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 16

	[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 17

	[19-Sep-2016 01:01:47 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 17

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_connect(): Host 'ns1.btstelecom.ro' is not allowed to connect to this MySQL server in /home/strpcom/public_html/register/part-4/register.php on line 3

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_select_db() expects parameter 2 to be resource, boolean given in /home/strpcom/public_html/register/part-4/register.php on line 4

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 6

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 6

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 7

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 7

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 8

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 8

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 9

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 9

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 10

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 10

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 11

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 11

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 12

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 12

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 13

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 13

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 14

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 14

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 15

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 15

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 16

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 16

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 17

	[19-Sep-2016 01:29:30 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 17

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_connect(): Host 'ns1.btstelecom.ro' is not allowed to connect to this MySQL server in /home/strpcom/public_html/register/part-4/register.php on line 3

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_select_db() expects parameter 2 to be resource, boolean given in /home/strpcom/public_html/register/part-4/register.php on line 4

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 6

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 6

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 7

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 7

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 8

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 8

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 9

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 9

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 10

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 10

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 11

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 11

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 12

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 12

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 13

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 13

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 14

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 14

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 15

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 15

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 16

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 16

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/strpcom/public_html/register/part-4/register.php on line 17

	[19-Sep-2016 08:57:31 Europe/Bucharest] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /home/strpcom/public_html/register/part-4/register.php on line 17[/CODE]

<?php
    include("variables.php"); //Our handy dandy includes page! 
    $connection = mysql_connect($dbservername, $dbusername, $dbpassword);  //Connects to the server 
    mysql_select_db($zhoryx20000, $connection);  //Connects to the database 
    
    $username = mysql_real_escape_string($_POST['Username']);
    $password = mysql_real_escape_string($_POST['Password']);
    $sex1 = mysql_real_escape_string($_POST['Sex']);
    $age = mysql_real_escape_string($_POST['Age']);
    $origin1 = mysql_real_escape_string($_POST['Origin']);
    $email = mysql_real_escape_string($_POST['Email']);
    $Bio = mysql_real_escape_string($_POST['Bio']);
    $Rp = mysql_real_escape_string($_POST['Rp']);
    $Pg = mysql_real_escape_string($_POST['Pg']);
    $Mg = mysql_real_escape_string($_POST['Mg']);
    $Rk = mysql_real_escape_string($_POST['Rk']);
    $Rules = mysql_real_escape_string($_POST['Rules']);    
    
if(!isset($_POST['formVenire'])) 
{
  echo "Forgot to select something !";
}
    
if (preg_match('/[_]/', $username))
{
    
    if ($sex1 == "Male"){
    $sex = "1";   
   }
   else if ($sex1 == "male"){
    $sex = "1";   
   }
   else if ($sex1 == "man"){
    $sex = "1";   
   }
   else if ($sex1 == "Man"){
    $sex = "1";   
   }
   else if ($sex1 == "1"){
    $sex = "1";   
   }
   else if ($sex1 == "man"){
    $sex = "1";   
   }
   else if ($sex1 == "Man"){
    $sex = "1";   
   }
   else if ($sex1 == "Female"){
    $sex = "0";   
   }
   else if ($sex1 == "male"){
    $sex = "0";   
   }
   else if ($sex1 == "man"){
    $sex = "0";   
   }
   else if ($sex1 == "Man"){
    $sex = "0";   
   }
   else if ($sex1 == "0"){
    $sex = "0";   
   }
   else if ($sex1 == "female"){
    $sex = "0";   
   }
   else if ($sex1 == "female"){
    $sex = "0";   
   }
   if ($origin1 == "Negru"){
    $origin = "0";   
   }
   else if ($origin1 == "negru"){
    $origin = "0";   
   }
   else if ($origin1 == "Asiatica"){
    $origin = "1";   
   }
   else if ($origin1 == "asiatica"){
    $origin = "1";   
   }
    
        $nameexist = mysql_query("SELECT `Username`, `Level`, `Money`, `Email`, `Admin`, `Tester`, `Developer`, `Skin`, `V1`, `V2`, `V3`, `V4`, `V5`, `Banned` FROM `Accounts` WHERE `Username` = '$username'"); //Selects the users score and money from the database. 
    if(!mysql_num_rows($nameexist)) //If we could find the users data 
    { 
    mysql_query("INSERT INTO `Accounts` (`Username`, `Password`, `Level`, `Admin`, `Banned`, `Sex`, `Tutorial`, `Bank`, `Experience`, `Money`, `Skin`, `SpawnPoint`, `HouseKey`, `BizKey`, `LoadPosX`, `LoadPosY`, `LoadPosZ`, `LoadPosInt`, `LoadPosW`, `Crashed`, `V1`, `V2`, `V3`, `V4`, `V5`, `CarKey`, `Savings`, `Wanted`, `Cell`, `Gun0`, `Gun1`, `Gun2`, `Gun3`, `Gun4`, `Gun5`, `Gun6`, `Gun7`, `Gun8`, `Gun9`, `Gun10`, `Gun11`, `Gun12`, `GunAmmo0`, `GunAmmo1`, `GunAmmo2`, `GunAmmo3`, `GunAmmo4`, `GunAmmo5`, `GunAmmo6`, `GunAmmo7`, `GunAmmo8`, `GunAmmo9`, `GunAmmo10`, `GunAmmo11`, `GunAmmo12`, `Tester`, `Demerits`, `CarDupe`, `Fight`, `Walk`, `Talk`, `Crimes`, `Deaths`, `Arrested`, `Frequence`, `Radio`, `MaskID`, `Race`, `Job`, `JobAllow`, `Mask`, `Faction`, `Rank`, `Credit`, `PayCheck`, `PlayingHours`, `Jailed`, `JailTime`, `Garage`, `Cigarettes`, `BadgeNumber`, `Lighter`, `CarLic`, `FlyLic`, `WepLic`, `LifeLic`, `PhoneNumber`, `ListNumber`, `Materials`, `Products`, `ContractTime`, `WorkOn`, `HeadValue`, `WeedX`, `WeedY`, `WeedZ`, `WeedTimer`, `WeedPlant`, `Armour`, `Seeds`, `Weed`, `Ecstasy`, `Amphetamine`, `Cocaine`, `Heroin`, `note1`, `note1s`, `note2`, `note2s`, `note3`, `note3s`, `note4`, `note4s`, `note5`, `note5s`, `Social`, `Age`, `BMX`, `ConName1`, `ConNum1`, `ApartKey`, `Location`, `Donator`, `ConName2`, `ConNum2`, `MoneyConvert`, `PaydayTime`, `CarBill`, `HouseBill`, `BusinessBill`, `NormalMail`, `Developer`, `DieTwentyTimes`, `DieOneTime`, `DriveFast`, `FirstSmoke`, `FirstCar`, `FirstHouse`, `GreetJohn`, `Namelocked`, `Inv1`, `Inv1a`, `Inv2`, `Inv2a`, `Inv3`, `Inv3a`, `Inv4`, `Inv4a`, `Inv5`, `Inv5a`, `Inv6`, `Inv6a`, `Inv7`, `Inv7a`, `Inv8`, `Inv8a`, `Inv9`, `Inv9a`, `Inv10`, `Inv10a`, `Inv11`, `Inv11a`, `Online`, `LoadPos`, `Email`, `Accepted`) VALUES ('$username', '$password', '1', '0', '0', '$sex', '1', '0', '0', '1000', '299', '1', '0', '255', '1715.1136', '-1871.3253', '13.5665', '0', '0', '0', 'NONE', 'NONE', 'NONE', 'NONE', 'NONE', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '$origin', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '$age', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '$email', '1')");
    
    mysql_query("INSERT INTO `Register` (`Bio`, `Rp`, `Pg`, `Mg`, `Rk`, `Rules`) VALUES ('$Bio', '$Rp', '$Pg', '$Mg', '$Rk', '$Rules')");
    
    mysql_query("INSERT INTO `Activation` (`Username`, `Password`, `Bio`, `Rp`, `Pg`, `Mg`, `Rk`, `Rules`, `Email`, `Accepted`) VALUES ('$username', '$password','$Bio', '$Rp', '$Pg', '$Mg', '$Rk', '$Rules', '$email', '0')");
    
    echo "<p>The account was successfully registered , you can login now on the server and UCP .</p>"; 
    } 
    else 
    { 
    
       $array = mysql_fetch_array($nameexist, MYSQL_ASSOC); //Fetches our variables for us. 
       $name1 = $array['Username']; //Sets $score to the result in our database for the players score. 
       
           echo "<p>Already there is an account named $name1.</p>";
       
    }
}

else {
    echo "<p>Your name must contain character _</p>";
}


?>

 

Edited September 19, 2016 by SamiHQ

[-=[Vyorel]=-]

Numai din erorile alea din log poti sa iti dai seama ca tu nu ai trecut in panel datele de la baza de date ale serverului.

[SamiHQ]

Am uitat sa pun portul.

Acum am pus la baza de date in variables.php si dupa ce dau inregistrare, apare asa: