VSRO Server Files [v188]

Missing procedure and table


ShardDB _ExistsServiceOffRentItem Procedure

Spoiler:

USE [SRO_VT_SHARD]
GO

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

AccountDB SK_gamebang_ip

Spoiler:

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[SK_gamebang_ip] Script Date: 09/13/2011 12:05:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SK_gamebang_ip](
[ip] [int] NULL,
[capacity] [int] NULL
) ON [PRIMARY]

GO

@LegendaryDev

Thx for it.
Care to tell how to fix cert ? How do i fix the node thingy ?

regards
rogan12

Quote:

---

Originally Posted by CEZALAND

I fixed cert, so i can open Global Manager but when i try open Gateway Server or Download Server;

Code:

---

cannot certify server body : [GatewayServer][x.xxx.xxx.xxx]

---

---

Nice :)
If my .ini files works with you
so here is a link for rogan :rolleyes:
inis.zip

Quote:

---

Originally Posted by Nah001

Skellyhand your problem is odbc add this to registry and DSN names add in System Dsn as Sql driver

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\SRO_VT_ACCOUNT]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="your name"
"Database"="SRO_VT_ACCOUNT"
"LastUser"="sa"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\SRO_VT_LOG]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="your name"
"Database"="SRO_VT_LOG"
"LastUser"="sa"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\SRO_VT_SHARD]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="your name"
"Database"="SRO_VT_SHARD"
"LastUser"="sa"
"Trusted_Connection"="Yes"

---

Already tried that :)

Quote:

---

Originally Posted by LegendaryDev

Missing procedure and table


ShardDB _ExistsServiceOffRentItem Procedure

Spoiler:

USE [SRO_VT_SHARD]
GO

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

AccountDB SK_gamebang_ip

Spoiler:

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[SK_gamebang_ip] Script Date: 09/13/2011 12:05:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SK_gamebang_ip](
[ip] [int] NULL,
[capacity] [int] NULL
) ON [PRIMARY]

GO

---

did u got the missing procedure "_AddCurrentUserCount"?

btw, thanks for _ExistsServiceOffRentItem sp.


pd: at sk_gamebang_ip, should i change ip - int to ip - varchar(15)?

I'm going to try it with another version of mssql because i have done EVERYTHING i can possibly do. I'll install MSSQL but the normal one not r2.

Quote:

---

Originally Posted by rogan12

@LegendaryDev

Thx for it.
Care to tell how to fix cert ? How do i fix the node thingy ?

regards
rogan12

---

ini.rar

my configs

Quote:

---

Originally Posted by CEZALAND

I using YasserLotfy's ini files and server.cfg:blink:

---

Can you link me?

The problem with "failed to receive silk data" is that, like you have to set up billing asp scripts on your IIS server, and link it at server.cfg.

Quote:

---

Originally Posted by Skellyhand

I'm going to try it with another version of mssql because i have done EVERYTHING i can possibly do. I'll install MSSQL but the normal one not r2.

---

i have 2008 R2 and db connecting,check your tcp settings

Quote:

---

Originally Posted by rogan12

@LegendaryDev

Thx for it.
Care to tell how to fix cert ? How do i fix the node thingy ?

regards
rogan12

---

working for me, feel free to check with your own files

btw i'm stuck at the "billingdead thingy" , i cannot get SR_ShardManager works for me.

SR_ShardManager said: Failed to initialize billing server: can't open URL! and then module crashes.

BILLING_SERVER_URL "http://192.168.0.102:80/" <<- extracted from server.cfg, anyway i added it too.

waiting for any feedback, thanks.

Quote:

---

Originally Posted by Y@$$ER LOTFY

Nice :)
If my .ini files works with you
so here is a link for rogan :rolleyes:
inis.zip

---

Quote:

---

Originally Posted by CEZALAND

I using YasserLotfy's ini files and server.cfg:blink:

---

Quote:

---

Originally Posted by Skellyhand

Can you link me?

---

Already posted before :blink:

Quote:

---

Originally Posted by Nah001

i have 2008 R2 and db connecting,check your tcp settings

---

To late anyway, I'm already installing 2008. It's not my TCP settings unless you're talking about ports.. but im running it locally so that's not an issue. I'm familiar with this type of issue though it's happened in the past but i can't seem to solve it on my own.

Quote:

---

Originally Posted by LegendaryDev

ini.rar

my configs

---

Thx for the files.
I changed ip , username, pw and db withing those ini's.
Still when i launch cert.bat i get this message.
Could not locate a "Certification Manager" node type.
I use the latest certification archive that was uploaded, now tried a lot of different ini's, with the same result.

regards
rogan12

Quote:

---

Originally Posted by rogan12

Thx for the files.
I changed ip , username, pw and db withing those ini's.
Still when i launch cert.bat i get this message.
Could not locate a "Certification Manager" node type.
I use the latest certification archive that was uploaded, now tried a lot of different ini's, with the same result.

regards
rogan12

---

Have you tried mine?