Question about dynamic questing

[klaw]

After taking a look at Euphy's edit of Lunar's shop , it got me thinking:

 

What would be the easiest way to make the quest(s) able to take turn ins of single items at once towards a certain item? (in case players can't carry all of the reqs)

 

I know there's a quest script that does this already, but it would be ridiculous to make it store what each character gets individually.

 

I was thinking of creating a new table and having it store things there, unless you guys have a simpler solution?

 

Thanks in advance

[Euphy]

There aren't many options. It's easiest to just use character variables to store the count of an item, with name formatting like:

quest_total_<item id>

It would be fairly straightforward to use setd/getd in a dynamic script.

A separate SQL table will be slower, but if you're planning to have a lot of quests it'll be more efficient in the long run. (You don't want to end up with tons of character variables floating around.)

[klaw]

That's exactly what I was thinking Euphy. Probably 50ish quests total, that's a lot of character variables. 

[GmOcean]

Hmm, I thought about this before, but, you could always store the information into 1 Player Var using implode & explode combinations. I've written a script for this sort of thing before, but it mainly dealt with giving players random quest requirements than other people but for the same item. To make things unique.