| 4ipolino |
08.06.2012 18:49 |
Re: Бафы война и мага
ручками пользоваться не научили? =)
все есть в клиенте пример:
Код:
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('309', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('529', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1393', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1352', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1353', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1354', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1259', '4', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1304', '3', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1460', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1073', '2', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1307', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1243', '6', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1356', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1355', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1357', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('264', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('265', '1', 'all,fighter,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('267', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('349', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('364', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('273', '1', 'all,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('274', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('275', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('305', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('306', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('308', '1', 'all,fighter,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('277', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('307', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('764', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('266', '1', 'all,fighter,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('366', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1077', '3', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1242', '3', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1086', '2', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1240', '3', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1087', '3', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1036', '2', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1268', '3', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1204', '2', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1388', '3', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1389', '3', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1461', '1', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1363', '1', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1284', '3', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1191', '3', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1189', '3', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1392', '3', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1352', '1', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1035', '4', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('363', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('271', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('272', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('310', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('311', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('530', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1087', '3', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1085', '3', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1059', '3', 'all,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1204', '2', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1389', '3', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1461', '1', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1413', '1', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1284', '3', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1191', '3', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1189', '3', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1392', '3', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1259', '4', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1460', '1', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1044', '3', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1078', '6', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1323', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('268', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('269', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('304', '1', 'mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('276', '1', 'all,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('365', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('270', '1', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('4699', '3', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('4700', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1388', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1389', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1461', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1363', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1413', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1284', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1519', '1', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1032', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1033', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1191', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1182', '3', 'all,fighter,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1189', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1392', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1242', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1303', '2', 'all,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1086', '2', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1240', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1087', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1045', '3', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1048', '3', 'all,fighter,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1257', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1068', '3', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1040', '3', 'all,mage,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1268', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1204', '2', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1062', '2', 'all,fighter,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1397', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('4702', '3', 'all');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('4703', '3', 'all,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('825', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('826', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('827', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('828', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('829', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('830', '1', 'all,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1502', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1500', '1', 'all,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1503', '1', 'all,fighter,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('915', '1', 'all,fighter,mage');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1517', '1', 'all,fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1519', '1', 'fighter');
INSERT INTO communitybuff_grp_allowed_buffs VALUES ('1504', '1', 'all,fighter,mage');
дальше сам
п.с HF, есть дубликаты |
