Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Conquer Online 2 > CO2 Private Server
You last visited: Today at 15:19

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Discuss] MySql for 5165 !

Discussion on [Discuss] MySql for 5165 ! within the CO2 Private Server forum part of the Conquer Online 2 category.

Reply
 
Old 04/01/2010, 17:27   #16
 
elite*gold: 0
Join Date: Feb 2010
Posts: 492
Received Thanks: 222
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 ?
Paralyzer[GM] is offline  
Reply


Similar Threads Similar Threads
[Release]MySql Databse 5165
04/22/2010 - CO2 PServer Guides & Releases - 7 Replies
New Source NewestCoSource Using MySql Database You Can Use it Free ! Sql Tabels : accounts characters config items skills cq_flowers
Files 5165 But in MySql with DB
04/06/2010 - Conquer Online 2 - 0 Replies
hi i need files 5165 but in mysql with DB, if any person have a link to download please post the link.
An Idea For Making 5165 With MySql
03/07/2010 - CO2 Private Server - 9 Replies
I Have An Idea. That Making A 5165 Soure With MySql By Getting A 5095 MySql Source. And Then Adding Hourse And Clan And Any Thing In The 5165 To Be Added To The 5095. It Is Not A Bad Idea. Plz Try And Thx.
5165 And Mysql
02/10/2010 - CO2 Private Server - 0 Replies
#request close
[Question] Mysql 5165
01/03/2010 - CO2 Private Server - 6 Replies
Is possivel put mysql in source 5165? is it is how i can do that?



All times are GMT +1. The time now is 15:21.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.