[cs346]

have problems whit MySQL Query Browser

please help me.

add me on msn christian.skogstad@c2i.net

[phini]

thanks a lot =D

[onur095]

How can i start the server`?


.....----.... LOL .....----.....'''-----...............------------



-.-

[onur095]

And Nice Guide !

[onur095]

Quote: Originally Posted by AskingAround

Hi all. Seems everyone wants a Conquer Server I decided to make a guide on how to.

REQUIREMENTS:
MySQL 5.0 :
[Only Registered and Activated Users Can See Links. Click Here To Register...]

MySQL Gui Tools for 5.0 :[Only Registered and Activated Users Can See Links. Click Here To Register...]

AppServ :[Only Registered and Activated Users Can See Links. Click Here To Register...]

Source of Server :
[Only Registered and Activated Users Can See Links. Click Here To Register...]

Register Page :
[Only Registered and Activated Users Can See Links. Click Here To Register...]

You're done with downloads.

----------------------------------------------------------------

Steps

1. Downlading..
Download every programs above.

2. Installing MySQL
Install MySQL 5.0 first of all. When the instalation is finished just configure MySQL in that moment. Press next everytime, When Password thing comes up put your password [REMEBER THE PASSWORD YOU'LL NEED IT FOR LATER]

3. Installing Gui Tools
Install MySQL Gui Tools normally.

4. Installing AppServ
Install AppServ and let everything chosen. When the install finishes let it starts Apache and MySQL. When the thing to put servername comes up just input there localhost and put in e-mail adress space your e-mail.

5.Setting the source
Open the source and go to CoServerProject/Bin/debug and open Config.ini
It will look like this:

[Server]
ServerIP= Put your ip here
XPRate= The Exp Rate You want for your server
ProfXPRate= The Profiency Rate you want for you server
DBUserName = "root" <<--- MySQL Username
DBUserPass = "DBPASSWORD HERE" <<<-- Password when you installed MySQL

There you have your source setup.

6.Getting the server to connect to the database.
Go to MySQL Query Browser(One of the tools of MySQL) and You'll to set it up too.
Make it look like this:
Stored Connection: (Let this in blank)
Server Host: localhost
Username: root
Password: (Password when installing MySQL)
Default Schema: coproj

It will ask you if you want to create something just press yes.

Go to Left up Corner and Press file and press Open Script.
Select The backup that's in Source folder. It's name it's Backup. After that press Continue in the right up corner.

After that press Execute in Right up Corner too

Then you can close it.

[THE SERVER CAN CONNECT ALREADY TO THE DATABASE]

Open the table accounts..
To Create accounts you gotta just Insert this
Username: UserYouwant
Password: Leave this space blank
LogonType: 2
LogonCount: 0
Status: 2 [IF U WANT A GM ACCOUNT JUST PUT 8 HERE FOR NORMAL PLAYERS INSERT 2]

Leave everything the rest in blank...

There you can connect to your server..

This server has all skills fixed and Reborn NPC Added in Market and you need a Celestial Stone to reborn or it will look like it don't work.

This Server works with patch 5016.

Don't forget to open the ports to your router

They are :
Type : Both
Ports: 9958 and 3306

7. How to setup your Register Page!

Download the Register Page above and do the following steps.

Extract the register and Copy the index.php to appserv folder in C:// or wherever you installed it.. and go to the folder www Paste the index.php there. Open it with NotePad and press Ctrl + G and go to the line 21 You'll find there where it says YOURDBPASSWORD change it to your MySQL Password and Save the index.php

To preview your website go to
[Only Registered and Activated Users Can See Links. Click Here To Register...]
If you want to give the others your website Just give them like this
[Only Registered and Activated Users Can See Links. Click Here To Register...]

xxx* Means the numbers of ur ip.

There you have your website maded..

I would like a Thanks for this guide!!!! Spent like 1 hour doing it xD

Thanks

--------------------------------------------------------------------------------------------------------------
How can i start the server? and can u make a video ?

[skycow]

Isnt this just PowerSource? ..
go to original thread for the video tut

anyways... this is not making any sense, if you leave the "password" in db blank, what pw you use to login with then?... -__-

[pokrocpityu]

Hey man!XD.I've installed ur server and everybody said that it is great:).I just can't connect to it [I think bcs i have router] my server.dat looks like this:
[Header]
GroupAmount=1
Group1=GroupPic9

[Group1]
ServerAmount=1

Server1=AvenueCO
Ip1= 85.186.5.154 [I tryed with my local IP and 127.0.0.1 too]
Port1=9958
ServerName1=AvenueCO
HintWord1=Together We Can do IT!
Pic1=servericon30

And I don't find the GM Commands :[ Please can you help me?:D

[SmallxTaylor]

how do i make account plz help me

[SmallxTaylor]

what do we do now seeing that half of the down loads dont work?