[SERVICE] - Coding Commands

[Jiozx]

The source has been releassed

Oh right, but only the source for Phoenix 3.11, I guess.

 

[Power]

DarkPower, I want to almost beg you to help me with something, haha

The empty command only deletes furniture from the items_users table, while it should also delete it from the items table. I found out that this is the only way the traxplayer won't start to bug after you delete some trax CDs and buy some new ones.

The empty command makes use of

internal void ClearItems()
{
    using (IQueryAdapter adapter = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
    {
        adapter.runFastQuery("DELETE FROM items_users WHERE user_id = " + this.UserId);
    }


    this.mAddedItems.Clear();
    this.mRemovedItems.Clear();
    this.floorItems.Clear();
    this.wallItems.Clear();
    this.discs.Clear();
    this.isUpdated = true;
    this.mClient.GetMessageHandler().GetResponse().Init(Outgoing.UpdateInventary);
    this.GetClient().GetMessageHandler().SendResponse();
}

But I really don't know how to get the deleted ids and also delete those from the items table.

Emu?

 

[ImNotSatan]

Emu?

Baashotel uses SwiftEmu

 

[Power]

DarkPower, I want to almost beg you to help me with something, haha

The empty command only deletes furniture from the items_users table, while it should also delete it from the items table. I found out that this is the only way the traxplayer won't start to bug after you delete some trax CDs and buy some new ones.

The empty command makes use of

internal void ClearItems()
{
    using (IQueryAdapter adapter = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
    {
        adapter.runFastQuery("DELETE FROM items_users WHERE user_id = " + this.UserId);
    }


    this.mAddedItems.Clear();
    this.mRemovedItems.Clear();
    this.floorItems.Clear();
    this.wallItems.Clear();
    this.discs.Clear();
    this.isUpdated = true;
    this.mClient.GetMessageHandler().GetResponse().Init(Outgoing.UpdateInventary);
    this.GetClient().GetMessageHandler().SendResponse();
}

But I really don't know how to get the deleted ids and also delete those from the items table.

i could do this as a command but it might lagg, depening on how many items the user has, i can code you somthing in php? for housekeeping which would be more effective

 

[Bjork]

DarkPower, I want to almost beg you to help me with something, haha

The empty command only deletes furniture from the items_users table, while it should also delete it from the items table. I found out that this is the only way the traxplayer won't start to bug after you delete some trax CDs and buy some new ones.

The empty command makes use of

internal void ClearItems()
{
    using (IQueryAdapter adapter = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
    {
        adapter.runFastQuery("DELETE FROM items_users WHERE user_id = " + this.UserId);
    }


    this.mAddedItems.Clear();
    this.mRemovedItems.Clear();
    this.floorItems.Clear();
    this.wallItems.Clear();
    this.discs.Clear();
    this.isUpdated = true;
    this.mClient.GetMessageHandler().GetResponse().Init(Outgoing.UpdateInventary);
    this.GetClient().GetMessageHandler().SendResponse();
}

But I really don't know how to get the deleted ids and also delete those from the items table.

Use JOIN query like:

dbClient.runFastQuery("DELETE items, items_extradata, items_users " +
                                             "FROM items_users " +
                                             "INNER JOIN items ON (items.item_id = items_users.item_id) " +
                                             "LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id) " +
                                             "WHERE items_users.user_id = " + UserId);

Not tested, but that's the idea.

 

[Power]

Use JOIN query like:

dbClient.runFastQuery("DELETE items, items_extradata, items_users " +
                                             "FROM items_users " +
                                             "INNER JOIN items ON (items.item_id = items_users.item_id) " +
                                             "LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id) " +
                                             "WHERE items_users.user_id = " + UserId);

Not tested, but that's the idea.

Brilliant idea! never thought about a join query!
learn something new everyday!

 

[The General]

Brilliant idea! never thought about a join query!
learn something new everyday!

Learn some SQL. There is a lot you can do that comes in handy one day.

 

[Gaby]

Use JOIN query like:

dbClient.runFastQuery("DELETE items, items_extradata, items_users " +
                                             "FROM items_users " +
                                             "INNER JOIN items ON (items.item_id = items_users.item_id) " +
                                             "LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id) " +
                                             "WHERE items_users.user_id = " + UserId);

Not tested, but that's the idea.

Oh that's brilliant, thank you! I'll be trying it out.

EDIT:
It works like a charm!

 

[Droppy]

The source has been releassed

Deobfuscated anyway... Ain't the best choice...

 

[ImNotSatan]

Deobfuscated anyway... Ain't the best choice...

Yes thats true, they did get a verry good finish of how to managed to get it

 

[Droppy]

Yes thats true, they did get a verry good finish of how to managed to get it

For sure! But still some cs files badly cleaned, some of them you may be interested to edit...

 

[ImNotSatan]

Use JOIN query like:

dbClient.runFastQuery("DELETE items, items_extradata, items_users " +
                                             "FROM items_users " +
                                             "INNER JOIN items ON (items.item_id = items_users.item_id) " +
                                             "LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id) " +
                                             "WHERE items_users.user_id = " + UserId);

Wow nice this is sure handy

 

[PR0]

All rights works fine for me *ankka emu*
Freeze all ill have a look at
Randomly cant walk on spots never seen that bug
ill look in to :setmax
i havent got a gift fix so i cant help there
the dice thing is easy to fix

#Threading Main Loops.
#Esta opcion separa del MainGameLoop cada tarea a ejecutar en un proceso distinto.
SeparatedTasksInMainLoops.enabled=true


#Threading GameClientManager Loops.
#Esta opcion separa del GameClientManager.OnCycle las tareas de forma lógica para aumentar rendimiento.
SeparatedTasksInGameClientManager.enabled=true and make sure the cycle count is on 6 in the db

dont touch any wired mate sorry

working on custom models atm

Damn.. should have specified. Would you be able to make the :allrights command compatible for PlusEMU please?

 

[Jiozx]

can someone code :emptypets and :emptybots? I use PlusEMU r2. The :emptypets in the emulator doesn't work..

 

[ImNotSatan]

@

Do you tink you could code an :emptybots and :emptypets

Atm i got an empypets but it doesnt work really good cuz im a noob xD


Atm i got this:
internal void emptypets()
{
this.Session.GetHabbo().GetInventoryComponent().ClearPets();
this.Session.SendNotif("Pets cleaned);
}

internal void ClearPets()
{
using (IQueryAdapter adapter = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
adapter.runFastQuery("DELETE FROM user_pets WHERE user_id = " + UserId + " AND room_id = 0;");
}
this.mAddedItems.Clear();
this.mRemovedItems.Clear();
this.floorItems.Clear();
this.wallItems.Clear();
this.discs.Clear();
this.InventoryPets.Clear();
this.isUpdated = true;
this.mClient.GetMessageHandler().GetResponse().Init(Outgoing.UpdateInventary);
this.GetClient().GetMessageHandler().SendResponse();
}

it works but i need to reload, could u make it so it update's

Thx !!!!

 

[Bjork]

@DarkPower

Do you tink you could code an :emptybots and :emptypets

Atm i got an empypets but it doesnt work really good cuz im a noob xD


Atm i got this:
internal void emptypets()
{
this.Session.GetHabbo().GetInventoryComponent().ClearPets();
this.Session.SendNotif("Pets cleaned);
}

internal void ClearPets()
{
using (IQueryAdapter adapter = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
adapter.runFastQuery("DELETE FROM user_pets WHERE user_id = " + UserId + " AND room_id = 0;");
}
this.mAddedItems.Clear();
this.mRemovedItems.Clear();
this.floorItems.Clear();
this.wallItems.Clear();
this.discs.Clear();
this.InventoryPets.Clear();
this.isUpdated = true;
this.mClient.GetMessageHandler().GetResponse().Init(Outgoing.UpdateInventary);
this.GetClient().GetMessageHandler().SendResponse();
}

it works but i need to reload, could u make it so it update's

Thx !!!!

Try this ?

internal void emptypets()
        {
               Session.GetHabbo().GetInventoryComponent().ClearPets();
   [B]Session.SendMessage(Session.GetHabbo().GetInventoryComponent().SerializePetInventory());[/B]
               Session.SendNotif("Pets cleaned");
        }

 

[ImNotSatan]

Try this ?

internal void emptypets()
        {
               Session.GetHabbo().GetInventoryComponent().ClearPets();
   [B]Session.SendMessage(Session.GetHabbo().GetInventoryComponent().SerializePetInventory());[/B]
               Session.SendNotif("Pets cleaned");
        }

Thx

should i keep this?

this.mAddedItems.Clear();
this.mRemovedItems.Clear();
this.floorItems.Clear();
this.wallItems.Clear();
this.discs.Clear();
this.InventoryPets.Clear();
this.isUpdated = true;
this.mClient.GetMessageHandler().GetResponse().Init(Outgoing.UpdateInventary);
this.GetClient().GetMessageHandler().SendResponse();

Elso what should i use for bots?

EDIT:
nvm

this.Session.SendMessage(Session.GetHabbo().GetInventoryComponent().SerializeBotInventory();

EDIT 2:
totally works now thx !


EDIT3 :

do you may know how to make a command like

:reloadroomlist

(reloads the rooms of a user)

 

[VabboWorld]

Please a transform for Swift/BcStorm ( Sorry i'm french x) ).

 

[Harun9]

Giveranks to r63

 

[Power]

Please a transform for Swift/BcStorm ( Sorry i'm french x) ).

i tried to do this a failed terrible <3 i would love this also. and harun9 and what emu if it phoenix no