Exemplo n.º 1
0
 public static bool giveUser(ref DataContainer cont, long I_Id)
 {
     UnreadableSQLExecuter exec = new UnreadableSQLExecuter();
     exec.query = "update `BelongsTo` set Amount=Amount+1 where I_Id=? and C_Id=?";
     exec.add_parameter(I_Id);
     exec.add_parameter(cont.c_data.C_Id);
     exec.execute_query();
     if (exec.error)
     {
         Console.WriteLine(exec.error_string);
         return false;
     }
     if (exec.rows_affected == 0)
     {
         exec = new UnreadableSQLExecuter();
         exec.query = "insert into `BelongsTo` (I_Id,C_Id,Amount,Equipped) values (?,?,1,0)";
         exec.add_parameter(I_Id);
         exec.add_parameter(cont.c_data.C_Id);
         exec.execute_query();
         if (exec.error)
         {
             Console.WriteLine(exec.error_string);
             return false;
         }
     }
     cont.c_data.calculateItemStats();
     return true;
 }
Exemplo n.º 2
0
        public static Monster getMonsterByName(ref DataContainer cont, string monstername)
        {
            Monster to_return;
            ReadableSQLExecuter exec = new ReadableSQLExecuter();
            // load monster attributes
            exec.query = "select `Monster`.M_Id from Monster, MonsterIsIn as MIIn where `Monster`.M_Id=MIIn.M_Id and MIIn.RespawnAtTime < NOW() and MIIn.R_Id=? and `Monster`.Name=?";
            exec.add_parameter(cont.r_data.R_Id);
            exec.add_parameter(monstername);
            exec.execute_query();
            if (exec.error)
            {
                Console.WriteLine(exec.error_string);
                return null;
            }
            if (!exec.HasRows) // no monster with this name
            {
                Console.WriteLine("No monster " + monstername);
                return null;
            }

            long M_Id = Convert.ToInt64(exec.result[0][0]);
            to_return = new Monster(ref cont, M_Id);

            return to_return;
        }
Exemplo n.º 3
0
 public CharacterData(ref DataContainer cont,long CharacterId)
 {
     this.container = cont;
     this.C_Id = CharacterId;
     loadAttributes();
     calculateBuffs();
     calculateItemStats();
     Console.WriteLine(C_Id);
 }
Exemplo n.º 4
0
        public GameLoopDialogue(UserDialogue.WriteMethod write,long C_Id)
        {
            this.write = write;
            this.C_Id = C_Id;

            container = new DataContainer();
            container.c_data = new CharacterData(ref container, C_Id);
            container.r_data = new Room(ref container);

            c_engine = new CommandEngine(write, container);
            writeStartMessage();
        }
Exemplo n.º 5
0
 public static GameObject getObjectByName(ref DataContainer cont, string objectName)
 {
     ReadableSQLExecuter sql = new ReadableSQLExecuter();
     sql.query = "select `Objekt`.O_Id from `Objekt`,`ObjInRoom` where `Objekt`.O_Id=`ObjInRoom`.O_Id and `ObjInRoom`.R_Id=? and `Objekt`.O_Id not in (select O_Id from `Takeable` where R_Id=? and not Takefrom='') and `Objekt`.Name=?";
     sql.add_parameter(cont.r_data.R_Id);
     sql.add_parameter(cont.r_data.R_Id);
     sql.add_parameter(objectName);
     sql.execute_query();
     if (sql.error)
     {
         Console.WriteLine(sql.error_string);
         return null;
     }
     if (!sql.HasRows)
     {
         return null;
     }
     return new GameObject(ref cont,Convert.ToInt64(sql.result[0][0]));
 }
Exemplo n.º 6
0
 public static TakeableGameObject getObjectByName(ref DataContainer cont, string objectName,string object_in)
 {
     ReadableSQLExecuter sql = new ReadableSQLExecuter();
     sql.query = "select O_Id from `Objekt` where `Objekt`.O_Id in (select O_Id from `Takeable` where R_Id=? and Takefrom=? and RespawnAtTime<NOW()) and `Objekt`.Name=?";
     sql.add_parameter(cont.r_data.R_Id);
     sql.add_parameter(object_in);
     sql.add_parameter(objectName);
     sql.execute_query();
     if (sql.error)
     {
         Console.WriteLine(sql.error_string);
         return null;
     }
     if (!sql.HasRows)
     {
         return null;
     }
     return new TakeableGameObject(ref cont, Convert.ToInt64(sql.result[0][0]));
 }
Exemplo n.º 7
0
        public static Item getItemByName(ref DataContainer cont, string name)
        {
            ReadableSQLExecuter exec = new ReadableSQLExecuter();
            exec.query = "select `Item`.I_Id from `Item`,`BelongsTo` where `Item`.I_Id=`BelongsTo`.I_Id and `BelongsTo`.C_Id=? and `Item`.Name=?";
            exec.add_parameter(cont.c_data.C_Id);
            exec.add_parameter(name);
            exec.execute_query();
            if (exec.error)
            {
                Console.WriteLine(exec.error_string);
                return null;
            }
            if (!exec.HasRows)
            {
                return null;
            }

            return new Item(ref cont, Convert.ToInt64(exec.result[0][0]));
        }
Exemplo n.º 8
0
 public static List<Monster> loadMonsters(ref DataContainer cont)
 {
     List<Monster> monsters = new List<Monster>();
     ReadableSQLExecuter exec = new ReadableSQLExecuter();
     exec.query = "select M_Id from MonsterIsIn where RespawnAtTime<NOW() and  R_Id=?";
     exec.add_parameter(cont.r_data.R_Id);
     exec.execute_query();
     if (exec.error)
     {
         Console.WriteLine(exec.error_string);
         return null;
     }
     if (!exec.HasRows)
     {
         return null;
     }
     foreach (object[] tmp in exec.result)
     {
         long id = Convert.ToInt64(tmp[0]);
         monsters.Add(new Monster(ref cont, id));
     }
     return monsters;
 }
Exemplo n.º 9
0
 public static List<Item> loadItems(ref DataContainer cont)
 {
     List<Item> items = new List<Item>();
     ReadableSQLExecuter exec = new ReadableSQLExecuter();
     exec.query = "select I_Id from BelongsTo where C_Id=?";
     exec.add_parameter(cont.c_data.C_Id);
     exec.execute_query();
     if (exec.error)
     {
         Console.WriteLine(exec.error_string);
         return null;
     }
     if (!exec.HasRows)
     {
         return null;
     }
     foreach (object[] tmp in exec.result)
     {
         long id = Convert.ToInt64(tmp[0]);
         items.Add(new Item(ref cont, id));
     }
     return items;
 }
Exemplo n.º 10
0
 public Benutzen(UserDialogue.WriteMethod write ,DataContainer cont)
 {
     this.write = write;
     this.container = cont;
 }
Exemplo n.º 11
0
 public Statistiken(UserDialogue.WriteMethod write, DataContainer cont)
 {
     this.write = write;
     this.container = cont;
 }
Exemplo n.º 12
0
 public Room(ref DataContainer cont)
 {
     this.container = cont;
     loadAttributes();
 }
Exemplo n.º 13
0
 public GameObject(ref DataContainer cont,long objectId)
 {
     this.O_Id = objectId;
     this.container = cont;
     loadAttributes();
 }
Exemplo n.º 14
0
 public Monster(ref DataContainer cont, long M_Id)
 {
     this.container = cont;
     this.M_Id = M_Id;
     loadAttributes();
 }
Exemplo n.º 15
0
 public static TakeableGameObject getObjectByName(ref DataContainer cont, string objectName)
 {
     return getObjectByName(ref cont, objectName, "");
 }
Exemplo n.º 16
0
 public Item(ref DataContainer cont, long I_Id)
 {
     this.container = cont;
     this.I_Id = I_Id;
     loadAttributes();
 }