Skip to content

Instantly share code, notes, and snippets.

I have just discovered a great feature of composer:
composer update --lock
It saves a lot of time when you merge branches with composer.lock file changes in both branches.
Just resolve conflict by applying --ours version of the file (or --theirs, it really doesn't matter) and then run
`composer update --lock `.
Composer will do all the dirty work for you and update composer.lock file according to composer.json changes
and install new packages. The rest of packages in composer are not changed.
@CraftedRO
CraftedRO / GoogleDorking.md
Created June 14, 2025 10:42 — forked from sundowndev/GoogleDorking.md
Google dork cheatsheet

Google dork cheatsheet

Search filters

Filter Description Example
allintext Searches for occurrences of all the keywords given. allintext:"keyword"
intext Searches for the occurrences of keywords all at once or one at a time. intext:"keyword"
inurl Searches for a URL matching one of the keywords. inurl:"keyword"
allinurl Searches for a URL matching all the keywords in the query. allinurl:"keyword"
intitle Searches for occurrences of keywords in title all or one. intitle:"keyword"
@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