[Guide] Most of vsro files problem solved here

09/16/2011 13:07 cogiakk1#931
eror help me :(( [Only registered and activated users can see links. Click Here To Register...]
09/16/2011 13:07 raiden90#932
Quote:
Originally Posted by blackout069 View Post
I have same problem, can u tell me how u fixed it ?
[Only registered and activated users can see links. Click Here To Register...]
09/16/2011 13:11 ichigo14000#933
[Only registered and activated users can see links. Click Here To Register...]
09/16/2011 13:26 raiden90#934
Quote:
Originally Posted by ichigo14000 View Post
[Only registered and activated users can see links. Click Here To Register...]
for _ExistsServiceOffRentItem error in shardmanager execute this tablet in SRO_VT_SHARD have worked for me.

Quote:
/****** 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
09/16/2011 13:30 blackout069#935
How i can make me to GM ? i have in account db GMrank = 1 but in game i cant open console ^^
09/16/2011 13:31 seven16#936
try (Shift+~) here works
09/16/2011 13:33 deadpirate#937
Quote:
Originally Posted by raiden90 View Post
for _ExistsServiceOffRentItem error in shardmanager execute this tablet in SRO_VT_SHARD have worked for me.
Tah ;) I wonderd what that error was
09/16/2011 13:37 TyrannoKINGS#938
Server is on CHECK, even tho I changed the service to "Operating" -.-'
09/16/2011 13:40 raiden90#939
Quote:
Originally Posted by TyrannoKINGS View Post
Server is on CHECK, even tho I changed the service to "Operating" -.-'
go to the database in SRO_VT_ACCOUNT>open the tablet "_ShardService" and change shardID to 64
09/16/2011 13:44 dimazapow#940
Quote:
Originally Posted by raiden90 View Post
for _ExistsServiceOffRentItem error in shardmanager execute this tablet in SRO_VT_SHARD have worked for me.
DONT WORK FOR ME:

here is the screen.
[Only registered and activated users can see links. Click Here To Register...]
09/16/2011 13:48 ichigo14000#941
Quote:
Originally Posted by dimazapow View Post
DONT WORK FOR ME:

here is the screen.
[Only registered and activated users can see links. Click Here To Register...]
me to...
09/16/2011 13:49 TyrannoKINGS#942
Quote:
Originally Posted by raiden90 View Post
go to the database in SRO_VT_ACCOUNT>open the tablet "_ShardService" and change shardID to 64
Ah, thanks! :)




What do I have to type in after I opened the tablet "dbo._PrivilegedIP"?
I wrote all my IPs there, but seems like it does not freakin work.


[sro_gm1] login refused (GM cannot login from the PC that has not privileged ip) - 127.0.0.1
09/16/2011 13:51 Dr.Abdelfattah#943
Quote:
Originally Posted by dimazapow View Post
DONT WORK FOR ME:

here is the screen.
[Only registered and activated users can see links. Click Here To Register...]
execute it in the 3 databases ;)
09/16/2011 13:57 TyrannoKINGS#944
[Only registered and activated users can see links. Click Here To Register...]
09/16/2011 13:57 dimazapow#945
Quote:
Originally Posted by abdelfattah View Post
execute it in the 3 databases ;)
what you mean with 3 databases ?