Good thing you recognized it :)
Printable View
Also :flagme doesn't work properly, It should show the 'Change Name' option when you click yourself.
:roomalert would be a great fix
My friend and I are trying to understand the Habbo structure from the scripts ;). He is only on vacation now so expect a fix soon ;)
http://i.imgur.com/6hMlCk9.png
Bugs :
When we want to buy a group it disconnects us, when one wants to wear it too
Good !
- - - Updated - - -
Bugs:
@jamal7
- Floor plan save.
- Ignore button.
- Public rooms.
- Forums for groups
- Add in the choice of staffs
- Crystals animations
- Freeze game
- Battle Banzai game
- Single Bundle page.
- coatings d/c
- Room Ads bug.
- From both bots and animals come in the apartment when we go.
- TV youtube bug a little, we can not add / view videos
- Talents achievements
- Voucher code in catalog
- Guide tool
It is not even being cached. - Being send to MySQL. And the queries are also bad.
http://cplus.about.com/od/glossar1/g/cache.htm
Take a look there, you will understand what Caching means.
Use this furnidata:
Code:<furnitype id="71000627" classname="horse_saddle1"><revision>45508</revision>
<defaultdir>0</defaultdir>
<xdim>1</xdim>
<ydim>1</ydim>
<partcolors/>
<name>Sela para Cavalo</name>
<description>Selas são necessárias para montar no seu cavalo</description>
<adurl></adurl>
<offerid>71000627</offerid>
<buyout>1</buyout>
<rentofferid>-1</rentofferid>
<rentbuyout>0</rentbuyout>
<bc>0</bc>
<customparams>15 4 9 0 77</customparams>
<specialtype>16</specialtype>
<canstandon>0</canstandon>
<cansiton>0</cansiton><
canlayon>0</canlayon>
</furnitype>
Users can walk through each other even when this is disabled. Does anyone know how to fix this as it ruins most event lines?
The only thing I hear is: cache, cache, cache...
You should cache the chatlogs and dump them to the db every hour with a timer. This can be done in batch-queries. Nothing to worry about.
Don't cache everything. Only data with huge database operations. And which is requested the most. RAM is faster, use it for the important data.
Happy coding [emoji106]
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