Custom items not loading

[scrubtasticx]

Hi I'm trying to add angel wings to my server I got all files in my grf correctly I have added wings to itemdb2 in sql and done all nessecary txt files and lub files when I get in game and @item 35000 it says invalid item number or name any reason why it wouldn't be adding it to db? And yes my client is diffed to have higher item numbers thanks guys I'm running newest rev of rathena 

[sader1992]

8 hours ago, scrubtasticx said:

My client has the diff load lua instead of iteminfo.lub but I'm my grf and data it's all lubs no lua at all so do I use iteminfo.lub or the 2idnum files?

 

[crazyarashi]

22 minutes ago, scrubtasticx said:

Hi I'm trying to add angel wings to my server I got all files in my grf correctly I have added wings to itemdb2 in sql and done all nessecary txt files and lub files when I get in game and @item 35000 it says invalid item number or name any reason why it wouldn't be adding it to db? And yes my client is diffed to have higher item numbers thanks guys I'm running newest rev of rathena 

Have you reloaded the itemdb? :))

[scrubtasticx]

Yes I have restarted the server like 5 times 

[Cyro]

Try your item id < 32k

As I remember itemdb supports max 32k  

Correct me if I am wrong

 

Edited August 14, 2017 by Cyro

[scrubtasticx]

I did I tried changing it to 1990 and still same results I have checked my 2 lub files and all three of the txt files and it all seems correct I mean even if I messed the accessory and acc lubs up the item should still load just no graphics right ? I'm super confused to why it's not loading 

[Cyro]

If the error says invalid item id it should be something wrong with item_db script recheck it

[scrubtasticx]

I put it in my itemdb2 the txt and the sql just to be safe they all look right to me but here is my entry 

 

REPLACE INTO `item_db2` VALUES (1990,'Angel_Wings','Angel Wings',5,5000,NULL,400,NULL,8,NULL,1,0xFFFFFFFE,7,2,4,NULL,NULL,1,3,'bonus2 bSubRace,7,10;',NULL,NULL);

Had no errors on query all looks good dunno

 

 

 

 

[sader1992]

put it in item_db

server/db/re/ = for re

server/db/pre-re = pre-renewal

show us the line you did add

do not use ID that already for another item (try 30000)

 

if you did change the server setting to read the sql

then add it on

item_db.sql =pre-re

item_db_re.sql = re

 

Edited August 14, 2017 by sader1992

[Scylla]

It's probably because you're adding it on your item_db SQL database.

You don't do it in SQL but inside your rA folder like @sader1992 mentioned:

7 minutes ago, sader1992 said:

put it in item_db

server/db/re/ = for re

server/db/pre-re = pre-renewal

show us the line you did add

do not use ID that already for another item (try 30000)

 

IIRC the server-side db's on SQL is only for Flux CP to display your stuff thru there.

Edited August 14, 2017 by Scylla

[Akkarin]

1 hour ago, Scylla said:

IIRC the server-side db's on SQL is only for Flux CP to display your stuff thru there.

Partially correct.

Having the dbs read from SQL instead of TXT means that you and your staff can just use something like FluxCP or PHPMyAdmin to edit things without needing to have access to the server's files.

[scrubtasticx]

i got the item to show but its completly wrong the guide is outdated for eathena i tried to make updated edits but i just dont know enough would anyone be kind enough to look at the wings i downloaded and tell me what i need to change in the 4 txt files and the accessory and accname lub? it was these wings 

https://rathena.org/board/files/file/2464-9-wings-from-the-past-made-in-2006/    (Just the Angel Wings)

 

thanks all for help much appreciated

Edited August 15, 2017 by scrubtasticx

[Scylla]

1 hour ago, scrubtasticx said:

i got the item to show but its completly wrong the guide is outdated for eathena i tried to make updated edits but i just dont know enough would anyone be kind enough to look at the wings i downloaded and tell me what i need to change in the 4 txt files and the accessory and accname lub? it was these wings 

https://rathena.org/board/files/file/2464-9-wings-from-the-past-made-in-2006/    (Just the Angel Wings)

 

thanks all for help much appreciated

Hmm, would you mind posting the lines you've edited for adding the wings from the following files:

accessory.lub and accname.lub

Also what client date are you using?

[Cyro]

this is best guide ever 

https://github.com/rathena/rathena/wiki/Custom_Items

you are using sql db or txt db? make sure which db u are using and edit accordingly 

//Use SQL item_db, mob_db and mob_skill_db for the map server
use_sql_db: no

if you are able to load items and getting sprite error, check sprite view in itemdb with accessoryid.lub

and resource file name in system/iteminfo.lub (if you are using 2013+ clients )

 

[scrubtasticx]

My client is 2015 so does that mean I edit the iteminfo.lub instead of all the idnum2 files? And do I still need to edit the accessory and accname lubs?

[sader1992]

14 minutes ago, scrubtasticx said:

My client is 2015 so does that mean I edit the iteminfo.lub instead of all the idnum2 files? And do I still need to edit the accessory and accname lubs?

@item failed = server side error

client crash after @item = client side error

and yes edit the iteminfo.lua or lub (the one u use) [ what you selected when u diffed with nemo use it]

[scrubtasticx]

My client has the diff load lua instead of iteminfo.lub but I'm my grf and data it's all lubs no lua at all so do I use iteminfo.lub or the 2idnum files?

[scrubtasticx]

I don't see how that helps all that's there are translated files which I have Already 

[sader1992]

if you already have the files then you already have the iteminfo.lua inside your game_folder\system\

[scrubtasticx]

i got it working thanks everyone! hehe