Skip to content

Instantly share code, notes, and snippets.

View CraftedRO's full-sized avatar

CraftedRO

19 followers · 2 following
View GitHub Profile
@CraftedRO
CraftedRO / hosts
Created October 31, 2023 21:51
Original hosts file for Windows located at c:\Windows\System32\Drivers\etc\hosts.
# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
@CraftedRO
CraftedRO / gist:5318948c8826b987c7be53ec1c580653
Created June 23, 2023 16:34
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:
@CraftedRO
CraftedRO / gist:fe0a5be204274c132f4f66cf5d86b786
Created June 23, 2023 16:32
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
@CraftedRO
CraftedRO / xmapp-replace-mariadb-with-mysql.md
Last active July 24, 2025 13:55 — forked from 111000101/xmapp-replace-mariadb-with-mysql.md
XAMPP - Replace MariaDB with MySQL

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
@CraftedRO
CraftedRO / gist:7a3693a634fccb95b5f000c8e5d9356f
Created May 12, 2023 22:05
46935
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)
@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:
@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 / obs crashlog
Created November 9, 2022 21:01
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 / OBS LOG
Created November 9, 2022 21:00
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)
@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;