예제 #1
0
        public static int DBLookupID(OdbcConnection connection, String name, int version, Stage stage)
        {
            string lookupIDString = String.Format("SELECT id FROM Map WHERE name='{0}' AND version={1}", name, version);

            int id = -1;

            try
            {
                id = (int)DBExecuteScalar <long>(new OdbcCommand(lookupIDString, connection));
            }
            catch (KeyNotFoundException ex)
            {
                int mapStages = -1;
                if (stage != null)
                {
                    mapStages = stage.MapStages;
                }

                DBMap map = new DBMap(new Map {
                    Name = name, Version = version, Stages = mapStages
                });
                map.DBInsert(connection);
                id = map.Object.ID;
            }
            return(id);
        }
        public override void DBInsert(OdbcConnection connection)
        {
            new DBProfile(Object.Profile).DBInsert(connection, true);

            OdbcCommand cmd = new OdbcCommand(
                @"INSERT INTO GameInstance (id, profile, map, senderIP, startTime, endTime, dateReceived, timePlayed, nFrames, 
                    reason, endPosX, endPosY, endPosZ, hp, rage, ammunition, meleeWeapon, rangedWeapon, difficulty, gameVersion, 
                    stageNumber, stageHP, stageMaxHP, stageRage, stageTime, stageAmmo,
                    hitsTaken, damageDealt, damageTaken, timesNetted, nSlams, gbShots, totalShots, killedUnits) 
                  Values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);",
                connection);

            cmd.Parameters.Add("id", OdbcType.Binary, 16).Value         = Object.ID.ToByteArray();
            cmd.Parameters.Add("profile", OdbcType.Binary, 16).Value    = Object.Profile.ID.ToByteArray();
            cmd.Parameters.Add("map", OdbcType.Int).Value               = DBMap.DBLookupID(connection, Object.MapName, Object.MapVersion, Object.HighestStage);
            cmd.Parameters.Add("senderIP", OdbcType.VarChar, 20).Value  = Object.SenderIP ?? "";
            cmd.Parameters.Add("startTime", OdbcType.DateTime).Value    = Object.StartTime;
            cmd.Parameters.Add("endTime", OdbcType.DateTime).Value      = Object.EndTime;
            cmd.Parameters.Add("dateReceived", OdbcType.DateTime).Value = DateTime.Now;
            cmd.Parameters.Add("timePlayed", OdbcType.Decimal).Value    = Object.TimePlayed;
            cmd.Parameters.Add("nFrames", OdbcType.Int).Value           = Object.Frames;
            cmd.Parameters.Add("reason", OdbcType.VarChar, 100).Value   = Object.Reason ?? "";
            cmd.Parameters.Add("endPosX", OdbcType.Decimal).Value       = Object.EndPosX;
            cmd.Parameters.Add("endPosY", OdbcType.Decimal).Value       = Object.EndPosY;
            cmd.Parameters.Add("endPosZ", OdbcType.Decimal).Value       = Object.EndPosZ;
            cmd.Parameters.Add("hp", OdbcType.Int).Value                  = Object.Hitpoints;
            cmd.Parameters.Add("rage", OdbcType.Int).Value                = Object.Rage;
            cmd.Parameters.Add("ammunition", OdbcType.Int).Value          = Object.Ammunition;
            cmd.Parameters.Add("meleeWeapon", OdbcType.Int).Value         = Object.MeleeWeapon;
            cmd.Parameters.Add("rangedWeapon", OdbcType.Int).Value        = Object.RangedWeapon;
            cmd.Parameters.Add("difficulty", OdbcType.VarChar, 15).Value  = Object.Difficulty ?? "";
            cmd.Parameters.Add("gameVersion", OdbcType.VarChar, 30).Value = Object.GameVersion ?? "";

            var stage = Object.HighestStage;

            cmd.Parameters.Add("stageNumber", OdbcType.Int).Value   = stage != null ? stage.StageNumber : -1;
            cmd.Parameters.Add("stageHP", OdbcType.Int).Value       = stage != null ? stage.HitPoints : -1;
            cmd.Parameters.Add("stageMaxHP", OdbcType.Int).Value    = stage != null ? stage.MaxHitPoints : -1;
            cmd.Parameters.Add("stageRage", OdbcType.Int).Value     = stage != null ? stage.Rage : -1;
            cmd.Parameters.Add("stageTime", OdbcType.Decimal).Value = stage != null ? stage.Time : -1;
            cmd.Parameters.Add("stageAmmo", OdbcType.Int).Value     = stage != null ? stage.Ammo : -1;

            cmd.Parameters.Add("hitsTaken", OdbcType.Int).Value   = Object.HitsTaken;
            cmd.Parameters.Add("damageDealt", OdbcType.Int).Value = Object.DamageDealt;
            cmd.Parameters.Add("damageTaken", OdbcType.Int).Value = Object.DamageTaken;
            cmd.Parameters.Add("timesNetted", OdbcType.Int).Value = Object.TimesNetted;
            cmd.Parameters.Add("nSlams", OdbcType.Int).Value      = Object.NSlams;
            cmd.Parameters.Add("gbShots", OdbcType.Int).Value     = Object.GBShots;
            cmd.Parameters.Add("totalShots", OdbcType.Int).Value  = Object.TotalShots;
            cmd.Parameters.Add("killedUnits", OdbcType.Int).Value = Object.KilledUnits;

            PrintCommandString(cmd, 300);
            DBExecute(cmd);
        }