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

r4full · 10/07/2011, 15:12

working perfect

thanks , i just use php reg and not asp

.

btw there no easy way to change exp etc rates ?
only with OllyDbg ?

~~hisbola~~ · 10/07/2011, 16:01

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

xFlyer · 10/07/2011, 17:44

Yo guys how did you fixed DC bug?
After login with char to game it's get disconnect, how to fix this?

nandatun · 10/07/2011, 18:25

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!

the_belgian · 10/07/2011, 18:28

@hisbola
Just execute the query

@xFlyer,nandatun
I'm pretty sure it's a xtrap prob , look in your agentserver and tell me

fiction12 · 10/07/2011, 18:38

Quote:

Originally Posted by nandatun

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.

zikor1337 · 10/07/2011, 19:08

Quote:

Originally Posted by the_belgian

@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

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

the_belgian · 10/07/2011, 19:14

Maybe they don't use your files, just post here you know what i mean ...

fiction12 · 10/07/2011, 19:32

Quote:

Originally Posted by zikor1337

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.

zikor1337 · 10/07/2011, 19:37

Quote:
Originally Posted by fiction12
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"

fiction12 · 10/07/2011, 19:40

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

%>

zikor1337 · 10/07/2011, 19:48

Quote:

Originally Posted by fiction12

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;"

fiction12 · 10/07/2011, 19:49

Thanks it works, i cant believe that made me lost 2 days rofl thanks zikor1337...

baddarkness · 10/07/2011, 21:34

zikor1337 thank you your guide is verry usefull and my server works now !!

~~N900i~~ · 10/07/2011, 22:23

Is it Possible to clean up those DB's from useless accounts and other ****?