L* R*
HOME FORUM DOWNLOADS
Content
  Links
     Browse SVN
     SVN Commit log
     Documentation (Wiki)
  Developers
     Taskmanager
User
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 02, 2008, 12:59:59 AM

Login with username, password and session length
Search



Advanced search
Support GoPHP5.org
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > Support for older versions > BeBot 0.3 support > Topic: .sql files... A question about some of the modules and getting them to run
Pages: [1]   Go Down
« previous next »
Print
Author Topic: .sql files... A question about some of the modules and getting them to run  (Read 811 times)
0 Members and 1 Guest are viewing this topic.
Xaun
Freshman
*
Offline Offline

Posts: 5


.sql files... A question about some of the modules and getting them to run
« on: March 03, 2007, 04: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  Tongue

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
Logged
Xaun
Freshman
*
Offline Offline

Posts: 5


Re: .sql files... A question about some of the modules and getting them to run
« Reply #1 on: March 03, 2007, 04:03:43 PM »

another thing is there a way to get the bot to always / auto turn !relay on?
Logged
Xaun
Freshman
*
Offline Offline

Posts: 5


Re: .sql files... A question about some of the modules and getting them to run
« Reply #2 on: March 03, 2007, 04:05:14 PM »

oh yeah.. and I am using the newest bebot and mysql/php options available as listed here.
Logged
Malosar
Expert
*****
Offline Offline

Posts: 259


WWW
Re: .sql files... A question about some of the modules and getting them to run
« Reply #3 on: March 03, 2007, 05:43:33 PM »

Download a program called SQLYog to assist with sql dumps.
Logged

Eternalist
General of The Syndicate
Xaun
Freshman
*
Offline Offline

Posts: 5


Re: .sql files... A question about some of the modules and getting them to run
« Reply #4 on: March 06, 2007, 08:10:22 PM »

great thanks!
Logged
Blueeagle
Omnipotent
BeBot Developer
Expert
********
Offline Offline

Gender: Male
Posts: 313



Re: .sql files... A question about some of the modules and getting them to run
« Reply #5 on: March 06, 2007, 08:36:58 PM »

Quote from: Xaun on March 03, 2007, 04: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:
$this -> relay = 0;

to read
Code:
$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.
Logged

The only problem that can't be solved by adding another wrapper is having too many wrappers.
Naturalistic
BeBot Contributor
Experienced
*******
Offline Offline

Posts: 221


Re: .sql files... A question about some of the modules and getting them to run
« Reply #6 on: March 06, 2007, 11:10:51 PM »

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

220/25 Eternalist Doctor
-----------------------------
Campalot Coding Co-ordinator and Super Admin
http://www.campalot.info/index.php
Blueeagle
Omnipotent
BeBot Developer
Expert
********
Offline Offline

Gender: Male
Posts: 313



Re: .sql files... A question about some of the modules and getting them to run
« Reply #7 on: March 07, 2007, 01:34:29 AM »

Shhh...

Don't say that out loud!!

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

The only problem that can't be solved by adding another wrapper is having too many wrappers.
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: .sql files... A question about some of the modules and getting them to run
« Reply #8 on: March 07, 2007, 10:53:47 AM »

Quote from: Xaun on March 03, 2007, 04: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.shadow-realm.org/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-
Logged
Hectares
Freshman
*
Offline Offline

Posts: 4


Re: .sql files... A question about some of the modules and getting them to run
« Reply #9 on: March 15, 2007, 05: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.shadow-realm.org/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.
Logged
Blueeagle
Omnipotent
BeBot Developer
Expert
********
Offline Offline

Gender: Male
Posts: 313



Re: .sql files... A question about some of the modules and getting them to run
« Reply #10 on: March 15, 2007, 06:39:02 PM »

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.
Logged

The only problem that can't be solved by adding another wrapper is having too many wrappers.
Pages: [1]   Go Up
Print
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Support > Support for older versions > BeBot 0.3 support > Topic: .sql files... A question about some of the modules and getting them to run
« previous next »
 
Jump to:  

Recent
[request] Raid timers
by Elesar1
[December 01, 2008, 04:41:09 PM]

Shared DB online list
by Temar
[December 01, 2008, 01:55:47 AM]

relay colors
by Temar
[December 01, 2008, 01:54:56 AM]

BeBot v0.6.0 released
by Alreadythere
[November 30, 2008, 05:32:00 PM]

Change to Bid.php
by Temar
[November 30, 2008, 11:41:44 AM]

OnlineOrg
by Jiheld
[November 29, 2008, 12:44:27 PM]

Silly Newbie Question.
by Temar
[November 29, 2008, 12:00:02 PM]

massive_pvp_time_table 1
by gerborg
[November 29, 2008, 06:55:35 AM]

Bot not see Guild Chat
by Delvar
[November 28, 2008, 08:30:34 AM]

Starting Bot
by Allisande
[November 28, 2008, 07:08:21 AM]
Stats
Members
Total Members: 1243
Latest: Whackoeng
Stats
Total Posts: 11144
Total Topics: 1505
Online Today: 21
Online Ever: 168
(July 01, 2007, 09:30:02 PM)
Users Online
Users: 0
Guests: 17
Total: 17

Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
TinyPortal v0.9.8 © Bloc | NewDef design by Bloc
Page created in 0.217 seconds with 29 queries. (Pretty URLs adds 0.056s, 4q)
Loading...