$loAuto = $_COOKIE['loAuto']; if($loAuto&&!$_SESSION['userid']){ $ip = $_SERVER['REMOTE_ADDR']; $enddate = date('YmdHis'); $code = $_COOKIE['loAutoCode']; include_once $_SERVER['DOCUMENT_ROOT'].'/member/system/one_member_db.php'; //db 접속 $sql = "select num,id,nic,enddate,alive,ip,point,overlap,code from member_g where num = '$loAuto' limit 1"; $result = mysql_query($sql); $record = mysql_num_rows($result); if($record){ $row = mysql_fetch_array($result); if($ip == long2ip($row['ip']) && $row['ip'] != null && $row[code] == $code){ mysql_query('begin'); $sql = "update member_g set enddate = '$enddate' where num = '$loAuto' limit 1"; $transaction = mysql_query($sql) * $transaction; if($transaction){ mysql_query('commit'); $_SESSION['userid'] = $row['id']; $_SESSION['usernic'] = $row['nic']; $_SESSION['usernum'] = $row['num']; $_SESSION['alive'] = $row['alive']; $_SESSION['latetime'] = $row['enddate']; $_SESSION['overlap'] = $row['overlap']; // 중복((도베)방지 $_SESSION['point'] = $row['point']; $_SESSION['token'] = md5(uniqid(rand(), true)); setcookie('loAuto', $row['num'], time() + 2592000, '/'); setcookie('loAutoCode', $row[code], time() + 2592000, '/',true); }else{ mysql_query('rollback'); } }else{ setcookie('loAuto', 0, time() + 0, '/'); setcookie('loAutoCode', 0, time() + 0, '/'); } }else{ setcookie('loAuto', 0, time() + 0, '/'); setcookie('loAutoCode', 0, time() + 0, '/'); }mysql_close($conn); } ?>