Help with invite

[void4ever]

I hate looking like an idiot, but i could use some help getting the invite script to work correctly with alcobot. It's step 2 thats throwing me for a loop here.

2. Create an ODBC DSN connection to your database. Use the table schema
provided in invite.sql, which is located in the module's directory.

I don't know the first thing about SQL. I have mysql installed along with the ODBC driver, and i've looked over at least 10 sites found from a google search. But there are at least 3 different ways to do this from what i see. User, system, and file.

I'm not looking for a hand out, but if someone could point me at a certain article i can read. or even some quick steps (if there is such a thing) i'd appreciate it.

Void4ever

[hukker]

youd have to import the invite.sql to your mysql, that step is fairly easy, you open up your administrator tool of mysql, and there should be an option of importing *.sql files.
This would create the database you need for invite.

About the ODBC connection between alcobot and mysql, do as followed...
start menu / run / odbcad32 "push enter"
choose the system DSN window, then Add... and select the ODBC driver "MYSQL ODBC DRIVER 5.1"
after that you input the info for your mysql Database, IP address, username / password.
Remeber to set the same Datasource Name as you have in your config settings of alcobot.

btw this invite script is only for the /msg _BOT_ !invite username pass feature when connected to IRC. You could use the internal one, the one for ioftpd only "site invite nick" this way a connection to any DB is not needed. Theres info about how you install the siteInvite.tcl in the readme.txt

"slap me if I have said anything wrong"

[void4ever]

i'm at work now, but i'll remote to my box and give this a try in a bit. One more question, Am i to assume any box that i want to use this invite function on needs to have mysql installed. Or once i create the database i'm good to go even if the box doesn't have mysql installed.

Void4ever

[ko0ky]

Originally Posted by hukker

btw this invite script is only for the /msg _BOT_ !invite username pass feature when connected to IRC. You could use the internal one, the one for ioftpd only "site invite nick" this way a connection to any DB is not needed. Theres info about how you install the siteInvite.tcl in the readme.txt

Are you sure about this? I am trying to configure only site invite cmd via ftp site, the script errors while trying to connect to db and isn't inviting me.

0:24:04 PM > site invite ko0ky
10:24:04 PM 200-.-[Invite]-----------------------------------------------------.
10:24:04 PM 200-| Unable to connect to database "Alcoholicz". |
10:24:04 PM 200-'--------------------------------------------------------------'
10:24:04 PM 200 Command successful.

any suggestions?

[PaRaNoiD_JaCK]

You have to the install the mySQL ODBC driver before you can select "MYSQL ODBC DRIVER 5.1"

http://www.mysql.com/products/connector/odbc/

[void4ever]

already have the connector installed, but it's actually 3.51 not 5.1. But anyways

I ran through your steps hukker, i had to go download an admin tool though

i created the database then imported the invite.sql, then went to the odcb connector page and followed those steps. using the test button it said it connected just fine. So i think i'm set there (i still need to test the bot though)

But as from my last question it looks like any computer i have this script setup on will have to have mysql installed is that correct? Say i have 3 different sites, each with there own user files, i'm going to have to get mysql installed on each box in order for the invite script to work is that correct?

Void4ever

[neoxed]

Originally Posted by void4ever

But as from my last question it looks like any computer i have this script setup on will have to have mysql installed is that correct? Say i have 3 different sites, each with there own user files, i'm going to have to get mysql installed on each box in order for the invite script to work is that correct?

No, the idea is that all sites would share a single invite database.

If you have multiple ioFTPD sites, with the same users and groups, why would you keep them independent? It would make a lot more sense to use a shared database, that way users and groups are consistent across all sites.

[void4ever]

well in the past i had always had multiple sites and each site had it's own users and groups. Everything was seaprate.

What script would you recommend to setup a shared user database between all my sites?

Void4ever

[neoxed]

Originally Posted by void4ever

What script would you recommend to setup a shared user database between all my sites?

There is only one public module to do this - ioShareDb. However, the author no longer supports the module and has not reposted it. I uploaded the original ioShareDb package to my website (for those of you who need it).

http://www.alcoholicz.com/scripts/ot...redb-0.9.0.zip

[hukker]

As I understood it, a DB of somekind was required for the /MSG !invite cmd but not for the "site invite nick" cmd, thats what I thought neoxed.

kooky sorry for missleading.

[eger]

I read this thread many times and I am still unclear if it is possible to use only site invite WITHOUT a dsn. Is this possible or not?

[neoxed]

Originally Posted by eger

I read this thread many times and I am still unclear if it is possible to use only site invite WITHOUT a dsn. Is this possible or not?

You obviously didn't read anything. http://www.inicom.net/forum/showpost...3&postcount=15

[eger]

Sorry, don't know why I didn't understand what I was reading.

I modified the code to make a seperate module that allows for non-db setups with site invite only.

EDIT: I now realize that the use of the invite DB is NOT just for invites. It allows for other modules to depend on it and it's DB for other functions (like nxtools request system). So now I will probably go back and actually create the DB and use it as designed instead of hacking it up to now use it.

I also found this tool which should aid in the building of the sqlite db for the sqlite odbc driver should anyone be using it: http://sqlitebrowser.sourceforge.net/

Neoxed, any plans to have an option to use an sqlite db in the config and have easy to create sqlite db like nxtools? The nxtools setup of the db is much nicer than the one for Alcobot currently. Just a thought.

[hukker]

I must say that sounds like a greate idee, keeping the DB localy...
downside I guess is youd have to add each host/user to each site db

you could use the !site cmd for that then hehe, executeing it on all sites at once