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 / 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 / do

Last active June 15, 2016 16:11

TrinityCore Auto Compiler / Ubuntu / 6.x

	#!/bin/bash

	## CONF ##
	ADMINEMAIL="[email protected]"
	CPUJOBS=8
	DIRPATH=$(cd `dirname "${BASH_SOURCE[0]}"` && pwd -P)
	##DIRPATH="/home/wow/server"

	if [ "$1" = "clone" ]; then
	cd $DIRPATH && rm -rf TrinityCore

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="[email protected]"

	# SCRIPT
	DIRPATH=$(cd `dirname "${BASH_SOURCE[0]}"` && pwd -P)
	TEAMSPEAK=`ps ax \| grep ts3server \| grep -v grep \| wc -l`

	if [ "$TEAMSPEAK" -eq 0 ]

nosmall / worldconfig.conf

Created June 14, 2016 08:32

	###################################################################################################
	# AUCTION HOUSE BOT SETTINGS
	#
	# AuctionHouseBot.Update.Interval
	# Description: Interval in seconds for AHBot to get updated
	# Default: 20
	#

	AuctionHouseBot.Update.Interval = 20

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 / 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 / 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 / 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 / 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 \

Jirka aka NOsmall or NoSmallCZ nosmall