Heroeo db problem

Page 2 of 2 1 2
12/08/2010 07:38 San-Goku#16
u mean eq lvl 255 or +255 ??..more detail..if u want eq +255..here the script:

Code:
-- ----------------------------
-- +255 With elements equipments
-- ----------------------------



update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=1;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=2;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=3;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=4;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=7;
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=8;

update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=1;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=2;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=3;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=4;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=7;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=8;

update cq_item set type ='1020260' where type=813002;

-- ----------------------------
-- Script End
-- ----------------------------

-- --------------------------------------------
-- For Casual +255 ( with full +255 element ---
-- Script Start --
-- --------------------------------------------

update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=12;
update cq_item set amount = '30000' , amount_limit = '30000' , gem1 = '21' , gem2 = '21', warghostexp = '1536' , ident = '4' , forgename='Nukleus' where player_id=10000001 and position=12;

-- ----------------------------
-- Script End
-- ----------------------------
12/08/2010 08:27 track19#17
how to insert it....i have insert it to my db but nothing happen
12/08/2010 08:34 San-Goku#18
query it..make sure it is ur ID..not other player ID..
12/08/2010 09:49 AziQ#19
maybe someone have to make a guide about this lol .
12/08/2010 10:00 track19#20
u make it
12/08/2010 10:24 AziQ#21
Quote:
update cq_item set eudemon_attack1 ='255', eudemon_attack2 ='255', eudemon_attack3 ='255', eudemon_attack4 ='255', magic3 = '255' , special_effect= '8' where player_id=10000001 and position=1;
why u dont want to learn by yourself .?u can learn by read those sentences .1st is "update cq_item" .thats mean u must enter cq_item .then "set eudemon_attack1 bla3" .thats mean in those 4 column means your earth attack,air attack etc ."magic 3" means your equipment bonus .like +12,+244 etc .special effect .u know what is it rite .?if u not understand about these query u can edit by hand .just enter cq_item and edit it .
12/08/2010 19:24 DEADP00L#22
this is one thing a guide dont need to be made of. This is dealin with common sense which it seems alot of people are lacking.
Page 2 of 2 1 2