select("blogcomments", ["[>]user" => ["operatorid" => "id"], "[>]clients" => ["clientid" => "id"]], ["blogcomments.id", "blogcomments.commentid", "blogcomments.message", "blogcomments.votes", "blogcomments.approve", "blogcomments.time", "blogcomments.session", "user.id(oid)", "user.name(oname)", "user.picture(opicture)", "clients.id(cid)", "clients.name(cname)", "clients.picture(cpicture)"], ["blogcomments.".$field => $id]);
} else {
$result = $jakdb->select("blogcomments", ["[>]user" => ["operatorid" => "id"], "[>]clients" => ["clientid" => "id"]], ["blogcomments.id", "blogcomments.commentid", "blogcomments.message", "blogcomments.votes", "blogcomments.approve", "blogcomments.time", "blogcomments.session", "user.id(oid)", "user.name(oname)", "user.picture(opicture)", "clients.id(cid)", "clients.name(cname)", "clients.picture(cpicture)"], ["AND" => ["OR" => ["blogcomments.session" => session_id(), "blogcomments.approve" => 1], "blogcomments.".$field => $id]]);
}
if (isset($result) && !empty($result)) foreach ($result as $row) {
if ($row['oid'] && $row['opicture'] && $row['opicture'] != "/standard.jpg") {
$row['avatar'] = BASE_URL.JAK_FILES_DIRECTORY.$row['opicture'];
} elseif ($row['cid'] && $row['cpicture'] && $row['cpicture'] != "/standard.jpg") {
$row['avatar'] = BASE_URL.JAK_FILES_DIRECTORY.'/'.$row['cpicture'];
} else {
$row['avatar'] = BASE_URL.JAK_FILES_DIRECTORY.'/standard.jpg';
}
$row['username'] = ($row['oname'] ? $row['oname'] : $row['cname']);
$row['created'] = JAK_base::jakTimesince($row['time'], $ptime, $pdate);
// Sanitize the message
$row["message"] = jak_secure_site($row['message']);
// There should be always a varname in categories and check if seo is valid
$row["parseurl1"] = JAK_rewrite::jakParseurl($var, 'del', $row['id']);
$row["parseurl2"] = JAK_rewrite::jakParseurl($var, 'report', $row['id']);
// collect each record into $jakdata
$jakdata[] = $row;
// Do we have nested comments
if ($nested) $getID = $row["id"];
}
// now we go nested because we have a reply
if ($nested && !empty($getID)) {
if ($admin) {
$resnes = $jakdb->select("blogcomments", ["[>]user" => ["operatorid" => "id"], "[>]clients" => ["clientid" => "id"]], ["blogcomments.id", "blogcomments.commentid", "blogcomments.message", "blogcomments.votes", "blogcomments.approve", "blogcomments.time", "blogcomments.session", "user.id(oid)", "user.name(oname)", "user.picture(opicture)", "clients.id(cid)", "clients.name(cname)", "clients.picture(cpicture)"], ["blogcomments.commentid" => [$getID]]);
} else {
$resnes = $jakdb->select("blogcomments", ["[>]user" => ["operatorid" => "id"], "[>]clients" => ["clientid" => "id"]], ["blogcomments.id", "blogcomments.commentid", "blogcomments.message", "blogcomments.votes", "blogcomments.approve", "blogcomments.time", "blogcomments.session", "user.id(oid)", "user.name(oname)", "user.picture(opicture)", "clients.id(cid)", "clients.name(cname)", "clients.picture(cpicture)"], ["AND" => ["OR" => ["blogcomments.session" => session_id(), "blogcomments.approve" => 1], "blogcomments.commentid" => [$getID]]]);
}
if (isset($resnes) && !empty($resnes)) foreach ($resnes as $nes) {
if ($nes['oid'] && $nes['opicture'] && $nes['opicture'] != "/standard.jpg") {
$nes['avatar'] = BASE_URL.JAK_FILES_DIRECTORY.$nes['opicture'];
} elseif ($row['cid'] && $nes['cpicture'] && $nes['cpicture'] != "/standard.jpg") {
$nes['avatar'] = BASE_URL.JAK_FILES_DIRECTORY.'/'.$nes['cpicture'];
} else {
$nes['avatar'] = BASE_URL.JAK_FILES_DIRECTORY.'/standard.jpg';
}
$nes['username'] = ($nes['oname'] ? $nes['oname'] : $nes['cname']);
$nes['created'] = JAK_base::jakTimesince($nes['time'], $ptime, $pdate, $timeago);
// Sanitize the message
$nes["message"] = jak_secure_site($nes['message']);
// There should be always a varname in categories and check if seo is valid
$nes["parseurl1"] = JAK_rewrite::jakParseurl($var, 'del', $nes['id']);
$nes["parseurl2"] = JAK_rewrite::jakParseurl($var, 'report', $nes['id']);
// collect each record into $jakdata
$jakdata[] = $nes;
}
}
$this->data = $jakdata;
}
public function get_comments()
{
// Setting up an alias, so we don't have to write $this->data every time:
$d = &$this->data;
return $d;
}
public function get_commentajax($lang) {
foreach($this->data as $d) {
if ($d['oid'] && $d['opicture'] && $d['opicture'] != '/standard.jpg') {
$avatar = '';
} elseif ($d['cid'] && $d['cpicture'] && $d['cpicture'] != '/standard.jpg') {
$avatar = '
';
} else {
$avatar = '
';
}
$approve = "";
if ($d['approve'] == 0) {
$approve = '