[Guide] Most of vsro files problem solved here

[cogiakk1]

eror help me (

[raiden90]

Originally Posted by blackout069

I have same problem, can u tell me how u fixed it ?

[ichigo14000]

[raiden90]

Originally Posted by ichigo14000

for _ExistsServiceOffRentItem error in shardmanager execute this tablet in SRO_VT_SHARD have worked for me.

/****** 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

[blackout069]

How i can make me to GM ? i have in account db GMrank = 1 but in game i cant open console ^^

[seven16]

try (Shift+~) here works

[deadpirate]

Originally Posted by raiden90

for _ExistsServiceOffRentItem error in shardmanager execute this tablet in SRO_VT_SHARD have worked for me.

Tah I wonderd what that error was

[TyrannoKINGS]

Server is on CHECK, even tho I changed the service to "Operating" -.-'

[raiden90]

Originally Posted by TyrannoKINGS

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

[dimazapow]

Originally Posted by raiden90

for _ExistsServiceOffRentItem error in shardmanager execute this tablet in SRO_VT_SHARD have worked for me.

DONT WORK FOR ME:

here is the screen.

[ichigo14000]

Originally Posted by dimazapow

DONT WORK FOR ME:

here is the screen.

me to...

[TyrannoKINGS]

Originally Posted by raiden90

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

[Dr.Abdelfattah]

Originally Posted by dimazapow

DONT WORK FOR ME:

here is the screen.

execute it in the 3 databases

[TyrannoKINGS]

[dimazapow]

Originally Posted by abdelfattah

execute it in the 3 databases

what you mean with 3 databases ?