Wie stellt man die Google-Besuche schnell fest?

[Dominik Müller]

Hallo zusammen,

wie kann ich am schnellsten und einfachsten nachschauen, wie oft Google mein Forum besucht/besucht hat ??

Grüße
Dominik

[gloriosa]

Hallo,
mit dem Google Visit Counter :

Code: Alles auswählen

############################################################################ 
## MOD Ttile : Google Visit Counter
## MOD Author : Dr DLP http://www.web-lapin.levillage.org/forum/
## MOD Description : Adds a google bot visit counter on index 
## MOD Version : 1.0.0. 
## 
## Scripts : 
## Google Track : Mojy ( < webmaster@mypsychedelicsite.com > (J.M.) 
## http://www.mypsychedelicsite.com ) / Editeur Javascrpit
## Visit Counter : Smartor ( < smartor_xp@hotmail.com > (Hoang Ngoc Tu) http://smartor.is-root.com 
##
##      Installation level : Easy 
##      Iinstallation time : 5 Minutes 
##
##      Files to edit  : 3
##      -language/lang_french/lang_main.php
##      -includes/page_header.php
##      -templates/subSilver/index_body.tpl
##
##      Files to include : n/a 
##
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
################################################################# 

#
#------[ SQL ]-------
#
INSERT INTO phpbb_config (config_name, config_value) VALUES ('google_visit_counter', '1');


#
#-----[ OPEN ]----------------------------------------
#
language/lang_english/lang_main.php

#
#-----[ FIND ]-----------------------------------
#
//
// That's all, Folks!


#
#-----[ BEFORE , ADD ]-----------------------------
#

$lang['Google_Visit_counter'] = 'Google has come <b>%d</b> times on this board since May 2005';

#
#-----[ OPEN ]----------------------------------------
#
language/lang_german/lang_main.php

#
#-----[ FIND ]-----------------------------------
#
//
// That's all, Folks!


#
#-----[ BEFORE , ADD ]-----------------------------
#

$lang['Google_Visit_counter'] = 'Google has come <b>%d</b> times on this board since May 2005';

#
#-----[ OPEN ]------------------------------------------
#
includes/page_header.php

#
#-----[ FIND ]------------------------------------------
#
//
// Parse and show the overall header.
//
$template->set_filenames(array(
	'overall_header' => ( empty($gen_simple_header) ) ? 'overall_header.tpl' : 'simple_header.tpl')
);

#
#-----[ BEFORE , ADD ]-------------------------------------
#
//
// Dr DLP's Google Visit Counter MOD
//
$google_visit_counter = $board_config['google_visit_counter'];

$tmp_list = explode(".", $REMOTE_ADDR);
if (($tmp_list[0] == "64" && $tmp_list[1] == "68" && $tmp_list[2] == "82") || ($tmp_list[0] == "216" && $tmp_list[1] == "239" && $tmp_list[2] == "46"))
{
	$sql = "UPDATE " . CONFIG_TABLE . "
			SET config_value = '" . ($google_visit_counter + 1) . "'
			WHERE config_name = 'google_visit_counter'";
	if( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not update google counter information', '', __LINE__, __FILE__, $sql);
	}

	$google_visit_counter++;
}
// ------------------------------------
//


#
#-----[ FIND ]-------------------------------------------
#
	'NAV_LINKS' => $nav_links_html)

#
#-----[ BEFORE , ADD ]------------------------------------
#
	// Google Counter MOD
	'GOOGLE_VISIT_COUNTER' => sprintf($lang['Google_Visit_counter'], $google_visit_counter),

#
#-----[ OPEN ]---------------------------------
#
templates/subSilver/index_body.tpl


#
#-----[ FIND ]---------------------------------
#
<td class="row1" align="left" width="100%"><span class="gensmall">{TOTAL_POSTS}<br />{TOTAL_USERS}<br />{NEWEST_USER}

#
#-----[ IN-LINE , AFTER , ADD ]-------------------
#
<br />{GOOGLE_VISIT_COUNTER}

# 
#-----[ SAVE/CLOSE ALL FILES ]----------- 
# 
# EoM

[Dominik Müller]

Wenn ich den SQL-Befehl gebe, kommt folgende Meldung:

SQL-Befehl:

SELECT *
FROM WHERE LIKE 'google_visit_counter'

MySQL meldet:

#1062 - Duplicate entry 'google_visit_counter' for key 1

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /var/www/phpMyAdmin-2.6.1/libraries/common.lib.php on line 685

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE LIKE 'google_visit_counter'' at line 1

Was heißt das?

Grüße
Dominik

[gloriosa]

Hallo,
das bedeutet :

#1062 - Duplicate entry 'google_visit_counter' for key 1

das die SQL-Anweisung

Code: Alles auswählen

INSERT INTO phpbb_config (config_name, config_value) VALUES ('google_visit_counter', '1');

schon (einmal ?) ausgeführt wurde und als Eintrag in der Tabelle bereits vorhanden ist !