Jump to content

  • Announcements

    • Xmat

      Pravidlo pro postování v TTT

      Do sekce Tipy, triky, tutoriály nepatří žádné dotazy.   Postujte sem vaše návody, tipy a různé další věci jež uznáte za vhodné sdělit zdejšímu osazenstvu, ale veškeré dotazy směřujte do sekce Všeobecná diskuse.
    • Replik

      Seznam návodů a důležitých témat v této sekci

      Pro lepší přehlednost jsem vytvořil tento seznam, který vás, méně zkušené, lépe provede touto sekcí. Věřím, že zde najdete, co hledáte. Vypsané jsou návody, které jsou oficiálně uznané jako návody. Běžné diskuze, které neposkytují postupy a rady zvěřejněny nejsou.   Instalace vlastního MaNGOS Serveru Díky těmto návodům budete (měli by jste být) schopni vytvořit a následně spustit váš vlastní server. Nastavení je pro verze s i bez datadisku.   Instalace MaNGOS Serveru (bez datadisku TBC) - Autor Benny Instalace MaNGOS Serveru (s datadiskem TBC) - Autor Malfik Instalace MaNGOS Serveru v prostředí Linux - Autor charlie Instalace MaNGOS Serveru v prostředí Linux - Autor kupkoid   Chyby a jejich řešení při přihlašování k serveru - Autor Cybe   Zálohování uživatelských dat   Dávkový soubor (BAT soubor) pro vytvoření SQL záloh - Autor Replik   Kompilování - tvoření vlastních release (revizí)   Tvorba kompilací pro Win32 (MangoScript) - Autor bLuma   Ostatní - těžko zařaditelné, ale neznamená to, že nejsou dobré   VIP Systém - Autor charlie Tvorba Webových stránek pro MaNGOS - Autor zahuba Tvorba teleportačních NPC (MangoScript) - Autor Replik Registrační web (původně předělaná SPORA) Funkční pro Antrix i MaNGOS - Autor Replik Nastavení a spuštění Minimanager pro MaNGOS - Autor BlackMartin Nastavení MaNGOS Website - Autor Artorius   Samozřejmě jsou zde i jiné návody, ale tyto jsou nejvíce používané, proto věřím, že vám budou nápomocné. Tuto sekci budeme upravovat podle potřeby. Pokud by jste něco nenašli nebo si nevěděli rady, hledejte na fóru a teprve potom založte vlastní topik. Pokud nějaký autor vytvoří kvalitní návod a chtěl by ho zveřejnit i v tomto seznamu, doporučuji, aby mi napsal zprávu skrze PM.   Díky a přeji hezký den na WoWResource   Replik
    • Aristo

      Příspěvky tam, kde nemají co dělat

      Dodržujte zákaz přispívání do topiků s repaky pokud si to zakladatelé nepřejí!! Opakované psaní příspěvků bude trestáno warnem.
    • Aristo

      Používání spoilerů

      Poslední dobou má většina uživatelů fora zvláštní nutkání postovat extrémně dlouhé texty nebo kódy, které zabírají v nejedenom případu i 80% obsahu celé stránky a hodně tak zvedají nepřehlednost v topiku. Chtěl bych všechny uživatele požádat, aby při postování citací, jakýchkoliv kódů, errorů, atp... delších než 30 řádků používali funkci spoileru.   Funkci vyvoláte příkazem [spoiler] text [/spoiler]   Ukázka:  
Sign in to follow this  
Followers 0
Falcon

UDB,UWDB.......

By Falcon, in Databáze a repaky

Recommended Posts

Falcon    0

Falcon
Posted (edited)

CHci se vsech zeptat co pouzivaj za db a podle toho si chci vybrat nikdo rika ze je dobra UWDB nikdo zase rika ze je dobra UDB nikdo jiny zase rika ze dobre Project silvermoon db apod.... chci se zeptat nikoho skuseneho jaka db je nej ;), kde je nejmene bugu.

Edited by Falcon

Share this post

Link to post
Share on other sites

charlie    13

charlie
Posted

to je podle uhlu pohledu... vyber si co ti nejlip sedi.. ja myslim ze pro tebe bude nejlepsi UDB, ... protoze UWDB je uz docela mrtvy a neupdatovany projekt a silvermoonDB nevim no..

Share this post

Link to post
Share on other sites

Falcon    0

Falcon
Posted (edited)

diky moc stahnul jsem si z official stranky https://unifieddb.svn.sourceforge.net/svnroot/unifieddb soubor UDB_0.10.2_Core_5949_SD2_414.rar a kdyz zapnu mangosd.exe tak mi to hazi hodne erroru mam revizi 6138 ale udb jsem si updatnul na 6138 je to nejaky divny pomohl by mi nikdo pls??

 

 

 

Errory jsou typu:

 

2008-06-26 13:56:34 ERROR:Item (Entry: 826) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 885) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 885) not correct 14036 display id, must be 8494 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 886) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 920) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1214) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1219) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1296) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1394) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1394) not correct 5204 display id, must be 5203 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 1440) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1457) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1459) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1469) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1480) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1493) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1721) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1927) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1938) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1958) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 1958) not correct 1515 display id, must be 1759 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 2018) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 2035) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 2046) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 2263) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 2265) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 2267) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 2281) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 2503) not correct 0 sheath, must be 2  (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 2808) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 2821) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 3034) not correct 5 inventory type, must be 24 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 3034) not correct 14674 display id, must be 5998 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 3154) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 3222) not correct 6439 display id, must be 20607 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 3223) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 3462) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 3570) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 3570) not correct 5197 display id, must be 8100 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 3755) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 3935) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 3935) not correct 4800 display id, must be 7311 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 4116) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4122) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4126) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4303) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4439) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4445) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4511) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4824) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4826) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4949) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4959) not correct 25 inventory type, must be 0 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4959) not correct 5416 display id, must be 16760 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 4971) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4977) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 4978) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 5229) not correct 14001 display id, must be 6007 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 5324) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 5324) not correct 8568 display id, must be 8576 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 5330) not correct 13989 display id, must be 18061 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 5459) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 5459) not correct 7965 display id, must be 5014 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 5562) not correct 5562 display id, must be 8132 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 5563) not correct 5563 display id, must be 8132 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 5744) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 5757) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6194) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6196) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6622) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6738) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6804) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6966) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6967) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6968) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6978) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6982) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6983) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6984) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 6985) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 7115) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 7117) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 7118) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 7328) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 7329) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 7681) not correct 15805 display id, must be 18519 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 8708) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 8840) not correct 8 inventory type, must be 0 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 8840) not correct 25980 display id, must be 1103 (using it).
2008-06-26 13:56:34 ERROR:Item (Entry: 9651) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 9686) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:34 ERROR:Item (Entry: 9728) not correct (not listed in list of existed items).
2008-06-26 13:56:34 ERROR:Item (Entry: 10696) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 10744) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 11906) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 11964) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 12400) not correct (not listed in list of existed items).
2008-06-26 13:56:35 ERROR:Item (Entry: 12866) not correct 9 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 12866) not correct 26794 display id, must be 23323 (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 12970) not correct 23709 display id, must be 26387 (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 13006) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 13028) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 13048) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 13936) not correct 25403 display id, must be 25659 (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 15021) not correct (not listed in list of existed items).
2008-06-26 13:56:35 ERROR:Item (Entry: 15445) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 15863) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 15863) not correct 5207 display id, must be 5205 (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 16334) not correct 11 inventory type, must be 2 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 16334) not correct 26001 display id, must be 30797 (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 17003) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 17039) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 17733) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 18000) not correct (not listed in list of existed items).
2008-06-26 13:56:35 ERROR:Item (Entry: 18001) not correct (not listed in list of existed items).
2008-06-26 13:56:35 ERROR:Item (Entry: 18002) not correct 0 inventory type, must be 17 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 18002) not correct 15852 display id, must be 30294 (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 18002) not correct 0 sheath, must be 1  (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 18003) not correct (not listed in list of existed items).
2008-06-26 13:56:35 ERROR:Item (Entry: 18004) not correct (not listed in list of existed items).
2008-06-26 13:56:35 ERROR:Item (Entry: 18005) not correct (not listed in list of existed items).
2008-06-26 13:56:35 ERROR:Item (Entry: 18491) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 18924) not correct (not listed in list of existed items).
2008-06-26 13:56:35 ERROR:Item (Entry: 18925) not correct (not listed in list of existed items).
2008-06-26 13:56:35 ERROR:Item (Entry: 19760) not correct (not listed in list of existed items).
2008-06-26 13:56:35 ERROR:Item (Entry: 19968) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 20393) not correct 32838 display id, must be 44552 (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 20723) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 22332) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 22822) not correct 2247 display id, must be 811 (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 23051) not correct 21 inventory type, must be 15 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 23051) not correct 24925 display id, must be 35450 (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 23051) not correct 3 sheath, must be 0  (using it).
2008-06-26 13:56:35 ERROR:Item (Entry: 24343) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 26050) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 26054) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 27756) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 30788) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 31422) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 31423) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 31476) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 31745) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 33272) not correct 21 inventory type, must be 13 (still using DB value).
2008-06-26 13:56:35 ERROR:Item (Entry: 34077) not correct 31577 display id, must be 49426 (using it).

 

a jeste nejaky:

2008-06-26 13:56:55 ERROR:Creature (GUID: 566) does not exist but has a record in `creature_addon`
2008-06-26 13:56:55 ERROR:Creature (GUID: 567) does not exist but has a record in `creature_addon`
2008-06-26 13:56:55 ERROR:Creature (GUID: 69728) does not exist but has a record in `creature_addon`
2008-06-26 13:56:55 ERROR:Creature (GUID: 70352) does not exist but has a record in `creature_addon`

 

to jsou vsechny errory kdo by vedel co stim ulibam mu snad nohy :D

Edited by hisgrak
zpřehlednění ...

Share this post

Link to post
Share on other sites

charlie    13

charlie
Posted

tydle errory jsou normalni a rikaji ti ze nejake udaje v DB jsou chybne.. muzes to ignorovat, reportnout na udbforums.org nebo fixnout :P

Share this post

Link to post
Share on other sites

charlie    13

charlie
Posted

2008-06-26 13:56:34 ERROR:Item (Entry: 1219) not correct 21 inventory type, must be 13 (still using DB value).

 

pise ti to ze Item s ID 1219 ma spatne nastaveny inventory type.. tak kouknu na wiki.udbforums.org v kterym sloupecku v item_template se definuje inventory type.. je to sloupec InventoryType .. take mangos pise ze musi byt 13 .. tak udelam todle

 

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1219;

 

executnu do DB a uz by to tudle hlasku s konkretne timto itemem nemelo psat..

Share this post

Link to post
Share on other sites

Falcon    0

Falcon
Posted (edited)

udelal jsem si podle toho vlastni fixy na sve bugy trvalo mi to hodku a hazi mi to v sqllogu error prosim oprav mi je nejak charlie :(

 

 

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=826;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=885;

UPDATE `item_template` SET `Display Id` = 8494 WHERE `entry`=885;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=886;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=920;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1214;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1296;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1394;

UPDATE `item_template` SET `Display Id` = 5203 WHERE `entry`=1394;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1440;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1457;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1459;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1469;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1480;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1493;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1721;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1927;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1938;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=1958;

UPDATE `item_template` SET `InventoryType` = 1759 WHERE `entry`=1958;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=2018;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=2035;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=2046;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=2263;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=2265;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=2267;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=2281;

UPDATE `item_template` SET `Sheath` = 2 WHERE `entry`=2503;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=2808;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=2821;

UPDATE `item_template` SET `InventoryType` = 24 WHERE `entry`=3034;

UPDATE `item_template` SET `Display Id` = 5998 WHERE `entry`=3034;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=3154;

UPDATE `item_template` SET `Display Id` = 20607 WHERE `entry`=3222;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=3223;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=3462;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=3570;

UPDATE `item_template` SET `Display Id` = 8100 WHERE `entry`=3570;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=3755;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=3935;

UPDATE `item_template` SET `Display Id` = 7311 WHERE `entry`=3935;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4116;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4122;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4126;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4303;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4439;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4445;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4511;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4824;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4826;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4949;

UPDATE `item_template` SET `InventoryType` = 0 WHERE `entry`=4959;

UPDATE `item_template` SET `Display Id` = 16760 WHERE `entry`=4959;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4971;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4977;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=4978;

UPDATE `item_template` SET `Display Id` = 6007 WHERE `entry`=5229;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=5324;

UPDATE `item_template` SET `Display Id` = 8576 WHERE `entry`=5324;

UPDATE `item_template` SET `Display Id` = 18061 WHERE `entry`=5330;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=5459;

UPDATE `item_template` SET `Display Id` = 5014 WHERE `entry`=5459;

UPDATE `item_template` SET `Display Id` = 8132 WHERE `entry`=5562;

UPDATE `item_template` SET `Display Id` = 8132 WHERE `entry`=5563;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=5744;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=5757;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6194;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6196;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6622;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6738;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6804;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6966;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6967;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6968;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6978;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6982;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6983;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6984;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=6985;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=7115;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=7117;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=7118;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=7328;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=7329;

UPDATE `item_template` SET `Display Id` = 18519 WHERE `entry`=7681;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=8708;

UPDATE `item_template` SET `InventoryType` = 0 WHERE `entry`=8840;

UPDATE `item_template` SET `Display Id` = 1103 WHERE `entry`=8840;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=9651;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=9686;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=10696;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=10744;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=11906;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=11964;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=12866;

UPDATE `item_template` SET `Display Id` = 23323 WHERE `entry`=12866;

UPDATE `item_template` SET `Display Id` = 26387 WHERE `entry`=12970;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=13006;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=13028;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=13048;

UPDATE `item_template` SET `Display Id` = 25659 WHERE `entry`=13936;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=15445;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=15863;

UPDATE `item_template` SET `Display Id` = 5205 WHERE `entry`=15863;

UPDATE `item_template` SET `InventoryType` = 2 WHERE `entry`=16334;

UPDATE `item_template` SET `Display Id` = 30797 WHERE `entry`=16334;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=17003;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=17039;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=17733;

UPDATE `item_template` SET `InventoryType` = 17 WHERE `entry`=18002;

UPDATE `item_template` SET `Display Id` = 30294 WHERE `entry`=18002;

UPDATE `item_template` SET `Sheath` = 1 WHERE `entry`=18002;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=18491;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=19968;

UPDATE `item_template` SET `InventoryType` = 44552 WHERE `entry`=20393;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=20723;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=22332;

UPDATE `item_template` SET `Display Id` = 811 WHERE `entry`=22822;

UPDATE `item_template` SET `InventoryType` = 15 WHERE `entry`=23051;

UPDATE `item_template` SET `Sheath` = 0 WHERE `entry`=23051;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=24343;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=26050;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=26054;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=27756;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=30788;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=31422;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=31423;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=31476;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=31745;

UPDATE `item_template` SET `InventoryType` = 13 WHERE `entry`=33272;

UPDATE `item_template` SET `Display Id` = 49426 WHERE `entry`=34077;

 

 

 

 

 

 

Byl bych ti moc vdecny :(

Edited by Falcon

Share this post

Link to post
Share on other sites

Molekula    0

Molekula
Posted

pls ja bych byl taky rad kdyby ste poradili jak na to mam stejny chyby :( normalne jsem si stahnul full db 10.2 updatnul to na predposledni verzi protoze ten nejnovjeis update se mi nejak drhne to este vyresim a taky mi to hazi tyhůe chyby nwm jestli mam neco nahrat ze slozy sql nebo vubec nwm pls help :)

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0
Go To Topic Listing Databáze a repaky
×