[UBEREMU] Wordfilter 90%

Find:

Code:

---

  public void Chat(GameClient Session, string Message, bool Shout)
        {
            Unidle();

---

Add it:

Code:

---

DataTable Data2 = null;

                                  using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                                  {
                                      Data2 = dbClient.ReadDataTable("SELECT SQL_NO_CACHE * FROM wordfilter");
                                  }

                                  if (Data2 != null)
                                  {
                                      foreach (DataRow Row2 in Data2.Rows)
                                      {

                                          if (Message.Contains(Row2["word"].ToString()))
                                          {
                                           
                                              Message = "bobba";

                                          }

---

Sql:

Code:

---

CREATE TABLE `wordfilter` (
  `word` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

You can add rude words this table.

This code replace rude word -> bobba full clause.

Tested, working...

10%: Not caching words, If clause rude word filter replace full clause.

What is the other 10%?

EDIT : Nice :)

It looks nice, but what's the other 10%? xD

Quote:

---

Originally Posted by PEjump2

It looks nice, but what's the other 10%? xD

---

I think the other 10% is the words in the database, so you don't have to put them there by yourselve.. Maybe ..

thanks, needed this

Error
Fehler 1 } erwartet HabboHotel\Rooms\RoomUser.cs 274 10
:?:

Got this error.

Code:

---

Error        1        The type or namespace name 'DataTable' could not be found (are you missing a using directive or an assembly reference?)        C:\Users\keven\Desktop\YabMeer Emulator\HabboHotel\Rooms\RoomUser.cs        215        13        uberEmu

---

EDIT: I fixed the problem. Nice code btw.

I Think the code isn't perfect. Without the emu work perfect and when i insert it it a litte of bugging.

Dutch Srry.

So you're saying that if the rude word was "fuck", and I typed in "you stupid fuck head" it would replace the whole sentence as "bobba"?

Quote:

---

Originally Posted by Ubercheese

So you're saying that if the rude word was "fuck", and I typed in "you stupid fuck head" it would replace the whole sentence as "bobba"?

---

Probally, or It would just get the word's from the Table, 'fuck' and replace it with 'bobba'.

Good release anyway more to come from you. :ott1::thumbup:

Shout and say replace the word to bobba but whisper needs to be done.

Also if the word "fuck" was in the wordfilter a user could bypass it by just typeing "Fuck" with a capital f.

Quote:

---

Originally Posted by Ubercheese

Also if the word "fuck" was in the wordfilter a user could bypass it by just typeing "Fuck" with a capital f.

---

That is why you would put "fuck" "Fuck" "FUck" "FUCk" "fUck" fuCk" "fucK" and any other ways to spell "fuck" in the list of words to filter..

Quote:

---

Originally Posted by Hejula

That is why you would put "fuck" "Fuck" "FUck" "FUCk" "fUck" fuCk" "fucK" and any other ways to spell "fuck" in the list of words to filter..

---

Well then, it would turn in to a list of hundreds which won't be good if each time you talk, it selects if the texts contains the word in the database. Better off caching it on server start.

Quote:

---

Originally Posted by Hejula

That is why you would put "fuck" "Fuck" "FUck" "FUCk" "fUck" fuCk" "fucK" and any other ways to spell "fuck" in the list of words to filter..

---

Yea and that is gay! :laugh:

DataTable Data2 = null;

using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
Data2 = dbClient.ReadDataTable("SELECT SQL_NO_CACHE * FROM wordfilter");

if (Data2 != null)
foreach (DataRow Row2 in Data2.Rows)
Message = Message.Replace(Row2["word"].ToString().ToLower(), "bobba");

Quote:

---

Originally Posted by AWA

DataTable Data2 = null;

using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
Data2 = dbClient.ReadDataTable("SELECT SQL_NO_CACHE * FROM wordfilter");

if (Data2 != null)
foreach (DataRow Row2 in Data2.Rows)
Message = Message.Replace(Row2["word"].ToString().ToLower(), "bobba");

---

Works great, thank you ;-).

A two minute job in notepad.

Quote:

---

Originally Posted by keven007

Got this error.

Code:

---

Error        1        The type or namespace name 'DataTable' could not be found (are you missing a using directive or an assembly reference?)        C:\Users\keven\Desktop\YabMeer Emulator\HabboHotel\Rooms\RoomUser.cs        215        13        uberEmu

---

EDIT: I fixed the problem. Nice code btw.

---

I got that same problem

Quote:

---

Originally Posted by Maintenance

I got that same problem

---

place above the .cs file this:

Code:

---

using System.Data;

---

Quote:

---

Originally Posted by AWA

DataTable Data2 = null;

using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
Data2 = dbClient.ReadDataTable("SELECT SQL_NO_CACHE * FROM wordfilter");

if (Data2 != null)
foreach (DataRow Row2 in Data2.Rows)
Message = Message.Replace(Row2["word"].ToString().ToLower(), "bobba");

---

What did you changed AWA? :?:

Quote:

---

Originally Posted by DarkBreakX

What did you changed AWA? :?:

---

Cleaned up code a little + just replace the swearword with bobba, not the whole message.

AWA I get this error's.

Code:

---

Error        1        Expected class, delegate, enum, interface, or struct        C:\Users\keven\Desktop\YabMeer Emulator\HabboHotel\Rooms\RoomUser.cs        278        16        uberEmu
Error        2        Expected class, delegate, enum, interface, or struct        C:\Users\keven\Desktop\YabMeer Emulator\HabboHotel\Rooms\RoomUser.cs        306        16        uberEmu
Error        3        Expected class, delegate, enum, interface, or struct        C:\Users\keven\Desktop\YabMeer Emulator\HabboHotel\Rooms\RoomUser.cs        310        24        uberEmu
Error        4        Type or namespace definition, or end-of-file expected        C:\Users\keven\Desktop\YabMeer Emulator\HabboHotel\Rooms\RoomUser.cs        323        9        uberEmu

---

This is the compleet RoomUser.cs :

using System.Data;
using System;
using System.Collections.Generic;
using System.Text;

using Uber.Storage;
using Uber.Messages;
using Uber.HabboHotel.GameClients;
using Uber.HabboHotel.Pathfinding;
using Uber.HabboHotel.RoomBots;
using Uber.HabboHotel.Misc;
using Uber.HabboHotel.Pets;

namespace Uber.HabboHotel.Rooms
{
class RoomUser
{
public uint HabboId;
public int VirtualId;
public uint RoomId;

public int IdleTime;

public int X;
public int Y;
public double Z;

public int CarryItemID;
public int CarryTimer;

public int RotHead;
public int RotBody;

public bool CanWalk;
public bool AllowOverride;

public int GoalX;
public int GoalY;

public Boolean SetStep;
public int SetX;
public int SetY;
public double SetZ;

public RoomBot BotData;
public BotAI BotAI;

public Coord Coordinate
{
get
{
return new Coord(X, Y);
}
}

public bool IsPet
{
get
{
return (IsBot && BotData.IsPet);
}
}

public Pet PetData;

public Boolean IsWalking;
public Boolean UpdateNeeded;
public Boolean IsAsleep;

public Dictionary<string, string> Statusses;

public int DanceId;

public List<Coord> Path;
public int PathStep;

public bool PathRecalcNeeded;
public int PathRecalcX;
public int PathRecalcY;

public int TeleDelay;

public Boolean IsDancing
{
get
{
if (DanceId >= 1)
{
return true;
}

return false;
}
}

public Boolean NeedsAutokick
{
get
{
if (IsBot)
{
return false;
}

if (IdleTime >= 1800)
{
return true;
}

return false;
}
}

public bool IsTrading
{
get
{
if (IsBot)
{
return false;
}

if (Statusses.ContainsKey("trd"))
{
return true;
}

return false;
}
}

public bool IsBot
{
get
{
if (this.BotData != null)
{
return true;
}

return false;
}
}

public bool IsSpectator;

public RoomUser(uint HabboId, uint RoomId, int VirtualId)
{
this.HabboId = HabboId;
this.RoomId = RoomId;
this.VirtualId = VirtualId;
this.IdleTime = 0;
this.X = 0;
this.Y = 0;
this.Z = 0;
this.RotHead = 0;
this.RotBody = 0;
this.UpdateNeeded = true;
this.Statusses = new Dictionary<string, string>();
this.Path = new List<Coord>();
this.PathStep = 0;
this.TeleDelay = -1;

this.AllowOverride = false;
this.CanWalk = true;

this.IsSpectator = false;
}

public void Unidle()
{
this.IdleTime = 0;

if (this.IsAsleep)
{
this.IsAsleep = false;

ServerMessage Message = new ServerMessage(486);
Message.AppendInt32(VirtualId);
Message.AppendBoolean(false);

GetRoom().SendMessage(Message);
}
}

public void Chat(GameClient Session, string Message, bool Shout)
{
Unidle();

DataTable Data2 = null;

using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
Data2 = dbClient.ReadDataTable("SELECT SQL_NO_CACHE * FROM wordfilter");

if (Data2 != null)
foreach (DataRow Row2 in Data2.Rows)
Message = Message.Replace(Row2["word"].ToString().ToLower(), "bobba");

/* if (!IsBot)
{
if (GetClient().GetHabbo().NewbieStatus == 1)
{
if (Message == "Yes, I verify that I will only speak English in the hotel." || Message == "Yes, I verify that I will only speak English in the hotel")
{
GetClient().GetHabbo().NewbieStatus = 2;

using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
{
dbClient.ExecuteQuery("UPDATE users SET newbie_status = '2' WHERE id = '" + GetClient().GetHabbo().Id + "' LIMIT 1");
}

GetClient().SendNotif("Thank you. You can now use chat.");
return;
}
else
{
GetClient().SendNotif("We would like to urge that Uber is an English hotel. Before you are allowed to use chat, please verify you will speak English by typing \"Yes, I verify that I will only speak English in the hotel.\" in the chat. This is case-sensitive.");
return;
}
}
}*/

if (!IsBot && GetClient().GetHabbo().Muted)
{
GetClient().SendNotif("You are muted.");
return;
}

if (Message.StartsWith(":") && Session != null && ChatCommandHandler.Parse(Session, Message.Substring(1)))
{
return;
}

uint ChatHeader = 24;

if (Shout)
{
ChatHeader = 26;
}

ServerMessage ChatMessage = new ServerMessage(ChatHeader);
ChatMessage.AppendInt32(VirtualId);
ChatMessage.AppendStringWithBreak(Message);
ChatMessage.AppendInt32(GetSpeechEmotion(Message));

GetRoom().TurnHeads(X, Y, HabboId);
GetRoom().SendMessage(ChatMessage);

if (!IsBot)
{
GetRoom().OnUserSay(this, Message, Shout);
}

if (!IsBot)
{
using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
{
dbClient.AddParamWithValue("message", Message);
dbClient.ExecuteQuery("INSERT INTO chatlogs (user_id,room_id,hour,minute,timestamp,message,user_name,full_date) VALUES ('" + Session.GetHabbo().Id + "','" + GetRoom().RoomId + "','" + DateTime.Now.Hour + "','" + DateTime.Now.Minute + "','" + UberEnvironment.GetUnixTimestamp() + "',@message,'" + Session.GetHabbo().Username + "','" + DateTime.Now.ToLongDateString() + "')");
}
}
}

public int GetSpeechEmotion(string Message)
{
Message = Message.ToLower();

if (Message.Contains(":)") || Message.Contains(":d") || Message.Contains("=]") ||
Message.Contains("=d") || Message.Contains(":>"))
{
return 1;
}

if (Message.Contains(">:(") || Message.Contains(":@"))
{
return 2;
}

if (Message.Contains(":o"))
{
return 3;
}

if (Message.Contains(":(") || Message.Contains("=[") || Message.Contains(":'(") || Message.Contains("='["))
{
return 4;
}

return 0;
}

public void ClearMovement(bool Update)
{
IsWalking = false;
PathRecalcNeeded = false;
Path = new List<Coord>();
Statusses.Remove("mv");
GoalX = 0;
GoalY = 0;
SetStep = false;
SetX = 0;
SetY = 0;
SetZ = 0;

if (Update)
{
UpdateNeeded = true;
}
}

public void MoveTo(Coord c)
{
MoveTo(c.x, c.y);
}

public void MoveTo(int X, int Y)
{
Unidle();

PathRecalcNeeded = true;
PathRecalcX = X;
PathRecalcY = Y;
}

public void UnlockWalking()
{
this.AllowOverride = false;
this.CanWalk = true;
}

public void SetPos(int X, int Y, double Z)
{
this.X = X;
this.Y = Y;
this.Z = Z;
}

public void CarryItem(int Item)
{
this.CarryItemID = Item;

if (Item > 0)
{
this.CarryTimer = 240;
}
else
{
this.CarryTimer = 0;
}

ServerMessage Message = new ServerMessage(482);
Message.AppendInt32(VirtualId);
Message.AppendInt32(Item);
GetRoom().SendMessage(Message);
}

public void SetRot(int Rotation)
{
SetRot(Rotation, false);
}

public void SetRot(int Rotation, bool HeadOnly)
{
if (Statusses.ContainsKey("lay") || IsWalking)
{
return;
}

int diff = this.RotBody - Rotation;

this.RotHead = this.RotBody;

if (Statusses.ContainsKey("sit") || HeadOnly)
{
if (RotBody == 2 || RotBody == 4)
{
if (diff > 0)
{
RotHead = RotBody - 1;
}
else if (diff < 0)
{
RotHead = RotBody + 1;
}
}
else if (RotBody == 0 || RotBody == 6)
{
if (diff > 0)
{
RotHead = RotBody - 1;
}
else if (diff < 0)
{
RotHead = RotBody + 1;
}
}
}
else if (diff <= -2 || diff >= 2)
{
this.RotHead = Rotation;
this.RotBody = Rotation;
}
else
{
this.RotHead = Rotation;
}

this.UpdateNeeded = true;
}

public void AddStatus(string Key, string Value)
{
Statusses[Key] = Value;
}

public void RemoveStatus(string Key)
{
if (Statusses.ContainsKey(Key))
{
Statusses.Remove(Key);
}
}

public void ResetStatus()
{
Statusses = new Dictionary<string, string>();
}

public void Serialize(ServerMessage Message)
{
// @\Ihqu@UMeth0d13haiihr-893-45.hd-180-8.ch-875-62.lg-280-62.sh-290-62.ca-1813-.he-1601-[IMRAPD4.0JImMcIrDK
// MSadiePull up a pew and have a brew!hr-500-45.hd-600-1.ch-823-75.lg-716-76.sh-730-62.he-1602-75IRBPA2.0PAK

if (IsSpectator)
{
return;
}

if (!IsBot)
{
Message.AppendUInt(GetClient().GetHabbo().Id);
Message.AppendStringWithBreak(GetClient().GetHabbo().Username);
Message.AppendStringWithBreak(GetClient().GetHabbo().Motto);
Message.AppendStringWithBreak(GetClient().GetHabbo().Look);
Message.AppendInt32(VirtualId);
Message.AppendInt32(X);
Message.AppendInt32(Y);
Message.AppendStringWithBreak(Z.ToString().Replace(',', '.'));
Message.AppendInt32(2);
Message.AppendInt32(1);
Message.AppendStringWithBreak(GetClient().GetHabbo().Gender.ToLower());
Message.AppendInt32(-1);
Message.AppendInt32(-1);
Message.AppendInt32(-1);
Message.AppendStringWithBreak("");
}
else
{
//btmFZoef0 008 D98961JRBQA0.0PAJH

Message.AppendInt32(BotAI.BaseId);
Message.AppendStringWithBreak(BotData.Name);
Message.AppendStringWithBreak(BotData.Motto);
Message.AppendStringWithBreak(BotData.Look);
Message.AppendInt32(VirtualId);
Message.AppendInt32(X);
Message.AppendInt32(Y);
Message.AppendStringWithBreak(Z.ToString().Replace(',', '.'));
Message.AppendInt32(4);
Message.AppendInt32((BotData.AiType.ToLower() == "pet") ? 2 : 3);

if (BotData.AiType.ToLower() == "pet")
{
Message.AppendInt32(0);
}
}
}

public void SerializeStatus(ServerMessage Message)
{
if (IsSpectator)
{
return;
}

Message.AppendInt32(VirtualId);
Message.AppendInt32(X);
Message.AppendInt32(Y);
Message.AppendStringWithBreak(Z.ToString().Replace(',','.'));
Message.AppendInt32(RotHead);
Message.AppendInt32(RotBody);
Message.AppendString("/");

foreach (KeyValuePair<string, string> Status in Statusses)
{
Message.AppendString(Status.Key);
Message.AppendString(" ");
Message.AppendString(Status.Value);
Message.AppendString("/");
}

Message.AppendStringWithBreak("/");
}

public GameClient GetClient()
{
if (IsBot)
{
return null;
}

return UberEnvironment.GetGame().GetClientManager().GetClientByHabbo(HabboId);
}

private Room GetRoom()
{
return UberEnvironment.GetGame().GetRoomManager().GetRoom(RoomId);
}
}
}

Quote:

---

Originally Posted by keven007

Got this error.

Code:

---

Error        1        The type or namespace name 'DataTable' could not be found (are you missing a using directive or an assembly reference?)        C:\Users\keven\Desktop\YabMeer Emulator\HabboHotel\Rooms\RoomUser.cs        215        13        uberEmu

---

EDIT: I fixed the problem. Nice code btw.

---

I Got the same error.. can you gimme the code for you fixed? :-):thumbup:


EDIT: I fixed it myself ;)

Can anyone help me make this work with Blah's emulator?

How could I change the word "bobba" to another word?

yes is work witsh spazz emu or Blah's Emulator?

Your attempt at a filter runs a MySQL query every single time someone talks, enjoy your MySQL rape.

If you want to do it properly then load the filtered words on bootup and cache them, then check against the cache rather than running a MySQL query each time cos on a big hotel this will seriously rape CPU for MySQL.

or you make mysql Cache higher :P

Quote:

---

Originally Posted by SkyHacker

or you make mysql Cache higher :P

---

Why bother using MySQL at all, 1 query on bootup is better than 100 queries/ second no matter how you look at it.

Still good but, on KM there is a better Bobba Filer that you can configure in config like on and replace word etc. Word you can do in config. I will release it soon here.

i have the code on off is easy ^^

if you wana cache them make a 'dictionary' (C#) and do 2 fields (MySQL DB) 'to_filter' and 'filter_with' then for filter_with the default could be 'bobba' so it auto uses bobba when someone adds a word, then just load all the words into the 'dictionary' at start up, ta-da cached filter.

Quote:

---

Originally Posted by Sojobo

Why bother using MySQL at all, 1 query on bootup is better than 100 queries/ second no matter how you look at it.

---

The only time Aaron's ever said anything intelligent? -gasp- but wait caching has been done for ages now everyone knows this.

Even more advanced:

Code:

---

                DataTable Data2 = null;

                using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                {
                    Data2 = dbClient.ReadDataTable("SELECT SQL_NO_CACHE * FROM wordfilter");
                }

                if (Data2 != null)
                {
                    foreach (DataRow Row2 in Data2.Rows)
                    {
                        string Lowered = Message.ToLower();
                        Lowered = Lowered.Replace(" ", "");
                        Lowered = Lowered.Replace("´", "");
                        Lowered = Lowered.Replace("`", "");
                        Lowered = Lowered.Replace("^", "");
                        Lowered = Lowered.Replace("*", "");
                        Lowered = Lowered.Replace("'", "");
                        Lowered = Lowered.Replace("-", "");
                        if (Lowered.Contains(Row2["word"].ToString()))
                        {

                            Message = "**** The Super Hotel spam filter has blocked this text! ****";
                            GetClient().SendNotif("You have swore or have been classified as a spammer. \nYou have now been muted for 30 seconds!");
                            ServerMessage Packet = new ServerMessage(27);
                            Packet.AppendInt32(30); //Blocked for 1 Minute
                            GetClient().SendMessage(Packet);

                        }
                        //}
                    }

---

Now this will check for FuCK or Fuck or FuCK or F-U-CK or F*ck or F-ck or F uck or F'ck
And will also mute them for 30 seconds!

nom nom nom nom nom nom nom, nub don't bump.