WvWvZBgV

1CREATE TABLE IF NOT EXISTS `settings` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `name` varchar(50) NOT NULL,
4  `value` varchar(255) NOT NULL,
5  `type` varchar(50) NOT NULL,
6  PRIMARY KEY (`id`)
7) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
8	
9INSERT INTO `settings` (`id`, `name`, `value`, `type`) VALUES
10(1, 'title', 'Qeekly', 'core'),
11(2, 'description', 'Твой собственный маленький мир', 'core'),
12(3, 'keywords', 'minecraft,сервер,комплекс,qeekly,майнкрафт', 'core'),
13(4, 'copyright', '«При копировании материалов с сайта, оставайтесь людьми — указывайте ссылку на источник!» Qeekly ©', 'core'),
14(5, 'charset', 'UTF-8', 'core'),
15(6, 'offline', '0', 'core'),
16(7, 'template', 'default', 'core'),
17(8, 'support', 'support@qeekly.ru', 'mail'),
18(9, 'noreply', 'noreply@qeekly.ru', 'mail'),
19(10, 'news', '3', 'lvl'),
20(11, 'pages', '4', 'lvl'),
21(12, 'actions', '4', 'lvl'),
22(13, 'profile', '2', 'lvl'),
23(14, 'news', '3', 'publish'),
24(15, 'pages', '4', 'publish'),
25(16, 'comments', '0', 'publish');
26	
27SELECT `value` 
28FROM `settings` 
29WHERE `type` = 'core' as Core AND `type` = 'lvl' as Lvl AND `type` = 'publish' as Publish
30	
31SELECT `value` FROM `settings` WHERE `type` = 'core'
32SELECT `value` FROM `settings` WHERE `type` = 'lvl'
33SELECT `value` FROM `settings` WHERE `type` = 'publish'
34	
35$result = $mysqli->query('SELECT name, type, value FROM settings');
36while($row=$result->fetch_array()) {
37 $name=strtoupper($row['name']);
38 if($row['type']=='lvl' || $row['type']=='publish') {
39   $name=$name.'_'.strtoupper($row['type']);
40 }
41 define($name,$row['value'];
42}