PDA

View Full Version : AdminCP Top 10 Statistic


Atakan KOC
04-01-2006, 10:00 PM
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'

https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=111973)

threat
04-02-2006, 01:25 PM
nice, thank you

soulface
04-02-2006, 01:53 PM
it would be nice if we (admins) can reply to this thread from admincp :P LOL.. nah! j/k ... nice hack.

/me installed!

bashy
04-02-2006, 04:10 PM
Nice 1 m8 thanks
All i need now is a admincp organiser to organise all the hacks i have? ;)
Actually i am being serious pmsl.....
Must have about 200 installed lol

Omranic
04-03-2006, 09:03 AM
thanks alot
it is nice

** Installed **

digitalltv
04-03-2006, 07:45 PM
my question is, how can see more than 10?

Nathan2006
04-03-2006, 08:03 PM
Thnk you Atakan KOC

Nice :)

Install

GoNz00
04-04-2006, 04:42 PM
nice, thankyou.

/installed

Stop
04-04-2006, 07:21 PM
<font color="Green">Installed !!!</font>

And works fine. tnx a lot.

Atakan KOC
04-05-2006, 07:45 PM
Turkey Langue Version

T?rk?e Versiyonu ;)

Atakan KOC
04-05-2006, 07:50 PM
my question is, how can see more than 10?
AdminCP ==> Plugin System ==> Plugin Manager ==>
"AdminCP Top Statistic 1" [Edit]

Find


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

Replace (XX) 10-50

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

Find


$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

$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


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

Replace (XX) 10-50


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

Mathiau
04-12-2006, 11:22 AM
Great hack works also perfectly on VBB 3.5.3 :)

digitalltv
04-12-2006, 11:31 AM
AdminCP ==> Plugin System ==> Plugin Manager ==>
"AdminCP Top Statistic 1" [Edit]

Find


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

Replace (XX) 10-50

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

Find


$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

$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


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

Replace (XX) 10-50


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

great work fine :banana: ;)

Atakan KOC
04-19-2006, 09:28 PM
nice

NR Fatal
04-21-2006, 01:16 AM
works like a charm!

abcmississauga
04-24-2006, 11:22 PM
Works great thanks

FLMom
04-24-2006, 11:35 PM
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
06-07-2006, 06:44 PM
nice, thank you

Wired1
06-09-2006, 09:35 PM
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 (http://www.vbulletin.com/docs/html/main/import_product)

ericgtr
06-09-2006, 09:36 PM
FLMom, right click on the .xml file and do a "Save As" and you can save it that way.

erhanerhan_5
07-27-2006, 04:02 AM
thanks, for hack
very nice :)

Dragon Company
01-03-2008, 09:05 AM
thanks :)