(GPLv2)
or write to the Free Software Foundation, Inc., 51 Franklin Street,
Fifth Floor, Boston, MA02110-1301, USA.
********************************************************************************/
if (!defined("_LOAD_PAGE_")) {
die("
Error: This file cannot be opened directly!
");
}
//------
//whr: 2
//------
$op = (isset($_GET['op'])) ? inCode($_GET['op']) : "" ;
if (isset($_GET['id'])) { $id = intval($_GET['id']); $title = ""; } else {
$title = (isset($_GET['title'])) ? mem_urldecode(inCode($_GET['title'])) : "" ;
$id = "";
}
if (isset($_GET['gid'])) { $gid = intval($_GET['gid']); } else { $gid = 0; }
if (isset($_GET['ok'])) { $ok = inCode($_GET['ok']); } else { $ok = false; }
if (isset($_GET['rank'])) { $rank = inCode($_GET['rank']); } else { $rank = ""; }
if (isset($_GET['pg'])) { $pg = intval($_GET['pg']); } else { $pg = 1; }
$ofsppg = 60; //Items per page
$ofsbgn = ($pg*$ofsppg)-$ofsppg;
function guideList() {
global $dblink,$siteConfig;
openTable();
if ($result = $dblink->get_list("SELECT * FROM memht_argomenti ORDER BY nome")) {
foreach ($result as $row) {
$ida = intval($row['id']);
$inome = outCode($row['nome']);
if ($dblink->get_num("SELECT id FROM memht_guide WHERE argomento=$ida AND enabled=1")>0) {
echo "
\n";
$result = $dblink->get_list("SELECT *,DATE_FORMAT(data, '".$siteConfig['timestamp']."') as data FROM memht_guide WHERE argomento=$ida AND enabled=1 ORDER BY id DESC LIMIT 20");
foreach ($result as $row) {
$id = intval($row['id']);
$nome = outCode($row['nome']);
$autore = outCode($row['autore']);
$data = $row['data'];
$hits = intval($row['hits']);
echo "
\n";
if ($result = $dblink->get_list("SELECT *,DATE_FORMAT(data, '".$siteConfig['timestamp']."') as data FROM memht_guide WHERE argomento=$ida AND enabled=1 ORDER BY id DESC LIMIT $ofsbgn,$ofsppg")) {
foreach ($result as $row) {
$id = intval($row['id']);
$nome = outCode($row['nome']);
$autore = outCode($row['autore']);
$data = $row['data'];
$hits = intval($row['hits']);
echo "
\n";
}
//Pages
include_once("inc/class/paginationSystem.class.php");
$ps = new paginationSystem();
$ps->items = $ofsppg;
$ps->actpg = $pg;
$ps->query = "SELECT id FROM memht_guide WHERE argomento=$ida";
$ps->url = "index.php?page=guide&op=arg&id=$ida&title=".mem_urlencode($title)."&pg={{N}}";
$ps->show();
} else {
echo "
"._NOGUIDESINSEC_."
\n";
}
closeTable();
}
function viewGuide($id,$title,$pg=1) {
global $dblink,$siteConfig,$admin,$user,$visitorInfo,$tzNOW;
$idg = intval($id);
$ipg = $pg - 1;
if ($row = $dblink->get_row("SELECT g.*,(SELECT ROUND(SUM(r.vote)/COUNT(r.id)) AS irank FROM memht_ratings AS r WHERE whr=2 AND r.wid=g.id) AS rank,DATE_FORMAT(g.data, '".$siteConfig['timestamp']."') as data,g.language AS languageid,l.language AS languagetxt FROM memht_guide AS g LEFT JOIN memht_content_languages AS l ON g.language = l.id WHERE g.id=$idg OR g.nome='$title' AND g.enabled=1")) {
// Aqui vamos criar uma rotina para apagar os ips da tabela com mais de 60 minutos
$dblink->query("DELETE FROM memht_guide_apoio WHERE (data + INTERVAL 4 MINUTE) < $tzNOW");
// Aqui vamos verificar se já existe o ip na tabela
if($dblink->get_num("SELECT ip FROM memht_guide_apoio WHERE ip='".$visitorInfo['ip']."' AND id='$idg'")==0) {
// Como verificamos o ip não existe então vamos adicionar, assim como o id da guide e data e hora.
$dblink->query("INSERT INTO memht_guide_apoio VALUES ($idg,'".$visitorInfo['ip']."',$tzNOW)");
// Aqui como o homem não está tentando enganar, vamos lá contar o hit lol
$dblink->query("UPDATE memht_guide SET hits=hits+1 WHERE id=$id OR nome='$title'");
}
$id = intval($row['id']);
$argomento = intval($row['argomento']);
$nome = outCode($row['nome']);
$descrizione = outCode($row['descrizione']);
$testo = outCode($row['testo']);
$autore = outCode($row['autore']);
$data = $row['data'];
$hits = intval($row['hits']);
$usecomments = intval($row['usecomments']);
$rank = intval($row['rank']);
$languageid = intval($row['languageid']);
$languagetxt = outCode($row['languagetxt']);
if ($languageid==0) { $languagetxt = _GLOBAL_; }
if ($descrizione!="") { $testo = "
$inome