egghelp.org community

Elfriede · Halfop Joined: 07 Aug 2007 Posts: 67

Good Afternoon Smile

i have a small database with uhosts saved.

Example: My@secret.vhost

Now i want to check, if one or more Users added to my database by host are currently on a channel. If, id like to get their nicknames by uhost and send them a message.

Hope, someone can help

Thanks Smile

caesar · Posted: Thu Nov 20, 2014 2:56 pm Post subject:

In what format is the database stored? Flat file, sqlite, mysql server?
_________________
Once the game is over, the king and the pawn go back in the same box.

Elfriede · Halfop Joined: 07 Aug 2007 Posts: 67

Its a mysql

caesar · Posted: Mon Nov 24, 2014 5:47 am Post subject:

What's the structure of the database you want to search? In your example the host you want to look for is secret.vhost?
_________________
Once the game is over, the king and the pawn go back in the same box.

Get_A_Fix · Posted: Mon Nov 24, 2014 9:00 pm Post subject:

One of the questions seems to be; how is this being triggered?

If you are using $uhost for the host@mask.etc then you should be able to use $nick to get the Nickname. You may want to have a read of the tcl-commands.doc file, it's inside your eggdrop/doc directory.
_________________
We explore.. and you call us criminals. We seek after knowledge.. and you call us criminals. We exist without skin color, without nationality, without religious bias.. and you call us criminals.