a thought maybe an idea

[josh2k7]

OK so i had a thought and i know a lot of players would agree with me on this idk about server owners or Dev's but my thought is this when a player uses a scroll it has a timer for 1 hour but when the player logs out the timer stops so i was wanting to make it so all cash shop items do the same cause if a player disconnects or cant play for a certain amount of time they will loose there cash shop items because of the timer on cash shop items not stopping on log out so i was wondering if this is even possible to do ?

[MentaL]

[Crystalz]

A timer on cashshop items? Why even have that?

I'm sorry, I just don't understand what you mean with timer. Scrolls has a timer for 1 hour?

[ThePunisher]

A timer on cashshop items? Why even have that?

So that the duration of the item(s) doesn't decrease when you're logged out, just like scrolls as he mentioned above.

[Crystalz]

So that the duration of the item doesn't decrease when you're logged out, just like scrolls as he mentioned above.

Oooh.. well I don't think that's possible.

[ThePunisher]

Oooh.. well I don't think that's possible.

That's what he wanted to know xD, let's see if anyone else has a different opinion.

[Crystalz]

That's what he wanted to know xD, let's see if anyone else has a different opinion.

You might be able to do something with the playTime column in the tLogout table inside AccountLog.

Like, you might be able to make it so that it reads off of tLogout, it adds the numbers in playTime up until it reaches let's say, 30 days(43 200 minutes). It might work since it also has a column called charNo not just userNo.

Some how..

I'm not saying it will work. It's just a suggestion.

[d4xyjen]

its Possible but would need effort well you can use the Logout procedure to subtract the remaining value of the buff duration since it uses date and time format then you would also need to modify the acccount login procedure so that before he selects a world you can modify the charged item or buff duration. Cause you cannot add something at character login procedure this must be done before he selects a character.

[josh2k7]

ok well my thought is this there is a file that controls the timer of scrolls couldn't i just add the items from the cash shop into it and remove them from charged effect or set the timer in charged effect to 0 so the other timer takes over?

[Charisma Doll]

That lowers profit from items donated for with duration. :/

[josh2k7]

honestly it does lower it some but at the same time it will benifit cause ppl will know u get 100% of the time they paid for no more no less

[Charisma Doll]

It won't benefit you at all. The only way I can think of something like that benefiting one financially is if attracts more players to the server.

[Myth]

its Possible but would need effort well you can use the Logout procedure to subtract the remaining value of the buff duration since it uses date and time format then you would also need to modify the acccount login procedure so that before he selects a world you can modify the charged item or buff duration. Cause you cannot add something at character login procedure this must be done before he selects a character.

Nailed it, however, I think it'd cause problems with the zone since the zone also runs from memory.

Eg: Even if you were to have the database update and save the time as they logout, it'd cause the world manager to still presume the timer is ticking, since it's also a hardcoded function within the world manager.

It'd require some trial and error, one method would be to have it insert 1 more field (using getdate()) when the item has been used for the first time to then compare with the end date of the item, which then you can have it insert a date based on the duration (difference between getdate() and end date = data entered into the new column within the database), from there on you could edit the procedure that gathers a players timed buffs (tCharacterChargedBuffer) and instantly compare based on duration, then rather then returning the end date, you extend the end date returned using the duration. (if end date =< duration == set new end date = getdate() + duration left)

Probably sounds confusing, but in my head I've got an idea of a way to achieve it, id assume that the world manager would be the bigger problem rather than the database side.

[josh2k7]

that make sense myth i have been toying with it my self and i have yet to have any results on it fully working past 1 hour