Printable View
I did find some info that could be a solution.
http://forum.ragezone.com/f792/help-...-spawn-991613/
I'm collecting all that i can find before i jump into changing the server to use SSL and try if it resolves anything.
I think not but it seems to have worked for beastgameer
@DNC
@ztimer
That is the thread I was referring to. Good find.
Thank you I'll watch for the @ DNC in a reply.
Cheers bro
So I downloaded the PHP Manager 1.2 for IIS 7 - x64
Installed Microsoft Web Platform Installer 5.0
From the web platform installed php 5.5.11
Enabled all modules.
In the error log:
[12-Jun-2014 23:23:18 Asia/Muscat] PHP Fatal error: Call to undefined function sqlsrv_connect() in C:\inetpub\wwwroot\api\php\dbinfo.inc.php on line 17
[12-Jun-2014 23:37:30 Asia/Muscat] PHP Fatal error: Call to undefined function sqlsrv_connect() in C:\inetpub\wwwroot\api\php\dbinfo.inc.php on line 17
[12-Jun-2014 23:46:18 Asia/Muscat] PHP Fatal error: Call to undefined function sqlsrv_connect() in C:\inetpub\wwwroot\api\php\dbinfo.inc.php on line 17
[12-Jun-2014 23:53:05 Asia/Muscat] PHP Fatal error: Call to undefined function sqlsrv_connect() in C:\inetpub\wwwroot\api\php\dbinfo.inc.php on line 17
The code seems ok to me.
Quote:
$db_user = "wz_api_user";
$db_pass = "123456";
$db_dbname = "WarZ";
$db_serverName = "localhost";
$db_connectionInfo = array(
"UID" => $db_user,
"PWD" => $db_pass,
"Database" => $db_dbname,
"CharacterSet" => "UTF-8"
//"ReturnDatesAsStrings" => true
);
line 17 ---> $conn = sqlsrv_connect($db_serverName, $db_connectionInfo);
This does not explain what i see in the log.
000008.846| LootBox: 077111F0 with ItemID 101267, tick: 60 <-------------------------- THIS HERE
000008.846| LootBox: 077115B8 with ItemID 400140, tick: 60 <---------------------------THIS HERE
000008.846| LootBox: !!!! m_LootBoxID 301132 does NOT have items inside
000008.846| !!! OnCreate failed for obj=obj_ItemSpawnPoint, filename=data/objectsdepot/capture_points/flag_pole_01.sco
000008.846| LootBox: !!!! m_LootBoxID 301133 does NOT have items inside
000008.846| !!! OnCreate failed for obj=obj_ItemSpawnPoint, filename=data/objectsdepot/capture_points/flag_pole_01.sco
000008.846| LootBox: !!!! m_LootBoxID 301134 does NOT have items inside
@DNC
Seems to me that only two loot boxes are working. Those lootboxes somehow skip some bugs that i'm supposed to have in the database or php not working or connection problems to the database.?
Honestly i'm really tired of looking at the code not understanding the bigger picture.
One must first know all the files and dependencies to really make some changes to them.
So at the moment i feel quite dumb.
Hoping tomorrow brings better ideas. :)
show me lines from your database that contain itemid 301132, 301133, 301134 <---
I have several
Items_LootData table is just one of the tables that contain this information.Code:3907 301132 50 301119 0 0
3908 301132 50 301122 0 0
3909 301132 10 301137 0 0
3910 301132 20 301125 0 0
3911 301132 50 301126 0 0
3912 301133 20 301119 0 0
3913 301133 15 301122 0 0
3914 301133 30 301124 0 0
3915 301133 30 301126 0 0
3916 301133 30 301137 0 0
3917 301133 100 301125 0 0
3918 301134 50 301120 0 0
3919 301134 50 301129 0 0
3920 301134 60 301128 0 0
3921 301134 100 301124 0 0
3922 301134 100 301125 0 0
- - - Updated - - -
You installed PHP with SQL Server, did you add the dll to the php.ini file at the bottom?
PHP\v5.3\PHP.ini
-----
extension=php_sqlsrv_53_nts_vc9.dll
PHP\v5.4\PHP.ini
-----
extension=php_pdo_sqlsrv.dll
extension=php_sqlsrv.dll
[PHP_PDO_PGSQL]
extension=php_pdo_pgsql.dll
@DNC
All is well in the log now. Spawn points all over the place. I was missing the correct extension.
Thanks for all your help.
For others to understand better.
Install php from Installed Microsoft Web Platform Installer selecting 5.3.28
It will auto suggest the extension driver and attach it.
I was using the wrong version.