[HELP]Flag Event / Battle Arena / Knight Quest

exghostcry · 03/10/2012, 23:02

Flag Event / Battle Arena / Knight Quest when time's up but dont go automatic to town. Help me pls

GameServer :

PHP Code:



2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[2]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[6]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[10]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[18]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[20]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[21]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[28]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[29]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[30]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[33]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[34]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[35]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[36]
2012-03-09    20:25:00    [SR_GameServer]    Async GameWorldQuery failed!!! TYPE[1] RequestorJID[38]




2012-03-09    20:55:00    [SR_GameServer]    {?=CALL _CharInstanceWorldDataMarkUpLastWorld(6693,1,1,1)}
2012-03-09    20:55:00    [SR_GameServer]    SQL Error State:42000, Native Error Code: 89, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Charid".
2012-03-09    20:55:00    [SR_GameServer]    {?=CALL _CharInstanceWorldDataMarkUpLastWorld(6693,1,1,1)}
2012-03-09    20:55:00    [SR_GameServer]    Query Error!!! Query Result : -1, Query : {?=CALL _CharInstanceWorldDataMarkUpLastWorld(6713,1,1,1)}
2012-03-09    20:55:00    [SR_GameServer]    SQL Error State:42000, Native Error Code: 89, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Charid".

Dr.Abdelfattah · 03/11/2012, 08:48

Did you use the cleaned database ?

Serenduk · 03/17/2012, 22:33

change [CharID] [int] NOT NULL,

to
[Charid] [int] NOT NULL, ?

i dont have this table _CharInstanceWorldDataMarkUpLastWorld
i do hhave _CharInstanceWorldData

some im missing a table if anyone knows and can share ?

edit i do have its under stored proceed

Code:

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_CharInstanceWorldDataMarkUpLastWorld]    Script Date: 03/17/2012 21:45:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER procedure  [dbo].[_CharInstanceWorldDataMarkUpLastWorld]
	@CharID			int,
	@WorldID		int,
	@LayerID		int,
	@Way			tinyint
AS 
	IF( EXISTS( SELECT WorldID FROM _CharInstanceWorldData WHERE CharID = @CharID and IsActivated = 1 ) )
	BEGIN
		UPDATE _CharInstanceworldData SET IsActivated = 0 WHERE Charid = @CharID
	END

	IF( NOT EXISTS ( SELECT WorldID FROM _CharInstanceworldData WHERE Charid = @Charid and WorldID = @WorldID ) )
	BEGIN
		RETURN 1
	END

	UPDATE _CharInstanceWorldData SET IsActivated = @Way WHERE CharID = @Charid and WorldID = @WorldID

	IF( @@ERROR != 0 )
	BEGIN
		RETURN @@ERROR
	END

	RETURN 1

but something must be wrog ie charid when its set to CharID