- Joined
- Mar 29, 2013
- Messages
- 123
- Reaction score
- 39
timeout getting lootbox db
logss error
My API
your api folder name: Site
IP: localhost
Port: 56016
Directory
Site\php\dbinfo.inc.php
Site\php\api_GetLootBoxConfig.php
My ServenMain.cpp
http://pastie.org/7603554
logss error
Code:
000000.012| r3dFS: there is no volume file wo_00.bin
000000.012| Connecting to master server at 192.168.1.2:34000
000000.012| r3dNetwork: Creating client
000000.037| IP: 192.168.1.2
000000.037| IP: 25.14.191.30
000000.037| r3dNetwork: connecting to 192.168.1.2:34000
000000.037| waiting: connecting, 10.0 sec left
000000.048| r3dNetwork: external ip: 192.168.1.2:62329
000000.048| Game: Initializing with 64 players
000000.048| Server time is Fri Apr 08 20:23:42 2022
000000.048| CAsyncApiMgr starting
000000.049| Starting server on port 34010
000000.049| r3dNetwork: Creating host at port 34010
000000.057| IP: 192.168.1.2
000000.057| IP: 25.14.191.30
000000.069| Getting shop data
000000.181| Reading game rewards
000000.218| Loading armory config
000000.226| Reading loot boxes
000000.236| !!! ERROR: timeout getting lootbox db
000000.236| !!! crashed
000000.236| Creating minidump at logss\GS_27100000026e033e.dmp
000000.364| Minidump created.My API
your api folder name: Site
IP: localhost
Port: 56016
Directory
Site\php\dbinfo.inc.php
PHP:
<?php
$db_apikey = "ACOR4823G%sjYU*@476xnDvYaK@!56";
function db_connect()
{
$db_user = "root";
$db_pass = "27091995";
$db_dbname = "WarZ";
$db_serverName = "localhost,11433";
$db_connectionInfo = array(
"UID" => $db_user,
"PWD" => $db_pass,
"Database" => $db_dbname,
"CharacterSet" => "UTF-8"
//"ReturnDatesAsStrings" => true
);
$conn = sqlsrv_connect($db_serverName, $db_connectionInfo);
if(! $conn)
{
//echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
exit();
}
return $conn;
}
function db_exec($conn, $tsql, $params)
{
$stmt = sqlsrv_query($conn, $tsql, $params);
if(! $stmt)
{
echo "exec failed.\n";
die( print_r( sqlsrv_errors(), true));
}
$member = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC);
return $member;
}
$conn = db_connect();
?>Site\php\api_GetLootBoxConfig.php
PHP:
<?php
$serverkey = $_POST['serverkey'];
if ($serverkey != "9F179EB9-C74E-4933-85B5-EB135E16F5EF")
{
die('oops');
}
require_once('dbinfo.inc.php');
header("Content-type: text/xml");
$xml_output = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
// create & execute query: LOOTBOXES
$tsql = "select * from Items_Generic where Category=7";
$params = array();
$stmt = sqlsrv_query($conn, $tsql, $params);
$xml_output .= "<LootBoxDB>\n";
while($member = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC))
{
$itemid=$member['ItemID'];
$xml_output .= "\t<LootBox itemID=\"$itemid\">\n";
$tsql2 = "select * from Items_LootData where LootID=$itemid order by Chance asc";
$params2 = array();
$stmt2 = sqlsrv_query($conn, $tsql2, $params2);
while($member2 = sqlsrv_fetch_array($stmt2, SQLSRV_FETCH_ASSOC))
{
$l_Chance = $member2['Chance'];
$l_ItemID = $member2['ItemID'];
$l_GDMin = $member2['GDMin'];
$l_GDMax = $member2['GDMax'];
$xml_output .= "\t\t<d c=\"$l_Chance\" i=\"$l_ItemID\" g1=\"$l_GDMin\" g2=\"$l_GDMax\" />\n";
}
$xml_output .= "\t</LootBox>\n";
}
$xml_output .= "</LootBoxDB>\n\n";
echo $xml_output;
exit();
?>My ServenMain.cpp
http://pastie.org/7603554
)
you'll need the PHP Module for Lootboxes.
