toggle key

[massiminodi4]

hi man!
i can t find a solution for toggle mode ( deco )


server still crash every time i use it.. what can i do?
thx

[muntaaka]

one has the same problem please help me ((

[mongreldogg]

think server crashes in case of overflow in hide_equip_flag column of dbo.Character table. or it even do not exist in your table.

please perform a crash again and send the last row of GameLog.txt here

[muntaaka]

 Spoiler

2014/08/22 19:55:57 onDeInit is called with SDS 0x00000000.
2014/12/13 19:49:58 onDeInit is called with SDS 0x00000000.
2014/12/13 20:26:40 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacterHideEquipFlag(dbo.smp_update_cha racter_hide_equip_flag) : Must declare the scalar variable "@iN_SID".
2014/12/13 20:28:33 DB COM ERROR(Thread:1, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacterHideEquipFlag(dbo.smp_update_cha racter_hide_equip_flag) : Must declare the scalar variable "@iN_SID".
2014/12/13 21:00:45 onDeInit is called with SDS 0x00000000.
2014/12/13 21:35:56 onDeInit is called with SDS 0x00000000.
2014/12/13 22:07:51 onDeInit is called with SDS 0x00000000.
2014/12/13 22:45:22 onDeInit is called with SDS 0x00000000.
2014/12/14 08:52:22 onDeInit is called with SDS 0x00000000.
2014/12/14 12:10:13 onDeInit is called with SDS 0x00000000.
2014/12/14 13:14:23 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacterHideEquipFlag(dbo.smp_update_cha racter_hide_equip_flag) : Must declare the scalar variable "@iN_SID".
2014/12/17 23:48:39 onDeInit is called with SDS 0x00000000.
2014/12/17 23:50:40 onDeInit is called with SDS 0x00000000.
2014/12/18 00:12:00 onDeInit is called with SDS 0x00000000.
2014/12/18 00:13:31 onDeInit is called with SDS 0x00000000.
2014/12/18 00:22:45 onDeInit is called with SDS 0x00000000.
2014/12/18 03:18:51 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacterHideEquipFlag(dbo.smp_update_cha racter_hide_equip_flag) : Must declare the scalar variable "@iN_SID".
2014/12/18 12:12:26 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacterHideEquipFlag(dbo.smp_update_cha racter_hide_equip_flag) : Must declare the scalar variable "@iN_SID".

[mongreldogg]

its an issue in stored procedure, take this:

 Spoiler

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_update_character_hide_equip_flag] Script Date: 18.12.2014 19:23:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- start of smp_update_character_hide_equip_flag
ALTER PROCEDURE [dbo].[smp_update_character_hide_equip_flag]
@IN_SID INT,
@IN_HIDE_EQUIP_FLAG INT
AS
SET NOCOUNT ON

UPDATE dbo.Character SET hide_equip_flag = @IN_HIDE_EQUIP_FLAG WHERE sid = @IN_SID

the problem is that your SQL server is case sensitive in declaration of variables, i think.
I have same procedure with same @iN_SID instead of @IN_SID but it all works nice fpr me anyways.

so just try the one i gave you ^^