Baza se sastoji iz 3 fajla, index.html, connect.php i login.php
index.html - u ovom fajlu treba da sredite sami layout tj izgled, u njemu se nalazi forma za prijavu panelu
connect.php - u ovom fajlu podesavate red " $con = mysql_connect("localhost","testuser","*********"); " , obavezeno unesite gdje se vasa baza nalazi, user i pass za prijavljivanje ( NAPOMENA: tu ne unosite username i pass koji vi zelite za ucp, vec MySql username i password accounta od vase baze!)
login.php - ovaj fajl poziva iz baze username koji pokusava da se prijavi na index.html; bitno je da promjenite ovaj red: " $query = "SELECT * FROM users WHERE pUsername = '$escuser'"; " - "users" promjenite u ime vase table u bazi a "pUsername" u naziv varijable u kojoj cuvate ime igraca.
index.html
<html>
<head><title>Gigi's UCP</title></head>
<body>
<form action="login.php" method="post">
<table align="center">
<tr>
<td align="center">
<b><font size="4" color="#000080">Gigi's UCP</font></b>
</td>
</tr>
<tr align="center">
<td><p><input type="text" name="User" size="20" /></p><p><input type="password" name="Password" size="20" /></p></td>
</tr>
<tr>
<td align="center"><p><input type="submit" />
<input type="reset" /> </p></td>
</tr>
</table>
</form>
</body>
</html>connect.php
<?php
$con = mysql_connect("localhost","testuser","*********");
mysql_select_db("testuser");
?>login.php
<?php
include("connect.php");
session_start();
function sanitizeString($var){
$var = stripslashes($var);
$var = htmlentities($var);
$var = strip_tags($var);
return $var;
}
function sanitizeSQL($var){
$var = mysql_real_escape_string($var);
$var = sanitizeString($var);
return $var;
}
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if(isset($_SESSION["Username"]))
{
$user = $_SESSION["Username"];
$pass = $_SESSION["Password"];
}
else
{
$user = $_POST["User"];
$pass = $_POST["Password"];
$_SESSION['Username'] = $user;
$_SESSION['Password'] = $pass;
$escuser = sanitizeSQL($user);
$escpass = sanitizeSQL($pass);
}
$query = "SELECT * FROM users WHERE pUsername = '$escuser'";
$result = mysql_query($query);
$username_exist = mysql_num_rows($result);
if($username_exist == 0)
{
echo 'That profile does not exist!
';
echo ' unset($_SESSION['Username']);
unset($_SESSION['Password']);
die;
}
$row = mysql_fetch_row($result);
if($row !== $escpass)
{
echo 'Password is not valid!
';
echo '<a href="index.php">Idi nazad</a>';
unset($_SESSION['Username']);
unset($_SESSION['Password']);
die;
}
$message = "Welcome $escuser!
";
echo $message;
echo "
";
echo "
<table border = 1>
<tr>
<td>Varijabla 1</td>
<td>$row</td>
</tr>
<tr>
<td>Varijabla 2</td>
<td>$row</td>
</tr>
</table>";
?>nadam se da ce nekome ovaj kod pomoci 😉
napomena: u koliko cete ucp koristiti za samp server, potrebno je da imate mysql kompatibilan mod, takodje i mysql server ( u koliko koristite kucni server dobar vam je wamp server, a ukoliko koristite linux uzmite lamp server)