help[cannot connect to database]

[`PsDn^]

'.mysql_error() ); $db_select = mysql_select_db( mySQL_database, $db_link ) or die( 'Error connecting to Database

 

'.mysql_error() ); if ($user == '') { print'Incorrect UserID'; mysql_close(); } else { $db_add = mysql_query( "INSERT INTO `accounts` VALUES ('$user', '$str', '0', '0', '')" ) or die( 'Error: '.mysql_error() ); } print 'Account Created

 

Enjoy youre gameplay.'; mysql_close(); ?>

afto to error m vgazei otan paw na ftiaxw account apo to site mou .. sto script vazw tin ip tis database diladi tin ip apo to pc mou kai to name tis database l2jarchid_db

episis to username = root

kai to password=

dn exw password

an mporei kapoios as mou pei giati m to vgazei afto

[Coyote™]

  On 1/8/2010 at 9:06 PM, ~PsDn® said:

{ print'Incorrect UserID'; mysql_close(); }

 

Incorrect UserID

[`PsDn^]

re file afou vazw root :S k dn einai alo....

[`PsDn^]

na afto einai to script :

<?php
 define('mySQL_hostname', '77.49.177.119');  //database IP
 define('mySQL_database', 'l2jarchid_db');  //database name
 define('mySQL_username', 'root');  //database user
 define('mySQL_password', '');  //database password

 function l2j_encrypt($password) 
   {
       return base64_encode(pack("H*", sha1(utf8_encode($password))));
   }

 $str =  l2j_encrypt($_POST['pass']);

 $user = $_POST["name"];

 $db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )
   or die( 'Error connecting to mysql<br><br>'.mysql_error() );

 $db_select = mysql_select_db( mySQL_database, $db_link )
   or die( 'Error connecting to Database<br><br>'.mysql_error() );

 if ($user == '') { print'Incorrect UserID'; mysql_close(); }
 else {
  $db_add = mysql_query( "INSERT INTO `accounts` VALUES ('$user', '$str', '0', '0', '')" )
    or die( 'Error: '.mysql_error() );
 }
 print 'Account Created<br><br>Enjoy youre gameplay.';
 mysql_close();
?>

EDIT: soz gia to double post

[Kяaσh]

  On 1/8/2010 at 9:15 PM, ~PsDn® said:

na afto einai to script :

<?php
  define('mySQL_hostname', '77.49.177.119');  //database IP
  define('mySQL_database', 'l2jarchid_db');  //database name
  define('mySQL_username', 'root');  //database user
  define('mySQL_password', '');  //database password

  function l2j_encrypt($password) 
    {
        return base64_encode(pack("H*", sha1(utf8_encode($password))));
    }

  $str =  l2j_encrypt($_POST['pass']);

  $user = $_POST["name"];

  $db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )
    or die( 'Error connecting to mysql<br><br>'.mysql_error() );

  $db_select = mysql_select_db( mySQL_database, $db_link )
    or die( 'Error connecting to Database<br><br>'.mysql_error() );

  if ($user == '') { print'Incorrect UserID'; mysql_close(); }
  else {
  $db_add = mysql_query( "INSERT INTO `accounts` VALUES ('$user', '$str', '0', '0', '')" )
    or die( 'Error: '.mysql_error() );
  }
  print 'Account Created<br><br>Enjoy youre gameplay.';
  mysql_close();
?>

EDIT: soz gia to double post

i ip p bales nomizo prp na ginei localhost

[`PsDn^]

nai ala den einai sto pc mou.. kai pistevw iparxoun ekatomiria idies database me l2jarchid_db kai username root

[sakisd]

  On 1/8/2010 at 9:19 PM, KяaSh™ said:

i ip p bales nomizo prp na ginei localhost

prepei na exeis balei stin db sou kapio pass gia na mporeseis na sinde8ei to srcipt stin db sou

[`PsDn^]

aahh.. ok ty w8 na dokimasw k 8a s pw