Changeset 7676


Ignore:
Timestamp:
Nov 7, 2010, 4:48:04 PM (10 years ago)
Author:
grum
Message:

fix bug:2009 - MySQL error on search tab
fix bug:2012 - MySQL 5.1 incompatibility

Location:
extensions/GMaps
Files:
4 edited

Legend:

Unmodified
Added
Removed
  • extensions/GMaps/gmaps_rb_callback.class.inc.php

    r7128 r7676  
    7474    $returned.=" AND pgc.latitude >= ".$param['bounds']['south']."
    7575                 AND pgc.latitude <= ".$param['bounds']['north']."
    76                  AND pgc.userId='".$user['id']."'
    7776                 AND pgc.requestId='".$param['requestId']."' ";
    7877
  • extensions/GMaps/gmaps_root.class.inc.php

    r7619 r7676  
    358358      $date=date('Y-m-d H:i:s', time()-$time);
    359359
    360       $sql="DELETE FROM ".$this->tables['cache']." pgc
    361               USING ".$this->tables['cache']." pgc
     360      $sql="DELETE FROM ".$this->tables['cache']."
     361              USING ".$this->tables['cache']."
    362362                JOIN ".$this->tables['cache_id']." pgci
    363                 ON pgc.requestId = pgci.requestId
     363                ON ".$this->tables['cache'].".requestId = pgci.requestId
    364364            WHERE pgci.`date` < '$date';";
    365365      pwg_query($sql);
  • extensions/GMaps/gmaps_version.inc.php

    r7616 r7676  
    1515  if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
    1616
    17   define('GMAPS_VERSION',  '1.2.3');
    18   define('GMAPS_VERSION2', '01.02.03');
     17  define('GMAPS_VERSION',  '1.2.4');
     18  define('GMAPS_VERSION2', '01.02.04');
    1919  define('GMAPS_GPC_NEEDED', '3.3.2');
    2020  define('GMAPS_AMD_NEEDED', '0.5.2'); //advanced metadata plugin is needed
  • extensions/GMaps/main.inc.php

    r7616 r7676  
    22/*
    33Plugin Name: GMaps
    4 Version: 1.2.3
     4Version: 1.2.4
    55Description: Display and manage (google) maps
    66Plugin URI: http://phpwebgallery.net/ext/extension_view.php?eid=454
     
    8585|         |            |     inserted in category description
    8686|         |            |
     87| 1.2.4   | 2010-11-05 | * mantis bug:2009
     88|         |            |   . MySQL error on search tab
     89|         |            |
     90|         |            | * mantis bug:2012
     91|         |            |   . MySQL 5.1 incompatibility
     92|         |            |
     93|         |            |
     94|         |            |
     95|         |            |
     96|         |            |
     97|         |            |
     98|         |            |
    8799|         |            |
    88100
Note: See TracChangeset for help on using the changeset viewer.