»Forumlar »SE ? Support »header quickstats hatası
  https://seditio.com.tr/eski1/forums.php?m=posts&q=1421
          Geri Dön      -      Sayfayı Yazdırmak için tıklayın
Author: mert er?st, Posted: 2011-05-09 22:12 GMT.
selam?n aleyk?m
arkada?lar localde tema d?zenliyorum ama bu eklentiyi kurunca forum kapan?yor
normalde index.tpl'de ?al???yor de?i?tirip headere kurdum eklenti b?t?n istatistikleri g?steriyor ama foruma t?klay?nca kategoriler kayboluyor anasayfadaki konular? a??ncada sadece konuya yorum att???m?z b?l?m g?r?n?yor
nas?l d?zeltebilirim
Author: Kaan, Posted: 2011-05-09 22:19 GMT.
Eklentiyi buraya ekle kodlar? d?zenlip vereyim..
Author: mert er?st, Posted: 2011-05-09 22:22 GMT.
quickstats.php
Kod:
<?PHP

/* ====================
Land Down Under - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/quickstats/quickstats.php
Version=
Updated=
Type=Plugin
Author=
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=quickstats
Part=main
File=quickstats
Hooks=header.tags
Tags=header.tpl:{PLUGIN_QUICKSTATS}
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]
==================== */

if ( !defined('SED_CODE') ) { die("Hacking attempt."); }

$evil_p = sed_import('plu_quickstats','P','HTM');
$evil_g = sed_import('plu_quickstats','G','HTM');

if (!$plu_quickstats || !empty($evil_g) || !empty($evil_p))
{
$plu_count_users = sed_sql_rowcount($db_users);
$plu_count_sections = sed_sql_rowcount($db_forum_sections);
$plu_count_tpages = sed_stat_get('totalpages');
$plu_count_topics = sed_sql_rowcount($db_forum_topics);
$plu_count_posts = sed_sql_rowcount($db_forum_posts);
$sqltmp = sed_sql_query("SELECT SUM(fs_topiccount_pruned) FROM $db_forum_sections", "Plugin/statistics");
$plu_count_topics += sed_sql_result($sqltmp, 0, "SUM(fs_topiccount_pruned)");
$sqltmp = sed_sql_query("SELECT SUM(fs_postcount_pruned) FROM $db_forum_sections", "Plugin/statistics");
$plu_count_posts += sed_sql_result($sqltmp, 0, "SUM(fs_postcount_pruned)");
$sqltmp = sed_sql_query("SELECT stat_name FROM $db_stats WHERE stat_name LIKE '20%' ORDER BY stat_name ASC LIMIT 1", "Plugin/statistics");
$rowtmp = sed_sql_fetcharray($sqltmp);
$plu_since = $rowtmp['stat_name'];
$sqltmp = sed_sql_query("SELECT user_name,user_id FROM $db_users WHERE user_maingrp!=2 ORDER by user_regdate DESC LIMIT 1");
$row=sed_sql_fetcharray($sqltmp);
$latestuser = sed_build_user($row["user_id"], stripslashes($row["user_name"]));

$banliuye= 0;
$sql = sed_sql_query("SELECT * FROM $db_users WHERE user_maingrp='3' ORDER by user_name ASC ");
while ($row = sed_sql_fetcharray($sql))
{
$banliuye++;
}
$onaysiz= 0;
$sql = sed_sql_query("SELECT * FROM $db_users WHERE user_maingrp='2' ORDER by user_name ASC ");
while ($row = sed_sql_fetcharray($sql))
{
$onaysiz++;
}

$iii = 0;
$sql = sed_sql_query("SELECT * FROM $db_pages WHERE page_file='0' AND page_state='0' AND page_cat NOT LIKE 'news' ORDER by page_cat, page_title ASC ");
while ($row = sed_sql_fetcharray($sql))
{
$page_id=$row["page_id"];
$page_cat=$row["page_cat"];
$page_title=stripslashes($row["page_title"]);
$page_desc=stripslashes($row["page_desc"]);
$page_author=stripslashes($row["page_author"]);
$page_date=$row["page_date"];
$page_url=$row["page_url"];
$page_size=$row["page_size"];
$page_filecount=$row["page_filecount"];

$totaldownloads = $page_filecount;
$iii++;
}

$timeback = $sys['now_offset'] - (7 * 86400); // 7 days
$timeback_stats = 15; // 15 days

$sql = sed_sql_query("SELECT COUNT(*) FROM $db_users WHERE user_regdate>'$timeback'");
$newusers = sed_sql_result($sql, 0, "COUNT(*)");

$sql = sed_sql_query("SELECT COUNT(*) FROM $db_pages WHERE page_date >'$timeback'");
$newpages = sed_sql_result($sql, 0, "COUNT(*)");

$sql = sed_sql_query("SELECT COUNT(*) FROM $db_forum_topics WHERE ft_creationdate>'$timeback'");
$newtopics = sed_sql_result($sql, 0, "COUNT(*)");

$sql = sed_sql_query("SELECT COUNT(*) FROM $db_forum_posts WHERE fp_updated>'$timeback'");
$newposts = sed_sql_result($sql, 0, "COUNT(*)");

$plu_quickstats = "<font color=yellow>></font>  <font color=red><b> Toplam ?yemiz =></b></font> <strong> ".$plu_count_users."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Banlanm?? ?yeler => <strong> ".$banliuye."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Onay Bekleyen ?yeler => <strong> ".$onaysiz."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Son ?yemiz => <strong>".$latestuser."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Forum Kategorisi => <strong>".$plu_count_sections."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Forum Konusu => <strong>".$plu_count_topics."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Forum Mesaj? => <strong>".$plu_count_posts."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Sayfalar => <strong>".$iii."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  A?ili? Tarihi => <strong>18 Ekim 2009</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam G?sterim => <strong>".$plu_count_tpages."</strong><br /><br />";
$plu_quickstats .= "<font color=yellow>></font><strong><font color=\"#FF0000\"><b>Son 7 G?nde</b></font></strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni ?yeler => <strong>".$newusers ."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni Sayfalar => <strong>".$newpages ."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni Forum Konular? => <strong>".$newtopics ."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni Forum Mesajlar? => <strong>".$newposts ."</strong><br />";

sed_cache_store('plu_quickstats', $plu_quickstats, 600);
}


$t-> assign(array(
"PLUGIN_QUICKSTATS" => $plu_quickstats,
));

?>


te?ekk?rler
Author: Kaan, Posted: 2011-05-09 22:47 GMT.
Yine ?al??maz ise atlad?g?m bir yer kalm??t?r kodlar? kar??la?t?r.

quickstats.php
Kod:
<?PHP

/* ====================
Land Down Under - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/quickstats/quickstats.php
Version=
Updated=
Type=Plugin
Author=
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=quickstats
Part=main
File=quickstats
Hooks=header.tags
Tags=header.tpl:{PLUGIN_QUICKSTATS}
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]
==================== */

if ( !defined('SED_CODE') ) { die("Hacking attempt."); }

$evil_p = sed_import('plu_quickstats','P','HTM');
$evil_g = sed_import('plu_quickstats','G','HTM');

if (!$plu_quickstats || !empty($evil_g) || !empty($evil_p))
{
$plu_count_users = sed_sql_rowcount($db_users);
$plu_count_sections = sed_sql_rowcount($db_forum_sections);
$plu_count_tpages = sed_stat_get('totalpages');
$plu_count_topics = sed_sql_rowcount($db_forum_topics);
$plu_count_posts = sed_sql_rowcount($db_forum_posts);
$sqltmp = sed_sql_query("SELECT SUM(fs_topiccount_pruned) FROM $db_forum_sections", "Plugin/statistics");
$plu_count_topics += sed_sql_result($sqltmp, 0, "SUM(fs_topiccount_pruned)");
$sqltmp = sed_sql_query("SELECT SUM(fs_postcount_pruned) FROM $db_forum_sections", "Plugin/statistics");
$plu_count_posts += sed_sql_result($sqltmp, 0, "SUM(fs_postcount_pruned)");
$sqltmp = sed_sql_query("SELECT stat_name FROM $db_stats WHERE stat_name LIKE '20%' ORDER BY stat_name ASC LIMIT 1", "Plugin/statistics");
$rowtmp = sed_sql_fetcharray($sqltmp);
$plu_since = $rowtmp['stat_name'];
$sqltmp = sed_sql_query("SELECT user_name,user_id FROM $db_users WHERE user_maingrp!=2 ORDER by user_regdate DESC LIMIT 1");
$row=sed_sql_fetcharray($sqltmp);
$latestuser = sed_build_user($row["user_id"], stripslashes($row["user_name"]));

$banliuye= 0;
$sqle = sed_sql_query("SELECT * FROM $db_users WHERE user_maingrp='3' ORDER by user_name ASC ");
while ($row = sed_sql_fetcharray($sqle))
{
$banliuye++;
}
$onaysiz= 0;
$sqle = sed_sql_query("SELECT * FROM $db_users WHERE user_maingrp='2' ORDER by user_name ASC ");
while ($row = sed_sql_fetcharray($sqle))
{
$onaysiz++;
}

$iii = 0;
$sqle = sed_sql_query("SELECT * FROM $db_pages WHERE page_file='0' AND page_state='0' AND page_cat NOT LIKE 'news' ORDER by page_cat, page_title ASC ");
while ($row = sed_sql_fetcharray($sqle))
{
$page_id=$row["page_id"];
$page_cat=$row["page_cat"];
$page_title=stripslashes($row["page_title"]);
$page_desc=stripslashes($row["page_desc"]);
$page_author=stripslashes($row["page_author"]);
$page_date=$row["page_date"];
$page_url=$row["page_url"];
$page_size=$row["page_size"];
$page_filecount=$row["page_filecount"];

$totaldownloads = $page_filecount;
$iii++;
}

$timeback = $sys['now_offset'] - (7 * 86400); // 7 days
$timeback_stats = 15; // 15 days

$sqle = sed_sql_query("SELECT COUNT(*) FROM $db_users WHERE user_regdate>'$timeback'");
$newusers = sed_sql_result($sqle, 0, "COUNT(*)");

$sqle = sed_sql_query("SELECT COUNT(*) FROM $db_pages WHERE page_date >'$timeback'");
$newpages = sed_sql_result($sqle, 0, "COUNT(*)");

$sqle = sed_sql_query("SELECT COUNT(*) FROM $db_forum_topics WHERE ft_creationdate>'$timeback'");
$newtopics = sed_sql_result($sqle, 0, "COUNT(*)");

$sqle = sed_sql_query("SELECT COUNT(*) FROM $db_forum_posts WHERE fp_updated>'$timeback'");
$newposts = sed_sql_result($sqle, 0, "COUNT(*)");

$plu_quickstats = "<font color=yellow>></font>  <font color=red><b> Toplam ?yemiz =></b></font> <strong> ".$plu_count_users."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Banlanm?? ?yeler => <strong> ".$banliuye."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Onay Bekleyen ?yeler => <strong> ".$onaysiz."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Son ?yemiz => <strong>".$latestuser."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Forum Kategorisi => <strong>".$plu_count_sections."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Forum Konusu => <strong>".$plu_count_topics."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Forum Mesaj? => <strong>".$plu_count_posts."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam Sayfalar => <strong>".$iii."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  A?ili? Tarihi => <strong>18 Ekim 2009</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Toplam G?sterim => <strong>".$plu_count_tpages."</strong><br /><br />";
$plu_quickstats .= "<font color=yellow>></font><strong><font color=\"#FF0000\"><b>Son 7 G?nde</b></font></strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni ?yeler => <strong>".$newusers ."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni Sayfalar => <strong>".$newpages ."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni Forum Konular? => <strong>".$newtopics ."</strong><br />";
$plu_quickstats .= "<font color=yellow>></font>  Yeni Forum Mesajlar? => <strong>".$newposts ."</strong><br />";

sed_cache_store('plu_quickstats', $plu_quickstats, 600);
}


$t-> assign(array(
"PLUGIN_QUICKSTATS" => $plu_quickstats,
));

?>
Author: mert er?st, Posted: 2011-05-10 12:53 GMT.
te?ekk?r ederim ?al??t? elinize sa?l?k

Powered by SeditioPrint version