Author Topic: .sql files... A question about some of the modules and getting them to run (Read 3385 times)

Xaun · « **on:** March 03, 2007, 10:02:24 pm »

This may seem like a silly question but here goes anyway. I am not really that good at code so some of this goes over my head. I am an artist not a programmer

When trying to get some of these modules installed like the whois etc.. some of them include .sql files which seem to create databases etc.. my question is.. how do I get it to run and actually do the create databases threads etc.. I know very little about mysql and php so I got totally lost on this. I checked in the threads relating to the individual modules but didn't find any replies about this part of the install of them so instead of spamming 15 threads I figured I would create a new one.

Also I have as of yet been unable to get some of the plugins like !alert to show up in the bot !help or work..

Can anyone help a gal out?

Thanks,

Xaun

Xaun · « **Reply #1 on:** March 03, 2007, 10:03:43 pm »

another thing is there a way to get the bot to always / auto turn !relay on?

Xaun · « **Reply #2 on:** March 03, 2007, 10:05:14 pm »

oh yeah.. and I am using the newest bebot and mysql/php options available as listed here.

Malosar · « **Reply #3 on:** March 03, 2007, 11:43:33 pm »

Download a program called SQLYog to assist with sql dumps.

Xaun · « **Reply #4 on:** March 07, 2007, 02:10:22 am »

great thanks!

Blueeagle · « **Reply #5 on:** March 07, 2007, 02:36:58 am »

Quote from: Xaun on March 03, 2007, 10:03:43 pm

another thing is there a way to get the bot to always / auto turn !relay on?

I made a setting for that using the new settings module. This will be put into trunk shortly.

Meanwhile if you grab the one that's in trunk now you can replace the line

Code: [Select]

$this -> relay = 0;

to read

Code: [Select]

$this -> relay = 0;

That should put relay into private group on by default when bot starts.

I hope that helps.

BlueEagle.

_{Edit: "Shortly" in this case is as soon as I get finished testing it completely. That is as soon as I get off this side track I've gotten in to.}

Naturalistic · « **Reply #6 on:** March 07, 2007, 05:10:51 am »

Blue: that code you posted is the same as what you're changing

Blueeagle · « **Reply #7 on:** March 07, 2007, 07:34:29 am »

Shhh...

Don't say that out loud!!

Jees, now I've got to come up with something truely brilliant.

jjones666 · « **Reply #8 on:** March 07, 2007, 04:53:47 pm »

Quote from: Xaun on March 03, 2007, 10:03:43 pm

another thing is there a way to get the bot to always / auto turn !relay on?

See the link I posted in the below topic for a switchable automatic relay for 0.2 (I'll try and remember to add this to A-Z).
http://bebot.link/index.php/topic,700.msg5215/topicseen.html#new

Let us know directly or ingame the particular plugin problems and we will do our best to help -simply "It doesn't work" doesn't help much ;p

-jj-

Hectares · « **Reply #9 on:** March 15, 2007, 11:01:12 pm »

Sorry to bring this up again but I'm still having problems understanding the madules that also include mysql. I've been searching around but can't find anything that would help me so if anyone has a link that would guide me I'd be very appreciative. Otherwise I'll give a rundown of what I'm doing.

I have the guildbot up and running. I've gotten most of the regular modules running but I'm trying to install this

http://bebot.link/index.php?PHPSESSID=6fj487s289m6j59ktsj60odme6&/topic,580.0.html

I've added the colors.php, level.pvp and the level.sql all into the modules directory. I'm guessing that I have to import the level.sql into the database but I'm not sure how. I've downloaded that SQLYOG program but not really sure what to do with it. Any advice that would point me in the right direction would really be appreciated.

Blueeagle · « **Reply #10 on:** March 16, 2007, 12:39:02 am »

mysql -p -u <username> <database_name>

that should bring you to the mysql prompt if you substitute <username> with the username you've got on the database and substitude <database_name> with the name of the database.

there you type:

\. filename.sql

That will execute the commands in filename.sql and that should set up the table structure for you.

Now in 0.3 the distribution of .sql files should sease as the bot now has got a very good way of executing database commands and this creating database tables in the modules itself.

Hope that helps.