using macro to connect to DB

[m1334]

Is it possible to use macro to send data to my DB? I have a macro I created that logs guild breaks but I don't know how to send the data to my DB. I can't even create a simple command to show the result on the bot using subroutine. Can anyone give me some hints or guidance?

Code: Select all

automacro Garden {
	console /\[GM\] s+\[(.+)\] guild occupied the \[(Garden of Heaven)\] Agit./
	call {
		$Garden = $.lastMatch1
                write($Garden)
	}
}

sub write {
    print ""   //no idea how to do this
    echo ""  //no idea how to do this
}

[EternalHarvest]

"print" always prints to STDOUT in kore, you may try message() or Log::message() instead.

Database access, as you're already using Perl subs and not just macros: http://search.cpan.org/perldoc?DBI#SYNOPSIS

[m1334]

Thanks message() work perfectly. I'm having a bit of a problem connecting to the DB though, probably because I don't know where should I put "use DBI;"?

Right now I'm just printing my output to a text file that looks like this

Code: Select all

~~~~~~~~~~~~~~~~~~~~~~~~
Sun Feb 12 21:00:06 2012
~~~~~~~~~~~~~~~~~~~~~~~~


##########
###Juno###
##########

Heemin = Guild
Andlerangh = Guild
Bidblind = Guild
Hueluid = Guild
Schatirnil = Guild 


############
###Rachel###
############

Mardol = Guild
Scheit = Guild
Horn = Guild
Gepun = Guild
Banadis = 

[AnotherBotterOnFro]

I used eval to execute a script. Goes like

Code: Select all

do eval system ("./database.sh $param1 $param2");

Ofc i get the params from other macros. I use this to debug loads of them. Though I can t use Linux (see my post on the fro-forum :-/) anymore, this works in Windows as well.

Script goes like

Code: Select all

#!/bin/bash
mysql -h localhost -u $dbusername -p$dbpassword -D $dbname -e "insert into $dbtable values ('$1','$2');"
exit 0

[einrel]

any update on this one? this was useful though