i Have been working on collctions for my server and hopefully it will help others as well

I have managed to import all 1174 collections(collections) n the game from live (although some cannot be used until if and when we are ready for next expansion or client) all 7601 collection items(collection_details) and all rewards,including coin, items and selectable items(collection_rewards) including getting the mapping correct to map to the correct items db entry(ID)

the only thing left is to get the remaining items imported from census there are several thousand of them i am missing

i was wandering if i could be pointed in the right direction for the item import from census so i could work that on this side so i can keep with the standard way of the itemization and the way they are entered on the db

thanks

side note, reason i did this is becuase when picking up shineys in the game the collection items that were being picked up did not match the collection they were tied to in the db so every collection item i was picking up said i had already collected even though i hadnt

There is no tool or anything to import items from the census, all of our items come from a packet logs that we collected around the CoE era so any items after that we just won't have.

I guess i'll write a tool then, starting with the missing collection items and rewards then

does the ADD button work to add a collection or am i missing something

Add button where? did you finally get into the web editor?

As far as I know there is no functional editor for collections yet.

the add button in the client when you examine a collection and you need it a button on the UI says ADD when you press it its supposed to add the collection item to the collection just like the COMMAND_COLLECTION_ADDITEM does, although the command is a pain since dont get item # and slot# easliy

Yea the functionality for collections should be in place just a complete lack of data so the add button should put that item into the collection.

well i think i have all the data now, but the button does not seem to work as intended

meaning for any collection item i have ie eagle feather, if i right click it and examine the collection window does come up and it knows what collection it will fit into, but when pressing the ADD button nothing appears to happen

Odd, I know I could finish some collections last time I tried, what client are you using?

I am using a COE client, i have a DOV client as well but i cant get it to patch until the patch server lets me loggin to back patch it

i have tried with both the COE and DOV , pressing the ADD button after examining a collection item, still does not add the item to the collection

I just tested on the emu server, I summoned "Oathstone of the Allectus Prime" (id of 10107 and first id I saw listed in collections) right clicked it and examine the collections window poped up clicked add and it was added to the collection and removed from my inventory. This was with CoE (data version 1208)

I switched to DoV (data version 1096) and used "Ironstein's Smithy Hammer" (id of 8423) and same results the add button put it in the collection and removed it from my inventory.

i have redownload and recompiled the SVN i have access to it shows verison 2657, from here https://svn.eq2emulator.net/svn/eq2server and get the same issue

is there a differnt location i should be downloading from such as a more recent devopeler version??

That is the public svn that most people should use. There is a dev svn that automatically pushes commits to the public svn every week though it looks like it stopped back in sept for some reason, I will get a hold of John to see if we can get that fixed. That being said public svn is only missing 4 commits and none of them touch collections, as far as I know collections have been working for a couple years now it just lacked data.

Are you doing the tests on your own server? If so can you log onto the emu server and do tests with the items I listed above and see if it works there?

ok i logged into the emu server, its says it version 0.7.3-dev compiled on 3-30-17 i summoned the same item numbet 10101 and it still did not work
my client version is COE and it is build 9378L

i tried with the backpatch DOv client but apparently the ui that we are supposed to use with it the like no longer works