#Nerd
Admin
Mensagens : 123
Reputacao : 10357
Agradescido : 2
Data de inscrição : 07/08/2010
Idade : 28
Localização : Games Trinyon
 |  Assunto: Como ter todas as quests e skills  Dom Ago 08, 2010 5:35 am | |
| É simples, porém exige um pouco de conhecimento do Banco de Dados MSSQL [Importante] 1. abra seu Query Analyzer 2. procure por GAMEDB.dbo.cabal_character_table 3. execute e anote os idx dos caracteres, pois irá utilizar bom, segue agora a query (Todas as Quests): - Código:
-
Código:
Escolha "GAMEDB"
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
segue a query (Todas as Skills):
lembrando, que são todas as skills basicas de cada classe...
aprimoramentos, skills mágicas, espadas, etc.
Código:
Escolha "GAMEDB"
WA (Guerreiro)
update cabal_skilllist_table set Data = 0x4D01014654010148550101499001014B7C01014E7D01014F7E0101507F010151D00009026700092064000921E600042265000923A3010147CC00140337000905D9001406CD001407CA00140822000909CE00140ADA00140BDB00140C1A00090D2B00090EDC001400DD001401A40101442C010A522E0108532F010854390103553A010356A5010166A6010167 where CharacterIdx = @characteridx
BL (Duelista)
update cabal_skilllist_table set Data = 0x020001004D01014656010148570101499201014B8001014E8101014F8201015083010151CB001401D0000902CC001403140009041B000905D3001406C9000F0728000908CD0014093400090A4600090BA3010147C40101452300090CCA00140D3800090EA40101442C0109522E0106532F0106543A01015539010156A5010166A6010167 where CharacterIdx = @characteridx
WI (Mago)
update cabal_skilllist_table set Data = 0x640001204D01014658010148590101499401014BE7001421E8001422E9000F23EC001424EA00092589000928730014297A00142A7600142B7D00142C020009008000012DD0000901A30101478C000F26E50014278B00092EEB00142F8D000C30E4000F31E3000632E2000633A40101442C010A522F01085330010854380103553701035634010157A5010166A6010167 where CharacterIdx = @characteridx
FA (Arqueiro)
update cabal_skilllist_table set Data = 0xA80101204B0101434D0101465A0101485B0101499601014B8701014E8801014F890101508A0101510200090095001422ED001423EE001424EF000125F000142697001427F1001428BE011429C301142AB701142BBA01142C9800142DF300142EF200142FF4001421D0000901A3010147F5001430F6000931100114329B000933110114349C000935F7001436A40101449900093712011438C40101452C010A5230010854380103553A0103562F01085737010353A5010166A6010167 where CharacterIdx = @characteridx
FS (Guardião)
update cabal_skilllist_table set Data = 0x020009004C0101434D0101465C0101485D0101499801014B8401014E8501014F86010150D00009017A0014247D0014257B0014261600090201000903F9001420FA0014229F000923F8001427DF000128730014297600142A7E00142BFB00142CA3010147E000142DE100142EA40101443900120424001405C40101457400142F770014307F0001317C001232E6000421780001332C010A522F0108533A010354380103553001085637010357A5010166A6010167 where CharacterIdx = @characteridx
FB (Espadachin)
update cabal_skilllist_table set Data = 0x020009004D0101465E0101485F0101499A01014B9C01014E9D01014F9E0101502E00090111001402D000090321001404250009053A00090602011422FE001423FD001424FF001425DF001420A301014736001407A40101442A000908060114210D0114260F011427F100142801011429EF00142A6400092B6500092C6600092D0E01142E2C010A522F0101532E010154390103563A01035737010355A5010166A6010167 where CharacterIdx = @characteridx
@characteridx: são as IDs do char cadastrados no mssql ex.: 1, 2, 3, 4, 5 se gostou agradeça, não custa nada créditos: aeyemo e a mim por ter deixado mais explicativo. obs.: não faça que nem o ROSS, poste os créditos |
|
