[SERVICE] - Coding Commands

Quote:

---

Originally Posted by ImNotSatan

The source has been releassed

---

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

Quote:

---

Originally Posted by BaasHotel

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

PHP Code:

---

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? :)

Quote:

---

Originally Posted by DarkPower

Emu? :)

---

Baashotel uses SwiftEmu

Quote:

---

Originally Posted by BaasHotel

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

PHP Code:

---

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

Quote:

---

Originally Posted by BaasHotel

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

PHP Code:

---

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:

PHP Code:

---

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.

Quote:

---

Originally Posted by Bjork

Use JOIN query like:

PHP Code:

---

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!

Quote:

---

Originally Posted by DarkPower

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.

Quote:

---

Originally Posted by Bjork

Use JOIN query like:

PHP Code:

---

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!

Quote:

---

Originally Posted by ImNotSatan

The source has been releassed

---

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

Quote:

---

Originally Posted by Droppy

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

---

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

Quote:

---

Originally Posted by ImNotSatan

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

---

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

[QUOTE=Bjork;8072714]Use JOIN query like:

PHP Code:

---

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 :D

Quote:

---

Originally Posted by DarkPower

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? :)

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

@

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 :D!!!!

Quote:

---

Originally Posted by ImNotSatan

@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 :D!!!!

---

Try this ?

Code:

---

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

---

Quote:

---

Originally Posted by Bjork

Try this ?

Code:

---

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

---

---

Thx :D

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 :P

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)

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

Giveranks to r63 :blushing:

Quote:

---

Originally Posted by VabboWorld

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

Quote:

---

Originally Posted by DarkPower

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

---

Do you know how to make like :updatemyroomlist

?

there something released online somewhere for swift

Quote:

---

Originally Posted by DarkPower

there something released online somewhere for swift

---

On ragezone?

Fly, Kiss, Lay For GTE ?

Plz filename to becuz i don't work so much with gte