--------------------------------------------------------------------------
ADMIN DATEIEN
--------------------------------------------------------------------------
/include/admin/admin.php
<?php
# Copyright by: Manuel
# 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 = 'I';
# 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 width="100%" border="0" cellspacing="0" cellpadding="5" class="rand">
<tr class="Chead">
<td><b>Willkommen bei ilchClan - Administration!</b></td>
</tr>
<tr>
<td class="Cnorm">
<table width="100%"><tr><td valign="top" width="100%">
<!--
Hallo, hier können Sie alle möglichen Einstellungen vornehmen.
<br /><br />
Wenn Sie Probleme haben sollten, oder irgendwie nicht weiter wissen, bitte
kommen Sie uns doch auf <a href="http://www.ilch.de" target="_blank">www.ilch.de</a>
besuchen, damit wir Ihnen helfen können.
<br /><br />
Auch wenn Sie Verbesserungswünsche oder eine geniale Idee haben,
freuen wir uns über jeden Vorschlag.
<br /><br />
und jetzt <b>viel Spass mit dem Script!</b>
-->
<!-- </td><td valign="top" width="60%"> -->
<br />
<h3 style="display:inline;">Ein Überblick über alle Inhalte</h3>
<script type="text/javascript">
function toggle_mimg()
{
class_name = document.getElementById('cpm').className;
if(class_name == "admix")
{
class_name = "admix_n";
link_text = "Symbol-Ansicht";
}
else
{
class_name = "admix";
link_text = "Listen-Ansicht";
}
document.getElementById('cpm').className = class_name;
document.getElementById('list_toggle').innerHTML = link_text;
}
</script>
<ul id="cpm" class="admix">
<li class="admix_box">Admin<br />
<ul>
<li><a href="admin.php?allg"><img src="include/images/icons/admin/konfiguration.png" alt="">Konfiguration</a></li>
<li><a href="admin.php?menu"><img src="include/images/icons/admin/navigation.png" alt="">Navigation</a></li>
<li><a href="admin.php?backup"><img src="include/images/icons/admin/backup.png" alt="">Backup</a></li>
<li><a href="admin.php?range"><img src="include/images/icons/admin/ranks.png" alt="">Ranks</a></li>
<li><a href="admin.php?smilies"><img src="include/images/icons/admin/smilies.png" alt="">Smiles</a></li>
<li><a href="admin.php?newsletter"><img src="include/images/icons/admin/newsletter.png" alt="">Newsletter</a></li>
<li><a href="admin.php?admin-versionsKontrolle"><img src="include/images/icons/admin/version_check.png" alt="">Versions Kontrolle</a></li>
<li><a href="admin.php?checkconf"><img src="include/images/icons/admin/version_check.png" alt="">Server Konfiguration</a></li>
<br class="admix_last"/>
</ul>
</li>
<li class="admix_box">Statistik<br />
<ul>
<li><a href="admin.php?admin-besucherStatistik"><img src="include/images/icons/admin/stats_visitor.png" alt="">Besucher</a></li>
<li><a href="admin.php?admin-siteStatistik"><img src="include/images/icons/admin/stats_site.png" alt="">Seite</a></li>
<li><a href="admin.php?admin-userOnline"><img src="include/images/icons/admin/stats_online.png" alt="">Online</a></li>
<br class="admix_last"/>
</ul>
</li>
<li class="admix_box">Clanbox<br />
<ul>
<li><a href="admin.php?wars-last"><img src="include/images/icons/admin/wars_last.png" alt="" />Lastwars</a></li>
<li><a href="admin.php?wars-next"><img src="include/images/icons/admin/wars_next.png" alt="" />Nextwars</a></li>
<li><a href="admin.php?awards"><img src="include/images/icons/admin/awards.png" alt="" />Awards</a></li>
<li><a href="admin.php?kasse"><img src="include/images/icons/admin/kasse.png" alt="" />Kasse</a></li>
<li><a href="admin.php?rules"><img src="include/images/icons/admin/rules.png" alt="" />Rules</a></li>
<li><a href="admin.php?history"><img src="include/images/icons/admin/history.png" alt="" />History</a></li>
<li><a href="admin.php?groups"><img src="include/images/icons/admin/teams.png" alt="" />Teams</a></li>
<li><a href="admin.php?trains"><img src="include/images/icons/admin/training_times.png" alt="" />Trainzeiten</a></li>
<br class="admix_last"/>
</ul>
</li>
<li class="admix_box">User<br />
<ul>
<li><a href="admin.php?user"><img src="include/images/icons/admin/user.png" alt="">Verwalten</a></li>
<li><a href="admin.php?grundrechte"><img src="include/images/icons/admin/user_rights.png" alt="">Grundrechte</a></li>
<li><a href="admin.php?profilefields"><img src="include/images/icons/admin/user_profile_fields.png" alt="">Profilefelder</a></li>
<li><a href="javascript: createNewUser();"><img src="include/images/icons/admin/user_add.png" alt="">neuen User</a></li>
<br class="admix_last"/>
</ul>
</li>
<li class="admix_box">Content<br />
<ul>
<li><a href="admin.php?news"><img src="include/images/icons/admin/news.png" alt="">News</a></li>
<li><a href="admin.php?news2"><img src="include/images/icons/admin/news.png" alt="">News2</a></li>
<li><a href="admin.php?news3"><img src="include/images/icons/admin/news.png" alt="">News3</a></li>
<li><a href="admin.php?forum"><img src="include/images/icons/admin/forum.png" alt="">Forum</a></li>
<li><a href="admin.php?archiv-downloads"><img src="include/images/icons/admin/downloads.png" alt="">Downloads</a></li>
<li><a href="admin.php?archiv-links"><img src="include/images/icons/admin/links.png" alt="">Links</a></li>
<li><a href="admin.php?gallery"><img src="include/images/icons/admin/gallery.png" alt="">Gallery</a></li>
<li><a href="admin.php?vote"><img src="include/images/icons/admin/vote.png" alt="">Umfrage</a></li>
<li><a href="admin.php?kalender"><img src="include/images/icons/admin/calendar.png" alt="">Kalender</a></li>
<li><a href="admin.php?contact"><img src="include/images/icons/admin/contact.png" alt="">Kontakt</a></li>
<li><a href="admin.php?impressum"><img src="include/images/icons/admin/imprint.png" alt="">Impressum</a></li>
<li><a href="admin.php?selfbp"><img src="include/images/icons/admin/self_page_box.png" alt="">Eigene Box/Page</a></li>
<li><a href="admin.php?gbook"><img src="include/images/icons/admin/guestbook.png" alt="">Gästebuch</a></li>
<br class="admix_last"/>
</ul>
</li>
<li class="admix_box">Boxen<br />
<ul>
<li><a href="admin.php?picofx"><img src="include/images/icons/admin/picofx.png" alt="">PicOfX</a></li>
<li><a href="admin.php?archiv-partners"><img src="include/images/icons/admin/partners.png" alt="">Partner</a></li>
<br class="admix_last"/>
</ul>
</li>
<li class="admix_box">Module
<?php
$modabf = db_query("SELECT * FROM `prefix_modules` WHERE ashow = 1");
if (db_num_rows($modabf) > 0) {
echo '<br /><ul>';
while ($modrow = db_fetch_object($modabf)) {
if (file_exists('include/images/icons/admin/'.$modrow->url.'.png')) {
$bild = 'include/images/icons/admin/'.$modrow->url.'.png';
} else {
$bild = 'include/images/icons/admin/na.png';
}
echo '<li><a href="admin.php?'.$modrow->url.'"><img src="'.$bild.'" alt="">'.$modrow->name.'</a></li>'."\n";
}
echo '<br class="admix_last"/></ul>';
}
?>
</li>
</ul>
</td></td></table>
</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>
<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>
<?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 ehrlich noch mehr geplant :P</h1>';
##########################################
break;
}
}
$design->footer();
?>
/include/admin/news2.php
<?php
# Copyright by: Manuel
# 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();
//-----------------------------------------------------------|
##
###
####
##### F u n k t i o n e n
function getKats ( $akt ) {
$katAR = array();
$kats = '';
$erg = db_query("SELECT DISTINCT news2_kat FROM `prefix_news2`");
while ($row = db_fetch_object($erg)) {
$katAr[] = $row->news2_kat;
}
$katAr[] = 'Allgemein';
$katAr = array_unique($katAr);
foreach($katAr as $a) {
if (trim($a) == trim($akt)) {
$sel = ' selected';
} else {
$sel = '';
}
$kats .= '<option'.$sel.'>'.$a.'</option>';
}
return ($kats);
}
##### F u n k t i o n
####
###
##
#
##
###
####
##### A k t i o n e n
if ( !empty($_REQUEST['um']) ) {
$um = $_REQUEST['um'];
if ( $um == 'insert' ) {
# insert
$text = escape($_POST['txt'], 'textarea');
if ( $_POST['katLis'] == 'neu' ) {
$_POST['katLis'] = $_POST['kat'];
}
db_query("INSERT INTO `prefix_news2` (news2_title,user_id,news2_time,news2_recht,news2_kat,news2_text)
VALUES ('".$_POST['titel']."',".$_SESSION['authid'].",NOW(),".$_POST['grecht'].",'".$_POST['katLis']."','".$text."')");
# insert
} elseif ( $um == 'change' ) {
# edit
$text = escape($_POST['txt'],'textarea');
if ( $_POST['katLis'] == 'neu' ) {
$_POST['katLis'] = $_POST['kat'];
}
db_query('UPDATE `prefix_news2` SET
news2_title = "'.$_POST['titel'].'",
user_id = "'.$_SESSION['authid'].'",
news2_recht = "'.$_POST['grecht'].'",
news2_kat = "'.$_POST['katLis'].'",
news2_text = "'.$text.'" WHERE news2_id = "'.$_POST['news2ID'].'" LIMIT 1');
$edit = $_POST['news2ID'];
}
}
# edit
# del
if ( $menu->get(1) == 'del' ) {
db_query('DELETE FROM `prefix_news2` WHERE news2_id = "'.$menu->get(2).'" LIMIT 1');
}
#del
##### A k t i o n e n
####
###
##
#
##
###
####
##### h t m l E i n g a b e n
if ( empty ($doNoIn) ) {
$limit = 20; // Limit
$page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
$MPL = db_make_sites ($page , '' , $limit , "?news2" , 'news2' );
$anfang = ($page - 1) * $limit;
if ( $menu->get(1) != 'edit' ) {
$Fnews2ID = '';
$Faktion = 'insert';
$Fueber = '';
$Fstext = '';
$Ftxt = '';
$Fgrecht = '';
$FkatLis = '';
$Fsub = 'Eintragen';
} else {
$row = db_fetch_object(db_query("SELECT * FROM `prefix_news2` WHERE news2_id = ".$menu->get(2)));
$Fnews2ID = $row->news2_id;
$Faktion = 'change';
$Fueber = $row->news2_title;
$Ftxt = stripslashes($row->news2_text);
$Fgrecht = $row->news2_recht;
$FkatLis = $row->news2_kat;
$Fsub = 'Ändern';
}
$tpl = new tpl ( 'news2', 1);
$ar = array
(
'NEWS2ID' => $Fnews2ID,
'AKTION' => $Faktion,
'MPL' => $MPL,
'UEBER' => $Fueber,
'txt' => $Ftxt,
'SMILIS' => getsmilies(),
'grecht' => dbliste($Fgrecht,$tpl,'grecht',"SELECT id,name FROM prefix_grundrechte ORDER BY id DESC"),
'KATS' => getKats($FkatLis),
'FSUB' => $Fsub
);
$tpl->set_ar_out($ar,0);
# e d i t , d e l e t e
$abf = 'SELECT news2_id,news2_title
FROM `prefix_news2`
ORDER BY news2_time DESC
LIMIT '.$anfang.','.$limit;
$erg = db_query($abf);
$class = '';
while ($row = db_fetch_object($erg) ) {
$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite' );
$tpl->set_ar_out( array ( 'ID' => $row->news2_id, 'class' => $class, 'TITEL' => $row->news2_title ) , 1 );
}
# e d i t , d e l e t e
$tpl->set_ar_out( array ('MPL' => $MPL ) , 2 );
}
$design->footer();
?>
/include/admin/news3.php
<?php
# Copyright by: Manuel
# 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();
//-----------------------------------------------------------|
##
###
####
##### F u n k t i o n e n
function getKats ( $akt ) {
$katAR = array();
$kats = '';
$erg = db_query("SELECT DISTINCT news3_kat FROM `prefix_news3`");
while ($row = db_fetch_object($erg)) {
$katAr[] = $row->news3_kat;
}
$katAr[] = 'Allgemein';
$katAr = array_unique($katAr);
foreach($katAr as $a) {
if (trim($a) == trim($akt)) {
$sel = ' selected';
} else {
$sel = '';
}
$kats .= '<option'.$sel.'>'.$a.'</option>';
}
return ($kats);
}
##### F u n k t i o n
####
###
##
#
##
###
####
##### A k t i o n e n
if ( !empty($_REQUEST['um']) ) {
$um = $_REQUEST['um'];
if ( $um == 'insert' ) {
# insert
$text = escape($_POST['txt'], 'textarea');
if ( $_POST['katLis'] == 'neu' ) {
$_POST['katLis'] = $_POST['kat'];
}
db_query("INSERT INTO `prefix_news3` (news3_title,user_id,news3_time,news3_recht,news3_kat,news3_text)
VALUES ('".$_POST['titel']."',".$_SESSION['authid'].",NOW(),".$_POST['grecht'].",'".$_POST['katLis']."','".$text."')");
# insert
} elseif ( $um == 'change' ) {
# edit
$text = escape($_POST['txt'],'textarea');
if ( $_POST['katLis'] == 'neu' ) {
$_POST['katLis'] = $_POST['kat'];
}
db_query('UPDATE `prefix_news3` SET
news3_title = "'.$_POST['titel'].'",
user_id = "'.$_SESSION['authid'].'",
news3_recht = "'.$_POST['grecht'].'",
news3_kat = "'.$_POST['katLis'].'",
news3_text = "'.$text.'" WHERE news3_id = "'.$_POST['news3ID'].'" LIMIT 1');
$edit = $_POST['news3ID'];
}
}
# edit
# del
if ( $menu->get(1) == 'del' ) {
db_query('DELETE FROM `prefix_news3` WHERE news3_id = "'.$menu->get(2).'" LIMIT 1');
}
#del
##### A k t i o n e n
####
###
##
#
##
###
####
##### h t m l E i n g a b e n
if ( empty ($doNoIn) ) {
$limit = 20; // Limit
$page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
$MPL = db_make_sites ($page , '' , $limit , "?news3" , 'news3' );
$anfang = ($page - 1) * $limit;
if ( $menu->get(1) != 'edit' ) {
$Fnews3ID = '';
$Faktion = 'insert';
$Fueber = '';
$Fstext = '';
$Ftxt = '';
$Fgrecht = '';
$FkatLis = '';
$Fsub = 'Eintragen';
} else {
$row = db_fetch_object(db_query("SELECT * FROM `prefix_news3` WHERE news3_id = ".$menu->get(2)));
$Fnews3ID = $row->news3_id;
$Faktion = 'change';
$Fueber = $row->news3_title;
$Ftxt = stripslashes($row->news3_text);
$Fgrecht = $row->news3_recht;
$FkatLis = $row->news3_kat;
$Fsub = 'Ändern';
}
$tpl = new tpl ( 'news3', 1);
$ar = array
(
'NEWS3ID' => $Fnews3ID,
'AKTION' => $Faktion,
'MPL' => $MPL,
'UEBER' => $Fueber,
'txt' => $Ftxt,
'SMILIS' => getsmilies(),
'grecht' => dbliste($Fgrecht,$tpl,'grecht',"SELECT id,name FROM prefix_grundrechte ORDER BY id DESC"),
'KATS' => getKats($FkatLis),
'FSUB' => $Fsub
);
$tpl->set_ar_out($ar,0);
# e d i t , d e l e t e
$abf = 'SELECT news3_id,news3_title
FROM `prefix_news3`
ORDER BY news3_time DESC
LIMIT '.$anfang.','.$limit;
$erg = db_query($abf);
$class = '';
while ($row = db_fetch_object($erg) ) {
$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite' );
$tpl->set_ar_out( array ( 'ID' => $row->news3_id, 'class' => $class, 'TITEL' => $row->news3_title ) , 1 );
}
# e d i t , d e l e t e
$tpl->set_ar_out( array ('MPL' => $MPL ) , 2 );
}
$design->footer();
?>
--------------------------------------------------------------------
TEMPLATES
--------------------------------------------------------------------
/include/admin/templates/news2.htm
<script language="JavaScript" type="text/javascript"><!--
function delcheck ( DELID ) {
var frage = confirm ( "Willst du diesen Eintrag wirklich l�schen?" );
if ( frage == true ) {
document.location.href="?news2-del-"+DELID;
}
}
function delKcheck ( DELID , NID) {
var frage = confirm ( "Willst du dieses Kommentar wirklich l�schen?" );
if ( frage == true ) {
document.location.href="?news2-sKoms-"+NID+"-Kdel-"+DELID+"#"+NID;
}
}
function sichtbar(){
if( document.form.katLis.value=="neu"){
document.form.kat.style.visibility="visible";
} else {
document.form.kat.style.visibility="hidden";
}
}
//--></script>
<script type='text/javascript' src='include/includes/js/bbcode.js'></script>
<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/news.png" /></td><td width="30"></td><td valign="bottom"><h1>News2</h1></td></tr></table>
<hr style="width: 400px; margin: 0px;" >
<br /><br />
<table border="0" cellspacing="0" cellpadding="0"><tr><td valign="top">
<form method="POST" name="form" action="?news2">
<input type="hidden" name="um" value="{AKTION}">
<input type="hidden" name="news2ID" value="{NEWSID}">
<table cellpadding="2" cellspacing="1" border="0" class="border">
<tr>
<td class="Cmite" align="right"><strong>Titel : </strong></td>
<td class="Cnorm"><input size="50" type="text" name="titel" value="{UEBER}"></td>
</tr><tr>
<td class="Cmite" align="right"><strong>News : </strong></td>
<td rowspan="2" class="Cnorm">
<!-- BB Code START -->
<a href="javascript:simple('b')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.bold.gif" alt="b" title="{_lang_bold}" border="0"></a>
<a href="javascript:simple('i')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.italic.gif" alt="i" title="{_lang_italic}" border="0"></a>
<a href="javascript:simple('u')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.underline.gif" alt="u" title="{_lang_underlined}" border="0"></a>
<a href="javascript:simple('code')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.code.gif" alt="Code" title="{_lang_code}" border="0"></a>
<a href="javascript:simple_liste()"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.insertunorderedlist.gif" alt="{_lang_list}" title="{_lang_list}" border="0"></a>
<a href="javascript:simple('url')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.link.gif" alt="Url" title="{_lang_link}" border="0"></a>
<a href="javascript:simple('img')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.image.gif" alt="{_lang_picture}" title="{_lang_picture}" border="0"></a>
<!-- BB Code ENDE -->
</td>
</tr><tr>
<td rowspan="2" valign="top" class="Cmite">{SMILIS}</td>
</tr><tr>
<td class="Cnorm"><textarea name="txt" rows="15" cols="65" tabindex="2">{txt}</textarea></td>
</tr><tr>
<td class="Cmite" align="right"><strong>Sichtbar ab : </strong></td>
<td class="Cnorm"><select name="grecht">{_list_grecht@<option%1 value="%2">%3</option>}</select></td>
</tr><tr>
<td class="Cmite" align="right"><strong>Kategorie : </strong></td>
<td class="Cnorm"><select onChange="sichtbar()" name="katLis">{KATS}<option value="neu">Neu:</option></select> <input type="text" name="kat" size="40"></td>
</tr><tr class="Cdark">
<td></td>
<td><input type="submit" value="{FSUB}" name="submit"></td>
</tr>
</table>
</form>
<br /><br />
<div class="info_box">
<b>Merke (Kategorie Bild)</b>
<br />
<span class="smalfont">
Das Kategorie Bild muss in den Ordner include/images/news2/
<br />
Das Bild muss genau wie die Kategorie heissen z.B. wenn die Kategorie
Allgemein heisst dann muss das Bild Allgemein heissen;)...
<br />
Die Endung muss entweder .jpg oder .gif sein bei uns also z.B. Allgemein.jpg
</span>
</div>
<div class="info_box">
<b>Merke (Vorschau Funktion)</b>
<br />
<span class="smalfont">
Soll nur ein kleinerer Vorschautext angezeigt werden, einfach erst die Vorschau
eingeben und nach der Vorschau dann <b>[PREVIEWENDE]</b> schreiben. Dann den langen
Text eintragen.
</span>
</div>
</td><td width="75"> </td><td valign="top">
{MPL}
<table cellpadding="3" cellspacing="1" border="0" class="border">
{EXPLODE}<tr class="{class}">
<td><a href="#" name="{ID}"></a><a href="javascript:delcheck({ID})"><img src="include/images/icons/del.gif" alt="Löschen" title="Löschen" border="0"></a></td>
<td><a href="?news2-edit-{ID}"><img src="include/images/icons/edit.gif" alt="Verändern" title="Verändern" border="0"></a></td>
<td>{TITEL}</td>
</tr>{EXPLODE}
</table>
{MPL}
</td></tr></table>
<script language="JavaScript" type="text/javascript">
<!--
sichtbar();
//-->
</script>
/include/admin/templates/news3.htm
<script language="JavaScript" type="text/javascript"><!--
function delcheck ( DELID ) {
var frage = confirm ( "Willst du diesen Eintrag wirklich l�schen?" );
if ( frage == true ) {
document.location.href="?news3-del-"+DELID;
}
}
function delKcheck ( DELID , NID) {
var frage = confirm ( "Willst du dieses Kommentar wirklich l�schen?" );
if ( frage == true ) {
document.location.href="?news3-sKoms-"+NID+"-Kdel-"+DELID+"#"+NID;
}
}
function sichtbar(){
if( document.form.katLis.value=="neu"){
document.form.kat.style.visibility="visible";
} else {
document.form.kat.style.visibility="hidden";
}
}
//--></script>
<script type='text/javascript' src='include/includes/js/bbcode.js'></script>
<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/news.png" /></td><td width="30"></td><td valign="bottom"><h1>News3</h1></td></tr></table>
<hr style="width: 400px; margin: 0px;" >
<br /><br />
<table border="0" cellspacing="0" cellpadding="0"><tr><td valign="top">
<form method="POST" name="form" action="?news3">
<input type="hidden" name="um" value="{AKTION}">
<input type="hidden" name="news3ID" value="{NEWSID}">
<table cellpadding="2" cellspacing="1" border="0" class="border">
<tr>
<td class="Cmite" align="right"><strong>Titel : </strong></td>
<td class="Cnorm"><input size="50" type="text" name="titel" value="{UEBER}"></td>
</tr><tr>
<td class="Cmite" align="right"><strong>News : </strong></td>
<td rowspan="2" class="Cnorm">
<!-- BB Code START -->
<a href="javascript:simple('b')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.bold.gif" alt="b" title="{_lang_bold}" border="0"></a>
<a href="javascript:simple('i')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.italic.gif" alt="i" title="{_lang_italic}" border="0"></a>
<a href="javascript:simple('u')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.underline.gif" alt="u" title="{_lang_underlined}" border="0"></a>
<a href="javascript:simple('code')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.code.gif" alt="Code" title="{_lang_code}" border="0"></a>
<a href="javascript:simple_liste()"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.insertunorderedlist.gif" alt="{_lang_list}" title="{_lang_list}" border="0"></a>
<a href="javascript:simple('url')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.link.gif" alt="Url" title="{_lang_link}" border="0"></a>
<a href="javascript:simple('img')"><img style="padding-left: 4%; float: left;" src="include/images/icons/button.image.gif" alt="{_lang_picture}" title="{_lang_picture}" border="0"></a>
<!-- BB Code ENDE -->
</td>
</tr><tr>
<td rowspan="2" valign="top" class="Cmite">{SMILIS}</td>
</tr><tr>
<td class="Cnorm"><textarea name="txt" rows="15" cols="65" tabindex="2">{txt}</textarea></td>
</tr><tr>
<td class="Cmite" align="right"><strong>Sichtbar ab : </strong></td>
<td class="Cnorm"><select name="grecht">{_list_grecht@<option%1 value="%2">%3</option>}</select></td>
</tr><tr>
<td class="Cmite" align="right"><strong>Kategorie : </strong></td>
<td class="Cnorm"><select onChange="sichtbar()" name="katLis">{KATS}<option value="neu">Neu:</option></select> <input type="text" name="kat" size="40"></td>
</tr><tr class="Cdark">
<td></td>
<td><input type="submit" value="{FSUB}" name="submit"></td>
</tr>
</table>
</form>
<br /><br />
<div class="info_box">
<b>Merke (Kategorie Bild)</b>
<br />
<span class="smalfont">
Das Kategorie Bild muss in den Ordner include/images/news3/
<br />
Das Bild muss genau wie die Kategorie heissen z.B. wenn die Kategorie
Allgemein heisst dann muss das Bild Allgemein heissen;)...
<br />
Die Endung muss entweder .jpg oder .gif sein bei uns also z.B. Allgemein.jpg
</span>
</div>
<div class="info_box">
<b>Merke (Vorschau Funktion)</b>
<br />
<span class="smalfont">
Soll nur ein kleinerer Vorschautext angezeigt werden, einfach erst die Vorschau
eingeben und nach der Vorschau dann <b>[PREVIEWENDE]</b> schreiben. Dann den langen
Text eintragen.
</span>
</div>
</td><td width="75"> </td><td valign="top">
{MPL}
<table cellpadding="3" cellspacing="1" border="0" class="border">
{EXPLODE}<tr class="{class}">
<td><a href="#" name="{ID}"></a><a href="javascript:delcheck({ID})"><img src="include/images/icons/del.gif" alt="Löschen" title="Löschen" border="0"></a></td>
<td><a href="?news3-edit-{ID}"><img src="include/images/icons/edit.gif" alt="Verändern" title="Verändern" border="0"></a></td>
<td>{TITEL}</td>
</tr>{EXPLODE}
</table>
{MPL}
</td></tr></table>
<script language="JavaScript" type="text/javascript">
<!--
sichtbar();
//-->
</script>
Das sind mal die Dateien für den Adminberreich