[GUIDE] Setup a server without errors [1x GameServer]

10/07/2011 15:12 r4full#346
working perfect :) thanks , i just use php reg and not asp :).

btw there no easy way to change exp etc rates ?
only with OllyDbg ?
10/07/2011 16:01 hisbola#347
Hi Guys ..
Server works fine for me ~ only problem is, that the Grabpet Time (30 Days) is ended after a Relog or a Teleport.
I saw this one in this thread:
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
In DB SRO_VT_ACCOUNT i dont have a dbo._ExistsServiceOffRentItem - is this the DB fix for the Pet or what is wrong ?

I hope anyone can help me :)

Greetz

Hisbola
10/07/2011 17:44 xFlyer#348
Yo guys how did you fixed DC bug?
After login with char to game it's get disconnect, how to fix this?
10/07/2011 18:25 nandatun#349
yea ..... me too
I got the same error. Once after I login with the character straight away DC.
I already fixed my DBAccount.asp from billing according to what they said.
But still got the same problem.

Please someone help us. THx!
10/07/2011 18:28 the_belgian#350
@hisbola
Just execute the query

@xFlyer,nandatun
I'm pretty sure it's a xtrap prob , look in your agentserver and tell me ;)
10/07/2011 18:38 fiction12#351
Quote:
Originally Posted by nandatun View Post
yea ..... me too
I got the same error. Once after I login with the character straight away DC.
I already fixed my DBAccount.asp from billing according to what they said.
But still got the same problem.

Please someone help us. THx!
Having the same problem after login with the char DC and the Sr_GameServer drop this sentence...
Failed to getting silk data: unknown success code (1)
Silk Data Loading Failed [JID: 1]
AQ Failed! Log out!! [AQType: 9]

i've tryed everything and remade everything for the 3rd time... hope u guys can help us. thanks.
10/07/2011 19:08 zikor1337#352
Quote:
Originally Posted by the_belgian View Post
@hisbola
Just execute the query

@xFlyer,nandatun
I'm pretty sure it's a xtrap prob , look in your agentserver and tell me ;)
Can't be xtrap problems. These files contain cracked agentserver and cracked sro client.

Quote:
Originally Posted by fiction12 View Post
Having the same problem after login with the char DC and the Sr_GameServer drop this sentence...
Failed to getting silk data: unknown success code (1)
Silk Data Loading Failed [JID: 1]
AQ Failed! Log out!! [AQType: 9]

i've tryed everything and remade everything for the 3rd time... hope u guys can help us. thanks.
Show me your dbaccount.asp
10/07/2011 19:14 the_belgian#353
Maybe they don't use your files, just post here you know what i mean ...
10/07/2011 19:32 fiction12#354
Quote:
Originally Posted by zikor1337 View Post
Can't be xtrap problems. These files contain cracked agentserver and cracked sro client.



Show me your dbaccount.asp
Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=WIN7;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;1234;"
DBConnA.Open strConnectA

%>
btw im using urs, and some one told me that i need to change ip in GetTotalSilk.asp,PurchaseSilk.asp and RefundSilk.asp i did it still not working.
10/07/2011 19:37 zikor1337#355
Quote:
Originally Posted by fiction12 View Post
Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=WIN7;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;1234;"
DBConnA.Open strConnectA

%>
btw im using urs, and some one told me that i need to change ip in GetTotalSilk.asp,PurchaseSilk.asp and RefundSilk.asp i did it still not working.
What this means?

"Data Source=WIN7"
10/07/2011 19:40 fiction12#356
thats the name of the SQL server, i copied urs and change the name of the SQL server thats it..
this is urs...
Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;[B]Data Source=YOURPCNAME\SQLEXPRESS[/B];Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=your password;"
DBConnA.Open strConnectA

%>
this is mine...
Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=[B]WIN7;Initial Catalog[/B]=SRO_VT_ACCOUNT;user ID=sa;1234;"
DBConnA.Open strConnectA

%>
10/07/2011 19:48 zikor1337#357
Quote:
Originally Posted by fiction12 View Post
thats the name of the SQL server, i copied urs and change the name of the SQL server thats it..
this is urs...
Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;[B]Data Source=YOURPCNAME\SQLEXPRESS[/B];Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=your password;"
DBConnA.Open strConnectA

%>
this is mine...
Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=[B]WIN7;Initial Catalog[/B]=SRO_VT_ACCOUNT;[B]user ID=sa;1234;[/B]"
DBConnA.Open strConnectA

%>
user ID=sa;password=1234;"
10/07/2011 19:49 fiction12#358
Thanks it works, i cant believe that made me lost 2 days rofl thanks zikor1337...
10/07/2011 21:34 baddarkness#359
zikor1337 thank you your guide is verry usefull and my server works now !!
10/07/2011 22:23 N900i#360
Is it Possible to clean up those DB's from useless accounts and other crap?