newuser
|
Last Activity: 04/03/2016 18:54
Mentions
| 09/10/2022 |
| 10:45 - melihxrist mentioned newuser in post Shaiya Raid Kill Share ...D_IDENTIFIER ON
GO
Create trigger [dbo].[NewCharsAdded] on [PS_GameData].[dbo].[_CreatedChars]
after INSERT
as
begin
SET NOCOUNT ON
declare oldk1 int, Newk1 int, UserUID INT, newuserUID INT, ChariD INT
set UserUID = (select UserUID from inserted) -- gets useruid from inserted row
SET ChariD = (select CHARID from inserted) -- gets char id from new inserted... |
| 12/05/2016 |
| 15:29 - D3vil Power mentioned newuser in post Random reward scroll #_TimedJob
if(@JobID= 'xxx') -- scroll id
begin
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] orderiD = NULL, userid = newuserID, pkgID = NULL, numsilk = 50, PRICE = NULL
set newJobID = @@identity
return newJobID
end
Try this ..
that's Scroll gift coin form ItemM... |
| 04/03/2016 |
| 01:23 - Deleted Posts |
