コード例 #1
0
ファイル: Program.cs プロジェクト: Dastano/D3SharpDatabase
        static void Main(string[] args)
        {
            try
            {
                string account_name = "orior3";
                string password = "******";
                Database.Instance.Connect();
                if (Database.Instance.Connection.State != System.Data.ConnectionState.Open)
                {
                    Console.WriteLine("Failed to open Database.Instance.Connection");
                    Console.ReadLine();
                    return;
                }
                Console.WriteLine("Connected to db");

                Account account;
                if (!Account.Authorize(account_name, password, out account))
                {
                    Console.WriteLine("Failed to authorize account");
                    account = new Account(account_name, 0, 1);
                    if (!account.Create(password))
                    {
                        Console.WriteLine("Failed to create account");
                        Console.ReadLine();
                        return;
                    }
                    else
                        Console.WriteLine("Created account");
                }
                Console.WriteLine("Authorized");
                Console.WriteLine(account.ToString());
                Console.WriteLine("10 gold given and saved");
                account.Gold += 10;
                account.Save();
                Console.WriteLine(account.ToString());

                Hero heroNew = new Hero("orior", 2, 1, 2, 1);
                if (!heroNew.Create(account.Id))
                    Console.WriteLine("Failed to create hero");
                else
                    Console.WriteLine("Hero created");

                List<Hero> heroList = account.GetHeroes();
                Console.WriteLine("{0} Heroes: ", heroList.Count);
                foreach (var hero in heroList)
                {
                    Console.WriteLine(hero);
                    hero.Experience += 10;
                    hero.Level += 1;
                    hero.Save();
                }

                Console.ReadLine();
            }
            finally
            {
                try { Database.Instance.Connection.Close(); } catch { }
            }
        }
コード例 #2
0
ファイル: Hero.cs プロジェクト: Dastano/D3SharpDatabase
 public static bool Load(int id, out Hero hero)
 {
     hero = null;
     SQLiteCommand command = new SQLiteCommand(string.Format("SELECT hero_id, hero_name, hero_class_id, hero_gender_id, hero_experience, hero_level FROM hero WHERE hero.hero_id='{0}'", id), Database.Instance.Connection);
     SQLiteDataReader reader = command.ExecuteReader();
     if (reader.HasRows)
     {
         while (reader.Read())
         {
             var hero_id = reader.GetInt32(0);
             var name = reader.GetString(1);
             var hero_class = reader.GetInt32(2);
             var gender = reader.GetInt32(3);
             var experience = reader.GetInt32(4);
             var level = reader.GetInt32(5);
             hero = new Hero(name, hero_class, gender, experience, level);
             hero.Id = hero_id;
             return true;
         }
     }
     return false;
 }
コード例 #3
0
ファイル: Program.cs プロジェクト: Badkore/D3SharpDatabase
        /// <summary>
        /// Handles the "create hero" command which creates a hero under the currently logged in account and saves it to the database.
        /// </summary>
        static void CommandCreateHero()
        {
            // check that user is logged in
            if (currentAccount == null)
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("Not logged in.");
                Console.ResetColor();
                return; // exit
            }

            // prompt for hero name
            Console.Write("Name: ");

            // read input
            string name = Console.ReadLine();

            // check that name doesn't contain numbers
            while (Regex.IsMatch(name, @"\d"))
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("Invalid name. Names cannot contain numbers.");
                Console.ResetColor();
                Console.Write("Name: ");
                name = Console.ReadLine();
            }

            while (name.Length < 3 || name.Length > 12)
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("Invalid name. Names must be between 3 and 12 characters inclusive.");
                Console.ResetColor();
                Console.Write("Name: ");
                name = Console.ReadLine();
            }

            // prompt for hero class
            Console.WriteLine("Hero Class:\n1: Wizard\n2: Witch Doctor\n3: Demon Hunter\n4: Monk\n5: Barbarian");

            // read input
            string heroClassString = Console.ReadLine();
            int heroClass;

            // check that input is a valid class id
            while (!int.TryParse(heroClassString, out heroClass) || heroClass > 5 || heroClass < 1)
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("Invalid class. Please choose a number.");
                Console.ResetColor();
                Console.WriteLine("Hero Class:\n1: Wizard\n2: Witch Doctor\n3: Demon Hunter\n4: Monk\n5: Barbarian");
                heroClassString = Console.ReadLine();
            }

            // prompt for gender
            Console.Write("Gender (male/female): ");

            int gender = 0;

            // check that gender is valid (1 or 2)
            while (gender == 0)
            {
                switch (Console.ReadLine().ToLower().Trim())
                {
                    case "male":
                    case "m":
                        gender = 1;
                        break;
                    case "female":
                    case "f":
                        gender = 2;
                        break;
                    default:
                        // red for errors
                        Console.ForegroundColor = ConsoleColor.Red;
                        Console.WriteLine("Invalid gender. Please choose male or female.");
                        // reset colour
                        Console.ResetColor();
                        Console.Write("Gender (male/female): ");
                        break;
                }
            }

            // prompt for hero level
            Console.Write("Level: ");

            // read input
            string levelString = Console.ReadLine();
            int level;

            // check that input is numeric
            while (!int.TryParse(levelString, out level))
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("Invalid level. Please choose a number.");
                Console.ResetColor();
                Console.Write("Level: ");
                levelString = Console.ReadLine();
            }

            // prompt for hero experience
            Console.Write("Experience: ");

            // read input
            string experienceString = Console.ReadLine();
            int experience;

            // check that input is numeric
            while (!int.TryParse(experienceString, out experience))
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("Invalid experience. Please choose a number.");
                Console.ResetColor();
                Console.Write("Experience: ");
                experienceString = Console.ReadLine();
            }

            // initialize hero object
            Hero hero = new Hero(currentAccount.Id, name, heroClass, gender, experience, level);

            // create hero
            if (hero.Create())
            {
                Console.Write("Hero ");
                Console.ForegroundColor = ConsoleColor.Green;
                Console.Write(name);
                Console.ResetColor();
                Console.WriteLine(" created.");
            }
            else // hero already exists
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("Hero with that name already exists");
                Console.ResetColor();
            }
        }
コード例 #4
0
ファイル: Hero.cs プロジェクト: Badkore/D3SharpDatabase
        /// <summary>
        /// Retrieves data for a specific hero from the database.
        /// </summary>
        /// <param name="id">The hero_id of the desired hero.</param>
        /// <param name="hero">Reference to an existing Hero instance where data will be stored on success.</param>
        /// <returns>True on success, otherwise false.</returns>
        public static bool Load(int id, out Hero hero)
        {
            // clear hero instance
            hero = null;

            // initialize SQL statement
            SQLiteCommand command = new SQLiteCommand(string.Format("SELECT hero_id, account_id, name, hero_class_id, hero_gender_id, experience, level FROM hero WHERE hero.hero_id='{0}'", id), Database.Instance.Connection);

            // execute SQL (retrieve hero data for the hero whose hero_id matches the input id
            SQLiteDataReader reader = command.ExecuteReader();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    // load data into hero instance
                    hero = new Hero(reader.GetInt32(1), reader.GetString(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetInt32(6));
                    // set hero id (not set by constructor)
                    hero.Id = reader.GetInt32(0);
                    return true;
                }
            }

            return false;
        }
コード例 #5
0
        static void CommandCreateHero()
        {
            if (currentAccount == null)
            {
                Console.WriteLine("not logged in");
                return;
            }
            Console.Write("Name: ");
            var name = Console.ReadLine();

            // Check if the hero name contains a number
            if (Regex.IsMatch(name, @"\d"))
            {
                while (Regex.IsMatch(name, @"\d"))
                {
                    Console.WriteLine("Invalid name - Names cannot contain a number.");
                    Console.Write("Name: ");
                    name = Console.ReadLine();
                }
            }
            Console.WriteLine("Hero Class:\n1: Wizard\n2: Witch Doctor\n3: Demon Hunter\n4: Monk\n5: Barbarian");
            var heroClassString = Console.ReadLine();
            int heroClass;
            if (!int.TryParse(heroClassString, out heroClass))
            {
                while (!int.TryParse(heroClassString, out heroClass))
                {
                    Console.WriteLine("Invalid class. Please choose a number.");
                    Console.WriteLine("Hero Class:\n1: Wizard\n2: Witch Doctor\n3: Demon Hunter\n4: Monk\n5: Barbarian");
                    heroClassString = Console.ReadLine();
                }
            }
            Console.Write("Gender (male/female): ");
            var gender = Console.ReadLine() == "male" ? 1 : 2;
            Console.Write("Level: ");
            var levelString = Console.ReadLine();
            Console.Write("Experience: ");
            var experienceString = Console.ReadLine();
            int level;
            int.TryParse(levelString, out level);
            int experience;
            int.TryParse(experienceString, out experience);

            var hero = new Hero(name, heroClass, gender, experience, level);
            if (hero.Create(currentAccount.Id))
                Console.WriteLine("Hero {0} created", name);
            else
                Console.WriteLine("Hero already exists");
        }
コード例 #6
0
ファイル: Program.cs プロジェクト: DarkLotus/D3SharpDatabase
        static void CommandCreateHero()
        {
            if (currentAccount == null)
            {
                Console.WriteLine("not logged in");
                return;
            }
            Console.Write("Name: ");
            var name = Console.ReadLine();
            Console.Write("Hero class 1-5: ");
            var heroClassString = Console.ReadLine();
            Console.Write("Gender (male/female): ");
            var gender = Console.ReadLine() == "male" ? 1 : 2;
            Console.Write("Level: ");
            var levelString = Console.ReadLine();
            Console.Write("Experience: ");
            var experienceString = Console.ReadLine();
            int heroClass;
            int.TryParse(heroClassString, out heroClass);

            int level;
            int.TryParse(levelString, out level);
            int experience;
            int.TryParse(experienceString, out experience);

            var hero = new Hero(name, heroClass, gender, experience, level);
            if (hero.Create(currentAccount.Id))
                Console.WriteLine("Hero {0} created", name);
            else
                Console.WriteLine("Hero already exists");
        }