Demo: http://swishzone.net
installier dir den webtemplate hack von logician und benutzte dann dieses template
Da sind noch downloadstats von mir drin....die must Du denn rausschmeißen...
W E B T E M P L A T E
WEBTEMPLATE NAME :
--------------------
portalstats
TEMPLATE:
------------ template cut start ------------------------------------------
templatequeryon
<table width="100%">
<tr>
<td bgcolor="#14649F" width="47%"><b><font color="#FFFFFF" size="1"><a href="http://217.160.93.124/vb/show.php?pg=downloadsswi20">Downloads
SWI</a>: $_countswi</font></b></td>
<td bgcolor="#14649F" width="53%"><b><font color="#FFFFFF" size="1"><a href="http://217.160.93.124/vb/memberlist.php?s=Array%5Bsessionhash%5D">User</a>:
$_countuser</font></b></td>
</tr>
<tr>
<td bgcolor="#044D91" width="47%"> <b><font color="#FFFFFF" size="1">Themen: $_countthread </font></b></td>
<td bgcolor="#044D91" width="53%"><b><font color="#FFFFFF" size="1">Unser neuestes Mitglied:</font></b></td>
</tr>
<tr>
<td bgcolor="#14649F" width="47%"><b><font color="#FFFFFF" size="1">Beiträge: $_countpost</font></b></td>
<td bgcolor="#044D91" width="53%" rowspan="2"><b><font color="#FFFFFF" size="1">$_newestmember</font></b></td>
</tr>
<tr>
<td bgcolor="#044D91" width="47%" height="2"><b><font color="#FFFFFF" size="1">heute: $_todaypostcount</font></b></td>
</tr>
</table>
------------ template cut end ------------------------------------------
WEB QUERIES IN THIS WEBTEMPLATE
--------------------
1.WEBQUERY NAME :
--------------------
_countswi
DESCRIPTION :
--------------------
NO RESULT TEXT:
--------------------
keine SWi's verfügbar
QUERY:
------------ query cut start ------------------------------------------
select count(id) as countswi from dlm_files where kategorie=0 or kategorie=2
------------ query cut end ------------------------------------------
TABLEROW:
------------ tablerow cut start ------------------------------------------
££countswi££
------------ tablerow cut end ------------------------------------------
2.WEBQUERY NAME :
--------------------
_countpost
DESCRIPTION :
--------------------
NO RESULT TEXT:
--------------------
keien Posts gefunden
QUERY:
------------ query cut start ------------------------------------------
select count(postid) as postcount from post
------------ query cut end ------------------------------------------
TABLEROW:
------------ tablerow cut start ------------------------------------------
££postcount££
------------ tablerow cut end ------------------------------------------
3.WEBQUERY NAME :
--------------------
_countuser
DESCRIPTION :
--------------------
NO RESULT TEXT:
--------------------
keine benutzer gefunden
QUERY:
------------ query cut start ------------------------------------------
select count(userid) as usercount from user
------------ query cut end ------------------------------------------
TABLEROW:
------------ tablerow cut start ------------------------------------------
££usercount££
------------ tablerow cut end ------------------------------------------
4.WEBQUERY NAME :
--------------------
_countthread
DESCRIPTION :
--------------------
NO RESULT TEXT:
--------------------
keien Beiträge gefunden
QUERY:
------------ query cut start ------------------------------------------
select count(threadid) as threadcount from thread
------------ query cut end ------------------------------------------
TABLEROW:
------------ tablerow cut start ------------------------------------------
££threadcount££
------------ tablerow cut end ------------------------------------------
5.WEBQUERY NAME :
--------------------
_todaypostcount
DESCRIPTION :
--------------------
NO RESULT TEXT:
--------------------
0
QUERY:
------------ query cut start ------------------------------------------
SELECT count(*) AS todaypostcount FROM post WHERE dateline>= unix_timestamp(curdate())
------------ query cut end ------------------------------------------
TABLEROW:
------------ tablerow cut start ------------------------------------------
££todaypostcount££
------------ tablerow cut end ------------------------------------------
6.WEBQUERY NAME :
--------------------
_newestmember
DESCRIPTION :
--------------------
NO RESULT TEXT:
--------------------
unregistriert
QUERY:
------------ query cut start ------------------------------------------
select username as lastmember from user order by joindate desc limit 1
------------ query cut end ------------------------------------------
TABLEROW:
------------ tablerow cut start ------------------------------------------
££lastmember££
------------ tablerow cut end ------------------------------------------
================================================================================
SHARE YOUR USEFUL WEBTEMPLATE AND WEBQUERY SAMPLES IN VBULLETIN.ORG HERE:
http://www.vbulletin.org/forum/showthread.php?s=&threadid=36578
You can attach the text file to your message to easily share them. Thank you!
================================================================================
~~~~ Powered by Logician WebTemplates & WebQueries Hack \=^)) ~~~~
DU kannst ja auhc das mal asuprobieren:
http://swishzone.net/vb/show.php?pg=wt_stats_graph