phpBB.de

Code: Alles auswählen

if(! function_exists(fetch_allnews)) {
    function fetch_allnews () {

        global $db_host, $db_name, $db_user, $db_pass, $db_tab, $elem, $bsx_conf, $links, $go, $QUERY_STRING;

        if(! isset($go)) $go = 0;

        $dbcon = new db_bsx($db_host, $db_name, $db_user, $db_pass);
        $com_anz = $dbcon->db_rows("SELECT * FROM ".$db_tab[news]." WHERE `active` = '1'");
        $query = $dbcon->db_fetch_multi("SELECT * FROM ".$db_tab[news]." WHERE `active` = '1' ORDER BY id DESC LIMIT $go,".$bsx_conf[news_com_max]."");
        foreach($query as $query_detail) {
            foreach($query_detail as $key=>$elem) {
                $elem[anz] = $dbcon->db_rows("SELECT * FROM ".$db_tab[news_com]." WHERE news_id = $elem[id]");
                $newscon[] = $elem;
            }
        }
        $close = $dbcon->close();
        $links = site_view($go, $bsx_conf[news_com_max], $com_anz, $QUERY_STRING);
        return $newscon;
        unset($elem, $newscon, $query, $query_detail, $anz);
    }
}

Code: Alles auswählen

if($_REQUEST["nshow"] == "postnews") {
    
    $dbcon = new db_bsx($db_host, $db_name, $db_user, $db_pass);
	$icon_query = $dbcon->db_fetch_multi("SELECT * FROM $db_tab[news_icon]");
	$close = $dbcon->close();
	if($icon_query) {
		$news_icon = "<select style=\"font-family:{fontface}; color:{fontcolor}; width:90%; font-size:{fontsize};\""
		            ." name=\"NewsIcon\">";
		foreach($icon_query as $icon_query_detail) {
			foreach($icon_query_detail as $key=>$icon_elem) {
				$news_icon .= "<option value=\"$icon_elem[id]\">$icon_elem[title]</option>";
			}
		}
		$news_icon .= "</select>";
	}
	eval("print dooutput(\"".gettemplate("useraddnews")."\");");
    
    
}

Code: Alles auswählen

error_reporting(E_ALL);