Beta2: Webstat mod - RC4 valid

[sporto]

Actually I just looked again at the database and the tables are getting populated with the data so the tracking is working. But I'm getting the "can't connect" error on the admin backend.

[frold]

Code: Select all

#
#-----[ Open ]------------------------------------------
#
phpOpenTracker\phpOpenTracker\conf\phpOpenTracker.php

try manually to put in your database settings here

// Database Type
// Available values: 'mssql', 'mysql', 'oci8', 'pgsql'
$PHPOPENTRACKER_CONFIGURATION['db_type'] = 'mysql';

// The host of your database server
$PHPOPENTRACKER_CONFIGURATION['db_host'] = $phpwcms["db_host"];

// The port your database server listens on
$PHPOPENTRACKER_CONFIGURATION['db_port'] = 'default';

// The socket your database server uses
$PHPOPENTRACKER_CONFIGURATION['db_socket'] = 'default';

// Username to connect with to your database server
$PHPOPENTRACKER_CONFIGURATION['db_user'] = $phpwcms["db_user"];

// Password to connect with to your database server
$PHPOPENTRACKER_CONFIGURATION['db_password'] = $phpwcms["db_pass"];

// Name of the database to use.
$PHPOPENTRACKER_CONFIGURATION['db_database'] = $phpwcms["db_table"];

[frold]

oooops, sorry

you need to change the prefixes used in the database tables

// Name of the Additional Data Table
// Default: 'pot_add_data'
$PHPOPENTRACKER_CONFIGURATION['additional_data_table'] = 'pot_add_data';

// Name of the Access Log Table
// Default: 'pot_accesslog'
$PHPOPENTRACKER_CONFIGURATION['accesslog_table'] = 'pot_accesslog';

// Name of the Documents Table
// Default: 'pot_documents'
$PHPOPENTRACKER_CONFIGURATION['documents_table'] = 'pot_documents';

// Name of the Exit Targets Table
// Default: 'pot_exit_targets'
$PHPOPENTRACKER_CONFIGURATION['exit_targets_table'] = 'pot_exit_targets';

// Name of the Hostnames Table
// Default: 'pot_hostnames'
$PHPOPENTRACKER_CONFIGURATION['hostnames_table'] = 'pot_hostnames';

// Name of the Operating Systems Table
// Default: 'pot_operating_systems'
$PHPOPENTRACKER_CONFIGURATION['operating_systems_table'] = 'pot_operating_systems';

// Name of the Referers Table
// Default: 'pot_referers'
$PHPOPENTRACKER_CONFIGURATION['referers_table'] = 'pot_referers';

// Name of the User Agents Table
// Default: 'pot_user_agents'
$PHPOPENTRACKER_CONFIGURATION['user_agents_table'] = 'pot_user_agents';

// Name of the Visitors Table
// Default: 'pot_visitors'
$PHPOPENTRACKER_CONFIGURATION['visitors_table'] = 'pot_visitors';

change pot_ to your prefix

[sporto]

I'll try this later tonight and see how it goes, but first help me understand...

I installed the default SQL file via PHPMyAdmin which includes pot_ as a prefix. My database happens to use cms_ as a prefix for all tables.

Now, the tracking is already working - data is being entered into the tables just fine. It's only on the backend admin where I can't access the information. So if I change the prefix on the data, aren't I going to mess up getting the data into the database?

Sorry I'm taking up so much time on this. THanks for your help!

[frold]

Now, the tracking is already working - data is being entered into the tables just fine. It's only on the backend admin where I can't access the information. So if I change the prefix on the data, aren't I going to mess up getting the data into the database?

Then you don´t need to change prefixes..... But why I will not work - I can´t answer right now, sry....

I will take a look on it tonight...

[sporto]

Thanks for your help Frold.

Could it help if I upgrade from RC3 to RC4?

[frold]

Thanks for your help Frold.

Could it help if I upgrade from RC3 to RC4?

Well I don´t think so... but it will fix some bugs in phpwcms and add some new features...

[jmeyknecht]

hi everybody.

because i read some people did claim about a non working vts + RC4, i did a fresh install of RC4 and the vts package from eMediaFabrik.
and, sorry guys, it was working alright. no error. it tracks visitors and viewing in backend is also working.

i have no clue at the mom, why it isn't working at some ppls sites :-/

[Mario670]

When I use this Tool, my URLs look like this:

Code: Select all

www.content.shoppic.de/homepageerstellung.html?PHPSESSID=87ec2bd6fc7f116de6651a5883e94a2b 

normaly:

Code: Select all

www.content.shoppic.de/homepageerstellung.html

Where is the problem?

Mario

[taurentius]

Not sure if this is the right place to post, but I did not think it was worth a separate thread. At any rate, I've made a Dutch translation of the WEBSTATS add-on.

--- CREATE ---
include/inc_ext/phpOpenTracker/lang/nl/
include/inc_ext/phpOpenTracker/lang/nl/lang.inc.php

--- OPEN ---
include/inc_ext/phpOpenTracker/lang/nl/lang.inc.php

--- ADD ---

Code: Select all

<?php

// added by Christian Günther (guenther@emediafabrik.de)
// and Johannes Meyknecht (meyknecht@emediafabrik.de) for VTS phpOpenTracker
// translated by Tim van Pelt (taurentius@hotmail.com)
$BL['be_nav_vts']                       = 'WEBSTATS';
$BL['be_subnav_vts_total']              = 'Totaal';
$BL['be_subnav_vts_currhour']           = 'Dit uur';
$BL['be_subnav_vts_lasthour']           = 'Vorig uur';
$BL['be_subnav_vts_today']              = 'Vandaag';
$BL['be_subnav_vts_yesterday']          = 'Gisteren';
$BL['be_subnav_vts_currweek']           = 'Deze week';
$BL['be_subnav_vts_lastweek']           = 'Vorige week';
$BL['be_subnav_vts_curryear']           = 'Dit jaar';
$BL['be_subnav_vts_lastyear']           = 'Vorig jaar';

$BL['be_vts_currhour']                  = 'Dit uur';
$BL['be_vts_lasthour']                  = 'Vorig uur';
$BL['be_vts_today']                     = 'Vandaag';
$BL['be_vts_yesterday']                 = 'Gisteren';
$BL['be_vts_currweek']                  = 'Deze week';
$BL['be_vts_lastweek']                  = 'Vorige week';
$BL['be_vts_currmonth']                 = 'Deze maand';
$BL['be_vts_lastmonth']                 = 'Vorige maand';
$BL['be_vts_curryear']                  = 'Dit jaar';
$BL['be_vts_lastyear']                  = 'Vorig jaar';

$BL['be_vts_total']                     = 'totaal';
$BL['be_vts_one_time_visitors']         = '&eacute;&eacute;n keer';
$BL['be_vts_returning_visitors']        = 'terugkerend';
$BL['be_vts_unique_visitors']           = 'uniek';
$BL['be_vts_return_visits']             = 'teruggekeerd';
$BL['be_vts_visitors_online']           = 'online';

$BL['be_vts_visits']                    = 'Bezoeken';
$BL['be_vts_visitor']                   = 'Bezoekers';
$BL['be_vts_browser']                   = 'Browser';
$BL['be_vts_os']                        = 'Besturingssysteem';
$BL['be_vts_host']                      = 'Host';
$BL['be_vts_document']                  = 'Document';
$BL['be_vts_referer']                   = 'Verwijzers';

//added by frold
$BL['be_vts_name']                      = 'Naam';
$BL['be_vts_times']                     = 'Totaal';
$BL['be_vts_procent']                   = 'Procent';
$BL['be_vts_search_engines']            = 'Zoekmachines';
$BL['be_vts_search_keywords']           = 'Zoekwoorden';
$BL['be_vts_search_combi']              = 'Gecombineerde statistieken';

?>

Hopefully this will be useful to someone.

[jmeyknecht]

cool taurentius.
can we include this into the our VTS-Mod?
if, we would have (de, en, nl support now)
other languages are welcome too...

[taurentius]

Sure you can It's a pleasure to be of assistance.

I was thinking that the functionality of the VTS/WebStats plug-in could be enhanced by making use of an IP-to-Country database such as the free one at http://ip-to-country.webhosting.info. That way you could rank users on their country of origin as well.

Also, an I have no idea how feasible this would be, it would be nice to include statistics on screen resolution and installed plugins (Flash etc.).

Just some suggestions. Must say I'm impressed by the simple and clean interface to the statistics, nice work!

[captaincrash]

I was also experiencing the...

Code: Select all

phpOpenTracker Error: Access denied for user

...error some of you guys had. I eventually figured it out to be my ISP (Plus.Net) not setting permissions correctly on my MySQL account so the CREATE TEMPORARY TABLE query was failing.

Hope this helps someone.

[sporto]

I eventually figured it out to be my ISP (Plus.Net) not setting permissions correctly on my MySQL account so the CREATE TEMPORARY TABLE query was failing.

Thanks for this info. How did you figure out that it was your ISP? And what did they do to correct the situation? Thanks

Mark

[captaincrash]

I switched on extended logging in the config file and traced the exact query that was failing and recreated this in phpMyAdmin which also produced the access denied message.

In MySQL their is a specific role CREATE TEMPORARY TABLES so the guys at plus net have just run a GRANT CREATE TEMPORARY TABLES to resolve this.

Happy to help,