Skip to content

Instantly share code, notes, and snippets.

@CraftedRO
CraftedRO / gameobjects.sql
Last active September 21, 2022 17:59
updates for gameobjects.sql converted from wow.tools 3.4.0 (45613) Pre-Patch WotLK Classic for 3.3.5 trinitycore database
/* Rows affected: 1,932 Records found: 0 Warnings: 0 Taking 2,208 queries: 18.403 sec. */
UPDATE gameobject SET position_x = -9979.134,position_y = 1007.3246,position_z = 32.758778,rotation0 = 0.100685,rotation1 = -0.025143987,rotation2 = 0.052290972,rotation3 = 0.99322504 WHERE id= 80;
UPDATE gameobject SET position_x = -9978.25,position_y = 1006.5087,position_z = 31.759172,rotation0 = 0.009525008,rotation1 = 0.056056038,rotation2 = 0.99837375,rotation3 = -0.0041099144 WHERE id= 81;
UPDATE gameobject SET position_x = -9978.594,position_y = 1007.7535,position_z = 32.285603,rotation0 = 0.08098299,rotation1 = -0.024925988,rotation2 = -0.65145093,rotation3 = 0.75394434 WHERE id= 82;
UPDATE gameobject SET position_x = -9977.337,position_y = 1009.8611,position_z = 31.468832,rotation0 = 0.21970919,rotation1 = -0.6859214,rotation2 = 0.1600136,rotation3 = 0.6750077 WHERE id= 83;
UPDATE gameobject SET position_x = -10912.045,position_y = 1420.3473,position_z = 42.525867,rotation0 = -0.056855977,rotation1 = 0.000639006
@CraftedRO
CraftedRO / 130.sql
Last active November 5, 2022 13:28
-- Delete 130 Wrong SAI
DELETE FROM `smart_scripts` WHERE `action_param1` IN (3391, 3417, 8876, 12787, 54913) AND `source_type` = 0;
-- 1843
DELETE FROM `creature_template_addon` WHERE `entry` = 1843;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
(1843, 0, 0, 0, 0, 0, 0, 0, '12787');
-- 1847
UPDATE `creature_template_addon` SET `auras` = '12787' WHERE `entry` = 1847;
22:58:28.405: CPU Name: Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz
22:58:28.405: CPU Speed: 3408MHz
22:58:28.405: Physical Cores: 4, Logical Cores: 8
22:58:28.405: Physical Memory: 16327MB Total, 10161MB Free
22:58:28.405: Windows Version: 10.0 Build 19045 (release: 2009; revision: 2251; 64-bit)
22:58:28.405: Running as administrator: false
22:58:28.405: Aero is Enabled (Aero is always on for windows 8 and above)
22:58:28.405: Windows 10/11 Gaming Features:
22:58:28.405: Game DVR: On
22:58:28.405: Game Mode: Probably On (no reg key set)
Unhandled exception: c0000005
Date/Time: 2022-11-09, 22:54:16
Fault address: 7FF99EF66252 (d:\obs studio 28.1.2\bin\64bit\obs.dll)
libobs version: 28.1.2 (64-bit)
Windows version: 10.0 build 19045 (release: 2009; revision: 2251; 64-bit)
CPU: Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz
Thread 2D70: CrBrowserMain (Crashed)
Stack EIP Arg0 Arg1 Arg2 Arg3 Address
@CraftedRO
CraftedRO / Crash 2023-03-12 15-57-34.txt
Created March 12, 2023 14:01
Crash 2023-03-12 15-57-34
Unhandled exception: c0000005
Date/Time: 2023-03-12, 15:57:33
Fault address: 7FFD484A6692 (d:\obs studio 29.0.2\bin\64bit\obs.dll)
libobs version: 29.0.2 (64-bit)
Windows version: 10.0 build 19045 (release: 22H2; revision: 2673; 64-bit)
CPU: Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz
Thread 3044: CrBrowserMain (Crashed)
Stack EIP Arg0 Arg1 Arg2 Arg3 Address
@CraftedRO
CraftedRO / gist:4b1f4419de8f72f639f6c9147d480489
Created March 14, 2023 14:16
obs log 2023-03-12 15-57-34
15:57:22.219: CPU Name: Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz
15:57:22.219: CPU Speed: 3408MHz
15:57:22.219: Physical Cores: 4, Logical Cores: 8
15:57:22.219: Physical Memory: 16327MB Total, 12169MB Free
15:57:22.219: Windows Version: 10.0 Build 19045 (release: 22H2; revision: 2673; 64-bit)
15:57:22.219: Running as administrator: false
15:57:22.219: Windows 10/11 Gaming Features:
15:57:22.219: Game DVR: On
15:57:22.219: Game Mode: Probably On (no reg key set)
15:57:22.220: Sec. Software Status:
ID - 46935 Ice Fishing
=================================================
Category = 0, SpellIconID = 1, activeIconID = 0, SpellVisual = (759,0), SpellPriority = 0
Family SPELLFAMILY_GENERIC, flag [0] 0x00000000 [1] 0x00000000 [2] 0x00000000
SpellSchoolMask = 1 (SPELL_SCHOOL_MASK_NORMAL)
DamageClass = 0 (SPELL_DAMAGE_CLASS_NONE)
PreventionType = 0 (SPELL_PREVENTION_TYPE_NONE)
=================================================
Attributes: 0x00040110 (SPELL_ATTR0_ABILITY, SPELL_ATTR0_HIDE_IN_COMBAT_LOG, SPELL_ATTR0_DONT_AFFECT_SHEATH_STATE)

XAMPP - Replace MariaDB with MySQL

Since XAMPP 5.5.30 and 5.6.14, XAMPP ships MariaDB instead of MySQL. MariaDB is not 100% compatible with MySQL and can be replaced with the "orginal" MySQL server.

Backup

  • Backup the old database into a sql dump file
  • Stop the MariaDB service
  • Rename the folder: c:\xampp\mysql to c:\xampp\mariadb
Unhandled exception: c0000005
Date/Time: 2023-06-23, 02:48:19
Fault address: 7FFF0D98B8D2 (d:\obs studio 29.1.3\bin\64bit\obs.dll)
libobs version: 29.1.3 (64-bit)
Windows version: 10.0 build 19045 (release: 22H2; revision: 3086; 64-bit)
CPU: Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz
Thread 2168: CrBrowserMain (Crashed)
Stack EIP Arg0 Arg1 Arg2 Arg3 Address
02:47:55.150: CPU Name: Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz
02:47:55.150: CPU Speed: 3408MHz
02:47:55.150: Physical Cores: 4, Logical Cores: 8
02:47:55.150: Physical Memory: 16327MB Total, 12577MB Free
02:47:55.150: Windows Version: 10.0 Build 19045 (release: 22H2; revision: 3086; 64-bit)
02:47:55.150: Running as administrator: false
02:47:55.150: Windows 10/11 Gaming Features:
02:47:55.150: Game DVR: On
02:47:55.150: Game Mode: Probably On (no reg key set)
02:47:55.153: Sec. Software Status: