Search results

Master Change Log See below for the Master Change Log. This post will be updated each update. Note: I have updated how I display the changes so it is all grouped. If you are interested here is my count of how many fixes have been done: NPC'S: 116 Quests: 45 Objects: 30 Items...

SQL Queries The queries has gotten to be a little TOO long to be put in a single post. I have attached them in a text file. Current lines of SQL: 885 Lines added since last update: 41 Last Update: 1st December 2022

Hi Everyone, I have been playing V16 and have made some fixes for the World Database. The next two posts on this thread will be the SQL queries and then the change log. Post 1: These queries can run as many times as you like and you shouldn't get any problems. Post 2: Will be a the master...

No where. They rarely let me leave work. Am sure if they could legally do it they would chain me up over night there. Not dead. Read the PSA below As long as you don't become a stalker we should be fine. PSA: I am an essential worker and a single parent. I get very little time to myself...

Thank you... I only tend to post more when I have about 50 lines of sql to add, so don't really expect a lot of changes (as work does get in the way of this fun)

You're welcome.

As soon as you press run, the changes are made. You do not need to save the query at all.

Thanks @Jenniy it's always nice to be appreciated. To start with you need an sql editor program like Navicat or HeidiSQL. I personally use Navicat. Once you have the program downloaded and installed: - Turn on the MySQL server for the repack - Open the program - Make a new connection using...

You're quite welcome Guess who's back. Back again. Dolgan's Back! Thank you friend. (Too be fair never actually left, but I am an essential worker during these pandemic times, so just been busy IRL)

Master Change Log See below for the Master Change Log. This post will be updated each update. Removed duplicated Auras x 8 Removed GM commands that don't exist x 2 Quest: Kyle's Gone Missing! (ID: 11129) Moved Kyle the Friendly's (ID: 23622) thank message to correct npc Removed non...

SQL Queries The following listed queries can be run as many times as you like. UPDATE `creature_template_addon` SET `auras`='' WHERE (`entry`='36578'); UPDATE `creature_template_addon` SET `auras`='' WHERE (`entry`='36681'); UPDATE `creature_template_addon` SET `auras`='' WHERE...

Hi Everyone, With the release of Version 13.1 for VIP members, I have continued to make database fixes and am sharing them all with you. The next two posts on this thread will be the SQL queries and then the change log. Post 1: These queries can run as many times as you like and you...

Which Draenei zone? and VIP is on Version 13 at the moment, so a monumental amount of differences in stability, I would say it is worth it.

Personally I would like it if the bots mounted when a Druid went into flight form.

Which version? can we get an NPC id? - Worked fine for me. Are you using .die command to kill them, because using that command won't count for quests. (if you are use ".damage 1000000" instead) Could not recreate these issues, worked fine for me. using the item worked fine on the injured...

Sure, working on it now. Most of them ARE there though. Updates will be a bit slower now. My holidays are over and I am back at work.

What would you do without me? :innocent: For Northrend Rares (The one's not listed here already work) DELETE FROM pool_template WHERE entry BETWEEN 1086 AND 1106; INSERT INTO pool_template (entry,max_limit,description) VALUES (1086,1, 'Old Crystalbark Rare Spawn (1 out 4)'), (1087,1, 'Fumblub...

Run this query for outland spawns DELETE FROM pool_template WHERE entry BETWEEN 1073 AND 1085; INSERT INTO pool_template (entry,max_limit,description) VALUES (1073,1, 'Okrek Rare Spawn (1 out 4)'), (1074,1, 'Ambassador Jerrikar Rare Spawn (1 out 5)'), (1075,1, 'Okrek Rare Spawn (1 out 3)')...

Select yourself and go .npcbot reset It will stop them fighting.

Hey got bored so thought I would throw out some sql queries to add to the teleports. These have been tested with the latest VIP release (Version 12) of 4.3.4 Game client from: 4.3.4 Download - FULL CLIENT - Torrent - Cataclysm Download (No Background downloader First up: An area that has...