Author Topic: Pretend i know nothing about SQL :) (Read 12358 times)

Ltes · « **on:** April 20, 2005, 02:10:40 am »

Ok, lets pretend i know nothing about SQL. Not how to set it up or do what i need to here with it... as i dont

I downloaded the administration one as it said somewhere else in these forums and am now completely lost

<---is a n00b

Btw, what the hell does it do on bebot?

craized · « **Reply #1 on:** April 20, 2005, 04:35:56 am »

http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.11-win32.zip/from/pick

Download MySQL server here.

What it does for the bot is hold administrator information, ie who is admin, and what type of admin they are. As well, it holds the items database for items lookups using the !items command. In aditioin, I'm sure it does much much more that I don't know about because I never touch it.

Ltes · « **Reply #2 on:** April 20, 2005, 04:39:17 am »

lol thanks very much

*wonders what secrets the SQL server holds*

like that commercial...what was it "wonder wonder whats in a... SQL server..."

erm...yea nvm

Ltes · « **Reply #3 on:** April 20, 2005, 11:15:55 pm »

omg i hate sql...this is honestly the first time i've needed to use it...help

craized · « **Reply #4 on:** April 21, 2005, 03:17:43 am »

More specific please.

How far have you gotten, what is your problem?
Post any error messages that may have come up.

Ltes · « **Reply #5 on:** April 21, 2005, 04:23:31 am »

um well basically i have it installed...ran the wizard...*yawn* i'm now trying to find a way to start something happening

Greel · « **Reply #6 on:** April 21, 2005, 03:28:28 pm »

Here are some questions that will help us get you in the right direction.
What OS are you using?
Do you have php already installed?
What point have you reached before you totally got lost?

Today is a good day to pick my brain. Work is exceptionally boring. Also, don't fret, I was in your shoes about 2 months ago. Now I use mysql daily. (granted I tend to use coldfusion instead of php, but thats due to being a lazy ass!)

Ltes · « **Reply #7 on:** April 21, 2005, 11:33:03 pm »

OS - XP
php- yes
not lost so much as "i'm not gonna f*ck this up"

Heres whats happening atm...i have it installed and i'm scrolling through a command prompt in which i can check sql databases and shit...beyond that i'm saying "help"

oh, and am scanning through a help guide but its way to long and i'm waaaaaaay to lazy ;p

craized · « **Reply #8 on:** April 22, 2005, 12:16:56 am »

When you're at the command prompt, whish should say something like
mysql>
type
create database bebot;
(or whatever the database name you want to use is)
next, type
use bebot;
after that, find out what the path to the items.sql file is, and then type
source PATH TO items.sql;
It should update rows of data for a while. After its done, close the command prompt.

Then, all you have to do is put your mysql info into MySQL.conf, and your bot info into Bot.php, and you're all set!

Ltes · « **Reply #9 on:** April 22, 2005, 04:35:30 am »

Quote from: "craized"

after that, find out what the path to the items.sql file is, and then type
source PATH TO items.sql;

1) whats the items.sql file for? (trying to setup for a raidbot)
2) second if plan to run bebot on a different comp than my sql should i use that comps ip adress or use a path through my network?

Lal · « **Reply #10 on:** April 22, 2005, 07:57:40 am »

Quote from: "Ltes"

Quote from: "craized"

after that, find out what the path to the items.sql file is, and then type
source PATH TO items.sql;

1) whats the items.sql file for? (trying to setup for a raidbot)
2) second if plan to run bebot on a different comp than my sql should i use that comps ip adress or use a path through my network?

1) you'll have to upload it to your mysql file in order to get results with !items item
2) (Internal) IP address

Ltes · « **Reply #11 on:** April 23, 2005, 03:38:37 am »

ok, lol i'm evidently am an idiot, but lets see...i've worked my way through to actually getting start the start.php file, however i get the message

Quote from: "command prompt"

warning:mysql_connect(): Can't connect to MySQL server on [computer ip](10061) in [location]MySQL.php on line 36
[Keine Verbindung zur datenbank!] (can't connect to mySQL server on 'computer ip' (10061))

regardless of what i use for the server adress i get that it cant connect, theres something wrong on line 36

any help?

Actually after digging around again, i think my biggest issue is not knowing what server to instruct the bot to connect to...i assumed i set it to my comps ip but thats not working

Lal · « **Reply #12 on:** April 23, 2005, 09:13:16 am »

well it prolly is soemthing like:

10.0.0.number

192.168.0.number

192.168.1.number

Ltes · « **Reply #13 on:** April 23, 2005, 10:07:27 pm »

I get a "line 36 error" for every single ip i try...i cant seem to find a cause either...

i'm prolly just doing something wrong

Also, would SQLlite work? if i could figure that out it seems easier

craized · « **Reply #14 on:** April 23, 2005, 11:55:17 pm »

Try this on the machine you're running mysql on.
Start Menu>>Run>>cmd
then press enter.
At the command prompt, type ipconfig.
You get should a few lines of information.
On the machine you're running the bot on now, for the mysql host, put in the address that started with IP Address...

Good luck, and I've never tried SQLight, but I spose if you want to try it probably can't hurt.