Keanu

why would you ask for scriptdev help on mangos forum??

www.scriptdev2.com

Because its part of the guide.

Make sure you type EXACTLY this. If you're using Putty, CTRL+C it from this forum on your pc, then right click in putty when the green type-bar is in the right place, and it will paste it for you.

~# cd mangos

~# svn co https://ScriptDev2.svn.sourceforge.net/svnroot/ScriptDev2/ src/bindings/ScriptDev2

Make sure your cd is mangos aswell. ^^

Any more problems, follow what Davemm said, and go onto Scriptdev2.com

-Keanu

I need to do an update for ya~

What was origionally this:

We will use this in place of a Windows/Mac MySQL application.

Create the MaNGOS database

Code:

~# mysql -p'YOUR PASSWORD HERE' < mangos/sql/create_mysql.sql

~# mysql -p'YOUR PASSWORD HERE' < scriptdev2/sql/scriptdev2_create_database.sql

~# mysql -p'YOUR PASSWORD HERE' scriptdev2 < scriptdev2/sql/scriptdev2_create_structure_mysql.sql

Now needs to change to this:

We will use this in place of a Windows/Mac MySQL application.

Create the MaNGOS database

Code:

~# mysql -p'YOUR PASSWORD HERE' < mangos/sql/create_mysql.sql

~# mysql -p'YOUR PASSWORD HERE' < mangos/src/bindings/ScriptDev2/sql/scriptdev2_create_database.sql

~# mysql -p'YOUR PASSWORD HERE' scriptdev2 < mangos/src/bindings/ScriptDev2/sql/scriptdev2_create_structure_mysql.sql

The things that have changed is, putting "ScriptDev2" with its caps, linux is a bitch for that. Thats why I was having so many problems. I'm running through it with phpmyadmin now getting the db working. Hopefully I can do it. Thanks for the brilliant guide and I will keep posting if I find any problems!

-Keanu

Okay after a few hours tinkering, and installing PHPMyAdmin, i've logged in and seen that there are no db's.... So im actually upset. x_x; Wondering quite what to do aswell. LOL.

-Josh

Thank you so much for your reply, I will give that all a try now!

-Keanu

// Update

Apparantly when I typed in

$ sudo apt-get install openssh-server

openssh-server is already the newest version? but im currently using the FileZilla thats on XAMPP, so I have just downloaded a stand-alone copy of it... You're a genius! All working for that part. Okay, so I got that all working, what do you reckon the problem would be with the SQL commands:

Step 7 - Realmlist

Where going to update the realm name and IP so it can be accessed from other computers.

Code:

~# mysql -p'YOUR PASSWORD HERE' realmd < UPDATE realmlist SET name = 'Your Realm Name' WHERE id = 1;

~# mysql -p'YOUR PASSWORD HERE' realmd < UPDATE realmlist SET address = 'Your IP' WHERE id = 1;

It just won't sorta execute them?... I'm wondering if I would have to install some form of PHPMyAdmin and edit the SQL like that, may not be the safest way, but.. Certainly get it done. Then delete it afterwards?... Do you think that would work?

One last thing aswell, the bin folder didn't exist in my mangos folder? so I created it. That all okay? Directory of it being: "/(username)/mangos/bin"

Thanks in advance!

-Josh

Anyone? Can anyone give me a hand with a few of my problems?.. Sorry to keep bugging, but I just need to get it sorted..

-Keanu

Uhm.. I'm having a few problems with the installation. I've got a Ubuntu VPS.. when I try to do this:

Step 7 - Realmlist

Where going to update the realm name and IP so it can be accessed from other computers.

Code:

~# mysql -p'YOUR PASSWORD HERE' realmd < UPDATE realmlist SET name = 'Your Realm Name' WHERE id = 1;

~# mysql -p'YOUR PASSWORD HERE' realmd < UPDATE realmlist SET address = 'Your IP' WHERE id = 1;

I get the following error

You have an error in your SQL Syntax; check the manual (Blah blah)

So I decided okay, lets just skip that step for the moment and go onto the next one.. So I opend up filezilla, and enterd my IP, and my password.. Didn't login, "Error, could not connect to server...Trying to reconnect in 5 seconds".. So I changed the port to 21... Still no luck. So I was wondering if there was a FTP server that I had to download for the ubuntu? Maybe?.. To be honest I don't quite know if the SQL databases have worked... It just pretty much shows this:

~# mysql -p'YOUR PASSWORD HERE' mangos < mangos/sql/mangos.sql

~# mysql -p'YOUR PASSWORD HERE' characters < mangos/sql/characters.sql

~# mysql -p'YOUR PASSWORD HERE' realmd < mangos/sql/realmd.sql

~# mysql -p'YOUR PASSWORD HERE' scriptdev2 < scriptdev2/sql/scriptdev2_script_full.sql

So it shows exactly that. Don't quite know if that has created them, etc. etc.

Thanks in advance! Hope for a quick reply, if nothing can someone message me on MSN:

[email protected]

Thanks!

-Keanu