Skip to content

Instantly share code, notes, and snippets.

View nosmall's full-sized avatar

Jirka aka NOsmall or NoSmallCZ nosmall

View GitHub Profile
@nosmall
nosmall / gist:6669147
Created September 23, 2013 11:15
Merge more files to ONE FILE
cat /TRINITY_CORE/sql/updates/world/*.sql >> all_world.sql
@nosmall
nosmall / README - TrinityCore restarter
Last active June 22, 2020 09:45
(simple) TrinityCore (linux (Debian)) restarter (using a bashscript) for posterus.cz
# (simple) TrinityCore (linux (Debian)) restarter (using a bashscript) for posterus.cz
# required applications
# sudo apt-get update && sudo apt-get install screen mutt gdb
# INFO
# ./_restarter > Starts the world server with restarter
# ./_auth_starter > Starts the auth server without restarter
# ./_world_starter > Starts the world server without restarter
@nosmall
nosmall / do
Last active June 15, 2016 16:11
TrinityCore Auto Compiler / Ubuntu / 6.x
#!/bin/bash
## CONF ##
ADMINEMAIL="docompile@domain.tld"
CPUJOBS=8
DIRPATH=$(cd `dirname "${BASH_SOURCE[0]}"` && pwd -P)
##DIRPATH="/home/wow/server"
if [ "$1" = "clone" ]; then
cd $DIRPATH && rm -rf TrinityCore
@nosmall
nosmall / crashreporter.sh
Created May 31, 2016 07:33
Team Speak 3 Crash Reporter & Restarter / TS3 Restarter & Crash Reporter / Ubuntu 14.04
#!/bin/bash
SCREENNAME="ts3srv"
MAILREPORT=0
ADMINEMAIL="admin@domain.tld"
# SCRIPT
DIRPATH=$(cd `dirname "${BASH_SOURCE[0]}"` && pwd -P)
TEAMSPEAK=`ps ax | grep ts3server | grep -v grep | wc -l`
if [ "$TEAMSPEAK" -eq 0 ]
###################################################################################################
# AUCTION HOUSE BOT SETTINGS
#
# AuctionHouseBot.Update.Interval
# Description: Interval in seconds for AHBot to get updated
# Default: 20
#
AuctionHouseBot.Update.Interval = 20
@nosmall
nosmall / make_mmaps.sh
Last active June 16, 2016 07:27
TrinityCore - Extractor - MMAPS - Linux (Ubuntu)
#! /bin/bash
mkdir -p mmaps
screen -L -A -m -d -S tmp_mmaps_generator ./mmaps_generator
echo "Check Progress: screen -x tmp_mmaps_generator"
echo ""
@nosmall
nosmall / make_dbc_maps_vmaps.bat
Last active July 9, 2018 00:14
TrinityCore - Extractor - DBC, MAPS, VMAPS - Windows (batch)
mapextractor.exe
vmap4extractor.exe
md vmaps
vmap4assembler.exe Buildings vmaps
pause
@nosmall
nosmall / return_first_free_id.sql
Created November 1, 2016 15:38
SQL get first free ID
(SELECT MIN(t1.UID + 1) AS id FROM task_read t1 LEFT JOIN task_read t2 ON t1.UID + 1 = t2.UID WHERE t2.UID IS NULL)
@nosmall
nosmall / ren utilman.exe to utilman.old copy cmd.exe to utilman.exe
Last active January 30, 2024 02:07
ren utilman.exe to utilman.old copy cmd.exe to utilman.exe
Toto nastavení GPO zablokuje spouštění Utilman z login screenu v rámci celé domény :)
----------------------------------------------------------------------------------
Computer Configuration > Policies > Windows Settings > Security Settings > File System
>>>> Add File > Type in the following;
Navigate to C:\Windows\System32
Find UTILMAN.EXE
Right Click, then Properties
Security, Advanced, Permissions (Continue)
Change the owner at the top from "TrustedInstaller" to "Administrators" (ensure you have and Administrator account)
Add a permission, and then click Select a "Principal"
@nosmall
nosmall / LAMP-on-Ubuntu-16.04.md
Last active June 21, 2018 11:54
Install Linux, Apache, MySQL, PHP (LAMP) on Ubuntu 16.04

LAMP on Ubuntu 16.04 (lazy guide)

PHP-FPM 5.6 & 7.1, Apache2.4, MySQL, Sendmail

# You must be root
sudo su
apt update \
&& apt install -y software-properties-common \