Parašė Narysx· 2008 Bir. 11 00:06:58
#7
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";