Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Flyff > Flyff Private Server
You last visited: Today at 02:21

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Tabbed Inventory DB

Discussion on Tabbed Inventory DB within the Flyff Private Server forum part of the Flyff category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2016
Posts: 36
Received Thanks: 17
Tabbed Inventory DB

Does any one have this and are they will to share the db changes for it? I know a few servers have it, i just need the db edits is all.

Thanks!
Lodelight is offline  
Old 08/23/2016, 10:28   #2



 
Sedrika's Avatar
 
elite*gold: 18
The Black Market: 103/0/0
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
Did you tried to do it by yourself so we may help you out ?
Sedrika is offline  
Old 08/23/2016, 14:46   #3
 
elite*gold: 0
Join Date: Jan 2014
Posts: 773
Received Thanks: 373
Quote:
Originally Posted by Lodelight View Post
Does any one have this and are they will to share the db changes for it? I know a few servers have it, i just need the db edits is all.

Thanks!
i can sell it
Drabur is offline  
Old 08/23/2016, 17:47   #4
 
elite*gold: 0
Join Date: Jul 2016
Posts: 36
Received Thanks: 17
Quote:
Originally Posted by Drabur View Post
i can sell it
I'm not buying sql changes lol.

Quote:
Originally Posted by Avalion View Post
From the system I have of tabbed inventory, it is a bit messy but it is something probably like so.


CDbManager::SendPlayerList
-> Sends S2 to character str
-> It is requesting m_Inventory, m_Inventory2, m_Inventory3, m_Inventory4
-> Requests 4 x the other inventory arrays.

Because it is requesting that data, we will need to add the values into the table "INVENTORY_TBL" and update the table to withhold the new varchar sizes.



CDbManager::Join
-> Moving on to further information, this function passes "S8" to the character str.
-> We Notice that this function also calls GetInventory which also expects having access to other table information that we have yet to come across. In S8, we will noticed it is "INVENTORY_EXT_TBL".
-> Because we are still pulling the new inventory, we need to add the values and then compensate the db for the new varchar lengths.


-> The values in the db could be more proper, but for this explanation I am multiplying the value by 4. Varchar in mssql cannot have a number if they are above 8000, thus varchar(max) had to be used.


If we load an inventory, we must save a players inventory, so
CDbManager::SavePlayer
-> Calls U1
-> Adds 3 params to the save, and binds parameter.

Now, the one that I have access too, looks like it stores the main column as 4 columns rather one and then multiplicates the rest by 4. Other than that, it also looks like it reads it all into one value after reading -- then having to separate on save.
Thanks will look into this
Lodelight is offline  
Old 08/23/2016, 17:57   #5
 
elite*gold: 0
Join Date: Jan 2014
Posts: 773
Received Thanks: 373
Quote:
Originally Posted by Avalion View Post
From the system I have of tabbed inventory, it is a bit messy but it is something probably like so.


CDbManager::SendPlayerList
-> Sends S2 to character str
-> It is requesting m_Inventory, m_Inventory2, m_Inventory3, m_Inventory4
-> Requests 4 x the other inventory arrays.

Because it is requesting that data, we will need to add the values into the table "INVENTORY_TBL" and update the table to withhold the new varchar sizes.



CDbManager::Join
-> Moving on to further information, this function passes "S8" to the character str.
-> We Notice that this function also calls GetInventory which also expects having access to other table information that we have yet to come across. In S8, we will noticed it is "INVENTORY_EXT_TBL".
-> Because we are still pulling the new inventory, we need to add the values and then compensate the db for the new varchar lengths.


-> The values in the db could be more proper, but for this explanation I am multiplying the value by 4. Varchar in mssql cannot have a number if they are above 8000, thus varchar(max) had to be used.


If we load an inventory, we must save a players inventory, so
CDbManager::SavePlayer
-> Calls U1
-> Adds 3 params to the save, and binds parameter.

Now, the one that I have access too, looks like it stores the main column as 4 columns rather one and then multiplicates the rest by 4. Other than that, it also looks like it reads it all into one value after reading -- then having to separate on save.
thats not all
Drabur is offline  
Reply


Similar Threads Similar Threads
Tabbed Inventory
11/14/2012 - Flyff Private Server - 2 Replies
Wäre es besser 4 Spalten in der BD zu machen oder die Inventory DB zu vergrößern? und besser aus m_Inventory nen array zu machen oder neue CWndItemCtrl pointer?, die alles aus m_Inventory kopieren?
[SHOW] Tabbed Inventory und Shopsystem
03/10/2012 - Flyff Private Server - 24 Replies
Hi Elitepvperzzzzzz... ich bin fast mit der Programmierung des Tabbed Inventorys fertig und wollte euch einfach mal zeigen, dass auch eine Privatperson und ein sogenannter "theoretischer" Programmierer in der Lage ist ein solches System zu programmieren. Flyff Tabbed Inventory - YouTube ...das System ist noch weit davon entfernt bugfrei zu sein: -das Speichern funktioniert noch nicht ganz ( der SQLString wird abgeschnitten ) -kleiner Bug durch schlampige Programmierung in der...
Request v17 Tabbed Inventory
03/10/2012 - Flyff Private Server - 2 Replies
Does anyone has the v17 tabbed inventory that they may share to our community or to me? It would be great if so. Just wondering if someone will, really appreciate it.
[VK] Tabbed Inventory (source)
02/18/2012 - Flyff Trading - 6 Replies
Da ich mit flyff aufhöre will ich hier mal das Tabbed inventory zum verkauf anbieten. Hier mal paar daten Info|Normal|Tabbed Slots|42|42 Tabs|1|4 SRO|ja|nein* GRO|ja|nein* CI|ja|ja RITEM|ja|ja



All times are GMT +1. The time now is 02:21.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.