webshop error, online users MU CORE

[Naks312]

I have this problem, when i try to buy a item this happen. (im offline in the server but this happend in the webshop)

Unable to buy this item, reason: your account is connected in game, please disconnect.

im trying to do with this to solve the problem, and i did it

UPDATE MEMB_STAT
SET Connect_Stat='0'
WHERE Connect_Stat>0

but i dont want to do this again again and again to buy a item, how can solve this to do automatic. Because when i reconnect, and try to buy a item the same error show to my users and me


Sorry for bad english

[MentaL]

[KarLi]

what webshop you use? the default by mucore?
maybe u can try another one and see if the problem relies on website module or files/db. @jacubb might help

[Naks312]

what webshop you use? the default by mucore?
maybe u can try another one and see if the problem relies on website module or files/db. @jacubb might help

yeah the default, my files are exteam (premium)

[Naks312]

what webshop you use? the default by mucore?
maybe u can try another one and see if the problem relies on website module or files/db. @jacubb might help

can you give me a pic of your sql MEMB_STAT CONNECTSTAT, because i dont know how to fix this maybe there is the problem

[KarLi]

memb_Stat

USE [MuOnline]
GO

/****** Object:  Table [dbo].[MEMB_STAT]    Script Date: 05/30/2016 08:24:28 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING OFF
GO

CREATE TABLE [dbo].[MEMB_STAT](
	[memb___id] [varchar](10) NOT NULL,
	[ConnectStat] [tinyint] NOT NULL,
	[ServerName] [varchar](50) NULL,
	[IP] [varchar](20) NULL,
	[ConnectTM] [smalldatetime] NULL,
	[DisConnectTM] [smalldatetime] NULL,
	[OnlineHours] [int] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[MEMB_STAT] ADD  CONSTRAINT [DF_MEMB_STAT_ConnectStat]  DEFAULT ((0)) FOR [ConnectStat]
GO

ALTER TABLE [dbo].[MEMB_STAT] ADD  DEFAULT ((0)) FOR [OnlineHours]
GO

u must re-create the table if u want to try out by deleting and running this query to recreate it (sql 2008)

also in database>programmibility>stored procedures> right click and modify dbo.WZ_CONNECT_MEMB
try to edit the whole code with

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_CONNECT_MEMB]    Script Date: 05/30/2016 08:27:43 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO


			ALTER PROCEDURE [dbo].[WZ_CONNECT_MEMB]
			@memb___id varchar(10) , 
		 @ServerName  varchar(50),
			@IP varchar(20)	
			 AS
			Begin	
			set nocount on
				Declare  @Find_id varchar(10) 	
				Declare  @Connectstat tinyint
				Set @Find_id = 'NOT'
				Set @Connectstat = 1

				select @Find_id = S.memb___id COLLATE Latin1_General_CS_AS from [MuOnline].[dbo].[MEMB_STAT] S INNER JOIN [MuOnline].[dbo].[MEMB_INFO] I ON S.memb___id = I.memb___id COLLATE Latin1_General_CS_AS
					   where I.memb___id = @memb___id COLLATE Latin1_General_CS_AS

				if( @Find_id = 'NOT' )
				begin		
					insert into [MuOnline].[dbo].[MEMB_STAT] (memb___id,ConnectStat,ServerName,IP,ConnectTM)
					values(@memb___id,  @Connectstat, @ServerName, @IP, getdate())
				end
				else		
					update [MuOnline].[dbo].[MEMB_STAT] set ConnectStat = @Connectstat,
								 ServerName = @ServerName,IP = @IP,
								 ConnectTM = getdate()
					 where memb___id = @memb___id COLLATE Latin1_General_CS_AS
			end

or just delete and re-create.

also database>programmibility>stored procedures> right click and modify this table called dbo.WZ_DISCONNECT_MEMB

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[WZ_DISCONNECT_MEMB]    Script Date: 05/30/2016 08:28:44 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

			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 
				Set @Find_id = 'NOT'
				select @Find_id = S.memb___id COLLATE Latin1_General_CS_AS from [MuOnline].[dbo].[MEMB_STAT] S INNER JOIN [MuOnline].[dbo].[MEMB_INFO] I ON S.memb___id = I.memb___id COLLATE Latin1_General_CS_AS
					   where I.memb___id = @memb___id

				if( @Find_id <> 'NOT' )
				begin		
					update [MuOnline].[dbo].[MEMB_STAT] set ConnectStat = @Connectstat, DisConnectTM = getdate(), OnlineHours = OnlineHours + DATEDIFF(hh,ConnectTM,getdate())
					 where memb___id = @memb___id
				end 
			end

after u do this changes close sql server and test.

[Naks312]

memb_stat

use [muonline]
go

/****** object:  Table [dbo].[memb_stat]    script date: 05/30/2016 08:24:28 ******/
set ansi_nulls off
go

set quoted_identifier on
go

set ansi_padding off
go

create table [dbo].[memb_stat](
    [memb___id] [varchar](10) not null,
    [connectstat] [tinyint] not null,
    [servername] [varchar](50) null,
    [ip] [varchar](20) null,
    [connecttm] [smalldatetime] null,
    [disconnecttm] [smalldatetime] null,
    [onlinehours] [int] not null
) on [primary]

go

set ansi_padding off
go

alter table [dbo].[memb_stat] add  constraint [df_memb_stat_connectstat]  default ((0)) for [connectstat]
go

alter table [dbo].[memb_stat] add  default ((0)) for [onlinehours]
go

u must re-create the table if u want to try out by deleting and running this query to recreate it (sql 2008)

also in database>programmibility>stored procedures> right click and modify dbo.wz_connect_memb
try to edit the whole code with

use [muonline]
go
/****** object:  Storedprocedure [dbo].[wz_connect_memb]    script date: 05/30/2016 08:27:43 ******/
set ansi_nulls off
go
set quoted_identifier off
go


            alter procedure [dbo].[wz_connect_memb]
            @memb___id varchar(10) , 
         @servername  varchar(50),
            @ip varchar(20)    
             as
            begin    
            set nocount on
                declare  @find_id varchar(10)     
                declare  @connectstat tinyint
                set @find_id = 'not'
                set @connectstat = 1

                select @find_id = s.memb___id collate latin1_general_cs_as from [muonline].[dbo].[memb_stat] s inner join [muonline].[dbo].[memb_info] i on s.memb___id = i.memb___id collate latin1_general_cs_as
                       where i.memb___id = @memb___id collate latin1_general_cs_as

                if( @find_id = 'not' )
                begin        
                    insert into [muonline].[dbo].[memb_stat] (memb___id,connectstat,servername,ip,connecttm)
                    values(@memb___id,  @connectstat, @servername, @ip, getdate())
                end
                else        
                    update [muonline].[dbo].[memb_stat] set connectstat = @connectstat,
                                 servername = @servername,ip = @ip,
                                 connecttm = getdate()
                     where memb___id = @memb___id collate latin1_general_cs_as
            end

or just delete and re-create.

Also database>programmibility>stored procedures> right click and modify this table called dbo.wz_disconnect_memb

use [muonline]
go
/****** object:  Storedprocedure [dbo].[wz_disconnect_memb]    script date: 05/30/2016 08:28:44 ******/
set ansi_nulls off
go
set quoted_identifier off
go

            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 
                set @find_id = 'not'
                select @find_id = s.memb___id collate latin1_general_cs_as from [muonline].[dbo].[memb_stat] s inner join [muonline].[dbo].[memb_info] i on s.memb___id = i.memb___id collate latin1_general_cs_as
                       where i.memb___id = @memb___id

                if( @find_id <> 'not' )
                begin        
                    update [muonline].[dbo].[memb_stat] set connectstat = @connectstat, disconnecttm = getdate(), onlinehours = onlinehours + datediff(hh,connecttm,getdate())
                     where memb___id = @memb___id
                end 
            end

after u do this changes close sql server and test.

woooorks perfeeeeeeeect
ty sir