<?PHP

/* ====================
Seditio - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/leetlogin/leetlogin.php
Version=121+122+125
Updated=01:16 01.05.2009
Type=Plugin
Author=Aragorn-pc
Description=Geli?mi? Kullan?c? Paneli ( leetlogin )
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=leetlogin
Part=main
File=leetlogin
Hooks=index.tags
Tags=index.tpl:{PLUGIN_LEETLOGIN}
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]

==================== */

if (!defined('SED_CODE')) { sed_diefatal('Wrong URL.'); }

require("plugins/leetlogin/lang/leetlogin.".$usr['lang'].".lang.php");
//Sql i?lemleri ba?langici ///
if ($m=='share')
{
$totaldbposts = sed_sql_rowcount($db_forum_posts);
$totaldbtopics = sed_sql_rowcount($db_forum_topics);
$totaldbviews = sed_sql_query("SELECT SUM(fs_viewcount) FROM $db_forum_sections");
$totaldbviews = sed_sql_result($totaldbviews,0,"SUM(fs_viewcount)");
$sql = sed_sql_query("SELECT SUM(fs_topiccount_pruned) FROM $db_forum_sections");
$totaldbtopics += sed_sql_result($sql,0,"SUM(fs_topiccount_pruned)");
$sql = sed_sql_query("SELECT SUM(fs_postcount_pruned) FROM $db_forum_sections");
$totaldbposts += sed_sql_result($sql,0,"SUM(fs_postcount_pruned)");
$output = "Seditio - Website engine<br />Copyright Neocrome<br />";
$output .= "<a href=\"http://www.neocrome.net\">http://www.neocrome.net</a><br />";
$output .= "&nbsp;<br />[BEGIN_SED]<br />Title=".$cfg['maintitle']."<br />";
$output .= "Subtitle=".$cfg['subtitle']."<br />Version=".$cfg['version']."<br />";
$output .= "Pages=".sed_sql_rowcount($db_pages)."<br />Users=".sed_sql_rowcount($db_users)."<br />";
$output .= "Pms=".sed_stat_get('totalpms')."<br />Forum_views=".$totaldbviews."<br />";
$output .= "Forum_posts=".$totaldbposts."<br />Forum_topics=".$totaldbtopics."<br />[END_SED]<br />&nbsp;";
die($output);
}

$sql = sed_sql_query("SELECT COUNT(*) FROM $db_forum_posts WHERE fp_posterid='".$usr['id']."'");
$user_postscount = sed_sql_result($sql,0,"COUNT(*)");
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_forum_topics WHERE ft_firstposterid='".$usr['id']."'");
$user_topicscount = sed_sql_result($sql,0,"COUNT(*)");
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_com WHERE com_authorid='".$usr['id']."'");
$user_comments = sed_sql_result($sql,0,"COUNT(*)");
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_pages WHERE page_ownerid='".$usr['id']."'");
$user_pages = sed_sql_result($sql,0,"COUNT(*)");

///Sql i?lemleri Biti?i //

// Retrive avatar from user
$avatar = sed_sql_query("SELECT user_avatar FROM $db_users WHERE user_id='".$usr['id']."'");
$avatar = sed_sql_fetcharray($avatar);
$el_avatar = stripslashes($avatar["user_avatar"]);
// Count total new private messages from user
$npmessages = sed_sql_query("SELECT COUNT(*) FROM $db_pm WHERE pm_touserid='".$usr['id']."' AND pm_state=0");
$el_npmessages = sed_sql_result($npmessages,0,"COUNT(*)");
// Count total old private messages from user
$olmessages = sed_sql_query("SELECT COUNT(*) FROM $db_pm WHERE pm_touserid='".$usr['id']."' AND pm_state=1");
$el_olmessages = sed_sql_result($olmessages,0,"COUNT(*)");
// Count total archived private messages from user
$apmessages = sed_sql_query("SELECT COUNT(*) FROM $db_pm WHERE pm_touserid='".$usr['id']."' AND pm_state=2");
$el_apmessages = sed_sql_result($apmessages,0,"COUNT(*)");

///Sql i?lemleri Ba?langici
//
// COUNT = COMMENTS
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_com WHERE com_authorid='$suserid' AND com_isspecial='0'");
$ext_comments = sed_sql_result($sql,0,"COUNT(*)");
// COUNT = COMMENTS TOTAL
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_com WHERE com_isspecial='0'");
$ext_ctotal = sed_sql_result($sql,0,"COUNT(*)");
// COUNT = COMMENTS PERCENTAGE
$ext_copercentage = "".@floor(100*$ext_comments/$ext_ctotal)."%";
// COUNT = PAGES
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_pages WHERE page_ownerid='$suserid'");
$ext_pages = sed_sql_result($sql,0,"COUNT(*)");
// COUNT = PAGES
$ext_ppercentage = "".@floor(100*$ext_pages/$ext_ptotal)."%";
// COUNT = COMMENTS TOTAL
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_pages");
$ext_ptotal = sed_sql_result($sql,0,"COUNT(*)");
// COUNT = FORUM POSTS
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_forum_posts WHERE fp_posterid='$suserid'");
$ext_fposts = sed_sql_result($sql,0,"COUNT(*)");
// COUNT = FORUM POSTS TOTAL
$ext_fptotal = sed_sql_rowcount($db_forum_posts);
// COUNT = FORUM POSTS PERCENTAGE
$ext_fppercentage = "".@floor(100*$ext_fposts/$ext_fptotal)."%";
// SELECT = RECENT FORUM POSTS
$ext_rfpmax = ($ext=="posts") ? 10 : 4;
$ext_rfposts = sed_sql_query("SELECT p.fp_id, t.ft_title, t.ft_id, t.ft_updated, t.ft_lastposterid, t.ft_lastpostername FROM $db_forum_posts p, $db_forum_topics t WHERE fp_posterid='$suserid' AND p.fp_topicid=t.ft_id GROUP BY t.ft_id ORDER BY t.ft_updated DESC LIMIT $ext_rfpmax");
// COUNT = FORUM TOPICS
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_forum_topics WHERE ft_firstposterid='$suserid'");
$ext_ftopics = sed_sql_result($sql,0,"COUNT(*)");
// COUNT = FORUM TOPICS TOTAL
$ext_fttotal = sed_sql_rowcount($db_forum_topics);
// COUNT = FORUM TOPICS PERCENTAGE
$ext_ftpercentage = "".@floor(100*$ext_ftopics/$ext_fttotal)."%";

///Sql i?lemleri Biti?i
///
if($usr['id']>0)
{
if ($el_avatar == "")
{
$el_avatar = $cfg['plugin']['leetlogin']['avatar2'];
}
if ($usr['isadmin'])
{
$el_admin = "<img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" /><a href=\"admin.php\">".$L['ll_administration']."</a><br />";
}
else
{
$el_admin = "";
}
if ($cfg['plugin']['leetlogin']['pmsound'] > 0)
{
if ($el_npmessages != 1)
{
$pluralmessage = $L['ll_plural'];
}
else
{
$pluralmessage = "";
}
$cookiepm = sed_import('sedPmTracking-usr'.$usr['id'],'C','NUM');
if ($el_npmessages > 0)
{
if ($el_npmessages > $cookiepm)
{
if ($cfg['plugin']['leetlogin']['pmsound'] == 2 || $cfg['plugin']['leetlogin']['pmsound'] == 3)
{
$pmmessage .= "<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0\" style=\"width:1px;height:1px\"><param name=\"movie\" value=\"".$cfg['plugin']['leetlogin']['npmessages']."\"><param name=\"quality\" value=\"high\"><embed src=\"".$cfg['plugin']['leetlogin']['npmessages']."\" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" style=\"width:1px;height:1px\"></embed></object>";
}
if ($cfg['plugin']['leetlogin']['pmsound'] == 1 || $cfg['plugin']['leetlogin']['pmsound'] == 3)
{
$pmmessage .= "
<script language=\"javascript\" type=\"text/javascript\">
<!--
function shownewpm()
{
viewpmconfirm = confirm('".$L['ll_msg1']." ".$el_npmessages." ".$L['ll_msg2'].$pluralmessage.".\\n".$L['ll_msg3']."');
if(viewpmconfirm == true)
{
window.location = \"pm.php\";
}
}
setTimeout('shownewpm()',1250);
-->
</script>";
}
}
}
setcookie("sedPmTracking-usr".$usr['id'], "$el_npmessages", time()+30000000);
}
$leetlogin = "<table style=\"border-collapse:collapse;text-align:center;width:98%\">";
if ($cfg['plugin']['leetlogin']['welcome'] == true)
{
$leetlogin .= "<tr><td style=\"text-align:center;padding:3px;\" colspan=\"2\"><div><strong>".$L['ll_welcome']."</strong> <a href=\"users.php?m=details&amp;id=".$usr['id']."\">".$usr['name']."!</a><br /></div></td></tr>";
}
else
{
$leetlogin .= "";
}
if ($cfg['plugin']['leetlogin']['avatar'] == true)
{
$leetlogin .= "<tr>";
$leetlogin .= "<td style=\"text-align:center;\"><a href=\"users.php?m=profile&amp;a=avatarchoose&amp;".sed_xg()."#list\"><img src=\"".$el_avatar."\" alt=\"\" /></a></td>";
$leetlogin .= "<tr></center>";
$leetlogin .= "<td style=\"text-align:left;width:100%;padding:0px;\"><div style=\"text-align:left;\">".$el_admin."<img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" /><a href=\"pm.php\">".$L['ll_inbox']."</a> (<strong>".$el_npmessages."</strong>)/".$el_olmessages."/".$el_apmessages."".$pmmessage."<br /><img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" /><a href=\"users.php?m=profile\">".$L['ll_profile']."</a><br /><img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" /><a href=\"page.php?m=add&c=files\">".$L['ll_dokumanekle']."</a><img src='plugins/leetlogin/yeni.gif'><br /><img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" /><a href=\"page.php?m=add&c=articles\">".$L['ll_dosyaekle']."</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src='plugins/leetlogin/yeni.gif'><br /><img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" /><a href=\"page.php?m=add&c=news\">".$L['ll_haberekle']."</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src='plugins/leetlogin/yeni.gif'><br /><img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" /><a href=\"users.php?m=logout&amp;".sed_xg()."\">".$L['ll_logout']."</a></td></center>";
$leetlogin .= "<tr><td>?statistikleriniz:<img src='plugins/leetlogin/yeni.gif'></td></tr><br />";
$leetlogin .= "<tr><td style=\"text-align:left;\"><img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" />".$L['plu_postsforums'].": <font color='red'>[".$user_postscount."]</font>: ".$ext_fppercentage." <font color='red'>".$ext_fptotal."</font></tr></td>";
$leetlogin .= "<tr><td style=\"text-align:left;\"><img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" />".$L['plu_newtopicsforums'].": <font color='red'>[".$user_topicscount."]</font>: ".$ext_ftpercentage." <font color='red'>".$ext_fttotal."</font></tr></td>";
$leetlogin .= "<tr><td style=\"text-align:left;\"><img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" />".$L['plu_sayfa'].": <font color='red'>[".$user_pages."]</font>: ".$ext_ppercentage." <font color='red'>".$ext_ptotal."</font></tr></td></div>";
$leetlogin .= "<tr><td style=\"text-align:left;\"><img src=\"".$cfg['plugin']['leetlogin']['1arrow']."\" />".$L['plu_comments'].": <font color='red'>[".$user_comments."]</font>: ".$ext_copercentage." <font color='red'>".$ext_ctotal."</font></tr></td></div>";

}
$leetlogin .= "</table>";
}
else
{
$leetlogin .= "<table style=\"border-collapse:collapse;text-align:center;width:98%\">";
if ($cfg['plugin']['leetlogin']['ynlin'] == true)
{
$leetlogin .= "<tr><td style=\"text-align:center\" colspan=\"2\"><div><strong>".$L['ll_ynlin']."</strong><br /></div></td></tr>";
}
else
{
$leetlogin .= "";
}
   $leetlogin .= "";

$leetlogin .= "<tr><td style=\"text-align:left;\" colspan=\"2\"><form name=\"login\" action=\"users.php?m=auth&amp;a=check\" method=\"post\"><div><b>".$L['ll_username']."<br /><input class=\"input\" type=\"text\" name=\"rusername\" size=\"20\" maxlength=\"32\"></input><br />";
$leetlogin .= "".$L['ll_password']."<br /><input class=\"input\" type=\"password\" name=\"rpassword\" size=\"20\" maxlength=\"32\"></input><br />";
$leetlogin .= "".$L['ll_rcookiettl']."<br />".$out['guest_cookiettl']."<br /></div>";
$leetlogin .= "<br /><div style=\"text-align:center;\"><input type=\"submit\" value=\"Giri?\"></input></div><div><input type="hidden" id="x" name="x" value="33A6EE" /></div></form>";
$leetlogin .= "<div style=\"text-align:center;\">[<a href=\"users.php?m=register\">".$L['ll_reg']."</a>]&nbsp;&nbsp;&nbsp;[<a href=\"eklenti.php?e=passrecover\">".$L['ll_lp']."</a>]</div></td></tr>";
$leetlogin .= "</table>";
}

$t-> assign(array(
"PLUGIN_LEETLOGIN" => $leetlogin
));
?>