800 Vues
1 Commentaires
$comments->query = "SELECT " . PREFIX . "_comments.id, post_id, " . PREFIX . "_comments.user_id, date, autor as gast_name, " . PREFIX . "_comments.email as gast_email, text, ip, is_register, " . PREFIX . "_comments.rating, " . PREFIX . "_comments.vote_num, " . PREFIX . "_comments.parent, name, " . USERPREFIX . "_users.email, news_num, comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, xfields FROM " . PREFIX . "_comments
LEFT JOIN " . USERPREFIX . "_users ON " . PREFIX . "_comments.user_id=" . USERPREFIX . "_users.user_id WHERE " . PREFIX . "_comments.post_id = '$news_id'" . $where_approve . " ORDER BY " . PREFIX . "_comments.id " . $comm_msort;
$comments->query = "SELECT " . PREFIX . "_comments.id, post_id, " . PREFIX . "_comments.user_id, date, autor as gast_name, " . PREFIX . "_comments.email as gast_email, text, ip, is_register, " . PREFIX . "_comments.rating, " . PREFIX . "_comments.vote_num, " . PREFIX . "_comments.parent, name, " . USERPREFIX . "_users.email, news_num, comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, forum_reputation, xfields FROM " . PREFIX . "_comments
LEFT JOIN " . USERPREFIX . "_users ON " . PREFIX . "_comments.user_id=" . USERPREFIX . "_users.user_id WHERE " . PREFIX . "_comments.post_id = '$news_id'" . $where_approve . " ORDER BY " . PREFIX . "_comments.id " . $comm_msort;
$comments->query = "SELECT cm.id, post_id, cm.user_id, cm.date, cm.autor as gast_name, cm.email as gast_email, text, ip, is_register, cm.rating, cm.vote_num, name, u.email, news_num, u.comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, u.xfields, p.title, p.date as newsdate, p.alt_name, p.category FROM
" . PREFIX . "_comments cm LEFT JOIN " . PREFIX . "_post p ON cm.post_id=p.id LEFT JOIN " . USERPREFIX . "_users u ON cm.user_id=u.user_id INNER JOIN (SELECT cm.id FROM " . PREFIX . "_comments cm " . $join . $where . " ORDER BY id desc LIMIT ".$fromcstart.", ".intval($config['comm_nummers'])." ) as sub ON sub.id = cm.id ORDER BY id desc";
$comments->query = "SELECT cm.id, post_id, cm.user_id, cm.date, cm.autor as gast_name, cm.email as gast_email, text, ip, is_register, cm.rating, cm.vote_num, name, u.email, news_num, u.comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, forum_reputation, u.xfields, p.title, p.date as newsdate, p.alt_name, p.category
FROM " . PREFIX . "_comments cm LEFT JOIN " . PREFIX . "_post p ON cm.post_id=p.id LEFT JOIN " . USERPREFIX . "_users u ON cm.user_id=u.user_id INNER JOIN (SELECT cm.id FROM " . PREFIX . "_comments cm " . $join . $where . " ORDER BY id desc LIMIT ".$fromcstart.", ".intval($config['comm_nummers'])." ) as sub ON sub.id = cm.id ORDER BY id desc";
$tpl->set( '{comment}', "<div>" . $row['text'] . "</div>" );
require_once ENGINE_DIR . '/data/forum_config.php';
require_once ENGINE_DIR . '/forum/sources/modules/dle_func.php';
if ($forum_config['reputation']) {
$rep_m = "<a><img src="{THEME}/forum/images/rep_mf.gif" alt="-" border="0"></a> ";
$rep_p = " <a><img src="{THEME}/forum/images/rep_p.gif" alt="+" border="0"></a>";
$reputation = $rep_m . link_rep($row['name'], $row['forum_reputation']) . $rep_p;
$tpl->set('{reputation}', "<span id="rep-".$row[">".$reputation."</span>");
}
else {
$tpl->set('{reputation}', "--");
}
unset ($reputation);
$tpl->set( '{lastdate}', langdate( "j F Y H:i", $row['lastdate'] ) );
require_once ENGINE_DIR . '/data/forum_config.php';
require_once ENGINE_DIR . '/forum/sources/modules/dle_func.php';
if ($forum_config['reputation']) {
$rep_m = "<a><img src="[THEME]/forum/images/rep_mf.gif" alt="-" border="0"></a> ";
$rep_p = " <a><img src="[THEME]/forum/images/rep_p.gif" alt="+" border="0"></a>";
$reputation = $rep_m . link_rep($row['name'], $row['forum_reputation']) . $rep_p;
$tpl->set('{reputation}', "<span>".$reputation."</span>");
} else {
$tpl->set('{reputation}', "--");
}
unset ($reputation);
<?php
if(!defined('DATALIFEENGINE')) die("Hacking attempt!");
//reputation
if (!function_exists("link_rep")) {
function link_rep($user, $title = false) {
global $config;
if (!$title) $title = "0";
if ($config['allow_alt_url'] == "yes") {
$forum_url = $config['http_home_url']."forum";
return("[url=/reputation/]{$title}[/url]");
}
else {
$forum_url = $config['http_home_url']."index.php?do=forum";
return("<a href="" target="_blank">{$title}</a>");
}
}
}
?>
Votre adresse électronique ne sera pas publiée. Les champs obligatoires sont marqués *
Les utilisateurs du Invités ne sont pas autorisés à ajouter des commentaires à cette publication.