Fixar a GW 100% e Como Mudar dia e hora de começar e terminar!

Ver o tópico anterior Ver o tópico seguinte Ir em baixo

Fixar a GW 100% e Como Mudar dia e hora de começar e terminar!

Mensagem por FelipeXP em Ter Set 08, 2015 4:09 pm

Basta adicionar o código no console do navicat e da enter

Fixar a GW:

Código:
############################################################
####################################
############
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;
REPLACE INTO `cq_dynanpc` VALUES ('0820', '5', '2', 'GuildOfficer', '02', '8160', '-1', '1038', '44', '60', '5043000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', 'ÎÞ', '0000', '0000', '0000', '0000', '0', '0000', '00', '00');
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;
UPDATE cq_action SET param="Only~Guild~Leader~and~Deputy~Leader~can~get~top~Guild~and~deputy~and~1~Mil~cps~after~finish~the~war~saturday~24.00~AM." WHERE id=5043030;
UPDATE cq_action SET param="i~see. 0" WHERE id=5043031;
UPDATE cq_action SET param="Only~Guild~Leader~and~Deputy~Leader~can~get~top~Guild~and~deputy~and~1~Mil~cps~after~finish~the~war~at~24.00~AM." WHERE id=5043030;
UPDATE cq_action SET param="claim~reward. 5043005" WHERE id=5043002;
UPDATE cq_action SET param="Top~GL~and~DL. 5008401" WHERE id=5008400;
UPDATE cq_action SET param="Just~Passing~By. 0" WHERE id=5043003;
UPDATE cq_action SET param="Are~You~Sure~You~Want~Get~Top~Now~?" WHERE id=5008401;
UPDATE cq_action SET param="Sure~. 5008410" WHERE id=5008402;
UPDATE cq_action SET param="Congratulation~you~have~got~it." WHERE id=5008466;
UPDATE cq_action SET param="wow.nice. 0" WHERE id=5008467;
UPDATE cq_action SET param="Only~GuildLeader~Can~claim~the~cps." WHERE id=5043020;
UPDATE cq_action SET param="i~see. 0" WHERE id=5043021;
UPDATE cq_action SET param="Congratulation~you~have~claimd~1~Mil~cps~enjoy." WHERE id=5043012;
UPDATE cq_action SET param="Thanks~Ryodan~. 0" WHERE id=5043013;
UPDATE cq_action SET param="e_money += 500000" WHERE id=5043009;
UPDATE cq_action SET param="Congratulation~{~%user_name~}~have~claimed~500~K~cps~for~his~guild~{~%syn_name~}~The~winner~of~the~war." WHERE id=5043011;
UPDATE cq_action SET param="Congratulation~{~%user_name~}~have~claimed~500~K~cps~for~his~guild~{~%syn_name~}~The~winner~of~the~war." WHERE id=5043014;
UPDATE cq_action SET param="you~are~already~claimed~it." WHERE id=5043025;
UPDATE cq_action SET param="i~see. 0" WHERE id=5043026;
UPDATE cq_action SET param="you~have~already~got~it." WHERE id=5008490;
UPDATE cq_action SET param="oh~i~forget~that. 0" WHERE id=5008491;
UPDATE cq_action SET param="Only~Guild~Leader~and~Deputy~Leader~can~get~top~Guild~and~deputy~and~1~Mil~cps~after~finish~the~war~saturday~24.00~AM." WHERE id=5043001;
REPLACE INTO `cq_action` VALUES ('5043009', '8500000', '0000', '1001', '0', 'e_money += 500000');
REPLACE INTO `cq_action` VALUES ('8500000', '5043011', '0000', '0501', '2100075', '0 0 0 0 0 0 0 0 1 0 0 0');
REPLACE INTO `cq_action` VALUES ('5043011', '5043014', '0000', '0125', '2005', 'Congratulations~%user_name~of~guild~%syn_name~has~claimed~500k~cps~and~GoldPrize~as~areward~for~winning~GuildWar~this~weak');
REPLACE INTO `cq_action` VALUES ('5043014', '5043012', '0000', '1022', '0', '%syn_nameµÄ°ïÖ÷%user_nameÁìÈ¡ÁË°ïÅÉ×Ü̳ÊÕÈë600ÍòµãÌìʯ¡£');
REPLACE INTO `cq_action` VALUES ('5043012', '5043013', '0000', '0101', '0', 'Congratulation,~You~have~got~500k~cps~and~GoldPrize~as~areward~for~winning~Guildwar~Say~Thanks~To~Ryodan~.');
REPLACE INTO `cq_action` VALUES ('5043013', '610107', '0000', '0102', '0', 'Thank~you 0');
############ Done .

Mudar o Dia e hora

Procure pela tabela cy_dynanpc
Procure por npc lookface 1137
Nesse npc você vai ver:
data 1 = A hora e dia que começa
data 2 = A hora e dia que Termina

Mudar a Hora que começa A Gw:
A hora e dia que começa:

6140000

6>>> O dia
14>>A hora que começa
0000> Não Mexa

Mudar a hora que termina:


7200000

7>>> O dia que termina
20>> A hora em que termina
0000> Não Mexa

avatar
FelipeXP
Administrador
Administrador

Mensagens : 276
Data de inscrição : 28/05/2014

Ver perfil do usuário https://www.youtube.com/channel/UCOmLJd3M1OSrMmlcR7UGlhw

Voltar ao Topo Ir em baixo

Re: Fixar a GW 100% e Como Mudar dia e hora de começar e terminar!

Mensagem por conquerlife em Seg Nov 30, 2015 1:14 am

aqui nao funfo kkkk
avatar
conquerlife
Membro
Membro

Mensagens : 5
Data de inscrição : 08/11/2015

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Ver o tópico anterior Ver o tópico seguinte Voltar ao Topo

- Tópicos similares

 
Permissão deste fórum:
Você não pode responder aos tópicos neste fórum