Autor Topic: Add Goblin Coint follow real time online Season 12  (Visto 17 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline tinnhan247 on: April 15, 2019, 02:05:33 PM

  • *
  • Rank: Principiante
  • Posts: 29
  • Gracias recibida: 0
  • vn
Hello All Bro

I have a problem want you support.
About Goblin coint, I want to Add Goblin Coint follow real time online of server SS12
Please help me base on content of WZ_DISCONNECT_MEMB  :


USE [MuOnline]

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--
-- Definition for stored procedure WZ_DISCONNECT_MEMB :
--

ALTER PROCEDURE [dbo].[WZ_DISCONNECT_MEMB]
@memb___id varchar(10)
 AS
Begin   
set nocount on
   Declare  @find_id varchar(10)   
   Declare @ConnectStat tinyint
   Set @ConnectStat = 0      -- ?? ?? ? 1 = ??, 0 = ??X
   Set @find_id = 'NOT'
   select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id
          where I.memb___id = @memb___id

   if( @find_id <> 'NOT' )   -- ?? ?? ??? ?? ??? ???? ???? ??
   begin      
      update MEMB_STAT set ConnectStat = @ConnectStat, DisConnectTM = getdate()
       where memb___id = @memb___id
   end
end

----------------

Thanks you so much

 

Related Topics

  Subject / Started by Replies Last post
3 Replies
479 Views
Last post June 12, 2016, 12:09:08 AM
by ZabiinoOo
3 Replies
355 Views
Last post February 19, 2018, 10:06:22 AM
by rogeralexander
0 Replies
19 Views
Last post April 15, 2019, 07:57:36 AM
by Pedroo