Problem mit WL

02/22/2011 08:55 Magical-MultiGaming#1
Hallo liebe comi

habe heute ep5 auf den server gemacht und jetzt bekomme wir bei sachen ins wl legen und relogen bei der zeit ablauf auf 0 ist bekommen wir ein acc mit der meldung error 0 was kann das sein

Engliche :
Dear comi

have made today on the server ep5 and now we get to put things into wl and relog in time is to 0, we get an ace with the error message that the 0 can be


thanks you

Quote:
2011-02-21 23:30:35 PS_DBAGENT__system log start (DBAgent)

2011-02-21 23:30:39 connect game, Name=



2011-02-21 23:30:39 connect game, Name=



2011-02-21 23:32:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-21 23:32:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-21 23:32:54 ::SaveCharacter 15 Sauron ret=-1, qerr=-1, {?=call Usp_Save_User_StoredItem_Add_E(2,11,32187751587981 55777, 0, 25086,25,86, 0, 0,0,0,0,0,0,'', 2, '2011-02-21 22:11:52', 'D')}

2011-02-21 23:32:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-21 23:32:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-21 23:32:54 ::SaveCharacter 15 Sauron ret=-1, qerr=-1, {?=call Usp_Save_User_StoredItem_Add_E(2,11,32187751587981 55777, 0, 25086,25,86, 0, 0,0,0,0,0,0,'', 2, '2011-02-21 22:11:52', 'D')}

Quote:
//PS_DBAGENT__charsave log start (DBAgent)

--<begin>2011-02-21 23:32:54,Gimli,11,Sauron,15

{?=call usp_Save_Char_Info_E(15,70, 0,0, 7,9,28000,28000,28000,9, 40226,46080,9105, 69,53, 64000000,-44916163, 1440.679199,27.079994,369.531097, 0,200,0,0,0, 0,0,0,0)}

EXEC usp_Save_User_StoredMoney_E 2,11,2134875427

{?=call Usp_Save_Char_Item_Del_E(15,'3218775158798155777') }

{?=call Usp_Save_Char_Item_Mod_E(15,3218690483517718529, 1,6, 0, 0,0,0,0,0,0,'',54)}

{?=call Usp_Save_User_StoredItem_Add_E(2,11,32187751587981 55777, 0, 25086,25,86, 0, 0,0,0,0,0,0,'', 2, '2011-02-21 22:11:52', 'D')}

{?=call Usp_Save_Char_Skill_Mod_E(15,14,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,365,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,32,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,4,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,6,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,3,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,320,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,29,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,35,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,192,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,132,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,70,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,117,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,28,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,74,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,83,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,84,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,359,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,360,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,361,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,362,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,184,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(15,356,3,0)}

{?=call Usp_Save_Char_ApplySkill_Del_E(15,0,0,1)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,104,100,51)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,120,3,68)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,207,3,16954)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,208,3,16954)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,209,3,16954)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,215,1,6154)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,219,3,6154)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,220,3,6154)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,221,3,6154)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,286,3,2589206)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(15,228,1,282)}

EXEC usp_Save_Char_QuickSlot_Del_E 15

EXEC usp_Save_Char_QuickSlot_Add_E 15,0,0,100,35

EXEC usp_Save_Char_QuickSlot_Add_E 15,0,1,100,29

EXEC usp_Save_Char_QuickSlot_Add_E 15,0,2,100,70

EXEC usp_Save_Char_QuickSlot_Add_E 15,0,3,100,84

EXEC usp_Save_Char_QuickSlot_Add_E 15,0,4,100,83

EXEC usp_Save_Char_QuickSlot_Add_E 15,0,8,100,74

EXEC usp_Save_Char_QuickSlot_Add_E 15,0,9,100,192

EXEC usp_Save_Char_QuickSlot_Add_E 15,1,0,100,132

EXEC usp_Save_Char_QuickSlot_Add_E 15,1,1,100,117

EXEC usp_Save_Char_QuickSlot_Add_E 15,1,6,100,359

EXEC usp_Save_Char_QuickSlot_Add_E 15,1,7,100,360

EXEC usp_Save_Char_QuickSlot_Add_E 15,1,8,100,361

EXEC usp_Save_Char_QuickSlot_Add_E 15,1,9,100,362

--<end>2011-02-21 23:32:54,******,11,******,15
was kann das sein :(
02/22/2011 16:37 TumbsUp#2
welche dbs benutzt du denn?
02/22/2011 16:55 eQuiNoX.#3
Probier mal das hier auszuführen.

Quote:
USE [PS_GameData]
GO
drop procedure [dbo].[usp_Save_Char_Item_Add_E]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E ******/


CREATE Proc usp_Save_Char_Item_Add_E

@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@MaketimeZ varchar(50),
@Maketype char(1)

AS
DECLARE @Maketime as datetime
SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120)
--SET NOCOUNT ON

IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END

INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)

IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

--SET NOCOUNT OFF



GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
02/22/2011 19:34 Magical-MultiGaming#4
danke dir hat geklappt :)
02/23/2011 11:18 Magical-MultiGaming#5
hm also das mit dem wl geh immer noch nicht :( ka was das jetzt noch sein soll

hier mal die fehler meldung

hm so the wl with the
is still not: (ka what should now be even
this time the error message

: PS_GAMELOG__system.log :

Quote:
2011-02-23 11:07:02 PS_GAMELOG__system log start (GameLog)

2011-02-23 11:07:08 connect game

2011-02-23 11:08:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:08:30 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:08:30' ,107, 255,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '91.50.70.16','money=349445031, bank=0, cash=1000000','level=70,skp=9738,stp=243','s=25207 ,d=0,i=8,w=25000,r=20000,l=25000'

2011-02-23 11:08:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:08:30 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:08:30' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Enter',NULL,NULL,NULL

2011-02-23 11:09:19 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:09:19 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:09:19' ,113, 3219706853168578561,100033,NULL,50,NULL,NULL,NULL, NULL,NULL,NULL,'??????','PointItem','0,0,0,0,0,0 (Option:)','2011-02-23 11:09:19'

2011-02-23 11:09:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:09:20 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:09:20' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=349445031, bank=1713083297, cash=1000000, firstmoney=349445031','level=70,skp=9738,stp=243', 's=25207,d=0,i=8,w=25000,r=20000,l=25000'

2011-02-23 11:09:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:09:20 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:09:20' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Leave',NULL,NULL,NULL

2011-02-23 11:10:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:10:07 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:10:07' ,107, 255,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '91.50.70.16','money=349445031, bank=0, cash=1000000','level=70,skp=9738,stp=243','s=25207 ,d=0,i=8,w=25000,r=20000,l=25000'

2011-02-23 11:10:39 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:10:39 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:10:39' ,113, 3219707213945831425,100082,NULL,15,NULL,NULL,NULL, NULL,NULL,NULL,'????','PointItem','0,0,0,0,0,0 (Option:)','2011-02-23 11:10:39'

2011-02-23 11:10:40 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:10:40 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:10:40' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=349445031, bank=0, cash=999600, firstmoney=349445031','level=70,skp=9738,stp=243', 's=25207,d=0,i=8,w=25000,r=20000,l=25000'

2011-02-23 11:11:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:11:20 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:11:20' ,107, 255,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '91.50.70.16','money=349445031, bank=0, cash=1000000','level=70,skp=9738,stp=243','s=25207 ,d=0,i=8,w=25000,r=20000,l=25000'

2011-02-23 11:12:19 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:19 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 0,0,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:19',180, 1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'It emCreate','','name=?????,count=10',NULL

2011-02-23 11:12:19 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:19 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:19' ,111, 3219707677802299393,100054,10,NULL,NULL,NULL,NULL, NULL,NULL,NULL,'?????','ItemCreate','0,0,0,0,0,0 (Option:)','2011-02-23 11:12:19'

2011-02-23 11:12:21 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:21 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:21' ,112, 3219707677802299393,100054,NULL,NULL,NULL,NULL,NUL L,NULL,NULL,NULL,'?????','use_item','0,0,0,0,0,0 (Option:)-2011-02-23 11:12:19','bag=1,slot=0'

2011-02-23 11:12:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:24 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:24' ,121, 3219312437731852289,100165, 1,1,2, NULL,39,NULL,NULL,NULL,'30?????',NULL,'0,0,0,0,0,0 (Option:)','2011-02-22 20:46:27'

2011-02-23 11:12:26 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:26 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:25' ,121, 3219312295997997057,100165, 1,1,9, NULL,31,NULL,NULL,NULL,'30?????',NULL,'0,0,0,0,0,0 (Option:)','2011-02-22 20:45:59'

2011-02-23 11:12:27 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:27 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:27' ,121, 3219312248753291265,100165, 1,1,3, NULL,23,NULL,NULL,NULL,'30?????',NULL,'0,0,0,0,0,0 (Option:)','2011-02-22 20:45:47'

2011-02-23 11:12:28 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:28 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:28' ,121, 3219312283113357313,100165, 1,1,4, NULL,15,NULL,NULL,NULL,'30?????',NULL,'0,0,0,0,0,0 (Option:)','2011-02-22 20:45:57'

2011-02-23 11:12:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:30 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:30' ,121, 3219312197213683713,100165, 1,1,10, NULL,7,NULL,NULL,NULL,'30?????',NULL,'0,0,0,0,0,0 (Option:)','2011-02-22 20:45:35'

2011-02-23 11:12:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:31 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:31' ,121, 3219312424846950401,100165, 1,1,11, NULL,38,NULL,NULL,NULL,'30?????',NULL,'0,0,0,0,0,0 (Option:)','2011-02-22 20:46:24'

2011-02-23 11:12:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:33 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:33' ,121, 3219312188623749121,100165, 1,1,5, NULL,30,NULL,NULL,NULL,'30?????',NULL,'0,0,0,0,0,0 (Option:)','2011-02-22 20:45:33'

2011-02-23 11:12:50 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:50 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '*******',2,4,'[Sys-Admin]Convent-D', 70,64000000,69, 1749.026733,24.813026,233.865204, '2011-02-23 11:12:50' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=349445031, bank=0, cash=1000000, firstmoney=349445031','level=70,skp=9738,stp=243', 's=25207,d=0,i=8,w=25000,r=20000,l=25000'
: Dbagent :

Quote:
2011-02-23 11:07:04 PS_DBAGENT__system log start (DBAgent)

2011-02-23 11:07:08 connect game, Name=



2011-02-23 11:07:08 connect game, Name=



2011-02-23 11:09:19 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:09:19 SaveBuyPointItem 4 [Sys-Admin]Convent-D qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(2,4,0,'B1_GE0051 ','2011-02-23 11:09:19')}

2011-02-23 11:10:39 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:10:39 SaveBuyPointItem 4 [Sys-Admin]Convent-D qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(2,4,400,'B1_GE00 36','2011-02-23 11:10:39')}

2011-02-23 11:12:50 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:50 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:50 ::SaveCharacter 4 [Sys-Admin]Convent-D ret=-1, qerr=-1, {?=call Usp_Save_User_StoredItem_Add_E(2,2,321931219721368 3713, 7, 100165,100,165, 0, 0,0,0,0,0,0,'', 1, '2011-02-22 20:45:35', 'D')}

2011-02-23 11:12:50 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:50 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Fehler beim Konvertieren des varchar-Datentyps in datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2011-02-23 11:12:50 ::SaveCharacter 4 [Sys-Admin]Convent-D ret=-1, qerr=-1, {?=call Usp_Save_User_StoredItem_Add_E(2,2,321931219721368 3713, 7, 100165,100,165, 0, 0,0,0,0,0,0,'', 1, '2011-02-22 20:45:35', 'D')}
Quote:
//PS_DBAGENT__charsave log start (DBAgent)

--<begin>2011-02-23 11:12:50,MSConvent2,2,[Sys-Admin]Convent-D,4

{?=call usp_Save_Char_Info_E(4,70, 243,9738, 25207,0,20000,8,25000,25000, 55142,5858,4152, 69,9, 64000000,349445031, 1749.026733,24.813026,233.865204, 0,200,0,0,0, 200000,0,3,2)}

EXEC usp_Save_User_StoredMoney_E 2,2,0

{?=call Usp_Save_Char_Item_Del_E(4,'3219312437731852289,32 19312295997997057,3219312248753291265,321931228311 3357313,3219312197213683713,3219312424846950401,32 19312188623749121')}

{?=call Usp_Save_Char_Item_Del_E(4,'3219707677802299393',0 )}

{?=call Usp_Save_Char_Item_Add_E(4,3219707677802299393, 1,0, 100054,100,54, 0, 0,0,0,0,0,0,'', 9, '2011-02-23 11:12:19', 'S')}

{?=call Usp_Save_User_StoredItem_Add_E(2,2,321931219721368 3713, 7, 100165,100,165, 0, 0,0,0,0,0,0,'', 1, '2011-02-22 20:45:35', 'D')}

{?=call Usp_Save_User_StoredItem_Add_E(2,2,321931228311335 7313, 15, 100165,100,165, 0, 0,0,0,0,0,0,'', 1, '2011-02-22 20:45:57', 'D')}

{?=call Usp_Save_User_StoredItem_Add_E(2,2,321931224875329 1265, 23, 100165,100,165, 0, 0,0,0,0,0,0,'', 1, '2011-02-22 20:45:47', 'D')}

{?=call Usp_Save_User_StoredItem_Add_E(2,2,321931218862374 9121, 30, 100165,100,165, 0, 0,0,0,0,0,0,'', 1, '2011-02-22 20:45:33', 'D')}

{?=call Usp_Save_User_StoredItem_Add_E(2,2,321931229599799 7057, 31, 100165,100,165, 0, 0,0,0,0,0,0,'', 1, '2011-02-22 20:45:59', 'D')}

{?=call Usp_Save_User_StoredItem_Add_E(2,2,321931242484695 0401, 38, 100165,100,165, 0, 0,0,0,0,0,0,'', 1, '2011-02-22 20:46:24', 'D')}

{?=call Usp_Save_User_StoredItem_Add_E(2,2,321931243773185 2289, 39, 100165,100,165, 0, 0,0,0,0,0,0,'', 1, '2011-02-22 20:46:27', 'D')}

{?=call Usp_Save_Char_Skill_Mod_E(4,1,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,5,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,7,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,8,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,9,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,10,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,32,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,4,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,3,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,15,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,17,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,18,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,19,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,20,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,56,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,192,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,31,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,57,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,30,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,55,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,40,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,38,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,139,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,39,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,342,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,340,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,151,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,153,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,156,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,157,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,152,1,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,301,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,190,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,112,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,24,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,341,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,171,3,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,180,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,174,2,0)}

{?=call Usp_Save_Char_Skill_Mod_E(4,87,3,0)}

{?=call Usp_Save_Char_ApplySkill_Del_E(4,0,0,1)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(4,286,3,2477054)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(4,287,3,1234109)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(4,228,1,270)}

EXEC usp_Save_Char_QuickSlot_Del_E 4

EXEC usp_Save_Char_QuickSlot_Add_E 4,0,0,100,192

EXEC usp_Save_Char_QuickSlot_Add_E 4,0,1,100,31

EXEC usp_Save_Char_QuickSlot_Add_E 4,0,2,100,30

EXEC usp_Save_Char_QuickSlot_Add_E 4,0,3,100,139

EXEC usp_Save_Char_QuickSlot_Add_E 4,0,4,100,190

EXEC usp_Save_Char_QuickSlot_Add_E 4,0,5,100,112

EXEC usp_Save_Char_QuickSlot_Add_E 4,0,8,100,341

EXEC usp_Save_Char_QuickSlot_Add_E 4,0,9,100,301

EXEC usp_Save_Char_QuickSlot_Add_E 4,1,0,100,56

EXEC usp_Save_Char_QuickSlot_Add_E 4,1,1,100,57

EXEC usp_Save_Char_QuickSlot_Add_E 4,1,2,100,55

EXEC usp_Save_Char_QuickSlot_Add_E 4,1,3,100,38

EXEC usp_Save_Char_QuickSlot_Add_E 4,1,4,100,156

EXEC usp_Save_Char_QuickSlot_Add_E 4,1,5,100,39

EXEC usp_Save_Char_QuickSlot_Add_E 4,1,6,100,342

EXEC usp_Save_Char_QuickSlot_Add_E 4,1,7,100,340

EXEC usp_Save_Char_QuickSlot_Add_E 4,1,8,100,151

EXEC usp_Save_Char_QuickSlot_Add_E 4,1,9,100,40

EXEC usp_Save_Char_QuickSlot_Add_E 4,2,0,100,171

EXEC usp_Save_Char_QuickSlot_Add_E 4,2,7,100,87

EXEC usp_Save_Char_QuickSlot_Add_E 4,2,8,100,174

EXEC usp_Save_Char_QuickSlot_Add_E 4,2,9,100,180

--<end>2011-02-23 11:12:50,*******,2,********,4
kann mir da einer bitte helfen danke schon mal
I can as a thank you please help ever
02/23/2011 14:24 eQuiNoX.#6
Führ mal das hier aus.

Quote:
USE PS_GameLog;
GO
drop procedure [dbo].[usp_Insert_Action_Log_E]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E FIXED ********.com Twilight ******/

CREATE Proc usp_Insert_Action_Log_E



@UserID varchar(18),
@UserUID int,
@CharID int,
@CharName varchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
@ActionTimeZ varchar(50),
@ActionType tinyint,
@Value1 bigint = null,
@Value2 int = null,
@Value3 int = null,
@Value4 bigint = null,
@Value5 int = null,
@Value6 int = null,
@Value7 int = null,
@Value8 int = null,
@Value9 int = null,
@Value10 int = null,
@Text1 varchar(100) = '',
@Text2 varchar(100) = '',
@Text3 varchar(100) = '',
@Text4 varchar(100) = '',
@Sql nvarchar(4000) = '',
@yyyy varchar(4) = '',
@mm varchar(2) = '',
@dd varchar(2) = '',
@Bucket smallint = -1

AS
DECLARE @ActionTime as datetime
SELECT @ActionTime = CONVERT(datetime, @ActionTimeZ, 120)
SET @yyyy = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)


IF(LEN(@mm) = 1)
BEGIN
SET @mm = '0' + @mm
END

IF(LEN(@dd) = 1)
BEGIN
SET @dd = '0' + @dd
END

SET @Sql = N'
INSERT INTO PS_GameLog.dbo.ActionLog
(UserID, UserUID, CharID, CharName, CharLevel, CharExp, MapID, PosX, PosY, PosZ, ActionTime, ActionType,
Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4)
VALUES(@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4)'

EXEC sp_executesql @Sql,
N'@UserID varchar(18), @UserUID int, @CharID int, @CharName varchar(50),
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint,
@Value1 bigint, @Value2 int, @Value3 int, @Value4 bigint, @Value5 int, @Value6 int, @Value7 int, @Value8 int,
@Value9 int, @Value10 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO