Guide/Release: Conquer Server (CoFuture) Using MySql

Hello Everyone, Im Future and im releaseing CoFuture aka CoFusion
This server was created by Korvacs & Myself (Future)
The server was created from scratch with the inspiration of CoEmu and also some help from the CoEmu source helping code & navigate through this project. The server was created in C# (C Sharp) and uses MySql.

Server Information:

- Server Name: CoFuture aka CoFusion
- Authors: Korvacs & Future
- Database Type: MySql
- Inspired By: CoEmu
- Source Language: C# (C Sharp)
- Client Version: Qonquer Client (Working Fine)

Requirements:

- Microsoft Visual C# 2005 Express Edition (Recommended) other versions are available
- MySql
- Apache
- PhpMyAdmin
- Conquer Online 2.0 Client Version 4348 <-- You need this to connect

Links:

- AppServ Project (Recommended) All in 1 Package MySql. Apache, PhpMyAdmin
- CoFuture Source & Database Backup from My WebServer
- Server Source from ***********
- Server Working Database from ***********
- Server Working Database from RageZone

Server Port(s) (Enable these ports with your router, firewalls/windows firewall)

- Auth Server: 9960
- Game Server: 9958

Installing AppServ

- ServerName: localhost
- Password: (any password, but dont forget it because u need it to log into phpmyadmin)

Login to PHPMyAdmin

- In your webbrowser type as a url "localhost/phpmyadmin"
- Username: root || Password: (Password you set when installing)


Guide:

1. Starting

Download, Install & Extract everything

2. Adding the Database

Open PhpMyAdmin, On the left Tab Click the button that has "SQL" on it, Click Import, Browse the database you downloaded and import it.

3. Setting up server in database

Open "servers" Table then click "Browse" then edit the current server entry there (Your Servername, Your IP Address or Localhost, Server Port) Save.

4. Creating an Account

Open "accounts" Table then click "Insert" (Account UserName "your username", Leave Password Blank, Type "1" for PM, Auth "1" server to accept connection, Leave Address Blank) Save.

5. Setting up Server to connect to Database

Open "Server" folder then Open the "CoFuture" Project File then open Database.cs and press "ctrl+g" and go to line "39" change "Database Username" to your databases username then on line "40" change "Database Password" to your databases password" and then on line "44" change "Database Name" to "conquer_server" unless you changed the database name. then go to Build --> Build Solution (Solution should build successfully!)

6. Turning the Server On

Method 1. Open "bin" then "x86" then "Debug" then "COServer.exe" I Recommend this Method for Windows XP Home/Professional

Method 2. Open "bin" then "Debug" then "COServer.exe"

Method 3. Open "bin" then "Release" then "COServer.exe"

7. Adding NPC Dialogs

Which ever "COServer.exe" you use there will be a folder "Npcs" in the same directory, create a text file with the name of the npc id you assign in the database, A tutorial on how to code the dialogs down the page.

8. Adding NPC Spawns

Go into your database and go to the "npcs" table and add your npc's there. (Main city npc's already added).

9. Adding Portals

Go into your database and go to the "portals" table and add your portals there (Most portals already added).

10. Adding Shops

Go into your database and go to the "shops" table and add your shops there (Some shops added already).

11. Coding the NPC Dialogs

NpcFace=ID
Dialog=Number (Dialog 0 is first dialog etc)
Text=Speech
Option=ReplyMessage=Dialog Number to go to (255 to close)
CheckMoney=0=amount
True=0
False=0
Teleport=MapID X Y
Item=ItemID Plus Minus Enchant GemIDSocket1 GemIDSocket2 Quality Quality 1
Finish

Example:

Code:

---

NpcId=50
Dialog=0
Text=Hello, Welcome to CoFuture
Option=Item Please=1
Option=Take My 100 Gold=2
Option=Teleport me=3
Option=I want to leave=255
Finish

Dialog=1
Item=410009 9 7 255 13 13 1 1 1
Text=Here is an item
Option=Back to start=0
Option=Good Bye=255
Finish

Dialog=2
CheckMoney=0=100
True=0
Text=Thanks for your 100 gold
False=0
Text=You dont have 100 gold
Option=Back to start=0
Option=Good Bye=255
Finish

Dialog=3
Teleport=1036 212 196
Text=Your At Market
Option=Back to start=0
Option=Good Bye=255
Finish

---

12. Command List

Code:

---

/dc
/clearinv
/save
/gm
/heal
/hp
/mana
/stamina
/reborn 0/1/2
/stats str amount
/stats vit amount
/stats spi amount
/stats agi amount
/stats all amount
/gold amount
/cp amount
/item ItemID Plus Minus Enchant GemIDSocket1 GemIDSocket2 Quality Quality
/job ID
/level level
/goto MapName (from Database)
/skill skillid level
/spell spellid level
/spawn type, type+dir, map, x, y, flag (temporary Npc)
/request charname (Request a characters info)
/where (your coordinates)
/spawnnpcs type, type+dir, map, x, y, flag (Temporary npc)
/statusfix
/invincible
/string something something something
/music on
/music off
/guild guildname bulletin
/status reset
/status
/data something something something something
/dialog something
/createguild guildname
/guildwar
/chattype something something something something
/encrypt password
/decrypt password
/getportals
/update
/addnpc type, type+dir, map, x, y, flag (Permanent)
/removenpc npcid
/npcsay message (Test Command)
/mapmode 1/2/3

---

Sorry for the commands that ive added something for, ive been very busy and those commands are ones korvacs added so im not as much familar with.

Please Give Feedback and ill try answer most questions. Don't say stuff like "Wont connect to database"

It suxs. Why ? NPCs, monsters are not spawning.

To bad Jack stopped:( He was really good! Atleast nice work Future!

#Titanium

what my username??? what username use in database??/ pls help me thx man

http://img4.uploadhouse.com/fileuplo...139236d5ae.jpg

pls help me!

Quote:

---

Originally Posted by dedeco92

http://img4.uploadhouse.com/fileuplo...139236d5ae.jpg

pls help me!

---

edit database.cs and rebuild the thing in visual C# 2005

Quote:

---

Originally Posted by MaestroS

It suxs. Why ? NPCs, monsters are not spawning.

---

you have to code them yourself man things are gonna be handed to you if your gonna use a private server learn some C# man.

Learn C#

theres a nice npc guide on the top of this thread also people arent gonna do it for you.

what my username ..... what look my username? pls help

Quote:

---

Originally Posted by dedeco92

what my username ..... what look my username? pls help

---

login to phpmyadmin go to accounts

and for the field AccountID add your username and leave the password blank set auth and type to 1
and leave the ip blank . open database.cs look for

public static bool ConnectDatabase()
{
string UserName = MakeSafeString("Databasename");
string Password = MakeSafeString("Databasename");

change Database name to your mysql login info usally root and the password you set for it

look for



try
{
DatabaseConnection = new MySqlConnection("Server=localhost;Database='Databasename';Username='" + UserName + "';Password='" + Password + "'");
DatabaseConnection.Open();
return true;
}

change Database='Databasename'; to Database='conquer_server'; then rebuild it in visual C# 2005 and it should run for you.

Thanks for sharing

Quote:

---

Originally Posted by magmas

you have to code them yourself man things are gonna be handed to you if your gonna use a private server learn some C# man.

Learn C#

theres a nice npc guide on the top of this thread also people arent gonna do it for you.

---

Uhm... I don't know how to place creatures on map (sending correct packets). If I'd know - I can code 'em, cause I'm pretty good in C# with database(s).

Very nice 0.0 tnxs for sharing

What change normal player for GM PLAYER??

maybe -> /gm ?

What change PLAYER NORMAL FOR GM PLAYER??? thx