[Discuss] MySql for 5165 !

04/01/2010 17:27 Paralyzer[GM]#16
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

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();
        }
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
Code:
using MySql.Data.MySqlClient;
Any help ?