$db->query();
$catkunena = $db->loadResult();
$sql = "select `id` from #__kunena_topics WHERE `subject`='" . addslashes(trim($step->name)) . "' order by `id` asc limit 0,1";
$db->setQuery($sql);
$db->query();
$idmess = $db->loadResult();
for ($i = 0; $i < count($resultid); $i++) {
$sql = "select `message` from #__kunena_messages_text WHERE `mesid`=" . $resultid[$i]["id"];
$db->setQuery($sql);
$db->query();
$result = $db->loadResult();
$sql = "select `time` from #__kunena_messages WHERE `id`=" . $resultid[$i]["id"];
$db->setQuery($sql);
$db->query();
$datestart = $db->loadResult();
$timepast = $guruModelguruTask->get_time_difference($datestart, $int_current_datek);
if ($timepast["days"] == 0) {
if ($timepast["hours"] == 0) {
if ($timepast["minutes"] == 0) {
$difference = "a few seconds ago";
} else {
$difference = $timepast["minutes"] . " " . JText::_("GURU_REAL_MINUTES") . " " . JText::_("GURU_AGO");
}
} else {
$difference = $timepast["hours"] . " " . JText::_("GURU_REAL_HOURS") . ", " . $timepast["minutes"] . " " . JText::_("GURU_REAL_MINUTES") . " " . JText::_("GURU_AGO");
}
} else {
$difference = $timepast["days"] . " " . JText::_("GURU_REAL_DAYS") . ", " . ($difference = $timepast["hours"] . " " . JText::_("GURU_REAL_HOURS") . ", " . $timepast["minutes"] . " " . JText::_("GURU_REAL_MINUTES") . " " . JText::_("GURU_AGO"));
}
if ($deviceType != 'phone') {
$rows_cols = ' rows="2" cols="90"';
function deletecom()
{
$db = JFactory::getDBO();
$comid = JRequest::getVar("comid", "");
$uid = JRequest::getVar("uid", "");
$lid = JRequest::getVar("lessonid", "");
$user = JFactory::getUser();
$jnow = JFactory::getDate();
$date_currentk = $jnow->toSQL();
$int_current_datek = strtotime($date_currentk);
$sql = "SELECT name from #__guru_task WHERE id=" . intval($lid);
$db->setQuery($sql);
$db->query();
$name = $db->loadResult();
$sql = "DELETE from #__kunena_messages WHERE id =" . $comid . " and userid=" . $uid . " ";
$db->setQuery($sql);
$db->query();
$sql = "SELECT id FROM #__kunena_topics WHERE subject='" . $name . "'";
$db->setQuery($sql);
$db->query();
$idtopic = $db->loadResult();
$sql = "SELECT id from #__kunena_messages WHERE subject ='" . $name . "' order by id desc limit 0,1 ";
$db->setQuery($sql);
$db->query();
$idmessage = $db->loadResult();
$sql = "SELECT id from #__kunena_categories WHERE name ='" . $name . "'";
$db->setQuery($sql);
$db->query();
$idcat = $db->loadResult();
$sql = "UPDATE #__kunena_categories set last_topic_id ='" . intval($idtopic) . "' ,`last_post_id`=" . intval($idmessage) . ", `last_post_time`='" . $int_current_datek . "' where id =" . $idcat . " and name ='" . $name . "' ";
$db->setQuery($sql);
$db->query();
$sql = "UPDATE #__kunena_topics set first_post_id ='" . $idmessage . "' where id =" . $idtopic . " ";
$db->setQuery($sql);
$db->query();
$sql = "select id, name, userid from #__kunena_messages WHERE subject='" . $name . "' order by id desc";
$db->setQuery($sql);
$db->query();
$resultid = $db->loadAssocList();
$sql = "select id from #__kunena_categories WHERE name='" . $name . "' order by id desc limit 0,1";
$db->setQuery($sql);
$db->query();
$catkunena = $db->loadResult();
$sql = "select id from #__kunena_topics WHERE subject='" . $name . "' order by id asc limit 0,1";
$db->setQuery($sql);
$db->query();
$idmess = $db->loadResult();
for ($i = 0; $i < count($resultid); $i++) {
$sql = "select message from #__kunena_messages_text WHERE mesid=" . $resultid[$i]["id"];
$db->setQuery($sql);
$db->query();
$result = $db->loadResult();
$sql = "select time from #__kunena_messages WHERE id=" . $resultid[$i]["id"];
$db->setQuery($sql);
$db->query();
$datestart = $db->loadResult();
$timepast = guruModelguruTask::get_time_difference($datestart, $int_current_datek);
if ($timepast["days"] == 0) {
if ($timepast["hours"] == 0) {
if ($timepast["minutes"] == 0) {
$difference = "a few seconds ago";
} else {
$difference = $timepast["minutes"] . " " . JText::_("GURU_REAL_MINUTES") . " " . JText::_("GURU_AGO");
}
} else {
$difference = $timepast["hours"] . " " . JText::_("GURU_REAL_HOURS") . ", " . $timepast["minutes"] . " " . JText::_("GURU_REAL_MINUTES") . " " . JText::_("GURU_AGO");
}
} else {
$difference = $timepast["days"] . " " . JText::_("GURU_REAL_DAYS") . ", " . ($difference = $timepast["hours"] . " " . JText::_("GURU_REAL_HOURS") . ", " . $timepast["minutes"] . " " . JText::_("GURU_REAL_MINUTES") . " " . JText::_("GURU_AGO"));
}
if ($user->id == $resultid[$i]["userid"]) {
if ($allow_delete == 0) {
$concat = 1;
$buttonsd = '<span style="display:block; float:left;"><a href="#" id="delete' . $resultid[$i]["id"] . '" onclick="javascript:deletegurucomment(' . $lid . ', ' . $resultid[$i]["userid"] . ', ' . $resultid[$i]["id"] . '); return false;">' . JText::_("GURU_DELETE") . '</a></span>';
} else {
$concat = 0;
}
if ($allow_edit == 0) {
if ($concat == 0) {
$buttonsd = '<span style="float:right;display:block"><a href="#" id="edit' . $resultid[$i]["id"] . '" onclick="javascript:editgurucomment1(' . $resultid[$i]["id"] . '); return false;">' . JText::_("GURU_EDIT") . '</a></span>';
} else {
$buttonsd .= '<span style="float:right;display:block"><a href="#" id="edit' . $resultid[$i]["id"] . '" onclick="javascript:editgurucomment1(' . $resultid[$i]["id"] . '); return false;">' . JText::_("GURU_EDIT") . '</a></span>';
}
}
} else {
$buttonsd = " ";
}
echo '<div class="guru-header">
<span><img src="' . JUri::base() . 'components/com_guru/images/guru_comment.gif' . '"</span>
<span>' . JText::_("GURU_POSTED") . ':' . $difference . '</span>
<span style="float:right;"><a href=' . JUri::base() . 'index.php?option=com_kunena&view=topic&catid=' . $catkunena . '&id=' . $idmess . '&Itemid=0#' . $resultid[$i]["id"] . '>#' . $resultid[$i]["id"] . '</a></span>
<span>' . JText::_("GURU_COMMENTED_BY") . ' ' . $resultid[$i]["name"] . '</span>
</div>
<div class="guru-reply-body clearfix">
<div style="display:block;" class="guru-text" id="gurupostcomment' . $resultid[$i]["id"] . '">' . $result . '</div>
<textarea style="display:none;" style="width:100%" name="message1' . $resultid[$i]["id"] . '" id="message1' . $resultid[$i]["id"] . '" rows="2" cols="90"></textarea>
<input class="btn btn-success" style="display:none;" id="save' . $resultid[$i]["id"] . '" name="save" type="button" onclick="javascript:savegurucomment(' . $lid . ',' . $resultid[$i]["id"] . ');" value="' . JText::_('GURU_SAVE') . '" />
<div>' . $buttonsd . '</div>
</div>';
}
}
