示例#1
0
        /// <summary>
        /// Generates the lottery dictionary values from database
        /// </summary>
        public static void Initialize()
        {
            BountyUsers.Clear();

            using (var dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
            {
                dbClient.SetQuery("SELECT * FROM `rp_bounties`");
                DataTable Table = dbClient.getTable();

                if (Table != null)
                {
                    foreach (DataRow Row in Table.Rows)
                    {
                        int    UserId          = Convert.ToInt32(Row["user_id"]);
                        int    AddedBy         = Convert.ToInt32(Row["added_by"]);
                        int    Reward          = Convert.ToInt32(Row["reward"]);
                        double TimeStamp       = Convert.ToDouble(Row["timestamp"]);
                        double ExpiryTimeStamp = Convert.ToDouble(Row["timestamp_expire"]);

                        Bounty Bounty = new Bounty(UserId, AddedBy, Reward, TimeStamp, ExpiryTimeStamp);

                        if (!BountyUsers.ContainsKey(UserId))
                        {
                            BountyUsers.TryAdd(UserId, Bounty);
                        }
                    }
                }
            }

            log.Info("Carregado " + BountyUsers.Count + " usuários com recompensa.");
        }
示例#2
0
        /// <summary>
        /// Adds the chosen client to the bounty
        /// </summary>
        /// <param name="New"></param>
        public static void AddBounty(Bounty New)
        {
            if (BountyUsers.ContainsKey(New.UserId))
            {
                return;
            }

            BountyUsers.TryAdd(New.UserId, New);

            using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor())
            {
                dbClient.SetQuery("INSERT INTO `rp_bounties` (`user_id`, `added_by`, `reward`, `timestamp`, `timestamp_expire`) VALUES (@userid, @addedby, @reward, @timestamp, @expirytimestamp)");
                dbClient.AddParameter("userid", New.UserId);
                dbClient.AddParameter("addedby", New.AddedBy);
                dbClient.AddParameter("reward", New.Reward);
                dbClient.AddParameter("timestamp", New.TimeStamp);
                dbClient.AddParameter("expirytimestamp", New.ExpiryTimeStamp);
                dbClient.RunQuery();
            }
        }