egghelp/eggheads community

right new thing. bind msg - login inv_1 load /home/almighty/eggdrop/scripts/sql/fbsql.so proc inv_1 { nick uhost hand arg } { global chan_1 set arg [split $arg] set user [lindex $arg 0] set pass [lindex $arg 1] sql startquery "SELECT * FROM tbl_member WHERE username = '$user' AND password = '$p...

ok well ive removed the conn variable out of it however it now says
[20:55] Tcl error [inv_1]: sql query statement; you are not connected to a mysql server yet (sql connect).

the sql connect code is:
sql connect localhost user "pass"
sql selectdb almighty

bind msg - login inv_1 # Script starts now load /home/almighty/eggdrop/scripts/sql/fbsql.so set conn [sql connect localhost ***** "*****"] sql selectdb almighty $conn proc inv_1 { nick uhost hand arg } { global chan_1 set arg [split $arg] set user [lindex $arg 0] set pass [lindex $arg 1] ...

right this is my new code load /sql/fbsql.so sql connect localhost ***** "*****" sql selectdb almighty bind msg - login inv_1 # Script starts now proc inv_1 { nick uhost hand arg } { global chan_1 set found 0 set arg [split $arg " "] set user1 [lindex $arg 0] set pass1 [lindex $a...

so u suggest i change the IF statement which ive now done, and also remove the string range commands?

Also if i remove the lindex commands where do i catch the username and password of the member?

the sql server is on localhost

This is the whole script load /sql/fbsql.so sql connect **** **** "****" sql selectdb almighty bind msg - login inv_1 # Script starts now proc inv_1 { nick uhost hand arg } { global chan_1 set found 0 set arg [split $arg " "] set user1 [lindex $arg 0] set user1 [string range $use...

I have the following code proc inv_1 { nick uhost hand arg } { global chan_1 set found 0 set arg [split $arg " "] set user1 [lindex $arg 0] set user1 [string range $user1 0 end] set pass1 [lindex $arg 1] set pass1 [string range $pass1 0 end] set data [sql "SELECT * FROM tbl_member WHE...

Hi there, When my bot gets disconnected through a netsplit it leaves irc but is left in the background processes list. However seeing as it is still active it doesnt run through crontab. I have tried to see if the bot is on irc with /whois <botname> but its not found. Is there a way for the bot to r...

look for two lines which are along the lines of that, if you remove these or comment them out, then it will work

right sorted now, thanks all for your help

right i have the following settings in my config file set global-flood-chan 10:60 set global-flood-deop 3:10 set global-flood-kick 3:10 set global-flood-join 5:60 set global-flood-ctcp 3:60 set global-flood-nick 5:60 set global-aop-delay 5:30 set global-idle-kick 0 set global-chanmode "nt"...

well where do u get the invite file from?

is this the invite.tcl u are on about?

http://www.egghelp.org/files/tcl/InviteKban.zip

if not which one are u on about as im intrested in a script similar to the one u mentioned

I want to directly download the eggdrop file to my shell. What commands would i use to do this.
Sorry new at Shells and Eggys