<?php
/* MyScripts V2 Script *\
*- Script for Kryptos
*- Script made by Mac
\* MyScripts V2 Script */
Include("/config.php");
Class Forum {
Function getUserDetails() {
$GetUsersOnline = MySQL_Query("SELECT * FROM users WHERE online = '1'") ;
$GetLastUser = MySQL_Query("SELECT MAX(id) FROM users LIMIT '1'") ;
}
Function getForumDetails() {
$Members = MySQL_Query("SELECT * FROM users ORDER BY id DESC") ;
$Posts = MySQL_Query("SELECT * FROM posts ORDER BY id DESC") ;
}
}
$Forum = new Forum;
$Forum->getUserDetails();
While( $echoUser = mysql_fetch_array( $GetUsersOnline ) ) {
Echo "<p>Users online are: ".$echoUser['username']." , </p>";
}
While( $echoUser2 = mysql_fetch_array( $GetLastUser ) ) {
Echo "<p>Last registred user : ".$echoUser2['username']."</p>";
}
$Forum->getForumDetails();
While( $echoForum = mysql_fetch_array($Members) ) {
Echo "<p>There are ".$echoForum['id']." members registred</p>";
}
While( $echoForum2 = mysql_fetch_array($Posts) ) {
Echo "<p>There are totaly ".$echoForum2['id']." posts</p>";
}
?>
<?php
session_start();
$pg = $_GET['pg'];
$host = "localhost";
$username = "root";
$password = "bess123";
$database = "PHPRetain";
class MySQL {
function connect() {
Global $host, $username, $password, $database;
mysql_connect($host, $username, $password);
}
function selectdb() {
Global $host, $username, $password, $database;
mysql_select_db($database);
}
function query($string) {
return mysql_query($string);
}
}
$mysql = new MySQL;
$mysql->connect();
$mysql->selectdb();
if(!$pg) {
?>
<form action='?pg=login'>
<b>Username:</b> <input type='text' name='username'>
<br /><br />Password:</b> <input type='password' name='password'>
<input type='submit' value='Log in!'>
</form>
<?php
}
if($pg == "login") {
$username = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);
$sql = $mysql->query("SELECT * FROM users WHERE username='$username' and password='$password'");
$check = mysql_num_rows($sql);
if($check == 1) {
session_register("username");
session_register("password");
header("location: ?pg=Home");
}
else {
echo "Wrong username or password";
}
}
if($pg == "Home") {
$selectrank = $mysql->query("SELECT * FROM users WHERE username='$_SESSION[username]'");
while($var = mysql_fetch_array($selectrank)) {
if($var['rank'] == "2") {
echo "<a href='?pg=Home&pg2=hk'>Housekeeping</a>";
}else{
echo "<p>You dont have acess of housekeeping</p>";
}
}
?>
<fieldset>
<legend>Welcome....</legend>
Bla bla bla... ?
</fieldset>
<?php
$pg2 = $_GET['pg2'];
if($pg2 == "hk") {
while($var2 = mysql_fetch_array($selectrank)) {
if($var2['rank'] == "2") {
$users = $mysql->query("SELECT * FROM users");
while($var3 = mysql_fetch_array($users)) {
echo $var3['username']." invited by ";
if(empty($refferedby)) {
echo "None<br />";
}
else {
echo $var3['refferedby']."<br />";
}
}
}else{
echo "<p>You dont have acess of housekeeping</p>";
}
}
}
}
if($pg == "Register") {
echo "<form method='post'>";
echo "<b>Your username:</b> <input type='text' name='username'><br />";
echo "<b>Your password:</b> <input type='password' name='password'><br />";
echo "<b>You are reffered by:</b> <input type='text' name='refferedby'><br />";
echo "<input type='submit' value='Register' name='Register'>";
echo "</form>";
if($_POST['Register']) {
$error = "";
if($_POST['username'] < 3) {
$error .= "<p>Please post a username with more than 3 lenghts.</p>";
}
if($_POST['password'] < 3) {
$error .= "<p>Please post a password with more than 3 lenghs.</p>";
}
$username_taken = $mysql->query("SELECT * FROM users");
while($var5 = mysql_fetch_array($username_taken)) {
if($_POST['username'] == $var5['username']) {
$error .= "<p>Username is already taken.</p>";
}
}
if(!$error) {
$mysql->query("INSERT INTO users VALUES('$_POST[username]', '$_POST[password]', '$_POST[refferedby]', '1'");
}
else {
echo $error;
}
}
}
?>>