Git Product home page Git Product logo

aowow's People

Contributors

afrom avatar carbenium avatar endalaust avatar helias avatar hellokitty avatar jackpoz avatar magnifikator avatar metalaka avatar opiums9 avatar sarjuuk avatar srzmgit avatar toshik avatar treeston avatar wodim avatar zackbcom avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

aowow's Issues

setup crash on glyphs data generation

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?

Installation

Hello,
Can you please provide a detailed installation guide in the README?

I've tried installing this but i get the following error:
error
I'm using Apache: 2.4.9
MySQL: 5.6.17
PHP: 5.5.12
And i did the following steps:

  1. Cloned the repo.
  2. Uploaded the files in my www folder.
  3. Created a new database named 'aowow'.
  4. Went to the folder config and removed the .in extension from every file.
  5. Edited the config.php with the required info.
  6. Extracted db_setup_1.zip, db_setup_2.zip, db_setup_3.zip, db_content.rar .
  7. Run the above databases + the config.sql, in my previous created 'aowow' db.

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!

db_structure.sql data inconsistency

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,'');

install error

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

[NPCs] DB Error - Lost connection to MySQL server during query.

/?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

zones does not show low level dungeon and raid

Setup not working with cli

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.

firstrun fails

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_achievementcategory

09: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?

Build Gems

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
)

Installation problem

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
  • I cant understand localeCode mean,Maybe it's because I didn't finish the extract step.

.. 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 ! ✨

MPQExtractor included as submodule will not compile

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.

Parse error - loot.class.php

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.

Insert special character inside DB

Hello, when user writes "à" in comment, the program inserts &agrave in the database. And of course, display something like this "Bienvenue &agrave ; John Doe"

Ty

Cannot clone submodule MPQExtractor

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'

Mistake on all pages

DB ERROR:

Array
(
    [code] => 1054
    [message] => Unknown column 'status' in 'where clause'
    [query] => SELECT * FROM aowow_announcements WHERE status = 1 AND (page = 'talent' OR page = "*")
    [context] => E:\OpenServer\domains\workbase\includes\utilities.php line 726
)

screenshot 2

Issues with Strict Standards

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

Aowow ignore port

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?

importing quests from world database fail

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...

Maps & Respawn & Zones

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

limit the custom items,npc etc?

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

Errors

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

Cannot sync aowow with world database

Hi. Thanks for revival this project :)
I tried to install "from the clean" and confused at the last step.
My steps are:

  1. Cloned repo
  2. Successfully compiled MPQExtractor
  3. Created sh script:
./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
  1. Moved this script to World of Warcraft/Data/ruRU directory (with MPQExtractor ofc)
  2. Launched for next files in order:
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
  1. Moved new "out" (443 mb) dir to setup/mpqdata/ruRU
  2. Created new user "aowow" with full access to aowow db (and select to chars, world and auth) + imported db_structure.sql file to aowow db
  3. $ chmod 777 cache static config
  4. php aowow --firstrun
    Everything here is ok (setup db connections etc) and sync is ok.

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!

Project Status

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

Working with Windows

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:

  1. After entering database config during first run, the walkthrough exits as soon as I press Enter. This was easy to get around as I just had to type php aowow --firstrun --resume After some tweaks, ran again and didn't have to ever resume the firstrun. Disregard.
  2. Once I got that sorted out, the installer kept dying while importing Spell.dbc. Went to task manager and noticed my PHP got to 128M and exited. Changed memory_limit variable in php.ini a few times until I finally set it to 2048M which allowed me to continue. (I think the highest the memory got was about 1280M)
  3. Some of the hardcoded time limits in the filegen files weren't long enough. It could be my machine, but resources weren't out of hand while script was running. Files below:
  • /setup/tools/filegen/enchants.func.php -> set_time_limit(180)
  • /setup/tools/filegen/profiler.func.php Mounts section -> 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)
  • /setup/tools/filegen/profiler.func.php Companions section -> 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!

Error bjects.func.php line 105

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

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

About Localization

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

Error in select call in items.func.php

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!

Page not Working

Parse error: syntax error, unexpected '$id' (T_VARIABLE) in /includes/types/basetype.class.php on line 277

PHP Version 5.4.4-14+deb7u11

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.