[Guide] Fixed Login On Lotf

[MeGaMaX]

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

    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

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

make it

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

also for this one too

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

make it

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

also for this one too

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

make it

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

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

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

make it

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

GOOD!Now open General.cs
search for

DataBase.Connect(DBUserName, DBUserPass);

after it add

DataBase.Connect2(DBUserName, DBUserPass);

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

           try
            {

in this statement u can find

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

after it add

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

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

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

add

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

it should look like
GetCharInfo

        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

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]

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]

Originally Posted by Steph Sorry you can't view links because you are not registered. [ Click here to register ]

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]

Originally Posted by BloodThirsty Sorry you can't view links because you are not registered. [ Click here to register ]

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]

Originally Posted by Pseudonym Sorry you can't view links because you are not registered. [ Click here to register ]

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

which is as followd.

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.

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 ^_^

[kirila007]

please fix your title, "Fixed login on LOTF" you can't do it on PowerSource, cuz it has 2 databases 1 External and 1 Internal...

[diegoalefru]

tranks, for the Credits ;d

[xxFastBoy]

Not wrok...