[Guide] Fixed Login On Lotf

MeGaMaX · #1 (**permalink**) 10-08-2008, 09:56 AM

All u have to do is in database.cs and a bit in general.cs

Good....now search for "public static MySqlConnection Connection;"
after it add
"public static MySqlConnection LoginConnection;"
now search for "public static bool Connect(string user, string pass)"after its end add

Code:

    public static bool Connect2(string user, string pass)
        {
            try
            {
                LoginConnection = new MySqlConnection("Server='localhost';Database='coproj;Username='" + user + "';Password='" + pass + "'");
                LoginConnection.Open();
                return true;
            }
            catch
            {
                return false;
            }
        }

good...now
search for

Code:

 DataAdapter = new MySqlDataAdapter("SELECT * FROM `Accounts` WHERE `AccountID` = '" + UserName + "'", Connection);

make it

Code:

DataAdapter = new MySqlDataAdapter("SELECT * FROM `Accounts` WHERE `AccountID` = '" + UserName + "'", LoginConnection);

also for this one too

Code:

 MySqlCommand Command = new MySqlCommand("UPDATE `Accounts` SET `Password` = '" + Password + "' WHERE `AccountID` = '" + UserName + "'", Connection);

make it

Code:

MySqlCommand Command = new MySqlCommand("UPDATE `Accounts` SET `Password` = '" + Password + "' WHERE `AccountID` = '" + UserName + "'", LoginConnection);

also for this one too

Code:

MySqlCommand Comm = new MySqlCommand("UPDATE `Accounts` SET `LogonCount` = " + LogonCount + " WHERE `AccountID` = '" + UserName + "'", Connection);

make it

Code:

MySqlCommand Comm = new MySqlCommand("UPDATE `Accounts` SET `LogonCount` = " + LogonCount + " WHERE `AccountID` = '" + UserName + "'", LoginConnection);

after this things at "public static void GetCharInfo" u`ll see

Code:

MySqlDataAdapter DataAdapter = new MySqlDataAdapter("SELECT * FROM `Characters` WHERE `Account` = '" + UserName + "'", Connection);

make it

Code:

MySqlDataAdapter DataAdapter = new MySqlDataAdapter("SELECT * FROM `Characters` WHERE `Account` = '" + UserName + "'", LoginConnection);

GOOD!Now open General.cs
search for

Code:

DataBase.Connect(DBUserName, DBUserPass);

after it add

Code:

DataBase.Connect2(DBUserName, DBUserPass);

at public static void GetCharInfo(Character Charr, string UserName)
before DataSet DSet = new DataSet();
add a

Code:

           try
            {

in this statement u can find

Code:

 
              else
                    General.WriteLine("Char not found.");

after it add

Code:

            }
            catch (InvalidOperationException exc)
            {
                General.WriteLine(Convert.ToString(exc));
                LoginConnection.Open();
            }

Now....
at public static byte Authenticate(string UserName, string Password)
before

Code:

            MySqlDataAdapter DataAdapter = null;
            DataAdapter = new MySqlDataAdapter("SELECT * FROM `Accounts` WHERE `AccountID` = '" + UserName + "'", LoginConnection);

add

Code:

            LoginConnection.Close();
            LoginConnection.Open();

it should look like
GetCharInfo

Code:

        public static void GetCharInfo(Character Charr, string UserName)
        {
            try
            {
            DataSet DSet = new DataSet();
            MySqlDataAdapter DataAdapter = new MySqlDataAdapter("SELECT * FROM `Characters` WHERE `Account` = '" + UserName + "'", LoginConnection);
            DataAdapter.Fill(DSet, "Character");
            if (DSet != null && DSet.Tables["Character"].Rows.Count > 0)
            {
                DataRow DR = DSet.Tables["Character"].Rows[0];
 
 
                Charr.UID = (uint)DR["UID"];
                Charr.Name = (string)DR["CharName"];
                Charr.Job = Convert.ToByte((uint)DR["Job"]);
                Charr.Level = Convert.ToByte((uint)DR["Level"]);
                Charr.Exp = (uint)DR["Exp"];
                Charr.Model = Convert.ToUInt16((uint)DR["Model"]);
                Charr.Avatar = Convert.ToUInt16((uint)DR["Avatar"]);
                Charr.Hair = Convert.ToUInt16((uint)DR["Hair"]);
                Charr.LocX = Convert.ToUInt16((uint)DR["LocationX"]);
                Charr.LocY = Convert.ToUInt16((uint)DR["LocationY"]);
                Charr.LocMap = Convert.ToUInt16((uint)DR["LocationMap"]);
                Charr.Str = Convert.ToUInt16((uint)DR["Strength"]);
                Charr.Agi = Convert.ToUInt16((uint)DR["Agility"]);
                Charr.Vit = Convert.ToUInt16((uint)DR["Vitality"]);
                Charr.Spi = Convert.ToUInt16((uint)DR["Spirit"]);
                Charr.Silvers = (uint)DR["Money"];
                Charr.CPs = (uint)DR["CPs"];
                Charr.CurHP = Convert.ToUInt16((uint)DR["CurrentHP"]);
                Charr.PKPoints = Convert.ToUInt16((uint)DR["PKPoints"]);
                Charr.RBCount = Convert.ToByte((uint)DR["RBCount"]);
                Charr.PackedInventory = (string)DR["Inventory"];
                Charr.PackedEquips = (string)DR["Equipment"];
                Charr.PackedSkills = (string)DR["Skills"];
                Charr.PackedProfs = (string)DR["Profs"];
                Charr.WHSilvers = (uint)DR["WHMoney"];
                Charr.PackedWHs = (string)DR["Warehouses"];
                Charr.PackedFriends = (string)DR["Friends"];
                Charr.PackedEnemies = (string)DR["Enemies"];
                Charr.VP = (uint)DR["VP"];
                Charr.GuildDonation = (uint)DR["GuildDonation"];
                Charr.GuildID = Convert.ToUInt16((uint)DR["MyGuild"]);
                Charr.GuildPosition = Convert.ToByte((uint)DR["GuildPos"]);
                Charr.PrevMap = Convert.ToUInt16((uint)DR["PrevMap"]);
                if (Guilds.AllGuilds.Contains(Charr.GuildID))
                    Charr.MyGuild = (Guild)Guilds.AllGuilds[Charr.GuildID];
                Charr.MinAtk = Charr.Str;
                Charr.MaxAtk = Charr.Str;
                Charr.Potency = Charr.Level;
                Charr.RealModel = Charr.Model;
                Charr.RealAvatar = Charr.Avatar;
                Charr.MaxHP = Charr.BaseMaxHP();
                Charr.RealAgi = Charr.Agi;
            }
            else
                General.WriteLine("Char not found.");
        }
        catch (Exception Exc) { General.WriteLine(Convert.ToString(Exc)); }
    }

Autenthicate

Code:

public static byte Authenticate(string UserName, string Password)
        {
            LoginConnection.Close();
            LoginConnection.Open();
            MySqlDataAdapter DataAdapter = null;
            DataAdapter = new MySqlDataAdapter("SELECT * FROM `Accounts` WHERE `AccountID` = '" + UserName + "'", LoginConnection);
            DataSet DSet = new DataSet();
            DataAdapter.Fill(DSet, "Account");
 
            if (DSet != null && DSet.Tables["Account"].Rows.Count > 0)
            {
                DataRow DR = DSet.Tables["Account"].Rows[0];
 
                string Pass = (string)DR["Password"];
                if (Pass == Password || Pass == "")
                {
                    if (Pass == "")
                    {
                        MySqlCommand Command = new MySqlCommand("UPDATE `Accounts` SET `Password` = '" + Password + "' WHERE `AccountID` = '" + UserName + "'", LoginConnection);
                        Command.ExecuteNonQuery();
                    }
 
                    uint LogonCount = (uint)DR["LogonCount"];
                    LogonCount++;
 
                    MySqlCommand Comm = new MySqlCommand("UPDATE `Accounts` SET `LogonCount` = " + LogonCount + " WHERE `AccountID` = '" + UserName + "'", LoginConnection);
                    Comm.ExecuteNonQuery();
 
                    return Convert.ToByte((uint)DR["LogonType"]);
                }
                else
                    return 0;
            }
            else
                return 0;
        }

Credits go to diegoalfru from rage

Steph · #2 (**permalink**) 10-08-2008, 08:39 PM

it is not working on my source , i use ShadowCo source. I made it like u said and after we can't login... getting errors on server console.... why ?

xX.blood.Xx · #3 (**permalink**) 10-08-2008, 11:50 PM

Quote:

Originally Posted by Steph

it is not working on my source , i use ShadowCo source. I made it like u said and after we can't login... getting errors on server console.... why ?

then u have added it wrong into ur source.. start freash read the guide
even tho it is taken from ****. word for word almost completely. but it does work..

Pseudonym · #4 (**permalink**) 10-09-2008, 12:01 AM

Quote:

Originally Posted by BloodThirsty

then u have added it wrong into ur source.. start freash read the guide
even tho it is taken from ****. word for word almost completely. but it does work..

Not really. Somebody said you need to do one more thing in order to fix it...

xX.blood.Xx · #5 (**permalink**) 10-09-2008, 12:04 AM

Quote:

Originally Posted by Pseudonym

Not really. Somebody said you need to do one more thing in order to fix it...

which is as followd.

Quote:

at public static void GetCharInfo(Character Charr, string UserName)
before DataSet DSet = new DataSet();
add a

Code:

try
{

which on elit**** is like this as followd.

Quote:

Well...Korvacs is saying the truth...without a path it wont give any reusults....
So,here it comes:
at public static void GetCharInfo(Character Charr, string UserName)
before DataSet DSet = new DataSet();
add a
Code:

try
{

thanks bye now ^_^