[Guide]CoEmu v2 Source Setup

[pro4never]

Originally Posted by †Death†Dealer

got game server working and now login server down

There is a guide, you simply need to change the database connection to not be pooled or that's how I remember it.

Read the error 30 fixes, they have been posted here before.



@ person confused about which ip to use.

You will ALWAYS use 127.0.0.1 if you are hosting yourself. Regardless of if it is hosted locally, online or through hamachi, you will be using 127.0.0.1. Only OTHERS connecting will use the external ip.

That's why in the source there are two different ips. One for nano and one for the actual server. Change nano to 127.0.0.1 and the other to your external or hamachi ip if hosting online, change both to 127.0.0.1 if not.

Also ensure Website_ip is NOT 127.0.0.1 or your external ip. Connections using it will NOT work, it's for website server status/admin connections.

[NoFatChicks]

Thanks.

[†Death†Dealer]

The min pool and max pool iv already deleted

[sonofskeletor]

Error Loading D.Maps Database DatabaseConection.cs Line 34
LoginServer Database DatabaseConection.cs Line 30

Seems To Be SQL Error Any Other Ways Around It Or The Right Way Of Installing MySql ?

[pro4never]

Should simply be some incorrect settings or something not allowing you to connect to your sql database.

I'd suggest making a test connection in navicat so you can double check your login information and then re-edit the source (both login server and game server) under Database>DatabaseConnection.cs and double check the user/pass and then debug both servers and try again.

Should be all there is to it really (ps: There are guides / threads posted already specifically for both of those errors...)

[sonofskeletor]

When i do a debug it shows errors of some kind i have no idea what it means lol

EDIT #### Trying to put screen shot up but dunno how lol sorry ill try explain the best way possible.

OK

1st i open CoEmu v2
2nd i go to solution explorer
3rd i go to CoEmu v2 Game Server, Database, DatabaseConnections.cs

/*
* Created by SharpDevelop.
* User: sams

Ill Delete This After To Free Up Space Sorry :/
* Date: 3/8/2009
* Time: 1:13 PM
*
* To change this template use Tools | Options | Coding | Edit Standard Headers.
*/
using System;
using MySql.Data.MySqlClient;

namespace CoEmu_v2_GameServer.Database
{
/// <summary>
/// Provides MySql resource connections, for multiple connections to a single MySql database.
/// This is due to the fact that the server is multi-threaded, so allowing a single connection would
/// likely result in errors, or general loss of performance.
/// </summary>
public static class DatabaseConnection
{
public const string USER_NAME = "USERNAMEHERE";
public const string PASSWORD = "PASSWORDHERE";
public const string SERVER = "127.0.0.1";
public const string DATA_BASE = "conqueremu";
public static MySqlConnection DBConnection = null;
public static MySqlConnection NewConnection()
{
MySqlConnection C = null;
try{
C = new MySqlConnection("Server=" + SERVER + ";Database='" + DATA_BASE + "';Username='" + USER_NAME + "';Password='" + PASSWORD + "'; Min Pool Size = 300; Max Pool Size = 900");
C.Open();
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
return null;
}
return C;
}
}
}

Next I Run DeBug
Microsoft Visual C# Express Edition opens a page called Database.cs

/*
* Created by SharpDevelop.
* User: sams
* Date: 3/8/2009
* Time: 1:10 PM
*
* To change this template use Tools | Options | Coding | Edit Standard Headers.
*/
using System;
using System.Data;
using MySql.Data.MySqlClient;

namespace CoEmu_v2_LoginServer.Database
{
/// <summary>
/// Provides connections for information retrevial from the CoEmu database, which is MySQL based.
/// </summary>
public static class Database
{
public static bool TestConnect()
{
MySqlConnection Connection = DatabaseConnection.NewConnection();
if(Connection.State == ConnectionState.Open)
{
Connection.Close();
Connection.Dispose();
return true;
}
else
{
Connection.Dispose();
return false;
}
}
public static string Password(string Account)
{
string Password = "ERROR";
MySqlCommand Cmd = new MySqlCommand("SELECT * FROM `accounts` WHERE `AccountID` = \"" + Account + "\"", DatabaseConnection.NewConnection());
MySqlDataReader DR = Cmd.ExecuteReader(CommandBehavior.CloseConnection) ;
while(DR.Read())
{
Password = Convert.ToString(DR["Password"]);
}
DR.Close();
return Password;
}
public static void SetPass(string Account, string Pass)
{
MySqlCommand Cmd = new MySqlCommand("UPDATE `accounts` SET `Password` = \"" + Pass + "\" WHERE `AccountID` = \"" + Account + "\"", DatabaseConnection.NewConnection());
Cmd.ExecuteNonQuery();
Cmd.Connection.Close();
Cmd.Dispose();
}
}
}
and it highlights Line 46 , Col 9, Chan 3 with says
if(Connection.state == ConectionState.open <--- higlights in yellow with a box aside it called, NullReferenceException was unhandled.

I Dont Know What This Means Or What I Should Do



Been Doing Some Research And Came Accross This I Dont Know If I Can Your It In This Source Anywhere?

Step 1 : Add Namspace "using System.Data.SqlClient;"

Step 2 : Make Sql connection.

Write this code to create Sql connection.
SqlConnection con = new SqlConnection("Server=You server name or comp name;Database=Yourdatabasename;Trusted_Connectopn= True");
SqlCommand cmd = new SqlCommand("Write your sql query here eg. select * from Table name");
con.Open();
DataSet ds = new DataSet(cmd,con);
SqlDataAdapter da = new SqlDataAdapter();
da.Fill(ds);
con.Close();

[pro4never]

Well if you are getting errors that will obviously mean that you won't be able to run it properly lol.

A list of the errors would be helpful. Usually they are fairly self explanatory (either having to do with an invalid argument, undefined variable or something similar) or it could be something more serious but just saying "I get errors and I don't know what they mean" doesn't help anyone. We aren't psychic and can't read you, or your computer's thoughts.

[snow118]

***** GARETH WE BOTH ON THE SAME SERVER PACK. AND U HAVIN PROBLEMS ROFL. I CANNOT BELIEVE IT. U SAID U FOUND A SERVER PACK UPDATED. IVE FOUND THE SAME ONE. GO ONTO THE OTHER THREAD IVE BEEN ASKING QUESTIONS ABOUT THIS ***** UP PACK FOR 3 DAYS LOLZ. I CANT BELIEVE THIS IS THE ONE U TRYIN TO INSTALL LOOL. ITS HARD AS *** THIS **** IS. COMAPRED TO POWER SOURCE. GET ON MSN WHEN U READ THIS LMAO. SONOFSKELE HAHAHA. LAUGHING ****** MY PANTS WHEN I SEEN THAT

[Pitylee]

Hey.
When I try to run the gameserver, the app crashes. MySQL is running, I can register, and everything. Below is a screenshot.

[Loginserver isn't freezing.]

I use W7, with XAMPP.
Anyone?
Thanks :]

[pro4never]

I forget the specific solution but you are getting error 31, there has been a number of guides/solutions posted for that. If you search I'm positive you will find something (easiest way would be to do advanced search, search replies. Alot of them are shoved in large, multi page threads. Makes it easier to find ****)

Good luck, I'm sure you'll get it working. Lemme know if you run into any other problems.

[nafarre]

I cannot Start CoEmu v2.exe's to start server, which one should i take anyways lol, so many in this file. And its my first time with 5095 Source.

[pro4never]

Game Server> bin> debug> CoEmu v2 GameServer.exe
Login server> bin> debug> CoEmu v2 LoginServer.exe

Debug them both from the source first (right click the project and debug it)

That way any changes made to source will be made in the .exes. Both must be running to log characters in.

[asdjkhjkasdnm,]

i followed guide , and nice guide but i can't login add me , IF any1 ccan help me to make an 5095 p server or 5065 ... :|

[pro4never]

what errors are you getting? just saying you can't login helps no one.

[MikeVan]

where do i get phpMyAdmit O.o