Bet kažkaip ne taip parašyti.
Turi būti maždaug taip:
-- Sukurta duomenų struktūra lentelei `fusion_admin`
--
CREATE TABLE IF NOT EXISTS `fusion_admin` (
`admin_id` tinyint(2) unsigned NOT NULL auto_increment,
`admin_rights` char(2) collate cp1257_lithuanian_ci NOT NULL default '',
`admin_image` varchar(50) collate cp1257_lithuanian_ci NOT NULL default '',
`admin_title` varchar(50) collate cp1257_lithuanian_ci NOT NULL default '',
`admin_link` varchar(100) collate cp1257_lithuanian_ci NOT NULL default 'reserved',
`admin_page` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1257 COLLATE=cp1257_lithuanian_ci AUTO_INCREMENT=76 ;
--
-- Sukurta duomenų kopija lentelei `fusion_admin`
--
INSERT INTO `fusion_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES
(1, 'AD', 'admins.gif', 'Administratoriai', 'administrators.php', 2),
(4, 'B', 'blacklist.gif', 'Juodasis sÄ…raÅas', 'blacklist.php', 2),
(5, 'C', '', 'Komentarai', 'reserved', 2),
(6, 'CP', 'c-pages.gif', 'PridÄ—tiniai puslapiai', 'custom_pages.php', 1),
(7, 'DB', 'db_backup.gif', 'Duomenų bazės atsarginės kopijos', 'db_backup.php', 3),
(11, 'F', 'forums.gif', 'Forumai', 'forums.php', 1),
(13, 'I', 'infusions.gif', 'Modifikacijos', 'infusions.php', 3),
(14, 'IP', '', 'Modifikacij? panel?s', 'reserved', 3),
(15, 'M', 'members.gif', 'Vartotojai', 'members.php', 2),
(16, 'N', 'news.gif', 'Naujienos', 'news.php', 1),
(18, 'P', 'panels.gif', 'PanelÄ—s', 'panels.php', 3),
(19, 'PH', 'photoalbums.gif', 'Foto albumai', 'photoalbums.php', 1),
(20, 'PI', 'phpinfo.gif', 'PHP info', 'phpinfo.php', 3),
(21, 'PO', 'polls.gif', 'Apklausos', 'polls.php', 1),
(22, 'S', 'shout.gif', 'Å aukykla', 'shoutbox.php', 2),
(25, 'U', 'upgrade.gif', 'Tinklapio atnaujinimas', 'upgrade.php', 3),
(29, 'S1', 'settings.gif', 'PAGRINDINIAI TINKLAPIO NUSTATYMAI', 'settings_main.php', 3),
(30, 'S2', 'settings_time.gif', 'Datos ir laiko nustatymai', 'settings_time.php', 3),
(31, 'S3', 'settings_forum.gif', 'Forumo nustatymai', 'settings_forum.php', 3),
(32, 'S4', 'registration.gif', 'Registracijos nustatymai', 'settings_registration.php', 3),
(33, 'S5', 'photoalbums.gif', 'Foto galerijos nustatymai', 'settings_photo.php', 3),
(34, 'S6', 'settings_misc.gif', 'Įvairūs nustatymai', 'settings_misc.php', 3),
(35, 'S7', 'settings_pm.gif', 'Asmeninių žinuĨių savybės', 'settings_messages.php', 3),
(74, 'IP', 'user_gold.gif', 'TaÅkų sistema', '../infusions/user_gold_panel/admin/index.php', 4),
(75, 'IP', 'infusion_panel.gif', 'Smileys', '../infusions/shoutbox_panel/shoutbox_smilies_admin.php', 4);
-- --------------------------------------------------------
O tam faile yra taip:
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."admin");
$result = dbquery("CREATE TABLE ".$db_prefix."admin (
admin_id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,
admin_rights CHAR(2) NOT NULL DEFAULT '',
admin_image VARCHAR(50) NOT NULL DEFAULT '',
admin_title VARCHAR(50) NOT NULL DEFAULT '',
admin_link VARCHAR(100) NOT NULL DEFAULT 'reserved',
admin_page TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (admin_id)
) TYPE=MyISAM;");
if (!$result) $fail = "1";
|
eini i phpmyadmin ir spaudi sql tada ten nukopini sita visa:
CREATE TABLE prefixasadmin (
admin_id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,
admin_rights CHAR(2) NOT NULL DEFAULT '',
admin_image VARCHAR(50) NOT NULL DEFAULT '',
admin_title VARCHAR(50) NOT NULL DEFAULT '',
admin_link VARCHAR(100) NOT NULL DEFAULT 'reserved',
admin_page TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (admin_id)
) TYPE=MyISAM;"
tada vel i sql ir nukopini sita
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('AD', 'admins.gif', '".$locale['460']."', 'administrators.php', 2)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('AC', 'article_cats.gif', '".$locale['461']."', 'article_cats.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('A', 'articles.gif', '".$locale['462']."', 'articles.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('B', 'blacklist.gif', '".$locale['463']."', 'blacklist.php', 2)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('C', '', '".$locale['464']."', 'reserved', 2)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('CP', 'c-pages.gif', '".$locale['465']."', 'custom_pages.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('DB', 'db_backup.gif', '".$locale['466']."', 'db_backup.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('DC', 'dl_cats.gif', '".$locale['467']."', 'download_cats.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('D', 'dl.gif', '".$locale['468']."', 'downloads.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('FQ', 'faq.gif', '".$locale['469']."', 'faq.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('F', 'forums.gif', '".$locale['470']."', 'forums.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('IM', 'images.gif', '".$locale['471']."', 'images.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('I', 'infusions.gif', '".$locale['472']."', 'infusions.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('IP', '', '".$locale['473']."', 'reserved', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('M', 'members.gif', '".$locale['474']."', 'members.php', 2)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('N', 'news.gif', '".$locale['475']."', 'news.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('NC', 'news_cats.gif', '".$locale['494']."', 'news_cats.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('P', 'panels.gif', '".$locale['476']."', 'panels.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('PH', 'photoalbums.gif', '".$locale['477']."', 'photoalbums.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('PI', 'phpinfo.gif', '".$locale['478']."', 'phpinfo.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('PO', 'polls.gif', '".$locale['479']."', 'polls.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S', 'shout.gif', '".$locale['480']."', 'shoutbox.php', 2)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('SL', 'site_links.gif', '".$locale['481']."', 'site_links.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('SU', 'submissions.gif', '".$locale['482']."', 'submissions.php', 2)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('U', 'upgrade.gif', '".$locale['483']."', 'upgrade.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('UG', 'user_groups.gif', '".$locale['484']."', 'user_groups.php', 2)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('WC', 'wl_cats.gif', '".$locale['485']."', 'weblink_cats.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('W', 'wl.gif', '".$locale['486']."', 'weblinks.php', 1)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S1', 'settings.gif', '".$locale['487']."', 'settings_main.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S2', 'settings_time.gif', '".$locale['488']."', 'settings_time.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S3', 'settings_forum.gif', '".$locale['489']."', 'settings_forum.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S4', 'registration.gif', '".$locale['490']."', 'settings_registration.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S5', 'photoalbums.gif', '".$locale['491']."', 'settings_photo.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S6', 'settings_misc.gif', '".$locale['492']."', 'settings_misc.php', 3)"
INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S7', 'settings_pm.gif', '".$locale['493']."', 'settings_messages.php', 3)";
ir viskas
beje nepamirsk pakeist prefixas i tavoprefixas_
Redagavo 2008 Bir. 11 00:06:56 |