Create a new Table with this SQL Script:
Code:
USE [CHARACTER_01_DBF]
GO
/****** Object: Table [dbo].[CHARACTER_SAVE] Script Date: 09/23/2013 00:11:20 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CHARACTER_SAVE]') AND type in (N'U'))
DROP TABLE [dbo].[CHARACTER_SAVE]
GO
USE [CHARACTER_01_DBF]
GO
/****** Object: Table [dbo].[CHARACTER_SAVE] Script Date: 09/23/2013 00:11:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CHARACTER_SAVE](
[m_idPlayer] [char](7) NOT NULL,
[serverindex] [char](2) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
then goto
CHARACTER_STR and edit it.
Search for
and add above
Code:
DECLARE @Exists int
this
Code:
if exists (select * from [CHARACTER_SAVE] where [m_idPlayer] = @im_idPlayer and [serverindex] = @iserverindex)
begin
select fError = '1', fText = 'You can not delete this character!'
return
end
Example entry:
This should work. Hope this helps you.
