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 ;)
Re: Inventory Items Fix + My Leave
thanks man. sad 2 see you leaving.
Re: Inventory Items Fix + My Leave
Re: Inventory Items Fix + My Leave
Can anyone confirm this code working without debug errors etc.
Re: Inventory Items Fix + My Leave
Why do you leave man? How sad..
Thanks for the fix! ;)
Re: Inventory Items Fix + My Leave
the German scene is not what it used to be .. Released what it is and makes you stupid;)
Re: Inventory Items Fix + My Leave
Re: Inventory Items Fix + My Leave
Thanks but my client crash again when i have 3361 items. :/
Re: Inventory Items Fix + My Leave
Thanks for the share. Will test it out :)
~tdid
Re: Inventory Items Fix + My Leave
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
Re: Inventory Items Fix + My Leave
What the hell is this? i don't get it lolz?
Re: Inventory Items Fix + My Leave
This doesn't run for me says "Error 2 The name 'userId' does not exist in the current context"
Re: Inventory Items Fix + My Leave
You're setting the query but not executing it ?
Re: Inventory Items Fix + My Leave
Hmm works when I use this @userid"); instead of " + userId);
Also I use + userId"); and now it runs.