Sql.dll and clan.dll

[OcuK]

Hello i have problem with sql.dll and clan.dll , server online ,but no1 can't connect its Say's "Account Already IN" , can some1 help fix it ?

[MentaL]

[osirus]

If you are trying to establish a server for yourself and do not care about sod ranks and such, you do not need sql.dll. You can set up the server via ODBC and everything, including Clans, will work perfectly fine.

If you want Clan sod and such to be recorded, you need to have a properly working sql.dll. Please consult the posts made by Gregoory as he has graciously set up guides on that matter, and even setup a site that is configured to take your appropriate information and give you a configured sql.dll that matches your server. I do not think it can get easier than that ^^. The only other thing I have noticed from my personal experience is that in order for sql.dll to work properly, I have had to use Sandurr registration scripts released by Shagpub. As otherwise when using sql.dll, I received the message "Account Already In."

I understand that you are new here, but please do consult the many pages here on the Pristontale forum as all the questions that you are asking or looking answer for have already been answered. Also, there is the "Search" function as well :).

[Gregoo]

You might wanna check in your SQL server, accountdb database, *GameUser tables if the inuse field is set to 1.
Changing it to 0 could solve this problem.

[OcuK]

You might wanna check in your SQL server, accountdb database, *GameUser tables if the inuse field is set to 1.
Changing it to 0 could solve this problem.

thanks you gregory , but we need change to all accounts it to 0 or ??

[Gregoo]

Yep.
If the .dlls are working correctly, SQL.dll will register alot of information in the database and the "Account already logged in" problem will disappear, whether the inuse value is set to 0 or 1.
I think it's just for the first use with the working .dlls, the inuse value has to be 0 (:

Hint:

UPDATE [accountdb].[dbo].[AGameUser] SET [inuse]=0
UPDATE [accountdb].[dbo].[BGameUser] SET [inuse]=0
...
UPDATE [accountdb].[dbo].[ZGameUser] SET [inuse]=0

[35hit]

we using ur dl generator ,

[OcuK]

thanks , fixed !!