Eeros - Menu (via database)

Bot · Topicstarter

Berichten: 93.699
Reputatie: 0
Punten: 1,27

Lid sinds: 2025
Laatst gezien: 29 jun 2025

27 nov 2010, 19:54

Ik wilde ook een admin erbij maken.. Maar het beheer script is een beetje ***

SQL:

Codeblok (menu.sql):

1
2
3
4
5
6
7
8

CREATE TABLE IF NOT EXISTS `menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`naam` varchar(100) NOT NULL,
`link` varchar(999) NOT NULL,
`site` enum(extern,intern) NOT NULL,
`zien` enum(iedereen,gasten,leden) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

Codeblok (menu_demo.sql):

1
2
3

INSERT INTO `menu` (`id`, `naam`, `link`, `site`, `zien`) VALUES
(1, One2xs!, http://www.one2xs.com/, extern, iedereen),
(2, Nieuwe prive bericht!, priveberichten&n, intern, leden);

En dan de PHP

Open includes/config.php
Zoek naar regel 681 (of zoek met CTRL + F public function showMenu($type))

Vervang de HELE functie met:

[COLOR= #0000BB]<?php[/COLOR]
    [URL="http://www.php.net/public"]public[/URL] [COLOR= #007700]function[/COLOR] showMenu[COLOR= #007700]([/COLOR][COLOR= #0000BB]$type[/COLOR][COLOR= #007700])
    {[/COLOR]
        
        [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700];[/COLOR]
        
        [COLOR= #0000BB]$pQuery[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM cms WHERE soort = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]real_escape[COLOR= #007700]([/COLOR][COLOR= #0000BB]$type[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]" OR soort = 3 AND menu = 1"[/COLOR][COLOR= #007700]);[/COLOR]
        
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$pFetch[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$pQuery[/COLOR][COLOR= #007700]))
        {[/COLOR]
            
            [COLOR= #0000BB]$returned[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<a href="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]?p=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$pFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]pagina_titel[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]">[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$core[/COLOR][COLOR= #007700]->[/COLOR]entities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$pFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]pagina_titel[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</a><br />[/COLOR][COLOR= #007700];
            
        }[/COLOR]
        
        [COLOR= #0000BB]$menuQuery[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]query[COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM menu WHERE zien = "[/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$type[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]0[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]gasten[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]leden[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000]" OR zien = iedereen"[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$menuFetch[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mysql[/COLOR][COLOR= #007700]->[/COLOR]fetch[COLOR= #007700]([/COLOR][COLOR= #0000BB]$menuQuery[/COLOR][COLOR= #007700])){[/COLOR]
            [COLOR= #0000BB]$returned[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]<a href="[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$menuFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]site[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]intern[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #0000BB]$_CONFIG[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Site_url[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]?p=[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700]).[/COLOR][COLOR= #0000BB]$menuFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]link[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">[/COLOR][COLOR= #007700].[/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$menuFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]</a><br />[/COLOR][COLOR= #007700];
        }[/COLOR]
        
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$returned[/COLOR][COLOR= #007700];
        
    }[/COLOR]
?>

Let op: Laat weg, Dit is alleen zodat je de mooie kleurtjes kan zien