Tabbed DB Save Issue

11/16/2016 03:48 Lodelight#1
I added the tabbed inventory, double checked everything with winmerge and even compareIT. It's all defined in the correct projects to.

Everything compiles fine, however when the player logs out or it saves it dispenses this error:
Code:
2016/11/15 21:43:05
CQuery::BindParameter - result : -1, ThreadID : 2532
2016/11/15 21:43:05
CQuery::BindParameter - result : -1, ThreadID : 2532
2016/11/15 21:43:05
CQuery::BindParameter - result : -1, ThreadID : 2532
2016/11/15 21:43:05
CQuery::BindParameter - result : -1, ThreadID : 2532
2016/11/15 21:43:05
CQuery::BindParameter - result : -1, ThreadID : 2532
2016/11/15 21:43:05
CQuery::BindParameter - result : -1, ThreadID : 2532
2016/11/15 21:43:05
CQuery::BindParameter - result : -1, ThreadID : 2532
2016/11/15 21:43:05
CQuery::BindParameter - result : -1, ThreadID : 2532
2016/11/15 21:43:05
CQuery::BindParameter - result : -1, ThreadID : 2532
2016/11/15 21:43:05
CQuery::BindParameter - result : -1, ThreadID : 2532
2016/11/15 21:43:05
SavePlayer(Testers) - 64th bindparam error - 2532
2016/11/15 21:43:05
try DB Reconnect... - ThreadId : 2532
2016/11/15 21:43:05
DB Reconnect Success! - ThreadId : 2532
If u reboot the server the character is well wiped.

I changed the following according to the other Database for my database.
Why is this happening, what am i missing o.o?
11/16/2016 10:58 -Venom'#2
Leeched Form Dragon Cross ?
11/16/2016 11:35 julioclitwin#3
Just check if server is sending all parameters to query is correct, maybe is missing something.
11/16/2016 12:27 alfredico#4
Check number 64, there are over 110 params in total.

SavePlayer(Testers) - 64th bindparam error - 2532
11/16/2016 14:07 Lodelight#5
Quote:
Originally Posted by Gentros' View Post
Leeched Form Dragon Cross ?
Yes


Quote:
Originally Posted by alfredico View Post
Check number 64, there are over 110 params in total.

SavePlayer(Testers) - 64th bindparam error - 2532
How do u count these out exactly?


Theres

?
MAX_SAVEPARAM +
bOK[++j] = qry->BindParameter


Which one do you count?


This is also my DbManagerSave.cpp:
[Only registered and activated users can see links. Click Here To Register...]

----------------------------------------------------------------------------------------------------------


After counting down if i'm correct i assume its :
Code:
	bOK[++j] = qry->BindParameter( ++i, SQL_PARAM_INPUT, SQL_C_SHORT, SQL_SMALLINT, 0, 0, &pMover->m_UserTaskBar.m_nActionPoint, 0, 0 );
Which dragoncross or w/e shows this:
Code:
#ifndef __NEW_THEME
	bOK[++j] = qry->BindParameter( ++i, SQL_PARAM_INPUT, SQL_C_SHORT, SQL_SMALLINT, 0, 0, &pMover->m_UserTaskBar.m_nActionPoint, 0, 0 );
#else //__NEW_THEME
	int nAP = 0;
	bOK[++j] = qry->BindParameter( ++i, SQL_PARAM_INPUT, SQL_C_SHORT, SQL_SMALLINT, 0, 0, &nAP, 0, 0 );
#endif //__NEW_THEME
I dont use the v19 skin nor did i add this so im not sure where or how to stop this?
11/16/2016 14:31 -Venom'#6
Your SaveInventory:
Code:
#ifdef __TABBED_INV
    strncat( pItemContainerStruct->szItem4, NullStr, sizeof(NullStr) );
#else
    strncat( pItemContainerStruct->szItem, NullStr, sizeof(NullStr) );
#endif
My SaveInventory:
Code:
#ifdef __TABBED_INV
	strncat(pItemContainerStruct->szItem, NullStr, sizeof(NullStr));
	strncat(pItemContainerStruct->szItem2, NullStr, sizeof(NullStr));
	strncat(pItemContainerStruct->szItem3, NullStr, sizeof(NullStr));
	strncat(pItemContainerStruct->szItem4, NullStr, sizeof(NullStr));
#else
	strncat(pItemContainerStruct->szItem, NullStr, sizeof(NullStr));
#endif
My tabbed Inventory works good and stable.
11/16/2016 14:54 Lodelight#7
Quote:
Originally Posted by Gentros' View Post
Your SaveInventory:
Code:
#ifdef __TABBED_INV
    strncat( pItemContainerStruct->szItem4, NullStr, sizeof(NullStr) );
#else
    strncat( pItemContainerStruct->szItem, NullStr, sizeof(NullStr) );
#endif
My SaveInventory:
Code:
#ifdef __TABBED_INV
    strncat(pItemContainerStruct->szItem, NullStr, sizeof(NullStr));
    strncat(pItemContainerStruct->szItem2, NullStr, sizeof(NullStr));
    strncat(pItemContainerStruct->szItem3, NullStr, sizeof(NullStr));
    strncat(pItemContainerStruct->szItem4, NullStr, sizeof(NullStr));
#else
    strncat(pItemContainerStruct->szItem, NullStr, sizeof(NullStr));
#endif
My tabbed Inventory works good and stable.
I tried this and it made no difference :(
11/17/2016 05:23 Rhyder`#8
@[Only registered and activated users can see links. Click Here To Register...]
What?? Only szItem4 got the /$ then you will nullstr all? Possible the dragoncross tab will not save..
12/22/2016 15:43 banktakung#9
Quote:
Originally Posted by Rhyder` View Post
@[Only registered and activated users can see links. Click Here To Register...]
What?? Only szItem4 got the /$ then you will nullstr all? Possible the dragoncross tab will not save..
So how to fix it sir ?

:handsdown: