shit

--admin and server

insert into server
values (2,'Rimor')
insert into admin
values (2,'Macrosun')
update server
set a_ID = 2
where name ='rimor'


insert into server
values (1,'Atlantean')
insert into admin
values (1,'Means')
update server
set a_ID = 1
where name ='atlantean'

--category

insert into category
values (1,'Weapon');
insert into category
values (2,'Armor');
insert into category
values (3,'Util');

--ability

insert into abilities
values (1,'Strength')
insert into abilities
values (2,'Agility')
insert into abilities
values (3,'Intelligence')
insert into abilities
values (4,'Max_Health')
insert into abilities
values (5,'Attack')
insert into abilities
values (6,'Defense')

--slot
insert into slot
values (1,'Gloves')
insert into slot
values (2,'Right_Hand')
insert into slot
values (3,'Left Hand')
insert into slot
values (4,'Jacket')
insert into slot
values (5,'Helmet')
insert into slot
values (6,'Boots')
insert into slot
values (7,'Legs')
insert into slot
values (8,'Shoulders')
insert into slot
values (9,'Arms')
insert into slot
values (10,'Body_Armor')
insert into slot
values (11,'Util1')
insert into slot
values (12,'Util2')




insert into player
values ('Milik',220,2,null,'President','27-4-14','30-4-14','27-4-14',null)
insert into player
values ('Siredmund',220,2,null,'President',null,null,'27-4-14',null)
insert into player
values ('Coen',220,2,null,'President',null,null,'27-4-14',null)
insert into player
values ('Crashcz',220,1,null,'Advisor','27-4-14','27-5-14','27-4-14',null)
insert into player
values ('Darkirbiska',220,1,null,'Advisor',null,null,'27-4-14',null)
insert into player
values ('DoDo',220,2,null,'President',null,null,'27-4-14',null)
insert into player
values ('Hellangel',220,1,null,'Advisor',null,null,'27-4-14',null)
insert into player
values ('Kochanska',220,1,null,'President','27-4-14','27-4-15','27-4-14',null)
insert into player
values ('Kvetinka',220,1,null,'President',null,null,'27-4-14',null)
insert into player
values ('Saharinka',220,2,null,'President',null,null,'27-4-14',null)
insert into player
values ('Shadecrash',220,1,null,'President','27-4-14','28-4-14','27-4-14',null)

insert into guild
values ('[Come Get Some]','Approved',2)
insert into guild
values ('[Come Get Some]','Pending',1)
insert into guild
values ('Piskotkas heaven','Approved',1)
insert into guild
values ('Punk','Pending',2)
insert into guild
values ('Riders Of The Lost Org','Pending',2)
insert into guild
values ('Sparta','Approved',2)
insert into guild
values ('Supersonic Electronic','Approved',1)
insert into guild
values ('Czech Anarchy','Approved',2)


insert into player
values ('Tinuska',220,1,'Piskotkas heaven','Applicant',null,null,'27-4-14',1)
insert into player
values ('Nezabudka',220,1,'Piskotkas heaven','Applicant',null,null,'27-4-14',1)
insert into player
values ('Piskotka',220,1,'Piskotkas heaven','Applicant',null,null,'27-4-14',1)
insert into player
values ('Kvetulienka',220,1,'Piskotkas heaven','Applicant',null,null,'27-4-14',1)
insert into player
values ('Jastericka',220,1,'Piskotkas heaven','Applicant',null,null,'27-4-14',1)
insert into player
values ('Baja',220,2,'Sparta','Advisor',null,null,'27-4-14',2)
insert into player
values ('Citymusic',220,2,'Sparta','Applicant',null,null,'27-4-14',2)
insert into player
values ('Dysfunktion',220,2,'Sparta','Applicant',null,null,'27-4-14',2)
insert into player
values ('Fuppet',220,2,'Sparta','Advisor',null,null,'27-4-14',2)
insert into player
values ('Juas',220,2,'Sparta','Advisor',null,null,'27-4-14',2)
insert into player
values ('Mark0',220,2,'Sparta','Advisor',null,null,'27-4-14',2)
insert into player
values ('Alcoydel',220,2,'Punk','Advisor',null,null,'27-4-14',2)
insert into player
values ('Armedkiwi',220,2,'Punk','Applicant',null,null,'27-4-14',2)
insert into player
values ('Fixerinka',100,2,'Punk','Applicant',null,null,'27-4-14',2)
insert into player
values ('Fjelldame',220,2,'Punk','Advisor',null,null,'27-4-14',2)
insert into player
values ('Goreth',13,2,'Punk','Applicant',null,null,'27-4-14',2)
insert into player
values ('Fakjuaol',220,1,'[Come Get Some]','Applicant',null,null,'27-4-14',1)
insert into player
values ('Ruzena',220,1,'[Come Get Some]','Applicant',null,null,'27-4-14',1)
insert into player
values ('Dertoni',220,1,'[Come Get Some]','Applicant',null,null,'27-4-14',1)
insert into player
values ('Listerdave',220,1,'[Come Get Some]','Applicant',null,null,'27-4-14',1)
insert into player
values ('Biaggio',200,2,'Riders of the lost org','Applicant',null,null,'27-4-14',2)
insert into player
values ('Ekulf',100,2,'Riders of the lost org','Applicant',null,null,'27-4-14',2)
insert into player
values ('LLeilla',10,2,'Riders of the lost org','Applicant',null,null,'27-4-14',2)
insert into player
values ('Maywedutza',220,2,'Riders of the lost org','Applicant',null,null,'27-4-14',2)
insert into player
values ('Pixelina',200,2,'Riders of the lost org','Advisor',null,null,'27-4-14',2)
insert into player
values ('Solams',220,2,'Riders of the lost org','Advisor',null,null,'27-4-14',2)
insert into player
values ('Chinagrrl',220,2,'Riders of the lost org','Applicant',null,null,'27-4-14',2)


update player
set Guild_Name = 'Riders Of The Lost Org',Guild_Server_id =2
where player_name = 'Coen'
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Crashcz'
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Darkirbiska'
update player
set Guild_Name = 'Sparta',Guild_Server_id =2
where player_name = 'DoDo'
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Hellangel'
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Kochanska'
update player
set Guild_Name = 'Piskotkas heaven',Guild_Server_id =1
where player_name = 'Kvetinka'
update player
set Guild_Name = 'Punk',Guild_Server_id =2
where player_name = 'Saharinka'
update player
set Guild_Name = 'Supersonic Electronic',Guild_Server_id =1
where player_name = 'Shadecrash'
update player
set Guild_Name = 'Czech Anarchy',Guild_Server_id =2
where player_name = 'Siredmund'
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =2
where player_name = 'Milik'


insert into item
values (1,'Hellspinner', 300,1,2 )
insert into item
values (2,'Combined Commando Helmet',300,2,5)
insert into item
values (3,'Stab Aid',300,3,11)
insert into item
values (4,'Snipers Friend',300,3,12)
insert into item
values (5,'nBall Defensive',100,3,12)
insert into item
values (6,'Dreadloch Shark',300,1,2)
insert into item
values (7,'Shen Sticks',300,1,3)
insert into item
values (8,'Envy of the Xan',300,1,2)
insert into item
values (9,'Mortiig Beater',150,1,2)
insert into item
values (10,'Perennium Blaster',200,1,2)
insert into item
values (11,'DB Chest',250,2,10)
insert into item
values (12,'Alappa Gloves',200,2,1)
insert into item
values (13,'Icy Pads',300,2,8)
insert into item
values (14,'Reanimators Cloak',150,2,4)
insert into item
values (15,'OFAB Arms',300,2,9)
insert into item
values (16,'Biodome ChestWear',300,2,10)
insert into item
values (17,'Combined Sharp Legs',300,2,7)
insert into item
values (18,'Coold Padzz',1,2,8)
insert into item
values (19,'Combined Arithmetic boots',300,2,6)
insert into item
values (20,'Omni Carbon Arms',200,2,9)
insert into item
values(21,'OFAB Gloves',300,2,1)
insert into item
values(22,'Combined Commando gloves',300,2,1)
insert into item
values(23,'Gloves of Aquarius',300,2,1)
insert into item
values(24,'Gloves of Capricorn',300,2,1)
insert into item
values(25,'Protective Wear',300,2,4)
insert into item
values(26,'Blood Soaked Cloak',300,2,4)
insert into item
values(27,'Modified NotuComm',300,2,4)
insert into item
values(28,'Ofab Keeper Backwear',300,2,4)
insert into item
values(29,'Biodome Helmet',300,2,5)
insert into item
values(30,'Ofab Soldiers Helm',150,2,5)
insert into item
values(31,'Beasts headwear',100,2,5)
insert into item
values(32,'Plumbos head',300,2,5)
insert into item
values(33,'Chosen Legs',300,2,7)
insert into item
values(34,'Pants of Gemini',300,2,7)
insert into item
values(35,'Duck Pants',300,2,7)
insert into item
values(36,'Frosty leaves',300,2,7)
insert into item
values(37,'Agent Shirt',300,2,10)
insert into item
values(38,'Augmented Body',200,2,10)
insert into item
values(39,'Basic Vest',134,2,10)
insert into item
values(40,'Combined commando Chest',220,2,10)
insert into item
values(41,'Combined Sharps Chest',1,2,10)




insert into owns
values ('Crashcz',1,1,1)
insert into owns
values ('Crashcz',1,2,2)
insert into owns
values ('Ekulf',2,18,3)
insert into owns
values ('Dysfunktion',2,17,5)
insert into owns
values ('Fakjuaol',1,10,8)
insert into owns
values ('Saharinka',2,20,1)
insert into owns
values ('Fjelldame',2,6,2)
insert into owns
values ('Hellangel',1,7,2)
insert into owns
values ('Fuppet',2,26,1)
insert into owns
values ('Juas',2,25,1)
insert into owns
values ('Baja',2,22,1)
insert into owns
values ('Chinagrrl',2,24,1)
insert into owns
values ('Kvetulienka',1,31,1)
insert into owns
values ('Kochanska',1,39,1)
insert into owns
values ('Kochanska',1,29,1)
insert into owns
values ('Solams',2,32,1)
insert into owns
values ('Solams',2,21,2)
insert into owns
values ('Pixelina',2,8,1)
insert into owns
values ('Mark0',2,14,2)
insert into owns
values ('Shadecrash',1,26,5)
insert into owns
values ('Shadecrash',1,40,3)
insert into owns
values ('Ruzena',1,41,1)
insert into owns
values ('Listerdave',1,33,2)
insert into owns
values ('Nezabudka',1,36,8)
insert into owns
values ('Maywedutza',2,35,1)
insert into owns
values ('LLeilla',2,37,1)
insert into owns
values ('Goreth',2,28,1)
insert into owns
values ('Alcoydel',2,36,5)
insert into owns
values ('Crashcz',1,6,1)
insert into owns
values ('Coen',2,6,1)
insert into owns
values ('Citymusic',2,7,2)
insert into owns
values ('Biaggio',2,5,3)
insert into owns
values ('Dertoni',1,2,1)
insert into owns
values ('DoDo',2,8,2)
insert into owns
values ('Darkirbiska',1,12,1)
insert into owns
values ('Goreth',2,11,1)
insert into owns
values ('Kvetinka',1,13,1)
insert into owns
values ('Kvetinka',1,2,3)


insert into buffs
values(3,5,10)
insert into buffs
values(4,5,100)
insert into buffs
values(5,6,100)
insert into buffs
values(6,5,110)
insert into buffs
values(7,2,100)
insert into buffs
values(8,5,15)
insert into buffs
values(11,4,1000)
insert into buffs
values(12,1,30)
insert into buffs
values(14,3,55)
insert into buffs
values(14,6,12)
insert into buffs
values(15,1,18)
insert into buffs
values(16,4,100)
insert into buffs
values(17,2,10)
insert into buffs
values(19,3,10)
insert into buffs
values(19,5,10)
insert into buffs
values(1,4,300)
insert into buffs
values(1,5,100)
insert into buffs
values(2,5,50)


--neincrement

--admin and server

insert into server
values ('Rimor')
insert into admin
values ('Macrosun',1)



insert into server
values ('Atlantean')
insert into admin
values ('Means',2)


--category

insert into category
values ('Weapon')
insert into category
values ('Armor')
insert into category
values ('Util')

--ability

insert into abilities
values ('Strength')
insert into abilities
values ('Agility')
insert into abilities
values ('Intelligence')
insert into abilities
values ('Max_Health')
insert into abilities
values ('Attack')
insert into abilities
values ('Defense')

--slot
insert into slot
values ('Gloves')
insert into slot
values ('Right_Hand')
insert into slot
values ('Left Hand')
insert into slot
values ('Jacket')
insert into slot
values ('Helmet')
insert into slot
values ('Boots')
insert into slot
values ('Legs')
insert into slot
values ('Shoulders')
insert into slot
values ('Arms')
insert into slot
values ('Body_Armor')
insert into slot
values ('Util1')
insert into slot
values ('Util2')




insert into player
values ('Milik',220,2,null,'President','27-4-14','30-4-14','27-4-14',null)
insert into player
values ('Siredmund',220,2,null,'President',null,null,'27-4-14',null)
insert into player
values ('Coen',220,2,null,'President',null,null,'27-4-14',null)
insert into player
values ('Crashcz',220,1,null,'Advisor','27-4-14','27-5-14','27-4-14',null)
insert into player
values ('Darkirbiska',220,1,null,'Advisor',null,null,'27-4-14',null)
insert into player
values ('DoDo',220,2,null,'President',null,null,'27-4-14',null)
insert into player
values ('Hellangel',220,1,null,'Advisor',null,null,'27-4-14',null)
insert into player
values ('Kochanska',220,1,null,'President','27-4-14','27-4-15','27-4-14',null)
insert into player
values ('Kvetinka',220,1,null,'President',null,null,'27-4-14',null)
insert into player
values ('Saharinka',220,2,null,'President',null,null,'27-4-14',null)
insert into player
values ('Shadecrash',220,1,null,'President','27-4-14','28-4-14','27-4-14',null)

insert into guild
values ('[Come Get Some]','Approved',2)
insert into guild
values ('[Come Get Some]','Pending',1)
insert into guild
values ('Piskotkas heaven','Approved',1)
insert into guild
values ('Punk','Pending',2)
insert into guild
values ('Riders Of The Lost Org','Pending',2)
insert into guild
values ('Sparta','Approved',2)
insert into guild
values ('Supersonic Electronic','Approved',1)
insert into guild
values ('Czech Anarchy','Approved',2)


insert into player
values ('Tinuska',220,1,'Piskotkas heaven','Applicant',null,null,'27-4-14',1)
insert into player
values ('Nezabudka',220,1,'Piskotkas heaven','Applicant',null,null,'27-4-14',1)
insert into player
values ('Piskotka',220,1,'Piskotkas heaven','Applicant',null,null,'27-4-14',1)
insert into player
values ('Kvetulienka',220,1,'Piskotkas heaven','Applicant',null,null,'27-4-14',1)
insert into player
values ('Jastericka',220,1,'Piskotkas heaven','Applicant',null,null,'27-4-14',1)
insert into player
values ('Baja',220,2,'Sparta','Advisor',null,null,'27-4-14',2)
insert into player
values ('Citymusic',220,2,'Sparta','Applicant',null,null,'27-4-14',2)
insert into player
values ('Dysfunktion',220,2,'Sparta','Applicant',null,null,'27-4-14',2)
insert into player
values ('Fuppet',220,2,'Sparta','Advisor',null,null,'27-4-14',2)
insert into player
values ('Juas',220,2,'Sparta','Advisor',null,null,'27-4-14',2)
insert into player
values ('Mark0',220,2,'Sparta','Advisor',null,null,'27-4-14',2)
insert into player
values ('Alcoydel',220,2,'Punk','Advisor',null,null,'27-4-14',2)
insert into player
values ('Armedkiwi',220,2,'Punk','Applicant',null,null,'27-4-14',2)
insert into player
values ('Fixerinka',100,2,'Punk','Applicant',null,null,'27-4-14',2)
insert into player
values ('Fjelldame',220,2,'Punk','Advisor',null,null,'27-4-14',2)
insert into player
values ('Goreth',13,2,'Punk','Applicant',null,null,'27-4-14',2)
insert into player
values ('Fakjuaol',220,1,'[Come Get Some]','Applicant',null,null,'27-4-14',1)
insert into player
values ('Ruzena',220,1,'[Come Get Some]','Applicant',null,null,'27-4-14',1)
insert into player
values ('Dertoni',220,1,'[Come Get Some]','Applicant',null,null,'27-4-14',1)
insert into player
values ('Listerdave',220,1,'[Come Get Some]','Applicant',null,null,'27-4-14',1)
insert into player
values ('Biaggio',200,2,'Riders of the lost org','Applicant',null,null,'27-4-14',2)
insert into player
values ('Ekulf',100,2,'Riders of the lost org','Applicant',null,null,'27-4-14',2)
insert into player
values ('LLeilla',10,2,'Riders of the lost org','Applicant',null,null,'27-4-14',2)
insert into player
values ('Maywedutza',220,2,'Riders of the lost org','Applicant',null,null,'27-4-14',2)
insert into player
values ('Pixelina',200,2,'Riders of the lost org','Advisor',null,null,'27-4-14',2)
insert into player
values ('Solams',220,2,'Riders of the lost org','Advisor',null,null,'27-4-14',2)
insert into player
values ('Chinagrrl',220,2,'Riders of the lost org','Applicant',null,null,'27-4-14',2)


update player
set Guild_Name = 'Riders Of The Lost Org',Guild_Server_id =2
where player_name = 'Coen'
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Crashcz'
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Darkirbiska'
update player
set Guild_Name = 'Sparta',Guild_Server_id =2
where player_name = 'DoDo'
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Hellangel'
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Kochanska'
update player
set Guild_Name = 'Piskotkas heaven',Guild_Server_id =1
where player_name = 'Kvetinka'
update player
set Guild_Name = 'Punk',Guild_Server_id =2
where player_name = 'Saharinka'
update player
set Guild_Name = 'Supersonic Electronic',Guild_Server_id =1
where player_name = 'Shadecrash'
update player
set Guild_Name = 'Czech Anarchy',Guild_Server_id =2
where player_name = 'Siredmund'
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =2
where player_name = 'Milik'


insert into item
values ('Hellspinner', 300,1,2 )
insert into item
values ('Combined Commando Helmet',300,2,5)
insert into item
values ('Stab Aid',300,3,11)
insert into item
values ('Snipers Friend',300,3,12)
insert into item
values ('nBall Defensive',100,3,12)
insert into item
values ('Dreadloch Shark',300,1,2)
insert into item
values ('Shen Sticks',300,1,3)
insert into item
values ('Envy of the Xan',300,1,2)
insert into item
values ('Mortiig Beater',150,1,2)
insert into item
values ('Perennium Blaster',200,1,2)
insert into item
values ('DB Chest',250,2,10)
insert into item
values ('Alappa Gloves',200,2,1)
insert into item
values ('Icy Pads',300,2,8)
insert into item
values ('Reanimators Cloak',150,2,4)
insert into item
values ('OFAB Arms',300,2,9)
insert into item
values ('Biodome ChestWear',300,2,10)
insert into item
values ('Combined Sharp Legs',300,2,7)
insert into item
values ('Coold Padzz',1,2,8)
insert into item
values ('Combined Arithmetic boots',300,2,6)
insert into item
values ('Omni Carbon Arms',200,2,9)
insert into item
values('OFAB Gloves',300,2,1)
insert into item
values('Combined Commando gloves',300,2,1)
insert into item
values('Gloves of Aquarius',300,2,1)
insert into item
values('Gloves of Capricorn',300,2,1)
insert into item
values('Protective Wear',300,2,4)
insert into item
values('Blood Soaked Cloak',300,2,4)
insert into item
values('Modified NotuComm',300,2,4)
insert into item
values('Ofab Keeper Backwear',300,2,4)
insert into item
values('Biodome Helmet',300,2,5)
insert into item
values('Ofab Soldiers Helm',150,2,5)
insert into item
values('Beasts headwear',100,2,5)
insert into item
values('Plumbos head',300,2,5)
insert into item
values('Chosen Legs',300,2,7)
insert into item
values('Pants of Gemini',300,2,7)
insert into item
values('Duck Pants',300,2,7)
insert into item
values('Frosty leaves',300,2,7)
insert into item
values('Agent Shirt',300,2,10)
insert into item
values('Augmented Body',200,2,10)
insert into item
values('Basic Vest',134,2,10)
insert into item
values('Combined commando Chest',220,2,10)
insert into item
values('Combined Sharps Chest',1,2,10)




insert into owns
values ('Crashcz',1,1,1)
insert into owns
values ('Crashcz',1,2,2)
insert into owns
values ('Ekulf',2,18,3)
insert into owns
values ('Dysfunktion',2,17,5)
insert into owns
values ('Fakjuaol',1,10,8)
insert into owns
values ('Saharinka',2,20,1)
insert into owns
values ('Fjelldame',2,6,2)
insert into owns
values ('Hellangel',1,7,2)
insert into owns
values ('Fuppet',2,26,1)
insert into owns
values ('Juas',2,25,1)
insert into owns
values ('Baja',2,22,1)
insert into owns
values ('Chinagrrl',2,24,1)
insert into owns
values ('Kvetulienka',1,31,1)
insert into owns
values ('Kochanska',1,39,1)
insert into owns
values ('Kochanska',1,29,1)
insert into owns
values ('Solams',2,32,1)
insert into owns
values ('Solams',2,21,2)
insert into owns
values ('Pixelina',2,8,1)
insert into owns
values ('Mark0',2,14,2)
insert into owns
values ('Shadecrash',1,26,5)
insert into owns
values ('Shadecrash',1,40,3)
insert into owns
values ('Ruzena',1,41,1)
insert into owns
values ('Listerdave',1,33,2)
insert into owns
values ('Nezabudka',1,36,8)
insert into owns
values ('Maywedutza',2,35,1)
insert into owns
values ('LLeilla',2,37,1)
insert into owns
values ('Goreth',2,28,1)
insert into owns
values ('Alcoydel',2,36,5)
insert into owns
values ('Crashcz',1,6,1)
insert into owns
values ('Coen',2,6,1)
insert into owns
values ('Citymusic',2,7,2)
insert into owns
values ('Biaggio',2,5,3)
insert into owns
values ('Dertoni',1,2,1)
insert into owns
values ('DoDo',2,8,2)
insert into owns
values ('Darkirbiska',1,12,1)
insert into owns
values ('Goreth',2,11,1)
insert into owns
values ('Kvetinka',1,13,1)
insert into owns
values ('Kvetinka',1,2,3)


insert into buffs
values(3,5,10)
insert into buffs
values(4,5,100)
insert into buffs
values(5,6,100)
insert into buffs
values(6,5,110)
insert into buffs
values(7,2,100)
insert into buffs
values(8,5,15)
insert into buffs
values(11,4,1000)
insert into buffs
values(12,1,30)
insert into buffs
values(14,3,55)
insert into buffs
values(14,6,12)
insert into buffs
values(15,1,18)
insert into buffs
values(16,4,100)
insert into buffs
values(17,2,10)
insert into buffs
values(19,3,10)
insert into buffs
values(19,5,10)
insert into buffs
values(1,4,300)
insert into buffs
values(1,5,100)
insert into buffs
values(2,5,50)

--new fixed
insert into player
values ('Tinuska',220,1,'Piskotkas heaven','Applicant',null,null,'27-april-14',1);
insert into player
values ('Nezabudka',220,1,'Piskotkas heaven','Applicant',null,null,'27-april-14',1);
insert into player
values ('Piskotka',220,1,'Piskotkas heaven','Applicant',null,null,'27-april-14',1);
insert into player
values ('Kvetulienka',220,1,'Piskotkas heaven','Applicant',null,null,'27-april-14',1);
insert into player
values ('Jastericka',220,1,'Piskotkas heaven','Applicant',null,null,'27-april-14',1);
insert into player
values ('Baja',220,2,'Sparta','Advisor',null,null,'27-april-14',2);
insert into player
values ('Citymusic',220,2,'Sparta','Applicant',null,null,'27-april-14',2);
insert into player
values ('Dysfunktion',220,2,'Sparta','Applicant',null,null,'27-april-14',2);
insert into player
values ('Fuppet',220,2,'Sparta','Advisor',null,null,'27-april-14',2);
insert into player
values ('Juas',220,2,'Sparta','Advisor',null,null,'27-april-14',2);
insert into player
values ('Mark0',220,2,'Sparta','Advisor',null,null,'27-april-14',2);
insert into player
values ('Alcoydel',220,2,'Punk','Advisor',null,null,'27-april-14',2);
insert into player
values ('Armedkiwi',220,2,'Punk','Applicant',null,null,'27-april-14',2);
insert into player
values ('Fixerinka',100,2,'Punk','Applicant',null,null,'27-april-14',2);
insert into player
values ('Fjelldame',220,2,'Punk','Advisor',null,null,'27-april-14',2);
insert into player
values ('Goreth',13,2,'Punk','Applicant',null,null,'27-april-14',2);
insert into player
values ('Fakjuaol',220,1,'[Come Get Some]','Applicant',null,null,'27-april-14',1);
insert into player
values ('Ruzena',220,1,'[Come Get Some]','Applicant',null,null,'27-april-14',1);
insert into player
values ('Dertoni',220,1,'[Come Get Some]','Applicant',null,null,'27-april-14',1);
insert into player
values ('Listerdave',220,1,'[Come Get Some]','Applicant',null,null,'27-april-14',1);
insert into player
values ('Biaggio',200,2,'Riders Of The Org','Applicant',null,null,'27-april-14',2);
insert into player
values ('Ekulf',100,2,'Riders Of The Org','Applicant',null,null,'27-april-14',2);
insert into player
values ('LLeilla',10,2,'Riders Of The Org','Applicant',null,null,'27-april-14',2);
insert into player
values ('Maywedutza',220,2,'Riders Of The Org','Applicant',null,null,'27-april-14',2);
insert into player
values ('Pixelina',200,2,'Riders Of The Org','Advisor',null,null,'27-april-14',2);
insert into player
values ('Solams',220,2,'Riders Of The Org','Advisor',null,null,'27-april-14',2);
insert into player
values ('Chinagrrl',220,2,'Riders Of The Org','Applicant',null,null,'27-april-14',2);



insert into player
values ('Milik',220,2,null,'President','27-april-14','30-april-14','27-april-14',null);
insert into player
values ('Siredmund',220,2,null,'President',null,null,'27-april-14',null);
insert into player
values ('Coen',220,2,null,'President',null,null,'27-april-14',null);
insert into player
values ('Crashcz',220,1,null,'Advisor','27-april-14','27-may-14','27-april-14',null);
insert into player
values ('Darkirbiska',220,1,null,'Advisor',null,null,'27-april-14',null);
insert into player
values ('DoDo',220,2,null,'President',null,null,'27-april-14',null);
insert into player
values ('Hellangel',220,1,null,'Advisor',null,null,'27-april-14',null);
insert into player
values ('Kochanska',220,1,null,'President','27-april-14','27-april-15','27-april-14',null);
insert into player
values ('Kvetinka',220,1,null,'President',null,null,'27-april-14',null);
insert into player
values ('Saharinka',220,2,null,'President',null,null,'27-april-14',null);
insert into player
values ('Shadecrash',220,1,null,'President','27-april-14','28-april-14','27-april-14',null);


update player
set Guild_Name = 'Riders Of The Org',Guild_Server_id =2
where player_name = 'Coen';
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Crashcz';
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Darkirbiska';
update player
set Guild_Name = 'Sparta',Guild_Server_id =2
where player_name = 'DoDo';
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Hellangel';
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =1
where player_name = 'Kochanska';
update player
set Guild_Name = 'Piskotkas heaven',Guild_Server_id =1
where player_name = 'Kvetinka';
update player
set Guild_Name = 'Punk',Guild_Server_id =2
where player_name = 'Saharinka';
update player
set Guild_Name = 'Supersonic',Guild_Server_id =1
where player_name = 'Shadecrash';
update player
set Guild_Name = 'Czech Anarchy',Guild_Server_id =2
where player_name = 'Siredmund';
update player
set Guild_Name = '[Come Get Some]',Guild_Server_id =2
where player_name = 'Milik';


insert into item
values ('','Hellspinner', 300,1,2 );
insert into item
values ('','Combined Comm Helm',300,2,5);
insert into item
values ('','Stab Aid',300,3,11);
insert into item
values ('','Snipers Friend',300,3,12);
insert into item
values ('','nBall Defensive',100,3,12);
insert into item
values ('','Dreadloch Shark',300,1,2);
insert into item
values ('','Shen Sticks',300,1,3);
insert into item
values ('','Envy of the Xan',300,1,2);
insert into item
values ('','Mortiig Beater',150,1,2);
insert into item
values ('','Perennium Blaster',200,1,2);
insert into item
values ('','DB Chest',250,2,10);
insert into item
values ('','Alappa Gloves',200,2,1);
insert into item
values ('','Icy Pads',300,2,8);
insert into item
values ('','Reanimators Cloak',150,2,4);
insert into item
values ('','OFAB Arms',300,2,9);
insert into item
values ('','Biodome ChestWear',300,2,10);
insert into item
values ('','Combined Sharp Legs',300,2,7);
insert into item
values ('','Coold Padzz',1,2,8);
insert into item
values ('','Combined Arithmetic',300,2,6);
insert into item
values ('','Omni Carbon Arms',200,2,9);
insert into item
values('','OFAB Gloves',300,2,1);
insert into item
values('','Combined gloves',300,2,1);
insert into item
values('','Gloves of Aquarius',300,2,1);
insert into item
values('','Gloves of Capricorn',300,2,1);
insert into item
values('','Protective Wear',300,2,4);
insert into item
values('','Blood Soaked Cloak',300,2,4);
insert into item
values('','Modified NotuComm',300,2,4);
insert into item
values('','Ofab Keeper Backwear',300,2,4);
insert into item
values('','Biodome Helmet',300,2,5);
insert into item
values('','Ofab Soldiers Helm',150,2,5);
insert into item
values('','Beasts headwear',100,2,5);
insert into item
values('','Plumbos head',300,2,5);
insert into item
values('','Chosen Legs',300,2,7);
insert into item
values('','Pants of Gemini',300,2,7);
insert into item
values('','Duck Pants',300,2,7);
insert into item
values('','Frosty leaves',300,2,7);
insert into item
values('','Agent Shirt',300,2,10);
insert into item
values('','Augmented Body',200,2,10);
insert into item
values('','Basic Vest',134,2,10);
insert into item
values('','Combined Chest',220,2,10);
insert into item
values('','Combined Sharps',1,2,10);