[TuT]Community Release Drop fix for Windows 2003 server

Hycker · May 21, 2013

Unfortunately M$ doesnot support native clients for Windows 2003 server and Windows XP with MS-SQL server 2008. Means you cannot install Native Client drivers coz its answer, this operating system does not supported blablabla. There we need an unofficial driver for php.

PHP can connect to MS-SQL but cant do anything, thats why the lootconfig is not loading and you getting sco error in supervisor server log. For fix this follow this little tutorial.

1., check your php version
create a file name test.php and insert this to inside:

Code:

<?php
phpinfo()
?>

put this file this to wwwroot if IIE or htdocs if Abyss and open up with your favorite browser, like

You must be registered to see links

lets check on the top PHP Version X.X.XX (mine is 5.3.24)
and the extension_dir (mine is: C:\Program Files\PHP\ext)
if 5.3.24 download this zip -> View attachment php5.3.zip
unpack to anywhere, example: C:\
at end you get a php5.3 directory in C drive

now go to this directory and copy both file

Code:

php_pdo_sqlsrv_30_53_nts_vc9x86.dll
php_sqlsrv_30_53_nts_vc9x86.dll

to your php extension dir (mine is C:\Program Files\PHP\ext)
Go to your PHP installed directory (mine is C:\Program Files\PHP\), open php.ini and insert those lines at the end:

Code:

extension=php_sqlsrv_30_53_nts_vc9x86.dll
extension=php_pdo_sqlsrv_30_53_nts_vc9x86.dll

restart your webserver, open your favorite browser and open

You must be registered to see links

(if you changed the backend folder then change in address too)

and you should get

means php finaly can communicate with M$-SQL

those steps can be done with PHP 5.4 too, for it you need other files
this one -> View attachment php5.4.zip
method is same

driver source: View attachment phpdriversrc.zip

Credits to Rob for driver ->

You must be registered to see links

Credtis to DNC for community rlz
Credits to Vusion for original warz source
Credits to else whos working hard on it

edit: virustotal links for dll files
php5.3

You must be registered to see links

php5.4

You must be registered to see links

source

You must be registered to see links

Edit2: this way works on Windows XP SP3 too, i dont know how about older versions.
Anyway, XP is not recommended operating system for War Z server because support from M$ will end at next year. So keep way on Win2k3 or better.

KlausVander · May 21, 2013

Iiii love youuuu !!! Thanks !!!!

KING GUEVARA · May 21, 2013

good jop iwas waiting for a fix

but i have other problem

my os windows server 2008 r2

php 5.3.19

PHP:

Array (     [0] => Array         (             [0] => IMSSP             [SQLSTATE] => IMSSP             [1] => -49             [code] => -49             [2] => This extension requires the Microsoft SQL Server  2012 Native Client. Access the following URL to download the Microsoft  SQL Server 2012 Native Client ODBC driver for x86:  http://go.microsoft.com/fwlink/?LinkId=163712             [message] => This extension requires the Microsoft SQL  Server 2012 Native Client. Access the following URL to download the  Microsoft SQL Server 2012 Native Client ODBC driver for x86:  http://go.microsoft.com/fwlink/?LinkId=163712         )      [1] => Array         (             [0] => IM002             [SQLSTATE] => IM002             [1] => 0             [code] => 0             [2] => [Microsoft][ODBC Driver Manager] Data source name  not found and no default driver specified             [message] => [Microsoft][ODBC Driver Manager] Data source  name not found and no default driver specified         )  )

Hycker · May 21, 2013

for win2k8 you can download native client

tyrael75 · May 22, 2013

Hycker said:
Unfortunately M$ doesnot support native clients for Windows 2003 server with MS-SQL server 2008. Means you cannot install Native Client drivers coz its answer, this operating system does not supported blablabla. There we need an unofficial driver for php.

PHP can connect to MS-SQL but cant do anything, thats why the lootconfig is not loading and you getting sco error in supervisor server log. For fix this follow this little tutorial.

1., check your php version
create a file name test.php and insert this to inside:

Code:

<?php phpinfo() ?>

put this file this to wwwroot if IIE or htdocs if Abyss and open up with your favorite browser, like

You must be registered to see links

lets check on the top PHP Version X.X.XX (mine is 5.3.24)
and the extension_dir (mine is: C:\Program Files\PHP\ext)
if 5.3.24 download this zip -> View attachment 130569
unpack to anywhere, example: C:\
at end you get a php5.3 directory in C drive

now go to this directory and copy both file

Code:

php_pdo_sqlsrv_30_53_nts_vc9x86.dll php_sqlsrv_30_53_nts_vc9x86.dll

to your php extension dir (mine is C:\Program Files\PHP\ext)
Go to your PHP installed directory (mine is C:\Program Files\PHP\), open php.ini and insert those lines at the end:

Code:

extension=php_sqlsrv_30_53_nts_vc9x86.dll extension=php_pdo_sqlsrv_30_53_nts_vc9x86.dll

restart your webserver, open your favorite browser and open

You must be registered to see links

(if you changed the backend folder then change in address too)

and you should get

<LootBoxDB><LootBox itemID="301118"><d c="20" i="101267" g1="0" g2="0"/><d c="40" i="101309" g1="0" g2="0"/><d c="50" i="101308" g1="0" g2="0"/><d c="300" i="101307" g1="0" g2="0"/><d c="500" i="-1" g1="0" g2="0"/><d c="900" i="101278" g1="0" g2="0"/></LootBox><LootBox itemID="301119"><d c="1" i="101032" g1="0" g2="0"/><d c="1" i="101098" g1="0" g2="0"/><d c="2" i="101111" g1="0" g2="0"/><d c="5" i="101040" g1="0" g2="0"/><d c="10" i="101158" g1="0" g2="0"/><d c="10" i="101115" g1="0" g2="0"/><d c="100" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301120"><d c="1" i="101172" g1="0" g2="0"/><d c="1" i="101247" g1="0" g2="0"/><d c="1" i="101103" g1="0" g2="0"/><d c="5" i="101022" g1="0" g2="0"/><d c="10" i="101200" g1="0" g2="0"/><d c="20" i="101002" g1="0" g2="0"/><d c="30" i="101111" g1="0" g2="0"/><d c="100" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301121"><d c="1" i="101088" g1="0" g2="0"/><d c="5" i="101063" g1="0" g2="0"/><d c="5" i="101103" g1="0" g2="0"/><d c="5" i="101022" g1="0" g2="0"/><d c="10" i="101064" g1="0" g2="0"/><d c="10" i="101112" g1="0" g2="0"/><d c="20" i="101055" g1="0" g2="0"/><d c="40" i="101002" g1="0" g2="0"/><d c="40" i="101120" g1="0" g2="0"/><d c="40" i="101004" g1="0" g2="0"/><d c="400" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301122"><d c="1" i="400043" g1="0" g2="0"/><d c="4" i="400070" g1="0" g2="0"/><d c="10" i="400017" g1="0" g2="0"/><d c="30" i="400048" g1="0" g2="0"/><d c="60" i="400073" g1="0" g2="0"/><d c="70" i="400101" g1="0" g2="0"/><d c="70" i="400016" g1="0" g2="0"/><d c="100" i="400136" g1="0" g2="0"/><d c="100" i="400137" g1="0" g2="0"/><d c="200" i="400071" g1="0" g2="0"/><d c="400" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301123"><d c="100" i="400000" g1="0" g2="0"/><d c="2000" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301124"><d c="10" i="20056" g1="0" g2="0"/><d c="10" i="20015" g1="0" g2="0"/><d c="60" i="20043" g1="0" g2="0"/><d c="60" i="20047" g1="0" g2="0"/><d c="60" i="20048" g1="0" g2="0"/><d c="100" i="20096" g1="0" g2="0"/><d c="100" i="20097" g1="0" g2="0"/><d c="100" i="20098" g1="0" g2="0"/><d c="100" i="20177" g1="0" g2="0"/><d c="100" i="20178" g1="0" g2="0"/><d c="100" i="20023" g1="0" g2="0"/><d c="100" i="20032" g1="0" g2="0"/><d c="100" i="20035" g1="0" g2="0"/><d c="100" i="20041" g1="0" g2="0"/><d c="100" i="20042" g1="0" g2="0"/><d c="1000" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301125"><d c="5" i="101304" g1="0" g2="0"/><d c="7" i="101302" g1="0" g2="0"/><d c="10" i="101262" g1="0" g2="0"/><d c="30" i="101256" g1="0" g2="0"/><d c="60" i="101300" g1="0" g2="0"/><d c="80" i="101261" g1="0" g2="0"/><d c="200" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301126"><d c="22" i="101293" g1="0" g2="0"/><d c="24" i="101292" g1="0" g2="0"/><d c="26" i="101291" g1="0" g2="0"/><d c="30" i="101290" g1="0" g2="0"/><d c="50" i="101297" g1="0" g2="0"/><d c="50" i="101298" g1="0" g2="0"/><d c="50" i="101286" g1="0" g2="0"/><d c="50" i="101294" g1="0" g2="0"/><d c="100" i="101283" g1="0" g2="0"/><d c="100" i="101285" g1="0" g2="0"/><d c="100" i="101288" g1="0" g2="0"/><d c="100" i="101289" g1="0" g2="0"/><d c="110" i="101296" g1="0" g2="0"/><d c="400" i="101299" g1="0" g2="0"/><d c="600" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301127"><d c="10" i="101295" g1="0" g2="0"/><d c="20" i="101286" g1="0" g2="0"/><d c="50" i="101298" g1="0" g2="0"/><d c="60" i="101297" g1="0" g2="0"/><d c="100" i="101290" g1="0" g2="0"/><d c="100" i="101291" g1="0" g2="0"/><d c="100" i="101292" g1="0" g2="0"/><d c="100" i="101293" g1="0" g2="0"/><d c="100" i="101299" g1="0" g2="0"/><d c="150" i="101285" g1="0" g2="0"/><d c="2000" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301128"><d c="100" i="101284" g1="0" g2="0"/><d c="100" i="101295" g1="0" g2="0"/><d c="2000" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301129"><d c="1" i="400070" g1="0" g2="0"/><d c="10" i="400050" g1="0" g2="0"/><d c="10" i="400079" g1="0" g2="0"/><d c="10" i="400017" g1="0" g2="0"/><d c="25" i="400015" g1="0" g2="0"/><d c="30" i="400016" g1="0" g2="0"/><d c="100" i="400071" g1="0" g2="0"/><d c="200" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301130"><d c="10" i="301118" g1="0" g2="0"/><d c="10" i="301137" g1="0" g2="0"/><d c="30" i="301125" g1="0" g2="0"/><d c="100" i="301126" g1="0" g2="0"/></LootBox><LootBox itemID="301132"><d c="5" i="301119" g1="0" g2="0"/><d c="5" i="301122" g1="0" g2="0"/><d c="10" i="301137" g1="0" g2="0"/><d c="20" i="301125" g1="0" g2="0"/><d c="100" i="301126" g1="0" g2="0"/></LootBox><LootBox itemID="301133"><d c="10" i="301119" g1="0" g2="0"/><d c="10" i="301122" g1="0" g2="0"/><d c="10" i="301124" g1="0" g2="0"/><d c="30" i="301126" g1="0" g2="0"/><d c="30" i="301137" g1="0" g2="0"/><d c="100" i="301125" g1="0" g2="0"/></LootBox><LootBox itemID="301134"><d c="20" i="301120" g1="0" g2="0"/><d c="20" i="301129" g1="0" g2="0"/><d c="60" i="301128" g1="0" g2="0"/><d c="100" i="301124" g1="0" g2="0"/><d c="100" i="301125" g1="0" g2="0"/></LootBox><LootBox itemID="301135"><d c="10" i="301123" g1="0" g2="0"/><d c="20" i="301121" g1="0" g2="0"/><d c="100" i="301124" g1="0" g2="0"/><d c="100" i="301127" g1="0" g2="0"/><d c="100" i="301125" g1="0" g2="0"/></LootBox><LootBox itemID="301136"><d c="20" i="0" g1="50" g2="100"/><d c="40" i="-1" g1="0" g2="0"/></LootBox><LootBox itemID="301137"><d c="1" i="101316" g1="0" g2="0"/><d c="1" i="101317" g1="0" g2="0"/><d c="20" i="20179" g1="0" g2="0"/><d c="40" i="20175" g1="0" g2="0"/><d c="70" i="101307" g1="0" g2="0"/><d c="100" i="101315" g1="0" g2="0"/><d c="100" i="101311" g1="0" g2="0"/><d c="100" i="101312" g1="0" g2="0"/><d c="100" i="101306" g1="0" g2="0"/><d c="100" i="-1" g1="0" g2="0"/></LootBox></LootBoxDB>

means php finaly can communicate with M$-SQL

those steps can be done with PHP 5.4 too, for it you need other files
this one -> View attachment 130570
method is same

driver source: View attachment 130571

Credits to Rob for driver ->
You must be registered to see links

Credtis to DNC for community rlz
Credits to Vusion for original warz source
Credits to else whos working hard on it

edit: virustotal links for dll files
php5.3

You must be registered to see links

php5.4

You must be registered to see links

source

You must be registered to see links

Hycker you are most welcome on my server when it goes live, we will ensure you're treatment will be of VIP quality!

Cookies95 · May 23, 2013

Hi there, Thanks for this, it has allowed My Co-Owner tyrael75 fix this issue to allow us have loot, Respect man

Hycker · May 23, 2013

1st post is edited

Breno Alves · May 31, 2013

I follow this but, when i try to log in localhost/WarZ/api/php/api_GetLootBoxConfig.php?serverkey=9F179EB9-C74E-4933-85B5-EB135E16F5EF, i got this erro...

PLEASE HELP

Array ( [0] => Array ( [0] => 28000 [SQLSTATE] => 28000 [1] => 18456

Code:

 => 18456 [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Falha de logon do usuÃ¡rio 'wz_api_user'. [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Falha de logon do usuÃ¡rio 'wz_api_user'. ) [1] => Array ( [0] => 28000 [SQLSTATE] => 28000 [1] => 18456 [code] => 18456 [2] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Falha de logon do usuÃ¡rio 'wz_api_user'. [message] => [Microsoft][SQL Server Native Client 11.0][SQL Server]Falha de logon do usuÃ¡rio 'wz_api_user'. ) )[/COLOR][/INDENT]

[/COLOR]
[COLOR=#837E6E]
[LIST]
[/LIST]

[/COLOR]

Hycker · May 31, 2013

your php settings is wrong or you didnot installed php aswell

steventhedon187 · Aug 22, 2013

I LOVE YOU Hycker !!!!

)) thank you very very much for you help !!!! awesome !

Welcome!

[TuT]Community Release Drop fix for Windows 2003 server

Hycker

Banned

Attachments

KlausVander

Experienced Elementalist

KING GUEVARA

Initiate Mage

Hycker

Banned

tyrael75

Newbie Spellweaver

Cookies95

Initiate Mage

Hycker

Banned

Breno Alves

Newbie Spellweaver

Hycker

Banned

steventhedon187

Newbie Spellweaver

Similar threads

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor