This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.

For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.

Search found 3 matches

Go to advanced search

by inaba
Sun Jan 24, 2010 1:28 pm
Forum: Scripting Help
Topic: mysql tcl and variables woes
Replies: 4
Views: 8608

:D

Got it working as expected thank you very much ^-^

Code: Select all

set r [mysqlconnect -host $db(host) -user $db(user) -db $db(name) -password $db(pass)] 
 mysqluse $r $db(name) 
 foreach idr [mysqlsel $r "select id from users WHERE username = '$nick'" -list] { 
     puts $idr 
 } 
 mysqlclose $r
by inaba
Sun Jan 24, 2010 11:38 am
Forum: Scripting Help
Topic: mysql tcl and variables woes
Replies: 4
Views: 8608

okays, change the select query and still getting the same behaviour: set r [mysqlconnect -host $db(host) -user $db(user) -db $db(name) -password $db(pass)] mysqluse $r $db(name) foreach idr [mysqlsel $r {select id from users WHERE username = '$nick'} -flatlist] { puts $idr } mysqlclose $r Thanks for...
by inaba
Sat Jan 23, 2010 9:17 pm
Forum: Scripting Help
Topic: mysql tcl and variables woes
Replies: 4
Views: 8608

mysql tcl and variables woes

I'm trying to get a variable by using sql, and then go on to use said variable in the next sql query, but things dont go as planned :( this is my current proc: proc to_shoutbox {nick uhost hand chan text} { global db botid botnm idr set message [lrange $text 0 end] if { $message == "" } { ...

Go to advanced search