SQLSTATE:42000 - could not find stored procedure WZ_QMK_InfoLoad
hello everyone , if anyone know the solution to fix this problem feel free to post it here.
All i know is that the error is coming from season 3 quest and i am running the files as season 2 , i log in , create char and play normally but i am not sure if this problem cause me some bugs or something else , about database now i got the original files database but maybe coders forgot to add this stored procedure.
Code:
SQLSTATE:420000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'WZ_QMK_Infoload'
SQLSTATE:420000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'WZ_QMK_InfoSave'
Re: SQLSTATE:42000 - could not find stored procedure WZ_QMK_InfoLoad
Code:
CREATE PROC [dbo].[WZ_QMK_InfoLoad]
@szCharName varchar(10)
As
Begin
BEGIN TRANSACTION
SET NOCOUNT ON
IF EXISTS ( SELECT CHAR_NAME FROM T_Quest_MonsterKill WITH ( READUNCOMMITTED )
WHERE CHAR_NAME = @szCharName )
BEGIN
SELECT QUEST_INDEX, MON_INDEX_1, KILL_COUNT_1, MON_INDEX_2, KILL_COUNT_2, MON_INDEX_3, KILL_COUNT_3, MON_INDEX_4, KILL_COUNT_4, MON_INDEX_5, KILL_COUNT_5
FROM T_Quest_MonsterKill WHERE CHAR_NAME = @szCharName
END
ELSE
BEGIN
INSERT T_Quest_MonsterKill VALUES ( @szCharName, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1 )
SELECT QUEST_INDEX, MON_INDEX_1, KILL_COUNT_1, MON_INDEX_2, KILL_COUNT_2, MON_INDEX_3, KILL_COUNT_3, MON_INDEX_4, KILL_COUNT_4, MON_INDEX_5, KILL_COUNT_5
FROM T_Quest_MonsterKill WHERE CHAR_NAME = @szCharName
END
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[WZ_QMK_InfoSave]
@szCharName varchar(10)
, @iQuestIndex INT
, @iMonsterIndex1 INT
, @iKillCount1 INT
, @iMonsterIndex2 INT
, @iKillCount2 INT
, @iMonsterIndex3 INT
, @iKillCount3 INT
, @iMonsterIndex4 INT
, @iKillCount4 INT
, @iMonsterIndex5 INT
, @iKillCount5 INT
As
Begin
BEGIN TRANSACTION
SET NOCOUNT ON
IF EXISTS ( SELECT CHAR_NAME FROM T_Quest_MonsterKill WITH (READUNCOMMITTED)
WHERE CHAR_NAME = @szCharName )
BEGIN
UPDATE T_Quest_MonsterKill
SET QUEST_INDEX = @iQuestIndex
, MON_INDEX_1 = @iMonsterIndex1
, KILL_COUNT_1 = @iKillCount1
, MON_INDEX_2 = @iMonsterIndex2
, KILL_COUNT_2 = @iKillCount2
, MON_INDEX_3 = @iMonsterIndex3
, KILL_COUNT_3 = @iKillCount3
, MON_INDEX_4 = @iMonsterIndex4
, KILL_COUNT_4 = @iKillCount4
, MON_INDEX_5 = @iMonsterIndex5
, KILL_COUNT_5 = @iKillCount5
WHERE CHAR_NAME = @szCharName
END
ELSE
BEGIN
INSERT T_Quest_MonsterKill VALUES ( @szCharName, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1 )
UPDATE T_Quest_MonsterKill
SET QUEST_INDEX = @iQuestIndex
, MON_INDEX_1 = @iMonsterIndex1
, KILL_COUNT_1 = @iKillCount1
, MON_INDEX_2 = @iMonsterIndex2
, KILL_COUNT_2 = @iKillCount2
, MON_INDEX_3 = @iMonsterIndex3
, KILL_COUNT_3 = @iKillCount3
, MON_INDEX_4 = @iMonsterIndex4
, KILL_COUNT_4 = @iKillCount4
, MON_INDEX_5 = @iMonsterIndex5
, KILL_COUNT_5 = @iKillCount5
WHERE CHAR_NAME = @szCharName
END
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Code:
CREATE TABLE [dbo].[T_Quest_MonsterKill] (
[CHAR_NAME] [varchar] (10) COLLATE Finnish_Swedish_CI_AS NOT NULL ,
[QUEST_INDEX] [smallint] NULL ,
[MON_INDEX_1] [smallint] NULL ,
[KILL_COUNT_1] [smallint] NULL ,
[MON_INDEX_2] [smallint] NULL ,
[KILL_COUNT_2] [smallint] NULL ,
[MON_INDEX_3] [smallint] NULL ,
[KILL_COUNT_3] [smallint] NULL ,
[MON_INDEX_4] [smallint] NULL ,
[KILL_COUNT_4] [smallint] NULL ,
[MON_INDEX_5] [smallint] NULL ,
[KILL_COUNT_5] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_Quest_MonsterKill] WITH NOCHECK ADD
CONSTRAINT [PK_T_Quest_MonsterKill1] PRIMARY KEY CLUSTERED
(
[CHAR_NAME]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_Quest_MonsterKill] ADD
CONSTRAINT [DF_T_Quest_MonsterKill1_QuestIndex] DEFAULT ((-1)) FOR [QUEST_INDEX],
CONSTRAINT [DF_T_Quest_MonsterKill_MON_INDEX_1] DEFAULT ((-1)) FOR [MON_INDEX_1]
GO