Inventory Items Fix + My Leave

[GheddoMonsta]

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

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

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 ;)

[MentaL]

[Flare]

thanks man. sad 2 see you leaving.

[GheddoMonsta]

No problem..

[KyleeIsProzZ]

Can anyone confirm this code working without debug errors etc.

[PRIZM]

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

[GheddoMonsta]

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

[LickUrDig]

Thanks for the share.

[xoofer]

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

[The General]

Thanks for the share. Will test it out :)

~tdid

[GheddoMonsta]

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

[Chapo]

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

[BoomHotel]

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

[Jonteh]

You're setting the query but not executing it ?

[BoomHotel]

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

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