AdminCP Top 10 Statistic

AdminCP Top 10 Statistic


Go to your admin cp, then:
Plugin System -> Manage Products -> [Add/Import Product] -> Select 'product-7.xml' from your computer then press 'Import'

[Atakan KOC]

Originally Posted by digitalltv

my question is, how can see more than 10?

AdminCP ==> Plugin System ==> Plugin Manager ==>
"AdminCP Top Statistic 1" [Edit]

Find

PHP Code:

$kyeni = $db->query_read("select * FROM " . TABLE_PREFIX . "user order by joindate DESC LIMIT 0,10"); 


Replace (XX) 10-50

PHP Code:

$kyeni = $db->query_read("select * FROM " . TABLE_PREFIX . "user order by joindate DESC LIMIT 0,XX"); 


Find

PHP Code:

$kiyi = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, 10"); 


Replace (XX) 10-50

PHP Code:

$kiyi = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, XX"); 


Find

PHP Code:

$kkonu = $db->query_read("select * FROM " . TABLE_PREFIX . "thread order by lastpost DESC LIMIT 0,10"); 


Replace (XX) 10-50

PHP Code:

$kkonu = $db->query_read("select * FROM " . TABLE_PREFIX . "thread order by lastpost DESC LIMIT 0,XX"); 


[Mathiau]

Great hack works also perfectly on VBB 3.5.3

[digitalltv]

Originally Posted by Atakan KOC

AdminCP ==> Plugin System ==> Plugin Manager ==>
"AdminCP Top Statistic 1" [Edit]

Find

PHP Code:

$kyeni = $db->query_read("select * FROM " . TABLE_PREFIX . "user order by joindate DESC LIMIT 0,10"); 


Replace (XX) 10-50

PHP Code:

$kyeni = $db->query_read("select * FROM " . TABLE_PREFIX . "user order by joindate DESC LIMIT 0,XX"); 


Find

PHP Code:

$kiyi = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, 10"); 


Replace (XX) 10-50

PHP Code:

$kiyi = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, XX"); 


Find

PHP Code:

$kkonu = $db->query_read("select * FROM " . TABLE_PREFIX . "thread order by lastpost DESC LIMIT 0,10"); 


Replace (XX) 10-50

PHP Code:

$kkonu = $db->query_read("select * FROM " . TABLE_PREFIX . "thread order by lastpost DESC LIMIT 0,XX"); 


great work fine :banana:

[Atakan KOC]

nice

[NR Fatal]

works like a charm!

[abcmississauga]

Works great thanks

[FLMom]

I want to install this, but I can't... when I click on the xml file to install, this is what I get:

 <?xml version="1.0" encoding="ISO-8859-1" ?> 
- <product productid="7" active="1">
  <title>AdminCP Top 10 Statistic</title> 
  <description /> 
  <version>1.00</version> 
  <apm_releasedate>1143928800</apm_releasedate> 
  <apm_author>Atakan KOC</apm_author> 
  <apm_relatedurl /> 
  <apm_extrainfo /> 
  <apm_extraedit /> 
  <codes /> 
  <templates /> 
- <plugins>
- <plugin active="1">
  <title>AdminCP Top Statistic 1</title> 
  <hookname>admin_index_main1</hookname> 
- <phpcode>
- <![CDATA[ 
$kyeni = $db->query_read("select * FROM " . TABLE_PREFIX . "user order by joindate DESC LIMIT 0,10");

while ($kyeni2 = $db->fetch_array($kyeni))
{
$yeniler = $yeniler."<a href=\"user.php?do=edit&u=".$kyeni2[userid]."\">".$kyeni2[username]." </a>(".$kyeni2[posts].") <br />";
}


$kiyi = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, 10");

while ($kiyi2 = $db->fetch_array($kiyi))
{
$eniyiler = $eniyiler."<a href=\"user.php?do=edit&u=".$kiyi2[userid]."\">".$kiyi2[username]."  </a>(".$kiyi2[posts].") <br />";
}

$kkonu = $db->query_read("select * FROM " . TABLE_PREFIX . "thread order by lastpost DESC LIMIT 0,10");

while ($kkonu2 = $db->fetch_array($kkonu))
{
$ensonkonu = $ensonkonu."[<a href=\"../showthread.php?goto=newpost&t=".$kkonu2[threadid]."\" target=\"_blank\">*</a>] ".substr($kkonu2[title], 0, strrpos(substr($kkonu2[title], 0, 50), ' ')) . '...'."<br />";
}


print_table_start();
 print_table_header("AdminCP Top Statistic",3);

echo "<tr align=\"left\" valign=\"top\"> <td class=\"thead\">Newest Members</td><td class=\"thead\">Top Members</td><td class=\"thead\">Latest Replies</td></tr>";


echo "<tr><td class=\"alt1\">$yeniler</td><td class=\"alt2\">$eniyiler</td><td class=\"alt1\">$ensonkonu</td></tr>";

 print_table_footer(2, '', '', 0);

  ]]> 
  </phpcode>
  </plugin>
  </plugins>
  <phrases /> 
  <options /> 
  </product>

How can I get this to my computer so I can upload this to my site?

[T?RKMEN]

nice, thank you

[Wired1]

Originally Posted by FLMom

I want to install this, but I can't... when I click on the xml file to install, this is what I get:


How can I get this to my computer so I can upload this to my site?

PLEASE read the MANUAL!

Importing / Installing a Product

[ericgtr]

FLMom, right click on the .xml file and do a "Save As" and you can save it that way.