[REQUEST] SQL.dll and CLAN.dll working

All the DLL that I use and configure for the SOD I system to function 100%, do not function no way, do not lead given to the SQL :bad:

need help also =X

All IP's should be 127.0.0.1
and on registry at
dbnameDBIP it's 127.0.0.1 too
mine is working 100% after it

This SQL.dll allows you to specify your SQL path. It was one of the few that actually worked for me--

http://forum.ragezone.com/attachment...t-here-sql.rar

Thanks :PPPPPPPPPPP :drinks_dr

One doubts, I place ServerName of the SQL or the IP


tetris shy64 -> GAMESERVER\SQLEXPRESS <- or IP? o.O

Try keeping it as SQL. So just replace GAMESERVER with what your SQL is called.

and in sql.reg in DbIP I place ServerName or IP?
where I will go to use 127.0.0.1 as nicktte spoke, in the SQL.reg and/or the SQL configuration to manager.

SERVER\SQLEXPRESS. But try 127.0.0.1 if that doesn't work.

I use SOD2RecBySandurr and in the SQL.dll you as SOD2Record%s%02d, I need to edit for SOD2RecBySandurr?

Sorry, I don't know about that part.

i dont think i ever did.

@-Fire-
not need adit this!

tutorial editing sql and clan .dll
------------------------------------------
1) open or clan.dll with hex!
2) go to offset : 00016660 editi it using ur ip!
3) go to offset :000166e0 and edit using db name ( not use Sa it Overload ur sql ! make a new!)
4) go to offset00016760 and edit using ur sql pass!
5) save!
----------------------------
1) editing sql.dll
2) open sql.dll with hex
3) press Ctrl+F and push source ( text string), u find : .\SQLEXPRESS
4) edit this place for : YURPCNAME\SQLEXPRESS ( here this dll find ur sql writhe sql name correcty!
5) go to offset : 0005e660 u find :GAMESERVER\SQLEXPRESS , EDIT ALL ( not source)
GAMESERVER\SQLEXPRESS !!!!!!!!!!!!* for UR IP*!!!!!!!
6) adit db user e db pass, u find in sql.dll db user :tetris and pass shy64 change for ur dbuser and pass.
7) go down... u find : ***site name****( same think ) editing for ur ip!
8) db user and db pass : go down and u see:
db name : PT_GF
db pass: 123
adit all (3)*** site name*** / PT_GF/123
for ur ip! db user and db pass
9) SAVE!

----------------------------------------------------------------
MOST IMPORTANT!
Editing ur sql!
for peoples, use the 2000 SQL, don't need edit for conect using the tcp/ip!
and for peoples, use the 2005 SQL server, i make a mini tutorial, for use this!
see:
1) for the SQL Server 2005, conect the Host 127....... you need configure this! see the images...:
http://img182.imageshack.us/img182/6018/sqlzc0.jpg
2)and go to SQL Server "Configuration Manager", and make this:
ImageShack 404 File not Found
3)and go to "SQL Server Surface Area Configuration", and make this:
http://img413.imageshack.us/img413/9...ver2005yq3.jpg
ok... now your SQL 2005 are configured for hosts...
!~!~!~!~!~!~!~!~!~!~!~ =D !~!~!~!~!~!~!~!~!~!~!~!~!
For sod ranks Work:
1)open your server...
2)and open "ClanSoDManager.exe" , and configure this:
http://img142.imageshack.us/img142/2456/sodsb7.jpg

3) making DB and configuring the .ASP Files!
3a) making DB, see:
http://img413.imageshack.us/img413/2209/db1tw7.jpg
3b)and,rigth click buton mause in Sod2Db> new Query ! ... and writhe the "SOD2RecBySandurr" Db, and, click in EXECUTE, and you see:
http://img355.imageshack.us/img355/8528/db2wz1.jpg
ok you SOD DB is creat!

3C) configuring the .ASP files!
see the images:
configure this file:
C:\Inetpub\wwwroot\ServerMain "SODsettings.asp" and "settings.asp"
C:\Inetpub\wwwroot\Clan "clanInsert.aspx"
C:\Inetpub\wwwroot\functions "database.asp"
see the image:
http://img100.imageshack.us/img100/7808/aspsg3.jpg
~~~~~~~~~~ =P~~~~~~~~~
and for finally make this reg! ( copy edit for ur sql name db user and db pass and past in notpad and save qith .reg )
_______________________________________________
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\PristonTale\GameServer]
"ServerName"="SPT"
"server1"="Database hosts"
"LogPath"="Path to Logs folder eg: C:\\Logs"
"AccountDbIP"="Database hosts"
"AccountDbID"="Database User"
"AccountDbPwd"="Database User Password"
"AccountDbName"="AccountDB"
"BillingDbIP"="Database hosts"
"BillingDbID"="Database User"
"BillingDbPwd"="Database User Password"
"BillingDbName"="BillingDB"
"BillingLogDbIP"="Database hosts"
"BillingLogDbID"="Database User"
"BillingLogDbPwd"="Database User Password"
"BillingLogDbName"="BillingLogDB"
"Database UserDbIP"="Database hosts"
"Database UserDbID"="Database User"
"Database UserDbPwd"="Database User Password"
"Database UserDbName"="Database UserDB"
"LogDbIP"="Database hosts"
"LogDbID"="Database User"
"LogDbPwd"="Database User Password"
"LogDbName"="GameLogDB"
"PCDbIP"="Database hosts"
"PCDbID"="Database User"
"PCDbPwd"="Database User Password"
"PCDbName"="PCRoom"
"PCCheck"="0"
"CountryCheck"="0"
"PCLogDbIP"="Database hosts"
"PCLogDbID"="Database User"
"PCLogDbPwd"="Database User Password"
"PCLogDbName"="PCRoomLog"
"ITEMLogDbIP"="Database hosts"
"ITEMLogDbID"="Database User"
"ITEMLogDbPwd"="Database User Password"
"ITEMLogDbName"="ITEMLogDB"
"SODDbIP"="Database hosts"
"SODDbID"="Database User"
"SODDbPwd"="Database User Password"
"SODDbName"="Sod2DB"
"SOD2DbIP"="Database hosts"
"SOD2DbID"="Database User"
"SOD2DbPwd"="Database User Password"
"SOD2DbName"="Sod2DB"
________________________________________________________
i think help all with this! and post here for samethin wrong! =P

tnks really to sandurr and sahgpub!
nicktte... baris...and many peoples ... i not remanber now =/

Not use \SQLEXPRESS has some problem if I, I use thus: SERVER and not SERVER\SQLEXPRESS ^^

As it has some links broken on SQL configuration to manager, below a photo of as this mine

http://images.cjb.net/385bc.jpg

GameManagent <--- this is a DB?

GameManagent is same of " logitem db " see he registry log os itens get !

I did not understand this part:
7) go down... u find : ***site name****( same think ) editing for ur ip!
8) db user and db pass : go down and u see:
db name : PT_GF
db pass: 123
adit all (3)*** site name*** / PT_GF/123
for ur ip! db user and db pass
9) SAVE!
@BR: [B]microamazing voc

***site name*** is a site have in enter of sql.dll and if i write here he as change for bads words.



[br] olha fire onde tem o h t t p : / / site xadasdx. com vc muda pro ip do seu server 123 eh o pass do sql
e na linha la eu disse q vc vai encontrar 3 valores desse tipo com o site db user e db pass
todos tenq ser editados!

[en] I am having problems to setup the sql.dll, I can't connect to server using it, I tried with lots of sets, like using 127.0.0.1 as the IP, using the hamachi's IP and using (name of my pc)\SQLEXPRESS...
can anyone add me on MSN to help? nemesis_knoxville@yahoo.com.br
what IP you all use? the server external ip, the network ip or 127?
thanks!

[br] eu to tendo problemas pra configurar o sql.dll, eu naum consigo conectar ao servidor usando isso, eu tentei de varias maneiras, tipo, usando 127.0.0.1 como o IP, usando o IP do Hamachi e usando (nome do meu pc)\SQLEXPRESS...
alguem pode me adicionar no msn pra ajduar? nemesis_knoxville@yahoo.com.br
qual IP vcs usam? o IP externo do servidor, o IP de rede ou o 127?
obrigado!

external, or what ever ur server is runing on.

Well, I tried with Hamachi's IP and didn't work...
I did the configuration on SQL Server that enables TCP/IP connections... Do I have to do any other thing?
What I have to do in Surface Area Connection? I couldn't see the image posted by Microamazing...

thanks

My sod system does not function with crown :/
it looks at this IMG of mine sql.dll and doors in the SQL configuration manager
SQL.reg -> http://images.cjb.net/bf706.jpg
SQL Configuration Manager -> http://images.cjb.net/b0df6.jpg
SQL.dll -> RapidShare: 1-Click Webhosting
what he can be, I made something wrong?
help me plz ^^
sry my bad English

I'm a tired drunken idiot right now, but I will try to explain this in the best, less confusing way possible.

SQL.dll is not required but reccomended to take over the use of using ODBC.

Problem with SQL.dll is that is doesn't recognize the connection to the data server instance.

In order to fix this you must specify your computers server name\ SQL instance name... hence SERVERNAME\SQLINSTANCE... for example, mine is GAMESERVER\SQLEXPRESS.

Yours might be BOB\PTDB or something like that. Pretty much just change the hex text values in the SQL.dll to that of your server. Make sure your server allows connections through named pipes using the MSSQL client utility. If not then try using the data source as 127.0.0.1;1433\SQLEXPRESS or whatever ip;port\instance your server is set to.

Well, How does this DLL works? It's:

1-The Client Request a connection
2-The server call the SQL.dll with the person ID,etc,etc
3-The Server reads all IP's that is in SQL.DLL and make a local connection to the SQL Server
4-The Server Requests the DATA that the client needs
5-The server send the DATA received to the client

It's correct?If not please ask Where Is my mistake and what is wrong(the number)

-.-

Use this SQL.reg, in SODDB and SOD2DB it leaves the 2 as its SOD2DB in SQL.reg

it edits its SQL.dll, it uses of sandurr 2,0, edits the IP for 127.0.0.1, to dbuser and dbpass and Databases, it uses source with /SQLEXPRESS (MMSQL)
It does not use no OBDC!!!!!!!!
open your SQL configuration manager, add TCP/IP
add for IP3 127.0.0.1 and selects "YES" in the remain

all the IP places dynamic for = 445 TCP Port = 1118

it only uses dynamic port 1433 and TCP port leaves blankin the IPAll

as this below

IPAll = Dynamic posrt: 1433
TCP Posrt: 0

thx :} sry for my bad english ;D

BR: GALERA NAO USE OBDC NENHUM, NO SQL.DLL EDITE OS DBPASS E DBUSER PARA O QUE VOCE CONECTA NO SQL, USE O SA RENOMEADO PARA SEU USER, POIS ELE TEM TODAS AS PERMISSOES =D

USE O SQL.REG QUE ESTA ALI EM CIMA, E EM SODDB E SOD2DB DEIXE COMO SEU SOD2DB

A PARTE DOS IP NO SQL CONFIGURATION MANAGER HABILITE "YES" PARA TODOS OS IPS, NO IP3 USE COMO 127.0.0.1 E NO IPALL TAMBEM USE 127.0.0.1 E COM DYNAMIC PORT = 1433 E O TCP PORT DEIXE EM BRANCO

O RESTANTE DOS IPS MENOS O IPALL DEIXE DYNAMIC PORT = 1118 E TCP PORT = 445

FOI ASSIM QUE EU CONSEGUI MEU SOD FUNFANDO ;D

AHHH LEMBRANDO QUE TEM QUE AS DBS TEM QUE ESTAR CORRETAS COM O SQL.DLL