That is a real downer. I have almost 70 clans listed. Looks like I'll be sticking with v1. :)

well, i actually could make an upgrade script, shouldn't be too hard. Just need to go through and add some columns. I'll get on that, but, make sure you do not add any clans until you upgrade, might screw it up. I'll go ahead and make that tonight, have it out tomorrow. =)

Ah my friend, that is excellent news. Thank you very much. I've been playing around with vB3, the usergroup functionality doesn't match up to this hack.

also adding an install/uninstall script (for your convinience :nervous: )
+ Clan Invites
+ Display Clans user is in with a dropdown in the postbit
+ Display all of the clan logos the user is in (Dunno how this will make any sense if the logos are too big, but, whatever)

Hey mate, can you briefly explain how I can achieve the same as this in vB3 with public usergroups? I'm not sure how the whole thing works, and am not sure how I can achieve the same goals as your hack.

I haven't used vb3 yet, so i'm not sure how to use public usergroups or anything, but i heard that this is very similar, which is why i added all of this extra crap.

If anyone has anything they still want me to do (i haven't done anything in a while) lemme know and i'll set it up.

I'm getting an error when trying to run the queries:

CREATE TABLE `clanrank` (
`id` smallint(10) unsigned NOT NULL auto_increment,
`clanid` smallint(10) NOT NULL default \'0\',
`title` varchar(30) NOT NULL default \'\',
`spot` smallint(10) NOT NULL default \'1\',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

MySQL said:

You have an error in your SQL syntax near '\'0\',
`title` varchar(30) NOT NULL default \'\',
`spot` smallint(10) NOT ' at line 3

HELP!

I was as much of a vB3 sceptic as anyone. I planned to stay on vB2 until all the hacks I needed were converted. I didn't, and I don't regret it at all!

Well, i'm redesigning this for vb3, hope you guys are happy.

I am extremely happy. Thanks very much. :)