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

0 Miembros and 1 Guest are viewing this topic.

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

  • 0 puntos por ventas
  • *
  • Rank: Dedicado
  • Posts: 38
  • Gracias recibida: 31
  • 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
537 Views
Last post June 11, 2016, 11:09:08 PM
by ZabiinoOo
3 Replies
450 Views
Last post February 19, 2018, 09:06:22 AM
by rogeralexander
0 Replies
49 Views
Last post April 15, 2019, 06:57:36 AM
by Pedroo