egghelp/eggheads community

add text to database from text on irc

2012-07-28T15:22:49-04:00

Thus, if the result mentioned in my previous post is 0, issue a new SQL-query with an INSERT command.
But honestly, given the number of posts/threads regarding mysql queries, I figured you had that part covered already.

Statistics: Posted by nml375 — Sat Jul 28, 2012 3:22 pm

add text to database from text on irc

2012-07-28T14:05:20-04:00

Thanks for the reply!

Well you almost right (or i miss guided you, sorry)

The text thats written on channel should be stored in database, with a giving ending from a switch or some kind...

hope this clear it a little better

Statistics: Posted by Fire-Fox — Sat Jul 28, 2012 2:05 pm

add text to database from text on irc

2012-07-28T14:01:22-04:00

So it's interpretaton 2:a then...

Use the pubm-binding to catch all channel chatter.
Extract the last word; possibly using split/lindex or regexp patterns?
Build an SQL-query using this word somewhat similar to this:

Code:

set query "SELECT COUNT(*) FROM `database`.`table` WHERE `table`.`field` = '[mysql::escape $varHoldingTheWord]'"

Execute the query and fetch the result.
If the result is larger then 0, there is atleast one match already present in the database, otherwise there was no matches.

Statistics: Posted by nml375 — Sat Jul 28, 2012 2:01 pm

add text to database from text on irc

2012-07-28T13:50:43-04:00

1). You'd like some action to be triggered if a spoken line of text (in a channel or private msg?) ends with a certain word?

- Channel

2). You'd like some action to be triggered if a spoken line of text (in a channel or private msg?), whose last word is not yet present in some kind of database :

- Yes action on the ending off a text like : -html / -php (just example)

2:a). An SQL-database such as MySQL, PostgreSQL, MSQL, etc.

- Mysql (have mysqltcl

2:b). A simple Tcl-list or dict.

- What ? dont understand

I have replied to the questions as good as i could

Statistics: Posted by Fire-Fox — Sat Jul 28, 2012 1:50 pm

add text to database from text on irc

2012-07-28T11:52:37-04:00

I'll try my best to interpret your query, but to be honest, I'm not even sure I'm remotely close to what you are really asking about...

1). You'd like some action to be triggered if a spoken line of text (in a channel or private msg?) ends with a certain word?

2). You'd like some action to be triggered if a spoken line of text (in a channel or private msg?), whose last word is not yet present in some kind of database;
2:a). An SQL-database such as MySQL, PostgreSQL, MSQL, etc.
2:b). A simple Tcl-list or dict.
2:c). A textfile on the filesystem (using some format like csv).

3). ??

Statistics: Posted by nml375 — Sat Jul 28, 2012 11:52 am

add text to database from text on irc

2012-07-28T08:30:59-04:00

Hey!

How do i get tcl to add specific text to database if it has i unique ending

Note: there is no trigger "!"

like :

Code:

some.text.here-endning1some.text.here-endning2

Statistics: Posted by Fire-Fox — Sat Jul 28, 2012 8:30 am