https://old.andunix.net/ 2026-06-04T07:20:15+00:00 https://old.andunix.net/ https://old.andunix.net/_media/favicon.ico text/html 2015-10-23T12:39:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/script/variables Shell Script Variables Last Character Get the last character of $a: ${a: -1} Remove Slash from the End of a Variable Remove a trailing slash from $a: a=${a%/} scripting bash sysadmin variable text/html 2013-03-15T09:42:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/blog/2009/travian_village_planner Travian Village Planner Currently I'm working on a village planner for Travian. It was inspired by the village planner at <http://www.ebav.co.uk/travian/>, but I was missing a possibility to save and reference my village. So the main feature was saving the village to a bookmark. This is done by the text/html 2020-09-15T19:10:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/wiki/syntax Formatting Syntax DokuWiki supports some simple markup language, which tries to make the datafiles to be as readable as possible. This page contains all possible syntax you may use when editing the pages. Simply have a look at the source of this page by pressing text/html 2016-01-25T11:49:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/mysql/user/create MySQL: Create User Create User CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; Create User and Database * Usually, {user} == {db} CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; GRANT USAGE ON * . * TO '{user}'@'%' IDENTIFIED BY '{passwd}' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; text/html 2014-02-02T11:19:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/p/dmx/protocol Serial Protocol For the communication between the host (PC) and the controller (Arduino), there is a serial protocol over USB. The protocol is line by line, with carriage return (“\n”) as end. The first character denotes the type of command or information. The following commands have been defined: text/html 2014-03-07T13:51:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/info/webdesign/urlencode URL Encoding Character URL-Code & %26 ? %3F web webdesign html http encoding reference text/html 2013-02-04T22:18:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://old.andunix.net/z/travian/travian_map_download_script Travian Map Download Script This is my script(s) which I use to downoad the map.sql from Travian and import it to the database. config.inc # # database DB_USER="travian" # set this to your database user DB_PASS="travian" # set this to your database password DB_INST="travian" # set this to your database instance # # directories MAP_DIR=${HOME}/opt/travian DUMP_DIR=/srv/glassfish/domains/domain1/docroot/sql # # executables MYSQL="/srv/mysql/bin/mysql --default-character-set=utf8 -u${DB_USER} -…