sarjuuk / aowow Goto Github PK
View Code? Open in Web Editor NEWDatabase viewer for TrinityCore based on aowow by @LordJZ, based on the JS-Engine of Wowhead
Database viewer for TrinityCore based on aowow by @LordJZ, based on the JS-Engine of Wowhead
Is this site "https://db.rising-gods.de/" the live demo of this repo?
( just wanna know that xD )
Aowow --firstrun ends on glyphs data generation. Here's the log :
`08:37:05 FileGen::init() - creating required directories
08:37:05 created 7 extra paths
08:37:05 [INFO] Found firstrun progression info. (Halted on subscript glyphs)
08:37:07 Resuming setup from step 62...
08:37:08 FileGen::generate() - gathering data for glyphs
`
according to php error log it's a memory problem :
[26-Oct-2016 08:12:17 Europe/Berlin] PHP Fatal error: Out of memory (allocated 1514143744) (tried to allocate 16384 bytes) in C:\xampp\htdocs\aowow\includes\libs\DbSimple\Database.php on line 1024
I increased memory_limit in my php.ini up to 4096M but error still occurs... Any idea?
Hello,
Can you please provide a detailed installation guide in the README?
I've tried installing this but i get the following error:
I'm using Apache: 2.4.9
MySQL: 5.6.17
PHP: 5.5.12
And i did the following steps:
Also the actual website doesn't contain any info. I'm getting "There is no data to display."
So if you could post a detailed install guide we'll forever be in your debt.
Thanks!
Now wlll meet loading error
In the current commit c75777e there is an syntax error in setup/structure.sql:
Line 2451:
INSERT INTO 'aowow_account' VALUES (0,0,'<system>','','AoWoW','',0,0,0,0,'','',0,0,0,0,'','','',0,0,0,0,0,'','');
The values structure does not match the table structure. The correct values would be something like this:
INSERT INTO 'aowow_account' VALUES (0,0,'<system>','','AoWoW','',0,0,0,0,'','',0,0,0,0,'','','',0,0,0,'');
Hello i download and run this db, but after config i recive this measage:
The website is currently closed for maintenance.
This will take a few minutes...
You can help me?
It's 3 minimum characters to create an account on WoW, and not 4. Users who have small user account can not auth on aowow :)
https://github.com/Sarjuuk/aowow/blob/master/includes/user.class.php#L370
use xampp
I put it into D:\server_data\webserver\htdocs\aowow
and use xampp control table and CIL php D:\server_data\webserver\htdocs\aowow\aowow --firstrun
then nothing and see error_log:
[02-Jan-2016 01:28:02 Asia/Shanghai] PHP Warning: require_once(includes/kernel.php): failed to open stream: No such file or directory in D:\server_data\webserver\htdocs\aowow\includes\shared.php on line 24
[02-Jan-2016 01:28:02 Asia/Shanghai] PHP Fatal error: require_once(): Failed opening required 'includes/kernel.php' (include_path='.;D:\server_data\webserver\php\PEAR') in D:\server_data\webserver\htdocs\aowow\includes\shared.php on line 24
see local and some codes
no zhcn and zhtw support?can you add it?
/?npcs
DB ERROR:
Array
(
[code] => 2013
[message] => Lost connection to MySQL server during query
[query] => SELECT SQL_CALC_FOUND_ROWS ct.*, ct.id AS ARRAY_KEY , IFNULL(dct1.id, IFNULL(dct2.id, IFNULL(dct3.id, 0))) AS parentId, IFNULL(dct1.name_loc0, IFNULL(dct2.name_loc0, IFNULL(dct3.name_loc0, ""))) AS parent_loc0, IFNULL(dct1.name_loc2, IFNULL(dct2.name_loc2, IFNULL(dct3.name_loc2, ""))) AS parent_loc2, IFNULL(dct1.name_loc3, IFNULL(dct2.name_loc3, IFNULL(dct3.name_loc3, ""))) AS parent_loc3, IFNULL(dct1.name_loc6, IFNULL(dct2.name_loc6, IFNULL(dct3.name_loc6, ""))) AS parent_loc6, IFNULL(dct1.name_loc8, IFNULL(dct2.name_loc8, IFNULL(dct3.name_loc8, ""))) AS parent_loc8, IF(dct1.difficultyEntry1 = ct.id, 1, IF(dct2.difficultyEntry2 = ct.id, 2, IF(dct3.difficultyEntry3 = ct.id, 3, 0))) AS difficultyMode, ft.A, ft.H, ft.factionId, IF(min(qse.method) = 1 OR max(qse.method) = 3, 1, 0) AS startsQuests, IF(min(qse.method) = 2 OR max(qse.method) = 3, 1, 0) AS endsQuests FROM aowow_creature ct LEFT JOIN aowow_creature dct1 ON ct.cuFlags & 0x02 AND dct1.difficultyEntry1 = ct.id LEFT JOIN aowow_creature dct2 ON ct.cuFlags & 0x02 AND dct2.difficultyEntry2 = ct.id LEFT JOIN aowow_creature dct3 ON ct.cuFlags & 0x02 AND dct3.difficultyEntry3 = ct.id JOIN aowow_factiontemplate ft ON ft.id = ct.faction LEFT JOIN aowow_quests_startend qse ON qse.type = 1 AND qse.typeId = ct.id WHERE (((`ct`.`cuFlags` & 1073741824) = 0)) GROUP BY ct.id LIMIT 300
[context] => /home/..../public_html/aowow/includes/types/basetype.class.php line 252
)
max_allowed_packet is in 268435456 value 😕
Thanks.
zones does not show low level dungeon and raid
like #44
db setup aborted
generated dbc_^ --table kept available
I followed your steps until configuration via php cli.
When I issue php aowow --firstrun
it just shows the following:
# php aowow --firstrun
11:49:10 FileGen::init() - creating required directories
11:49:10 created 7 extra paths
11:49:10 Please enter your database credentials.
It seems that user interaction is broken for me, it doesn't work with other commands, too.
Output of php aowow --dbconfig
for example shows:
# php aowow --dbconfig
11:53:54 select a numerical index to use the corresponding entry
11:53:54 [0] aowow <empty>
11:53:54 [1] world <empty>
11:53:54 [2] auth <empty>
11:53:54 [3] add an additional Character DB
I'm using PHP 5.6.13.
Commit: 8f77774
Problem: After setting up the DB schema and importing the SQL file, the command
php aowo --firstrun
fails with the following output:
09:17:56 [INFO] site configuration aborted
09:17:56 SqlGen::generate() - copying achievement_category.dbc into aowow_achievementcategory09:17:56 reading MPQdata from setup/mpqdata/ to list for first time use...
09:17:56 done[c]ontinue anyway? [r]etry? [a]bort?:
Is there a way to increase debugging output? I cannot see whats wrong. Maybe it has to do with the latest changes in the DB structure file?
How I can extract custom spell dbc text?
You can write a how to put aowow
Hello,
I found error in https://github.com/Sarjuuk/aowow/blob/master/setup/tools/sql/_item.php#L284-L287
Navicat say: "[Err] 1241 - Operand should contain 1 column(s)".
Not sure how you want to add this:
update aowow_items set iconString = lower(iconString);
php aowow --siteconfig
then edit STATIC_HOST or SITE_HOST:
this does not affects to static files contents (e.g. power.js) where those paths are constantly defined
see to title , thx!
I get an issues on ?build=gems i'm on linux.
Array
(
[code] => 1054
[message] => Unknown column 'itemId' in 'where clause'
[query] => SELECT *, Id AS ARRAY_KEY FROM aowow_itemenchantment WHERE id IN (itemId
='49110', name
='Nightmare Tear', entry
='49110', name_loc1
='악몽� 눈물', name_loc2
='Larme de cauchemar', name_loc3
='Alptraumträne', name_loc4
='梦é‡ä¹‹æ³ª', name_loc5
='夢é˜ä¹‹æ·š', name_loc6
='Lágrima de pesadilla', name_loc7
='Lágrima de pesadilla', name_loc8
='Слеза кошмаров', description_loc1
='붉ì�€ìƒ‰, 노란색, 푸른색 ë³´ì„� 홈ì—� ê¼ ë§žìŠµë‹ˆë‹¤. ìž�ì‹ ì�˜ 장비ì—� 하나만 ìž¥ì°©í• ìˆ˜ 있습니다.', description_loc2
='Correspond à une châsse rouge, jaune ou bleue. Vous ne pouvez en enchâsser qu'une maximum dans votre équipement.', description_loc3
='Am besten für einen roten, gelben oder blauen Sockel geeignet. In Eurer Ausstattung kann nur ein Stein dieser Art ausgerüstet sein.', description_loc4
='对应红色ã€�黄色或è“�色æ�’槽。最多å�¯ä»¥åœ¨ä½ 的装备ä¸é•¶åµŒä¸€æžšã€‚', description_loc5
='相容於紅色ã€�黃色或è—�色æ�’槽。最多å�ªèƒ½æœ‰ä¸€é¡†æ�’åœ¨ä½ çš„è£�備上。', description_loc6
='Encaja en una ranura de color rojo, amarillo o azul. Solo puedes encajar una en tu equipo.', description_loc7
='Encaja en una ranura de color rojo, amarillo o azul. Solo puedes encajar una en tu equipo.', description_loc8
='Дл� кра�ного, желтого или �инего гнезда. В�ю �кипировку можно инкру�тировать мак�имум одной �лезой кошмаров.', VerifiedBuild
='15050', expansion
='2', quality
='4', icon
='INV_Misc_Gem_Pearl_12', id
='3879', type1
='3', type2
='0', type3
='0', amount1
='0', amount2
='0', amount3
='0', object1
='68251', object2
='0', object3
='0', text_loc0
='+10 All Stats', text_loc2
='+10 à toutes les caractéristiques', text_loc3
='+10 alle Werte', text_loc6
='+10 todas las estadÃsticas', text_loc8
='+10 ко в�ем характери�тикам', gemReference
='49110', conditionId
='0', skillLine
='0', skillLevel
='0', requiredLevel
='0', colors
='14')
[context] => /var/www/html/db/includes/utilities.php line 1103
)
Sorry, I'm a rookie.
I can't understand the fifth of the installation section.
Can u tell me the detail.
5 .compile the MPQExtractor (im a win user , so i use MPQEditor directly)
extract the following directories (where are directories,can u tell me which directory or which file ? ) from the client(do u mean The World of Warcraft v3.3.5 Client?) archives into setup/mpqdata/(do u mean the aowow folder which i have cloned.=aowow/setup/mpqdata), while maintaining patch order (suffix: 1 -> 9 -> A -> Z)
.. for every locale you are going to use:*
<localeCode>/DBFilesClient/
<localeCode>/Interface/WorldMap/
<localeCode>/Interface/FrameXML/GlobalStrings.lua
.. once is enough (still apply the localeCode though):
<localeCode>/Interface/TalentFrame/
<localeCode>/Interface/Glues/Credits/
<localeCode>/Interface/Icons/
<localeCode>/Interface/Spellbook/
<localeCode>/Interface/PaperDoll/
<localeCode>/Interface/GLUES/CHARACTERCREATE/
<localeCode>/Interface/Pictures
<localeCode>/Interface/PvPRankBadges
<localeCode>/Interface/FlavorImages
<localeCode>/Interface/Calendar/Holidays/
.. optionaly (for other uses):
<localeCode>/Interface/GLUES/LOADINGSCREENS/
✨Forgive my ignorance and bother ! Please tell me the detail ! thx a lot ! ✨
Greetings,
Doing the install on a Linux box finally. When I pulled the submodule repo for the MPQExtractor from iamcal, I can't ever get it to compile. I did some troubleshooting for a while, then went upstream from what it was forked from: https://github.com/Kanma/MPQExtractor - that one actually did compile properly. Using Debian 8 x86_64
I am still apparently too dense to use the tool, but it does compile and appears to give proper output - I'm just feeding it incorrectly! I'll keep plugging away at that one.
This is the following error that comes up:
Parse error: syntax error, unexpected '$this' (T_VARIABLE) in \includes\loot.class.php on line 48
My php is the latest.
Some achievements pages display nothing.
Hello, when user writes "à" in comment, the program inserts à in the database. And of course, display something like this "Bienvenue à ; John Doe"
Ty
I am trying to follow the instructions for the setup.
It says to
git submodule update --init ....
But I get an error:
Cloning into 'includes/tools/MPQExtractor'...
remote: Counting objects: 457, done.
remote: Total 457 (delta 0), reused 0 (delta 0), pack-reused 457
Receiving objects: 100% (457/457), 741.53 KiB, done.
Resolving deltas: 100% (144/144), done.
fatal: reference is not a tree: 32c72bb5f075f6f2ce93fa37a677de4cf507ed70
Unable to checkout '32c72bb5f075f6f2ce93fa37a677de4cf507ed70' in submodule path 'includes/tools/MPQExtractor'
Installation fail, page white
Hello
Shields block value is incorrect:
http://woehead.way-of-elendil.fr/?item=28606 you can see "Block: 42" (line 5) but it's a duplicate of equipment spell. If you check item ingame, stat is different: https://lut.im/scdUKdpArJ/ALaoDTXaIJEBuIG2.png (Block: 122).
Ty
After dcff6f6 zones for non wotlk donjon are shown, but informations like: NPCs, Objects, Starts quest are not listed.
only Fishing, spells and zones are there.
Strict Standards: Non-static method DbSimple_Generic::connect() should not be called statically in includes/database.class.php on line 29
Strict Standards: Non-static method DbSimple_Generic::parseDSN() should not be called statically in /includes/libs/DbSimple/Generic.php on line 92
Hello again,
I use this great Aowow on site http://3server.net:8088/ but I have almost empty page.
I figured out why - Aowow ignore ":" in static and site host from ?_config as you can see here:
var g_staticUrl = "http://3server.net8088/static";
var g_host = "http://3server.net8088";
Can you help me?
As said in tittle, importaing quests from trinity database does not seem to work for me.
See log details :
06:37:11 * sets 193588 - 195403 06:37:11 * sets 195404 - 300205 06:37:12 [OK] - subscript 'objects' returned sucessfully 06:37:12 SqlGen::generate() - filling aowow_pet with data 06:37:13 [OK] - subscript 'pet' returned sucessfully 06:37:13 SqlGen::generate() - filling aowow_quests with data 06:37:13 * sets 1 - 06:37:14 * sets 1 - 06:37:15 * sets 1 - 06:37:16 * sets 1 - 06:37:17 * sets 1 -
the *sets 1 - seems to be an endless loop...
Rev. 92b180c
As the title says. This would allow to properly diff the file. Size shouldn't be a problem (330 KB).
See the name of the sound id.
?spell=75767 shows Play Music: (17487).
On wowhead you can see the name and actually play the sound file.
http://www.wowhead.com/spell=75767/dnd-music
Event-GnomereganEventComplete
This way, it's easyier to see what soundid if for what. Quicker scripting and finding what is what.
the maps do not shown...
the npc respawn points are not shown and tells "the location of npc is unknown"
but in http://aowow.meedns.com/?npc=31084 i saw it is showing the map and respawn points...
there is a error in zones for example when you want
http://127.0.0.1/aowow-master/?zones=2.1
it says : There is no data to display.
and when u wana to see for example a specific zone like "Dusk Wood"
http://aowow.meedns.com/?zone=10
it says: fatal error: Class 'zonePage' not found in E:\Xamp\htdocs\aowow-master\index.php on line 89
but in http://aowow.meedns.com it works fine
will these systems push to main project?
and what is the trinity db revision for this application?
best regards
If I have added new custom npc items,can it be shown?
and If do some related restrictions, how to remove this restriction or how to add support for custom items,npc
Hello,
Can you edit readme(file) and add more instructions how setup your Aowow?
Where should i download images?
Where should i place it?
i see only http://www.imgup.cz/image/gqn
Thx, for reply.
http://aowow.dyndns.org/?latest-comments
Warning: require(pages/miscTools.php): failed to open stream: No such file or directory in C:\xampp\htdocs\aowow\index.php on line 108
Fatal error: require(): Failed opening required 'pages/miscTools.php' (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\aowow\index.php on line 108
When I link to the site:
The website is currently closed for maintenance.
This will take a few minutes...
PHP 5.5.17
Hi. Thanks for revival this project :)
I tried to install "from the clean" and confused at the last step.
My steps are:
./MPQExtractor -e "DBFilesClient/*.*" -f -o out $1
./MPQExtractor -e "Interface/WorldMap/*.*" -f -o out $1
./MPQExtractor -e "Interface/FrameXML/GlobalStrings.lua" -f -o out $1
./MPQExtractor -e "Interface/TalentFrame/*.*" -f -o out $1
./MPQExtractor -e "Interface/Glues/Credits/*.*" -f -o out $1
./MPQExtractor -e "Interface/Icons/*.*" -f -o out $1
./MPQExtractor -e "Interface/Spellbook/*.*" -f -o out $1
./MPQExtractor -e "Interface/PaperDoll/*.*" -f -o out $1
./MPQExtractor -e "Interface/GLUES/CHARACTERCREATE/*.*" -f -o out $1
./MPQExtractor -e "Interface/Pictures/*.*" -f -o out $1
./MPQExtractor -e "Interface/PvPRankBadges/*.*" -f -o out $1
./MPQExtractor -e "Interface/FlavorImages/*.*" -f -o out $1
./MPQExtractor -e "Interface/Calendar/Holidays/*.*" -f -o out $1
./MPQExtractor -e "Interface/GLUES/LOADINGSCREENS/*.*" -f -o out $1
backup-ruRU.MPQ
base-ruRU.MPQ
expansion-locale-ruRU.MPQ
expansion-speech-ruRU.MPQ
lichking-locale-ruRU.MPQ
lichking-speech-ruRU.MPQ
locale-ruRU.MPQ
patch-ruRU.MPQ
patch-ruRU-2.MPQ
patch-ruRU-3.MPQ
speech-ruRU.MPQ
But most tables are empty. Except few like aowow_itemenchantment (2,656 rows), aowow_quests_startend (11,797 rows) and some others (just 4-5 tables). I tried to run
$ php aowow --sql
But it doesn't help. (log is ok, seems everything is fine, but tables are empty)
php aowow --sql
07:31:56 begin generation of achievementcategory, achievementcriteria, glyphproperties, itemenchantmentcondition, itemextendedcost, itemlimitcategory, itemrandomproppoints, lock, mailtemplate, scalingstatdistribution, scalingstatvalues, spellfocusobject, spellrange, spellvariables, totemcategory, talents, classes, factions, factiontemplate, holidays, icons, itemrandomenchant, races, shapeshiftforms, skillline, emotes, itemenchantment, achievement, creature, currencies, events, objects, pet, quests, quests_startend, spell, spelldifficulty, taxi, titles, items, spawns, zones, itemset, item_stats, source
07:31:56 SqlGen::generate() - copying achievement_category.dbc into aowow_achievementcategory
07:31:56 reading MPQdata from setup/mpqdata/ to list for first time use...
07:31:56 done
07:31:56 - reading and merging data from setup/mpqdata/ruRU/DBFilesClient/Achievement_Category.dbc
07:31:56 [OK] - subscript 'achievementcategory' returned sucessfully
07:31:56 SqlGen::generate() - copying achievement_criteria.dbc into aowow_achievementcriteria
07:31:56 - reading and merging data from setup/mpqdata/ruRU/DBFilesClient/Achievement_Criteria.dbc
07:31:58 [OK] - subscript 'achievementcriteria' returned sucessfully
07:31:58 SqlGen::generate() - copying glyphproperties.dbc into aowow_glyphproperties
07:31:58 [OK] - subscript 'glyphproperties' returned sucessfully
07:31:58 SqlGen::generate() - copying spellitemenchantmentcondition.dbc into aowow_itemenchantmentcondition
07:31:58 - reading data from setup/mpqdata/ruRU/DBFilesClient/SpellItemEnchantmentCondition.dbc
07:31:58 [OK] - subscript 'itemenchantmentcondition' returned sucessfully
07:31:58 SqlGen::generate() - copying itemextendedcost.dbc into aowow_itemextendedcost
07:31:58 - reading data from setup/mpqdata/ruRU/DBFilesClient/ItemExtendedCost.dbc
07:31:59 [OK] - subscript 'itemextendedcost' returned sucessfully
07:31:59 SqlGen::generate() - copying itemlimitcategory.dbc into aowow_itemlimitcategory
07:31:59 - reading and merging data from setup/mpqdata/ruRU/DBFilesClient/ItemLimitCategory.dbc
07:31:59 [OK] - subscript 'itemlimitcategory' returned sucessfully
07:31:59 SqlGen::generate() - copying randproppoints.dbc into aowow_itemrandomproppoints
07:31:59 - reading data from setup/mpqdata/ruRU/DBFilesClient/RandPropPoints.dbc
07:31:59 [OK] - subscript 'itemrandomproppoints' returned sucessfully
07:31:59 SqlGen::generate() - copying lock.dbc into aowow_lock
07:31:59 [OK] - subscript 'lock' returned sucessfully
07:31:59 SqlGen::generate() - copying mailtemplate.dbc into aowow_mailtemplate
07:31:59 - reading and merging data from setup/mpqdata/ruRU/DBFilesClient/MailTemplate.dbc
07:31:59 [OK] - subscript 'mailtemplate' returned sucessfully
07:31:59 SqlGen::generate() - copying scalingstatdistribution.dbc into aowow_scalingstatdistribution
07:31:59 [OK] - subscript 'scalingstatdistribution' returned sucessfully
07:31:59 SqlGen::generate() - copying scalingstatvalues.dbc into aowow_scalingstatvalues
07:31:59 [OK] - subscript 'scalingstatvalues' returned sucessfully
07:31:59 SqlGen::generate() - copying spellfocusobject.dbc into aowow_spellfocusobject
07:31:59 - reading and merging data from setup/mpqdata/ruRU/DBFilesClient/SpellFocusObject.dbc
07:31:59 [OK] - subscript 'spellfocusobject' returned sucessfully
07:31:59 SqlGen::generate() - copying spellrange.dbc into aowow_spellrange
07:31:59 - reading and merging data from setup/mpqdata/ruRU/DBFilesClient/SpellRange.dbc
07:31:59 [OK] - subscript 'spellrange' returned sucessfully
07:31:59 SqlGen::generate() - copying spelldescriptionvariables.dbc into aowow_spellvariables
07:31:59 - reading data from setup/mpqdata/ruRU/DBFilesClient/SpellDescriptionVariables.dbc
07:31:59 [OK] - subscript 'spellvariables' returned sucessfully
07:31:59 SqlGen::generate() - copying totemcategory.dbc into aowow_totemcategory
07:31:59 - reading and merging data from setup/mpqdata/ruRU/DBFilesClient/TotemCategory.dbc
07:31:59 [OK] - subscript 'totemcategory' returned sucessfully
07:31:59 SqlGen::generate() - filling aowow_talents with data
07:31:59 [OK] - subscript 'talents' returned sucessfully
07:31:59 SqlGen::generate() - filling aowow_classes with data
07:31:59 - reading and merging data from setup/mpqdata/ruRU/DBFilesClient/Spell.dbc
Any ideas?
Thanks!
Hi, the option "Sticky All" for mass selection doesn't work.
(You tell me on IRC if we have contributors, to warn you. We have a lot eh eh)
Hi
This is not exacly an issue, is more like a question. http://aowow.dyndns.org its actualized to the last change in the branch work or is in the branch stable? because i see the pages of items, itemlist and spells dont work
Thanks
It appears from the most recent commit that you're doing some work to make this compatible with Windows. I've ran into a couple of hiccups while setting this up and thought I'd document them here:
php aowow --firstrun --resume
set_time_limit(180)
set_time_limit(250)
(this was too high I'm sure, tried to tweak it to a sane amount, but never could get it right)set_time_limit(50)
After these changes, I've ran through the installer start to finish without anything hanging up. I couldn't ever get the MPQ Extractor to compile properly under Win7 x64, so I used MPQEditor (from http://www.zezula.net/en/mpq/download.html) and imported all MPQs in merge mode, then cherry picked what was needed. The site is working great! I'm still exploring each area to make sure I got everything right.
No showstopping issues with your code at all, just sharing some guidance for us Windows folk!
Array
(
[code] => 1054
[message] => Unknown column 'faction' in 'field list'
[query] =>
SELECT
go.entry,
`type`,
IF(`type` = 2, -2, -- quests 1
IF(`type` = 8 AND Data0 IN (1, 2, 3, 4, 1552), -6, -- tools
IF(`type` = 3 AND IFNULL(gqi.ItemId, 0) 0, -2, -- quests 2
IF(`type` IN (3, 9, 25), `type`, 0)))), -- regular chests, books, pools
0 AS event, -- linked worldevent
displayId,
go.name,
gtl2.`name` AS name_loc2,
gtl3.`name` AS name_loc3,
gtl6.`name` AS name_loc6,
gtl8.`name` AS name_loc8,
faction,
flags,
0 AS cuFlags, -- custom Flags
IF(`type` IN (3, 25), Data1, 0), -- lootId
IF(`type` IN (2, 3, 6, 10, 13, 24, 26), Data0, IF(`type` IN (0, 1), Data1, 0)), -- lockId
0 AS reqSkill, -- reqSkill
IF(`type` = 9, Data0, IF(`type` = 10, Data7, 0)), -- pageTextId
IF(`type` = 1, Data3, -- linkedTrapIds
IF(`type` = 3, Data7,
IF(`type` = 10, Data12,
IF(`type` = 8, Data2, 0)))),
IF(`type` = 5, Data5, -- reqQuest
IF(`type` = 3, Data8,
IF(`type` = 10, Data1,
IF(`type` = 8, Data4, 0)))),
IF(`type` = 8, Data0, 0), -- spellFocusId
IF(`type` = 10, Data10, -- onUseSpell
IF(`type` IN (18, 24), Data1,
IF(`type` = 26, Data2,
IF(`type` = 22, Data0, 0)))),
IF(`type` = 18, Data4, 0), -- onSuccessSpell
IF(`type` = 18, Data2, IF(`type` = 24, Data3, 0)), -- auraSpell
IF(`type` = 30, Data2, IF(`type` = 24, Data4, IF(`type` = 6, Data3, 0))), -- triggeredSpell
IF(`type` = 29, CONCAT_WS(" ", Data14, Data15, Data16, Data17, Data0), -- miscInfo: capturePoint
IF(`type` = 3, CONCAT_WS(" ", Data4, Data5, Data2), -- miscInfo: loot v
IF(`type` = 25, CONCAT_WS(" ", Data2, Data3, 0),
IF(`type` = 23, CONCAT_WS(" ", Data0, Data1, Data2), "")))), -- miscInfo: meetingStone
IF(ScriptName "", ScriptName, AIName)
FROM
gameobject_template go
LEFT JOIN
gameobject_template_locale gtl2 ON go.entry = gtl2.entry AND gtl2.`locale` = "frFR"
LEFT JOIN
gameobject_template_locale gtl3 ON go.entry = gtl3.entry AND gtl3.`locale` = "deDE"
LEFT JOIN
gameobject_template_locale gtl6 ON go.entry = gtl6.entry AND gtl6.`locale` = "esES"
LEFT JOIN
gameobject_template_locale gtl8 ON go.entry = gtl8.entry AND gtl8.`locale` = "ruRU"
LEFT JOIN
gameobject_questitem gqi ON gqi.GameObjectEntry = go.entry
WHERE
go.entry > 0
GROUP BY
go.entry
LIMIT
1000
[context] => /home/www/setup/tools/sqlgen/objects.func.php line 105
)
Gameobject localization was moved from denormalized table "locales_gameobject" to normalized table "gameobject_template_locale".
Corresponding TC commit: TrinityCore/TrinityCore@9245bad
Now setup is failing due to old structure:
[message] => Table 'world.locales_gameobject' doesn't exist
Hi Sarjuuk
I want this aowow to support zhTW, so i have to create some files:
Similar to:
Ocale_zhTW.lua.php
Locale_zhTW.js
GlobalStrings.lua (already have. but I don't know where to upload. 💔 )
i mean is there some tools or simple utility functions to do it ?
It's too slow by hands... yes Yes, I'm dead serious: OMG
In you current code you use:
while ($items = DB::World()->select($baseQuery, $lastMax, $ids ?: DBSIMPLE_SKIP, $offset, SqlGen::$stepSize))
You changed this in your last commit. $offset is still in this code while not used / initialized anymore. Resulting in failure of this total function. Remove the parameter (reducing number of parameters once again to three) and it works.
This also corrected the FileGen Glyph problem for me (issue #69). It could not handle an empty item table.
Keep up the good work!
Parse error: syntax error, unexpected '$id' (T_VARIABLE) in /includes/types/basetype.class.php on line 277
PHP Version 5.4.4-14+deb7u11
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.