xHosts.uk - Windows & Linux VPS - Cosmic Guard
[VIP] Member
- Joined
- Sep 10, 2011
- Messages
- 857
- Reaction score
- 354
Hey
Its been mentioned to me many times, that people scam on hotels then use "flagme" to change name and hard for hotel owners to trace the scammers because they have changed the user names,
I came up with this idea only a small idea but may help some people in the community
Database
In your class258 / ChangeUserNameMessageEvent.cs
Under this :
Add this
Now each time a user uses flagme, the old name, new name and most importantly the users ID is stored with the date and time on which they change username.
Its been mentioned to me many times, that people scam on hotels then use "flagme" to change name and hard for hotel owners to trace the scammers because they have changed the user names,
I came up with this idea only a small idea but may help some people in the community
Database
CREATE TABLE IF NOT EXISTS `flagme_logs` (
`old_username` varchar(100) DEFAULT NULL,
`new_username` varchar(100) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`time` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
In your class258 / ChangeUserNameMessageEvent.cs
Under this :
class3.ExecuteQuery(string.Concat(new object[]
{
"UPDATE users SET username = '",
text,
"' WHERE id = '",
Session.GetHabbo().Id,
"' LIMIT 1"
}));
Add this
using (DatabaseClient @class = Phoenix.GetDatabase().GetClient())
{
@class.AddParamWithValue("old_username", Session.GetHabbo().Username);
@class.AddParamWithValue("new_username", text);
@class.AddParamWithValue("user_id", Session.GetHabbo().Id);
@class.ExecuteQuery("INSERT INTO flagme_logs SET old_username = @old_username, new_username = @new_username, user_id = @user_id");
}
Now each time a user uses flagme, the old name, new name and most importantly the users ID is stored with the date and time on which they change username.