SR_ShardManager

[Only registered and activated users can see links. Click Here To Register...]
After 5second i got crash it, what i can do wrong? pls help, thanks

check again ini files

ok according to what i am seeing by the 42000 error code it seams like your char is set to log into a forbidden area or area that is not loaded by the gameserver , try changing the spawn point of your char back to china such as > 25000 reagion 1 x 1 y 1 z and then log back in or restart your server and if thats the problem and fixes it then you need to find out what area it is so that it can be fixed . hope this helps

Quote:

Originally Posted by mtnman33 ok according to what i am seeing by the 42000 error code it seams like your char is set to log into a forbidden area or area that is not loaded by the gameserver , try changing the spawn point of your char back to china such as > 25000 reagion 1 x 1 y 1 z and then log back in or restart your server and if thats the problem and fixes it then you need to find out what area it is so that it can be fixed . hope this helps

:facepalm: really ??? are u serious ?
can u read what is the problem ? SR_SHARD crash after 5 sec

(Check again your files)

or add me on skype i help u

this querry repaired my problem :) thx for help :)


/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end


GO