Changeset 96959 in spip-zone
- Timestamp:
- May 2, 2016, 1:30:25 PM (5 years ago)
- Location:
- _plugins_/shortcut_url/trunk
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
_plugins_/shortcut_url/trunk/README.md
r96915 r96959 13 13 14 14 ## Changelog 15 16 ### Version 1.1.4 (02/05/2016) 17 18 - Content-type sur les fichiers json 19 - Fix un bug sur les graphs des bots 20 - i18n pour les dates sur les graphs 15 21 16 22 ### Version 1.1.3 (30/04/2016) -
_plugins_/shortcut_url/trunk/paquet.xml
r96915 r96959 2 2 prefix="shortcut_url" 3 3 categorie="edition" 4 version="1.1. 3"4 version="1.1.4" 5 5 etat="stable" 6 6 compatibilite="[3.0.0;3.1.*]" -
_plugins_/shortcut_url/trunk/shortcut_url_fonctions.php
r96915 r96959 47 47 */ 48 48 function shortcut_compteur($id_shortcut_url){ 49 50 $shorturl = sql_fetsel('url,click', 'spip_shortcut_urls', 'id_shortcut_url='.intval($id_shortcut_url));51 52 $date_modif = date('Y-m-d H:m:i');53 $referrer = $_SERVER['REMOTE_ADDR'];54 $user_agent = get_user_agent();55 $ip_address = $_SERVER['SERVER_ADDR'];56 $country_code = get_geoip($referrer);57 $click = $shorturl['click']+1;58 59 49 if (!defined('_IS_BOT')) 60 50 define('_IS_BOT', … … 70 60 ); 71 61 62 $ip_address = $_SERVER['SERVER_ADDR']; 63 72 64 if(_IS_BOT) { 73 $humain = 'bot'; 74 $insert_bot = sql_insertq('spip_shortcut_urls_bots', array('id_shortcut_url' => $id_shortcut_url,'date_modif' => $date_modif,'referrer' => $referrer,'user_agent' => $user_agent,'ip_address' => $ip_address)); 65 $appele = sql_getfetsel('id_shortcut_url','spip_shortcut_urls_bots','ip_address = ' . sql_quote($ip_address) . ' AND id_shortcut_url = ' .intval($id_shortcut_url) . ' AND date_modif < ' . date('Y-m-d H:i:s',strtotime('-30 seconds'))); 66 }else{ 67 $appele = sql_getfetsel('id_shortcut_url','spip_shortcut_urls_logs','ip_address = ' . sql_quote($ip_address) . ' AND id_shortcut_url = ' .intval($id_shortcut_url) . ' AND date_modif < ' . date('Y-m-d H:i:s',strtotime('-30 seconds'))); 68 } 69 if(!$appele){ 70 $shorturl = sql_fetsel('url, click', 'spip_shortcut_urls', 'id_shortcut_url=' . intval($id_shortcut_url)); 71 72 $date_modif = date('Y-m-d H:m:i'); 73 $referrer = $_SERVER['REMOTE_ADDR']; 74 $user_agent = get_user_agent(); 75 76 $country_code = get_geoip($referrer); 77 $click = $shorturl['click']+1; 75 78 $insert_click = sql_updateq('spip_shortcut_urls', array('click' => $click), 'id_shortcut_url=' . intval($id_shortcut_url)); 76 } else { 77 $humain = 'oui'; 78 $insert = sql_insertq('spip_shortcut_urls_logs', array('id_shortcut_url' => $id_shortcut_url,'date_modif' => $date_modif,'shorturl' => $shorturl['url'],'referrer' => $referrer,'user_agent' => $user_agent,'ip_address' => $ip_address,'country_code' => $country_code,'humain' => $humain)); 79 $insert_click = sql_updateq('spip_shortcut_urls', array('click' => $click), 'id_shortcut_url=' . intval($id_shortcut_url)); 79 80 if(_IS_BOT) { 81 $humain = 'bot'; 82 $insert_bot = sql_insertq('spip_shortcut_urls_bots', array('id_shortcut_url' => $id_shortcut_url,'date_modif' => $date_modif,'referrer' => $referrer,'user_agent' => $user_agent,'ip_address' => $ip_address)); 83 } else { 84 $humain = 'oui'; 85 $insert = sql_insertq('spip_shortcut_urls_logs', array('id_shortcut_url' => $id_shortcut_url,'date_modif' => $date_modif,'shorturl' => $shorturl['url'],'referrer' => $referrer,'user_agent' => $user_agent,'ip_address' => $ip_address,'country_code' => $country_code,'humain' => $humain)); 86 } 80 87 } 81 82 88 return false; 83 89 }
Note: See TracChangeset
for help on using the changeset viewer.