|
You last visited: Today at 07:39
Advertisement
168 Inventory Slot
Discussion on 168 Inventory Slot within the Flyff Private Server forum part of the Flyff category.
05/30/2018, 12:58
|
#1
|
elite*gold: 0
Join Date: Jun 2008
Posts: 355
Received Thanks: 5
|
168 Inventory Slot
#request to delete thanks
|
|
|
05/30/2018, 19:14
|
#2
|
elite*gold: 60
Join Date: Sep 2017
Posts: 424
Received Thanks: 138
|
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
|
#3
|
elite*gold: 0
Join Date: Jun 2008
Posts: 355
Received Thanks: 5
|
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
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?
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?
|
|
|
05/31/2018, 04:11
|
#4
|
elite*gold: 0
Join Date: Mar 2018
Posts: 77
Received Thanks: 57
|
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
|
#5
|
elite*gold: 0
Join Date: Jun 2008
Posts: 355
Received Thanks: 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
|
#6
|
elite*gold: 0
Join Date: Jan 2017
Posts: 301
Received Thanks: 28
|
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
|
#7
|
elite*gold: 0
Join Date: Jun 2008
Posts: 355
Received Thanks: 5
|
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
|
#8
|
elite*gold: 0
Join Date: Mar 2018
Posts: 77
Received Thanks: 57
|
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
|
#9
|
elite*gold: 294
Join Date: Jun 2009
Posts: 407
Received Thanks: 587
|
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
|
#10
|
elite*gold: 0
Join Date: Jun 2008
Posts: 355
Received Thanks: 5
|
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
|
#11
|
elite*gold: 0
Join Date: Mar 2018
Posts: 77
Received Thanks: 57
|
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.
|
|
|
06/02/2018, 10:46
|
#12
|
elite*gold: 0
Join Date: Jun 2008
Posts: 355
Received Thanks: 5
|
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.
|
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
|
|
|
06/14/2018, 19:27
|
#13
|
elite*gold: 0
Join Date: Oct 2013
Posts: 47
Received Thanks: 0
|
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.
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.
|
|
|
11/11/2018, 07:12
|
#14
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
AHHHHHH
|
|
|
|
Similar Threads
|
168 Slot Inventory
02/29/2024 - Flyff PServer Guides & Releases - 103 Replies
Why pay 50 euro when you can have it for free :mofo:
https://drive.google.com/open?id=1C10jYBp3IOgi9zw N5nlQYOppM3PwHY-a
Credits: Hekmatyar
Ps: This feature was not stolen from clockworks flyff :bandit:
|
168 Inventory Problem
05/20/2018 - Flyff Private Server - 6 Replies
Hello, I'm back :3
I added 168 Inventory Slots and it is well placed to my source and I 4 executable .sql files is executed already.
So here is my problem.
http://i.epvpimg.com/IrxIcab.png
I don't know why I still receive this error.
|
[WTS]Tera Rising Veteran ACC 3xLvl60 GS170,168,168+5Twinks Hasmina [S]PSC/TF2 Items
04/14/2014 - Trading - 4 Replies
Hallo allerseits,
Wer kennt´s nicht, man wird in den Bann von einem tollen MMO/RPG gezogen, und verbringt mit vielen, vielen netten Leuten viel Zeit. Freundet sich an, meistert zusammen lustige, schwierige aber auch ernste Sachen. Hat eben wirklich Spaß.
Leider ist all die schöne Zeit irgendwann dann um, wenn die Luft raus ist, und genau das ist nun eben bei mir der Fall. Ich verkaufe meine Spielzeit relativ ungern, bin aber zu dem Schluß gekommen, dass ich definitiv nicht mehr anfangen...
|
All times are GMT +2. The time now is 07:39.
|
|