dbliste PHPのコード例

コード例 #1

0

ファイルを表示

ファイル: search.php プロジェクト: rjdesign/Ilch-1.2

function search_finduser()
{
    $design = new design('Finduser', '', 0);
    $design->header();
    $tpl = new tpl('search_finduser');
    $tpl->out(0);
    if (isset($_POST['sub']) and !empty($_POST['name'])) {
        $name = str_replace('*', "%", $_POST['name']);
        $name = escape($name, 'string');
        $q = "SELECT `name`,`name` FROM `prefix_user` WHERE `name` LIKE '" . $name . "'";
        $tpl->set('username', dbliste('', $tpl, 'username', $q));
        $tpl->out(1);
    }
    $tpl->out(2);
    $design->footer();
}

コード例 #2

0

ファイルを表示

ファイル: news.php プロジェクト: kveldscholten/Ilch-1.1

        $Ftxt = '';
        $Fgrecht = '';
        $FkatLis = '';
        $Fsub = 'Eintragen';
    } else {
        $row = db_fetch_object(db_query("SELECT * FROM `prefix_news` WHERE news_id = " . $menu->get(2)));
        $FnewsID = $row->news_id;
        $Faktion = 'change';
        $Fueber = $row->news_title;
        $Ftxt = stripslashes($row->news_text);
        $Fgrecht = $row->news_recht;
        $FkatLis = $row->news_kat;
        $Fsub = '&Auml;ndern';
    }
    $tpl = new tpl('news', 1);
    $ar = array('NEWSID' => $FnewsID, '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 news_id,news_title
	        FROM `prefix_news`
					ORDER BY news_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->news_id, 'class' => $class, 'TITEL' => $row->news_title), 1);
    }
    // e d i t , d e l e t e
    $tpl->set_ar_out(array('MPL' => $MPL), 2);
}

コード例 #3

0

ファイルを表示

ファイル: forum.php プロジェクト: kveldscholten/Ilch-1.1

     $ar['view'] .= dbliste($row->view, $tpl, 'view', "SELECT id, name FROM prefix_grundrechte ORDER BY id DESC");
     $ar['view'] .= '</optgroup>';
     $ar['view'] .= '<optgroup label="Gruppen">';
     $ar['view'] .= dbliste($row->view, $tpl, 'view', "SELECT id, name FROM prefix_groups ORDER BY id DESC");
     $ar['view'] .= '</optgroup>';
     $ar['reply'] = '<optgroup label="Grundrechte">';
     $ar['reply'] .= dbliste($row->reply, $tpl, 'reply', "SELECT id, name FROM prefix_grundrechte ORDER BY id DESC");
     $ar['reply'] .= '</optgroup>';
     $ar['reply'] .= '<optgroup label="Gruppen">';
     $ar['reply'] .= dbliste($row->reply, $tpl, 'reply', "SELECT id, name FROM prefix_groups ORDER BY id DESC");
     $ar['reply'] .= '</optgroup>';
     $ar['start'] = '<optgroup label="Grundrechte">';
     $ar['start'] .= dbliste($row->start, $tpl, 'start', "SELECT id, name FROM prefix_grundrechte ORDER BY id DESC");
     $ar['start'] .= '</optgroup>';
     $ar['start'] .= '<optgroup label="Gruppen">';
     $ar['start'] .= dbliste($row->start, $tpl, 'start', "SELECT id, name FROM prefix_groups ORDER BY id DESC");
     $ar['start'] .= '</optgroup>';
     $tpl->set_ar_out($ar, 0);
     unset($tpl);
     $show = false;
 } else {
     $cid = escape($_POST['cid'], 'integer');
     $name = escape($_POST['name'], 'string');
     $text = escape($_POST['text'], 'string');
     $view = escape($_POST['view'], 'integer');
     $start = escape($_POST['start'], 'integer');
     $reply = escape($_POST['reply'], 'integer');
     $fid = escape($_POST['fid'], 'integer');
     $r = db_fetch_object(db_query("SELECT * FROM prefix_forums WHERE id = " . $fid));
     if ($cid != $r->cid) {
         db_query("UPDATE prefix_forums SET pos = pos -1 WHERE pos > {$r->pos} AND cid = {$r->cid}");

コード例 #4

0

ファイルを表示

ファイル: user.php プロジェクト: kveldscholten/Ilch-1.1

 $design = new design('Admins Area', 'Admins Area', 2);
 $design->header();
 if (isset($_REQUEST['uID'])) {
     $uid = $_REQUEST['uID'];
 } else {
     $uid = $menu->get(2);
 }
 $erg = db_query("SELECT name,email,id,recht,wohnort,homepage,aim,msn,icq,yahoo,status,staat,gebdatum,sig,opt_pm,opt_pm_popup,opt_mail,geschlecht,spezrank,avatar FROM prefix_user WHERE id = '" . $uid . "'");
 if (db_num_rows($erg) == 0) {
     die('Fehler: Username nicht gefunden <a href="?user">zur&uuml;ck</a>');
 } else {
     $row = db_fetch_assoc($erg);
     $tpl = new tpl('user/details', 1);
     $row['recht'] = dbliste($row['recht'], $tpl, 'recht', "SELECT id,name FROM prefix_grundrechte ORDER BY id ASC");
     $row['staat'] = '<option></option>' . arliste($row['staat'], get_nationality_array(), $tpl, 'staat');
     $row['spezrank'] = '<option></option>' . dbliste($row['spezrank'], $tpl, 'spezrank', "SELECT id, bez FROM prefix_ranks WHERE spez = 1");
     $row['geschlecht0'] = $row['geschlecht'] < 1 ? 'checked' : '';
     $row['geschlecht1'] = $row['geschlecht'] == 1 ? 'checked' : '';
     $row['geschlecht2'] = $row['geschlecht'] == 2 ? 'checked' : '';
     if ($row['status'] == 1) {
         $row['status1'] = 'checked';
         $row['status0'] = '';
     } else {
         $row['status1'] = '';
         $row['status0'] = 'checked';
     }
     if ($row['opt_mail'] == 1) {
         $row['opt_mail1'] = 'checked';
         $row['opt_mail0'] = '';
     } else {
         $row['opt_mail1'] = '';

コード例 #5

0

ファイルを表示

ファイル: menu.php プロジェクト: kveldscholten/Ilch-1.1

        $ar['was'] = 2;
    }
} else {
    $ar = array('allboxes' => '', 'was' => '', 'getfuerB' => '', 'cwebene' => '', 'cwmenu' => $wo, 'allmenus' => '', 'bname' => '', 'posi' => '', 'apos' => '', 'awo' => '', 'link2' => '', 'alllinkss' => '', 'menutyp' => '');
}
$tpl = new tpl('menu', 1);
$boxenArNav = get_boxes_array();
$menuArNav = get_links_array();
$ar_cwmenu = array();
for ($i = 1; $i <= 5; $i++) {
    $ar_cwmenu[$i] = 'Men&uuml; 0' . $i;
}
$ar_cwebene = array();
for ($i = 0; $i <= 4; $i++) {
    $ar_cwebene[$i] = 'Ebene 0' . ($i + 1);
}
$ar_cwwas = array(1 => 'Box', 2 => 'Men&uuml;', 7 => 'Men&uuml;punkt wahl', 8 => 'Men&uuml;punkt extern', 9 => 'Men&uuml;punkt intern');
$ar_menutyp = array(2 => 'Vertikal', 1 => 'Horizontal');
$ar['allboxes'] = arliste($ar['allboxes'], $boxenArNav, $tpl, 'allboxes');
$ar['alllinkss'] = arliste($ar['alllinkss'], $menuArNav, $tpl, 'alllinkss');
$ar['getfuerB'] = dbliste($ar['getfuerB'], $tpl, 'getfuerB', "SELECT id,name FROM prefix_grundrechte ORDER BY id DESC");
$ar['cwmenu'] = arliste($ar['cwmenu'], $ar_cwmenu, $tpl, 'cwmenu');
$ar['cwebene'] = arliste($ar['cwebene'], $ar_cwebene, $tpl, 'cwebene');
$ar['cwwas'] = arliste($ar['was'], $ar_cwwas, $tpl, 'cwwas');
$ar['menutyp'] = arliste($ar['menutyp'], $ar_menutyp, $tpl, 'menutyp');
# ausgabe
$tpl->out(0);
show_menu($wo);
$tpl->set_ar($ar);
$tpl->out(1);
$design->footer();

コード例 #6

0

ファイルを表示

ファイル: kalender.php プロジェクト: rjdesign/Ilch-1.2

}
$arm = array();
for ($i = 0; $i < 60; $i++) {
    $arm[$i] = $i;
}
$ars = array();
for ($i = 0; $i < 24; $i++) {
    $ars[$i] = $i;
}
$tpl = new tpl('kalender.htm', 1);
$limit = 30;
// Limit
$page = $menu->getA(1) == 'p' ? $menu->getE(1) : 1;
$MPL = db_make_sites($page, '', $limit, "admin.php?kalender", 'kalender');
$anfang = ($page - 1) * $limit;
$aus = array('AKTION' => $Faktion, 'MPL' => $MPL, 'EID' => $Fid, 'TITLE' => $Ftitle, 'TEXT' => $Ftext, 'stunden' => arliste($Fhours, $ars, $tpl, 'stunden'), 'minuten' => arliste($Fmins, $arm, $tpl, 'minuten'), 'zende' => $Fzende, 'begind' => $Fbegind, 'recht' => dbliste($Frecht, $tpl, 'recht', "SELECT `id`,`name` FROM `prefix_grundrechte` ORDER BY `id` DESC"), 'FSUB' => $Fsub, 'ANTISPAM' => get_antispam('adminuser_action', 0, true));
$tpl->set_ar_out($aus, 0);
if (!isset($_GET['edit'])) {
    $tpl->out(1);
} else {
    $tpl->out(2);
}
$tpl->out(3);
unset($aus);
// Liste
$result = db_query('SELECT `gid`,`id`,`title`,`time` FROM `prefix_kalender` ORDER BY `time` DESC LIMIT ' . $anfang . ',' . $limit);
while ($row = db_fetch_assoc($result)) {
    $aus = array('ID' => $row['id'], 'DATE' => date('d.m.Y', $row['time']), 'TIME' => date('H:i', $row['time']), 'TITLE' => $row['title'], 'GID' => $row['gid']);
    $tpl->set_ar_out($aus, 4);
}
$tpl->set_ar_out(array('MPL' => $MPL), 5);

コード例 #7

0

ファイルを表示

ファイル: user.php プロジェクト: rjdesign/Ilch-1.2

 $design = new design('Ilch Admin-Control-Panel :: Userdetails', '- Details', 2);
 $design->header();
 if (isset($_REQUEST['uID'])) {
     $uid = $_REQUEST['uID'];
 } else {
     $uid = $menu->get(2);
 }
 $erg = db_query("SELECT `name`,`email`,`id`,`recht`,`wohnort`,`homepage`,`aim`,`msn`,`icq`,`yahoo`,`status`, `sperre`,`staat`,`gebdatum`,`sig`,`opt_pm`,`opt_pm_popup`,`opt_mail`,`geschlecht`,`spezrank`,`avatar` FROM `prefix_user` WHERE `id` = '" . $uid . "'");
 if (db_num_rows($erg) == 0) {
     die('Fehler: Username nicht gefunden <a href="admin.php?user">zur&uuml;ck</a>');
 } else {
     $row = db_fetch_assoc($erg);
     $tpl = new tpl('user/details', 1);
     $row['recht'] = dbliste($row['recht'], $tpl, 'recht', "SELECT `id`,`name` FROM `prefix_grundrechte` ORDER BY `id` ASC");
     $row['staat'] = '<option></option>' . arliste($row['staat'], get_nationality_array(), $tpl, 'staat');
     $row['spezrank'] = '<option></option>' . dbliste($row['spezrank'], $tpl, 'spezrank', "SELECT `id`, `bez` FROM `prefix_ranks` WHERE `spez` = 1");
     $row['geschlecht0'] = $row['geschlecht'] < 1 ? 'checked' : '';
     $row['geschlecht1'] = $row['geschlecht'] == 1 ? 'checked' : '';
     $row['geschlecht2'] = $row['geschlecht'] == 2 ? 'checked' : '';
     if ($row['status'] == 1) {
         $row['status1'] = 'checked';
         $row['status0'] = '';
     } else {
         $row['status1'] = '';
         $row['status0'] = 'checked';
     }
     if ($row['sperre'] == 1) {
         $row['sperre1'] = 'checked';
     } else {
         $row['sperre1'] = '';
     }

コード例 #8

0

ファイルを表示

ファイル: forum.php プロジェクト: rjdesign/Ilch-1.2

     $ar['view'] .= dbliste($row->view, $tpl, 'view', "SELECT `id`, `name` FROM `prefix_grundrechte` ORDER BY `id` DESC");
     $ar['view'] .= '</optgroup>';
     $ar['view'] .= '<optgroup label="Gruppen">';
     $ar['view'] .= dbliste($row->view, $tpl, 'view', "SELECT `id`, `name` FROM `prefix_groups` ORDER BY `id` DESC");
     $ar['view'] .= '</optgroup>';
     $ar['reply'] = '<optgroup label="Grundrechte">';
     $ar['reply'] .= dbliste($row->reply, $tpl, 'reply', "SELECT `id`, `name` FROM `prefix_grundrechte` ORDER BY `id` DESC");
     $ar['reply'] .= '</optgroup>';
     $ar['reply'] .= '<optgroup label="Gruppen">';
     $ar['reply'] .= dbliste($row->reply, $tpl, 'reply', "SELECT `id`, `name` FROM `prefix_groups` ORDER BY `id` DESC");
     $ar['reply'] .= '</optgroup>';
     $ar['start'] = '<optgroup label="Grundrechte">';
     $ar['start'] .= dbliste($row->start, $tpl, 'start', "SELECT `id`, `name` FROM `prefix_grundrechte` ORDER BY `id` DESC");
     $ar['start'] .= '</optgroup>';
     $ar['start'] .= '<optgroup label="Gruppen">';
     $ar['start'] .= dbliste($row->start, $tpl, 'start', "SELECT `id`, `name` FROM `prefix_groups` ORDER BY `id` DESC");
     $ar['start'] .= '</optgroup>';
     $tpl->set('ANTISPAM', get_antispam('adminuser_action', 0, true));
     $tpl->set_ar_out($ar, 0);
     unset($tpl);
     $show = false;
 } elseif (chk_antispam('adminuser_action', true)) {
     $cid = escape($_POST['cid'], 'integer');
     $name = escape($_POST['name'], 'string');
     $text = escape($_POST['text'], 'string');
     $view = escape($_POST['view'], 'integer');
     $start = escape($_POST['start'], 'integer');
     $reply = escape($_POST['reply'], 'integer');
     $fid = escape($_POST['fid'], 'integer');
     $r = db_fetch_object(db_query("SELECT * FROM `prefix_forums` WHERE `id` = " . $fid));
     if ($cid != $r->cid) {

コード例 #9

0

ファイルを表示

ファイル: kalender.php プロジェクト: kveldscholten/Ilch-1.1

}
$arm = array();
for ($i = 0; $i < 60; $i++) {
    $arm[$i] = $i;
}
$ars = array();
for ($i = 0; $i < 24; $i++) {
    $ars[$i] = $i;
}
$tpl = new tpl('kalender.htm', 1);
$limit = 30;
// Limit
$page = $menu->getA(1) == 'p' ? $menu->getE(1) : 1;
$MPL = db_make_sites($page, '', $limit, "?kalender", 'kalender');
$anfang = ($page - 1) * $limit;
$aus = array('AKTION' => $Faktion, 'MPL' => $MPL, 'EID' => $Fid, 'TITLE' => $Ftitle, 'TEXT' => $Ftext, 'stunden' => arliste($Fhours, $ars, $tpl, 'stunden'), 'minuten' => arliste($Fmins, $arm, $tpl, 'minuten'), 'zende' => $Fzende, 'begind' => $Fbegind, 'recht' => dbliste($Frecht, $tpl, 'recht', "SELECT id,name FROM prefix_grundrechte ORDER BY id DESC"), 'FSUB' => $Fsub);
$tpl->set_ar_out($aus, 0);
if (!isset($_GET['edit'])) {
    $tpl->out(1);
} else {
    $tpl->out(2);
}
$tpl->out(3);
unset($aus);
//Liste
$result = db_query('SELECT gid,id,title,time FROM `prefix_kalender` ORDER BY time DESC LIMIT ' . $anfang . ',' . $limit);
while ($row = db_fetch_assoc($result)) {
    $aus = array('ID' => $row['id'], 'DATE' => date('d.m.Y', $row['time']), 'TIME' => date('H:i', $row['time']), 'TITLE' => $row['title'], 'GID' => $row['gid']);
    $tpl->set_ar_out($aus, 4);
}
$tpl->set_ar_out(array('MPL' => $MPL), 5);

コード例 #10

0

ファイルを表示

ファイル: groups.php プロジェクト: kveldscholten/Ilch-1.1

 if ($um == 'edit') {
     $ar = db_fetch_assoc(db_query("SELECT id as gid, name, img, `mod1`, `mod2`, `mod3`, `mod4`, zeigen, show_joinus, show_fightus FROM prefix_groups WHERE id = " . $menu->get(2)));
     $ar['ak'] = 'ch';
     $ar['zeigenja'] = $ar['zeigen'] == 1 ? 'checked' : '';
     $ar['zeigenno'] = $ar['zeigen'] == 1 ? '' : 'checked';
     $ar['joinusja'] = $ar['show_joinus'] == 1 ? 'checked' : '';
     $ar['joinusno'] = $ar['show_joinus'] == 1 ? '' : 'checked';
     $ar['fightusja'] = $ar['show_fightus'] == 1 ? 'checked' : '';
     $ar['fightusno'] = $ar['show_fightus'] == 1 ? '' : 'checked';
 } else {
     $ar = array('name' => '', 'img' => '', 'mod1' => '', 'mod2' => '', 'mod3' => '', 'mod4' => '', 'zeigenja' => '', 'zeigenno' => 'checked', 'ak' => 'ins', 'gid' => '', 'fightusja' => '', 'fightusno' => 'checked', 'joinusja' => '', 'joinusno' => 'checked');
 }
 $ar['mods1'] = dbliste($ar['mod1'], $tpl, 'mods1', "SELECT id,name FROM prefix_user WHERE recht <= -4 ORDER BY name");
 $ar['mods2'] = dbliste($ar['mod2'], $tpl, 'mods2', "SELECT id,name FROM prefix_user WHERE recht <= -4 ORDER BY name");
 $ar['mods3'] = dbliste($ar['mod3'], $tpl, 'mods3', "SELECT id,name FROM prefix_user WHERE recht <= -4 ORDER BY name");
 $ar['mods4'] = dbliste($ar['mod4'], $tpl, 'mods4', "SELECT id,name FROM prefix_user WHERE recht <= -4 ORDER BY name");
 $ar['mods2'] = '<option value="0">keiner</option>' . $ar['mods2'];
 $ar['mods3'] = '<option value="0">keiner</option>' . $ar['mods3'];
 $ar['mods4'] = '<option value="0">keiner</option>' . $ar['mods4'];
 $ar['pic'] = arlistee($ar['img'], get_teampic_ar());
 $ar['pic'] = '<option value="0">kein Bild<option>' . $ar['pic'];
 $ar['msg'] = empty($msg) ? '' : '<table width="50%" cellpadding="2" cellspacing="1" border="0" class="border"><tr><td class="Cnorm"><b>Nachricht:</b>&nbsp;' . $msg . '</td></tr></table>';
 $ar['joinu'] = '';
 if (0 < db_result(db_query("SELECT COUNT(*) FROM prefix_usercheck WHERE ak = 4"), 0)) {
     $ar['joinu'] = '<a href="admin.php?groups-joinus"><b>Joinus Anfragen bearbeiten</b></a><br /><br />';
 }
 $tpl->set_ar_out($ar, 0);
 $class = 'Cnorm';
 $erg = db_query("SELECT name,id FROM prefix_groups ORDER BY pos ASC");
 while ($row = db_fetch_assoc($erg)) {
     $row['useranz'] = db_count_query("SELECT COUNT(uid) FROM prefix_groupusers WHERE gid = " . $row['id']);

コード例 #11

0

ファイルを表示

ファイル: menu.php プロジェクト: rjdesign/Ilch-1.2

    $ar = array('allboxes' => '', 'was' => '', 'getfuerB' => '', 'cwebene' => '', 'cwmenu' => $wo, 'allmenus' => '', 'bname' => '', 'posi' => '', 'apos' => '', 'awo' => '', 'link2' => '', 'alllinkss' => '', 'menutyp' => '', 'recht_type' => 0, 'team' => 0, 'ANTISPAM' => get_antispam('adminuser_action', 0, true));
}
$tpl = new tpl('menu', 1);
$boxenArNav = get_boxes_array();
$menuArNav = get_links_array();
$ar_cwmenu = array();
for ($i = 1; $i <= $allgAr['menu_anz']; $i++) {
    $ar_cwmenu[$i] = 'Men&uuml; 0' . $i;
}
$ar_cwebene = array();
for ($i = 0; $i <= 4; $i++) {
    $ar_cwebene[$i] = 'Ebene 0' . ($i + 1);
}
$ar_cwwas = array(1 => 'Box', 2 => 'Men&uuml;', 7 => 'Men&uuml;punkt wahl', 8 => 'Men&uuml;punkt extern', 9 => 'Men&uuml;punkt intern');
$ar_menutyp = array(2 => 'Vertikal', 1 => 'Horizontal');
$ar_rechttypes = array('ab', 'für', 'bis', 'für Team');
$ar['allboxes'] = arliste($ar['allboxes'], $boxenArNav, $tpl, 'allboxes');
$ar['alllinkss'] = arliste($ar['alllinkss'], $menuArNav, $tpl, 'alllinkss');
$ar['getfuerB'] = dbliste($ar['getfuerB'], $tpl, 'getfuerB', "SELECT `id`,`name` FROM `prefix_grundrechte` ORDER BY `id` DESC");
$ar['cwmenu'] = arliste($ar['cwmenu'], $ar_cwmenu, $tpl, 'cwmenu');
$ar['cwebene'] = arliste($ar['cwebene'], $ar_cwebene, $tpl, 'cwebene');
$ar['cwwas'] = arliste($ar['was'], $ar_cwwas, $tpl, 'cwwas');
$ar['menutyp'] = arliste($ar['menutyp'], $ar_menutyp, $tpl, 'menutyp');
$ar['rechttype'] = arliste($ar['recht_type'], $ar_rechttypes, $tpl, 'rechttype');
$ar['teams'] = dbliste($ar['team'], $tpl, 'teams', 'SELECT `id`, `name` FROM `prefix_groups` ORDER BY `pos`');
// ausgabe
$tpl->out(0);
show_menu($wo);
$tpl->set_ar($ar);
$tpl->out(1);
$design->footer();

コード例 #12

0

ファイルを表示

ファイル: groups.php プロジェクト: rjdesign/Ilch-1.2

 if ($um == 'edit') {
     $ar = db_fetch_assoc(db_query("SELECT `id` as `gid`, `name`, `img`, `mod1`, `mod2`, `mod3`, `mod4`, `zeigen`, `show_joinus`, `show_fightus` FROM `prefix_groups` WHERE `id` = '{$menu->get(2)}'"));
     $ar['ak'] = 'ch';
     $ar['zeigenja'] = $ar['zeigen'] == 1 ? 'checked' : '';
     $ar['zeigenno'] = $ar['zeigen'] == 1 ? '' : 'checked';
     $ar['joinusja'] = $ar['show_joinus'] == 1 ? 'checked' : '';
     $ar['joinusno'] = $ar['show_joinus'] == 1 ? '' : 'checked';
     $ar['fightusja'] = $ar['show_fightus'] == 1 ? 'checked' : '';
     $ar['fightusno'] = $ar['show_fightus'] == 1 ? '' : 'checked';
 } else {
     $ar = array('name' => '', 'img' => '', 'mod1' => '', 'mod2' => '', 'mod3' => '', 'mod4' => '', 'zeigenja' => '', 'zeigenno' => 'checked', 'ak' => 'ins', 'gid' => '', 'fightusja' => '', 'fightusno' => 'checked', 'joinusja' => '', 'joinusno' => 'checked');
 }
 $ar['mods1'] = dbliste($ar['mod1'], $tpl, 'mods1', "SELECT `id`,`name` FROM `prefix_user` WHERE `recht` <= '-4' ORDER BY `name`");
 $ar['mods2'] = dbliste($ar['mod2'], $tpl, 'mods2', "SELECT `id`,`name` FROM `prefix_user` WHERE `recht` <= '-4' ORDER BY `name`");
 $ar['mods3'] = dbliste($ar['mod3'], $tpl, 'mods3', "SELECT `id`,`name` FROM `prefix_user` WHERE `recht` <= '-4' ORDER BY `name`");
 $ar['mods4'] = dbliste($ar['mod4'], $tpl, 'mods4', "SELECT `id`,`name` FROM `prefix_user` WHERE `recht` <= '-4' ORDER BY `name`");
 $ar['mods2'] = '<option value="0">keiner</option>' . $ar['mods2'];
 $ar['mods3'] = '<option value="0">keiner</option>' . $ar['mods3'];
 $ar['mods4'] = '<option value="0">keiner</option>' . $ar['mods4'];
 $ar['pic'] = arlistee($ar['img'], get_teampic_ar());
 $ar['pic'] = '<option value="0">kein Bild<option>' . $ar['pic'];
 $ar['msg'] = empty($msg) ? '' : '<table width="50%" cellpadding="2" cellspacing="1" border="0" class="border"><tr><td class="Cnorm"><b>Nachricht:</b>&nbsp;' . $msg . '</td></tr></table>';
 $ar['joinu'] = '';
 if (0 < db_result(db_query("SELECT COUNT(*) FROM prefix_usercheck WHERE ak = 4"), 0)) {
     $ar['joinu'] = '<a href="admin.php?groups-joinus"><b>Joinus Anfragen bearbeiten</b></a><br /><br />';
 }
 $ar['ANTISPAM'] = get_antispam('adminuser_action', 0, true);
 $tpl->set_ar_out($ar, 0);
 $class = 'Cnorm';
 $erg = db_query("SELECT `name`,`id` FROM `prefix_groups` ORDER BY `pos` ASC");
 while ($row = db_fetch_assoc($erg)) {

コード例 #13

0

ファイルを表示

ファイル: news.php プロジェクト: rjdesign/Ilch-1.2

        $Ftxt = '';
        $Fgrecht = '';
        $FkatLis = '';
        $Fsub = 'Eintragen';
    } else {
        $row = db_fetch_object(db_query("SELECT * FROM `prefix_news` WHERE `news_id` = " . $menu->get(2)));
        $FnewsID = $row->news_id;
        $Faktion = 'change';
        $Fueber = $row->news_title;
        $Ftxt = stripslashes($row->news_text);
        $Fgrecht = $row->news_recht;
        $FkatLis = $row->news_kat;
        $Fsub = '&Auml;ndern';
    }
    $tpl = new tpl('news', 1);
    $ar = array('NEWSID' => $FnewsID, '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, 'ANTISPAM' => get_antispam('adminuser_action', 0, true));
    $tpl->set_ar_out($ar, 0);
    // e d i t , d e l e t e
    $abf = 'SELECT `news_id`,`news_title`
	        FROM `prefix_news`
					ORDER BY `news_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->news_id, 'class' => $class, 'TITEL' => $row->news_title), 1);
    }
    // e d i t , d e l e t e
    $tpl->set_ar_out(array('MPL' => $MPL), 2);
}

PHP dblisteの例