[MOD] Search Statistics v1.2

[RoadDogg]

It gives same worth as your first code ?

[V@no]

It gives same worth as your first code ?

as I said I didnt test it.
also if u didnt remove my first code, then it will owerwrite result from the last posted code.

[RoadDogg]

Code: [Select]

$sql = "SELECT SUM(count) AS num
        FROM ".SEARCH_STATS_TABLE;
$total = $site_db->query_firstrow($sql);
$site_template->register_vars("total_count", $total['num']);
It works, no idea what I did yesterday. Uploaded wrong file or something 

  Thank you 

[Vincent]

Hello
could you tell me how to reset the search statistic?

sincerly
vincent

[RoadDogg]

clear 4images_search_stats table via phpMyadmin?!

[artpics]

hello i have installed this mod all is working but i get this printed out



on screen, where in the code can i remove this please v1.71, i have deleted the DB field and run the stats_install but still the same


thanks

RT

[artpics]

is this why this is happening
  http://www.4homepages.de/forum/index.php?topic=6806.0

as it did not show these tags when i had 1.7

edited ..................

yes i found the answer click above 

[max.cady]

Danke für den Link zu dem conditional tags mod. Ich hatte das gleiche Problem .... ist jetzt gelöst 

[artpics]

 

[Dandily]

I have a strange thing, only phrases are added to search statistics...
i check the mysql with phpMyAdmin and there are no words, only phrases...

Search are working good, but i have no statistics about searching words.

What it could be?

[V@no]

recheck Step 1.2

P.S. so, where does the single word goes after the search?
For example try to search for a random, unique string, and check database if that string was added at all.

P.P.S. can we test it?

[Dandily]

Thanks a lot!

It was my stuipid fault...
I was trying to install this mod two times, but every time i missed step 1.2

Thanks again.

P.S. I`m also from Russia, but i`m from Moscow.

[SAD]

Look stats only admin.

Open search_stats.php

find

Code: [Select]

include(ROOT_PATH.'includes/page_header.php');

add after

Code: [Select]

if ($user_info['user_level'] != ADMIN) {
  show_error_page($lang['no_permission']);
}


[Vincent]

Hello
i have the Problem that the words are added to the Phrases - but i have added step 1.2

http://www.foto-kocher.com/search_stats.php

Code: [Select]

    elseif ($split_words[$i] != "" && strlen($split_words[$i]) >= MIN_SEARCH_KEYWORD_LENGTH && strlen($split_words[$i]) <= MAX_SEARCH_KEYWORD_LENGTH && !in_array($split_words[$i], $stopword_list)) {
// start Search_stat
if (count($split_words) == 1) {
      $sql = "UPDATE ".SEARCH_STATS_TABLE."
      SET count = count + 1, word = 1, date = ".time().", ".$who." = ".$who." + 1
      WHERE text LIKE '".addslashes(str_replace("*", "", $split_words[$i]))."' AND word = 1";
      $site_db->query($sql);
    if (!$site_db->affected_rows()) {
      $sql = "INSERT INTO ".SEARCH_STATS_TABLE."
              (text, word, date, ".$who.")
              VALUES
              ('".addslashes(str_replace("*", "", $split_words[$i]))."', 1, ".time().", 1)";
      $site_db->query($sql);
    }
}
// end Search_stat
so who else coud be the fault?

[Vincent]

i Found out that this mess with phrase and word only happen with count, if i change to date it works fine!

why this happen?

and would do i have to change to have it by default sorted by date?

sincerly
vincent