Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
RomualdGaming
PHP Code:
INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `min_sub`, `page_text_details`, `page_text_teaser`, `vip_only`, `page_link_description`, `page_link_pagename`) VALUES ('7', '5', 'Habbo Club Kopen', '0', '172', '1', '1', '1', '0', '1', 'default_3x3', 'habboclub1', 'hc-6', ' ', '', ' ', '0', 'Klik op een meubel voor meer informatie', ' ', '0', '', '');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_duckets`, `amount`, `vip`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `flat_id`, `allow_present`) VALUES ('7002120', '7', '20060', 'HABBO_CLUB_VIP_7_DAY', '15', '0', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '-1', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_duckets`, `amount`, `vip`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `flat_id`, `allow_present`) VALUES ('7002118', '7', '20060', 'HABBO_CLUB_VIP_1_MONTH', '100', '0', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '-1', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_duckets`, `amount`, `vip`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `flat_id`, `allow_present`) VALUES ('7002119', '7', '20060', 'HABBO_CLUB_VIP_14_DAY', '25', '0', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '-1', '1');
INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `is_arrow`, `foot_figure`, `stack_multiplier`, `subscriber`, `effectid`, `height_adjustable`, `flat_id`, `revision`, `description`, `specialtype`, `canlayon`) VALUES ('20060', 'DEAL_HC_1', 'DEAL_HC_1', 'h', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '49500', '', '1', '0');
A like or Rep is always welcome <3
Note : Use the next time the help section ;)
Re: New Structure - PlusR2 [Updated]
I know this is not an help thread but i need to fix this http://gyazo.com/f10cb7192d4766bf8cec3333b962e33a , How can i fix the dc problem?
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
Jamal7
PHP Code:
INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `min_sub`, `page_text_details`, `page_text_teaser`, `vip_only`, `page_link_description`, `page_link_pagename`) VALUES ('7', '5', 'Habbo Club Kopen', '0', '172', '1', '1', '1', '0', '1', 'default_3x3', 'habboclub1', 'hc-6', ' ', '', ' ', '0', 'Klik op een meubel voor meer informatie', ' ', '0', '', '');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_duckets`, `amount`, `vip`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `flat_id`, `allow_present`) VALUES ('7002120', '7', '20060', 'HABBO_CLUB_VIP_7_DAY', '15', '0', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '-1', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_duckets`, `amount`, `vip`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `flat_id`, `allow_present`) VALUES ('7002118', '7', '20060', 'HABBO_CLUB_VIP_1_MONTH', '100', '0', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '-1', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_duckets`, `amount`, `vip`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `flat_id`, `allow_present`) VALUES ('7002119', '7', '20060', 'HABBO_CLUB_VIP_14_DAY', '25', '0', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '-1', '1');
INSERT INTO `furniture` (`id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `is_arrow`, `foot_figure`, `stack_multiplier`, `subscriber`, `effectid`, `height_adjustable`, `flat_id`, `revision`, `description`, `specialtype`, `canlayon`) VALUES ('20060', 'DEAL_HC_1', 'DEAL_HC_1', 'h', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '49500', '', '1', '0');
A like or Rep is always welcome <3
Note : Use the next time the help section ;)
Hi,
I get this error when I buy the HC
http://img4.hostingpics.net/pics/164257Sanstitre.png
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
dracau18
mabe not use default3x3 but the hc buy page
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
jordynegen11
mabe not use default3x3 but the hc buy page
I edit the page of catalogue and I put club_buy
but it's empty http://img11.hostingpics.net/pics/502293Sanstitre.png
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
dracau18
Add a case "h"
Find
Add
PHP Code:
case "h": //HC type :p
return;
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
Jeanzinh0
Add a case "h"
Find
Add
PHP Code:
case "h": //HC type :p
return;
Sorry ^^ but in what .cs file?
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
dracau18
Sorry ^^ but in what .cs file?
catalog.cs
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
Damien Jolly
catalog.cs
Thank but now I can buy the HC but no days are add.
http://img11.hostingpics.net/pics/985207Sanstitre.png
Re: New Structure - PlusR2 [Updated]
HabboHotel/Users/Subscriptions/SubscriptionManager.cs
Find:
PHP Code:
internal void ReloadSubscription
Replace:
PHP Code:
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);
}
}
}
Credits to @Jeanzinh0 though.
Give him some love +rep
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
Damien Jolly
HabboHotel/Users/Subscriptions/SubscriptionManager.cs
Find:
PHP Code:
internal void ReloadSubscription
Replace:
PHP Code:
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);
}
}
}
Credits to @
Jeanzinh0 though.
Give him some love +rep
I have an error in MusSocket.cs
http://img11.hostingpics.net/pics/115912Sanstitre.png
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
dracau18
Me too i have that problem. :'(
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
dracau18
Messages/Net/MusSocket.cs
Find:
PHP Code:
case "updatesubscription":
Replace:
PHP Code:
case "updatesubscription":
{
uint UserId = Convert.ToUInt32(Params[0]);
int DurationSeconds = Convert.ToInt32(Params[1]);
Client = SilverwaveEnvironment.GetGame().GetClientManager().GetClientByUserID(UserId);
if (Client != null && Client.GetHabbo() != null)
{
Client.GetHabbo().GetSubscriptionManager().ReloadSubscription(1, DurationSeconds, Client);
Client.GetHabbo().SerializeClub();
Client.SendMessage(new ServerMessage(Outgoing.UpdateShop));
}
break;
}
Still credits to @Jeanzinh0 though :D
Re: New Structure - PlusR2 [Updated]
Re: New Structure - PlusR2 [Updated]
Quote:
Originally Posted by
Damien Jolly
Messages/Net/MusSocket.cs
Find:
PHP Code:
case "updatesubscription":
Replace:
PHP Code:
case "updatesubscription":
{
uint UserId = Convert.ToUInt32(Params[0]);
int DurationSeconds = Convert.ToInt32(Params[1]);
Client = SilverwaveEnvironment.GetGame().GetClientManager().GetClientByUserID(UserId);
if (Client != null && Client.GetHabbo() != null)
{
Client.GetHabbo().GetSubscriptionManager().ReloadSubscription(1, DurationSeconds, Client);
Client.GetHabbo().SerializeClub();
Client.SendMessage(new ServerMessage(Outgoing.UpdateShop));
}
break;
}
Still credits to @
Jeanzinh0 though :D
Now that's good, but i don't view the page for HC CLUB, is like http://img11.hostingpics.net/pics/502293Sanstitre.png
And i have an error with that :
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_duckets`, `amount`, `vip`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `flat_id`, `allow_present`) VALUES ('7002120', '7', '20060', 'HABBO_CLUB_VIP_7_DAY', '15', '0', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '-1', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_duckets`, `amount`, `vip`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `flat_id`, `allow_present`) VALUES ('7002118', '7', '20060', 'HABBO_CLUB_VIP_1_MONTH', '100', '0', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '-1', '1');
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_duckets`, `amount`, `vip`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `extradata`, `badge`, `flat_id`, `allow_present`) VALUES ('7002119', '7', '20060', 'HABBO_CLUB_VIP_14_DAY', '25', '0', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '-1', '1');
In my emulator I don't have allow_presents.
Help :'(
