168 Inventory Slot

05/30/2018 12:58 khemomo#1

#request to delete thanks

05/30/2018 19:14 Dr. Peacock#2

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.

05/31/2018 03:26 khemomo#3

Quote:

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 :feelsgoodman:

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

[Only registered and activated users can see links. Click Here To Register...]

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?

Code:

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? :wat:

05/31/2018 04:11 Mushpoie#4

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.

05/31/2018 04:31 khemomo#5

Quote:

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)

06/01/2018 09:54 KingKeesie#6

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

06/01/2018 13:47 khemomo#7

Quote:

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

06/01/2018 16:30 Mushpoie#8

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.

06/01/2018 19:01 Avalion#9

Find the error.

Code:

	IndexItem = GetOneItem( &BufItemElem, Inven, &CountStr );
				if( IndexItem == -1 )
				{
					Error( "Inventory : << ������Ƽ ����. %s, %d", mover.m_szName, BufItemElem.m_dwItemId );
				}
				else

Code:

	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.

06/02/2018 02:13 khemomo#10

Quote:
Originally Posted by Avalion
Find the error.
Code:
	IndexItem = GetOneItem( &BufItemElem, Inven, &CountStr );
				if( IndexItem == -1 )
				{
					Error( "Inventory : << ������Ƽ ����. %s, %d", mover.m_szName, BufItemElem.m_dwItemId );
				}
				else
Code:
	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?

06/02/2018 04:08 Mushpoie#11

Quote:

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.

[Only registered and activated users can see links. Click Here To Register...]

06/02/2018 10:46 khemomo#12

Quote:

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.

[Only registered and activated users can see links. Click Here To Register...]

Using SQL: SQL 2014
ODBC: SQL Server Native Client 11.0
Code from: [Only registered and activated users can see links. Click Here To Register...] (Reupload by FlyServices [Only registered and activated users can see links. Click Here To Register...] )
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 :wojak:

06/14/2018 19:27 ramom155#13

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' @[Only registered and activated users can see links. Click Here To Register...]rindex='01',@iaccount='ramom',@im_szName='treta' @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @[Only registered and activated users can see links. Click Here To Register...]Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @[Only registered and activated users can see links. Click Here To Register...]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' @[Only registered and activated users can see links. Click Here To Register...]rindex='01',@iaccount='ramom',@im_szName='treta' @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @[Only registered and activated users can see links. Click Here To Register...]Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @[Only registered and activated users can see links. Click Here To Register...]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.

11/11/2018 07:12 Ecrypter#14

AHHHHHH