internal void ReloadSubscription(int SubscriptionId, int DurationSeconds, Silverwave.HabboHotel.GameClients.GameClient Session)
{
IQueryAdapter adapter;
SubscriptionId = 1;
SilverwaveEnvironment.GetGame().GetAchievementManager().ProgressUserAchievement(Session, "ACH_VipClub", 1);
using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT * FROM user_subscriptions WHERE user_id=@id AND timestamp_expire > UNIX_TIMESTAMP() ORDER BY subscription_id DESC LIMIT 1");
dbClient.addParameter("id", UserId);
DataRow Row = dbClient.getRow();
if (Row == null)
{
int unixTimestamp = SilverwaveEnvironment.GetUnixTimestamp();
int timeExpire = SilverwaveEnvironment.GetUnixTimestamp() + DurationSeconds;
Subscription subscription2 = new Subscription(1, SubscriptionId, timeExpire);
using (adapter = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
adapter.setQuery(string.Concat(new object[] { "INSERT INTO user_subscriptions (user_id,subscription_id,timestamp_activated,timestamp_expire) VALUES (", this.UserId, ",'1',", unixTimestamp, ",", timeExpire, ")" }));
adapter.runQuery();
}
Subscription = new Subscription(1, SubscriptionId, SilverwaveEnvironment.GetUnixTimestamp() + DurationSeconds);
}
else
{
using (IQueryAdapter adapters = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
adapters.setQuery(string.Concat(new object[] { "UPDATE user_subscriptions SET timestamp_expire = ", Subscription.ExpireTime + DurationSeconds, " WHERE user_id = ", this.UserId, " AND subscription_id = '1'" }));
adapters.runQuery();
}
Subscription = new Subscription(1, SubscriptionId, Subscription.ExpireTime + DurationSeconds);
}
}
}
public WiredItem GenerateNewItem(Silverwave.HabboHotel.Items.RoomItem Item)
{
Console.WriteLine("Interaccion: "+Item.GetBaseItem().InteractionType);
switch (Item.GetBaseItem().InteractionType)
{
case InteractionType.triggerroomenter:
return new UserEntersRoom(Item, Room);
case InteractionType.triggeronusersay:
return new SaysKeyword(Item, Room);
case InteractionType.triggerrepeater:
return new Repeater(Item, Room);
case InteractionType.triggergamestart:
return new GameStarts(Item, Room);
case InteractionType.triggergameend:
return new GameEnds(Item, Room);
case InteractionType.triggerstatechanged:
return new FurniStateToggled(Item, Room);
case InteractionType.triggerwalkonfurni:
return new WalksOnFurni(Item, Room);
case InteractionType.triggerwalkofffurni:
return new WalksOffFurni(Item, Room);
case InteractionType.actionshowmessage:
return new ShowMessage(Item, Room);
case InteractionType.actionteleportto:
return new TeleportToFurni(Item, Room);
case InteractionType.actiontogglestate:
return new ToggleFurniState(Item, Room);
case InteractionType.actionmoverotate:
return new MoveRotateFurni(Item, Room);
case InteractionType.actionkickuser:
return new KickUser(Item, Room);
case InteractionType.conditionfurnishaveusers:
return new FurniHasUsers(Item, Room);
case InteractionType.conditionfurnihasfurni:
return new FurniHasFurni(Item, Room);
case InteractionType.conditiontriggeronfurni:
return new TriggererOnFurni(Item, Room);
case InteractionType.actionposreset:
return new PositionReset(Item, Room);
}
return null;
}
