<?php
# Copyright by: Felix Hohlwegler
# Support: www.felix-hohlwegler.de
#HTML - Parser include
require('include/admin/simple_html_dom.php');
$tpl = new tpl ( 'tagcloud', 1);
defined ('main') or die ( 'no direct access' );
defined ('admin') or die ( 'only admin access' );
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
$um = '';
if (isset($_REQUEST['um'])) {
$um = $_REQUEST['um'];
}
#-----------------------------------------------------------------------------------------------------------------------------------------------
#Tag Suche
#durchsucht die angegebene Webseite nach Links Trägt dann die Links + Name in die Datenbank ein
#-----------------------------------------------------------------------------------------------------------------------------------------------
if (!empty($_POST['search'])) {
#Pfad einlesen
$path = escape($_POST['seite'], 'string');
# Datei Laden
$html = file_get_html($path);
#links suchen
foreach($html->find('a') as $element){
$temp_href = $element->href;
$temp_title = $element->title;
db_query('INSERT INTO `prefix_tagcloud` (href,name) VALUES ( "'.$temp_href.'", "'.$temp_title.'") ' );
}
}
#-----------------------------------------------------------------------------------------------------------------------------------------------
#Submit Manuelle Tag eingabe
#-----------------------------------------------------------------------------------------------------------------------------------------------
if (!empty($_POST['sub'])) {
$href = escape($_POST['href'], 'string');
$name = escape($_POST['name'], 'string');
$cssid = escape($_POST['cssid'], 'string');
if ( empty($_POST['sid']) ) {
db_query('INSERT INTO `prefix_tagcloud` (href,name,cssid) VALUES ( "'.$href.'","'.$name.'","'.$cssid.'" ) ' );
} else {
$sid = escape($_POST['sid'], 'integer');
db_query('UPDATE `prefix_tagcloud` SET href = "'.$href.'", name = "'.$name.'", cssid ="'.$cssid.'" WHERE id = "'.$sid.'"');
}
}
#-----------------------------------------------------------------------------------------------------------------------------------------------
#Submit CSS Eintrag
#-----------------------------------------------------------------------------------------------------------------------------------------------
if (!empty($_POST['csssend'])) {
$css = escape($_POST['css'], 'string');
if ( empty($_POST['sidcss']) ) {
db_query('INSERT INTO `prefix_tagcloudcss` (css) VALUES ( "'.$css.'" ) ' );
} else {
$sidcsss = escape($_POST['sidcss'], 'integer');
db_query('UPDATE `prefix_tagcloudcss` SET css = "'.$css.'" WHERE id = "'.$sidcsss.'"');
}
}
#-----------------------------------------------------------------------------------------------------------------------------------------------
#Eintrag Löschen Tag
#-----------------------------------------------------------------------------------------------------------------------------------------------
if (!empty($_GET['delete']) ) {
$delete = escape($_GET['delete'], 'integer');
db_query('DELETE FROM `prefix_tagcloud` WHERE id = "'.$delete.'" LIMIT 1');
}
#-----------------------------------------------------------------------------------------------------------------------------------------------
#Eintrag Löschen CSS Stil
#-----------------------------------------------------------------------------------------------------------------------------------------------
if (!empty($_GET['deletecss']) ) {
$delete = escape($_GET['deletecss'], 'integer');
db_query('DELETE FROM `prefix_tagcloudcss` WHERE id = "'.$delete.'" LIMIT 1');
}
#-----------------------------------------------------------------------------------------------------------------------------------------------
#Ausgabe
#-----------------------------------------------------------------------------------------------------------------------------------------------
if ( empty($_GET['sid']) ) {
$row = array();
$row['sub'] = 'Eintragen';
$row['name'] = '';
$row['href'] = '';
$row['cssid'] = '';
$row['sid'] = '';
$row['sidcss'] = '';
$row['seite'] = '';
$row['css'] = '';
} else {
$abf = 'SELECT href,name,cssid,id as sid FROM `prefix_tagcloud` WHERE id = "'.$_GET['sid'].'"';
$erg = db_query($abf);
$row = db_fetch_assoc($erg);
$row['sub'] = 'Ändern';
$row['seite'] = '';
$row['css'] = '';
}
if ( empty($_GET['sidcss']) ) {
$css_out['css'] = '';
} else {
$sidcss=escape($_GET['sidcss'],'integer');
$abf2 = 'SELECT css FROM `prefix_tagcloudcss` WHERE id = "'.$sidcss.'"';
$erg2 = db_query($abf2);
$css_out = db_result($erg2,0);
}
$tpl->set_out('css',$css_out,0);
$clas = '';
$tpl->set_ar_out($row,0);
#Abfrage der Tags
$erg = db_query('SELECT * FROM `prefix_tagcloud` ORDER BY id');
#Abfrage der CSS sTile
$erg1 = db_query('SELECT * FROM `prefix_tagcloudcss` ORDER BY id');
while ($row = db_fetch_assoc($erg) ) {
$clas = ($clas == 'Cmite' ? 'Cnorm' : 'Cmite' );
$row['class'] = $clas;
$tpl->set_ar_out($row,1);
}
$tpl->out(2);
while ($row = db_fetch_assoc($erg1) ) {
$clas = ($clas == 'Cmite' ? 'Cnorm' : 'Cmite' );
$row['classcss'] = $clas;
$tpl->set_ar_out($row,3);
}
$tpl->out(4);
$design->footer();
?>
Zitat geschrieben von holz
