plusEMU issues.

[Stevee]

Hi,

I was wondering if someone could help me sort this issue? The issue is, whenever a user is trying to use the command "ickall" they end up picking up there entire room yes or if they pickup an item, BUT if they reload there room the items they've picked up will return back in there room..

any ideas why?

@Sledmore if you could possibly help me that'd be great as well.

Thanks,
Steve

 

[MrArkalys]

So when some1 picks up 1 single item all the items in the room are picked up???
Then your ickall is just fucked up.... you should remove the command and add it remotely again (WITH THE GOOD SCRIPT)<<<

 

[Data]

So when some1 picks up 1 single item all the items in the room are picked up???
Then your ickall is just fucked up.... you should remove the command and add it remotely again (WITH THE GOOD SCRIPT)<<<

He gets a mysql error.

Error in query:
UPDATE items SET user_id = 21, room_id='' WHERE id = 8524
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: '' for column 'room_id' at row 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery()

 

[Stevee]

So when some1 picks up 1 single item all the items in the room are picked up???
Then your ickall is just fucked up.... you should remove the command and add it remotely again (WITH THE GOOD SCRIPT)<<<

No,

When someone uses the command ickall

or picks up a furniture item manually, the item picked up or the room picked up will just return when they reload the room.

It doesn't go back to the inventor like it's supposed too

 

[MrArkalys]

No,

When someone uses the command ickall

or picks up a furniture item manually, the item picked up or the room picked up will just return when they reload the room.

It doesn't go back to the inventor like it's supposed too

So... if i understand it good, if you picj up ANYTHING ANYWAY it just returns to the room and not in your inventory???

DAFUQ i am a long time in retro bussiness but never had this...

Will ask some friends/sites for help will try my best for ya^^ BTW Screen your mySQL error since you didnt say that you had that^^

 

[MrArkalys]

Ehm you might have an old build... here is the new build with patched pickup:

You must be registered for see links

Couldn't find download link this fast but at least you see what versions are patched and what not... i saw this on rage-zone btw<

 

[Sledmore]

Change room_id='' to `room_id`= '0' (as you probably have your MySQL on strict, it wants an integer value only, not an empty value).

 

[Stevee]

Change room_id='' to `room_id`= '0' (as you probably have your MySQL on strict, it wants an integer value only, not an empty value).

The room_id for the table 'items' is already set to the default of 0,

You must be registered for see links

 

[Sledmore]

I meant via the emulator.

 

[Stevee]

I meant via the emulator.

Oh right, would this be in the commandhandler file? Or where exactly.

 

[Sledmore]

Just CTRL + F for all results that come up for 'room_id='' WHERE' and change them to '`room_id` = '0' WHERE'.

 

[Stevee]

Just CTRL + F for all results that come up for 'room_id='' WHERE' and change them to '`room_id` = '0' WHERE'.

Alright, thank you.

 

[Stevee]

Just CTRL + F for all results that come up for 'room_id='' WHERE' and change them to '`room_id` = '0' WHERE'.

That wasn't the issue, I think it's a database issue because it's still happening after changing emulators. ._. any idea?

 

[Timothy]

Check your commands in your emulator folder. (I thought u ment when someone says "ickall" all their furni gets picked up.) I am stupid. -.-