Web Based Tools ( PrivateHiveTools )

raziel23x · June 4, 2014

okay I completely deleted the entire contents of my htdocs and then redownloaded PrivateHiveTools.

Rcon is not functional at all

I am running XAMPP Control Panel V3.2.1 on my windows 2012 Dedicated Box which is the same box as my Dayz Epoch Server is hosted on using the the mysql server for the Gameservers Database

here is my config file for PrivateHiveTools

<?php

/*#### MYSQL DATABASE SETTINGS #########*/ 

$CONF['DBHOST']		= 'localhost'; 		/** DATABASE HOSTNAME OR IP **/
$CONF['DBPORT'] 	= 3306; 		/** DATABASE PORT **/
$CONF['DBPASS'] 	= 'xxx'; 		/** DATABASE PASSWORD **/
$CONF['DBUSER'] 	= 'xxx'; 		/** DATABASE USER **/
$CONF['DBNAME'] 	= 'xxx'; 		/** DATABASE NAME **/


/*#### GAME SETTINGS  #################*/

$CONF['GAME'] 		= 1; 			/** 1=A2EPOCH, 2=DAYZMOD **/
$CONF['GAMEIP']		= 'xx.x.xxx.xxx'; 		/** IP OF GAMESERVER **/
$CONF['GAMEPORT']	= 2302; 		/** PORT OF GAMESERVER **/
$CONF['GAMERCON'] 	= 'xxxxxx'; 	/** RCON PASSWORD OF GAMESERVER **/
$CONF['GAMEMAP'] 	= 1; 		/** 1=chernarus,2=chernarusplus,3=lingor,4=namalsk,5=ovaron,6=panthera2,7=utes,8=altis,9=stratis,10=sauerland,11=takistan,12=zargabad,13=napf **/
$CONF['INSTANCE'] 	= 11; 		/** SERVER INSTANCE ( see /MPMissions/init.sqf ) **/
 
 
/*#### PHT SETTINGS ###################*/
$CONF['PHT_RESET_KEY'] 		= 'xxx'; 	/** pw reset key **/	
$CONF['PHT_FORCE_LANG'] 	= 'en'; 				/** de / en / no **/
$CONF['PHT_MAXTABLEDATA'] 	= 10;
$CONF['PHT_SQLITE']		  	= true;
$CONF['PHT_SQLITEDB']	  	= 'e2e281ac5581d084b68134b1fec71f9b7751e9c85daf8ff2a56b20ca5d8d10b1_db.sqlite';
$CONF['PHT_SETUP'] 			= false; 
$CONF['PHT_AUTH']	  		= true;				
$CONF['PHT_TOKEN']    		= '035daca8d56cb0f2f7db23494334713042cc125d3fdae3ea7350acddd8eafb51';	/** needed when PHT_AUTH set to false **/

my Server Config

hostName = "xxxx";
password = "";
passwordAdmin = "xxx";
maxPlayers = 50;
logFile = "server_log.txt";
voteThreshold = 2;
voteMissionPlayers = 3;
reportingIP = "arma2oapc.master.gamespy.com";
timeStampFormat = "short";
motd[] = {"xxx","!"};
motdInterval = 0;
vonCodecQuality = 20;
disableVoN = 0;
kickduplicate = 1;
verifySignatures = 0;
persistent = 1;
BattlEye = 1;
requiredSecureId = 2;
doubleIdDetected = "";
onUserConnected = "";
onUserDisconnected = "";
onUnsignedData = "kick (_this select 0)";
onHackedData = 	"kick (_this select 0)";
onDifferentData = "";
regularCheck = "";
requiredBuild = 103718;

class Missions
{
    class Mission1
    {
    	template = "DayZ_Epoch_11.Chernarus";
    	difficulty="veteran";
    };

};

The Firewall is disabled completely

Falcon911 · June 4, 2014

raziel.. What is the issue??

BetterDeadThanZed · June 4, 2014

In regards to the Epoch Prices page, I have heavily modified my traders so they no longer fit the categories show on my price page (http://killinzedz.net/EpochPrices2/). How do I update it so it shows the new traders and also how can i make it so it only shows items sold on the instance I'm running?

raziel23x · June 4, 2014

Rcon not functional at all

nightmare · June 4, 2014

On 6/4/2014 at 6:52 PM, BetterDeadThanZed said:

How do I update it so it shows the new traders

you have to update this epoch tables:

- trader_tids

- server_traders

On 6/4/2014 at 6:52 PM, BetterDeadThanZed said:

how can i make it so it only shows items sold on the instance I'm running?

copy this into "price.func.php"

Reveal hidden contents

<?php
/*****************
EpochPrices by Nightmare
http://n8m4re.de
******************/

$INSTANCE=17;

function selectTraderData($WHERE){
global $db;
	$result = $db->query("SELECT `id`,`desc` FROM `server_traders` ");	
	$row = array();
	if ( $result->num_rows !== 0 ) {
		while ( $row[] = $result->fetch_assoc() );			
		return $row;	
	} else {
		return false;
	}
}


function selectStockData($WHERE){
global $db;
	$result = $db->query("SELECT `Traders_DATA`.`item`,`Traders_DATA`.`qty`,`Traders_DATA`.`buy`,`Traders_DATA`.`sell`,`Traders_DATA`.`tid`,`trader_tids`.`name`,`trader_tids`.`trader`,`server_traders`.`id`,`server_traders`.`instance`,`server_traders`.`desc`FROM `Traders_DATA` INNER JOIN `trader_tids` ON ( `trader_tids`.`id` = `Traders_DATA`.`tid` ) INNER JOIN `server_traders` ON ( `server_traders`.`id` = `trader_tids`.`trader` ) ". $WHERE ." ORDER BY `Traders_DATA`.`item` ASC");
	$row = array();
	if ( $result->num_rows !== 0 ) {
		while ( $row[] = $result->fetch_assoc() );			
		return $row;	
	} else {
		return false;
	}
}


function priceList() {
global $db,$INSTANCE;
	if (isset($_GET['show']) && !empty($_GET['show'])){			
				echo '<h3>'.$_GET['show'].'</h3>';				
			$WHERE = "WHERE `trader_tids`.`name`= '".secure($_GET['show'])."' AND `server_traders`.`instance`=".(int)$INSTANCE." ";
			$row = @array_filter( selectStockData($WHERE) );			
			for ( $i=0; $i < count ( $row ); $i++ ) {
					
					$item	= json_decode($row[$i]['item']); 
					$buy	= json_decode($row[$i]['buy']); 
					$sell	= json_decode($row[$i]['sell']);	

					$itemImg = '<img height="25" src="images/nopic.png"/>';								
					if ( image($item[0],'items') !== 'images/nopic.png' )		$itemImg = '<img height="25" src="'.image( $item[0] ,'items').'"/>';				
					if ( image($item[0],'objects') !== 'images/nopic.png' )		$itemImg = '<img height="25" src="'.image( $item[0] ,'objects').'"/>';	
					$model = str_replace('Skin_','',$item[0]);
					if ( image($model,'models') !== 'images/nopic.png' ) 		$itemImg = '<img height="80" src="'.image( $model ,'models').'"/>';
					$buyImg = 'images/nopic.png';
					if ( image($buy[1],'items') !== 'images/nopic.png' ) 	$buyImg = image($buy[1],'items');	

					$sellImg = 'images/nopic.png';
					if ( image($sell[1],'items') !== 'images/nopic.png' ) 	$sellImg = image($sell[1],'items');
					echo '<tr class="list">
							<td>'.$row[$i]['desc'].'</td>
							<td>'.@$itemImg.'<br/><span class="price">'.$item[0].'</span></td>
							<td><span class="price" title="'.$buy[1].'">'.$buy[0].' x </span> <img height="30" src="'.@$buyImg.'" title="'.$buy[1].'" /></td>
							<td><span class="price" title="'.$sell[1].'">'.$sell[0].' x </span> <img height="30" src="'.@$sellImg.'" title="'.$sell[1].'"/></td>
						</tr>';
			}	
	}

}


function selectCategory() {
global $db;
$result = $db->query("SELECT `trader_tids`.`name` FROM `trader_tids` INNER JOIN `Traders_DATA` ON `Traders_DATA`.`tid` = `trader_tids`.`id` GROUP BY `trader_tids`.`name` ORDER BY `trader_tids`.`name` ASC ");
if ( $result->num_rows !== 0 ) {
		while ( $row = $result->fetch_assoc() ){
			echo '<li><a href="index.php?show='.$row['name'].'" >'.$row['name'].'</a></li>';
		}
	}
}

?>

Falcon911 · June 4, 2014

raziel...did you even follow my post on what he stated above?

raziel23x · June 4, 2014

On 6/4/2014 at 8:28 PM, Falcon911 said:
raziel...did you even follow my post on what he stated above?

i have no clue how to check with XAMPP about the UDP but everything else is green

Diceman · June 8, 2014

Hello I have this installed with vert hosting its running correct but its very slow loading takes around 60 seconds to login and still continues to run slow after that but not as long.

has anyone else experienced this problem?

chaingun427 · June 10, 2014

installed and connected to DB, but no data shows, and i'm unable to change anything. I've covered all 35 pages here without any resolution. server is 1.0.4.2 on a dedicated server i'm hosting. below is my config file. not sure why but it doesn't even pick up the custom trader sets that i have.

<?php

/*#### MYSQL DATABASE SETTINGS #########*/ 

$CONF['DBHOST']		= '127.0.0.1'; 		/** DATABASE HOSTNAME OR IP **/
$CONF['DBPORT'] 	= 3306; 		/** DATABASE PORT **/
$CONF['DBPASS'] 	= '######'; 		/** DATABASE PASSWORD **/
$CONF['DBUSER'] 	= '######'; 		/** DATABASE USER **/
$CONF['DBNAME'] 	= 'dayz_epoch'; 		/** DATABASE NAME **/


/*#### GAME SETTINGS  #################*/

$CONF['GAME'] 		= 1; 			/** 1=A2EPOCH, 2=DAYZMOD **/
$CONF['GAMEIP']		= '127.0.0.1'; 		/** IP OF GAMESERVER **/
$CONF['GAMEPORT']	= 2302; 		/** PORT OF GAMESERVER **/
$CONF['GAMERCON'] 	= 'changeme'; 	/** RCON PASSWORD OF GAMESERVER **/
$CONF['GAMEMAP'] 	= 13; 		/** 1=chernarus,2=chernarusplus,3=lingor,4=namalsk,5=ovaron,6=panthera2,7=utes,8=altis,9=stratis,10=sauerland,11=takistan,12=zargabad,13=napf **/
$CONF['INSTANCE'] 	= 1; 		/** SERVER INSTANCE ( see /MPMissions/init.sqf ) **/
 
 
/*#### PHT SETTINGS ###################*/
$CONF['PHT_RESET_KEY'] 		= '######'; 	/** pw reset key **/	
$CONF['PHT_FORCE_LANG'] 	= ''; 				/** de / en / no **/
$CONF['PHT_MAXTABLEDATA'] 	= 10;
$CONF['PHT_SQLITE']		  	= true;
$CONF['PHT_SQLITEDB']	  	= '2d36025bbcea18701787b632a74c83e12374765e758bebdc42cc40f5cb61ac1b_db.sqlite';
$CONF['PHT_SETUP'] 			= false; 
$CONF['PHT_AUTH']	  		= true;				
$CONF['PHT_TOKEN']    		= 'be415572ae7f152846526be641e40129dd133b9b24c500842f76ecc55c648d8d';	/** needed when PHT_AUTH set to false **/

nightmare · June 10, 2014

On 6/10/2014 at 2:04 AM, chaingun427 said:

installed and connected to DB, but no data shows, and i'm unable to change anything. I've covered all 35 pages here without any resolution. server is 1.0.4.2 on a dedicated server i'm hosting. below is my config file. not sure why but it doesn't even pick up the custom trader sets that i have.

1.)

The the database tablenames should look like the following. ( If not, please rename )

Character_DATA
Object_DATA
Player_DATA
Player_LOGIN
Traders_DATA

2.)

The "$CONF['INSTANCE']" number in the "config.php" must be the same like the "instanceID" of your "init.sqf "

3.)

if players not showing: please check in your "Character_DATA" table wether column "last_updated" exists

if not, then please execute this SQL- command:

ALTER TABLE `Character_DATA` 
      ADD COLUMN `last_updated` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP AFTER `Infected`;

4.)

if objects not showing: please check your "Object_DATA" table wether column "LastUpdated" exists.

if not, then please execute this SQL- command:

ALTER TABLE `Object_DATA` 
     ADD COLUMN `LastUpdated` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP AFTER `Damage`;

5.)

if objects not showing and "Object_DATA" table has the column "last_updated" .

then please execute this SQL- command:

ALTER TABLE `Object_DATA`
    CHANGE COLUMN `last_updated` `LastUpdated` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP AFTER `Damage`;

chaingun427 · June 10, 2014

tables exist as shown, except that they are lowercase at the end. columns exist in player_data and object_ data as referenced above as well.

Instance ID is 24 for Napf

nightmare · June 10, 2014

On 6/10/2014 at 11:31 AM, chaingun427 said:

tables exist as shown, except that they are lowercase at the end.

this table names are required, as I write

Character_DATA
Object_DATA
Player_DATA
Player_LOGIN
Traders_DATA

Epoch Table-Schema Source: https://github.com/vbawol/DayZ-Epoch/blob/master/Server%20Files/SQL/epoch.sql

raziel23x · June 10, 2014

what about my issue with the player list with rcon not showing

uaing xampp on a dedicated box and remote desktop connection says UDP is open firewall is disabled and not Anti-Virus installed on box.

i am able to connect to rcon with dart and emp but not the webrcon in your web application.

my info on my box is in the previous page

BetterDeadThanZed · June 10, 2014

On 6/10/2014 at 1:44 PM, raziel23x said:

what about my issue with the player list with rcon not showing

uaing xampp on a dedicated box and remote desktop connection says UDP is open firewall is disabled and not Anti-Virus installed on box.

i am able to connect to rcon with dart and emp but not the webrcon in your web application.

my info on my box is in the previous page

It doesn't work for me and a lot of other people too. There's no obvious solution if all the settings are correct.

nightmare · June 10, 2014

On 6/10/2014 at 1:44 PM, raziel23x said:

what about my issue with the player list with rcon not showing

uaing xampp on a dedicated box and remote desktop connection says UDP is open firewall is disabled and not Anti-Virus installed on box.

i am able to connect to rcon with dart and emp but not the webrcon in your web application.

my info on my box is in the previous page

please try this: READY2GO DOWNLOAD ( with Apache2 WebServer from xampp-portable-win32-1.8.3-4-VC11 build )

** i've tested it and the rcon works for me on this.

raziel23x · June 10, 2014

On 6/10/2014 at 4:05 PM, nightmare said:

please try this: READY2GO DOWNLOAD ( with Apache2 WebServer from xampp-portable-win32-1.8.3-4-VC11 build )

** i've tested it and the rcon works for me on this.

downloading now will tell you if it works in 10 min

raziel23x · June 10, 2014

well your folders for php and apache broke my xampp so i have to reinstall....

nightmare · June 10, 2014

On 6/10/2014 at 5:35 PM, raziel23x said:

well your folders for php and apache broke my xampp so i have to reinstall....

its not an install version of xampp in my package ! ( portable )

you can put the "xampp folder" to any hdd. then execute the start.bat ( before use , please shutdown your xampp installation )

raziel23x · June 10, 2014

Still have the issue with rcon

chaingun427 · June 10, 2014

table names changed as noted, capitalization is intact.

Gamemap set to 13 for napf, instance set to 24, tool is now a white screen.

EDIT: was missing a ; objects showing now, but no players

nightmare · June 11, 2014

On 6/10/2014 at 10:13 PM, chaingun427 said:

table names changed as noted, capitalization is intact.

Gamemap set to 13 for napf, instance set to 24, tool is now a white screen.

EDIT: was missing a ; objects showing now, but no players

please post a dump from your database, i will have a look..

On 6/10/2014 at 8:17 PM, raziel23x said:

Still have the issue with rcon

mhmm...

have no idea what can be wrong, it works for me on xampp also on linux....

( did you click on the "refresh" button ? )

Falcon911 · June 11, 2014

Yeah I'm still in the same boat with the rcon too.

But everything else seems to be working wonderfully.

raziel23x · June 11, 2014

On 6/11/2014 at 4:50 PM, nightmare said:

please post a dump from your database, i will have a look..

mhmm...

have no idea what can be wrong, it works for me on xampp also on linux....

( did you click on the "refresh" button ?)

i clicked refresh several times

ATRealMaster · July 2, 2014

I tried the Ready 2 Go version, but when I ran the "start.bat' file, it gave me this error:

"C:\xampp\htdocs/db/785c8cbd70bb320a433912ff39c3db4a0f2e58e554030497236e677693e84a65_db.sqlite" is missing

nightmare · July 2, 2014

On 7/2/2014 at 3:28 AM, ATRealMaster said:

I tried the Ready 2 Go version, but when I ran the "start.bat' file, it gave me this error:

"C:\xampp\htdocs/db/785c8cbd70bb320a433912ff39c3db4a0f2e58e554030497236e677693e84a65_db.sqlite" is missing

please open:

C:\xampp\htdocs/config.php

and remove all entrys or set " $CONF['PHT_SETUP'] " to true

Web Based Tools ( PrivateHiveTools )

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

nightmare

nightmare

nightmare

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Please sign in to comment

Similar Content