Page 1 of 2

Tsuki Online Drop list

PostPosted: Tue Jun 11, 2019 7:22 am
by JDoeBoy
I set up the server, with the files I could find, and exported the individual tables. After exporting to Excel, I imported the tables into Access, and made the connections/quarries that made the following list.

item_drops_and.csv
(1.66 MiB) Downloaded 676 times


A lot can be done with it in the CSV format that it is in.

JD

PS; I released something similar years ago on these forums, only in Excel format, but I could not find it, so I remade the file.

Re: Tsuki Online Drop list

PostPosted: Tue Jul 09, 2019 3:55 am
by Tartie
Good day.....Sir, I think my reply is off topic but just want to ask I am trying to explore Tsuki Server...I try the skills I notice that some of the skill is not fix and also the 2nd Job Quest is not fix for Dealer to Artisan...just want to ask if your's is fix or just mine is missing out??

Thanks!!

Re: Tsuki Online Drop list

PostPosted: Sun Jul 14, 2019 2:42 pm
by Elyntra
Could of sworn I fixed them in the 2nd release.

Re: Tsuki Online Drop list

PostPosted: Thu Jul 18, 2019 2:24 am
by Tartie
Elyntra wrote:Could of sworn I fixed them in the 2nd release.


I did try killing more than 500 mobs "Stone Golems" for the artisan job just to test... and it doesn't work..also for the Hawker to Raider 2nd Job quest it never gives the quest item....or can you point me out what did I miss in setting it up?? thanks for the reply I thought you really stop visiting the forum...anyway happy to see your name here..God Bless!!

Re: Tsuki Online Drop list

PostPosted: Fri Jul 19, 2019 5:18 pm
by rl2171
I did notice not all the gates (or at least one of them) did not work.

Going from Paradise of RA to Geb Desert (if I recall the maps) it didn't work, but going the other way the way worked.

Is it something on the map that controls the gates, then you add the details in List_Telegates?

I did use the program that lmame wrote to export to the sql files, but still didn't work.

Re: Tsuki Online Drop list

PostPosted: Sat Jul 20, 2019 5:18 am
by Tartie
rl2171 wrote:I did notice not all the gates (or at least one of them) did not work.

Going from Paradise of RA to Geb Desert (if I recall the maps) it didn't work, but going the other way the way worked.

Is it something on the map that controls the gates, then you add the details in List_Telegates?

I did use the program that lmame wrote to export to the sql files, but still didn't work.



mine works.... I just work on the list_respawnareas.sql, I just wrote it's coords and other stuff and it works, when I enter gates to gates...try on that files maybe it will work..here is a screenshot from Geb Desert to Ramasses Mines....I hope I could help..

Re: Tsuki Online Drop list

PostPosted: Sat Jul 20, 2019 2:47 pm
by rl2171
Try Paradise of RA to Geb Desert. It works the other way, just not this way

I tried coords into the file and it didn't work.

That gate you did it to already worked :)

It has to go into the List_Telegates, the respawnareas one is when you die

Re: Tsuki Online Drop list

PostPosted: Mon Jul 22, 2019 3:20 am
by Tartie
rl2171 wrote:Try Paradise of RA to Geb Desert. It works the other way, just not this way

I tried coords into the file and it didn't work.

That gate you did it to already worked :)

It has to go into the List_Telegates, the respawnareas one is when you die



Oh...Sorry...my bad...but I guess really mine works..I was just ridding mount or even running from gates to gates it works..for Paradise of Ra and Geb mine works....my problem for now is this PVP thing in TG or in DOD name are Hot Red but characters can't attack...you have idea about this PVP thing???

Re: Tsuki Online Drop list

PostPosted: Mon Jul 22, 2019 1:12 pm
by rl2171
Tartie wrote:
rl2171 wrote:Try Paradise of RA to Geb Desert. It works the other way, just not this way

I tried coords into the file and it didn't work.

That gate you did it to already worked :)

It has to go into the List_Telegates, the respawnareas one is when you die



Oh...Sorry...my bad...but I guess really mine works..I was just ridding mount or even running from gates to gates it works..for Paradise of Ra and Geb mine works....my problem for now is this PVP thing in TG or in DOD name are Hot Red but characters can't attack...you have idea about this PVP thing???


Interesting yours works. I wonder if you have a different client than I do.

Would you post your list_telegates.sql file so I may compare them?

I extracted the info from my client and it didn't have the gate info in it, thus is why I think maybe different ones.

Thank you.

Re: Tsuki Online Drop list

PostPosted: Tue Jul 23, 2019 4:59 am
by Tartie
rl2171 wrote:
Tartie wrote:
rl2171 wrote:Try Paradise of RA to Geb Desert. It works the other way, just not this way

I tried coords into the file and it didn't work.

That gate you did it to already worked :)

It has to go into the List_Telegates, the respawnareas one is when you die



Oh...Sorry...my bad...but I guess really mine works..I was just ridding mount or even running from gates to gates it works..for Paradise of Ra and Geb mine works....my problem for now is this PVP thing in TG or in DOD name are Hot Red but characters can't attack...you have idea about this PVP thing???


Interesting yours works. I wonder if you have a different client than I do.

Would you post your list_telegates.sql file so I may compare them?

I extracted the info from my client and it didn't have the gate info in it, thus is why I think maybe different ones.

Thank you.



Sure...I will post it later...glad to help...later after work I will try to post it here asap....