Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

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

0 Miembros and 1 Guest are viewing this topic.

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

  • 0 puntos por ventas
  • *
  • Rank: Dedicado
  • Posts: 38
  • Gracias recibida: 112
  • 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


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
6 Replies
1714 Views
Last post February 26, 2020, 05:37:46 PM
by Lil Kid
2 Replies
323 Views
Last post May 11, 2021, 11:06:31 AM
by walkeny
1 Replies
1116 Views
Last post October 07, 2021, 11:19:46 AM
by whisky123
0 Replies
357 Views
Last post October 19, 2021, 07:17:19 PM
by oliver1993a
0 Replies
291 Views
Last post January 06, 2022, 11:48:52 AM
by yejiunayangluo