Sistema referidos [Expert]

<input type="text" style="width:240px;" value="<?php echo $path; ?>/refer.php?r=<?php echo $name; ?>" disabled="disabled"/>
<input type="text" style="width:240px;" value="<?php echo $path; ?>/refer/<?php echo $name; ?>" disabled="disabled"/>

<h4>*Referidos <?php echo $name; ?></h4>
<input type="text" style="width:240px;" value="Você possui: <?php if(!isset($_GET['n'])) {
$usuario = $name;
} else {
$usuario = mysql_real_escape_string($_GET['n']);
}
$query = mysql_query("SELECT COUNT(id) AS aantalleden FROM users_referidos WHERE usuario ='". $usuario ."' ORDER BY ID") or die(mysql_error());
$data = mysql_fetch_assoc($query); echo $data['aantalleden'];?> de Referência" disabled="disabled"/>

-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: 20/07/2012 às 22h38min
-- Versão do Servidor: 5.1.63
-- Versão do PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Banco de Dados: `blitzhotelnet`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `users_referidos`
--

CREATE TABLE IF NOT EXISTS `users_referidos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usuario` varchar(400) NOT NULL DEFAULT 'user',
`ip_referida` varchar(50) NOT NULL,
`fecha` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

--
-- Extraindo dados da tabela `users_referidos`
--

INSERT INTO `users_referidos` (`id`, `usuario`, `ip_referida`, `fecha`) VALUES
(1, 'Thalys', '127.0.0.1', 'teste'),
(2, 'Thalys', '174.37.164.104', '1342745062'),
(3, 'Durfort', '187.114.128.174', '1342749423'),
(4, 'Durfort', '187.13.46.65', '1342749427'),
(5, 'Durfort', '187.74.91.150', '1342749574'),
(6, 'Durfort', '177.157.98.101', '1342749982'),
(7, 'Durfort', '2.82.249.202', '1342750071'),
(8, 'Durfort', '189.74.97.5', '1342750204'),
(9, 'Durfort', '201.95.77.201', '1342750249'),
(10, 'Durfort', '189.79.117.228', '1342750723'),
(11, 'Durfort', '201.83.192.250', '1342750950'),
(12, 'Durfort', '177.42.24.15', '1342750962'),
(13, 'Durfort', '189.69.188.226', '1342751061'),
(14, 'Caio', '187.117.156.213', '1342751667'),
(15, 'Durfort', '187.58.41.44', '1342762565'),
(16, 'Durfort', '186.218.154.177', '1342784269'),
(17, 'Durfort', '189.70.125.50', '1342832051'),
(18, 'Durfort', '187.20.28.102', '1342832198'),
(19, 'Durfort', '201.79.13.124', '1342832261'),
(20, 'Durfort', '177.34.203.200', '1342832519'),
(21, 'Durfort', '189.31.2.180', '1342832580'),
(22, 'Durfort', '187.15.189.238', '1342833086'),
(23, 'Durfort', '189.15.195.209', '1342833108'),
(24, 'Durfort', '177.125.145.14', '1342833530'),
(25, 'Durfort', '177.19.84.74', '1342833718'),
(26, 'Gewandz', '69.171.247.1', '1342833960'),
(27, 'Gewandz', '186.221.127.104', '1342833961'),
(28, 'Durfort', '189.70.39.150', '1342834297'),
(29, 'Durfort', '189.41.49.154', '1342834390'),
(30, 'Durfort', '189.125.229.11', '1342834445'),
(31, 'Durfort', '177.97.55.118', '1342834673');

DELIMITER $$
--
-- Eventos
--
CREATE EVENT `resetear_respetos_caricias` ON SCHEDULE EVERY 24 HOUR STARTS '2012-01-01 23:59:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE user_stats
SET
DailyRespectPoints = '3',
DailyPetRespectPoints = '3'$$

DELIMITER ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

<?php

require_once('./data_classes/server-data.php_data_classes-core.php.php');

if($logged_in){
header("Location: ".$path."/me");
exit;
}

$ip_check = mysql_query("SELECT ip_last,username,id FROM users WHERE ip_last = '".$remote_ip."'");

if(isset($_GET['cancal'])){
session_unset();
header("Location: $path/");
exit;
}


switch($_GET['stap']){
case "1":
if(isset($_SESSION['jjp']['register'][1])){
header("Location: ".$path."/quickregister/email_password");
}

require_once('./templates/register_subheader.php');
require_once('./templates/quickregister/page-register-1.php');

break;

case "2":
$bday_day = FilterText($_POST['bean_day']);
$bday_month = FilterText($_POST['bean_month']);
$bday_year = FilterText($_POST['bean_year']);
$gender = FilterText($_POST['bean_gender']);

if (!is_numeric($bday_day) || !is_numeric($bday_month) || !is_numeric($bday_year) || $bday_day <= 0 || $bday_day > 31 ||
$bday_month <= 0 || $bday_month > 12 || $bday_year < 1900 || $bday_year > 2010)
{
$errors = "Por favor, debes proporcionar una fecha válida";

}else if(!empty($gender)){
$_SESSION['jjp']['register'][1]['bday_day'] = $bday_day;
$_SESSION['jjp']['register'][1]['bday_month'] = $bday_month;
$_SESSION['jjp']['register'][1]['bday_year'] = $bday_year;
$_SESSION['jjp']['register'][1]['gender'] = $gender;
header("Location: ".$path."/quickregister/email_password");
exit;
}else{
$errors = "Por favor, debes proporcionar una fecha válida";
}

require_once('./templates/register_subheader.php');
require_once('./templates/quickregister/page-register-1.php');

exit;
break;

case "3":
if(!isset($_SESSION['jjp']['register'][1])){
header("Location: ".$path."/quickregister/start");
} elseif(isset($_SESSION['jjp']['register'][2])){
header("Location: ".$path."/quickregister/captcha");
}

require_once('./templates/register_subheader.php');
require_once('./templates/quickregister/page-register-2.php');

break;

case "4":
$name = FilterText($_POST['bean_name']);
$email = FilterText($_POST['bean_email']);
$email2 = FilterText($_POST['bean_retypedEmail']);
$pass1 = FilterText($_POST['bean_password']);
$pass2 = FilterText($_POST['bean_retypedPassword']);

$filter = preg_replace("/[^a-z\d\-=\?!@:\.]/i", "", $name);
$email_check = preg_match("/^[a-z0-9_\.-]+@([a-z0-9]+([\-]+[a-z0-9]+)*\.)+[a-z]{2,7}$/i", $email);

$tmp = mysql_query("SELECT id FROM users WHERE username = '".$name."' LIMIT 1") or die(mysql_error());
$tmp = mysql_num_rows($tmp);

$first = substr($name, 0, 4);

// NAME CHECK

if(strnatcasecmp($first,"MOD-") == false) {
$errors = "Dieser Username ist ungültig";
}elseif($tmp > 0){
$errors = "Der Name ist leider vergeben!";
}elseif($filter !== $name){
$errors = "Dieser Username ist ungültig.";
}elseif(strlen($name) > 12){
$errors = "Dieser Username ist zulang.</p></div>";

// E-MAIL CHECK

}elseif($email_check !== 1){
$errors = "Ungültige E-Mail Adresse";
}elseif(strlen($email) < 6){
$errors = "Ungültige E-Mail Adresse";
}elseif($email !== $email2){
$errors = "Die Email-Adressen stimmen nicht überein";

// PASSWORT CHECK

}elseif($pass1 !== $pass2){
$errors = "Die Passwörter stimmen nicht überein";
}elseif(isset($_POST['bean_termsOfServiceSelection'])){
$_SESSION['jjp']['register'][2]['name'] = $name;
$_SESSION['jjp']['register'][2]['email'] = $email;
$_SESSION['jjp']['register'][2]['pass'] = $pass1;

header("Location: ".$path."/quickregister/captcha");
exit;
}else{
$errors = "Bitte akzeptiere die Nutzungsbedienung";
}

require_once('./templates/register_subheader.php');
require_once('./templates/quickregister/page-register-2.php');

exit;
break;

case "5":
if(!isset($_SESSION['jjp']['register'][1])){
header("Location: ".$path."/quickregister/start");
}elseif(!isset($_SESSION['jjp']['register'][2])){
header("Location: ".$path."/quickregister/email_password");
}

require_once('./templates/register_subheader.php');
require_once('./templates/quickregister/page-register-3.php');
break;

case "6":

if($_SESSION['register-captcha-bubble'] !== strtolower($_POST['captchaResponse'])){
$errors = "Der Sicherheitscode war leider nicht korrekt. Bitte versuch es noch einmal.";
}else{
if($_SESSION['jjp']['register'][1]['gender'] == "male"){
$look = 'hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100-';
$gender = 'M';
}else{
$look = 'hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100-';
$gender = 'F';
}

mysql_query("INSERT INTO `users` (username,real_name,password,auth_ticket,motto,mail,rank,look,gender,account_created,last_online,online,ip_last,ip_reg,working,secretcode,mymusik) VALUES ('".$_SESSION['jjp']['register'][2]['name']."','HabboRE','".HoloHashMD5($_SESSION['jjp']['register'][2]['pass'])."','-/-','Qual pensamento de hoje?','".$_SESSION['jjp']['register'][2]['email']."','1','".$look."','".$gender."','".time()."','".time()."','1','".$remote_ip."','".$remote_ip."','','','')") or die(mysql_error());

$userdata2 = mysql_query("SELECT * FROM users WHERE username = '".$_SESSION['jjp']['register'][2]['name']."'");
$userdata = mysql_fetch_assoc($userdata2);

mysql_query("INSERT INTO `user_info` (user_id,reg_timestamp) VALUES ('".$userdata['id']."','".time()."')");
mysql_query("INSERT INTO `user_stats` (id) VALUES ('".$userdata['id']."')");

$_SESSION['username'] = $_SESSION['jjp']['register'][2]['name'];
$_SESSION['password'] = HoloHashMD5($_SESSION['jjp']['register'][2]['pass'], $_SESSION['jjp']['register'][2]['name']);

unset($_SESSION['jjp']['register']);

header("Location: ../me");
exit;
}

require_once('./templates/register_subheader.php');
require_once('./templates/quickregister/page-register-3.php');
exit;
break;
}

?>

Koily escreveu:Ficou bem interessante aparentemente, depois eu testo. Espero que funcione bem.

Obrigado por compartilhar.