legion war!

[pfj511]

use this script ,so you can see the HP of the legion FLAG

delete from cq_dynanpc where id=30980;
delete from cq_dynanpc where id=30983;
INSERT INTO cq_dynanpc
   (`id`, `ownerid`, `ownertype`, `name`, `type`, `lookface`, `length`, `fat`, `idxserver`, `mapid`, `cellx`, `celly`, `task0`, `task1`, `task2`, `task3`, `task4`, `task5`, `task6`, `task7`, `data0`, `data1`, `data2`, `data3`, `datastr`, `linkid`, `life`, `maxlife`, `base`, `sort`, `itemid`, `size_front`, `size_back`, `size_left`, `size_right`, `defence`, `magic_def`, `owner_name`, `default_owner_name`, `initial_price`, `price`, `deposit`, `buy_ratio`, `fee_type`, `income_value`, `preferential`, `harvest_date`)
VALUES
   (30980, 0, 0, 'synflag', 10, 9800, 0000, 0000, -1, 1100, 470, 610, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 1, 0, 0, 0, '', 0000, 66000000, 66000000, 0000, 01, 0000, 0000, 0000, 0000, 0000, 10000, 10000, '', '', 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO cq_dynanpc
   (`id`, `ownerid`, `ownertype`, `name`, `type`, `lookface`, `length`, `fat`, `idxserver`, `mapid`, `cellx`, `celly`, `task0`, `task1`, `task2`, `task3`, `task4`, `task5`, `task6`, `task7`, `data0`, `data1`, `data2`, `data3`, `datastr`, `linkid`, `life`, `maxlife`, `base`, `sort`, `itemid`, `size_front`, `size_back`, `size_left`, `size_right`, `defence`, `magic_def`, `owner_name`, `default_owner_name`, `initial_price`, `price`, `deposit`, `buy_ratio`, `fee_type`, `income_value`, `preferential`, `harvest_date`)
VALUES
   (30983, 0, 0, 'synstone', 124, 9836, 0000, 0000, -1, 1100, 465, 268, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 0000, 1, 0, 0, 0, '', 0000, 207000000, 207000000, 0000, 01, 0000, 0000, 0000, 0000, 0000, 10000, 10000, '', '', 0, 0, 0, 0, 0, 0, 0, 0);

[nooneatall]

so how do you make legionwar start?
i can only find one file in the server called synwar.cfg and in that i see
2007 1 21:30 2007 1 23:30

and in database cq_action i found a line which looked like this 1~21:30~1~23:30
i renamed it to 1 21:30 1 23:30

but didnt work..

so how to start legionwar

[pfj511]

2.0901 msg support the legion war ,but i dont have the legion war db file ! legion war start 21:30 friday and end 23:30 friday ,concern those db file cq_action cq_dynanpc cq_map cq_npc cq_config cq_trap cq_traptype more db file and sctipt need we to add in ! same with the castle system , we dont know the action type to start it and i dont know how and where to define the time in the db table

there is a way mybe can find this answer ,reserch the MSG ,we can find the table name and the column name of db table ,at least we can find how many column and what the column number type in each table ,someone had find out those table info in the msg : cq_castle cq_building cq_buildingtype cq_castle cq_castle_lev_req and edit ,so the castle system had come true, but i dnot know waht the detail column in it ! only continue to resarch on it!


some legion war action type : only guess


type=226 is if the legion war process ,i guess test query the time in the table
type=224 change the user cell x and cell y to current map ...
type=223 get the exp and catch the leader，and record log synwarenter [userid:%u] [synname:%s] [level:%d] [profession:%d]
type=207 legion war end ，because pop part of code
type=227 query the cq_syndicate
type=205 if ok the code will jump to 207
type=221 query the door in the legion map
type=214 query the data0 number in the dynanpc

which the action type legion war use (still guess )201-230

[nooneatall]

cq_action ID 8820000 is the timer to start and end legionwar (i think)

[pfj511]

no ,we can change the action id !

you can use this script to creat a new legion war door in cq_action

your actionid	0	0	2007	0	destroy~door 26 17 100 2 %map_owner_id 1100 473 775 0 0 0 8410270 0 0 0 0 0 0 0 %id 0 0 0 0 0 0 4 4

you can use another script to run this line ,just add a new action id in cq_action and write a new action id behind another action next!

so you can atk this door

[BetuDM]

pfj511, man, i have one problem, in my server the legion wars dont start, you can help me?
Tanks

[pfj511]

Originally Posted by BetuDM

pfj511, man, i have one problem, in my server the legion wars dont start, you can help me?
Tanks

if you want to start the legion war ,you must use the new db file ! but we dont have except the tq

[BetuDM]

Man, I have Set in the My DB Yours Files, and i have enter in the game, where i enter in the legion map, dont have Gates, Have the Pole and Shield, the sield have Life, but i dont can attack the Shield, i Attack and no have damage, and too dont show's the life of pole and shield.
You can say what i can make?
Tanks:}

[pfj511]

you must use my db file above ,then restart your svr again! btw ,you had use my msg exe which i had release ! after this you will see the flag life . ihad had test it susseed!

[BetuDM]

I need only use the DB file? or need too insert into DB My the codes?

Tanks X)

[pfj511]

insert new code

[E.M.E]

thanks bro..

[magewarior2]

I have problem to :O ... if they win the war, they normal get a reward ?? well not working .... same as PKT (PkTournament) the number's 1 never get there price !!

[magewarior2]

can you help me on the pkt to ? Greetings Magewarior2

[penebang]

Hai..
I have 1 problem with this legion war..
2x i follow legion war, i look at hp shield normal n working.
but i look until that hp shield going 0 this legion war still going n not finish...
until pole broken. can u help me??

K-rEaL [PM]
MyEO