You are an unregistered user, you can register here
Navigation

Information

Site

Donations
If you wish to make a donation you can by clicking the image below.


Site Sponsor

BeyondUnreal News

 
Go Back   The Unreal Admins Page > Forums > Hosted Forums > UTStats > General Chat

Reply
Thread Tools Display Modes
  #21  
Unread 3rd April, 2012, 10:41 AM
Graffix^ Graffix^ is offline
Forum Newcomer
 
Join Date: Sep 2011
Posts: 2
Default

Solved it, it's nowadays ACEPLAYERS instead of ACE
Reply With Quote
  #22  
Unread 3rd April, 2012, 09:05 PM
rork's Avatar
rork rork is offline
Godlike
 
Join Date: Nov 2007
Posts: 264
Default

I thought [ACEPLAYERS] are just all playerlogs, and the cheat logs still start with [ACE]?

Anyway, the 50 files are probably just files that do not match any of the criteria to be uploaded (there are several filename starts/endings configurable in user.ini). They may either be [ACEPLAYER] files, ucc logs, incomplete logs (*.tmp) and whatever else is around there.
__________________
Admin of XOL DOG CTF Fun server: 81.169.188.18 - Stats & dU Coop: 85.14.203.180:5555 - Forum
Reply With Quote
  #23  
Unread 21st May, 2012, 08:14 PM
SoNY_scarface SoNY_scarface is offline
Holy Shit!!
 
Join Date: Mar 2007
Posts: 1,726
Default

I'm having issues here too...


Importing Latest Log Files

Last FTP update more than 0 minutes ago, starting update (sockets):
FTP Transferring Log Files...
Connecting to server: 75.102.40.199:21
Connected, now logging in...
Logged in!
Setting passive mode
Current directory is: /
Changing directory to: /75.102.40.199 port 7777/Logs
New directory is: /75.102.40.199 port 7777/Logs
Directory contains: 891 files
Downloading... Unreal.ngLog.2012.05.21.11.50.34.7777.log -> OK (103 KB)
Unreal.ngLog.2012.05.21.11.57.23.7777.log -> OK (157 KB)
Unreal.ngLog.2012.05.21.12.09.34.7777.log -> OK (154 KB)
Downloaded: 3 files (414 KB) in 1 seconds
Disconnecting... done!
Connecting to server: 75.102.41.52:21
Connected, now logging in...
Logged in!
Setting passive mode
Current directory is: /
ERROR: Unable to change directory to: /75.102.41.52 port 7777/Logs
Downloaded: 0 files (0 KB) in 0 seconds
Disconnecting... done!
Connecting to server: 109.70.149.182:21
Connected, now logging in...
Logged in!
Setting passive mode
Current directory is: /
Changing directory to: /109.70.149.182 port 7777/Logs
New directory is: /109.70.149.182 port 7777/Logs
Directory contains: 1537 files
Downloading... Unreal.ngLog.2012.05.21.20.35.58.7777.log -> OK (244 KB)
Unreal.ngLog.2012.05.21.20.52.18.7777.log -> OK (244 KB)
Unreal.ngLog.2012.05.21.21.08.14.7777.log -> OK (209 KB)
Downloaded: 3 files (696 KB) in 6 seconds
Disconnecting... done!


Unable to create the temporary table - are you allowed to create tables in this database?
__________________




Reply With Quote
  #24  
Unread 2nd June, 2012, 12:28 PM
rork's Avatar
rork rork is offline
Godlike
 
Join Date: Nov 2007
Posts: 264
Default

Download the a patch for the import.php here that might fix it.
__________________
Admin of XOL DOG CTF Fun server: 81.169.188.18 - Stats & dU Coop: 85.14.203.180:5555 - Forum
Reply With Quote
  #25  
Unread 4th June, 2012, 04:31 PM
SoNY_scarface SoNY_scarface is offline
Holy Shit!!
 
Join Date: Mar 2007
Posts: 1,726
Default

Ah yes I forgot to post. I already did that and it worked.

TY!
__________________




Reply With Quote
  #26  
Unread 5th January, 2013, 11:04 AM
zavateandu's Avatar
zavateandu zavateandu is offline
Dominating
 
Join Date: Nov 2010
Posts: 171
Default

the 4.2.8 version of utstats is creating logs in my directory with "~" sign in front and when i want to import the logs it give me error
~Unreal.ngLog.2012.12.02.09.48.16.7777.log

how can i get take out that sign not be on log files.
__________________
Reply With Quote
  #27  
Unread 6th January, 2013, 01:02 PM
rork's Avatar
rork rork is offline
Godlike
 
Join Date: Nov 2007
Posts: 264
Default

If utstats doesn't delete the logs it renames the file (appends the ~) to prevent it from importing again. To prevent it from doing that you'll have to edit includes/ftp.php at about line 297

Code:
				if ((!isset($ftp_delete[$i]) or $ftp_delete[$i]) and !$error) {
					$ftp->delete($filename);
				}
				else {
					// rename the file to prevent reimporting
					$ftp->rename($filename, "~" . $filename);
				}
Comment out $ftp->rename($filename, "~" . $filename); like this:
Code:
				if ((!isset($ftp_delete[$i]) or $ftp_delete[$i]) and !$error) {
					$ftp->delete($filename);
				}
				else {
					// rename the file to prevent reimporting
					// $ftp->rename($filename, "~" . $filename);
				}
__________________
Admin of XOL DOG CTF Fun server: 81.169.188.18 - Stats & dU Coop: 85.14.203.180:5555 - Forum
Reply With Quote
  #28  
Unread 7th January, 2013, 06:12 PM
zavateandu's Avatar
zavateandu zavateandu is offline
Dominating
 
Join Date: Nov 2010
Posts: 171
Default

thank you it worked
__________________
Reply With Quote
  #29  
Unread 14th January, 2013, 05:02 AM
zavateandu's Avatar
zavateandu zavateandu is offline
Dominating
 
Join Date: Nov 2010
Posts: 171
Default

one more thing that i couldn't get it work
is about showing 2 servers in utstats page
everything is working ok ,the logs are imported for both servers but i can not get it work for 2 servers

i have the config setup like this:

<?php
// Database connection details
$dbname = "ut_stats";
$hostname = "localhost";
$uname = "root";
$upass = "xxx";

$dbconnect = mysql_connect($hostname,$uname,$upass);
$dbconnect2 = mysql_select_db($dbname);

// The key needed to run the import script
$import_adminkey = 'xxx';

// When runnning from the command-line (cron jobs):
// The absolute path to UTStats's home directory.
// Only needed if you're starting the importer from another directory
// Leave emtpy if unsure
$import_homedir = '';

// Use the MySQL temporary tables feature?
// Available since MySQL 3.23 - requires CREATE TEMPORARY TABLE privilege since 4.0.2
$import_use_temporary_tables = true; // set to true if available

// Use temporary heap tables?
// This will (at any cost) keep the entire table in RAM and may speed and/or fuck things up
$import_use_heap_tables = false; // DON'T USE IF YOU DON'T KNOW WHAT YOU'RE DOING!

// Log files start with...
$import_log_start = "Unreal.ngLog";

// Log files end with...
$import_log_extension = ".log";

// How to backup logfiles?
// Possible values: yes - move logfiles to the backup directory
// no - don't make a backup. The file will be lost after it was imported
// compress - will compress the logfile and move it to the backup directory
// It'll first try bzip2 compression, then gzip (your php must be
// compiled to support these)
// If both fail, it will backup the uncompressed log
// gzip - same as compress but will only try to gzip the file
$import_log_backup = "yes";

// Purge old logs after x days. 0 to disable.
$import_log_backups_purge_after = 0;


// After how many seconds should we reload the import page?
// This is to prevent the 'maximum execution time exeeded' error. It will reload
// the page after the amount of seconds you specify in order to bypass php's time limit.
// Set to 0 to disable (f.e. if your php does not run in safe mode)
$import_reload_after = 22;

// Ignore bots and bot kills/deaths?
$import_ignore_bots = true;

// How to deal with banned players?
// 1 - (recommended) import the player and display him/her on matchpages (without values )
// but don't include him/her in rankings and don't allow to show individual player stats
// You may unban a player banned with this setting and all stuff will display again
// 2 - don't import at all
// will lead to 'strange' results on matchpages because kills of and against this player
// won't be shown; efficiency etc. will be calculated including these kills though.
$import_ban_type = 1;

// Try to import logs from previous versions of UTStats
// Set this to true and you'll probably some strange results - You've been warned
$import_incompatible_logs = false;

// Don't import if the gametime was less than x minutes. Set to 0 to import all logs.
$import_ignore_if_gametime_less_than = 0;


// UTStats can download and manage your UTDC logs
// Enable downloading of UTDC logs?
$import_utdc_download_enable = false;

// Log files start with...
$import_utdc_log_start = "[UTDC]";

// Log files end with...
$import_utdc_log_extension = ".log";

// Screenshot files start with...
$import_utdc_screenshot_start = "[UTDC]";

// Screenshot files end with...
$import_utdc_screenshot_extension = ".enc";

// Compress UTDC logfiles after download? [compress/gzip/no]
// (see $import_log_backup for available options)
$import_utdc_log_compress = "compress";

// Purge old UTDC logs after x days. 0 to disable.
$import_utdc_log_purge_after = 0;

// UTStats can download and manage your AnthChecker logs
// Enable downloading of AC logs?
$import_ac_download_enable = true;

// Log files start with...
$import_ac_log_start = "[AC]";

// Log files end with...
$import_ac_log_extension = ".log";

// Compress AnthChecker logfiles after download? [compress/gzip/no]
// (see $import_log_backup for available options)
$import_ac_log_compress = "compress";

// Purge old AnthChecker logs after x days. 0 to disable.
$import_ac_log_purge_after = 0;

// UTStats can download and manage your ACE logs
// Enable downloading of ACE logs?
$import_ace_download_enable = true;

// Log files start with...
$import_ace_log_start = "[ACE]";

// Log files end with...
$import_ace_log_extension = ".log";

// Log files start with...
$import_ace_screenshot_start = "[ACE]";

// Log files end with...
$import_ace_screenshot_extension = ".jpg";

// Compress ACE logfiles after download? [compress/gzip/no]
// (see $import_log_backup for available options)
$import_ace_log_compress = "compress";

// Purge old ACE logs after x days. 0 to disable.
$import_ace_log_purge_after = 0;

// Enable the creation of pictures? (Signature pictures for users where they can see their current ranking and stuff)
// Requires GD- and FreeType support.
// see config_pic.php for picture configuration options
$pic_enable = true;


// FTP Connection Details
$ftp_use = true; // Whether to auto get the log files
$ftp_interval = 7; // How often in minutes to allow stats update
$ftp_type = 'sockets'; // Which FTP module do you want to use?
// sockets - (recommended)
// Use PHP's socket extension to connect to the FTP server
// will fallback to 'pure' if no sockets available
// pure - Use fsockopen() to connnect to the FTP server
// should work with any php version
// php - Use PHP's FTP extension (must be compiled in)
// Debugging will not be available with this module and
// error handling may not be as good as with the other modules

$ftp_debug = true; // Debugging output that may help you to resolve ftp problems


// UT Server 1
$i = 0;
$ftp_hostname[$i] = '108.61.255.210'; // FTP server location here
$ftp_port[$i] = 21; // FTP Port - do not remove this even if you do not use ftp
// Do not add '' around the port either
$ftp_uname[$i] = 'xxx'; // FTP Username
$ftp_upass[$i] = 'xxx'; // FTP Password
$ftp_dir[$i][] = '/Logs'; // Directory of the log files - MUST NOT end with a /
//$ftp_dir[$i][] = '/'; // You may repeat this entry as often as you wish but please remember
//$ftp_dir[$i][] = '/'; // to enter the directory relative to the last one
//$ftp_dir[$i][] = '/'; // (or use an absolute path)
$ftp_passive[$i] = true; // Use passive transfer mode for this connection?
$ftp_delete[$i] = true; // Delete logs after download?


// UT Server 2
$i++;
$ftp_hostname[$i] = '62.67.42.207'; // FTP server location here
$ftp_port[$i] = 21; // FTP Port - do not remove this even if you do not use ftp
// Do not add '' around the port either
$ftp_uname[$i] = 'xxx'; // FTP Username
$ftp_upass[$i] = 'xxx'; // FTP Password
$ftp_dir[$i][] = '/Logs'; // Directory of the log files - MUST NOT end with a /
//$ftp_dir[$i][] = '/'; // You may repeat this entry as often as you wish but please remember
//$ftp_dir[$i][] = '/'; // to enter the directory relative to the last one
//$ftp_dir[$i][] = '/'; // (or use an absolute path)
$ftp_passive[$i] = true; // Use passive transfer mode for this connection?
$ftp_delete[$i] = true; // Delete logs after download?

?>

maybe is something more to set up for showing server 2 on stats?
__________________
Reply With Quote
  #30  
Unread 14th January, 2013, 10:06 PM
rork's Avatar
rork rork is offline
Godlike
 
Join Date: Nov 2007
Posts: 264
Default

Quote:
Originally Posted by zavateandu View Post
one more thing that i couldn't get it work
is about showing 2 servers in utstats page
everything is working ok ,the logs are imported for both servers but i can not get it work for 2 servers

maybe is something more to set up for showing server 2 on stats?
UTStats doesn't separate the servers in the stats, the only page where different servers can be seen is at Servers, there's also a list of matches played on that server there. However, playerstats etc. are all calculated over both servers.
__________________
Admin of XOL DOG CTF Fun server: 81.169.188.18 - Stats & dU Coop: 85.14.203.180:5555 - Forum
Reply With Quote
  #31  
Unread 15th January, 2013, 05:34 AM
zavateandu's Avatar
zavateandu zavateandu is offline
Dominating
 
Join Date: Nov 2010
Posts: 171
Default

yes m8 i know but if i press server i see only 1 server in stats and should be the both servers listed there .
my problem is that the stats collect the logs and should create the second server name on server stats but it doesnt
__________________
Reply With Quote
  #32  
Unread 15th January, 2013, 05:37 PM
rork's Avatar
rork rork is offline
Godlike
 
Join Date: Nov 2007
Posts: 264
Default

Can you email me some logs of both servers? I'd like to see what's going on.

Sent email by pm.
__________________
Admin of XOL DOG CTF Fun server: 81.169.188.18 - Stats & dU Coop: 85.14.203.180:5555 - Forum
Reply With Quote
  #33  
Unread 2nd February, 2013, 10:18 PM
McNamara's Avatar
McNamara McNamara is offline
Dominating
 
Join Date: Aug 2007
Location: UK
Posts: 100
Default

is this version final? or will there be some updates?
__________________

My BunnyTrack maps
http://www.i4games.eu/maps/?author=18724
Reply With Quote
  #34  
Unread 9th February, 2013, 10:43 AM
rork's Avatar
rork rork is offline
Godlike
 
Join Date: Nov 2007
Posts: 264
Default

I did some work a couple of months ago:
Thread
Beta patch

Never got to proper testing some features and packing it all up...
__________________
Admin of XOL DOG CTF Fun server: 81.169.188.18 - Stats & dU Coop: 85.14.203.180:5555 - Forum
Reply With Quote
  #35  
Unread 17th April, 2014, 05:00 PM
InstaG InstaG is offline
Forum Newcomer
 
Join Date: Feb 2014
Posts: 1
Default

Hello guys,
I was trying to put utstats 428 on my Server, I make de database, Load the files to my site and Config the file Config.php
Then When I try to join the site and log in, this is the message:
"No database selected"
What do I have to do?
Any of you guys can Help me please.
Reply With Quote
  #36  
Unread 18th April, 2014, 02:01 AM
2399Skillz 2399Skillz is offline
Super Moderator
 
Join Date: Jan 2004
Location: North Carolina
Posts: 2,241
Default

You have to enter the name of the database into the config.php file.

// Database connection details
$dbname = "database_name";
$hostname = "127.0.0.1";
$uname = "user_for_the_database";
$upass = "the_password";

Change database_name to the name of your database.
Change user_for_the_database to the name of the user who has access to the database.
Change the_password to the password the user uses to gain access to that database.
__________________

UT-FILES.COM
Get your files
Reply With Quote
  #37  
Unread 7th May, 2014, 06:32 PM
mattackUY mattackUY is offline
Forum Newcomer
 
Join Date: Oct 2013
Posts: 3
Default can`t import

Hi! I'm having some problems when I try to import. I've already configured everything what the install.txt says, but still can't get my logs imported. Do I have to CHMOD 777 my Log directory from the UT server? Also tried to import via ftp configuring the config.php file, using all modules, "sockets", "pure" and "php", but still can't get it. Any suggestion someone?
Reply With Quote
  #38  
Unread 8th May, 2014, 03:11 AM
zavateandu's Avatar
zavateandu zavateandu is offline
Dominating
 
Join Date: Nov 2010
Posts: 171
Default

please check ftp debug ,import via ftp and copy/paste the log file.we can see where is the problem
__________________
Reply With Quote
  #39  
Unread 8th May, 2014, 05:29 PM
mattackUY mattackUY is offline
Forum Newcomer
 
Join Date: Oct 2013
Posts: 3
Default

Here it's what the log return:

Staring FTP client class with PORT mode support
UMASK 022
Transfer type: auto ASCII
Timeout 30
Passive mode off
Connect to:

- Server: 190.210.177.151

- Port: 21


Host "190.210.177.151(190.210.177.151):21"
Local OS : UNIX
Using PHP's socket extension
Creating socket
Connecting to "190.210.177.151:21"
_connect: socket connect failed (Operation now in progress)
Error : Cannot connect to remote host "190.210.177.151 :21"

Reply With Quote
  #40  
Unread 8th May, 2014, 06:38 PM
mattackUY mattackUY is offline
Forum Newcomer
 
Join Date: Oct 2013
Posts: 3
Default

Also enabled the debug option in the import.php and this is the output:
http://k39.kn3.net/B/7/7/8/7/2/920.png

Last edited by mattackUY : 8th May, 2014 at 06:42 PM.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:21 PM.


Powered by vBulletin® Version 3.6.7
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

All pages are copyright The Unreal Admins Page.
You may not copy any pages without our express permission.