Auto Teleport scroll

10/07/2013 22:37 Royalblades#31
Phoenix.... delete the eventid stuff... let ppl find out themselves. I left it out on purpose.
10/10/2013 18:52 Herovans#32
Some hints for you.
1 -Create teleport scroll
2 -_AddLogItem
3 - IF ( @ItemRefID = XX)
4 -Your query.
5 -Profit??
10/10/2013 18:53 Lifestyler.#33
If you actually need help write me a PM i try to help you
10/10/2013 21:01 Royalblades#34
Quote:
Originally Posted by Herovans View Post
Some hints for you.
1 -Create teleport scroll
2 -_AddLogItem
3 - IF ( @ItemRefID = XX)
4 -Your query.
5 -Profit??
Completely USELESS hints xD
Cant believe you even wrote it.

_AddLogItem does NOT log the USE of a NEW type of teleport scroll.
@ItemRefID does NOT contain the id of the scroll either.
"Your Query." WILL NOT be able to teleport anyone from ingame.
There will NOT be any "profit" since the shit wont work.

Mr Herovans... USELESS comment.
10/10/2013 21:33 Herovans#35
Quote:
Originally Posted by Royalblades View Post
Completely USELESS hints xD
Cant believe you even wrote it.

_AddLogItem does NOT log the USE of a NEW type of teleport scroll.
@ItemRefID does NOT contain the id of the scroll either.
"Your Query." WILL NOT be able to teleport anyone from ingame.
There will NOT be any "profit" since the shit wont work.

Mr Herovans... USELESS comment.
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.
10/10/2013 22:10 Royalblades#36
Quote:
Originally Posted by Herovans View Post
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?
10/10/2013 22:33 Herovans#37
Maybe i missunderstand you..

But i already explained my way how to do it via teleport scroll.

"There is no ItemLog created for using a Teleportscroll"= actually it does ,Please try it yourself.

it was a simple idea of using a teleport scroll to execute query.

Anyway i got your point, you want we create something instead of editing it.
Can you such features by using executable sql program to inject smc or sending packets with gm character etc.
10/10/2013 22:38 Royalblades#38
Quote:
Originally Posted by Herovans View Post
"There is no ItemLog created for using a Teleportscroll"= actually it does ,Please try it yourself.
There is a CharLog for using a Teleportscroll, not a Itemlog. Theres a difference between those two. Try it out yourself lol.
10/10/2013 22:49 magicanoo#39
It's very possible,took me 10minutes to figure it out.

As a testing,I edited the fast return scroll to give me -1 STR/INT after teleportation,and it worked like a charm,no skills/logs no shit :)

EDIT: However,some conditions must apply on that item,example: can't be sold/traded/stored and maxstack=1 in order to make it fully functional just like myth sro.
10/10/2013 22:52 Herovans#40
I can't believe myself!!! you don't know that there is Itemmlog for teleportscroll?

Ok log in game.

wooh wooh wait.

I was not very specified i meant by teleportscroll is instant return scroll.

it's make any difference sound for you? :)

Quote:
Originally Posted by magicanoo View Post
It's very possible,took me 10minutes to figure it out.

As a testing,I edited the fast return scroll to give me -1 STR/INT after teleportation,and it worked like a charm,no skills/logs no shit :)

EDIT: However,some conditions must apply on that item,example: can't be sold/traded/stored and maxstack=1 in order to make it fully functional just like myth sro.
Nice to know it worked with you.
10/10/2013 23:13 Royalblades#41
[QUOTE=Herovans;25359863]I can't believe myself!!! you don't know that there is Itemmlog for teleportscroll?

Ok log in game.

wooh wooh wait.

I was not very specified i meant by teleportscroll is instant return scroll.

it's make any difference sound for you? :)
/QUOTE]

Lol... yes there is a huge difference.