Create("localDatabase"); $sql1 = new MySQL_class;$sql1->Create("localDatabase"); $ctime = time();$userid = 10; function secondsToTime($before) { $diff = time() - $before; $d = $diff / 86400 % 7; $h = $diff / 3600 % 24; $m = $diff / 60 % 60; $s = $diff % 60; if($s > 0){$ltime = "{$s} seconds ";} if($m > 0){$ltime = "{$m} minutes ";} if($h > 0){$ltime = "{$h} hours ";} if($d > 0){$ltime = "{$d} days ";} return $ltime; } function replace_links($s) { return preg_replace('@(http?://([-\w\.]+)+(:\d+)?(/([\w/_\.-]*(\?\S+)?)?)?)@', '$1', $s); } $pid = $_POST['pid']; if ($pid > 0 ) { // Add New Reply If (!empty($_POST['submit']) && $_POST['submit']= 'Submit Reply' && strlen($_POST['reply']) > 30) { $reply = addslashes($_POST['reply']); $selQuery = "SELECT COUNT(*) FROM ls_feedback WHERE comment = '$reply'"; $sql->QueryItem($selQuery); $cid = $sql->data[0]; if($cid == 0){ $insQuery = "INSERT INTO ls_feedback (pid, userid, name, comment, addtime) VALUES ($pid, $userid, '$duser', '$reply', $ctime)"; $sql->Query($insQuery); } } } else { // Add New Comment If (!empty($_POST['submit']) && strlen($_POST['comment']) > 30) { $comment= addslashes($_POST['comment']); $selQuery = "SELECT COUNT(*) FROM ls_feedback WHERE comment = '$comment'"; $sql->QueryItem($selQuery); $id = $sql->data[0]; if($id == 0){ $insQuery = "INSERT INTO ls_feedback (userid, name, comment, addtime) VALUES ($userid, '$duser', '$comment', $ctime)"; $sql->Query($insQuery); } } } // Select Last 15 Comments $selQuery = "SELECT id, trim(comment), firstname, lastname, profileUrl, thumbnail, a.addtime FROM ls_feedback a, users b WHERE a.userid = b.userid AND status =0 AND pid =0 ORDER BY addtime desc LIMIT 15"; $sql->Query($selQuery); for ($i = 0; $i < $sql->rows; $i++) { $sql->Fetch($i); $id = $sql->data[0]; $comment = $sql->data[1]; $comment = replace_links($comment); $fname = $sql->data[2]; $lname = $sql->data[3]; $name = "$fname $lname"; $url = $sql->data[4]; $thumbnail = $sql->data[5]; $addtime = $sql->data[6]; $comtime = secondsToTime($addtime); $reply = ""; // Find latest 15 reply $selCQuery = "SELECT id, trim(comment), firstname, lastname, profileUrl, thumbnail, a.addtime FROM ls_feedback a, users b WHERE a.userid = b.userid AND status = 0 AND pid = $id ORDER BY addtime desc LIMIT 15"; $sql1->Query($selCQuery); for ($j = 0; $j < $sql1->rows; $j++) { $sql1->Fetch($j); $cid = $sql1->data[0]; $ccomment = $sql1->data[1]; $ccomment = replace_links($ccomment); $cfname = $sql1->data[2]; $clname = $sql1->data[3]; $cname = "$fname $lname"; $cname = "Anonymous"; $curl = $sql1->data[4]; $cthumbnail = $sql1->data[5]; $caddtime = $sql1->data[6]; $reptime = secondsToTime($caddtime); $reply .= "

$ccomment
$cname $reptime ago

"; } $userfeed .= "

$comment

$name $comtime ago
Click To Reply
$reply
"; } $sql->Close(); include("header.min.inc");?>