Ok I just made a backup of my server and now going to try convert it to MySql
EDIT: I am going use the CoEmuV2.sql file for a bass and begin with converting accounts then characters then ko then monsters then items and Ko kills, ranks vola most of it is mysql eccept NPC ( not going to mysql ) and stuff like Events and Stuff lol
Has anybody got a Items table with the 5165 items in ?
EDIT 2: ok so I have changed the login method and I have spend about 1 hour on this problem but I get this error Wait I am using this code
And I get these errors
1.The name 'DatabaseConnection' does not exist in the current context
2.The name 'DatabaseConnection' does not exist in the current context
Ok for the errors 1 and 2 they are the same and I think the code is looking for DatabaseConnection.cs But I dont see what to change the code with I did get a few other 5-6 errors but I trued to use my common sence and I got them fixed useing refrences and
Any help ?
EDIT: I am going use the CoEmuV2.sql file for a bass and begin with converting accounts then characters then ko then monsters then items and Ko kills, ranks vola most of it is mysql eccept NPC ( not going to mysql ) and stuff like Events and Stuff lol
Has anybody got a Items table with the 5165 items in ?
EDIT 2: ok so I have changed the login method and I have spend about 1 hour on this problem but I get this error Wait I am using this code
Code:
public static string Password(string Account)
{
string Password = "ERROR";
MySqlCommand Cmd = new MySqlCommand("SELECT * FROM `accounts` WHERE `AccountID` = \"" + Account + "\"", [COLOR=Red]DatabaseConnection[/COLOR].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 + "\"", [COLOR=Red]DatabaseConnection[/COLOR].NewConnection());
Cmd.ExecuteNonQuery();
Cmd.Connection.Close();
Cmd.Dispose();
}
1.The name 'DatabaseConnection' does not exist in the current context
2.The name 'DatabaseConnection' does not exist in the current context
Ok for the errors 1 and 2 they are the same and I think the code is looking for DatabaseConnection.cs But I dont see what to change the code with I did get a few other 5-6 errors but I trued to use my common sence and I got them fixed useing refrences and
Code:
using MySql.Data.MySqlClient;