GuildWar 5095

09/01/2010 10:18 Sp|dEr#1
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 ....
09/02/2010 00:45 Sp|dEr#2
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 ?
09/02/2010 00:57 FrontBoy#3
here just some people mess with binaryes most of ppl here use c# sources
09/02/2010 06:10 Sp|dEr#4
:S there are no solution ?
09/02/2010 13:13 dowhatuwant#5
Quote:
Originally Posted by Sp|dEr View Post

source is 5095
Did u call a binary a source?:confused:
09/03/2010 07:54 Sp|dEr#6
lol i dont even know what binary is ....

but i know it means sources for CO PS .
09/03/2010 08:29 dowhatuwant#7
Quote:
Originally Posted by Sp|dEr View Post
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.
09/03/2010 13:59 ~Master#8
You could change your host's clock to start/end gw whenever you want.
09/04/2010 20:40 Sp|dEr#9
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 ...
09/04/2010 21:17 ~Master#10
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.