Pool.remove_post(post_id, pool_id)
return false
}
Post.register_resp(<?php
echo to_json(Post::batch_api_data($posts));
?>
);
</script>
<?php
echo render_partial('post/hover');
?>
<div id="paginator">
<?php
paginator();
?>
<div style="display: none;" id="info">When delete mode is enabled, clicking on a thumbnail will remove the post from this pool.</div>
</div>
<?php
do_content_for("footer");
?>
<?php
if (CONFIG::pool_zips) {
?>
<?php
$zip_params = array();
?>
<?php
$has_jpeg = CONFIG::jpeg_enable && $pool->has_jpeg_zip($zip_params);
function filtraCat()
{
#BUSCAMOS LA SEDE ACTUAL
if (!isset($_SESSION)) {
session_start();
}
$id_sede = $_SESSION['id_sede'];
$bd = new bd();
$clasificado = new clasificados($_POST["id"]);
$palabra = $_POST["palabra"] != "" ? " and titulo like '%{$_POST["palabra"]}%'" : "";
if ($_POST["estado"] != "") {
$strEstado = " and usuarios_id in (select id from usuarios where estados_id={$_POST["estado"]})";
} else {
$strEstado = "";
}
if ($_POST["condicion"] != "") {
$strCondicion = " and condiciones_publicaciones_id={$_POST["condicion"]}";
} else {
$strCondicion = "";
}
$ruta = $clasificado->getAdressWithLinks($_POST["palabra"]);
/*?>
<div class="col-xs-12 col-sm-12 col-md-2 col-lg-2 resultados" > <!-- ocultar cuando no hay resultados -->
<div class="marL5 marT5 marB5 contenedor">
<div class="marL10">
<div id="izquierda">
<?php */
/********************INICIO DE LA BUSQUEDA DE CATEGORIAS********************/
$hijos = $clasificado->buscarHijos();
if (!$hijos) {
$hijos[0]['id'] = $clasificado->getID();
$hijos[0]['nombre'] = $clasificado->getNombre();
}
ob_start();
if ($hijos) {
?>
<h5 class="negro"><b>Categoria</b></h5>
<hr class="marR5">
<ul class="nav marR5 t11 marT10 marB20 ">
<?php
foreach ($hijos as $h => $valor) {
$criterio = "I" . $valor["id"] . "F";
$condicion = " and usuarios_id in (select id from usuarios where id_sede={$id_sede}) ";
$consulta = "select count(id) as totaC from publicaciones where id in\n\t\t\t\t\t\t(select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 and fecha_fin is null) {$strEstado} {$strCondicion}\n\t\t\t\t\t\tand clasificados_id in (select id from clasificados where ruta like '%{$criterio}%') {$condicion} {$palabra}";
$result = $bd->query($consulta);
$row = $result->fetch();
if ($row["totaC"] > 0) {
?>
<li class='marB10 t11'><div class='h-gris'><span ><a class='blue-vin filtrocat' href='#' data-id="<?php
echo $valor["id"];
?>
" data-cantidad="<?php
echo $row["totaC"];
?>
" ><?php
echo $valor["nombre"] . " ({$row["totaC"]})";
?>
</a></span></div></li>
<?php
}
}
?>
</ul>
<?php
}
$categorias = ob_get_clean();
ob_end_clean();
echo json_encode(array('categoria' => $categorias, 'paginacion' => paginator($_POST['cantidad']), 'ruta' => $ruta));
/******************FIN DE LA BUSQUEDA DE CATEGORIAS********************/
/******************INICIO DE LA BUSQUEDA DE UBICACION******************/
/*if($_POST["estado"]!=""){
if($_POST["estado"]<100){
$estados=$bd->doFullSelect("estados","id={$_POST["estado"]}");
$ruta.=" En {$estados[0]["nombre"]}";
}else{
$estados=$bd->doFullSelect("estados");
}
}else{
$estados=$bd->doFullSelect("estados");
}
$estado=$_POST["estado"]!=""?"data-estado={$_POST["estado"]}":"";
?>
<div id="ubicacion" <?php echo $estado;?>
<h5 class="negro" ><b>Ubicación</b></h5>
<hr class="marR5">
<ul class="nav marR5 t11 marT10 marB20 ">
<?php
foreach($estados as $e=>$valor):
$criterio="I" . $_POST["id"] . "F";
$condicion=" and clasificados_id in (select id from clasificados where ruta like '%$criterio%') and ";
$condicion.="id in (select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 and fecha_fin is null) $palabra $strCondicion";
$consulta="select count(id) as totaP from publicaciones where usuarios_id in (select id from usuarios where estados_id={$valor["id"]}) $condicion";
$result=$bd->query($consulta);
$row=$result->fetch();
if($row["totaP"]>0):
?>
<li class='marB10 t11'><div class='h-gris'><span ><a class='blue-vin filtroest' href='#' data-id="<?php echo $valor["id"];?>"><?php echo ($valor["nombre"]) . " ({$row["totaP"]})";?></a></span></div></li>
<!-- <li class='marB10 t11'><div class='h-gris'><span ><a class='blue-vin filtroest' href='#' data-id="<?php echo $valor["id"];?>"><?php echo ($valor["nombre"]) . " (0)";?></a></span></li>-->
<?php
endif;
endforeach;
?>
</ul>
</div>
<?php*/
/******************FIN DE LA BUSQUEDA DE UBICACION*********************/
/******************INICIO DE LA BUSQUEDA DE CONDICION******************/
/*
$criterio="I" . $_POST["id"] . "F";
$condicion=" and clasificados_id in (select id from clasificados where ruta like '%$criterio%') and ";
$condicion.="id in (select publicaciones_id from publicacionesxstatus where status_publicaciones_id=1 and fecha_fin is null) $palabra $strCondicion";
$condicion.=$strEstado;
$consulta="select
(select count(id) from publicaciones where condiciones_publicaciones_id=1 $condicion) as tota1,
(select count(id) from publicaciones where condiciones_publicaciones_id=2 $condicion) as tota2,
(select count(id) from publicaciones where condiciones_publicaciones_id=3 $condicion) as tota3";
$result=$bd->query($consulta);
$condiciones=$result->fetch();
$con="";
switch($_POST["condicion"]){
case 1:
$con="data-condicion={$_POST["condicion"]}";
$ruta .=" <span class='f-condicion'>Nuevo</span>";
break;
case 2:
$con="data-condicion={$_POST["condicion"]}";
$ruta .=" <span class='f-condicion'>Usado</span>";
break;
case 3:
$con="data-condicion={$_POST["condicion"]}";
$ruta .=" <span class='f-condicion'>Servicio</span>";
break;
}
$total=$condiciones["tota1"] + $condiciones["tota2"] + $condiciones["tota3"];
?>
<div id="condicion" data-ruta="<?php echo ($ruta);?>" <?php echo $con; ?> style="display:<?php if($total==0){ echo "none"; } else{ echo "block"; }?>">
<h5 class="negro" ><b>Condición</b></h5>
<hr class="marR5">
</div>
<ul class="nav marR5 marT10 marB20 t11">
<?php
if($condiciones["tota1"]>0):
?>
<li class='marB10 t11'><div class='h-gris'><div style='padding:2px; '><a class='grisO filtrocon' href='#' data-id='1'>
<span class='blue-vin'>Nuevo (<?php echo $condiciones["tota1"];?>)</a></div></div></li>
<?php
endif;
if($condiciones["tota2"]>0):
?>
<li class='marB10 t11'><div class='h-gris'><div style='padding:2px; '><a class='grisO filtrocon' href='#' data-id='2'>
<span class='blue-vin'>Usado (<?php echo $condiciones["tota2"];?>)</a></div></div></li>
<?php
endif;
if($condiciones["tota3"]>0):
?>
<li class='marB10 t11'><div class='h-gris'><div style='padding:2px; '><a class='grisO filtrocon' href='#' data-id='3'>
<span class='blue-vin'>Servicios (<?php echo $condiciones["tota3"];?>)</a></div></div></li>
<?php
endif;
?>
</ul>
/******************FIN DE LA BUSQUEDA DE CONDICION (NUEVO, USADO, SERVICIO)********************/
/* ?>
</div> <!--Cierre de Izquierda-->
</div>
</div>
</div>
<?php
$condicion=substr($condicion,5,strlen($condicion));
$consulta="select id from publicaciones where $condicion limit 25 OFFSET 0";
$result=$bd->query($consulta);
//$total=$result->rowCount();
$totalPaginas=ceil($total/25);
?>
<!-- Listado -->
<div class="col-xs-12 col-sm-12 col-md-10 col-lg-10 resultados" > <!-- ocultar si no hay resultados -->
<div class="mar5 contenedor row">
<div class="col-xs-12 col-sm-12 col-md-10 col-lg-10 text-left vin-blue ">
<!-- mostrar la busqueda o donde esta segun lo q selecciono y almaceno en la variable de busqueda 2 y contar seria la cantidad de resultados obtenidos segun la busqueda -->
<div class="marL20 t14"><p style="margin-top:15px;">
<span id="inicio" name="inicio" class="grisC"> 1</span> - <span id="final" name="final" class="grisC"><?php if($total>=25){ echo "25"; }else{ echo $total;}?> de </span> <span class="grisC">
<?php echo $total;?></span> <span class="marR5 grisC"> resultados</span>
<a href="index.php" style="color:#000" class="marL5">Inicio </a>
<i class="fa fa-caret-right negro marR5 marL5"></i>
<span id="ruta" name="ruta">
<?php echo ($ruta);?>
</span>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-2 col-lg-2 ">
<div class=" marR20" style="margin-top:10px;" id="orden">
<select id="filtro" class="form-control input-sm " style="width:auto;" >
<option value='id_desc' selected>Mas Recientes</option>
<option value='id_asc'>Menos Recientes</option>
<option value='monto_desc'>Mayor Precio</option>
<option value='monto_asc'>Menor Precio</option>
</select>
</div>
</div>
<div class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
<hr class="marL10 marR10">
<br>
</div>
<div id="ajaxContainer" border="3" > <!-- ESTE DIV SE UTILIZARA SI SE DECIDI APLICARLE AJAX, POR EL MOMENTO NO SE UTILIZA -->
<!--Usuario-->
<?php
$i=0;
foreach($result as $p=>$valor):
$i++;
$publi=new publicaciones($valor["id"]);
$usua=new usuario($publi->usuarios_id);
$miTitulo=$publi->titulo;
if($_POST["palabra"]!=""){
$miTitulo=str_ireplace($_POST["palabra"], "<span style='background:#ccc'><b>" . $_POST["palabra"] . "</b></span>", $miTitulo);
}
?>
<!--publicacion-->
<div class=' col-xs-12 col-sm-6 col-md-2 col-lg-2'>
<div class='marco-foto-conf point marL20 ' style='height:130px; width: 130px;' >
<div style='position:absolute; left:40px; top:10px; ' class='f-condicion'><?php echo $publi->getCondicion();?> </div>
<img src='<?php echo $publi->getFotoPrincipal();?>' class='img img-responsive center-block img-apdp imagen' style='width:100%;height:100%;'
data-id='<?php echo $publi->id;?>' data-tipo='P'>
</div>
</div>
<div class=' col-xs-12 col-sm-6 col-md-7 col-lg-7'><p class='t16 marL10 marT5'>
<span class=' t15'><a class='negro' href='detalle.php?id=<?php echo $publi->id;?>' class='grisO'><b> <?php echo ($miTitulo);?></b></a></span>
<br><span class=' vin-blue t14'><a href='perfil.php?id=<?php echo $usua->id;?>' class=''><b> <?php echo $usua->a_seudonimo;?></b></a></span>
<br><span class='t14 grisO '><?php echo ($usua->getNombre());?></span><br>
<span class='t12 grisO '><i class='glyphicon glyphicon-time t14 opacity'></i><?php echo $publi->getTiempoPublicacion();?></span><br>
<span class='t11 grisO'> <span> <i class='fa fa-eye negro opacity'></i></span><span class='marL5'><?php echo $publi->getVisitas();?> Visitas</span><i class='fa fa-heart negro marL5 opacity'>
</i><span class=' point h-under marL5'><?php echo $publi->getFavoritos();?> Me gusta</span><i class='fa fa-share-alt negro marL15 opacity hidden'></i> <span class=' point h-under marL5 hidden'> <?php echo $publi->getCompartidos(3);?> Veces compartido</span> </span></p>
</div>
<div class=' col-xs-12 col-sm-12 col-md-3 col-lg-3 text-right'>
<div class='marR20'><span class='red t20'><b> <?php echo $publi->getMonto();?></b></span >
<br><span class=' t12'> <?php echo $usua->getEstado();?> </span><br><span class='vin-blue t16'><a href='detalle.php?id=<?php echo $publi->id;?>' style='text-decoration:underline;'>Ver Mas</a></span >
</div>
</div>
<div class='col-xs-12 col-sm-12 col-md-12 col-lg-2'><br></div><div class='col-xs-12 col-sm-12 col-md-12 col-lg-10'><hr class='marR10'><br></div>
<?php
endforeach;
?>
</div>
<div id="paginacion" name="paginacion" class='col-xs-12 col-sm-12 col-md-12 col-lg-12 ' data-paginaactual='1' data-total="<?php echo $total;?>"><center><nav><ul class='pagination'>
<li id="anterior2" name="anterior2" class="hidden"><a href='#' aria-label='Previous' class='navegador' data-funcion='anterior2'><i class='fa fa-angle-double-left'></i> </a>
<li id="anterior1" name="anterior1" class="hidden"><a href='#' aria-label='Previous' class='navegador' data-funcion='anterior1'><i class='fa fa-angle-left'></i> </a>
<?php
$activo="active";
$oculto="";
for($i=1;$i<=$totalPaginas;$i++):
?>
<li class="<?php echo $activo; echo $oculto;?>"><a class="botonPagina" href='#' data-pagina="<?php echo $i;?>"><?php echo $i;?></a></li>
<?php
if($i==10)
$oculto=" hidden";
$activo="";
endfor;
?>
<?php
if($totalPaginas>1):
?>
<li id="siguiente1" name="siguiente1"><a href='#' class="navegador" aria-label='Next' data-funcion='siguiente1'><i class='fa fa-angle-right'></i> </a>
<?php
endif;
?>
<?php
if($totalPaginas>10):
?>
<li id="siguiente2" name="siguiente2"><a href='#' class="navegador" aria-label='Next' data-funcion='siguiente2'><i class='fa fa-angle-double-right'></i> </a>
<?php
endif;
?>
</li></ul>
</nav></center></div>
</div></div></div>
</div>
<?php */
}
<?php
include __DIR__ . '../function/function.php';
$y = mysqli_connect("localhost", "root", '', "news");
$get = $_GET['page'];
$v = (check($get) - 1) * 10;
view($v, $y);
paginator($y);
function ListR2($titulo, $sql, $conexion, $clase, $ord, $url, $enlaceCod, $panel, $id_tabla, $checks, $paginador)
{
$totReg = totReg($sql, $conexion);
//$paginador = '3,4';
if ($paginador != '') {
$sql = pag($sql, $paginador);
}
$cmp = array();
$consulta = mysql_query($sql, $conexion);
$resultado = $consulta or die(mysql_error());
$v = "<div id='" . $clase . "' style='width:100%;'>";
$v .= "<div class='" . $clase . "' style='width:98%;float:left;'>";
if ($titulo != "") {
$v = $v . "<div style='width:100%;float:left;'><h1>" . $titulo . "<h1></div>";
}
$v = $v . "<div style='float:left;width:100%;'>";
$v = $v . "<form name='" . $id_tabla . "' method='post' id='" . $id_tabla . "'>";
$v = $v . "<table id='" . $id_tabla . "-T' cellspacing='0' cellpadding='0' style='width:100%;'>";
$v = $v . "<tr>";
for ($i = 0; $i < mysql_num_fields($consulta); ++$i) {
$campo = mysql_field_name($consulta, $i);
if ($campo != "CodigoAjax" && $campo != 'UrlAjax') {
if ($checks != 'SinTitulo') {
$v = $v . "<th>" . $campo . "</th>";
}
}
$cmp[$i] = $campo;
}
if ($checks == 'checks') {
$v = $v . "<th> <input type='checkbox' name='checkAllSelected' value='all' onclick=\"checkAll('{$id_tabla}', this);\"></th>";
}
if ($checks == 'cerrarPrograma') {
$v = $v . "<th>Cerrar</th>";
}
if ($checks == 'editar') {
$v = $v . "<th>Acción</th>";
}
$v = $v . "</tr>";
$cont = 1;
while ($reg = mysql_fetch_array($resultado)) {
$cont++;
for ($i = 0; $i < mysql_num_fields($consulta); ++$i) {
$campo = mysql_field_name($consulta, $i);
if ($campo == "CodigoAjax") {
$codAjax = $reg[$cmp[$i]];
}
if ($campo == "UrlAjax") {
$UrlAjax = $reg[$cmp[$i]];
}
}
$codAjaxId = $codAjax;
if (!empty($UrlAjax)) {
$codAjax = $codAjax . '&' . $UrlAjax;
}
$url2 = $url . "&" . $enlaceCod . "=" . $codAjaxId;
if ($checks == 'Buscar') {
$v = $v . "<tr style='cursor:pointer' id='" . $codAjaxId . "' ondblclick=enviaRegBuscar('" . $codAjaxId . "','" . $panel . "'); >";
} else {
$v = $v . "<tr style='cursor:pointer' id='" . $codAjaxId . "' ondblclick=enviaReg('" . $codAjaxId . "','" . $url2 . "','" . $panel . "','" . $id_tabla . "'); >";
}
for ($j = 0; $j < mysql_num_fields($consulta); ++$j) {
$campo = mysql_field_name($consulta, $j);
if ($campo != "CodigoAjax" && $campo != 'UrlAjax') {
$v = $v . "<td>" . $reg[$cmp[$j]] . "</td>";
}
}
if ($checks == 'checks') {
$v = $v . "<td>";
$v = $v . "<input type='checkbox' name='ky[]' value='" . $codAjax . "'>";
$v = $v . "</td>";
}
if ($checks == 'cerrarPrograma') {
$ur = './_vistas/pc_analisis.php?';
$url3 = $ur . "cerrarPrograma=si&" . $enlaceCod . "=" . $codAjax;
$v = $v . "<td>";
$v = $v . "<span onclick=enviaVista('" . $url3 . "','" . $panel . "','')>cerrar</span>";
$v = $v . "</td>";
}
if ($checks == 'editar') {
$v = $v . "<td>";
$v = $v . "<span onclick=enviaVista('" . $url2 . "','" . $panel . "','')>editar</span>";
$v = $v . "</td>";
}
$v = $v . "</tr>";
}
$v = $v . "</table>";
$v = $v . "</form>";
$v = $v . "</div>";
$v = $v . "</div>";
if ($paginador != '') {
$v = $v . paginator($sql, $paginador, $totReg);
}
$v = $v . '</div>';
if (mysql_num_rows($resultado) == 0) {
$v = '<div class="MensajeB vacio" style="float:left;width:95%;">(!) No se encontró ningun registro...</div>';
}
return $v;
}
function comment($freeze_status)
{
echo '<h3>Comments</h3>';
global $categorySEF, $subcatSEF, $articleSEF, $_ID, $commentsPage;
if (isset($commentsPage)) {
$commentsPage = str_replace(l('comment_pages'), '', $commentsPage);
}
if (strpos($articleSEF, l('paginator')) === 0) {
$articleSEF = str_replace(l('paginator'), '', $articleSEF);
}
if (!isset($commentsPage) || !is_numeric($commentsPage) || $commentsPage < 1) {
$commentsPage = 1;
}
$comments_order = s('comments_order');
if (isset($_POST['comment'])) {
$comment = cleanWords(trim($_POST['text']));
$comment = strlen($comment) > 4 ? clean(cleanXSS($comment)) : null;
$name = trim($_POST['name']);
$name = strlen($name) > 1 ? clean(cleanXSS($name)) : null;
$url = trim($_POST['url']);
$url = strlen($url) > 8 && strpos($url, '?') === false ? clean(cleanXSS($url)) : null;
$post_article_id = is_numeric($_POST['id']) && $_POST['id'] > 0 ? $_POST['id'] : null;
$ip = strlen($_POST['ip']) < 16 ? clean(cleanXSS($_POST['ip'])) : null;
if (_ADMIN) {
$doublecheck = 1;
$ident = 1;
} else {
$contentCheck = retrieve('id', 'comments', 'comment', $comment);
$ident = !$contentCheck || time() - $_SESSION[_SITE . 'poster']['time'] > s('comment_repost_timer') || $_SESSION[_SITE . 'poster']['ip'] !== $ip ? 1 : 0;
$doublecheck = $_SESSION[_SITE . 'poster']['article'] === "{$comment}:|:{$post_article_id}" && time() - $_SESSION[_SITE . 'poster']['time'] < s('comment_repost_timer') ? 0 : 1;
}
if ($ip == $_SERVER['REMOTE_ADDR'] && $comment && $name && $post_article_id && checkMathCaptcha() && $doublecheck == 1 && $ident == 1) {
$url = preg_match('/((http)+(s)?:(\\/\\/)|(www\\.))([a-z0-9_\\-]+)/', $url) ? $url : '';
$url = substr($url, 0, 3) == 'www' ? 'http://' . $url : $url;
$time = date('Y-m-d H:i:s');
unset($_SESSION[_SITE . 'poster']);
$approved = s('approve_comments') != 'on' || _ADMIN ? 'True' : '';
$query = 'INSERT INTO ' . _PRE . 'comments' . '(articleid, name, url, comment, time, approved) VALUES' . "('{$post_article_id}', '{$name}', '{$url}', '{$comment}', '{$time}', '{$approved}')";
mysql_query($query);
$_SESSION[_SITE . 'poster']['article'] = "{$comment}:|:{$post_article_id}";
$_SESSION[_SITE . 'poster']['time'] = time();
// this is to set session for checking multiple postings.
$_SESSION[_SITE . 'poster']['ip'] = $ip;
$commentStatus = s('approve_comments') == 'on' && !_ADMIN ? l('comment_sent_approve') : l('comment_sent');
// eMAIL COMMENTS
if (s('mail_on_comments') == 'on' && !_ADMIN) {
if (s('approve_comments') == 'on') {
$status = l('approved_text');
$subject = l('subject_a');
} else {
$status = l('not_waiting_approved');
$subject = l('subject_b');
}
$to = s('website_email');
$send_array = array('to' => $to, 'name' => $name, 'comment' => $comment, 'ip' => $ip, 'url' => $url, 'subject' => $subject, 'status' => $status);
send_email($send_array);
}
// End of Mail
} else {
$commentStatus = l('comment_error');
$commentReason = l('ce_reasons');
$fail = true;
$_SESSION[_SITE . 'comment']['name'] = $name;
$_SESSION[_SITE . 'comment']['comment'] = br2nl($comment);
$_SESSION[_SITE . 'comment']['url'] = $url;
$_SESSION[_SITE . 'comment']['fail'] = $fail;
}
echo '<h2>' . $commentStatus . '</h2>';
if (!empty($commentReason)) {
echo '<p>' . $commentReason . '</p>';
}
$postArt = clean(cleanXSS($_POST['article']));
$postArtID = retrieve('category', 'articles', 'id', $post_article_id);
if ($postArtID == 0) {
$postCat = '';
} else {
$postCat = cat_rel($postArtID, 'seftitle') . '/';
}
if ($fail) {
$back_link = _SITE . $postCat . $postArt;
echo '<a href="' . $back_link . '/">' . l('back') . '</a>';
} else {
echo '<meta http-equiv="refresh" content="1; url=' . _SITE . $postCat . $postArt . '/">';
}
} else {
$commentCount = s('comment_limit');
$comment_limit = empty($commentCount) || $commentCount < 1 ? 100 : $commentCount;
if (isset($commentsPage)) {
$pageNum = $commentsPage;
}
$offset = ($pageNum - 1) * $comment_limit;
$totalrows = 'SELECT count(id) AS num FROM ' . _PRE . 'comments' . '
WHERE articleid = ' . $_ID . ' AND approved = \'True\';';
$rowsresult = mysql_query($totalrows);
$numrows = mysql_fetch_array($rowsresult);
$numrows = $numrows['num'];
/**** redundant/excessive
/* if ($numrows == 0) {
if ($freeze_status != 'freezed' && s('freeze_comments') != 'YES') {
echo '<p>'.l('no_comment').'</p>';
} else {
echo '<p>'.l('frozen_comments').'</p>';
}
} else {
/**** end redundant/excessive*****/
if ($numrows > 0) {
$query = 'SELECT
id,articleid,name,url,comment,time,approved
FROM ' . _PRE . 'comments' . '
WHERE articleid = ' . $_ID . '
AND approved = \'True\'
ORDER BY id ' . $comments_order . '
LIMIT ' . "{$offset}, {$comment_limit}";
$result = mysql_query($query) or die(l('dberror'));
$ordinal = 1;
$date_format = s('date_format');
$edit_link = ' <a href="' . _SITE . '?action=';
while ($r = mysql_fetch_array($result)) {
$date = date($date_format, strtotime($r['time']));
$commentNum = $offset + $ordinal;
$tag = explode(',', tags('comments'));
foreach ($tag as $tag) {
switch (true) {
case $tag == 'date':
echo '<a id="' . l('comment') . $commentNum . '"
name="' . l('comment') . $commentNum . '"></a>' . $date;
break;
case $tag == 'name':
$name = $r['name'];
echo !empty($r['url']) ? '<a href="' . $r['url'] . '" title="' . $r['url'] . '" rel="nofollow">
' . $name . '</a> ' : $name;
break;
case $tag == 'comment':
echo $r['comment'];
break;
case $tag == 'edit' && _ADMIN:
echo $edit_link . 'editcomment&commentid=' . $r['id'] . '"
title="' . l('edit') . ' ' . l('comment') . '">' . l('edit') . '</a> ';
echo $edit_link . 'process&task=deletecomment&commentid=' . $r['id'] . '"
title="' . l('delete') . ' ' . l('comment') . '" onclick="return pop()">' . l('delete') . '</a>';
break;
case $tag == 'edit':
break;
default:
echo $tag;
}
}
$ordinal++;
}
$maxPage = ceil($numrows / $comment_limit);
$back_to_page = ceil(($numrows + 1) / $comment_limit);
if ($maxPage > 1) {
paginator($pageNum, $maxPage, l('comment_pages'));
}
}
if ($freeze_status != 'freezed' && s('freeze_comments') != 'YES') {
/*added 24 jan 2009*/
if ($numrows == 0) {
echo '<p>' . l('no_comment') . '</p>';
}
// recall and set vars for reuse when botched post
if ($_SESSION[_SITE . 'comment']['fail'] == true) {
$name = $_SESSION[_SITE . 'comment']['name'];
$comment = $_SESSION[_SITE . 'comment']['comment'];
$url = $_SESSION[_SITE . 'comment']['url'];
unset($_SESSION[_SITE . 'comment']);
} else {
$url = $name = $comment = '';
}
// end var retrieval
$art_value = empty($articleSEF) ? $subcatSEF : $articleSEF;
echo '<div class="commentsbox"><h2>' . l('addcomment') . '</h2>' . "\r\n";
echo '<p>' . l('required') . '</p>' . "\r\n";
echo html_input('form', '', 'post', '', '', '', '', '', '', '', '', '', 'post', _SITE, '') . "\r\n";
echo html_input('text', 'name', 'name', $name, '* ' . l('name'), 'text', '', '', '', '', '', '', '', '', '') . "\r\n";
echo html_input('text', 'url', 'url', $url, l('url'), 'text', '', '', '', '', '', '', '', '', '') . "\r\n";
echo html_input('textarea', 'text', 'text', $comment, '* ' . l('comment'), '', '', '', '', '', '5', '5', '', '', '') . "\r\n";
echo mathCaptcha() . "\r\n";
echo '<p>';
echo html_input('hidden', 'category', 'category', $categorySEF, '', '', '', '', '', '', '', '', '', '', '') . "\r\n";
echo html_input('hidden', 'id', 'id', $_ID, '', '', '', '', '', '', '', '', '', '', '') . "\r\n";
echo html_input('hidden', 'article', 'article', $art_value, '', '', '', '', '', '', '', '', '', '', '') . "\r\n";
echo html_input('hidden', 'commentspage', 'commentspage', $back_to_page, '', '', '', '', '', '', '', '', '', '', '') . "\r\n";
echo html_input('hidden', 'ip', 'ip', $_SERVER['REMOTE_ADDR'], '', '', '', '', '', '', '', '', '', '', '') . "\r\n";
echo html_input('hidden', 'time', 'time', time(), '', '', '', '', '', '', '', '', '', '', '');
echo html_input('submit', 'comment', 'comment', l('submit'), '', 'button', '', '', '', '', '', '', '', '', '') . "\r\n";
echo '</p></form></div>';
} else {
echo '<p>' . l('frozen_comments') . '</p>';
}
}
}
echo urlencode($kill['target_ip']);
?>
"><?php
echo htmlspecialchars($kill['target_ip']);
?>
</a></td>
<?php
if (function_exists('geoip_country_name_by_name')) {
?>
<td><?php
echo empty($kill['ip_address']) ? '' : @geoip_country_name_by_name($kill['target_ip']);
?>
</td><?php
}
?>
<td><?php
echo $kill['gun'];
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
echo paginator($page, $total_pages);
break;
}
} catch (PDOException $e) {
echo $e;
}
