Quote:
Originally Posted by Herovans
You have to think out of box.
He asked about scroll to remove stat points and teleport him instead of dc.
So he can create a teleport scroll that will teleport him to town in same time, it will execute the query for rest char stat points.
Just example to rest character skills
PHP Code:
IF ( @ItemRefID = 48003 AND @dwData = 65538 ) BEGIN EXEC SRO_VT_SHARD_INIT.dbo.[__reset_skill_by_CharID] @CharID = @CharID
@ItemRefID = teleport scroll id
You are a good developer so please don't think like that.
|
Don't worry, I always think outside the box, however your just so far outside the box, you aren't even sticking to the ground anymore.
Let me explain it:
There is no ItemLog created for using a Teleportscroll.
There is a CharLog created for using a teleportscroll.
The distinguishing part are the @Data1, @Data2 columns.
Those ones vary depending on the type of scroll used.
Unfortunatly it is not possible to create a completely "new" distinguishable type of return scroll. Therefore, you would need to "remove" one variety and keep it for exclusive use of stat resetting.
Thus, you are limiting the gameplay, instead of actually advancing with features. If you are truly open-minded you would have thought of that, wouldn't you?