egghelp/eggheads community Discussion of eggdrop bots, shell accounts and tcl scripts. 2010-08-31T18:10:06-04:00 https://forum.eggheads.org/app.php/feed/topic/17981 2010-08-31T18:10:06-04:00 2010-08-31T18:10:06-04:00 https://forum.eggheads.org/viewtopic.php?p=94175#p94175 <![CDATA[[SOLVED] Retrieving replies from mysql gives unexpected ...]]> Statistics: Posted by nml375 — Tue Aug 31, 2010 6:10 pm

]]> 2010-08-31T17:59:45-04:00 2010-08-31T17:59:45-04:00 https://forum.eggheads.org/viewtopic.php?p=94174#p94174 <![CDATA[[SOLVED] Retrieving replies from mysql gives unexpected ...]]>
PS, your signature isn't correct ;)

Statistics: Posted by DjSlash — Tue Aug 31, 2010 5:59 pm

]]> 2010-08-31T17:53:48-04:00 2010-08-31T17:53:48-04:00 https://forum.eggheads.org/viewtopic.php?p=94173#p94173 <![CDATA[[SOLVED] Retrieving replies from mysql gives unexpected ...]]> subst command if you'd like the escape-sequences to be substituted properly. Most likely, you'll want to use the -nocommands -novariables options to prevent unintended injections.

Statistics: Posted by nml375 — Tue Aug 31, 2010 5:53 pm

]]> 2010-08-31T18:00:37-04:00 2010-08-31T17:43:11-04:00 https://forum.eggheads.org/viewtopic.php?p=94172#p94172 <![CDATA[[SOLVED] Retrieving replies from mysql gives unexpected ...]]>
I'm playing with an idea I have for a while and I'm using the mysql module from BarkerJr for it. I have made a script that makes bindings according to the stuff in the database. Since it is just an experiment, I didn't put much tought to it. However, what's been bugging me for a couple of hours now is that I don't get the expected result from what I have right now.

This is the code:

Code: 

proc tb:respond { nick uhost hand chan arg binding} {        global talkbot        mysql_connect $talkbot(db_name) $talkbot(db_host) $talkbot(db_uname) $talkbot(db_pass)        set respond_query "SELECT reply FROM talkbot WHERE binding = '$binding' ORDER BY RAND() LIMIT 1"        set result [mysql_query $respond_query]        if {[mysql_affected_rows] < 1} {                putlog "TalkBot MySQL error: $result ([mysql_errno])"                return 0        } else {                set reply [lindex [lindex $result 0] 0]                putserv "privmsg $chan :$reply"        }}
This is what I have in the database:

Code: 

mysql> select reply from talkbot where binding = 'test';+---------------------+| reply               |+---------------------+| \001ACTION test\001 |+---------------------+1 row in set (0.00 sec)
This should make the bot do an action, however this is what I get:

Code: 

23:41 <@DjSlash> !test23:41 <@StatsBot> \001ACTION test\001
I've been trying all kinds of things, but the result remains the same. Any ideas?

Statistics: Posted by DjSlash — Tue Aug 31, 2010 5:43 pm

]]>