Clan Hack

This hack was requested HERE

Basically, this hack adds a clan system to your vbulletin. Everything is controlled from the usercp. When a user goes to edit his/her profile, there is an additional "clan password" field. Clan leaders should give out the password to clan members. If the password matches one of an exsisting clan, they are added to that clan. There is more information in the request thread.

HACK STATS:

Templates to add: 5
Templates to edit: 2
Files to upload: 3
Files to edit: 3

This includes an easy to follow install guide and installer. Screenshots are below:

Addition to the administration CP

EDIT/ADD CLAN SCREEN

Admin CP clan list screen

Entering clan password in user cp (ignore the image thing, that's a different hack)

List of clans

List of users in that clan

Postbit Stuff


Enjoy the hack!

If you get any errors, please tell me

[DRR]

Nice one
i might be able to use this in the future

[kaotic]

Perfect! This will help organize some of the groups in my message board. I'll try this out as soon as my site is no longer suspended.

[Dan]

thanks I'll go install it now

/me clicks install

[Dan]

This is trying to be installed on my testboard btw....

I get an error in the install script

First before I sign into it
Warning: Cannot add header information - headers already sent by (output started at /home/eternalgamer/www/eg/forums/admin/clan_install.php:2) in /home/eternalgamer/www/eg/forums/admin/functions.php on line 1683

and after when its running the querys

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: CREATE TABLE clan (
clanid smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
title varchar(50) NOT NULL,
pass varchar(50) NOT NULL,
leader varchar(50) NOT NULL,
)
mysql error: You have an error in your SQL syntax near ')' at line 6

mysql error number: 1064

Date: Sunday 13th of April 2003 09:27:18 AM
Script: http://www.eternalgamers.com/eg/foru...p?where=clandb
Referer: http://www.eternalgamers.com/eg/foru...?where=install

[The_Cyberdemon]

Don't worry about the header information, that shouldn't be a problem. It just does that becuase i don't have the sessionhash. That is very very strange. I don't know why it would do that. I don't have that problem, and there is no error there. If you'd like, you can just go and run this query on ur db:

CREATE TABLE `clan` (
`clanid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 50 ) NOT NULL ,
`pass` VARCHAR( 50 ) NOT NULL ,
`leader` VARCHAR( 50 ) NOT NULL 
);

That does basically the same thing.
And i'll ask someone on the irc, too.
Are you running these queries in your database or through the installer, by clicking "next." IT installs it automatically. And i have the full code there being:
$DB_site->query("CREATE TABLE clan (
blah,
blahh
blah
blah
) ");

[The_Cyberdemon]

Okay, i know the error, and i know why only you are getting it. I think you have a earlier version of mysql. mine ignores ending commas. Urs doesnt. So... open up clan_install.php.

FIND:

   pass varchar(50) NOT NULL,
   leader varchar(50) NOT NULL,

REPLACE THAT WITH:

   pass varchar(50) NOT NULL,
   leader varchar(50) NOT NULL

It should work. =)

[Brian Briscoe]

Im gonna modify this for 3.0.0 when it is released

[The_Cyberdemon]

yay :banana:

[Dan]

there works perfectly thanks!