altronrain

Well, compare to other forks this all-in-one installer is just the greatest thing! Yep, at the end there are 3 folders: src (not needed anymore after install), bin with executables, etc with configs (and resources). Pretty simple, same as usual linux-way. There was one odd thing iduring latest install, that etc folder not on the same level as bin and src. But I just moved it. + Yo need to set up right relative path to extracted files (aka DataDir in .conf)

db_struct: rel21_16_040 server branch master 21.14 Allright. If there is no reply I make a vid that confirms manareg in bear form. bear_manareg.mp4

This is still bugged. The root of the issue is : the moment you learn next rank from trainer, the talent point drops from talent tree (it looks 0/1 rank that is awaliable for learning). However you can't spend an extra point there. sorry for longvid again but it illustrates it well. Other talents with similar system that I encountered before (such as Aimed shot, Pyroblast, Blasting wave works pretty well). This one is surely bugged a little. farie_fire_talent.mp4

Well, described issue is sitll exists (look at vid_1 and vid_2: Fluying a zeppelin. Pet not aware of zeppelin existance and trying to follow my xy on tyhe ground level. After travelling pet is not despawned (actually it spawned at the beginning of the tirisfal map in the ocean according to minimap and idk what' next happened with him (her, actually). As a workaround player could dismiss the pet and then call him/her again. But this issue is not about the topic. What can I say about pet despawn at range during travelling? I encountered two types of behaviour (both could be reprodused better when you are fast enough (aka using mount)). The pet will follow you with the nearly same speed. If you aggro a mob and continue running: 1. Pet will make a pair-or-so attacks to the mob then continues following a player, catching him up pretty fast. 2. Pet will stuck in combat and if you run quite far it will despawn. Idk how it should be, but variant 2 proofs TS wrong. In my view, the described issue not matching the title. Described issue is confirmed. Topic statement maybe another issue according to my thoughts and experience of travelling alongside pet simply through the map, but seems not. pets_map_1.mp4 pets_map_2.mp4

Confirm. server branch master 21.14 db_struct rel21_16_040 If hunter gets T1 setbonus (5) then Pet stam really starts changing non-stop. pet_stam_t1.mp4

I can confirm the issue. Being attacked not putting mobs out of sleep. DoT doesn't apply. Also playing up with gm commands and skills, there are interesting thing: each level of Wyvern Sting skill has second-mirrored Wyvern Sting), that is actually DoT itself (instant 50006 yards, according to db), that Do damage, even now. So I suppose one should be swapped for another after sleep breaks. This Dots IDs are: Wyvern Sting DoT (Rank 1) (spell=24131) Wyvern Sting DoT (Rank 2) (spell=24134) Wyvern Sting DoT (Rank 3) (spell=24135) sorry for the long vid. wyvern_sting.mp4

I can confirm that there is an issue with this quest mobs. Tested on latest db_struct of rel21_16_40. Attached vid. screecher_spirits.mp4

Looking through Player.cpp now the only place where such construction appears "m_regenTimer != 0" is around 2162 line. In my opinion dudu now regens mana while in bear form. But to be sure there is still needed a feedback (cause I cannot orient inside this huge .cpp). You could think of this comment like a bump. server branch master 21.14 db_struct rel21_16_040

Hehe, Blizz seems were planning to make a dungeon or whatever with this place 😃 Seems like that. This quest, The Den quest, Elites, Named Elites inside, Named Rare Elites I suppose because of that vanilla have such "rudiments" and u can encounter them from time to time. So, I suppose next statements are true/should be done such way: 1) Yes, the banner was never a requirement to complete the quest. (Seems like it's official). So it's like a toy (maybe it was planned to do something else but it never was implemented). 2) I think it is right way to leave the banner in player's inventory (and some database comments says that it is true but I'm not sure). What if somebody would like to return in this weird place that is far from horde's flight nodes and place this thing again as a proclamation of war? (P.S.: btw aside this quest there are others in vanilla that leaves some quest-related stuff in players inventory (maybe part of them is mangos minor "bugs" but I suppose most of them are official) such as letters, runes or so. Can't give you any detailed info but from time to time scanning inventory I can't remember what is this thing and what it is doing in my inv? Then google says that it is a part of a quest that I've done 10-15 lvls ago) 😃 So, why not to leave this flag inside inventory too? At least it is a usable "toy". This would be blizzlike, I think

2020-04-21 23:01:06 ERROR:Table `db_scripts [type = 2]` has datalong = 315 in SCRIPT_COMMAND_SEND_TAXI_PATH for script id 4041, but this taxi path can be triggered by spell 27998. 2020-04-21 23:01:06 ERROR:Table `db_scripts [type = 2]` has datalong = 494 in SCRIPT_COMMAND_SEND_TAXI_PATH for script id 737901, but this taxi path can be triggered by spell 29931. 2020-04-21 23:01:06 ERROR:Table `db_scripts [type = 2]` has datalong = 495 in SCRIPT_COMMAND_SEND_TAXI_PATH for script id 737902, but this taxi path can be triggered by spell 29934. 2020-04-21 23:01:06 ERROR:Table `db_scripts [type = 2]` has datalong = 496 in SCRIPT_COMMAND_SEND_TAXI_PATH for script id 737903, but this taxi path can be triggered by spell 29994. 2020-04-21 23:01:06 ERROR:Table `db_scripts [type = 2]` has datalong = 316 in SCRIPT_COMMAND_SEND_TAXI_PATH for script id 4042, but this taxi path can be triggered by spell 28001. Maybe this startup errors could be connected with the issue?

All right. The problem with NPC Riggle Bassbait seems to be easier than i thought. Solution is in changing start_date time in mysql/mariadb table: For me it was like: MariaDB [zero_world]> UPDATE game_event SET start_time='2006-01-01 23:00:00' WHERE entry=34; That brings my table to this state: MariaDB [zero_world]> SELECT * FROM game_event WHERE entry IN (14,15,34); +-------+---------------------+---------------------+-----------+--------+---------+-------------------------------+ | entry | start_time | end_time | occurence | length | holiday | description | +-------+---------------------+---------------------+-----------+--------+---------+-------------------------------+ | 14 | 2006-01-02 16:00:00 | 2021-01-01 09:59:59 | 10080 | 240 | 0 | Fishing Extravaganza Announce | | 15 | 2006-01-01 22:00:00 | 2021-01-01 09:59:59 | 10080 | 120 | 301 | Fishing Extravaganza | | 34 | 2006-01-01 23:00:00 | 2020-12-31 10:00:00 | 10080 | 180 | 0 | Fishing Extravaganza Turn-in | +-------+---------------------+---------------------+-----------+--------+---------+-------------------------------+ 3 rows in set (0.00 sec) Then I set server vm time to the 2020-04-19 Sunday 23:15 and all three NPC were there: So, there should be done changes to start_event timings. But there are some questions about it: 1) I looked through my db table values (that I patched from Rel21_14_xx all the way up to Rel21_16_35) and db table values from fresh install .sql They have different values in column start_time (but anyway broken ones): game_event.sql from github mangoszero (https://github.com/mangoszero/database/blob/master/World/Setup/FullDB/game_event.sql😞 (14,'2006-01-02 05:00:00','2020-12-31 22:59:59',10080,240,0,'Fishing Extravaganza Announce'), (15,'2006-01-01 11:00:00','2020-12-31 22:59:59',10080,120,301,'Fishing Extravaganza'), (34,'2006-01-04 14:00:00','2020-12-30 23:00:00',10080,180,0,'Fishing Extravaganza Turn-in'), So It would be better to organize changes (start_time) to all 3 events connected with Extravaganza. 2) How to set the event timers itself is a question. Cause I didn't have any classic experience during "live". What is said about the timers: wowhead (classic) notes: https://classicdb.ch/?npc=15116#comments (Extravaganza Announce): Is it a proper way to organize Extravaganza for Europe (and other) regions just the same time as 2-4pm PDT simply converting one to UTC? For UTC it then should be like 21:00:00 starting time. Or It should be started at 14:00:00? (I don't have rights to decide such things but pref second variant). another remark from wowhead: Seems like Riggle should spawn the same time with other 2 NPC's. And then table should look like: MariaDB [zero_world]> SELECT * FROM game_event WHERE entry IN (14,15,34); +-------+---------------------+---------------------+-----------+--------+---------+-------------------------------+ | entry | start_time | end_time | occurence | length | holiday | description | +-------+---------------------+---------------------+-----------+--------+---------+-------------------------------+ | 14 | 2005-12-31 14:00:00 | 2021-01-01 09:59:59 | 10080 | 240 | 0 | Fishing Extravaganza Announce | | 15 | 2006-01-01 14:00:00 | 2021-01-01 09:59:59 | 10080 | 180 | 301 | Fishing Extravaganza | | 34 | 2006-01-01 14:00:00 | 2020-12-31 10:00:00 | 10080 | 180 | 0 | Fishing Extravaganza Turn-in | +-------+---------------------+---------------------+-----------+--------+---------+-------------------------------+ 3 rows in set (0.00 sec) 2 NPC that related with turn-in quests and Main rewars Riggle NPC spawning the same time at 14:00:00 each Sunday. Length also changed to suit 3 hours as it supposed to be. About announcment. Idk how much time Announce NPC (2 actually, for Orgrimmar and Ironforge) should be standing in capitals, but suppose 240 min is pretty enough for the beginning (I don't even know if it is working at all for now. Needed to be tested). This event should be held the day before (Saturday). Than there are another issue. Schools of tastyfish (gameobject id=180248 entries) spawn time should be reduced from 180 mins to 120 mins to suit 2-4pm gap (yes, fishing for 2 hours, NPC stays for 3 hours as it stated to be in vanilla): MariaDB [zero_world]> update gameobject set spawntimesecs=120 where id=180248; Thats what I've learn about Riggle and event timers. Still there is a problem with reward for Apprentice Angler figh turn-in quest (no money given as a reward).

Riggle spawned after causing it manually: 1. .event start 34 2. .go -14439.3 475.42 15.892 0 But I could'nt find him during event as-it-is on prod server. I suppose ithe answer is buried somewhere in timing. My prod server sql query output for related events: MariaDB [zero_world]> SELECT * FROM game_event WHERE entry IN (14,15,34); +-------+---------------------+---------------------+-----------+--------+---------+-------------------------------+ | entry | start_time | end_time | occurence | length | holiday | description | +-------+---------------------+---------------------+-----------+--------+---------+-------------------------------+ | 14 | 2006-01-02 16:00:00 | 2021-01-01 09:59:59 | 10080 | 240 | 0 | Fishing Extravaganza Announce | | 15 | 2006-01-01 22:00:00 | 2021-01-01 09:59:59 | 10080 | 120 | 301 | Fishing Extravaganza | | 34 | 2006-01-05 01:00:00 | 2020-12-31 10:00:00 | 10080 | 180 | 0 | Fishing Extravaganza Turn-in | +-------+---------------------+---------------------+-----------+--------+---------+-------------------------------+ 3 rows in set (0.00 sec) Could it be holiday field absence? Cause only 1 event has not default value (and the event works). Also couldn't find the meaning of 301 in wiki-database.

Maybe there are too many nodes at Kalimdor, but i wanted to submit something quite opposite. Through game experience i can say that there are too low nodes in Eastern Kingdoms. Played quite long, running through this locations. ALL nodes that i found there you may see at screens. (So, pictures from Kalimdor just for comparison). Really doesnt seems work well. + Most of the Kalimdor nodes spawns regularry at the same places (~5-10 mins maybe). And what can i see in Hilsbrad (for example): ~4-6 nodes on tha map, one of them was discovered near Taren Mill at the third day only (means third day running nearby while questing etc.). I wish i could discribe it more carefully, but my english not quite well.