[REQUEST] SQL.dll and CLAN.dll working

[coca-cola]

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:

 

[-Fire-]

need help also =X

 

[nicktte]

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

 

[DarkKnightH20]

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/attachments/f286/44964d1190359640-unable-connect-post-about-here-sql.rar

 

[-Fire-]

Thanks PPPPPPPPPP :drinks_dr

 

[-Fire-]

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


tetris shy64 -> GAMESERVER\SQLEXPRESS <- or IP?

 

[DarkKnightH20]

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

 

[-Fire-]

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.

 

[DarkKnightH20]

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

 

[-Fire-]

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

 

[DarkKnightH20]

Sorry, I don't know about that part.

 

[bbchamps2000]

i dont think i ever did.

 

[microamazing]

@-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...:

2)and go to SQL Server "Configuration Manager", and make this:

To view the content, you need to sign in or register

3)and go to "SQL Server Surface Area Configuration", and make this:

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:

3) making DB and configuring the .ASP Files!
3a) making DB, see:

3b)and,rigth click buton mause in Sod2Db> new Query ! ... and writhe the "SOD2RecBySandurr" Db, and, click in EXECUTE, and you see:

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:

~~~~~~~~~~ =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 =/

 

[-Fire-]

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

To view the content, you need to sign in or register

 

[gmice]

GameManagent <--- this is a DB?

 

[microamazing]

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

 

[-Fire-]

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: microamazing voc

 

[microamazing]

***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!

 

[NemesisHell]

[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? [email protected]
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? [email protected]
qual IP vcs usam? o IP externo do servidor, o IP de rede ou o 127?
obrigado!

 

[Phatkone]

external, or what ever ur server is runing on.