Register for your free account! | Forgot your password?

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

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

Advertisement
Bitcoin Dice Game


Command for changing Item ID in Database

Discussion on Command for changing Item ID in Database within the Flyff Private Server forum part of the Flyff category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: May 2011
Posts: 101
Received Thanks: 0
Command for changing Item ID in Database

Hello anyone got the sql command to change the item ID to a new ITEM ID that works for Inventory, Bag and Guild Warehouse?

I really appreciate your help.



campomanes25 is offline  
Old 08/27/2019, 08:06   #2
 
elite*gold: 0
Join Date: May 2019
Posts: 49
Received Thanks: 3
Hmmm the thought would be like this:

Query the database to look for the item id ex: 11323 and once found change it to 11324.


Fatcode is offline  
Old 08/27/2019, 19:13   #3
 
elite*gold: 0
Join Date: Jan 2009
Posts: 1,709
Received Thanks: 1,641
You should take a look at the following function, which was developed for this purpose - kinda:
Code:
BOOL CDbManager::Conv(LPCSTR lpFileName)
xTwiLightx is offline  
Old 08/28/2019, 13:50   #4
 
elite*gold: 0
Join Date: Mar 2008
Posts: 663
Received Thanks: 224
I've done before using replace function, it could be risky in some cases, but may work for you.

Code:
UPDATE CHARACTER_01_DBF.dbo.INVENTORY_TBL SET m_Inventory = REPLACE(m_Inventory, ',OldId,', ',NewId,') WHERE m_Inventory LIKE '%,OldId,%'
There is a chance of altering other item params like an item count that matches the id or something else, so use at your own risk.
alfredico is offline  
Reply



« HELP COMPILE | (Help) want to learn a few things »

Similar Threads Similar Threads
Command line interface working command
08/05/2012 - DarkOrbit - 27 Replies
I found only one working command: Enter "J" when you are in teleport Anyone know other commands?
Conquer_V2 ini to MySql item Database Command
01/11/2012 - CO2 Private Server - 2 Replies
` i do not want to spam the from with stuff so i am posting a ? here. in item the database item data what is Weight, Unknown1, Unknown2, Unknown3, what is the purpose of them?
[Guide] Just changing the drops of VIP maps without changing of its place
10/08/2010 - EO PServer Guides & Releases - 2 Replies
in revo's DB when u add the VIP tele it apears on the old market .. some ppl dont know how to change its place thats why i made this query for them delete from cq_generator where id >= 0113 and id <= 0128; INSERT INTO `cq_generator` VALUES ('0113', '8900', '0062', '0033', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000'); INSERT INTO `cq_generator` VALUES ('0114', '8900', '0072', '0037', '0001', '0001', '0001', '0025', '0001', '0110', '0000',...



All times are GMT +2. The time now is 21:56.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

BTC: 33E6kMtxYa7dApCFzrS3Jb7U3NrVvo8nsK
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

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