Room items -> Nova

Diddy · Oct 8, 2015

Issue with Nova.

I have run into one major bug, when I place items in a room and shut down the emulator by typing 'shutdown' on the console and reopen the emu and go to the same room the furni is not there.

I changed '.' to ',' in region and langauage settings I'm wondering if that would of messed it up.

But here is the error I get.

Error in query: REPLACE INTO items_rooms (item_id,room_id,x,y,n,user_id) VALUES (123,1,6,07000017166138,0,2,1),(122,1,6,07999992370605,0,2,1),(121,1,6,05000019073486,0,0,1)
DONGSql.Data.MySqlClient.MySqlException (0x80004005): Column count doesn't match value count at row 1
at DONGSql.Data.MySqlClient.MySqlStream.ReadPacket()
at DONGSql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at DONGSql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at DONGSql.Data.MySqlClient.MySqlDataReader.NextResult()
at DONGSql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at DONGSql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in e:\Users\Maarten Vink\Desktop\Source\Nova_RELEASE63-201312191142-127854526\Database Manager R103\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 216

That is given after I try to place 3 items in a room and shutdown the emulator. When i reopen and go in room its gone.

Thanks for any oncoming help.
Brought
Messaged Ryan

Matata · Oct 8, 2015

I changed '.' to ',' in region and langauage settings I'm wondering if that would of messed it up.

Yes it have.

Diddy · Oct 8, 2015

Matata said:
Yes it have.

How would I fix it to work with ','?

The General · Oct 9, 2015

When are people going to read error messages.

It clearly says: "Column count doesn't match value count at row 1"

Which means, the amount of columns you specify in your prepared statemetnt don't match the amount of values you add.

You're trying to update 6 columns with 7 values.

Edit your emulator so the amount of fields match the amount of values. Most likely you're missing a column to update.

Diddy · Oct 9, 2015

The General said:
When are people going to read error messages.

It clearly says: "Column count doesn't match value count at row 1"

Which means, the amount of columns you specify in your prepared statemetnt don't match the amount of values you add.

You're trying to update 6 columns with 7 values.

Yeah I read that and Tried to fix it, wouldn't have it. Fixed that issue just trying to figure why trading doesn't work now.

GlobeCMS · Oct 9, 2015

Maybe this.. : https://forum.ragezone.com/f335/fix-stack_height-mercury-emulator-1040923/ it's similar.

The General · Oct 9, 2015

GlobeCMS said:
Maybe this.. : https://forum.ragezone.com/f335/fix-stack_height-mercury-emulator-1040923/ it's similar.

No thats a type in a query.

Diddy · Oct 9, 2015

Like i said fixed this issue. Battling trying to get trading to work and stop throwing 'Can't Trade' as an error

Kim Jong Chill · Oct 9, 2015

The General
Maybe you should start supporting Nova emulator as it seems to be alot of people in need of help.
When I trade it simply says "Can't do that :-(". It doesn't throw me any error. If you don't have a solution, do you know where I should start looking for the issue? Which file in the project would that be?

The General · Oct 9, 2015

Re: Room items -> Nova

Kim Jong Chill said:
The General
Maybe you should start supporting Nova emulator as it seems to be alot of people in need of help.
When I trade it simply says "Can't do that :-(". It doesn't throw me any error. If you don't have a solution, do you know where I should start looking for the issue? Which file in the project would that be?

I only support up until in this section.

My own emulator has been in development for over a year and will be released soon. I really don't have the time to start working on other emulators too.

Diddy said:
Like i said fixed this issue. Battling trying to get trading to work and stop throwing 'Can't Trade' as an error

See in the emulator source where it sends that message and pastebin the whole method here.

Diddy · Oct 9, 2015

Re: Room items -> Nova

The General said:
I only support up until in this section.

My own emulator has been in development for over a year and will be released soon. I really don't have the time to start working on other emulators too.

See in the emulator source where it sends that message and pastebin the whole method here.

It doesn't show that message when searching for it as I'm having same issue as Kim Jong Chill but I have a feeling the issue is in here.

You must be registered to see links

(TradeManager.cs)

Kim Jong Chill · Oct 9, 2015

The message show as if there was a perk missing. At least that's what my external_texts say.

perkmissing.caption=Can't do that :-(
perkmissing.title=Ouch!

The General · Oct 9, 2015

Code:

response.appendString("TRADE");
response.appendString("");
response.appendBoolean(true);

Should be in your perks composer to allow trade.

Kim Jong Chill · Oct 9, 2015

There are five composers for trading, sir.

You must be registered to see links

And I'm guessing you won't need these, but I'll post them as well.

You must be registered to see links

I'm sorry The General, that I'm not that good of a programmer. I just really want to use this emulator.

Kim Jong Chill · Oct 10, 2015

Ryan said:
Just add "TRADE" in your DB (table: allowances)

Goodluck

Done. Still doesn't work

Diddy · Oct 10, 2015

Ryan said:
Just add "TRADE" in your DB (table: allowances)

Goodluck

Adding anything to allowances makes the client get stuck on 87%

The General · Oct 10, 2015

Should be UserPerksComposer

Diddy · Oct 10, 2015

The General said:
Should be UserPerksComposer

Added it to table now the emu goes black after starting up (gets rid of normal startup messages) and get this critexception

SYSTEM CRITICAL EXCEPTION: System.InvalidCastException: Specified cast is not valid.
at Nova.habbo.Client.Misc.AvatarClientRights.AllowanceManager.Initialize(IQueryAdapter dbClient) in c:\Users\Administrator\Desktop\EMU\Nova\habbo\Client\Misc\AvatarClientRights\AllowanceManager.cs:line 30
at Nova.habbo.ingame.Game.ContinueLoading() in c:\Users\Administrator\Desktop\EMU\Nova\Game.cs:line 380
at Nova.MainEnvironment.Initialize() in c:\Users\Administrator\Desktop\EMU\Nova\MainEnvironment.cs:line 125
at Nova.Program.InitEnvironment() in c:\Users\Administrator\Desktop\EMU\Nova\Program.cs:line 64
at Nova.Program.Main() in c:\Users\Administrator\Desktop\EMU\Nova\Program.cs:line 52

The General · Oct 10, 2015

Post the method which includes this line:

c:\Users\Administrator\Desktop\EMU\Nova\habbo\Client\Misc\AvatarClientRights\AllowanceManager.cs:line 30

Diddy · Oct 10, 2015

The General said:
Post the method which includes this line:

c:\Users\Administrator\Desktop\EMU\Nova\habbo\Client\Misc\AvatarClientRights\AllowanceManager.cs:line 30

internal void Initialize(IQueryAdapter dbClient) {
Allowances = new List<Allowance>();

dbClient.setQuery("SELECT * FROM `allowances`");
DataTable dAllow = dbClient.getTable();

if (dAllow != null)
{
foreach (DataRow Row in dAllow.Rows)
{
string label = (string) Row["label"];
string level = (string) Row["level"];
string fieldPerm = (string) Row["field_permission"];
int minrank = (int) Row["min_rank"];
bool Override = (bool)Row["override"];
bool overridestate = (bool)Row["override_state"];

Allowances.Add(new Allowance(label, level, fieldPerm, minrank, Override, overridestate));
}
}
}

Line 30 is

bool overridestate = (bool)Row["override_state"];

Room items -> Nova

Skilled Illusionist

Hakuna Matata

Skilled Illusionist

Developer

Skilled Illusionist

Junior Spellweaver

Developer

Skilled Illusionist

Newbie Spellweaver

Developer

Skilled Illusionist

Newbie Spellweaver

Developer

Newbie Spellweaver

Newbie Spellweaver

Skilled Illusionist

Developer

Skilled Illusionist

Developer

Skilled Illusionist