PsYcH0TiK;202179 schrieb:
Nun mal meine Fragen :
Wer hätte mal die LOG_USER_CNT_STR für mich ?
Für mich nicht verständlich :
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...)
Das Data.h wird angezeigt wenn zu viele Objecte/Monster gespawnt sind.
UNd LOG_USER prozedur hier
Quellcode
- 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 off
Debug Error kannst du ignorieren.