Rx8aDVR0

1ALTER TABLE players ADD gang_id int(11) NOT NULL DEFAULT '-1';
2ALTER TABLE players ADD gang_perm_id int(11) NOT NULL DEFAULT '-1';
3
4ALTER TABLE gangs ADD level int(2) NOT NULL DEFAULT '1';
5ALTER TABLE gangs ADD tag varchar(50) NOT NULL DEFAULT '';
6ALTER TABLE gangs ADD description text NOT NULL;
7ALTER TABLE gangs ADD hq int(11) NOT NULL DEFAULT '-1';
8ALTER TABLE gangs ADD hq_upgrades text NOT NULL;
9ALTER TABLE gangs ADD permission text NOT NULL;
10ALTER TABLE gangs ADD tax int(100) NOT NULL DEFAULT '0';
11ALTER TABLE gangs ADD `type` tinyint(1) NOT NULL DEFAULT '0';
12ALTER TABLE gangs ADD perm_int int(11) NOT NULL DEFAULT '1';
13ALTER TABLE gangs ADD tax_sum int(11) NOT NULL DEFAULT '0';
14ALTER TABLE gangs ADD hq_garage varchar(100) NOT NULL DEFAULT '[]';
15
16UPDATE gangs SET `type`= 1;
17UPDATE gangs SET `description`='""';
18UPDATE gangs SET `hq_upgrades`='"[]"';
19UPDATE gangs SET `permission`='"[[0,`Owner`,[`INVITE`,`KICK`,`HQ`,`DEPOSIT`,`PAYTAX`,`HQSPAWN`,`RANKS`,`WITHDRAW`,`DESCRIPTION`,`TAX`,`DISBAND`,`UPGRADE`,`CHANGEPERMISSION`,`TAG`]],[1,`Member`,[`HQSPAWN`,`PAYTAX`,`DEPOSIT`]]]"';
20UPDATE players P, gangs G SET P.gang_id=G.id, P.gang_perm_id=0 WHERE P.pid = G.owner;
21
22ALTER TABLE gangs DROP COLUMN members;
23ALTER TABLE gangs DROP COLUMN maxmembers;
24ALTER TABLE gangs DROP INDEX name_UNIQUE;
25
26
27CREATE TABLE IF NOT EXISTS `gang_info` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `name` varchar(255) NOT NULL,
30  `value` int(11) NOT NULL DEFAULT '0',
31  PRIMARY KEY (`id`)
32) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
33
34
35INSERT INTO `gang_info` (`id`, `name`, `value`) VALUES
36	(1, 'hideout1', -1),
37	(2, 'hideout2', -1),
38	(3, 'hideout3', -1);
39
40DELIMITER //
41CREATE DEFINER=CURRENT_USER PROCEDURE `deactivateTempGangs`()
42BEGIN
43	UPDATE `gangs` SET `active`= 0 WHERE `type`='0';
44END//
45DELIMITER ;