Mir ist grad erst aufgefallen als ich meine linkus banner reinstellen wollte das bei mir im adminbereich garkein linkus steht, kann also keine banner reinstellen. das installieren von linkus ist ohne fehler verlaufen weßhalb mir das auch erst jatzt aufgefallen ist. hab mich schon durchs forum gelesen habe aber keine lösung gefunden.
wenn ich so normal auf der hp auf linkus klicke wir es mir normal angezeigt nur halt ohne banner, da ich ja noch keine drin hab.
nochmal installieren geht nicht weil die tabellen schon vorhanden sind sagt mir das prog dann.
habt ihr einen tip wie dies begeben kann?
verwendetes linkus:externer Link
das kann ich auch nicht finden(steht in der readme):
In der /include/admin/admin.php -> admix_box">Content folgenden code einfügen: <li><a href="admin.php?linkus"><img src="include/images/icons/admin/linkus.png" alt="">Link us</a></li>
meine admin php:
<?php
# Copyright by: Manuel Staechele
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
defined ('admin') or die ( 'only admin access' );
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
# script version
$scriptVersion = 11;
$scriptUpdate = 'M';
# statistik wird bereinigt.
$mon = date('n');
$lastmon = $mon - 1;
$jahr = date('Y');
$lastjahr = $jahr;
if ( $lastmon <= 0 ) { $lastmon = 12; $lastjahr = $jahr - 1; }
db_query("DELETE FROM prefix_stats WHERE NOT ((mon = $mon OR mon = $lastmon) AND (yar = $jahr OR yar = $lastjahr))");
db_query("OPTIMIZE TABLE prefix_stats");
$um = $menu->get(1);
switch($um)
{
default :
{
?>
<table class="border" cellspacing="1" cellpadding="0" width="100%" border="0">
<tr>
<td class="Chead" height="20"> Info</td>
</tr>
<td>
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td class="Cnorm" align="center" width="20%">
<?php echo getCalendar($mon, $jahr, $url, $urlod, $data, $cellpadding=2);?>
</td>
<td class="Cnorm" align="center" valign="top" width="60%">Nächsten Geburtstage<hr style="height: 0px; border: dotted #444444 0px; border-top-width: 1px; " /><br>
<? include ('include/boxes/geburtstag.php');?>
</td>
<td class="Cnorm" align="center" width="20%">
<embed src="http://www.clocklink.com/clocks/0008-Orange.swf?TimeZone=WET" width="150" height="150" wmode="transparent" type="application/x-shockwave-flash">
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<table class="border" cellspacing="1" cellpadding="4" width="100%" border="0">
<tr>
<td class="Chead" colspan="4">Statistik</td>
</tr>
<tr>
<td class="Cnorm" width="25%"><font class="smalfont">Design</font></td>
<td class="Cnorm" width="25%" nowrap><font class="smalfont">
<? echo $allgAr['gfx']; ?>
</font></td>
<td class="Cnorm" width="25%"><font class="smalfont">Installierte Version</font></td>
<td class="Cnorm" width="25%"><font class="smalfont">
<?php echo ''.$scriptVersion.' Update: '.$scriptUpdate.''; ?>
</font></td>
</tr>
<tr>
<td class="Cnorm"><font class="smalfont">Datenbankgröße</font></td>
<td class="Cnorm"><font class="smalfont">
<?php
// gibt die groesse der Datenbank aus
$result = db_query("SHOW TABLE STATUS");
$dbsize = 0;
while($row = mysql_fetch_assoc($result)) {
$dbsize += $row['Data_length'];
}echo nicebytes($dbsize);
?>
</font></td>
<td class="Cnorm"><font class="smalfont">Downloads</font></td>
<td class="Cnorm"><font class="smalfont">
<?php
echo nicebytes(dirsize('include/downs/'));
?>
</font></td>
</tr>
<tr>
<td class="Cnorm"><font class="smalfont">Benutzer & Gäste online</font></td>
<td class="Cnorm"><font class="smalfont">
<?php echo '<b>'.ges_online().'</b> Benutzer und <b>'.ges_gast_online().'</b> Gäste';?>
<a class="smalfont" href="admin.php?admin-userOnline">» anzeigen</a></font></td>
<td class="Cnorm" nowrap><font class="smalfont">Web Status</font></td>
<td class="Cnorm"><font class="smalfont">
<?
if ($allgAr['wartung'] == 0){
echo 'Seite Öffentlich';
}else
echo '<b>Wartungs Modus</b> <img src="include/images/icons/wartung.png">';
?>
</a></font></td>
</tr>
<tr>
<td class="Cnorm"><font class="smalfont">nicht aktivierte Accounts</font></td>
<td class="Cnorm"><font class="smalfont">
<?
$gesuser = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 1"),0);
echo '<b>'.$gesuser.'</b>';
?>
<a class="smalfont" href="admin.php?puser">» anzeigen</a>
</font></td>
<td class="Cnorm"nowrap><font class="smalfont">nicht aktivierte Join Us</font></td>
<td class="Cnorm"><font class="smalfont">
<?
$joinus = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 4"),0);
echo '<b>'.$joinus.'</b>';
?>
<a class="smalfont" href="admin.php?groups-joinus">» anzeigen</a>
</font></td>
</tr>
</table>
<br>
<table class="border" cellspacing="1" cellpadding="4" width="100%" border="0">
<tr>
<td class="Chead" colspan="2">Die neusten Mitglieder</td>
<td class="Chead" colspan="2">Die letzten Artikel, News ...</td>
</tr>
<tr>
<td class="Cnorm" colspan="2" valign="top">
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<?
$abf = 'SELECT * FROM prefix_user ORDER BY regist DESC LIMIT 5';
$erg = db_query($abf);
while ($row = db_fetch_object($erg)) {
$regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') ) - $row->regist;
$regday = round($regsek / 86400);
$user = $row->name;
echo'<tr class="Cnorm"><td><a href="?user-1-'.$row->id.'"><b>'.$user.'</b></a></td><td> Registriert am "'.date('d.m.Y',$row->regist).'"</td></tr>';}
?>
</table>
</td>
<td class="Cnorm" colspan="2" valign="top">
<table border="0" cellspacing="0" cellpadding="2" width="100%">
<?
$abf = 'SELECT news_id,news_title FROM `prefix_news` ORDER BY news_time DESC LIMIT 5';
$erg = db_query($abf);
while ($row = db_fetch_object($erg) ) {
echo'<tr class="Cnorm"><td><a href="?news-edit-'.$row->news_id.'">'.$row->news_title.'</a></td></tr>';}
?>
</table>
</td>
</tr>
<tr>
<td class="Chead" colspan="4" align="right"><a class="Chead" href="admin.php?about">Systeminformationen</a></td>
</tr>
</table>
<?php
break;
}
case 'versionsKontrolle' :
{
// ICON Anzeige...
echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/version_check.png" /></td><td width="30"></td><td valign="bottom"><h1>Versionskontrolle</h1></td></tr></table>';
echo 'Scripte Version: '.$scriptVersion.'<br />Update Version: '.$scriptUpdate.'<br /><br />';
echo '<script language="JavaScript" type="text/javascript" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></script>';
#echo '<iframe width="100%" height="60" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></iframe>';
break;
}
#####################################
case 'besucherStatistik' :
{
function echo_admin_site_statistik ($title, $col, $smon, $ges, $orderQuery ) {
$sql = db_query("SELECT COUNT(*) AS wert, $col as schl FROM `prefix_stats` WHERE mon = ".$smon." GROUP BY schl ORDER BY ".$orderQuery);
$max = @db_result(db_query("SELECT COUNT(*) as wert, $col as schl FROM prefix_stats WHERE mon = ".$smon." GROUP BY schl ORDER BY wert DESC LIMIT 1"),0,0);
if ( empty($max) ) { $max = 1; }
if ( empty($ges) ) { $ges = 1; }
echo '<tr><th align="left" colspan="4">'.$title.'</th></tr>';
while ( $r = db_fetch_assoc($sql) ) {
$wert = ( empty($r['wert']) ? 1 : $r['wert'] );
$weite = ($wert / $max) * 200;
$prozent = ($wert * 100) / $ges;
$prozent = number_format(round($prozent,2), 2, ',', '');
$name = $r['schl'];
if ( strlen ( $name ) >= 50 ) {
$name = substr($name,0,50).'<b>...</b>';
}
echo '<tr class="norm"><td width="150" title="'.$r['schl'].'">'.$name.'</td><td width="250">';
echo '<hr width="'.$weite.'" align="left" /></td>';
echo '<td width="50" align="right">'.$prozent.'%</td>';
echo '<td width="50" align="right">'.$wert.'</td></tr>';
}
}
// ICON Anzeige...
echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>';
echo '<a href="admin.php?admin-besucherUebersicht">Übersicht</a> <b>|</b> <a href="?admin-besucherStatistik-'.$lastmon.'" title="'.$lastmon.'. '.$lastjahr.'">letzter Monat</a> <b>|</b> <a href="?admin-besucherStatistik-'.$mon.'" title="'.$mon.'. '.$jahr.'">dieser Monat</a>';
$smon = $menu->get(2);
if ( empty($smon) ) { $smon = $mon; }
$ges = db_result(db_query("SELECT COUNT(*) FROM prefix_stats WHERE mon = ".$smon),0,0);
echo '<br /><br /><b>Gesamt diesen Monat: '.$ges.'</b>';
echo '<table cellpadding="2" border="0" cellspacing="0">';
echo_admin_site_statistik ('Besucher nach Tagen', 'day', $smon, $ges, "schl DESC LIMIT 50" );
echo_admin_site_statistik ('Besucher nach Wochentagen', 'DAYNAME(FROM_UNIXTIME((wtag+3)*86400))', $smon, $ges, "wtag DESC LIMIT 50" );
echo_admin_site_statistik ('Besucher nach Uhrzeit', 'stunde', $smon, $ges, "schl ASC LIMIT 50");
echo_admin_site_statistik ('Besucher nach Browsern', 'browser', $smon, $ges, "schl DESC LIMIT 50" );
echo_admin_site_statistik ('Besucher nach Betriebssytemen', 'os', $smon, $ges, "schl DESC LIMIT 50" );
echo_admin_site_statistik ('Besucher nach Herkunft', 'ref', $smon, $ges, "wert DESC LIMIT 50" );
echo '</table>';
break;
}
case 'userOnline' :
{
?>
<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_online.png" /></td><td width="30"></td><td valign="bottom"><h1>Online Statistik</h1></td></tr></table>
<br>
<table cellpadding="0" cellspacing="0" border="0"><tr><td></td><td width="30"></td><td valign="bottom"><h2>Online</h2></td></tr></table>
<table border="0" cellpadding="2" cellspacing="1" class="border">
<tr class="Chead">
<th>Username</th>
<th>Letzte aktivitaet</th>
<th>IP-Adresse</th>
<th>Anbieter</th>
</tr>
<?php
echo user_admin_online_liste();
?>
</table>
<br><br>
<table cellpadding="0" cellspacing="0" border="0"><tr><td widht="48"></td><td width="30"></td><td valign="bottom"><h2>Last log Member List</h2></td></tr></table>
<table border="0" cellpadding="2" cellspacing="1" class="border">
<tr class="Chead">
<th>Letzte aktivitaet</th>
<th>Username</th>
</tr>
<?php
$abf = 'SELECT * FROM prefix_user where recht <= -3 ORDER BY llogin DESC';
$erg = db_query($abf);
while ($row = db_fetch_object($erg)) {
$datum = date('d.m.y-H:m:s',$row->llogin);
$user = $row->name;
echo'<tr class="Chead"><td>'.$datum.'</td><td> <a href="?user-1-'.$row->id.'">'.$user.'</a></td></tr>';}
?>
</table>
<?php
break;
}
case 'besucherUebersicht' :
{
function get_max_from_x ($q) {
$q = db_query($q);
$m = 0;
while($r = db_fetch_row($q)) {
if ($r[0] > $m) { $m = $r[0]; }
}
return ($m);
}
function echo_admin_site_uebersicht ($schl, $wert, $max, $ges) {
$wert = ( empty($wert) ? 1 : $wert );
$weite = ($wert / $max ) * 100;
$prozent = ($wert * 100) / $ges;
$prozent = number_format(round($prozent,2), 2, ',', '');
$name = $schl;
if ( strlen ( $name ) >= 50 ) {
$name = substr($name,0,50).'<b>...</b>';
}
echo '<tr class="norm"><td width="150" title="'.$schl.'">'.$name.'</td><td width="250">';
echo '<hr width="'.$weite.'" align="left" /></td>';
echo '<td width="50" align="right">'.$prozent.'%</td>';
echo '<td width="50" align="right">'.$wert.'</td></tr>';
}
// ICON Anzeige...
echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>';
echo '<a href="admin.php?admin-besucherUebersicht">Übersicht</a> <b>|</b> <a href="?admin-besucherStatistik-'.$lastmon.'" title="'.$lastmon.'. '.$lastjahr.'">letzter Monat</a> <b>|</b> <a href="?admin-besucherStatistik-'.$mon.'" title="'.$mon.'. '.$jahr.'">dieser Monat</a>';
echo '<br /><br /><table cellpadding="0" border="0" cellspacing="0" width="100%">';
echo '<tr><td valign="top" width="33%"><b>Nach Tagen (letzten 5 Monate):</b><br />';
echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
$max = db_result(db_query("SELECT MAX(`count`) FROM prefix_counter"),0);
$ges = db_result(db_query("SELECT SUM(`count`) FROM prefix_counter"),0);
$erg = db_query("SELECT `count` as sum, DATE_FORMAT(`date`, '%d.%m.%Y') as datum FROM prefix_counter ORDER BY `date` DESC");
while ($r = db_fetch_assoc($erg)) {
echo_admin_site_uebersicht ($r['datum'], $r['sum'], $max, $ges);
}
echo '</table>';
echo '</td><td valign="top" width="33%"><b>Nach Monaten:</b><br />';
echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
$max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY MONTH(`date`), YEAR(`date`)");
$erg = db_query("SELECT SUM(`count`) as sum, MONTH(`date`) as monat, YEAR(`date`) as jahr FROM prefix_counter GROUP BY monat, jahr ORDER BY jahr DESC, monat DESC");
while ($r = db_fetch_assoc($erg)) {
echo_admin_site_uebersicht ((strlen($r['monat'])==1?'0':'').$r['monat'].'.'.$r['jahr'], $r['sum'], $max, $ges);
}
echo '</table>';
echo '</td><td valign="top" width="33%"><b>Nach Jahren:</b><br />';
echo '<table cellpadding="0" border="0" cellspacing="0" width="90%">';
$max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY YEAR(`date`)");
$erg = db_query("SELECT SUM(`count`) as sum, YEAR(`date`) as jahr FROM prefix_counter GROUP BY jahr ORDER BY jahr DESC");
while ($r = db_fetch_assoc($erg)) {
echo_admin_site_uebersicht ($r['jahr'], $r['sum'], $max, $ges);
}
echo '</table>';
echo '</td></tr></table>';
break;
}
case 'siteStatistik' :
{
##########################################
function forum_statistic_show ($sql,$ges) {
$erg = db_query($sql);
echo '<table border="0" cellpadding="0" cellspacing="0">';
while ($r = db_fetch_row($erg)) {
# str_repeat('|',abs($row['regs'] / 2))
echo '<tr><td>'.$r[1].'</td><td>'.str_repeat('|',$r[0]).' '.$r[0].'</td></tr>';
}
echo '</table>';
}
// ICON Anzeige...
echo '<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_site.png" /></td><td width="30"></td><td valign="bottom"><h1>Seiten Statistik</h1></td></tr></table>';
echo '<table><tr><td valign="top">';
$heute = mktime(0,0,0,date('m'),date('d'),date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute),0,0);
echo 'Gesamt Posts heute: '.$anzheute.'<br /><hr>';
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User heute</b><br />';
forum_statistic_show($sql,$anzheute);
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen heute</b><br />';
forum_statistic_show($sql,$anzheute);
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren heute</b><br />';
forum_statistic_show($sql,$anzheute);
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute),0,0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User heute</b><br />';
forum_statistic_show($sql,$gsh);
echo '</td><td valign="top">';
$heute1 = mktime(0,0,0,date('m'),date('d')-1,date('Y'));
$anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute),0,0);
echo 'Gesamt Posts gestern: '.$anzheute.'<br /><hr>';
# aktivsten user
$sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<b>Aktivsten User gestern</b><br />';
forum_statistic_show($sql,$anzheute);
# aktivsten themen
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Themen gestern</b><br />';
forum_statistic_show($sql,$anzheute);
# aktivsten foren
$sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Aktivsten Foren gestern</b><br />';
forum_statistic_show($sql,$anzheute);
# neue user heute
$gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute),0,0);
$sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10";
echo '<hr><b>Neue User gestern</b><br />';
forum_statistic_show($sql,$gsh);
echo '</td></tr></table>';
echo '<h1>Es ist ganz erlich noch mehr geplant :P</h1>';
##########################################
break;
}
}
$design->footer();
?>
MFG
betroffene Homepage: externer Link
