hi all, i am hoping you can help me with this problem i am having when add this mod/hack it's telling me to add
ALTER TABLE `nuke_bbforums` ADD `forum_icon` VARCHAR( 255 ) default NULL; to my SQL databas
so here is what i am doing i go to nuk_bbforums using php my admin export the table then dropping/delete the table then i add that line to the exported table then i try to import it but get an error am i just doing some thing completely wrong ?
here is the un moded table "sorry if this gets to long" can anyone help me out pls :D
-- phpMyAdmin SQL Dump
-- version 2.11.9.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 14, 2009 at 10:43 PM
-- Server version: 5.0.77
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `sixsixsi_nuke1`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_bbforums`
--
CREATE TABLE IF NOT EXISTS `nuke_bbforums` (
`forum_id` smallint(5) unsigned NOT NULL auto_increment,
`cat_id` mediumint(8) unsigned NOT NULL default '0',
`forum_name` varchar(150) default NULL,
`forum_desc` text,
`forum_status` tinyint(4) NOT NULL default '0',
`forum_order` mediumint(8) unsigned NOT NULL default '1',
`forum_posts` mediumint(8) unsigned NOT NULL default '0',
`forum_topics` mediumint(8) unsigned NOT NULL default '0',
`forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
`prune_next` int(11) default NULL,
`prune_enable` tinyint(1) NOT NULL default '1',
`auth_view` tinyint(2) NOT NULL default '0',
`auth_read` tinyint(2) NOT NULL default '0',
`auth_post` tinyint(2) NOT NULL default '0',
`auth_reply` tinyint(2) NOT NULL default '0',
`auth_edit` tinyint(2) NOT NULL default '0',
`auth_delete` tinyint(2) NOT NULL default '0',
`auth_sticky` tinyint(2) NOT NULL default '0',
`auth_announce` tinyint(2) NOT NULL default '0',
`auth_vote` tinyint(2) NOT NULL default '0',
`auth_pollcreate` tinyint(2) NOT NULL default '0',
`auth_attachments` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`forum_id`),
KEY `forums_order` (`forum_order`),
KEY `cat_id` (`cat_id`),
KEY `forum_last_post_id` (`forum_last_post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;
--
-- Dumping data for table `nuke_bbforums`
--
INSERT INTO `nuke_bbforums` (`forum_id`, `cat_id`, `forum_name`, `forum_desc`, `forum_status`, `forum_order`, `forum_posts`, `forum_topics`, `forum_last_post_id`, `prune_next`, `prune_enable`, `auth_view`, `auth_read`, `auth_post`, `auth_reply`, `auth_edit`, `auth_delete`, `auth_sticky`, `auth_announce`, `auth_vote`, `auth_pollcreate`, `auth_attachments`) VALUES
(1, 1, 'Introduction', 'If you want to apply being a 666 member, you have to introduce yourself!', 0, 10, 500, 129, 6247, NULL, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 0),
(2, 1, 'Six Six Six Alliances', 'Alliance Meeting is at here. Keep on posting...', 0, 20, 52, 13, 6366, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(3, 2, 'News of Kinship', 'News and information regarding the kin \r\n', 0, 10, 329, 33, 6523, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(4, 2, 'Kin-Chest inventory', 'What do we have?', 0, 20, 2, 2, 4215, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(7, 2, 'Fellowship Quests', 'Build a group for instances, class quests and epic quests ', 0, 50, 116, 28, 5751, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(8, 2, 'Crafting', 'Job for each member and also here is a place that you can ask your needs for crafting from Kin members\r\n\r\n', 0, 60, 21, 8, 6142, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(10, 3, 'Six Six Six News', 'News about all the Community', 0, 30, 187, 48, 6584, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(11, 3, 'General Banter', 'Talk about everything in here', 0, 40, 969, 158, 6585, NULL, 0, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1, 0),
(43, 3, 'Holidays & Absences', '', 0, 60, 29, 9, 6578, NULL, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 0),
(13, 3, 'Suggestions & Ideas', 'Use this forum to submit your suggestions and ideas for our forum(site) and games.', 0, 70, 81, 18, 5678, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(16, 4, 'Dawn of War I', 'Division Head Solar Ice', 0, 20, 77, 20, 6052, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(17, 5, 'Officer Chat', '', 0, 10, 1311, 190, 6583, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(24, 3, 'Hints & Tips', '', 0, 50, 22, 11, 6472, NULL, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 0),
(25, 7, 'Warden', 'Head of Warden is None', 0, 10, 8, 4, 3130, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(26, 7, 'Rune Keeper', 'Head of Rune-Keeper is None', 0, 20, 8, 3, 3990, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(22, 2, 'Raid Tips & Techniques ', '', 0, 30, 19, 6, 5854, NULL, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 0),
(23, 8, 'Community Events', 'Kinship Raids & Clan Matches', 0, 20, 480, 46, 6577, NULL, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 0),
(27, 7, 'Minstrel ', 'Head of Minstrel is Dorori', 0, 30, 6, 3, 4539, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(28, 7, 'Guardian', 'Head of Guardian is Reavor', 0, 40, 14, 7, 6460, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(29, 7, 'Lore-master', 'Head of Lore-master is Ardaniel', 0, 50, 4, 2, 3450, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(30, 7, 'Hunter ', 'Head of Hunter is Telladan', 0, 60, 10, 6, 3945, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(31, 7, 'Champion ', 'Head of Champion is Wormweed', 0, 70, 21, 7, 6509, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(32, 7, 'Captain ', 'Head of Captain is Maximums', 0, 80, 23, 9, 6285, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(33, 7, 'Burglar ', 'Head of Burglar is Mongon', 0, 90, 27, 5, 5362, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(44, 4, 'Dawn Of War II', 'Division Head Black Wind', 0, 30, 14, 4, 5827, NULL, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 0),
(34, 5, 'Clan Officer Chat', '', 0, 20, 77, 12, 5856, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(35, 4, 'Clan News', 'News about the clan', 0, 10, 97, 18, 6545, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(37, 4, 'Challenge Us!!', 'challenge the clan or just a member to a game', 0, 60, 73, 6, 5135, NULL, 0, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1, 0),
(38, 4, 'Other Games', 'Other Games That Some Of us Play', 0, 50, 83, 24, 6566, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(39, 4, 'Call Of Duty 4', 'Division Head Ardbeg', 0, 40, 93, 9, 6002, NULL, 0, 0, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(40, 5, 'Recruitment and Players', '', 0, 30, 77, 22, 6558, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(45, 5, 'Admin Info', 'Information about the website', 0, 40, 8, 2, 6580, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 0),
(42, 3, 'Community Charter', '', 0, 10, 5, 5, 6194, NULL, 0, 0, 0, 3, 3, 3, 3, 2, 3, 3, 3, 0);
|
38.107.179.216
