Inventory Items Fix + My Leave

Hello today i Release the Furni Buy bug fix for Buy 33333 items and more okay ;) this are my last Release. I Leave the Scene ;)

search For the Call getuseritems functions in the source and replace all the Call getuseritems Lines with

Code:

---

adapter.setQuery("SELECT items_users.item_id, items.base_id, items_extradata.data, items.rareid, items.group_data FROM items_users 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);

---

Now search for Call Getroomitems and Repleace all the Getroomitems lines with

Code:

---

adapter.setQuery("SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items.rareid, items.group_data FROM items_rooms JOIN items ON (items.item_id = items_rooms.item_id) LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id) WHERE items_rooms.room_id = @roomid");
adapter.addParameter("roomid", room.RoomId);

---

credits: Meik2010 50% for the Idea and 50% to me For Coding ;)

thanks man. sad 2 see you leaving.

No problem..

Can anyone confirm this code working without debug errors etc.

Why do you leave man? How sad..
Thanks for the fix! ;)

the German scene is not what it used to be .. Released what it is and makes you stupid;)

Thanks for the share.

Thanks but my client crash again when i have 3361 items. :/

Thanks for the share. Will test it out :)

~tdid

Edit: i'm coding a Last Fix ;) a Club gift page ^^ like habbo ;D i need the Packet? o.o have every one the Packet or can Search? ^^ for Release63-201211141113-913728051

What the hell is this? i don't get it lolz?

This doesn't run for me says "Error 2 The name 'userId' does not exist in the current context"

You're setting the query but not executing it ?

Hmm works when I use this @userid"); instead of " + userId);

Also I use + userId"); and now it runs.