1 ] Quest Generator NPC
I want a script where the player are able to Create Quest spending their Flux Credits Points.
These Generated Quest can be generated like Hunting Mission but what i want to do is store this data in SQL Database.
From 50 Credit - Easy to 100 Credit Difficult to 500 Credit Boss Hunt.
Check Available Credit before publishing the Quest.
It will Store Quest ID [Auto generated by sql] Flux Credit Rewarded [ for those who will take the quest] Publisher Account ID [The one who invest] Quest Taker Account ID\ Monster to kill or Item to get ID Target Amount [Kill / collect] Post Time date Completed Status or Status "0 Pending / 1 Completed".
It also enables the Publisher to check the status of its quest. "Waiting/Taken/Completed" and if Completed Delete or regenerate option.
Important: On Completion it gives a reward Kafra Cash Points to the Publisher which is Customizable.
NOTE: Its a Play2Earn System kinda thing. If you help me I will give a part of my earning as thanks giving.
2] Paid Quest Publisher NPC
Quest Can only be taken by Custom Currency Item.
This Npc Will retrieve any 5 random Paid Quest from the database criteria to oldest time posted. Or as you see fit.
Taken Quest will have Questers ID. Else if it is null or 0 the quest can be listed.
On completion It Gives an Reward Credit based on difficulty. Easy Mid, Hard, Boss. And Mainly this is important.
It will record completion status while adding Flux Credit Points to that Questers. Also Mail the Quest Publisher status completion or taken.