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 ...
ــــــــــــــــــــــــــــــــــــــــــــــــــ ــــــــــــــــــــــــــــــــــــــــــــــــــ ــــــــــــــــــــــــــــــــــــــــ
ــــــــــــــــــــــــــــــــــــــــــــــــــ ــــــــــــــــــــــــــــــــــــــــــــــــــ ــــــــــــــــ
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 ....
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 ....