I thank you again for the job :)Quote:
<?php
$hostname = '*****-*****';
$connection_options = array('Database'=>'telecaster', 'UID'=>'sa', 'PWD'=>'******');
$conn = sqlsrv_connect($hostname, $connection_options);
if(!is_resource($conn)){ echo 'Could not connect: '; var_dump(sqlsrv_errors(SQLSRV_ERR_ALL)); exit(0); }
echo 'Connection established successfully. le serveur est actuellement en maintenance.';
$sql = "select top 10 name, lv from character order by lv desc";
$query = sqlsrv_query($conn, $sql);
if ($query === false)
die( FormatErrors( sqlsrv_errors() ));
while ($row = sqlsrv_fetch_array($query))
{
echo "<p>$row[name] $row[lv]</p>";
}
sqlsrv_free_stmt($query);
//Credit to nimoht & Icoderz\FlyffResu ranking
sqlsrv_close($conn);
?>
Quote:
<?php
@$pseudo = $_POST['pseudo'];
@$pass = $_POST['pass'];
$key = "univers";
$hdpass = md5("$key$pass");
$hostname = '*******';
$connection_options = array('Database'=>'auth', 'UID'=>'sa', 'PWD'=>'******');
$conn = sqlsrv_connect($hostname, $connection_options);
if( $conn === false )
{
echo "Impossible de se connecter au serveur .\n";
die( print_r( sqlsrv_errors(), true));
}
$tsql = "INSERT INTO [Accounts]
([login_name]
,[password]
,[referral_id]
,[referral_code]
,[pcbang]
,[block]
,[withdraw_remain_time]
,[age]
,[auth_ok]
,[last_login_server_idx]
,[event_code]
,[server_list_mask]
,[result]
,[ip]
,[game_code]
,[gamecode]
,[login_event]
,[email])
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
$params = array($pseudo,$hdpass,0,0,0,0,0,18,1,1,0,0,0,0,0,0 ,0,0);
$stmt = sqlsrv_query( $conn, $tsql, $params);
if( $stmt === false )
{
die( print_r( sqlsrv_errors(), true));
}
else if( $stmt === true )
{
$reponse="<p>valide</p>";
echo $reponse;
}
sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
Pseudo : <input type="text" size="20" name="pseudo" /><br />
Mot de passe : <input type="password" size="20" name="pass" /><br /><br/>
<strong> Notre système d'inscription est temporaire et ne présente aucun message de validation.<br/>
Cependant, votre compte est quand même inscrit sur notre service !<br/>
Un prochain script d'inscription verra le jour dans la semaine !<br/>
Si toute fois vous n'arrivez pas a vous connectez, modifié le nom de compte.</strong><br/>
<input type="submit" value="Inscrivez-vous !" name="senden" />
</form>
<?php
session_start();
if(isset($_POST['submit']) == true)
{
$error = "";
if (preg_match("/[^a-zA-Z0-9\-\_\!\$\#\@\^\&\*\(\)\^\+\ \.\?]/", $_POST['username']))
{
$_SESSION['islogged'] = false;
$error = "Sorry, invalid char(s) in your username.";
}
else
{
if (preg_match("/[^a-zA-Z0-9\-\_\!\$\#\@\^\&\*\(\)\^\+\ \.\?]/", $_POST['password']))
{
$_SESSION['islogged'] = false;
$error = "Sorry, invalid char(s) in your password.";
}
else
{
$username = $_POST['username'];
$password = $_POST['password'];
$hash = "*****";
$encryptedpw = md5($hash$password);
$sqlsrv_server = "****";
$sqlsrv_username = "sa";
$sqlsrv_password = "*******";
$connection_infos = array( "UID"=>$sqlsrv_username,"PWD"=>$sqlsrv_password,"Database"=>"Auth");
$conn = sqlsrv_connect($sqlsrv_server, $connection_infos);
if( $conn === false )
{
die( print_r(sqlsrv_errors(), true));
}
else
{
$sql = "SELECT * FROM Accounts WHERE login_name = ?";
$params = array($username);
$get01 = sqlsrv_query($conn, $sql, $params);
if( $get01 === false )
{
die( print_r(sqlsrv_errors(), true));
}
else
{
$row01 = sqlsrv_fetch_array($get01);
if($encryptedpw == $row01['password'])
{
$_SESSION['islogged'] = true;
header("location:login_success.php");
}
else
{
$_SESSION['islogged'] = false;
$error = "Password is incorrect";
}
sqlsrv_free_stmt($get01);
}
sqlsrv_close( $conn );
}
}
}
}
?>
<form name="form" method="post"> <li><a href='#'>Identifiant:</a></li> <li><input name="username" value="" required /> </li> <li><a href='#'>Mot de passe:</a></li> <li><input type="password" name="password" value="" required ></li> <input type="submit" value="Connexion" name='submit' class="login" /><br/> <?php echo $error; ?> </form>