I'll like used a small code to make request in the mysql Database automatically, the problem it is by making an echo on a nick !
[code]
#Chan -> look pretime
set chanpretime "#PRES"
#Chan -> addpre & nuke
set chanadd "#TIME"
#Chan ->your checkpre
set chanpre "#your checkpre"
#Host de la db
set host {localhost}
#User de la db
set user {root}
#Pass de la db
set password {}
#Database name
set db {'PRE}
#Nickserv : 1=ON
set nson 1
#pass nickserv
set nspass "pass_bot"
#Nick bot
set nsbot "nick_bot"
##############################
# MySQL Connec #
###############################
load libmysqltcl.dll
package require mysqltcl
if [catch {mysqlconnect -host $host -user $user -password $password -db $db} mysql_handler] {
putquick "PRIVMSG $chanadd :ERROR..."
}
###############################
# !addpre By Nick Echo (Automatik)
###############################
bind pub - !addpre pub:addpre
proc pub:addpre {nick uhost handle channel arg } {
global Hdecalage chanadd chanpre mysql_handler
set arg [lindex [split $arg] 0]
if {![rlzexist $arg] && [string tolower $channel]=="$chanadd"} {
set passedsec [expr [unixtime]-[expr $Hdecalage*3600]]
set curdate [strftime %Y-%m-%d $passedsec]
set curtime [strftime %H:%M:%S $passedsec]
set sql "INSERT INTO releases(name,date,time,unixtime,nuke) VALUES('$arg','$curdate','$curtime','$passedsec','')"
mysqlquery $mysql_handler $sql
-------------------------------------
Example:
echo_chan -> #PRES
Echo_nick > PRED
PRED : «BoX» PRE : Aquamarine 2006 iTALiAN MD CAM XviD-BoX «»AUTRE-IT«»
Thank
