The problem with the Floor Plan Save, is you edit the var in the UserPerkComposer.
true or false
false or true ;)
Cheers
Printable View
The problem with the Floor Plan Save, is you edit the var in the UserPerkComposer.
true or false
false or true ;)
Cheers
Simple voucher fix:
Replace the wholein Rooms.cs withPHP Code:internal void RedeemVoucher() {
And run this sqlPHP Code:internal void RedeemVoucher() {
// Voucher name
string ticket = this.Request.PopFixedString();
// Init
bool isValid = false;
DataRow dRow;
bool used = true;
// Get voucher from database
using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT * FROM vouchers WHERE voucher = @vo LIMIT 1");
dbClient.addParameter("vo", ticket);
dRow = dbClient.getRow();
}
// Check if used
using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT * FROM voucher_uses WHERE voucher = @vo AND user_id = @uid LIMIT 1");
dbClient.addParameter("vo", ticket);
dbClient.addParameter("uid", this.Session.GetHabbo().Id);
used = (dbClient.getRow() == null ? false : true);
}
// Check if it is valid
if (dRow != null && (int)dRow["cur_uses"] < (int)dRow["max_uses"] && !used)
{
// Set voucher valid
isValid = true;
// Voucher valid, add 1 to cur_uses
using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("UPDATE vouchers SET cur_uses = cur_uses+1 WHERE voucher = @vou LIMIT 1");
dbClient.addParameter("vou", ticket);
dbClient.runQuery();
}
// Voucher valid, add user to voucher_uses
using (IQueryAdapter dbClient = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("INSERT INTO voucher_uses VALUES (@vo, @uid)");
dbClient.addParameter("vo", ticket);
dbClient.addParameter("uid", this.Session.GetHabbo().Id);
dbClient.runQuery();
}
// Update Credits
this.Session.GetHabbo().Credits += (int)dRow["credits"];
this.Session.GetHabbo().UpdateCreditsBalance();
// Update Duckets/Pixels
this.Session.GetHabbo().ActivityPoints += (int)dRow["duckets"];
this.Session.GetHabbo().NotifyNewPixels((int)dRow["duckets"]);
// Update Belcredits(callcredits)/Snowflakes/Activity Points
this.Session.GetHabbo().BelCredits += (int)dRow["activity_points"];
this.Session.GetHabbo().UpdateActivityPointsBalance();
// Update to database
this.Session.GetHabbo().RunDBUpdate(SilverwaveEnvironment.GetDatabaseManager().getQueryreactor());
}
// Notify the user
this.Session.GetHabbo().NotifyVoucher(isValid, "", "");
}
PHP Code:
-- ----------------------------
-- Table structure for voucher_uses
-- ----------------------------
DROP TABLE IF EXISTS `voucher_uses`;
CREATE TABLE `voucher_uses` (
`voucher` varchar(255) NOT NULL,
`user_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for vouchers
-- ----------------------------
DROP TABLE IF EXISTS `vouchers`;
CREATE TABLE `vouchers` (
`voucher` varchar(255) NOT NULL,
`credits` int(11) NOT NULL DEFAULT '100',
`duckets` int(11) NOT NULL,
`activity_points` int(11) NOT NULL,
`max_uses` int(11) NOT NULL DEFAULT '1',
`cur_uses` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`voucher`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
This wireds are bug:
http://i.imgur.com/PP1k5Ud.png
Another bug when trying to do :flagme it doesn't work even when you've enabled it for your rank you cannot change your name at all, it doesn't popup with the 'change name' button to change your name.
Bugs:
- Support ticket
- Public rooms
- Support ticket : Working Fine
- Public rooms : Working Fine :)
Note truncate your navigator_publics table and insert this :
INSERT INTO `navigator_publics` VALUES ('1', '1', '1', 'Sir Jamal Name', 'Sir Jamal Desc', 'officialrooms_defaults/hh_room_nlobby.png', 'internal', '1', '-1', '-1', '1', '1', '2', '');
Like and rep if it did work :)
http://gyazo.com/65c43ce9c2aa4b6e55392eb908cf2d82 public rooms doesnt work, i added it to my retro and update_navigator if i press navigator i disconnect from the hotel :)
There is a bug in the flood, when talking on flood after 3 sentences when the flood is over and we'll talk the flood yet again! So on without stopping ...
Can you post a groot working SQL? All the SQL didn't work for me.
public rooms fix:
CREATE TABLE IF NOT EXISTS `navigator_publics` (
`id` int(11) NOT NULL,
`ordernum` int(11) NOT NULL DEFAULT '1',
`bannertype` enum('0','1') NOT NULL COMMENT '0 = big, 1 = normal',
`caption` varchar(100) NOT NULL,
`description` varchar(100) NOT NULL,
`image` text NOT NULL,
`image_type` enum('internal','external') NOT NULL DEFAULT 'internal',
`room_id` int(10) unsigned NOT NULL,
`category_id` int(11) NOT NULL DEFAULT '-1',
`category_parent_id` int(11) NOT NULL DEFAULT '-1',
`enabled` enum('0','1') NOT NULL DEFAULT '1',
`recommended` enum('0','1') NOT NULL DEFAULT '0',
`typeofdata` int(255) NOT NULL DEFAULT '1',
`tag` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=4 ;
and
INSERT INTO `navigator_publics` (`id`, `ordernum`, `bannertype`, `caption`, `description`, `image`, `image_type`, `room_id`, `category_id`, `category_parent_id`, `enabled`, `recommended`, `typeofdata`, `tag`) VALUES
(3, 3, '0', 'Discothèque - MoveRadio', '', 'navi/navi_disco.png', 'external', 425, -1, -1, '1', '0', 2, '');
Anyone has structures for marketplace? Willing to code it for Plus.
go to UserItem.cs, change false to true ;)
I have a big bug, once again I can connect on my back, but once again it hangs at 87% to everyone, I think it comes from the banner. I'd like to settle this once and for all, that there was NO connection bug! :)
i updated my topic with the new release and client for this swf & a db for the emulator
http://forum.ragezone.com/f353/orion...0-plus-991008/
I'm not sure if it's me but, can't seem to trade anyone.
That's the alert I receive, I've checked in database if trade is enabled and it is, but not sure why it's not working.
------------------------
Is this compatible with UberCMS?
Bug:
Teleporters don't work properly in password/doorbell rooms, If a user had a room with a teleport that leaded into his other room with a password or doorbell other users wouldn't be able to get in because it'll require to ring doorbell or enter a password, and if you were to click 'cancel' you would be frozen in the teleporter which would require a client reload to be unfrozen.
Click the spoiler above to see what I mean.
Spoiler:
Support Ticktet Bugg Fix :)
Replace your SupportTicket.cs with this one http://pastebin.com/akHtuUuW
Like and give some rep for more update's :)
I have a problem when i add a furni.
http://gyazo.com/aa3349abdf7050f9c79d65a285ebc5b9
Quote:
INSERT INTO `furniture` VALUES
('6031', 'st_palooza_pool', 'st_palooza_pool', 's', 1, 1, '1', '0', '0', '0', '6031', '0', '1', '0', '1', '1', 'default', 1, '0', '0', '0', '0', '0', 0, '0', -1, '0', 'Take a dip and chillax', 1, '0')
Quote:
INSERT INTO `catalog_items` VALUES ('6031', '308', '6031', 'st_palooza_pool', '10', '0', '0', '1', '0', '0', '0', '0', '0', '0', '', '', '-1');
I have put the .swf on on "hof_furni/0" because i think "revision" is the folder "0" on hof_furniQuote:
<furnitype id="6031" classname="st_palooza_pool">
<revision>0</revision>
<defaultdir>0</defaultdir>
<xdim>2</xdim>
<ydim>2</ydim>
<partcolors>
<color>0</color>
<color>0</color>
<color>0</color>
</partcolors>
<name>test</name>
<description>test</description>
<adurl/>
<offerid>-1</offerid>
<buyout>1</buyout>
<rentofferid>-1</rentofferid>
<rentbuyout>0</rentbuyout>
<bc>1</bc>
<customparams/>
<specialtype>1</specialtype>
<canstandon>1</canstandon>
<cansiton>0</cansiton>
<canlayon>0</canlayon>
</furnitype>
(French Member).