Nun mal meine Fragen :
Wer hätte mal die LOG_USER_CNT_STR für mich ?
Codequery:LOG_USER_CNT_STR '01', 0, 0 SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'LOG_USER_CNT_STR'.
Für mich nicht verständlich :
Code2010/10/20 20:48:53 ..\_Network\Misc\Include\ObjMap.h, 56 [COLOR=red]2010/10/20 20:48:53 ..\_DirectX\..\_Common\data.h, 72[/COLOR]Das Rot markierte wiederholt sich etwa um die 100 mal.
Zu guter letzt, die Debug Errors ?!
(Nicht nötig, aber eventuell versteht jemand von euch etwas...)Code2010/10/20 20:48:50 OP: 18627752, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0 2010/10/20 20:48:52 OP: 2426, 0.0, 0.0, 2425.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0
Das Data.h wird angezeigt wenn zu viele Objecte/Monster gespawnt sind.
UNd LOG_USER prozedur hier
Code
USE [LOGGING_01_DBF]
GO
/****** Objekt: StoredProcedure [dbo].[LOG_USER_CNT_STR] Skriptdatum: 10/26/2010 18:41:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[LOG_USER_CNT_STR]
@iserverindex CHAR(2),
@im_channel int,
@im_01 INT = 0,
@im_02 INT = 0,
@im_03 INT = 0,
@im_04 INT = 0,
@im_05 INT = 0,
@im_06 INT = 0,
@im_07 INT = 0,
@im_08 INT = 0,
@im_09 INT = 0,
@im_10 INT = 0,
@im_11 INT = 0,
@im_12 INT = 0,
@im_13 INT = 0,
@im_14 INT = 0,
@im_15 INT = 0,
@im_16 INT = 0,
@im_17 INT = 0,
@im_18 INT = 0,
@im_19 INT = 0,
@im_20 INT = 0
/***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************
LOG_USER_CNT_STR 스토어드
작성자 : 최석준
작성일 : 2003.12.19
***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************/
AS
set nocount on
DECLARE @os_date CHAR(14),@onumber INT
SELECT @os_date = CONVERT(CHAR(8),GETDATE(),112)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,GETDATE())),2)
SELECT @onumber = @im_01 + @im_02 + @im_03 + @im_04 + @im_05
+ @im_06 + @im_07 + @im_08 + @im_09 + @im_10
+ @im_11 + @im_12 + @im_13 + @im_14 + @im_15
+ @im_16 + @im_17 + @im_18 + @im_19 + @im_20
INSERT LOG_USER_CNT_TBL
(
serverindex,
s_date,
number,
m_channel,
m_01,
m_02,
m_03,
m_04,
m_05,
m_06,
m_07,
m_08,
m_09,
m_10,
m_11,
m_12,
m_13,
m_14,
m_15,
m_16,
m_17,
m_18,
m_19,
m_20
)
VALUES
(
@iserverindex,
@os_date,
@onumber,
@im_channel,
@im_01,
@im_02,
@im_03,
@im_04,
@im_05,
@im_06,
@im_07,
@im_08,
@im_09,
@im_10,
@im_11,
@im_12,
@im_13,
@im_14,
@im_15,
@im_16,
@im_17,
@im_18,
@im_19,
@im_20
)
RETURN
set nocount offDebug Error kannst du ignorieren.