bot replying idea

09/29/2019 04:32 develmax#1

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

09/29/2019 05:00 akkas64#2

Quote:

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.

09/29/2019 06:09 develmax#3

Quote:

Originally Posted by akkas64

phBot plugins u can use.

dude i meant by bot :: [BOT]EVENTS

09/29/2019 22:55 ScarOnline#4

you can use [Only registered and activated users can see links. Click Here To Register...] or [Only registered and activated users can see links. Click Here To Register...]

09/29/2019 23:24 develmax#5

Quote:

Originally Posted by ScarOnline

you can use [Only registered and activated users can see links. Click Here To Register...] or [Only registered and activated users can see links. Click Here To Register...]

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

09/30/2019 04:50 Mr.Awesome1337#6

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

@[Only registered and activated users can see links. Click Here To Register...]16 varchar(65)
Declare @[Only registered and activated users can see links. Click Here To Register...]D int = (Select CharID from SRO_VT_SHARD.._Char where CharName16 = @[Only registered and activated users can see links. Click Here To Register...]16)
if (@Message like 'Teleport')
begin
Update SRO_VT_SHARD.._Char set Level = 135 where CharID = @[Only registered and activated users can see links. Click Here To Register...]D -- This is an example that will set character level to 135
Exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @[Only registered and activated users can see links. Click Here To Register...]16,ITEM_ETC_ARENA_COIN,1,0 -- This is an example that will add 1x Arena Coin to the character
end