[SupremeWeapon]

few things. First i want to add links to the RPG nav that you have included. So it has the BANK and store mods for the cash mod I have installed (ubbux)

I tried adding the stuff but no go it doesnt add to the nav.



also.

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE `rpg_clans`
(
`clanid` int(10) UNSIGNED NOT NULL auto_increment,
`title` varchar(50) NOT NULL DEFAULT '',
`leader` int(10) UNSIGNED NOT NULL DEFAULT '0',
`clanpoints` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`logo` varchar(100) NOT NULL DEFAULT '',
`signature` VARCHAR( 255 ) NOT NULL DEFAULT '',
`ally` MEDIUMTEXT NOT NULL,
`enemy` MEDIUMTEXT NOT NULL,
`members` INT( 10 ) UNSIGNED NOT NULL DEFAULT '1',
`maxmem` tinyint(3) UNSIGNED NOT NULL DEFAULT '5',
`invite` MEDIUMTEXT NOT NULL DEFAULT 'a:0:{}',
`col1` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col2` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col3` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col4` int(10) UNSIGNED NOT NULL DEFAULT '0',
`cm_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`ci_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`rm_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`midiurl` varchar(100) NOT NULL DEFAULT '',
`rank` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`clanid`)
) TYPE=InnoDB;

MySQL Error : BLOB/TEXT column 'invite' can't have a default value
Error Number : 1101

going to try a fix posted for another table. Figured you should know about this error so you can fix it. will edit if the fix doesnt work



edit:

Fix workd for it.

changing

`invite` MEDIUMTEXT NOT NULL DEFAULT 'a:0:{}',

to

`invite` MEDIUMTEXT NOT NULL,