168 Inventory Slot

[khemomo]

#request to delete thanks

[Dr. Peacock]

1. Check the Source Code for the Database part.
2. Check the Database for missing Codes (try to clean the Inventory $,$,$... and create your own Character with optimal Starter Items.

[khemomo]

Originally Posted by Dr. Peacock

1. Check the Source Code for the Database part.
2. Check the Database for missing Codes (try to clean the Inventory $,$,$... and create your own Character with optimal Starter Items.

Thank you for your response

Just A question. I don't actually understand the "Try to clean your inventory"
i tried to look for the m_Inventory Inside the Character_TBL > BASE_VALUE_TBL but I this is the only thing I see



All I can see when i right click each TBL Inside the Character_TBL is "Modify and New Column" Every time i click that it only send me into list of table.

I think this is what you've talking about?

USE CHARACTER_01_DBF
GO
UPDATE BASE_VALUE_TBL SET m_Inventory = '0,2800,0,0,,3,0,-1,0,0,0,-322033766,0,0,0,0,0/1,2801,0,0,,1,0,-1,0,0,0,-1981991882,0,0,0,0,0/2,4805,0,0,,5,0,-1,0,0,0,1215878883,0,0,0,0,0/3,21,0,0,,1,0,7200000,0,0,0,1392520605,0,0,0,0,0/169,510,0,0,,1,0,4500000,0,0,0,-40500469,0,0,0,0,0/170,506,0,0,,1,0,5850000,0,0,0,-1201535032,0,0,0,0,0/171,502,0,0,,1,0,9000000,0,0,0,1123978889,0,0,0,0,0/$' WHERE g_nSex = '0'
UPDATE BASE_VALUE_TBL SET m_apIndex = '0/1/2/172/173/174/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/48/49/50/51/52/53/54/55/56/57/58/59/60/61/62/63/64/65/66/67/68/69/70/71/72/73/74/75/76/77/78/79/80/81/82/83/84/85/86/87/88/89/90/91/92/93/94/95/96/97/98/99/100/101/102/103/104/105/106/107/108/109/110/111/112/113/114/115/116/117/118/119/120/121/122/123/124/125/126/127/128/129/130/131/132/133/134/135/136/137/138/139/140/141/142/143/144/145/146/147/148/149/150/151/152/153/154/155/156/157/158/159/160/161/162/163/164/165/166/167/-1/-1/171/-1/170/169/-1/-1/-1/-1/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '0'
UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '0/1/2/178/173/178/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/48/49/50/51/52/53/54/55/56/57/58/59/60/61/62/63/64/65/66/67/68/69/70/71/72/73/74/75/76/77/78/79/80/81/82/83/84/85/86/87/88/89/90/91/92/93/94/95/96/97/98/99/100/101/102/103/104/105/106/107/108/109/110/111/112/113/114/115/116/117/118/119/120/121/122/123/124/125/126/127/128/129/130/131/132/133/134/135/136/137/138/139/140/141/142/143/144/145/146/147/148/149/150/151/152/153/154/155/156/157/158/159/160/161/162/163/164/165/166/167/170/173/172/170/3/4/5/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '0'
UPDATE BASE_VALUE_TBL SET m_adwEquipment = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$' WHERE g_nSex = '0'
GO
UPDATE BASE_VALUE_TBL SET m_Inventory = '0,2800,0,0,,3,0,-1,0,0,0,-45364226,0,0,0,0,0/1,2801,0,0,,1,0,-1,0,0,0,38338230,0,0,0,0,0/2,4805,0,0,,5,0,-1,0,0,0,-1372191970,0,0,0,0,0/3,21,0,0,,1,0,7200000,0,0,0,1863914943,0,0,0,0,0/171,504,0,0,,1,0,9000000,0,0,0,-678003276,0,0,0,0,0/172,512,0,0,,1,0,4500000,0,0,0,1047816487,0,0,0,0,0/173,508,0,0,,1,0,5850000,0,0,0,1764043902,0,0,0,0,0/$' WHERE g_nSex = '1'
UPDATE BASE_VALUE_TBL SET m_apIndex = '0/1/2/174/170/169/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/48/49/50/51/52/53/54/55/56/57/58/59/60/61/62/63/64/65/66/67/68/69/70/71/72/73/74/75/76/77/78/79/80/81/82/83/84/85/86/87/88/89/90/91/92/93/94/95/96/97/98/99/100/101/102/103/104/105/106/107/108/109/110/111/112/113/114/115/116/117/118/119/120/121/122/123/124/125/126/127/128/129/130/131/132/133/134/135/136/137/138/139/140/141/142/143/144/145/146/147/148/149/150/151/152/153/154/155/156/157/158/159/160/161/162/163/164/165/166/167/-1/-1/171/-1/173/172/-1/-1/-1/-1/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '1'
UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '0/1/2/178/173/178/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/48/49/50/51/52/53/54/55/56/57/58/59/60/61/62/63/64/65/66/67/68/69/70/71/72/73/74/75/76/77/78/79/80/81/82/83/84/85/86/87/88/89/90/91/92/93/94/95/96/97/98/99/100/101/102/103/104/105/106/107/108/109/110/111/112/113/114/115/116/117/118/119/120/121/122/123/124/125/126/127/128/129/130/131/132/133/134/135/136/137/138/139/140/141/142/143/144/145/146/147/148/149/150/151/152/153/154/155/156/157/158/159/160/161/162/163/164/165/166/167/170/5/4/170/173/172/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '1'
UPDATE BASE_VALUE_TBL SET m_adwEquipment = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$' WHERE g_nSex = '1'
GO

But i wonder how and where did he/she get that entry's from?

[Mushpoie]

Delete the table, pull it from the sql script, re-import the table and update the strings.

Everything needed was included in the original release.

[khemomo]

Originally Posted by Mushpoie

Delete the table, pull it from the sql script, re-import the table and update the strings.

Everything needed was included in the original release.

That is what I did, I delete my BASE_VALUE_TBL, INVENTORY_TBL, INVENTORY_EXT_TBL, And QUEST_STR, then execute the
"BASE_VALUE_TBL.sql , Inventory.sql , and QUEST_STR" From the release.

and it works with-out the error but yeah that problem happen (Wipe)

Btw I didn't execute the Character_STR from the release i just compare it to mine. (changing value)

[KingKeesie]

Bro i sended you my clean database with 168 slots V15 character_01_dbf, also the DbManager.cpp were u got a error on? compare with yours and it should be solved

[khemomo]

Originally Posted by KingKeesie

Bro i sended you my clean database with 168 slots V15 character_01_dbf, also the DbManager.cpp were u got a error on? compare with yours and it should be solved

Woah! Still got the same error
Auto Remove item during character selection and automatic wipe

2018/ 6/ 1 19:44:07 Inventory : << ÇÁ·ÎÆÛƼ ¾øÀ½. TesterGuy, 0

[Mushpoie]

Make sure that:
#define MAX_INVENTORY 168

Is in..
_Common\ProjectCmn.h
_Network\Objects\Obj.h

Also make sure that your using SQL server Native Client 11.0 or above.

[Avalion]

Find the error.

	IndexItem = GetOneItem( &BufItemElem, Inven, &CountStr );
				if( IndexItem == -1 )
				{
					Error( "Inventory : << ÇÁ·ÎÆÛƼ ¾øÀ½. %s, %d", mover.m_szName, BufItemElem.m_dwItemId );
				}
				else

	int IndexItem		= 0;
	IndexItem	= GetIntPaFromStr( pstrItem, pLocation );
	pItemElem->m_dwItemId	= (DWORD)GetIntPaFromStr( pstrItem, pLocation );

The objid for the item that is causing the error is unsigned long max and/or -1. Personally, double check if everything has been added successfully, source and DB wise. Double check your values and your sizes. Double check that the first base_value_tbl is correct. You can always start off with no items be recreating the base_value_tbl where m_inventory is "$" and the m_apIndex and m_dwObjIndex is 0/1/2/3/ to 167 and then have 31 -1's after for the equips and of course end with $.

As Mushpoie said, double check your odbc to use sql server native client. If you're using '08, the odbc connection for sql server doesn't seem to like varchar(max). Haven't tried the released package, but from my understanding, should simply work.

[khemomo]

Originally Posted by Avalion

Find the error.

	IndexItem = GetOneItem( &BufItemElem, Inven, &CountStr );
				if( IndexItem == -1 )
				{
					Error( "Inventory : << ÇÁ·ÎÆÛƼ ¾øÀ½. %s, %d", mover.m_szName, BufItemElem.m_dwItemId );
				}
				else

	int IndexItem		= 0;
	IndexItem	= GetIntPaFromStr( pstrItem, pLocation );
	pItemElem->m_dwItemId	= (DWORD)GetIntPaFromStr( pstrItem, pLocation );

The objid for the item that is causing the error is unsigned long max and/or -1. Personally, double check if everything has been added successfully, source and DB wise. Double check your values and your sizes. Double check that the first base_value_tbl is correct. You can always start off with no items be recreating the base_value_tbl where m_inventory is "$" and the m_apIndex and m_dwObjIndex is 0/1/2/3/ to 167 and then have 31 -1's after for the equips and of course end with $.

As Mushpoie said, double check your odbc to use sql server native client. If you're using '08, the odbc connection for sql server doesn't seem to like varchar(max). Haven't tried the released package, but from my understanding, should simply work.

Source Code Exactly the same with the Release one
Character_Str Exactly the same with the release one

What I did to the other part of Database (BASE_VALUE_TBL, INVENTORY_TBL,INVENTORY_EXT_TBL,QUEST_STR)

I delete BASE_VALUE_TBL, INVENTORY_TBL,INVENTORY_EXT_TBL,QUEST_STR from my existing clean database and then execute the Script from the release.

I wonder if that moves is ok?

[Mushpoie]

Originally Posted by khemomo

Source Code Exactly the same with the Release one
Character_Str Exactly the same with the release one

What I did to the other part of Database (BASE_VALUE_TBL, INVENTORY_TBL,INVENTORY_EXT_TBL,QUEST_STR)

I delete BASE_VALUE_TBL, INVENTORY_TBL,INVENTORY_EXT_TBL,QUEST_STR from my existing clean database and then execute the Script from the release.

I wonder if that moves is ok?

If your merge/add was correct, your using sql12+ and native 11 then this database will work without problems.

This is a clean database, nothing has been added except for the 168 slots.

If your still having issues after using this database then you need to recheck everything.

[khemomo]

Originally Posted by Mushpoie

If your merge/add was correct, your using sql12+ and native 11 then this database will work without problems.

This is a clean database, nothing has been added except for the 168 slots.

If your still having issues after using this database then you need to recheck everything.

Using SQL: SQL 2014
ODBC: SQL Server Native Client 11.0
Code from: (Reupload by FlyServices )
Defined as: __NOT_STOLEN_INVENTORY

Tried Trouble Shooting
Re-Checking Source Code (Check)
Character_STR All the same (Check)


Tried approach in the Database part (SQL)
Deleting my existing

BASE_VALUE_TBL
INVENTORY_EXT_TBL
INVENTORY_TBL
QUEST_STR

And then Executing the SQL Part from the release
BASE_VALUE_TBL.sql
Inventory.sql
QUEST_STR.sql

Defined in every Versioncommon.h
#define __NOT_STOLEN_INVENTORY


Issue:
When I reach 141 Item inside my inventory then restart my server (closing All .exe) then all item will be wipe including the item of the character (being naked)

Getting an error inside my program folder (.exe Location)
2018/ 6/2 04:04:47 Inventory : << ÇÁ·ÎÆÛƼ ¾øÀ½. TesterGuy, 0

File use: v15 File

Status: still not fix

[ramom155]

Someone can help me I'm using a DB v17 with Glow Change and model view and Model change I got and compared the DB added so the changes in both banks and at the time of creating an account the following error occurs.

 Spoiler

2018/06/14 14:07:55
query:CHARACTER_STR 'I1',@im_idPlayer='0000000' @rindex='01',@iaccount='ramom',@im_szName='treta' @slot=0,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=697 1.984375,@im_vPos_y=100.000000,@im_vPos_z=3336.884 277,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@i m_dwHairMesh=0,@im_dwHairColor=-329126,@im_dwHeadMesh=3,@im_dwSex=1,@im_vScale_x=0 .000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHi tPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_ dwRideItemIdx=0,@im_dwGold=0,@im_nJob=1,@im_pActMo ver='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_ nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJ obSkill='(null)',@im_aLicenseSkill='(null)',@im_aJ obLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld= 0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.0 00000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@ im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp =0,@im_lpQuestCntArray='(null)',@im_chAuthority='F ',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im _nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwF lyTime=0,@im_nMessengerState=0 @alPlayTime=0,@im_Card='(null)',@im_Index_Card='(nu ll)',@im_ObjIndex_Card='(null)',@im_Cube='(null)', @im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)' ,@im_Inventory='(null)',@im_apIndex='(null)',@im_a dwEquipment='(null)',@im_dwObjIndex='(null)',@im_a SlotApplet='(null)',@im_aSlotItem='(null)',@im_aSl otQueue='(null)',@im_SkillBar=0 @='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @Piercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0 .000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z =0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_ dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszIn ventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@ im_aCheckedQuest='(null)'
SQLSTATE:23000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'm_Bank', table 'CHARACTER_01_DBF.dbo.BANK_TBL'; column does not allow nulls. INSERT fails.
2018/06/14 14:07:55
query:CHARACTER_STR 'I1',@im_idPlayer='0000000' @rindex='01',@iaccount='ramom',@im_szName='treta' @slot=0,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=697 1.984375,@im_vPos_y=100.000000,@im_vPos_z=3336.884 277,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@i m_dwHairMesh=0,@im_dwHairColor=-329126,@im_dwHeadMesh=3,@im_dwSex=1,@im_vScale_x=0 .000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHi tPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_ dwRideItemIdx=0,@im_dwGold=0,@im_nJob=1,@im_pActMo ver='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_ nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJ obSkill='(null)',@im_aLicenseSkill='(null)',@im_aJ obLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld= 0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.0 00000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@ im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp =0,@im_lpQuestCntArray='(null)',@im_chAuthority='F ',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im _nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwF lyTime=0,@im_nMessengerState=0 @alPlayTime=0,@im_Card='(null)',@im_Index_Card='(nu ll)',@im_ObjIndex_Card='(null)',@im_Cube='(null)', @im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)' ,@im_Inventory='(null)',@im_apIndex='(null)',@im_a dwEquipment='(null)',@im_dwObjIndex='(null)',@im_a SlotApplet='(null)',@im_aSlotItem='(null)',@im_aSl otQueue='(null)',@im_SkillBar=0 @='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @Piercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0 .000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z =0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_ dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszIn ventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@ im_aCheckedQuest='(null)'
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.

[Ecrypter]

AHHHHHH