Tak je konec

[svatypatejl 0]

Tak doporucuju schovavat databaze v Navicatu.

Pokud davate nejaky novy sqlko udelejte si novou.

napr. prvni databaze wow_sql01

Novy sql wow_sql02 ... atd.

Pokud neco nejede tak muzete prepsat jen databazi v conf adresarich a jet zase na stare databazi.

 

Na te stare mne to ty problemy s bojem nedela.

 

Dalsi krok muze byt kopirovani databazi po jedne a hledani kde je chyba.

POZOR ! nektere databaze jsou navazane ale maximalne to hodi Error radek pri nabihani emu.

Nepredpokladam ze by to emulator sestrelilo uplne.

[svatypatejl 0]

btw... ten fix co se siri jako oprava na dual wield je asi blbost.

je to strceny Rogue trainerovi a ten mne to nedal ani jeden. I kdyz tu 118 v databazi mel.

Dal sem to Archiemu, weapon masterovi v Undercity a v pohode to trenoval.

.... ted na to kaslu ale zitra udelam fix na vsecky trenery.

[RoXY 0]

Nj aj mne sa zda ze ti z Keen repacku opravuju aj to co netreba, len aby neco opravili ))

btw uz vysla v3.0:

CHANGE LOG:

v3.0

- dbc updated!

- booty bay fix

- added tsoatt (gm_weapon)

- changed gameobj_loot (backup the old one incase u don't like it)

 

SendSpace | The Best Free File Sharing Servicev3.0

 

.bug fix pack > SendSpace | The Best Free File Sharing Service

 

btw .. skoda ze nemas cas na SC by sa hodil taky sikovny programator ako si ty

[svatypatejl 0]

Tak sem koukal a oni tu 118 skill napraskali snad ke vsem trenerum

Dual Wield je ale weapon skill takze ma byt jen u weapon masteru :-)

Takze tady je slibenej sql skriptik. Zatim to nemam kam davat tak sorry ze to tu tak zaplacavam...

 

 

#----------------------------

# Clear all wrong dual wield and set it to Weapon master only

#----------------------------

 

UPDATE trainer

SET skillline1 = 0

WHERE skillline1 = 118;

 

UPDATE trainer

SET skillline2 = 0

WHERE skillline1 <> 43 and skillline2 = 118;

 

UPDATE trainer

SET skillline3 = 0

WHERE skillline1 <> 43 and skillline3 = 118;

 

UPDATE trainer

SET skillline4 = 0

WHERE skillline1 <> 43 and skillline4 = 118;

 

UPDATE trainer

SET skillline5 = 0

WHERE skillline1 <> 43 and skillline5 = 118;

 

UPDATE trainer

SET skillline6 = 0

WHERE skillline1 <> 43 and skillline6 = 118;

 

UPDATE trainer

SET skillline7 = 0

WHERE skillline1 <> 43 and skillline7 = 118;

 

UPDATE trainer

SET skillline8 = 0

WHERE skillline1 <> 43 and skillline8 = 118;

 

UPDATE trainer

SET skillline9 = 0

WHERE skillline1 <> 43 and skillline9 = 118;

 

UPDATE trainer

SET skillline10 = 0

WHERE skillline1 <> 43 and skillline10 = 118;

 

UPDATE trainer

SET skillline11 = 0

WHERE skillline1 <> 43 and skillline11 = 118;

 

UPDATE trainer

SET skillline12 = 0

WHERE skillline1 <> 43 and skillline12 = 118;

 

UPDATE trainer

SET skillline13 = 0

WHERE skillline1 <> 43 and skillline13 = 118;

 

UPDATE trainer

SET skillline14 = 0

WHERE skillline1 <> 43 and skillline14 = 118;

 

UPDATE trainer

SET skillline15 = 0

WHERE skillline1 <> 43 and skillline15 = 118;

 

UPDATE trainer

SET skillline16 = 0

WHERE skillline1 <> 43 and skillline16 = 118;

 

UPDATE trainer

SET skillline17 = 0

WHERE skillline1 <> 43 and skillline17 = 118;

 

UPDATE trainer

SET skillline18 = 0

WHERE skillline1 <> 43 and skillline18 = 118;

 

UPDATE trainer

SET skillline19 = 0

WHERE skillline1 <> 43 and skillline19 = 118;

 

UPDATE trainer

SET skillline20 = 0

WHERE skillline1 <> 43 and skillline20 = 118

 

#####

# That's all folks

#####

 

[jelenidlo 0]

prosimte zaloz novej topic kam budes psat tvoje opravy sql... a mol by ti to taky nekdo vyvesit

 

a kdyztak je nekam uploaduj treba sem http://www.filebeam.com/

[svatypatejl 0]

jj dikec :-) to je to co sem uz nestihal hledat :-)