|
|
Hallo sorry für Doppelpost , aber ich habe da noch ein Problem mit einem DB eintrag.Kann m ir dabei auch bitte jemand helfen?
http://www.validome.org/validate/?uri=http://www.wbb-support.de/statistik.php&lang=ge&extended=1&viewSource=1&doctype=doctypeAUTO&charset=charsetAUTO&userAgent=Mozilla/4.0%20%28compatible%3b%20MSIE%206.0%3b%20Windows%20NT%205.1%29
DB Eintrag INSERT INTO bb1_stats_table VALUES('1','1','Top Besuchte Themen','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=30% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" /><span class=\"smallfont\" /><a href=thread.php?threadid={num2}&sid={session} title=\"{num4}\" />{num5}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>\r\n\r\n\r\n\r\n\r\n','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','4','0','1','SELECT a.views AS views,a.boardid AS boardid,a.threadid AS threadid,a.topic AS threadname FROM bb{n}_threads AS a,bb{n}_boards AS b WHERE a.boardid = b.boardid ORDER BY a.views DESC','views','threadid','boardid','threadname','10','1'); INSERT INTO bb1_stats_table VALUES('2','1','Top Beantwortete Themen','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=30% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" /><span class=\"smallfont\" /><a href=thread.php?threadid={num2}&sid={session} title=\"{num4}\" />{num5}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>\r\n','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','5','0','1','SELECT a.replycount AS replies,a.boardid AS boardparentid,a.threadid AS threadid,a.topic AS threadname FROM bb{n}_threads AS a,bb{n}_boards AS b WHERE a.boardid = b.boardid ORDER BY a.replies DESC','replies','threadid','boardparentid','threadname','10','1'); INSERT INTO bb1_stats_table VALUES('3','1','Top Poster [Anzahl Beiträge]','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" /><a href=profile.php?userid={num3}&sid={session} title=\"{num6}\" />{num2}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>\r\n','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','8','0','1','SELECT * FROM bb{n}_users WHERE useronlinegroupid IN ({usergroup_poster_beitrag}) ORDER BY userposts DESC LIMIT {countlimit}','userposts','username','userid','regdate','10','1'); INSERT INTO bb1_stats_table VALUES('4','1','Top PN´s - Versender','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" /><a href=profile.php?userid={num3}&sid={session} title=\"{num6}\" />{num2}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','10','0','1','SELECT * FROM bb{n}_users WHERE useronlinegroupid IN ({usergroup_pn_out}) ORDER BY pn_out DESC LIMIT {countlimit}','pn_out','username','userid','regdate','10','1'); INSERT INTO bb1_stats_table VALUES('5','1','Top PN´s - Empfänger','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" /><a href=profile.php?userid={num3}&sid={session} title=\"{num6}\" />{num2}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','11','0','1','SELECT * FROM bb{n}_users WHERE useronlinegroupid IN ({usergroup_pn_in}) ORDER BY pn_in DESC LIMIT {countlimit}','pn_in','username','userid','regdate','10','1'); INSERT INTO bb1_stats_table VALUES('6','2','Top Onlinetimer','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" /><a href=profile.php?userid={num3}&sid={session} title=\"{num6}\" />{num2}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','14','0','1','SELECT * FROM bb{n}_users WHERE useronlinegroupid IN ({usergroup_onlinetimer}) ORDER BY onlinetime DESC LIMIT {countlimit}','onlinetime','username','userid','regdate','10','1'); INSERT INTO bb1_stats_table VALUES('7','1','Top Werbende User','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" /><a href=profile.php?userid={num3}&sid={session} title=\"{num6}\" />{num2}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','12','0','0','SELECT * FROM bb{n}_users WHERE useronlinegroupid IN ({usergroup_werbende}) ORDER BY gw_g DESC LIMIT {countlimit}','gw_g','username','userid','regdate','10','1'); INSERT INTO bb1_stats_table VALUES('8','1','Top Smilies','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" /><img src=\"{num2}\" alt=\"{num3} = {num4}\" /></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>\r\n\r\n','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','16','0','1','SELECT * FROM bb{n}_smilies ORDER BY smiliesint DESC LIMIT {countlimit}','smiliesint','smiliepath','smilietitle','smiliecode','10','1'); INSERT INTO bb1_stats_table VALUES('9','1','Top Browser','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=\"4%\" align=center><span class=\"smallfont\" /><img src=\"{imagefolder}/{num3}\" /></span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" />{num2}</td></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','17','0','1','SELECT * FROM bb{n}_stats_new WHERE artcount=\'1\' ORDER BY counter DESC','counter','title','icon','','9','0'); INSERT INTO bb1_stats_table VALUES('10','1','Top OS','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" /><img src=\"{imagefolder}/{num3}\" /></span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" />{num2}</td></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','18','0','1','SELECT * FROM bb{n}_stats_new WHERE artcount=\'0\' ORDER BY counter DESC','counter','title','icon','','16','0'); INSERT INTO bb1_stats_table VALUES('11','4','Registrierungen seit Start','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','registrierte.gif','5','1','1','SELECT COUNT(*) FROM bb{n}_users WHERE activation = 1','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('12','4','inaktive User','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','nicht_freigeschaltet.gif','15','1','1','SELECT COUNT(*) FROM bb{n}_users WHERE activation<>1','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('13','4','Zur Zeit abwesende Mitglieder','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','away.gif','14','1','1','SELECT COUNT(*) FROM bb{n}_users WHERE abwesend=1','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('14','4','gesperrte User','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','gesperrt.gif','16','1','1','SELECT COUNT(*) FROM bb{n}_users WHERE blocked=1','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('15','4','Moderatoren','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','mods.gif','19','1','1','SELECT COUNT(*) FROM bb{n}_users WHERE rankgroupid=3','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('16','4','Super-Moderatoren','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>',' ','supmods.gif','18','1','1','SELECT COUNT(*) FROM bb{n}_users WHERE rankgroupid=2','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('17','4','Administratoren','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','admins.gif','17','1','1','SELECT COUNT(*) FROM bb{n}_users WHERE rankgroupid=1','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('18','4','Weibliche Mitglieder','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','gender_female.gif','20','2','1','SELECT COUNT(*) FROM bb{n}_users WHERE gender=2','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('19','4','Männliche Mitglieder','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','gender_male.gif','19','2','1','SELECT COUNT(*) FROM bb{n}_users WHERE gender=1','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('20','4','Keine Angaben(Geschlecht)','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','gender_nodeclaration.gif','21','2','1','SELECT COUNT(*) FROM bb{n}_users WHERE gender=0','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('21','4','Kategorien','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','kategorien.gif','1','2','1','SELECT COUNT(*) FROM bb{n}_boards WHERE isboard = 0','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('22','4','Foren','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','foren.gif','2','2','1','SELECT COUNT(*) FROM bb{n}_boards WHERE isboard = 1','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('23','4','Benutzergruppen','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','usergruppen.gif','3','2','1','SELECT COUNT(*) FROM bb{n}_groups','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('24','4','Aktive Attachments','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','attachments.gif','5','2','1','SELECT COUNT(*) FROM bb{n}_attachments','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('25','4','Aktive Umfragen','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','poll.gif','6','2','1','SELECT COUNT(*) FROM bb{n}_polls','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('26','4','Benutzung der Suche','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','suche.gif','7','2','1','SELECT COUNT(*) FROM bb{n}_searchs','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('27','4','BB Codes','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','stats_no.gif','18','2','1','SELECT COUNT(*) FROM bb{n}_bbcodes','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('28','4','Beiträge insgesamt','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','articles.gif','9','2','1','SELECT COUNT(*) FROM bb{n}_posts','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('29','4','Themen insgesamt','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','threads.gif','11','2','1','SELECT COUNT(*) FROM bb{n}_threads','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('30','4','Wichtige Themen','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','threads.gif','13','2','1','SELECT COUNT(*) FROM bb{n}_threads WHERE important = 1','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('31','4','Geschlossene Themen','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','closed1.gif','14','2','1','SELECT COUNT(*) FROM bb{n}_threads WHERE closed = 1','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('32','4','Smiles','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','smile.gif','15','2','1','SELECT COUNT(*) FROM bb{n}_smilies','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('33','4','Avatare','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','avatare.gif','16','2','1','SELECT COUNT(*) FROM bb{n}_avatars','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('34','4','Styles','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','styles.gif','17','2','1','SELECT COUNT(*) FROM bb{n}_styles','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('35','4','Beiträge heute','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','articles.gif','8','2','1','SELECT COUNT(*) FROM bb{n}_posts WHERE posttime>=\'{suchdate}\'','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('36','4','Themen heute','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','threads.gif','10','2','1','SELECT Count(*) FROM bb{n}_threads WHERE starttime>=\'{suchdate}\'','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('37','4','Registrierungen heute','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','registrierte.gif','6','1','1','SELECT COUNT(*) FROM bb{n}_users WHERE regdate>=\'{suchdate}\'','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('38','4','Userränge','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','userraenge.gif','4','2','1','SELECT COUNT(*) FROM bb{n}_ranks','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('39','4','Unser neustes Mitglied','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td colspan=2 class=\"tablea\" /><span class=\"smallfont\" />{title}:<b><a href=\"profile.php?userid={num3}&sid={session}\" />{inhalt}</a></b></span></td>\r\n</tr>','','users.gif','1','1','1','SELECT username,userid FROM bb{n}_users ORDER BY userid DESC LIMIT 1','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('40','4','Zur Zeit aktive Gäste','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{guestcount}</b></span></td>\r\n</tr>','','member.gif','12','1','1',' ','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('41','4','Zur Zeit aktive Mitglieder','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{membercount}</b></span></td>\r\n</tr>','','member.gif','11','1','1',' ','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('42','4','Zur Zeit aktive unsichbare Mitglieder','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{invisiblecount}</b></span></td>\r\n</tr>','','geist.gif','13','1','1',' ','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('43','4','Zur Zeit aktive Benutzer','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{allusercount}</b></span></td>\r\n</tr>','','member.gif','10','1','1',' ','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('44','4','Start des Projektes','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{projekt}</b></span></td>\r\n</tr>','','projekt.gif','2','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('45','4','Bau des Boards seit dem','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{bau}</b></span></td>\r\n</tr>','','bauboard.gif','3','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('46','4','Start von {board}','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{start}</b></span></td>\r\n</tr>','','stats_no.gif','4','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('47','4','Besucherrecord','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{record}</b></span></td>\r\n</tr>','','stats_no.gif','7','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('48','4','Recorddatum','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{recorddatum}</b></span></td>\r\n</tr>','','stats_no.gif','8','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('49','4','Recordzeit','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{recordzeit}</b></span></td>\r\n</tr>','','stats_no.gif','9','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('50','4','Beiträge pro User','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{beitraege}</b></span></td>\r\n</tr>','','umfragen.gif','20','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('51','4','Themen pro User','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{themen}</b></span></td>\r\n</tr>','','umfragen.gif','21','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('52','4','Seitenaufrufe heute','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{seiteheute}</b></span></td>\r\n</tr>','','seiten.gif','23','2','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('53','4','Seitenaufrufe Gesamt','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{seitegesamt}</b></span></td>\r\n</tr>','','seiten.gif','22','2','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('54','4','Besucher heute','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{besucherheute}</b></span></td>\r\n</tr>','','usergruppen.gif','24','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('55','4','Besucher Gesamt','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{besuchergesamt}</b></span></td>\r\n</tr>','','usergruppen.gif','24','2','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('57','5','Populärste Avatars','<table cellpadding=4 cellspacing=1 border=0 width=50% class=\"tableinborder\" align=center>\r\n<tr class=\"tabletitle\" />\r\n<td align=center colspan={countlimit}><span class=\"normalfont\" /><b>{title}</b></span></td>\r\n</tr> \r\n<tr class=\"tableb\" />','<td align=center nowrap><img src=\"images/avatars/avatar-{num1}.{num2}\" height=\"{max_avatar_height}\" /><br><span class=\"smallfont\" />Benutz{benutzt} <b>{num3}</b> {mitglieder}</span></td>','','21','0','1','SELECT avatarid,avatarextension,benutzung FROM bb{n}_avatars WHERE userid=0 Order BY benutzung DESC limit {countlimit}','avatarid','avatarextension','benutzung','','10','0'); INSERT INTO bb1_stats_table VALUES('58','6','Allgemeine-Statistik','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n\r\n','','','19','0','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('59','7','Datenbank-Webspace-Server-PHP','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<table border=0 cellpadding=0 cellspacing=0 width=\"100%\" />\r\n<tr>\r\n<td class=\"tableinborder\" />\r\n<table cellpadding=4 cellspacing=1 border=0 class=\"tableinborder\" width=\"100%\" />\r\n<tr>\r\n<td class=\"tablea\" width=50%><span class=\"smallfont\" />{dwsp1}</span></td>\r\n<td class=\"tablea\" width=0%><span class=\"smallfont\" />MySQL {mysqlver} - {mysqlmem} - {mysqlrecord} {dwsp7}</span></td>\r\n</tr><tr>\r\n<td class=\"tableb\" /><span class=\"smallfont\" />{dwsp2}</span></td>\r\n<td class=\"tableb\" /><span class=\"smallfont\" />{gesamt}</span></td>\r\n</tr>\r\n<tr>\r\n<td class=\"tablea\" /><span class=\"smallfont\" />{dwsp3}</span></td>\r\n<td class=\"tablea\" /><span class=\"smallfont\" />{verbraucht}</span></td>\r\n</tr>\r\n<tr>\r\n<td class=\"tableb\" /><span class=\"smallfont\" />{dwsp4}</span></td>\r\n<td class=\"tableb\" /><span class=\"smallfont\" />{frei}</span></td>\r\n</tr>\r\n<tr>\r\n<td class=\"tablea\" /><span class=\"smallfont\" />{dwsp5}</span></td>\r\n<td class=\"tablea\" /><span class=\"smallfont\" /><b>{serverinfo}</b></span></td>\r\n</tr>\r\n<tr>\r\n<td class=\"tableb\" /><span class=\"smallfont\" />{dwsp6}</span></td>\r\n<td class=\"tableb\" /><span class=\"smallfont\" /><b>{phpversion}</b></span></td>\r\n</tr></table></table></table></table>','','','20','0','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('60','8','Tages-Statistik','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td><span class=\"smallfont\" /><b>{tages_stats1}</b></span></td>\r\n<td><span class=\"smallfont\" /><b>{tages_stats2}</b></span></td>\r\n<td><span class=\"smallfont\" /><b>{tages_stats3}</b></span></td>\r\n<td><span class=\"smallfont\" /><b>{tages_stats4}</b></span></td>\r\n<td><span class=\"smallfont\" /><b>{tages_stats5}</b></span></td>\r\n<td><span class=\"smallfont\" /><b>{tages_stats6}</b></span></td>\r\n<td><span class=\"smallfont\" /><b>{tages_stats7}</b></span></td>\r\n</tr>','<tr class=\"tablea\" />\r\n<td><span class=\"smallfont\" /><b>{time}</b></span></td>\r\n<td><span class=\"smallfont\" /><img src=\"{imagefolder}/vote_left1.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle1.gif\" height="9" alt="" width=\"{newthreads_percent_int}\" /><img src=\"{imagefolder}/vote_right1.gif\" height="9" alt="" /> {newthreads}</span></td>\r\n<td><span class=\"smallfont\" /><img src=\"{imagefolder}/vote_left2.gif\" height="9" alt="" alt=""/><img src=\"{imagefolder}/vote_middle2.gif\" height="9" alt="" width=\"{newposts_percent_int}\" /><img src=\"{imagefolder}/vote_right2.gif\" height="9" alt="" /> {newposts}</span></td>\r\n<td><span class=\"smallfont\" /><img src=\"{imagefolder}/vote_left3.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle3.gif\" height="9" alt="" width=\"{newpms_percent_int}\" /><img src=\"{imagefolder}/vote_right3.gif\" height="9" alt="" /> {newpms}</span></td>\r\n<td><span class=\"smallfont\" />{maxuserontime}<img src=\"{imagefolder}/vote_left4.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle4.gif\" height="9" alt="" width=\"{maxuseron_percent_int}\" /><img src=\"{imagefolder}/vote_right4.gif\" height="9" alt="" /> {maxuseron}</span></td>\r\n<td><span class=\"smallfont\" /><img src=\"{imagefolder}/vote_left5.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle5.gif\" height="9" alt="" width=\"{memberson_percent_int}\" /><img src=\"{imagefolder}/vote_right5.gif\" height="9" alt="" /> {memberson}</span></td>\r\n<td><span class=\"smallfont\" /><img src=\"{imagefolder}/vote_left6.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle6.gif\" height="9" alt="" width=\"{newregs_percent_int}\" /><img src=\"{imagefolder}/vote_right6.gif\" height="9" alt="" /> {newregs}</span></td>\r\n</tr>','<tr class=\"tablea\" />\r\n<td><span class=\"smallfont\" /><b>{time}</b></span></td>\r\n<td><span class=\"smallfont\" /><img src=\"{imagefolder}/vote_left1.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle1.gif\" height="9" alt="" width=\"{newthreads_percent_int}\" /><img src=\"{imagefolder}/vote_right1.gif\" height="9" alt="" /> {newthreads}</span></td>\r\n<td><span class=\"smallfont\" /><img src=\"{imagefolder}/vote_left2.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle2.gif\" height="9" alt="" width=\"{newposts_percent_int}\" /><img src=\"{imagefolder}/vote_right2.gif\" height="9" alt="" /> {newposts}</span></td>\r\n<td><span class=\"smallfont\" /><img src=\"{imagefolder}/vote_left3.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle3.gif\" height="9" alt="" width=\"{newpms_percent_int}\" /><img src=\"{imagefolder}/vote_right3.gif\" height="9" alt="" /> {newpms}</span></td>\r\n<td><span class=\"smallfont\" />{maxuserontime}<img src=\"{imagefolder}/vote_left4.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle4.gif\" height="9" alt="" width=\"{maxuseron_percent_int}\" /><img src=\"{imagefolder}/vote_right4.gif\" height="9" alt="" /> {maxuseron}</span></td>\r\n<td><span class=\"smallfont\" /><img src=\"{imagefolder}/vote_left5.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle5.gif\" height="9" alt="" width=\"{memberson_percent_int}\" /><img src=\"{imagefolder}/vote_right5.gif\" height="9" alt="" /> {memberson}</span></td>\r\n<td><span class=\"smallfont\" /><img src=\"{imagefolder}/vote_left6.gif\" height="9" alt="" /><img src=\"{imagefolder}/vote_middle6.gif\" height="9" alt="" width=\"{newregs_percent_int}\" /><img src=\"{imagefolder}/vote_right6.gif\" height="9" alt="" /> {newregs}</span></td>\r\n</tr>','1','0','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('61','4','PN´s pro User','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{pms}</b></span></td>\r\n</tr>','','umfragen.gif','22','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('62','4','Attachments pro User','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{attachment}</b></span></td>\r\n</tr>','','umfragen.gif','23','1','1','','','','','','0','0'); INSERT INTO bb1_stats_table VALUES('63','1','Top Attachments Downloads','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=30% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" /><span class=\"smallfont\" /><a href=thread.php?sid={session}&postid={num2}#post={num2} title=\"{num4}\" />{num5}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>\r\n\r\n\r\n','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','6','0','1','SELECT\r\na.*, b.boardid, p.postid, t.threadid\r\nFROM bb{n}_attachments a\r\nLEFT JOIN bb{n}_posts p ON(a.postid=p.postid)\r\nLEFT JOIN bb{n}_threads t ON(p.threadid=t.threadid)\r\nLEFT JOIN bb{n}_boards b ON(t.boardid=b.boardid)\r\nWHERE SUBSTRING(a.attachmentextension,1,1) IN ({attach_such}) ORDER BY a.counter DESC','counter','postid','boardid','attachmentname','10','1'); INSERT INTO bb1_stats_table VALUES('64','1','Top Poster [Anzahl Themen]','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" /><a href=profile.php?userid={num3}&sid={session} title=\"{num6}\" />{num2}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','7','0','1','SELECT * FROM bb{n}_users WHERE useronlinegroupid IN ({usergroup_poster_themen}) ORDER BY threadcount DESC LIMIT {countlimit}','threadcount','username','userid','regdate','10','1'); INSERT INTO bb1_stats_table VALUES('65','3','Top Poster [Anzahl Bytes]','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" /><a href=profile.php?userid={num3}&sid={session} title=\"{num6}\" />{num2}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','9','0','1','SELECT * FROM bb{n}_users WHERE useronlinegroupid IN ({usergroup_poster_bytes}) ORDER BY bytescounter DESC LIMIT {countlimit}','bytescounter','username','userid','regdate','10','1'); INSERT INTO bb1_stats_table VALUES('66','1','Top Seitenaufrufe','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" /><a href=profile.php?userid={num3}&sid={session} title=\"{num6} title=\"{num6}\"\" />{num2}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','15','0','1','SELECT * FROM bb{n}_users WHERE useronlinegroupid IN ({usergroup_seitenaufrufe}) ORDER BY seitencounter DESC LIMIT {countlimit}','seitencounter','username','userid','regdate','10','1'); INSERT INTO bb1_stats_table VALUES('67','1','Top Bewerteten User','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=15% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" align=\"center\" /><span class=\"smallfont\" /><a href=profile.php?userid={num3}&sid={session} title=\"{num6}\" />{num2}</a></span></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','13','0','1','SELECT * FROM bb{n}_users WHERE useronlinegroupid IN ({usergroup_bewertung}) ORDER BY ratingpoints DESC LIMIT {countlimit}','ratingpoints','username','userid','regdate','10','1'); INSERT INTO bb1_stats_table VALUES('68','1','Top Foren (Thema erstellung)','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=30% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" /><span class=\"smallfont\" /><a href=board.php?boardid={num2}&sid={session} title=\"{num4}\" />{num5}</a></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>\r\n','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','2','0','1','SELECT * FROM bb{n}_boards WHERE parentid<>0 ORDER BY threadcount DESC','threadcount','boardid','','title','10','1'); INSERT INTO bb1_stats_table VALUES('69','1','Top Foren (Post erstellung)','<table cellpadding="4" cellspacing="1" border="0" width="100%" class=\"tableinborder\" />\r\n<tr class=\"tabletitle\" />\r\n<td class=\"normalfont\" /> <b>{title}</b></td>\r\n</tr>\r\n<tr class=\"tableb\" />\r\n<td>\r\n<table border="0" cellpadding="0" cellspacing="0" width="100%" /><tr><td class=\"tableinborder\" />\r\n<table cellpadding=2 cellspacing=1 border=0 width=100%>\r\n<tr class=\"tabletitle\" />\r\n<td width=4% align=center class=\"smallfont\" /><b>{menu1}</b></td>\r\n<td width=30% align=center class=\"smallfont\" ><b>{menu2}</b></td>\r\n<td width=7% align=center class=\"smallfont\" /><b>{menu3}</b></td>\r\n<td width=7% align=center class=\"smallfont\" nowarp><b>{menu4}</b></td>\r\n<td></td>\r\n</tr>','<tr>\r\n<td class=\"tablea\" width=4% align=center><span class=\"smallfont\" />{nr}</span></td>\r\n<td class=\"tableb\" /><span class=\"smallfont\" /><a href=board.php?boardid={num2}&sid={session} title=\"{num4}\" />{num5}</a></td>\r\n<td class=\"tablea\" width=\"5%\" align=center><span class=\"smallfont\" />{num1}</span></td>\r\n<td class=\"tableb\" width=\"6%\" align=center><span class=\"smallfont\" />{percent} %</span></td>\r\n<td class=\"tablea\" /><table width=100%><tr><td>{grafik}</td></tr></table></td>\r\n</tr>\r\n','<img src=\"{imagefolder}/vote_left{nr}.gif\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_middle{nr}.gif\" width=\"{num5}%\" height="9" alt="" border="0" /><img src=\"{imagefolder}/vote_right{nr}.gif\" height="9" alt="" border="0" />','3','0','1','SELECT * FROM bb{n}_boards WHERE parentid<>0 ORDER BY postcount DESC','postcount','boardid','','title','10','1'); INSERT INTO bb1_stats_table VALUES('70','4','Ankündigungen','<tr>\r\n<td class=\"tableb\" width=\"5%\" align=center><img src=\"{imagefolder}/{gifimage}\" border="0" height="16" /></td>\r\n<td class=\"tablea\" width=\"80%\" ><span class=\"smallfont\" />{title}</span></td>\r\n<td class=\"tablea\" align=\"right\" /><span class=\"smallfont\" /><b>{inhalt}</b></span></td>\r\n</tr>','','threads.gif','12','2','1','SELECT COUNT(*) FROM bb{n}_threads WHERE important = 2','','','','','0','0');
|
Ich habe s schon versucht bkomme aber mit den <tr> und <td> und so nicht klar.
Big THX
|
|