dbo.CHECK_CHARS PROBLEM NEED HELP

09/13/2015 02:36 Ecrypter#1

Hi Epvpers., anyone know this problem.,?

PHP Code:


			
2015/09/13    08:24:52
query:{ call CHARACTER_01_DBF.dbo.CHECK_CHARS('Dado', '2') }
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'CHARACTER_01_DBF.dbo.CHECK_CHARS'.

every time i create new char database gives me an error, i know the problem is from the database., but i dont have files that check_character., anyone have this or know were i can find it?

thnx and advance,

09/13/2015 03:04 Flogolo#2

u use the aio db of sedrika? then execute the aio again, maybe it just missed :D

09/13/2015 05:19 -Venom'#3

Code:

CHARACTER_01_DBF.dbo.CHECK_CHARS

The CHECK_CHARS TBL is missing in your CHARACTER_01_DBF

You can use this script for your database

Code:

USE [CHARACTER_01_DBF]
GO

/****** Object:  StoredProcedure [dbo].[CHECK_CHARS]    Script Date: 06/01/2014 22:02:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[CHECK_CHARS] 
	@account VARCHAR(32) = '',
	@playerslot int = 0
AS
SET NOCOUNT ON
  SELECT * FROM CHARACTER_TBL WHERE account=@account AND playerslot = @playerslot AND isblock ='F'
SET NOCOUNT OFF

/* FOR CHARACTER OVERRIDE BUG */
GO