AVrJD0bk

1<?php
2### Database : ###################################
3### DROP TABLE IF EXISTS `bonus_cash`;         ###
4### CREATE TABLE `bonus_cash` (                ###
5###  `user_index` varchar(50) NOT NULL,        ###
6###  `ip` varchar(30) NOT NULL,                ###
7###  `time` varchar(50) NOT NULL,              ###
8###  PRIMARY KEY (`ip`)                        ###
9### ) ENGINE=InnoDB DEFAULT CHARSET=latin1;    ###
10##################################################
11
12$conn = @new mysqli( 'localhost', 'root', 'root', 'newproject_db_auth' ) or die("ERROR#1 No connection");
13
14if (isset( $_GET['id'] )):
15$id = mysqli_real_escape_string ($conn,$_GET['id']);
16$ip = mysqli_real_escape_string ($conn,$_SERVER['REMOTE_ADDR']);
17$time = mysqli_real_escape_string ($conn,date("d. F o H:i:s"));
18
19if (ctype_digit($id)):
20$qIP = "SELECT * FROM bonus_cash";
21$IPexec = $conn->query($qIP) OR die("Error#2: IP Query has failed!");
22while ($eIP = mysqli_fetch_object($IPexec));
23if ($eIP->ip == $ip):
24echo "ERROR#3 IP ".$eIP->ip." was already used!";
25Exit;
26else:
27EndIf;
28$s = "INSERT INTO bonus_cash(user_index,ip,time) VALUES ('".$id."','".$ip."','".$time."');";
29$s1 = "UPDATE bg_user SET cash = cash + '5000' WHERE user_code ='".$id."';";
30$qIn = mysqli_query ($conn,$s) OR die("Error#4: bonus_cash insert query has failed!".$eIP->ip."");
31$qCash = mysqli_query ($conn,$s1) OR die("Error#5: Cash query has failed!");
32echo "Success :) <br> You'll be redirected after 5 seconds.";
33?>
34<script language="JavaScript" type="text/javascript">
35setTimeout("location.href='register.php'", 5000);
36</script>
37<?php
38else:
39echo "DON'T MESS WITH ME!";
40EndIf;
41else:
42Echo "DON'T MESS WITH ME!";
43EndIf;
44$conn->close();
45?>