29-09-2006, 16:23
|
|
|
חבר מתאריך: 07.08.05
הודעות: 18
|
|
קוד PHP:
<?php include "connect.php"; $user1 = $_GET['user']; $query = "SELECT * FROM users WHERE user = '$user1'"; $result1 = mysql_query($query) or die("query"); $r1 = mysql_fetch_assoc($result1);
$query = "SELECT * FROM suprise WHERE user = '$user1'"; $result2 = mysql_query($query) or die("query"); $r2 = mysql_fetch_assoc($result2);
$ip = $_SERVER[REMOTE_ADDR]; if($r2['ip'] == $ip){ echo " "; }else{ $bonus = $r1['bonus']; $addbonus = $bonus + 1; mysql_query("UPDATE users SET bonus = '$addbonus' WHERE user = '$user1'") or die(mysql_error()); mysql_query("INSERT INTO suprise VALUES('$id', '$user1','$ip')"); } mysql_close($connection); ?>
תנסה ככה אולי
|