Dobra ja juz stracilem cierpliwosc do tego :? Pomozcie ! Macie caly skrypt rejestrujacy, wyrejestrowujacy, updatujacy i zliczajacy... i powiedzcie mi dlaczego :
1) gdy za pierwszym razem odpalam strone nie widzi SESSID
2) czemu co ktores odswiezenie strony wiczba gosci to raz sie zwieksz to zmniejsza, na pewno jestem wtedy sam na strone
3) znajdzcie ogoolnie w tym bledy...
JA NIE MAM JUZ NA TO SILY !
[php:1:7a145390b5]<?php
include('connect.inc');
if(isset($_COOKIE["PHPSESSID"])){
$query = "SELECT * FROM users WHERE login='".$login_db."'";
$result = mysql_query($query, $db_link);
if($result && mysql_num_rows($result)>0){
$val=mysql_fetch_array($result,MYSQL_ASSOC);
$haslo_md5=md5($haslo_db);
if($login_db==$val["login"] && $haslo_md5==$val["password"]){
$query = "SELECT * FROM ug WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
$result = mysql_query($query, $db_link);
if($result && mysql_num_rows($result)>0){
$val=mysql_fetch_array($result,MYSQL_ASSOC);
$time=time();
$query="UPDATE ug set time=".$time." WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
mysql_query($query,$db_link);
$query="UPDATE ug set u=1 WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
mysql_query($query,$db_link);
$query="UPDATE ug set g=0 WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
mysql_query($query,$db_link);
}
else{
$time=time();
$query="INSERT INTO ug(sessid,time,u,g) VALUES('".$_COOKIE["PHPSESSID"]."',".$time.",1,0)";
mysql_query($query);
}
}
if($_POST["log_opt"]=='logout'){
$time=time();
$query="UPDATE ug set time=".$time." WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
mysql_query($query,$db_link);
$query="UPDATE ug set u=0 WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
mysql_query($query,$db_link);
$query="UPDATE ug set g=1 WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
mysql_query($query,$db_link);
}
}
else{
$query = "SELECT * FROM ug WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
$result = mysql_query($query, $db_link);
if($result && mysql_num_rows($result)>0){
$val=mysql_fetch_array($result,MYSQL_ASSOC);
$time=time();
$query="UPDATE ug set time=".$time." WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
mysql_query($query);
$query="UPDATE ug set u=0 WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
mysql_query($query,$db_link);
$query="UPDATE ug set g=1 WHERE sessid='".$_COOKIE["PHPSESSID"]."'";
mysql_query($query,$db_link);
}
else{
$time=time();
$query="INSERT INTO ug(sessid,time,u,g) VALUES('".$_COOKIE["PHPSESSID"]."',".$time.",0,1)";
mysql_query($query);
}
}
}
else{
$query = "SELECT * FROM ug WHERE sessid='guest'";
$result = mysql_query($query, $db_link);
if($result && mysql_num_rows($result)>0){
$val=mysql_fetch_array($result,MYSQL_ASSOC);
$time=time();
$query="UPDATE ug set time=".$time." WHERE sessid='guest'";
mysql_query($query);
$query="UPDATE ug set u=0 WHERE sessid='".guest."'";
mysql_query($query,$db_link);
$query="UPDATE ug set g=1 WHERE sessid='".guest."'";
mysql_query($query,$db_link);
}
else{
$time=time();
$query="INSERT INTO ug(sessid,time,u,g) VALUES('guest',".$time.",0,1)";
mysql_query($query);
}
}
$query = "SELECT * FROM ug";
$result = mysql_query($query, $db_link);
$row = 0;
$n_u=0;
$n_g=0;
if(mysql_num_rows($result) > 0){
for($row = 0; $row < mysql_num_rows($result);$row++){
$time_db=mysql_result($result, $row, 'time');
$time=time();
$sessid = mysql_result($result, $row, 'sessid');
if(($time-$time_db) > 300){
$sessid = mysql_result($result, $row, 'sessid');
$query = " DELETE FROM ug WHERE sessid = '$sessid'";
mysql_query($query, $db_link);
}
if(($time-$time_db) < 300 && ($time-$time_db) > 0){
$sessid = mysql_result($result,$row,'sessid');
$query = "UPDATE up SET time = '$time' WHERE sessid = '".$sessid."'";
mysql_query($query, $db_link);
$g = mysql_result($result, $row, 'g');
$u = mysql_result($result, $row, 'u');
if($u==1){
$n_u++;
}
if($g==1){
$n_g++;
}
}
}
}
?>[/php:1:7a145390b5]
Z goory thx ;]