coa/aowow
3
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions

Commit graph

  • 1c88254a06 style: drop redundant semicolons after function declarations (filegen templates + static js) master Florian Berthold 2026-06-10 06:13:19 +02:00
  • 1491db51e3 Template/Cleanup * \n to PHP_EOL * add phpdoc for autocomplete * try to unify indentations * stop mixing quotation marks if possible Sarjuuk 2026-04-11 20:45:01 +02:00
  • 9fc6f7896e Profiler/Fixup * fix achievementpoint total being the sum of both factions Sarjuuk 2026-04-09 20:17:51 +02:00
  • 725686d1cd Setup/Help * be more clear that connecting to auth and characters db is conditional * updated some lost references to renamed databases and config options Sarjuuk 2026-04-08 14:43:30 +02:00
  • 20f38e1c2b
         Readme/Fixup (#503) emv33 2026-04-03 01:13:02 +02:00
  • 8ded8e8e97 Filter/Fixup * sanitize input before trying to construct filter and redirect Sarjuuk 2026-03-30 18:13:09 +02:00
  • 681d29e5f3 Search/Indexing * add reversed words and update token processing to allow fulltext search to match end of word (e.g. searching 'wind -storm' will now find 'whisperwind' or 'windrunner' and ignore 'stormwind') * fix search token duplication for spells Sarjuuk 2026-03-28 21:12:43 +01:00
  • 764ea1c7fa Setup/Spells * manually set several trade skills and related items as unavailable * don't use unavailable trade skills to resolve reagent dependencies on Spell Detail Page * closes #499 Sarjuuk 2026-03-27 00:06:17 +01:00
  • 7906b6c942 Localization/Fixup * localize "unnamed" text for gameobjects and areatrigger * fix empty links in Quest Detail Page for quests with external completion event but empty AreaDescription * closes #501 Sarjuuk 2026-03-26 15:22:11 +01:00
  • 38dc0e834e Search/Fixup * fix creature indices only including creatures with name AND subname * closes #500 Sarjuuk 2026-03-25 20:54:28 +01:00
  • c93417301a Quests/Fixup * fix showing "Gains:" header on detail page if there is nothing to be gained Sarjuuk 2026-03-22 16:34:40 +01:00
  • edfe800348 Sitemap/Fixup * fix broken link to icons * fixes #498 Sarjuuk 2026-03-16 20:34:14 +01:00
  • 7c9131eca8 Misc/Fixup * fix formated money having trailing whitespaces if copper amount was 0 * also cleanup Sarjuuk 2026-03-12 21:38:34 +01:00
  • 0d645334cb Sitemap * generate and link basic sitemap Sarjuuk 2026-03-05 11:37:55 +01:00
  • 5a230daad6 Search/Indexing * move fulltext indizes for tables /w ~10k+ rows to separate tables > sounds have ~12k but names are effectively incompatible with FTI * normalize searchable strings to catch edgecases > preparse spell descriptions + buffs > move effect text cols of items to new table * also fix extended search of creatures, spells & quests Sarjuuk 2026-03-03 14:58:19 +01:00
  • 2161a7b846 Search/Fixup * dashes also split words into multiple tokens, so they are now stripped from search entirely (see: 'weather-beaten') * only search for the full search input if the tokenizer didn't yield any fulltext tokens. This should fix search performance after 00f048d3ae * fixes #497 Sarjuuk 2026-02-27 12:02:16 +01:00
  • 297d678270 Cookies/Fixup * fix storing Item Summary state * amends e421bdba79 Sarjuuk 2026-02-26 19:15:23 +01:00
  • 254f3f7f1a Filter/Fixup * fix criterium related world event:none excluding unspawned entities Sarjuuk 2026-02-26 10:49:18 +01:00
  • c85675e181 Setup/DBCReader * port extended client file handling from other branch * class DBC -> DBCReader now initializes a DBCFile which itself is a BinaryFile * update DBCReader to use the new DB wrappers multi-insert feature Sarjuuk 2026-01-19 22:34:59 +01:00
  • 69df50619a DB/Dependency * remove unmaintained DbSimple * add package db/dibi as substitute db abstraction Sarjuuk 2026-01-05 18:34:19 +01:00
  • 8a404b32aa ProfilerExclusions/Fixup * fix including all exclude groups Sarjuuk 2026-02-26 10:35:33 +01:00
  • 1556a5e4c9 ItemFilter/Fixup * fix including jewelcrafter only gems toggle in weights Sarjuuk 2026-02-26 10:36:20 +01:00
  • 15f20a63f7 Quests/Fixup * fix 'Side' displayed in infobox on detail page * don't display 'Races' in infobox if they encompass an entire faction Sarjuuk 2026-02-24 17:53:56 +01:00
  • 750e176c33 Stats/Fixup * fix melee attack power from spells counting towards generic attack power * combine melee and ranged attack power from the same spell into generic attack power, if amounts are equal Sarjuuk 2026-02-24 13:12:40 +01:00
  • f7a1ae241f Quest/Fixup * fix unused quests being shown in quest series on detail page Sarjuuk 2026-02-14 22:37:23 +01:00
  • 6051ef5a4a Misc/Cleanup * update some unit flags / bytes Sarjuuk 2026-02-13 22:12:23 +01:00
  • f6d7ccbb69 Quest/Filter * update quest flags to current knowledge base * implemented filter criterium for pvp-enabling quests Sarjuuk 2026-02-13 00:34:07 +01:00
  • 68ca4973b1 Items/Filter * implement 'effect text' filter * slight cleanup in itemset setup to match changes for effect text Sarjuuk 2026-02-12 12:11:00 +01:00
  • 84d2e30940 Filters/Fixup * implement NPC 'has location' criterium * fix NPC 'uses model' criterium using string comparison on int values Sarjuuk 2026-02-12 10:28:23 +01:00
  • 2216b664fa DBTypes/Filters * filters should test string input during initialization, so errors can be passed on to the PageTemplate. * have strings be compared for identity by default and (NOT) LIKE as optional operator * note: if a string criterium gets processed via callback function it will not get prechecked Sarjuuk 2026-02-12 00:25:54 +01:00
  • 9d187e8d4c StatWeights/Fixup * move weightable stats from Util to Stat * align what stats can be saved in weightscales to match javascript Sarjuuk 2026-02-12 00:05:42 +01:00
  • 00f048d3ae Search/Fixup * readd regular indizes for name cols. There are cases where entities are named in a way that does not work with FT indizes. ex. "XT:9" is two tokens "XT", "9" which are too short to be indexed. * additionally to FT search also exact match col to search string. Sarjuuk 2026-02-09 09:53:08 +01:00
  • e421bdba79 PageTemplate/Cookies * set path and domain on consent cookie * if page uses https, tag cookies as secure * use samesite=lax so cookies get sent if user visits via external link Sarjuuk 2026-02-04 23:23:45 +01:00
  • 511e1a78e6 PageTemplate/Styles * set styles for audio controls so they visually fit on chrome Sarjuuk 2026-02-04 23:23:40 +01:00
  • 3510c8211c Spells/Scaling * implement tooltip scaling calculation for spells with attribute SPELL_ATTR0_LEVEL_DAMAGE_CALCULATION * I don't know why i loaded item scales as spell scales a decade ago. Lets hope removing that didn't break stuff. Sarjuuk 2026-02-05 17:47:41 +01:00
  • 55f599bbb8 Game/WorldPosition * rework map pos -> zone pos calculation. It was kinda stupid to run a query for each individual spawn point. So cache all wma entries per map and do the calculation in php. Sarjuuk 2026-02-05 06:35:49 +01:00
  • 5258290332 Profiler/Cleanup * cleanup in sync / queue Sarjuuk 2026-02-01 22:50:10 +01:00
  • a29c88fe78 Profiler/Fixup * fix Profile tooltips not loading if the triggering url wasn't entirely in lowercase Sarjuuk 2026-02-02 18:50:43 +01:00
  • 83ec057dea PageTemplate/Fixup * fix not setting consentFooter for all cases and occasionally importing its value from cache Sarjuuk 2026-02-01 17:29:28 +01:00
  • 1292fa90bd Profiler/Fixup * handle special sourcemore dungeondifficulty 99 in Profiler summaries (unclear if i'm doing it wrong or if sm.dd:99 is newer than the Profiler) Sarjuuk 2026-01-30 23:54:19 +01:00
  • a21feab939 Profiler/Fixup * catch failing queries for characters, arena teams and guilds on realm Sarjuuk 2026-01-30 20:08:50 +01:00
  • dfabc9464d Profiler/Fixup * fix tooltips for profiles pending rename Sarjuuk 2026-01-30 15:39:16 +01:00
  • 4f4f68bd66 Profiler/Fixup * don't increment index for renamed chars again when a known to rename chars stub is synced Sarjuuk 2026-01-30 15:27:13 +01:00
  • 09f14ee4e1 Setup/Fixup * column keys names like to be unquoted * amends cadb4aa0d3 Sarjuuk 2026-01-30 00:40:42 +01:00
  • 7e4e52de7b Setup/Fixup * remove extraneous , from query added in cadb4aa0d3 Sarjuuk 2026-01-29 23:43:14 +01:00
  • 62d898173a Account/Fixup * fix referencing nonexistent error message if password validation fails * fixes #488 Sarjuuk 2026-01-29 22:33:43 +01:00
  • 021cdf6228 Spells/Glyphs * link back from applied spell to applying glyph spell via new tab: glyphs * closes #489 Sarjuuk 2026-01-29 21:52:03 +01:00
  • 08318d286c Objects/SpellFocus * link from spellfocus in objects and spell infobox to objects filter if able * closes #491 Sarjuuk 2026-01-29 21:30:57 +01:00
  • 26292d17c5 Objects/Fixup * don't show loot charges in infobox if restock cd is set but min/max charges are not * fixes #493 Sarjuuk 2026-01-29 21:10:17 +01:00
  • b25a70458b Help/Fixup * manually set articleUrl so help pages have content again Sarjuuk 2026-01-29 20:49:10 +01:00
  • c58b073a73 Quests/Fixup * fix inconsistency in linking to categoy: uncategorized (-2) * fixes #485 Sarjuuk 2026-01-28 19:50:55 +01:00
  • cadb4aa0d3 Icons/Fixup * reference original icon names/paths during setup * fixes #487 * amends 1e1ce29438 Sarjuuk 2026-01-28 19:24:11 +01:00
  • 08ae564a48 PageTemplate/Fixup * escape input username on user page Sarjuuk 2026-01-27 14:23:27 +01:00
  • 0378a84373 Routing/Fixup * always route requests where page equals page parameter (i.e. /?spell=spell; /?user=user) to BaseResponse * fixes #486 Sarjuuk 2026-01-27 14:09:53 +01:00
  • e675a8f953 PageTemplate/Fixup * Don't try to be smart with the helper methods as they are used to escape user input. Sarjuuk 2026-01-26 20:01:26 +01:00
  • c6d92031c5 Quests/Fixup * fix converting min/max reputation requirements to TC condition on detail page (it still lacks the exact amount) * also Game::getReputationLevelForPoints was off by 1 Sarjuuk 2026-01-25 18:57:50 +01:00
  • 5f7247b292 Quest/Misc * move honor/arena point reward to gains on detail page so it no longer looks like an item Sarjuuk 2026-01-23 23:05:55 +01:00
  • 98763c3060 Setup/Fixup * fix calculation of honor reward Sarjuuk 2026-01-23 18:41:53 +01:00
  • 4c598972cc Search/Misc * why loop when regex does trick * further unify variable naming and layout Sarjuuk 2026-01-19 20:12:17 +01:00
  • 09fe715bc1 Spells/Fixup * add forgotten filter criterium 43 - usableinbgs * fixes #484 Sarjuuk 2026-01-19 19:46:49 +01:00
  • 15338dc503 PageTemplate/Fixup * only need to ask for consent if analytics is enabled * fixes #483 Sarjuuk 2026-01-19 19:35:48 +01:00
  • 53374972ef Search/Fixup * strip leading/trailing dashes from search tokens. Casues FT syntax errors when combined with our own modifiers Sarjuuk 2026-01-19 19:30:03 +01:00
  • 0ea5477d6e Items/Fixup * fix spell struct to calculate stats from when viewing item XML Sarjuuk 2026-01-19 19:27:43 +01:00
  • 2e8abf6dff PageText/Misc * $t is probably the players HK rank. Fill with name for lowest rank. Sarjuuk 2026-01-18 11:27:56 +01:00
  • 6df9145446 Search/Fixup * do not use stopwords in fulltext search apparentyl there is a bug in innodb where including stopwords in a search causes the lookup to fail entirely. e.g. innodb_ft_enable_stopword must be disabled when the index is edited (rows are added/removed) * don't create a MATCH AGAINST search from empty search strings after sanitization * drop fulltext indizes for locale zhCN logographic languages need special treatment, which handling may differ by db provider * use LIKE search by default for locale zhCN. Added config option to use fulltext if supported by db. Sarjuuk 2026-01-17 19:08:50 +01:00
  • 7616ec25fc DB/Search * add more indizes to large tables for cols used in lookups * drop multi-column indizes on spell as they are not utilized by mysql * add and use fulltext indizes for names of items, spells, quests, creatures & objects could add more, but is it really necessary? * limitations - still need a solution for race/class/spellFamily masks cols that are used as such - fulltext indizes in boolean mode cant partial match the end of a word. reverse name cols and search and match back to front like that..? blows up db size even more though (+trike* : "stormstrike" => +ekirt* : "ekirtsmrots") Sarjuuk 2026-01-16 01:29:04 +01:00
  • a89eef5736 Setup/Fixup * fix required class/race masks on items and quests during import instead of on demand Sarjuuk 2026-01-15 23:47:02 +01:00
  • 2ef3f575c3 PageTemplate/Misc * fetch user vars on __wakeup / __construct so the queries get picked up by the DB profiler * unset temporary vars before serialization * reduce redundancy Sarjuuk 2026-01-15 22:43:00 +01:00
  • 59506dda11 DB/Profiler * add indizes to searchable cols to hopefully speed up page loads Sarjuuk 2026-01-14 17:05:51 +01:00
  • b4f40b4264 Filter/Fixup * only criteria should be affected by the match any/none selector * multi-selects are never null and shouldn't be tested as such. Sarjuuk 2026-01-13 21:38:53 +01:00
  • a5129b46b2 Template/Fixup * remove excess colons from profiler related filters Sarjuuk 2026-01-13 21:00:35 +01:00
  • a465de1653 Spells/Effects * link to map with start/end position for SPELL_EFFECT_SEND_TAXI Sarjuuk 2026-01-13 19:11:47 +01:00
  • 03fb4045dc JS/Date * add localeaware Date.getLocaleDay method and reorder week days array * calendars should now have a region approriate first day of the week Sarjuuk 2026-01-11 18:46:37 +01:00
  • ce020204cb Events/Fixup * fix events occupying an additional day in calendar view if starting and ending at 0:00 Sarjuuk 2026-01-11 17:43:25 +01:00
  • 40717a8057 Site/Layout * increase site layout further to make the Icons grid fit entirely * amends b3e215cc40 Sarjuuk 2026-01-09 17:29:48 +01:00
  • face95c1dd PageTemplate/Consent * fix showing consent overlay when cookie is already set Sarjuuk 2026-01-09 17:22:37 +01:00
  • a17d4a5528 Quests/Cleanup * render quest objectives on detail page by var type instead of magic number Sarjuuk 2026-01-07 23:07:37 +01:00
  • 793dc4dfdd Dependencies/Composer * use composer to manage future dependencies Sarjuuk 2026-01-05 18:34:07 +01:00
  • d686f87467 User/Fixup * fix my-guides query on user page Sarjuuk 2026-01-07 20:41:26 +01:00
  • a6438454d6 Misc/Cleanup * remove namespace includes sneakily auto placed by vscode Sarjuuk 2026-01-05 01:23:12 +01:00
  • e96fafaf8b Quests/Fixup * show related quests on detail page for events without associated holiday * closes #480 Sarjuuk 2026-01-03 18:07:24 +01:00
  • 6077c39055 Account/Avatar * minor cleanup * make use of array_find_key polyfill Sarjuuk 2026-01-02 17:24:23 +01:00
  • 8417b6854b PageTemplate/Fixup * fix broken external links from detail pages * amends 715c1534eb * closes #477 Sarjuuk 2026-01-02 17:05:58 +01:00
  • a4629a4f6f Events/Fixup * fix related items tab showing all the items when none should be shown * amends c44bf4f575 * closes #478 Sarjuuk 2026-01-02 16:35:46 +01:00
  • de911d0db6 Profiler/Tooltips * add some spacing between spell school and value Sarjuuk 2026-01-01 15:42:34 +01:00
  • e88bbb774f Misc/Fixup * yearly year increment Sarjuuk 2026-01-01 01:28:38 +01:00
  • 715c1534eb Core/Endpoints * don't use raw input to recreate subcategories for filter urls and external links * if a page does not expect categories it will now error out if it is called with parameters * fixed infite redirect loop that could occur if the pageName was an invalid string * added lost filter string for external page call to NPCs Page Sarjuuk 2026-01-01 01:15:08 +01:00
  • 23c5c71f4a Misc/Fixup * fixed crash when bit blob contains trailing whitespace Sarjuuk 2025-12-30 20:39:22 +01:00
  • 6c1b4e4e1a SQL/Fixup * update zoneOrSort > questSortId in custom data table * amends eec21c2763 Sarjuuk 2025-12-30 20:21:46 +01:00
  • eec21c2763 Quests/Fixup * rename columns of quests table to avoid name collisions and to match the dbc they are referencing * fixes #463 Sarjuuk 2025-12-30 19:15:06 +01:00
  • c44bf4f575 Config/Misc * hardcode sql limits within their respective components instead of having them configurable * creating a new DBTypeList defaults it to being unlimited * SQL_LIMIT_NONE (0) > removed as it only existed for consistency * SQL_LIMIT_DEFAULT (300) > frontend / Listview::DEFAULT_SIZE * SQL_LIMIT_SEARCH (500) > Search::DEFAULT_MAX_RESULTS * SQL_LIMIT_QUICKSEARCH (10) > Search::SUGGESTIONS_MAX_RESULTS Sarjuuk 2025-12-30 02:55:43 +01:00
  • b9d888ab3a Compat/TDB * update conditions with changes from TC > 4fd3669f1b Sarjuuk 2025-12-26 17:21:44 +01:00
  • 2b3b9de8bc Entity/AI * store and display StringIds * unify storage of AI/Scripts for NPCs and Objects * store and display StringIds and AI/Scripts from individual spawns in mapper tooltip and infobox Sarjuuk 2025-12-29 19:23:00 +01:00
  • 9db943e8f4 Compat/TDB * drop references to script_waypoint and waypoints tables, removed in > 91dcae540e > f3b691dcb0 * db requirement bump Sarjuuk 2025-11-16 16:41:07 +01:00
  • 289d5062bd NPC/Objective * must test for KillCredit as there are cases where reqNpcOrGo is 0, but its required count is > 0 * amends d34765eed5 * fixes #475 Sarjuuk 2025-12-28 19:59:53 +01:00
  • 4e848e29a7 Quests/Fixup * fix missing objective quantity if required entity is unknwon * don't display go/npc objective if go/npc id is 0 Sarjuuk 2025-12-28 19:38:31 +01:00
  • 69b8fdcc27 Misc/Cleanup * could have sworn there were more blobs to be indexed.. Sarjuuk 2025-12-26 18:58:43 +01:00
  • 9bbe95d5e8 Search/Fixup * partially revert eb70065e0f as the regex without the /u flag destroys valid umlauts like 'ß' * convert strings from utf8 to utf8 instead to achieve the same effect Sarjuuk 2025-12-26 17:13:29 +01:00
  • 8f9acedb8f Items/Enchantments * cleanup list generation for random enchantments * note that rand enchants should be grouped purely by stat type, which requires more work than it is currently worth Sarjuuk 2025-12-23 21:29:55 +01:00
  • d34765eed5 NPC/Objective * also show quests in objective-of tab the npc has a KillCredit entry for. Sarjuuk 2025-12-21 20:40:46 +01:00