GuildWar 5095

~~Sp|dEr~~ · 09/01/2010, 10:18

hello guys ...

i was planing to make 2 guild wars per each week

i mean ... make another guild war starts at Tuesday and ends at Wednesday at 9 o'clock like witch starts at Saturday and ends at Sunday at 9 O'clock .

and i searched and i found this ...

ــــــــــــــــــــــــــــــــــــــــــــــــــ ــــــــــــــــــــــــــــــــــــــــــــــــــ ــــــــــــــــــــــــــــــــــــــــ

Code:

UPDATE cq_action SET param="What~can~I~do~for~you?" WHERE id=30700;
UPDATE cq_action SET param="Enter~the~guild~area. 30710" WHERE id=30701;
UPDATE cq_action SET param="Buy~statue 30720" WHERE id=30702;
UPDATE cq_action SET param="Just~passing~by 0" WHERE id=30703;
UPDATE cq_action SET param="A~statue~costs~50,000~silver.~Are~you~sure~that~you~want~to~buy?" WHERE id=30720;
UPDATE cq_action SET param="Yeach. 30730" WHERE id=30721;
UPDATE cq_action SET param="No,~thanks. 0" WHERE id=30722;
UPDATE cq_action SET param="You~don't~have~the~money." WHERE id=30731;
UPDATE cq_action SET param="Oh,~sry. 0" WHERE id=30732;
UPDATE cq_action SET param="There~is~guildwar~time.~Are~you~sure~you~wanna~enter?" WHERE id=7001600;
UPDATE cq_action SET param="Positive. 7001603" WHERE id=7001601;
UPDATE cq_action SET param="Oh,~thanks~for~info. 0" WHERE id=7001602;
UPDATE cq_action SET param="Are~you~going~to~leave~here?" WHERE id=5030001;
UPDATE cq_action SET param="Yes. 5030004" WHERE id=5030002;
UPDATE cq_action SET param="No.~Wait~a~moment. 0" WHERE id=5030003;

UPDATE cq_action SET param="Are~you~going~to~leave~here?" WHERE id=5030001;
UPDATE cq_action SET param="Yes. 5030004" WHERE id=5030002;
UPDATE cq_action SET param="No.~Wait~a~moment. 0" WHERE id=5030003;

UPDATE cq_npc SET name="GuildChief", cellx=0438, celly=0377 WHERE id=4362;
UPDATE cq_action SET param="1970-01-01 00:00 2008-05-23 23:59" WHERE id=7234100;
UPDATE cq_action SET param="Okeyz 0" WHERE id=7234104;
UPDATE cq_action SET param="There~will~be~proper~date~and~time~when~I~could~offer~GuildLeaders~who~won~GuildWar~special~prices~and~rewards." WHERE id=7234101;
UPDATE cq_action SET param="" WHERE id=7234102;
UPDATE cq_action SET param="..." WHERE id=7234102;
UPDATE cq_action SET param="Oh~yea~check~website~for~that~term." WHERE id=7234103;
UPDATE cq_action SET param="1970-04-19 00:00 2008-05-23 23:59" WHERE id=7234100;
UPDATE cq_action SET param="Greetings,~conquerer!~Yet~another~Guild~War~Contest~is~being~help~now.~Before~end~of~this~special~contest,~the~winner~" WHERE id=7234120;
UPDATE cq_action SET param="guild~in~each~week~will~receive~Lord~Token~and~3k~CPs!~There~will~be~5~Lord~Tokens~in~the~contest.~Depending~on~how~many" WHERE id=7234121;
UPDATE cq_action SET param="Lord~Tokens~you~have,~special~rewards~and~CPs~are~avaiable!~Prepare~yourselves~for~the~fight!" WHERE id=7234122;
UPDATE cq_action SET param="!" WHERE id=7234123;
UPDATE cq_action SET param="Lord~Tokens~you~have,~special~rewards~and~CPs~are~avaiable!~Prepare~yourselves~for~the~fight" WHERE id=7234122;
UPDATE cq_action SET param="~" WHERE id=7234124;
UPDATE cq_action SET param="Tell~me~more 7234150" WHERE id=7234125;
UPDATE cq_action SET param="A~Lord~Token~can~be~exchanged~for~Bronze~Prize~and~3k~CPs.~Two~Lord~Tokens~can~be~exchanged~for~Silver~Prize~and~6k~CPs.~" WHERE id=7234150;
UPDATE cq_action SET param="Three~Lord~Tokens~can~be~exchanged~for~a~Gold~Prize~and~20k~CPs.~The~Gold~Prize~means~you~" WHERE id=7234151;
UPDATE cq_action SET param="are~the~winner~of~The~Guild~War~Contest" WHERE id=7234152;
UPDATE cq_action SET param="!" WHERE id=7234153;
UPDATE cq_action SET param="What~are~these~prizes~for? 7234160" WHERE id=7234154;
UPDATE cq_action SET param="I~cannot~keep~Gold~Prizes~permanently?~Why? 7234170" WHERE id=7234155;
UPDATE cq_action SET param="I~want~to~claim~my~reward 7234200" WHERE id=7234126;
UPDATE cq_action SET param="Leave 0" WHERE id=7234127;
UPDATE cq_action SET param="is~there~website~info? 7234400" WHERE id=7234128;
UPDATE cq_action SET param="http://????/" WHERE id=7234400;
UPDATE cq_action SET param="Equippong~Bronze~Prize~will~enchance~your~HP~and~MP~by~900~points.~Equipping~Silver~Prize~will~enchance~your~HP~and~MP~by~1200~points." WHERE id=7234160;
UPDATE cq_action SET param="points.~Equipping~Gold~Prize~will~enhance~your~HP~and~MP~by~1500~points,~besides,~you~will~get~1000~" WHERE id=7234161;
UPDATE cq_action SET param="physical~and~magic~attack~plus~1000~physical~defence." WHERE id=7234162;
UPDATE cq_action SET param="~" WHERE id=7234163;
UPDATE cq_action SET param="~" WHERE id=7234163;
UPDATE cq_action SET param="~" WHERE id=7234164;
UPDATE cq_action SET param="Ok~thank~you 0" WHERE id=7234165;
UPDATE cq_action SET param="You~can~claim~rewards~according~to~how~many~Lord~Tokens~you~have.~But,~if~your~guild~might~be~able~to~win~3~Lord~Tokens,~" WHERE id=7234200;
UPDATE cq_action SET param="we~strongly~recommend~you~to~exchange~Gold~Prize~for~them,~because~Gold~Prize~has~more~benefits!~" WHERE id=7234201;
UPDATE cq_action SET param="What~is~more,~12~Gold~Trophies~can~be~exchanged~for~Gold~Cup" WHERE id=7234202;
UPDATE cq_action SET param="!" WHERE id=7234203;
UPDATE cq_action SET param="I~have~1~LordToken 7234250" WHERE id=7234204;
UPDATE cq_action SET param="I~have~2~LordTokens 7234300" WHERE id=7234205;
UPDATE cq_action SET param="I~have~3~LordTokens 7234350" WHERE id=7234206;
UPDATE cq_action SET param="I~want~to~claim~GoldCup 7234180" WHERE id=7234207;
UPDATE cq_action SET param="Is~there~website~info? 7234400" WHERE id=7234128;
UPDATE cq_action SET param="Let~me~think~about~it 0" WHERE id=7234127;
UPDATE cq_action SET param="No,~you~cannot.~The~system~will~automatically~take~your~Gold~Prize~away~before~the~next~Guild~War~Contest,~" WHERE id=7234170;
UPDATE cq_action SET param="but~give~the~owner~Gold~Trophy~in~its~place.~Gold~Trophy~has~better~effect~than~Silver~Prize,~except~that~collecting~" WHERE id=7234171;
UPDATE cq_action SET param="12~Gold~Trophies~will~entitle~you~to~magical~special~Gold~Cup." WHERE id=7234172;
UPDATE cq_action SET param="." WHERE id=7234173;
UPDATE cq_action SET param="~" WHERE id=7234174;
UPDATE cq_action SET param="12~Gold~Trophies~will~entitle~you~to~magical~special~Gold~Cup" WHERE id=7234172;
UPDATE cq_action SET param="Cool!~Thanks 0" WHERE id=7234175;
UPDATE cq_action SET param="I~want~to~claim~my~Gold~Cup 7234180" WHERE id=7234176;
UPDATE cq_action SET param="Let~me~think~it~over 0" WHERE id=7234208;
UPDATE cq_action SET param="12~Gold~Trophies~are~required~to~exchange~for~Gold~Cup." WHERE id=7234181;
UPDATE cq_action SET param="~12~Gold~Trophies~are~required~to~exchange~for~Gold~Cup." WHERE id=7234181;
UPDATE cq_action SET param="Ok~thank~you 0" WHERE id=7234186;
UPDATE cq_action SET param="Great!~Well~if~you~are~sure~I~will~exchange~those~12~Tokens~and~give~you~GoldCup~with~1500~HP~and~MP." WHERE id=7234182;
UPDATE cq_action SET param="~It~will~also~add~to~your~magic~and~physical~attacks~1k~and~enchant~your~defence~by~1k" WHERE id=7234183;
UPDATE cq_action SET param="." WHERE id=7234184;
UPDATE cq_action SET param="Yes,~give~it~to~me~pls 7234190" WHERE id=7234185;
UPDATE cq_action SET param="%user_name gained 12 LordTokens and gained GoldCup[T]" WHERE id=7234193;
UPDATE cq_action SET param="1970-01-01 00:00 2008-05-23 23:59" WHERE id=7234100;
UPDATE cq_action SET param="1970-04-19 00:00 2008-05-23 23:59" WHERE id=7234100;

UPDATE cq_action SET param="Congratulations! You have gained 888888 gold" WHERE id=7547922;
UPDATE cq_action SET param="Congratulations! You have gained 88888 gold" WHERE id=7547917;
UPDATE cq_action SET param="Congratulations! You have gained 88888 gold" WHERE id=7547912;
UPDATE cq_action SET param="Congratulations! You have gained 888888 gold" WHERE id=7547917;

UPDATE cq_action SET param="What~can~I~do~for~you?" WHERE id=150010;
UPDATE cq_action SET param="Heal~this~Stone~Pillar 150020" WHERE id=150011;
UPDATE cq_action SET param="Just~passing~by 0" WHERE id=150012;
UPDATE cq_action SET param="Sorry.~You~can't~repair~pole.~Only~Leader~of~the~guild~taking~Guild~House~can~use~guild~fund~to~repair~it." WHERE id=150025;
UPDATE cq_action SET param="Oh,~I~see 0" WHERE id=150026;
UPDATE cq_action SET param="There~is~3k~CPs~income~every~week.~Guild~leader~can~claim~it~from~Monday~to~Thursday." WHERE id=5043001;
UPDATE cq_action SET param="There~is~3k~CPs~income~every~week.~Guild~leader~can~claim~it~from~Monday~to~Thursday.~First~come,~First~served." WHERE id=5043001;
UPDATE cq_action SET param="I~would~like~to~claim~it 5043005" WHERE id=5043002;
UPDATE cq_action SET param="Just~passing~by 0" WHERE id=5043003;
UPDATE cq_action SET param="1970-04-19 00:00 2008-05-23 23:59" WHERE id=7234051;
UPDATE cq_action SET param="data1 == 0 820" WHERE id=5043005;
UPDATE cq_action SET param="Your~guild~has~not~dominated~guild~area.~Guild~war~will~be~held~on~every~Saturday,~lasting~2~days.~The~winner~can~seize~guild~area~and~gain~the~funds~after~that." WHERE id=5043015;
UPDATE cq_action SET param="Your~guild~has~not~dominated~guild~area.~Guild~war~will~be~held~on~every~Saturday,~lasting~2~days." WHERE id=5043015;
UPDATE cq_action SET param="Okeyz 0" WHERE id=5043016;

UPDATE cq_action SET param="What~can~I~do~for~you?" WHERE id=5030107;
UPDATE cq_action SET param="Teleport~me~in 5030115" WHERE id=5030108;
UPDATE cq_action SET param="Open~the~gate! 5030120" WHERE id=5030109;
UPDATE cq_action SET param="Nothing,~atm 0" WHERE id=5030110;
UPDATE cq_action SET param="Sorry,~you~cannot~open~it.~Only~DLs~or~GLs~can." WHERE id=402961;
UPDATE cq_action SET param="I~see 0" WHERE id=402962;
UPDATE cq_action SET param="Good~to~know 0" WHERE id=5001104;
UPDATE cq_action SET param="Do~you~want~to~blow~the~gate?" WHERE id=5001102;
UPDATE cq_action SET param="Definetly 5001105" WHERE id=5001103;
UPDATE cq_action SET param="You~need~bomb~if~you~like~to~blow~urself." WHERE id=5001106;
UPDATE cq_action SET param="Just~passing~by 0" WHERE id=5030136;
UPDATE cq_action SET param="Close~the~gate! 5030140" WHERE id=5030135;
UPDATE cq_action SET param="What~can~I~do~for~you?" WHERE id=5030134;
UPDATE cq_action SET param="Gate~was~just~blowed~up." WHERE id=5001109;
UPDATE cq_action SET param="What~can~I~do~for~you?" WHERE id=5030151;
UPDATE cq_action SET param="Heal~gate! 5030155" WHERE id=5030152;
UPDATE cq_action SET param="You~need~100k~gold~to~cover~that~healing!" WHERE id=402976;
UPDATE cq_action SET param="Okeyz 0" WHERE id=5030153;
UPDATE cq_action SET param="You~can~blow~the~gate~only~at~Guild~war~time." WHERE id=5001191;
UPDATE cq_action SET param="Guild~%syn_name~member~%user_name~just~blowed~up~the~GuildGate" WHERE id=5001125;
UPDATE cq_action SET param="Guild~%syn_name~member~%user_name~just~blowed~up~the~GuildGate!" WHERE id=5001125;
UPDATE cq_action SET param="%user_name~just~blowed~up~GuildGate!" WHERE id=5001126;
UPDATE cq_action SET param="Kamikaze~%user_name~just~blowed~up~GuildGate!" WHERE id=5001126;
UPDATE cq_action SET param="Kamikaze~%user_name~just~blowed~up~GuildGate!" WHERE id=5001134;
UPDATE cq_action SET param="What~can~I~do~for~you?" WHERE id=5030172;
UPDATE cq_action SET param="Teleport~me~in 5030180" WHERE id=5030173;
UPDATE cq_action SET param="Open~the~gate! 5030185" WHERE id=5030174;
UPDATE cq_action SET param="Sorry,~you~cannot~open~it.~Only~DLs~or~GLs~can." WHERE id=402991;
UPDATE cq_action SET param="Okeyz 0" WHERE id=402992;
UPDATE cq_action SET param="Nothing,~atm 0" WHERE id=5030175;
UPDATE cq_action SET param="What~can~I~do~for~you?" WHERE id=5030194;
UPDATE cq_action SET param="Close~the~Gate! 5030200" WHERE id=5030195;
UPDATE cq_action SET param="Nothing,~atm 0" WHERE id=5030196;
UPDATE cq_action SET param="Nothing,~atm 0" WHERE id=5030213;
UPDATE cq_action SET param="What~can~I~do~for~you?" WHERE id=5030211;
UPDATE cq_action SET param="Heal~the~gate 5030215" WHERE id=5030212;
UPDATE cq_action SET param="Do~you~want~to~blow~the~gate?" WHERE id=5001152;
UPDATE cq_action SET param="Definetly 5001155" WHERE id=5001153;
UPDATE cq_action SET param="Not~now 0" WHERE id=5001154;
UPDATE cq_action SET param="You~do~need~bomb~to~blow~urself." WHERE id=5001156;
UPDATE cq_action SET param="You~do~need~bomb~to~blow~urself." WHERE id=5001159;
UPDATE cq_action SET param="Gate~is~already~opened." WHERE id=5001156;
UPDATE cq_action SET param="Gate~is~already~opened." WHERE id=5001106;
UPDATE cq_action SET param="You do need bomb to blow urself." WHERE id=5001109;
UPDATE cq_action SET param="Close~the~Gate! 5030200" WHERE id=5030195;
UPDATE cq_action SET param="You~do~have~full~inventory!" WHERE id=7510261;
UPDATE cq_action SET param="Ohh 0" WHERE id=7510262;

ــــــــــــــــــــــــــــــــــــــــــــــــــ ــــــــــــــــــــــــــــــــــــــــــــــــــ ــــــــــــــــ

so ... can anyone tell me how to change the 9 o'clock and witch commands i need to copy to make another guild war with another times ??

source is 5095

sorry but im not good at sql commands ...

and sorry for my english ...

Thanks For Who Could Help Meh ....

~~Sp|dEr~~ · 09/02/2010, 00:45

INSERT INTO `cq_action` VALUES ('7234051', '7234052', '5043032', '0123', '0', '2009-11-13 00:00 2010-10-03 23:59');
INSERT INTO `cq_action` VALUES ('7234052', '5043032', '7234053', '0508', '1', '');
INSERT INTO `cq_action` VALUES ('7234053', '0000', '0000', '1010', '2005', 'Ã„Â¿Ã‡Â°Ã•Ã½ &# 194;¾Ã™Ã�Ã�Â°Ã¯Ã…&#1 95;‰Ã•Ã¹Â°Ã”ÃˆÃ¼&# 19 4;»Ã®Â¶Â¯Â£Â¬Ã�&#195 ;¬ÃˆÂ�');
INSERT INTO `cq_action` VALUES ('7234060', '7234061', '5043011', '0123', '0', '2009-11-13 00:00 2010-10-03 23:59');
INSERT INTO `cq_action` VALUES ('7234061', '5043011', '0000', '0501', '723467', '');
INSERT INTO `cq_action` VALUES ('7234100', '7234120', '7234101', '0123', '0', '2009-11-13 00:00 2010-10-03 23:59');

how to make it ends at 10 instead of 9 o'clock ....

and how to make another guild war times ?? i mean another 2 days got guild war too ?

FrontBoy · 09/02/2010, 00:57

here just some people mess with binaryes most of ppl here use c# sources

~~Sp|dEr~~ · 09/02/2010, 06:10

:S there are no solution ?

~~dowhatuwant~~ · 09/02/2010, 13:13

Quote:

Originally Posted by Sp|dEr

source is 5095

Did u call a binary a source?

~~Sp|dEr~~ · 09/03/2010, 07:54

lol i dont even know what binary is ....

but i know it means sources for CO PS .

~~dowhatuwant~~ · 09/03/2010, 08:29

Quote:

Originally Posted by Sp|dEr

lol i dont even know what binary is ....

but i know it means sources for CO PS .

Fast an undetailed explanation:

A source is something you self have made in a language like C, C++, C#, Java etc.

A binary is some leeched dingdong from conquer.
Wich is all just almost Translate, copy+paste.

Not many here uses binary, because they are not allowed.

~Master · 09/03/2010, 13:59

You could change your host's clock to start/end gw whenever you want.

~~Sp|dEr~~ · 09/04/2010, 20:40

well then i got binary ...

copy + paste source from some frined ...

and about changing the time ...

it changes the times for other quests too not just the gw only ...

im only trying to put another quest time for guild war instead of 1 time only ..

i hope u understand me ...

~Master · 09/04/2010, 21:17

I know that you are trying to change the gw timer.
What about using gw's start action?
its like typing "/action 123456 " 123456 in cq_action starts gw for example.