Guide/Release: Conquer Server (CoFuture) Using MySql

[leavemealone]

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:

-

You must be registered to see links

(Recommended) All in 1 Package MySql. Apache, PhpMyAdmin
-

You must be registered to see links

-

You must be registered to see links

-

You must be registered to see links

- 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:

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

/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"

 

[MaestroS]

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

 

[hugo_zonderland]

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

#Titanium

 

[dedeco92]

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

 

[dedeco92]

You must be registered to see links

pls help me!

 

[magmas]

You must be registered to see links

pls help me!

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

 

[magmas]

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.

You must be registered to see links

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

 

[dedeco92]

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

 

[magmas]

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

login to phpmyadmin go to accounts

and for the field

You must be registered to see links

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.

 

[arturitto]

Thanks for sharing

 

[MaestroS]

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.

You must be registered to see links

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

 

[markymc2007]

Very nice 0.0 tnxs for sharing

 

[dedeco92]

What change normal player for GM PLAYER??

 

[MarHazK]

maybe -> /gm ?

 

[dedeco92]

What change PLAYER NORMAL FOR GM PLAYER??? thx

 

[arturitto]

It's work?) I don't test it.

 

[dedeco92]

yes work xD pls help me change player normal for GM player

flag 1 = Login
Flag 2 = normal player
flag 3 = BAN

waht flag to GM?

 

[arturitto]

"run test" THX =)

 

[bone-you]

wow. All of these people who cannot help themselves... You all need to learn to do things on your own instead of "omg omg how do this how do that"

 

[supersoto]

Hey all,
I have an error, i think that is for Accounds but i dont understand so much, please i need help.