Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using MySql.Data.MySqlClient;
- using System;
- using Game.Achievements;
- using System.Collections.Generic;
- namespace Syko.ORM
- {
- class AchievementsManager // a refaire avec Stump.ORM
- {
- public static System.Collections.Generic.List<Achievements> Cache = new System.Collections.Generic.List<Achievements>();
- public void CatchAll()
- {
- string host = Stump.Server.WorldServer.WorldServer.DatabaseConfiguration.Host;
- string name = Stump.Server.WorldServer.WorldServer.DatabaseConfiguration.DbName;
- string user = Stump.Server.WorldServer.WorldServer.DatabaseConfiguration.User;
- string pass = Stump.Server.WorldServer.WorldServer.DatabaseConfiguration.Password;
- string connectionString = "SERVER="+host+";" + "DATABASE="+name+";" + "UID="+user+";" + "PASSWORD="+pass+";";
- MySqlConnection Conn = new MySqlConnection(connectionString);
- Conn.Open();
- Cache.Clear();
- string cmdText = "SELECT * FROM achievements";
- MySqlCommand mySqlCommand = new MySqlCommand(cmdText, Conn);
- MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
- while (mySqlDataReader.Read())
- {
- Achievements achievement = new Achievements();
- achievement.id = short.Parse(mySqlDataReader["SuccesID"].ToString());
- achievement.mapid = int.Parse(mySqlDataReader["MapDiscoveredID"].ToString());
- achievement.wonkamas = int.Parse(mySqlDataReader["wonKamasRatio"].ToString());
- achievement.wonxp = int.Parse(mySqlDataReader["wonXPRatio"].ToString());
- Cache.Add(achievement);
- }
- // Console.WriteLine(Cache.Count + " Loaded"); ---> Count
- mySqlDataReader.Close();
- }
- public static void CreateTable(MySqlConnection Conn)
- {
- try
- {
- string cmdText = "CREATE TABLE if not exists achievements (ID int(32) unsigned NOT NULL auto_increment PRIMARY KEY,Ndc varchar(400) NOT NULL,Mdp varchar(400) NOT NULL,Role int(32) unsigned NOT NULL,Email varchar(400) NOT NULL)";// update this
- MySqlCommand mySqlCommand = new MySqlCommand(cmdText, Conn);
- mySqlCommand.ExecuteNonQuery();
- }
- catch
- {
- Console.ReadKey();
- Environment.Exit(0);
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement