Skip to content

Instantly share code, notes, and snippets.

View Ovahlord's full-sized avatar

Ovahlord

83 followers · 3 following
  • Potatoland
  • 08:18 (UTC +01:00)
View GitHub Profile
@Ovahlord
Ovahlord / Convert openssl .key file to .pem
Created March 7, 2024 15:03 — forked from amolkhanorkar/Convert openssl .key file to .pem
Convert openssl .key file to .pem
For converting .key file to .pem file,
Your keys may already be in PEM format, but just named with .crt or .key.
If they begin with -----BEGIN and you can read them in a text editor (they use base64, which is readable in ASCII, not binary format), they are in PEM format.
If the file is in binary, for the server.crt, you would use
openssl x509 -inform DER -outform PEM -in server.crt -out server.crt.pem
For server.key, use openssl rsa in place of openssl x509.
@Ovahlord
Ovahlord / 2019-https-localhost.md
Created March 7, 2024 14:16 — forked from cecilemuller/2019-https-localhost.md
How to create an HTTPS certificate for localhost domains

How to create an HTTPS certificate for localhost domains

This focuses on generating the certificates for loading local virtual hosts hosted on your computer, for development only.

Do not use self-signed certificates in production ! For online certificates, use Let's Encrypt instead (tutorial).

@Ovahlord
Ovahlord / static_flags.sql
Created February 23, 2024 16:53
This file has been truncated, but you can view the full file.
UPDATE creature_template_difficulty SET `StaticFlags1`= 524288, `StaticFlags2`= 0, `StaticFlags3`= 0, `StaticFlags4`= 0, `StaticFlags5`= 16777216 WHERE `entry`= 3;
UPDATE creature_template_difficulty SET `StaticFlags1`= 524288, `StaticFlags2`= 0, `StaticFlags3`= 0, `StaticFlags4`= 0, `StaticFlags5`= 0 WHERE `entry`= 6;
UPDATE creature_template_difficulty SET `StaticFlags1`= 524390, `StaticFlags2`= 0, `StaticFlags3`= 0, `StaticFlags4`= 0, `StaticFlags5`= 0 WHERE `entry`= 19;
UPDATE creature_template_difficulty SET `StaticFlags1`= 4, `StaticFlags2`= 0, `StaticFlags3`= 0, `StaticFlags4`= 0, `StaticFlags5`= 0 WHERE `entry`= 29;
UPDATE creature_template_difficulty SET `StaticFlags1`= 16, `StaticFlags2`= 0, `StaticFlags3`= 0, `StaticFlags4`= 0, `StaticFlags5`= 0 WHERE `entry`= 30;
UPDATE creature_template_difficulty SET `StaticFlags1`= 0, `StaticFlags2`= 0, `StaticFlags3`= 0, `StaticFlags4`= 0, `StaticFlags5`= 0 WHERE `entry`= 31;
UPDATE creature_template_difficulty SET `StaticFlags1`= 0, `StaticFlags2`= 0, `Static
@Ovahlord
Ovahlord / nocombatunscripted.sql
Created July 29, 2020 18:54
-- Set CREATURE_FLAG_EXTRA_NO_COMBAT for all creatures with CREATURE_DIFFICULTYFLAGS_IGNORE_COMBAT that are NOT scripted.
UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x2000 WHERE `entry` IN (1182, 14122, 15546, 15904, 15910, 16400, 16897, 16898, 16899, 17059, 17060, 17176, 17211, 17231, 17293, 17469, 17529, 17611, 17687, 17847, 18308, 18370, 18409, 18458, 18491, 18504, 18564, 18581, 18793, 18891, 19159, 19211, 19212, 19297, 19376, 19387, 19388, 19437, 19439, 19464, 19483, 19484, 19597, 19677, 19727, 19845, 19922, 19939, 20003, 20023, 20024, 20084, 20093, 20133, 20148, 20155, 20156, 20229, 20286, 20288, 20289, 20391, 20392, 20431, 20605, 20608, 20709, 20736, 20804, 20858, 20978, 21030, 21041, 21092, 21094, 21095, 21096, 21157, 21160, 21203, 21290, 21322, 21414, 21436, 21437, 21438, 21439, 21440, 21447, 21664, 21682, 21683, 21684, 21726, 21747, 21748, 21750, 21752, 21756, 21761, 21791, 21792, 21793, 21794, 21855, 21856, 22054, 22114, 22228, 22232, 22233, 22235, 22240, 22246, 22269, 22277, 222
@Ovahlord
Ovahlord / gist:47695c854d14a26215de77e4c3a29e40
Created September 4, 2019 18:24 — forked from Shauren/gist:310fe3f1fcbadc74e102
Packets.h
class AccountObjectSetCheats
{
bool AutoBattle = false;
AccountobjectSetCheats Type;
int8 SlotLockCheat = 0;
};
class AccountObjectGetProfile
{
std::string Filename;
@Ovahlord
Ovahlord / convert.cpp
Created December 30, 2018 22:54 — forked from Shauren/convert.cpp
npc_trainer converter
namespace TrinityOld
{
struct TrainerRequirement
{
uint32 trainer_type;
uint32 trainer_spell;
uint32 trainer_class;
uint32 trainer_race;
};
@Ovahlord
Ovahlord / gist:c9a26aa5b4d1292effaa15383ad07e0b
Last active December 26, 2022 11:44
Spell and Loot batching
diff --git a/src/server/game/Entities/Player/ActionBatchObject.cpp b/src/server/game/Entities/Player/ActionBatchObject.cpp
new file mode 100644
index 0000000000..dfefef657a
--- /dev/null
+++ b/src/server/game/Entities/Player/ActionBatchObject.cpp
@@ -0,0 +1,126 @@
+/*
+* Copyright (C) 2008-2018 TrinityCore <https://www.trinitycore.org/>
+*
+* This program is free software; you can redistribute it and/or modify it
@Ovahlord
Ovahlord / gist:facaa0247c1e9d5fe593b55fb74de0bc
Created January 4, 2018 18:58 — forked from Kinzcool/gist:f2b42ad6f6ba6054cd53
World of Warcraft Cataclysm (4.3.4 - Build 15595) - Download Links.
http://ak.worldofwarcraft.com.edgesuite.net/wow-pod-retail/NA/15050.direct/Data/art.MPQ
http://ak.worldofwarcraft.com.edgesuite.net/wow-pod-retail/NA/15050.direct/Data/base-OSX.MPQ
http://ak.worldofwarcraft.com.edgesuite.net/wow-pod-retail/NA/15050.direct/Data/base-Win.MPQ
http://ak.worldofwarcraft.com.edgesuite.net/wow-pod-retail/NA/15050.direct/Data/expansion1.MPQ
http://ak.worldofwarcraft.com.edgesuite.net/wow-pod-retail/NA/15050.direct/Data/expansion2.MPQ
http://ak.worldofwarcraft.com.edgesuite.net/wow-pod-retail/NA/15050.direct/Data/expansion3.MPQ
http://ak.worldofwarcraft.com.edgesuite.net/wow-pod-retail/NA/15050.direct/Data/sound.MPQ
http://ak.worldofwarcraft.com.edgesuite.net/wow-pod-retail/NA/15050.direct/Data/world.MPQ
http://ak.worldofwarcraft.com.edgesuite.net/wow-pod-retail/NA/15050.direct/Data/world2.MPQ
http://ak.worldofwarcraft.com.edgesuite.net/wow-pod-retail/NA/15050.direct/Data/wow-update-base-15211.MPQ