Location: PHPKode > projects > PHPEcho CMS > install/data/mysql_inserts.php
<?php
// Blocks insert
$insert[] = "
INSERT INTO `".PREFIX."blocks` VALUES (1, 'navigation', 'Navigation', 'r', 0, 0, 'ON', '');
";
$insert[] = "
INSERT INTO `".PREFIX."blocks` VALUES (2, 'login', 'Login', 'l', 0, 0, 'ON', '');
";
$insert[] = "
INSERT INTO `".PREFIX."blocks` VALUES (3, 'userlist', 'User List', 'd', 0, 0, 'ON', '');
";
$insert[] = "
INSERT INTO `".PREFIX."blocks` VALUES (4, 'voting', 'Voting', 'r', 1, 0, 'ON', '');
";
$insert[] = "
INSERT INTO `".PREFIX."blocks` VALUES (5, 'statistics', 'Statistics', 'd', 1, 0, 'ON', '');
";
$insert[] = "
INSERT INTO `".PREFIX."blocks` VALUES (6, 'lastnews', 'Last News', 'l', 1, 0, 'ON', '');
";
// Themes insert
$insert[] = "
insert into `".PREFIX."themes` values (1, 'default', 'Default', 'Cheep', 'hide@address.com');
";
// Language choice insert
$insert[] = "
INSERT INTO `".PREFIX."languages` VALUES (1, 'russian', 'Russian', 'Tigran Abrahamyan', 'hide@address.com');
";
$insert[] = "
INSERT INTO `".PREFIX."languages` VALUES (2, 'english', 'English', 'Tigran Abrahamyan', 'hide@address.com');
";
$insert[] = "
INSERT INTO `".PREFIX."languages` VALUES (3, 'arabic', 'Arabic', 'Linostar', 'anas_h_34[at]hotmail[dot]com');
";
$insert[] = "
INSERT INTO `".PREFIX."languages` VALUES (4, 'polish', 'Polish', 'Xiadz', 'xiadz[at]users[dot]sourceforge[dot]net');
";
$insert[] = "
INSERT INTO `".PREFIX."languages` VALUES (5, 'german', 'German', 'Webjack', 'webjack21[at]users[dot]sourceforge[dot]net');
";
$insert[] = "
INSERT INTO `".PREFIX."languages` VALUES (6, 'italian', 'Italian', 'giuseppep', 'giuseppep[at]users[dot]sourceforge[dot]net');
";
$insert[] = "
INSERT INTO `".PREFIX."languages` VALUES (7, 'swedish', 'Swedish', 'Gulligan', 'gulligan[at]users[dot]sourceforge[dot]net');
";
// Modules insert
$insert[] = "
INSERT INTO `".PREFIX."modules` VALUES (1, 'news', 'News', 1, 'ON');
";
$insert[] = "
INSERT INTO `".PREFIX."modules` VALUES (2, 'files', 'Files', 1, 'ON');
";
$insert[] = "
INSERT INTO `".PREFIX."modules` VALUES (3, 'login', 'Authorization', 0, '');
";
$insert[] = "
INSERT INTO `".PREFIX."modules` VALUES (4, 'cpanel', 'Control Panel', 0, '');
";
$insert[] = "
INSERT INTO `".PREFIX."modules` VALUES (5, 'gallery', 'Photo Gallery', 1, 'ON');
";
$insert[] = "
INSERT INTO `".PREFIX."modules` VALUES (6, 'admin', 'Admin Panel', '0', '');
";
$insert[] = "
INSERT INTO `".PREFIX."modules` VALUES (7, 'forum', 'Forum', 1, 'ON');
";
$insert[] = "
insert into `".PREFIX."modules` values (8, 'voting', 'Voting', 1, 'ON');
";
$insert[] = "
insert into `".PREFIX."modules` values (9, 'statistics', 'Statistics', 1, 'ON');
";
// welcome news insert (test message)
$insert[] = "
INSERT INTO `".PREFIX."news` VALUES (1, 'Welcome message from PHPEcho CMS Team', 'Welcome to your new site. You have successfuly installed the CMS. <br/>Thank you for using our product!', '<br/>You can delete this message at any time!', 'Admin', '0');
";
// admin user insert
$insert[] = "
INSERT INTO `".PREFIX."users` VALUES (null, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'hide@address.com', 'english', 'default', '1', '0', '0');
";
// Settings insert
$insert[] = "
INSERT INTO `".PREFIX."settings` VALUES ('PHPEcho CMS', 'english', 0, '', 'hide@address.com', 6, 'PHPEcho Portal', 'default', '15', '15', '0', '1', '3');
";
// Statistics insert
$insert[] = "
INSERT INTO `".PREFIX."statistics_os` VALUES ('Linux', '0');
";
$insert[] = "
INSERT INTO `".PREFIX."statistics_os` VALUES ('Unix', '0');
";
$insert[] = "
INSERT INTO `".PREFIX."statistics_os` VALUES ('Windows', '0');
";
$insert[] = "
INSERT INTO `".PREFIX."statistics_os` VALUES ('Mac', '0');
";
$insert[] = "
INSERT INTO `".PREFIX."statistics_os` VALUES ('Others', '0');
";
$insert[] = "
INSERT INTO `".PREFIX."statistics_browser` VALUES ('Mozilla', '0');
";
$insert[] = "
INSERT INTO `".PREFIX."statistics_browser` VALUES ('Opera', '0');
";
$insert[] = "
INSERT INTO `".PREFIX."statistics_browser` VALUES ('Safari', '0');
";
$insert[] = "
INSERT INTO `".PREFIX."statistics_browser` VALUES ('IE', '0');
";
$insert[] = "
INSERT INTO `".PREFIX."statistics_browser` VALUES ('Others', '0');
";

// Admin permissions insert
$insert[] = "
insert into `".PREFIX."admin_perms` values (1, '11111111111');
";

// Banners insert
$insert[] = "
insert into `".PREFIX."banners` values ('logo.jpg', 1);
";
?>

Return current item: PHPEcho CMS