bot replying idea

[develmax]

i wanna make a bot when someone send to the bot a message for example (!teleport), it executes a query

let's say the bot recorded the pm at sro_vt_shardlog..botlog

[akkas64]

Originally Posted by develmax

i wanna make a bot when someone send to the bot a message for example (!teleport), it executes a query

let's say the bot recorded the pm at sro_vt_shardlog..botlog

phBot plugins u can use.

[develmax]

Originally Posted by akkas64

phBot plugins u can use.

dude i meant by bot :: [BOT]EVENTS

[ScarOnline]

you can use or

[develmax]

Originally Posted by ScarOnline

you can use or

i got my own one.. i wanna know how to execute an query once someone pm the bot

[Mr.Awesome1337]

if your bot is saving incoming chat then you might create a procedure on the bot db that looks like

@16 varchar(65)
Declare @D int = (Select CharID from SRO_VT_SHARD.._Char where CharName16 = @16)
if (@Message like 'Teleport')
begin
Update SRO_VT_SHARD.._Char set Level = 135 where CharID = @D -- This is an example that will set character level to 135
Exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @16,ITEM_ETC_ARENA_COIN,1,0 -- This is an example that will add 1x Arena Coin to the character
end