egghelp.org community

[Fire-Fox]

Hey!

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

Note: there is no trigger "!"

like :

[nml375]

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). ??
_________________
NML_375, idling at #eggdrop@IrcNET

[Fire-Fox]

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
_________________
GreatZ
Fire-Fox | Denmark

Scripts: Relay | Store Text | TvMaze

[nml375]

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:

[Fire-Fox]

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
_________________
GreatZ
Fire-Fox | Denmark

Scripts: Relay | Store Text | TvMaze

[nml375]

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.
_________________
NML_375, idling at #eggdrop@IrcNET