Skip to content

Instantly share code, notes, and snippets.

View CraftedRO's full-sized avatar

CraftedRO

16 followers · 3 following
View GitHub Profile
@CraftedRO
CraftedRO / secure_with_htaccess
Created March 20, 2025 22:08 — forked from hugopereira84/secure_with_htaccess
Security with cookies: - PREVENTING SESSION HIJACKING - PREVENTING SESSION FIXATION - Uses a secure connection (HTTPS) if possible
With .htaccess just need to add these flags:
php_value session.cookie_httponly 1
php_value session.cookie_secure 1
@CraftedRO
CraftedRO / Sarathstra.sql
Created March 15, 2025 19:05
Sarathstra, Scourge of the North @crafted V1 EDITION
-- Sarathstra, Scourge of the North @CRAFTED V1 EDITION
SET @ROKHAN=26859;
SET @SARATHSTRA=26858;
SET @GOSSIP=9434;
-- Creature Text
DELETE FROM `creature_text` WHERE `CreatureID`=@ROKHAN;
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(@ROKHAN, 0, 0, "Don't ya worry, mon. Just leave it to Rokhan. She be comin'.", 12, 0, 100, 1, 0, 0, 26047, 0, 'Rokhan to Player');
@CraftedRO
CraftedRO / gist:c1f50c11fee0b25281c9eb264ed11213
Last active March 14, 2025 11:59 — forked from Aokromes/gist:1a3a60bea163e2120dd56bac40556ff0
POSSIBLE BUGGED QUEST ID TRINITYCORE
ID
618
1701
1846
5063
5067
5068
5143
5146
5892
@CraftedRO
CraftedRO / gist:244be7257d22957b82825a8c1d068aac
Created February 23, 2025 19:03
Want to find the oldest ever YouTube videos?
A Reminder that this feature can find the Oldest YouTube videos ever.
Discussion
Want to find the oldest ever YouTube videos?
Type "whatever you're looking for before:year(or date)" in the search field and have fun.
Examples:
Oldest videos about birds "birds before:2005"
@CraftedRO
CraftedRO / Win_Server_2025_Evaluation_to_full_version.md
Last active November 4, 2024 11:37 — forked from nosmall/Win_Server_2022_Evaluation_to_full_version.md
Upgrade Windows Server 2025 Evaluation (Eval) to Full Version Standard or Datacenter
@CraftedRO
CraftedRO / Github Webhook Tutorial.md
Created October 26, 2024 19:19 — forked from jagrosh/Github Webhook Tutorial.md
Simple Github -> Discord webhook

Step 1 - Make a Discord Webhook

  1. Find the Discord channel in which you would like to send commits and other updates

  2. In the settings for that channel, find the Webhooks option and create a new webhook. Note: Do NOT give this URL out to the public. Anyone or service can post messages to this channel, without even needing to be in the server. Keep it safe! WebhookDiscord

Step 2 - Set up the webhook on Github

  1. Navigate to your repository on Github, and open the Settings Settings
@CraftedRO
CraftedRO / opcache_install.md
Created October 15, 2024 00:57 — forked from WillSquire/opcache_install.md
OpCache install & configuration

OpCache

Installation

Install OpCache on FreeBSD with (note 56 resembles the current PHP version 5.6):

cd /usr/ports/www/php56-opcache && sudo make config-recursive install distclean

Configuration

@CraftedRO
CraftedRO / opcache.ini
Created October 13, 2024 22:20 — forked from rohankhudedev/opcache.ini
Best Zend OpCache Settings / Tuning / Configurations
[opcache]
; Determines if Zend OPCache is enabled
opcache.enable=1
; Determines if Zend OPCache is enabled for the CLI version of PHP
;opcache.enable_cli=1
; The OPcache shared memory storage size.
opcache.memory_consumption=512
@CraftedRO
CraftedRO / rarreg.key
Created June 5, 2024 13:27 — forked from MuhammadSaim/rarreg.key
Step 1: Create a file called rarreg.key Step 2: Paste into the file the raw content of this gist Step 3: Go to Winrar install directory (by default => c:\ProgramFiles\WinRAR\ ) Step 4: Paste the rarreg.key into WinRAR directory Step 5: Enjoy
RAR registration data
WinRAR
Unlimited Company License
UID=4b914fb772c8376bf571
6412212250f5711ad072cf351cfa39e2851192daf8a362681bbb1d
cd48da1d14d995f0bbf960fce6cb5ffde62890079861be57638717
7131ced835ed65cc743d9777f2ea71a8e32c7e593cf66794343565
b41bcf56929486b8bcdac33d50ecf773996052598f1f556defffbd
982fbe71e93df6b6346c37a3890f3c7edc65d7f5455470d13d1190
6e6fb824bcf25f155547b5fc41901ad58c0992f570be1cf5608ba9
@CraftedRO
CraftedRO / multiple_ip_to_fw_rule.bat
Created June 3, 2024 23:33 — forked from ehindiayleau/multiple_ip_to_fw_rule.bat
Inject Multiple IP Addresses Into A Single Windows Firewall Rule With A Batch and Text File
@echo off
if "%1"=="list" (
netsh advfirewall firewall show rule multiple_ip_to_fw_rule | findstr RemoteIP
exit/b
)
netsh advfirewall firewall delete rule name="multiple_ip_to_fw_rule"
for /f %%i in (C:\PATH_TO_TEXT_FILE_WITH_IP_ADDRESSES\multiple_ip_to_fw_rule.txt) do (
netsh advfirewall firewall add rule name="multiple_ip_to_fw_rule" protocol=any dir=in action=block remoteip=%%i