<?php
require_once("config.php");
function add_user($db,$ip, $referrer){
if($referrer == ""){$referrer = 0;}else{$referrer = mysql_real_escape_string($referrer);}
$check = mysql_query("SELECT * FROM `users` WHERE ip= '$ip'");
if(mysql_num_rows($check) == 0 ){
//Add user to the db
$sql = "INSERT INTO `$db`.`users` (`id`, `ip`, `referrer`, `referrals`, `date`) VALUES ('', '$ip', '$referrer', '0', '$date', '( new DateTime() )->format('Y-m-d H:i:s')');";
mysql_query($sql);
//Add +1 referrals to their referrer (if is set)
$sql = "UPDATE `$db`.`users` SET `referrals` = `referrals`+1 WHERE `users`.`id`='$referrer';";
mysql_query($sql);
return false;
}elseif(mysql_num_rows($check) > 0 ){
return true;
}
}
function add_prize($db,$thumb, $name, $desc,$prize,$cost){
$sql = "INSERT INTO `$db`.`prizes`(`id`,`thumb`,`name`,`desc`,`prize`,`cost`) VALUE ('','$thumb','$name','$desc','$prize','$cost')";
mysql_query($sql);
}
function edit_prize($db,$id,$thumb, $name, $desc,$prize,$cost){
$sql = "UPDATE `$db`.`prizes` SET `thumb` = '$thumb',
`name` = '$name',
`desc` = '$desc',
`prize` = '$prize',
`cost` = '$cost' WHERE `prizes`.`id` ='$id';";
mysql_query($sql);
}
function delete_prize($db,$id){
$sql ="DELETE FROM `$db`.`prizes` WHERE `prizes`.`id` ='$id';";
mysql_query($sql);
}
function get_user($ip){
$result = mysql_query("SELECT * FROM `users` WHERE ip='$ip'");
while ($row = mysql_fetch_array($result))
{
$check = mysql_query("SELECT * FROM `users` WHERE `ip` = '$ip'");
if(mysql_num_rows($check) == 0)
{
return false;
}elseif(mysql_num_rows($check) > 0){
return true;
}
}
}
function get_prize($id){
$result = mysql_query("SELECT * FROM `prizes` WHERE id='$id'");
while ($row = mysql_fetch_array($result))
{
$check = mysql_query("SELECT * FROM `prizes` WHERE `id` = '$id'");
if(mysql_num_rows($check) == 0)
{
return false;
}elseif(mysql_num_rows($check) > 0){
return array (
$row['id'],$row['thumb'],
$row['name'],
$row['desc'],
$row['prize'],
$row['cost']
);
}
}
}
?>
