Hablux Emulator Blog

string VOUCHER_TYPE = null;
            using (DatabaseClient MySQL = HABLUXENVIRONMENT.GetDatabase().GetClient())
            {
                int Value = GetVoucherValue(Code);




                MySQL.AddParamWithValue("value", Value);
                MySQL.AddParamWithValue("id", Session.GetHabbo().Id);
                MySQL.AddParamWithValue("code", Code);
                VOUCHER_TYPE = MySQL.query_string("SELECT type FROM credit_vouchers WHERE code = @code LIMIT 1");




                int A_COUNT = 0;




                foreach (string TYPE in VOUCHER_TYPE.Split(';'))
                {


                    switch (TYPE.ToLower())
                    {
                        case "credits":


                            A_COUNT++;


                            MySQL.query("UPDATE users SET credits = credits+@value WHERE id = @id");
                            TryDeleteVoucher(Code);
                            Session.GetHabbo().Credits += Value;
                            Session.GetHabbo().UpdateCreditsBalance();


                            if (A_COUNT.Equals(1))
                                Session.SendMessage(new ServerMessage(212));

                            break;


                        case "pixels":


                            A_COUNT++;


                            MySQL.query("UPDATE users SET activity_points = activity_points+@value WHERE id = @id");
                            TryDeleteVoucher(Code);
                            Session.GetHabbo().ActivityPoints += Value;
                            Session.GetHabbo().UpdateActivityPointsBalance(true);


                            if (A_COUNT.Equals(1))
                                Session.SendMessage(new ServerMessage(212));


                            break;


                        case "vip":


                            A_COUNT++;


                            MySQL.query("UPDATE users SET vip_points = vip_points+@value WHERE id = @id");
                            TryDeleteVoucher(Code);
                            Session.GetHabbo().UpdateCreditsBalance();


                            if (A_COUNT.Equals(1))
                                Session.SendMessage(new ServerMessage(212));


                            break;


                        default:
                            Session.SendNotif(CACHE.CACHE_TEXTS["voucher_code_type_invalid"]);
                            break;
                    }
                }


            }