Maybe a billing server error?

09/15/2011 22:38 deadpirate#1
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?
09/15/2011 22:53 kevin_owner#2
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.
09/15/2011 22:59 deadpirate#3
Code:
<%
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

Code:
'''''''''' 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?
09/15/2011 23:33 the_belgian#4
up
Waiting answer :D
09/15/2011 23:35 kevin_owner#5
should be fine.
09/15/2011 23:37 deadpirate#6
Quote:
Originally Posted by kevin_owner View Post
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..
09/15/2011 23:38 the_belgian#7
mmh still crashing after select char and press start
09/15/2011 23:39 InTerpoL05#8
where is the .asp files?
09/15/2011 23:41 raiden90#9
Quote:
Originally Posted by the_belgian View Post
mmh still crashing after select char and press start
+1 same
09/15/2011 23:46 3lyka#10
Whats wrong with IIS? Better and easy
09/15/2011 23:54 deadpirate#11
Quote:
Originally Posted by 3lyka View Post
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

[Only registered and activated users can see links. Click Here To Register...]
Working showing current time.. So the problems pure and simply some problem with the files it has no connection problems..

FIXED :D

/Request close ill post tut tmoz
09/17/2011 20:58 milliyet#12
how to do fixed? same error
09/17/2011 21:19 kevin_owner#13
Quote:
Originally Posted by milliyet View Post
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.
09/17/2011 22:11 milliyet#14
Quote:
<%
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

%>
Quote:
<!-- #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 ?