db=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD))) { die("Unable to connect to database using configuration from wp-config.php"); } if(!mysql_select_db(DB_NAME,$this->db)) { die("Unable to select database from wp-config.php"); } } function get_row($q) { if(empty($q)) { return false; } $r=mysql_query($q); if(!$r) { $this->error="Error executing SQL query '".$q."': ".mysql_error(); return false;} else { $this->error=false; } if(!mysql_num_rows($r)) { return 0; } $row=mysql_fetch_row($r); return $row; } function doquery($q) { if(empty($q)) { return false; } $r=mysql_query($q); if($r) { $this->error=false; return true; } else { $this->error=mysql_error(); } } function query_rows($q) { if(empty($q)) { return false; } $r=mysql_query($q); if(!$r) { $this->error="Error executing query '".$q."': ".mysql_error(); return -1; } else { $this->error=false; } return $r; } } $psdb=new psdb; $t=time(); $r=$psdb->get_row("SELECT name,starttime,lasttime FROM ajaxim_sess WHERE sessid='".session_id()."'"); if($psdb->error) { print $psdb->error; } if($r==0) { foreach($_COOKIE as $cname=>$cvalue) { if(preg_match('/^wordpress_logged_in/',$cname)) { $cvals=explode("|",$cvalue); $name=$cvals[0]; } } $name=$name ? $name : "Guest_".getrand(5); $_SESSION['myName']=$name; $psdb->doquery("INSERT INTO ajaxim_sess (name,lasttime,starttime,sessid) VALUES('".$name."',".$t.",".$t.",'".session_id()."')"); if($psdb->error) { print $psdb->error; } } else { if($t-$r[2]>=30) { $psdb->doquery("UPDATE ajaxim_sess SET lasttime=".$t." WHERE sessid='".session_id()."'"); } } $_SESSION['lastmsg']=$id; $r2=$psdb->query_rows("SELECT name,time,msg,msgid FROM ajaxim_data WHERE time>".($r==0?$t:$r[1])." AND msgid>".$id." ORDER BY time"); if($psdb->error) { print $psdb->error; } if(mysql_num_rows($r2)) { $str=""; while($row=mysql_fetch_row($r2)) { $str.="

(".date("g:ia",$row[1]).") <".$row[0]."> ".stripslashes($row[2])."

"; } print $str; } ?>