06/11/2010, 05:32
regarde ma te montrer ma config complete
load libmysqltcl.dll
package require mysqltcl
set pdb(hostname) "localhost"
set pdb(username) "username"
set pdb(password) "password"
set pdb(database) "site"
set pdb(table) "pre"
bind pub - !addpre pr:addpre
bind pub - !pre pr:pre
# Adding
proc pr:addpre { nick uhost handle channel arg1 arg2 } {
global pdb
set table "$pdb(table)"
set sqlhand [mysqlconnect -host $pdb(hostname) -user $pdb(username) -password $pdb(password)]
mysqluse $sqlhand $pdb(database)
mysqlexec $sqlhand "INSERT INTO
mysqlclose $sqlhand
putserv "PRIVMSG $channel rayer request has been added"
putcmdlog "<<$nick>> !$handle! Added a prayer request in $channel."
}
je voudraix que sa marche comme sa
load libmysqltcl.dll
package require mysqltcl
set pdb(hostname) "localhost"
set pdb(username) "username"
set pdb(password) "password"
set pdb(database) "site"
set pdb(table) "pre"
bind pub - !addpre pr:addpre
bind pub - !pre pr:pre
# Adding
proc pr:addpre { nick uhost handle channel arg1 arg2 } {
global pdb
set table "$pdb(table)"
set sqlhand [mysqlconnect -host $pdb(hostname) -user $pdb(username) -password $pdb(password)]
mysqluse $sqlhand $pdb(database)
mysqlexec $sqlhand "INSERT INTO
$table
( id
, section
, rls
, date
) VALUES ('', '$arg1', '$arg2', NOW( ))"mysqlclose $sqlhand
putserv "PRIVMSG $channel rayer request has been added"
putcmdlog "<<$nick>> !$handle! Added a prayer request in $channel."
}
je voudraix que sa marche comme sa