Maybe a billing server error?

[deadpirate]

About 2 mins after game login and wandering about it disconnects me and then on SR_Gameserver i get

It takes time more than 0.5 Sec
Failed to getting silk data
Silk data loading failed [JID: 745525]
AQ Failed! Log out!!

Anyone had this or have a billing server fix to give?

[kevin_owner]

you have to change some .asp scripts.

there is a DB_connect.asp and change it to your sql server. and also a totalsilk.asp or whatever it's called that one also has an ip in it which needs to be changed.

[deadpirate]

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=GSINC-PC\SQLEXPRESS;Data Source=5.20.34.16x;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=1234;"
DBConnA.Open strConnectA

%>

I x'd last bit of ip but does that look correct? if not someone please correct.. the rest ive done

'''''''''' Check ACL only Call from Billing Server
Dim IP
Dim BillingServer
BillingServer = "5.20.34.16x"
IP = Request.ServerVariables("REMOTE_ADDR")
'If(IP <> BillingServer) Then
'	Response.Write "ACCESSDENY"
'	Response.End
'End If

The rest all have ip filled in correctly?

[the_belgian]

up
Waiting answer

[kevin_owner]

should be fine.

[deadpirate]

Originally Posted by kevin_owner

should be fine.

Nope.. Im trying a workaround now using XAMPP instead. Dont know if it will work though.. but it should make a proper live server file storage..

[the_belgian]

mmh still crashing after select char and press start

[InTerpoL05]

where is the .asp files?

[raiden90]

Originally Posted by the_belgian

mmh still crashing after select char and press start

+1 same

[3lyka]

Whats wrong with IIS? Better and easy

[deadpirate]

Originally Posted by 3lyka

Whats wrong with IIS? Better and easy

Cos xampp is actually working

EDIT: Regretted that and went back to IIS with help from google on proper setup..

Tested the file


Working showing current time.. So the problems pure and simply some problem with the files it has no connection problems..

FIXED

/Request close ill post tut tmoz

[milliyet]

how to do fixed? same error

[kevin_owner]

Originally Posted by milliyet

how to do fixed? same error

if you read the thread you'll find the answer.

ok short answer:

Go to the C:\inetpub\wwwroot\ folder and edit the db_connect.asp and the GetTotalSilk.asp.

The first one you need to change the database connection string and the second one the billing server ip. I don't know if there are more ip's in other files but you could check them but these 2 fixed it for me.

[milliyet]

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=CAN-PC\SQLEXPRESS;Data Source=CAN-PC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=1234;"
DBConnA.Open strConnectA

%>

<!-- #include file = "DBConnect.asp" -->
<!-- #include file = "Function.asp" -->
<!-- #include file = "Class_MD5.asp" -->
<%

On Error Resume Next

' Error
If Err.Number <> 0 Then
Response.Write "-1"
Response.End
End If

'''''''''' Check ACL only Call from Billing Server
Dim IP
Dim BillingServer
BillingServer = "192.168.2.2"
IP = Request.ServerVariables("REMOTE_ADDR")
'If(IP <> BillingServer) Then
' Response.Write "ACCESSDENY"
' Response.End
'End If
''''''''''
Dim sdSQL
Dim sdRS
Dim ReturnValue

sdSQL = "SET NOCOUNT ON EXEC CGI.CGI_WebGetTotalSilk "
'Response.Write sdSQL
'Response.End

Set sdRS = DBConnA.Execute(sdSQL)
ReturnValue = sdRS(0)

sdRS.Close
Set sdRS = Nothing
DBConnA.Close
Set DBConnA = Nothing

' Error
If Err.Number <> 0 Then
Response.Write "-1"
Response.End
End If
Response.Write ReturnValue
Response.End
%>

where is the error ?