WordPress.org

Plugin Directory

Changeset 566813


Ignore:
Timestamp:
07/03/12 08:44:47 (22 months ago)
Author:
SteveAtty
Message:

Version 2.5 : fixes DB location

Location:
canalplan-ac
Files:
5 edited
14 copied

Legend:

Unmodified
Added
Removed
  • canalplan-ac/tags/2.5/admin-pages/cp-admin-general.php

    r537712 r566813  
    9595    $res = mysql_query($sql); 
    9696    $res2=mysql_fetch_array($res); 
    97     $handle=fopen("http://www.canalplan.org.uk/stable_canal.sqlite","rb"); 
     97    $handle=fopen("http://www.canalplan.org.uk/data/stable_canal.sqlite","rb"); 
    9898    $handle2=fopen("../wp-content/uploads/canalplan_data.sqlite","w"); 
    9999    $contents = ''; 
  • canalplan-ac/tags/2.5/canalplan.php

    r559376 r566813  
    44Plugin URI: http://blogs.canalplan.org.uk/canalplanac/canalplan-plug-in/ 
    55Description: Provides features to integrate your blog with <a href="http://www.canalplan.eu">Canalplan AC</a> - the Canal Route Planner. 
    6 Version: 2.4 
     6Version: 2.5 
    77Author: Steve Atty 
    88Author URI: http://blogs.canalplan.org.uk/steve/ 
     
    2929define ('CANALPLAN_GAZ_URL','http://www.canalplan.eu/gazetteer/'); 
    3030define ('CANALPLAN_MAX_POST_PROCESS',20); 
    31 define('CANALPLAN_CODE_RELEASE','2.4.0 r00'); 
     31define('CANALPLAN_CODE_RELEASE','2.5.0 r00'); 
    3232 
    3333global $table_prefix, $wp_version,$wpdb,$db_prefix; 
     
    242242        $res = mysql_query($sql); 
    243243        $row = mysql_fetch_array($res); 
     244        if (count($row) > 2) { 
    244245        if($place_count==$mid_point) { 
    245246            $centre_lat=$row[lat]; 
     
    257258            $last_long=$row[long]; 
    258259        } 
     260    //  echo count($row).' - '.$place." - ".$row[place_name]." : ".$row[lat]." - ".$row[long]."<br />"; 
    259261        $points=$place.",".$row[lat].",".$row[long]; 
    260262            $pointx = $row[lat]; 
     
    276278        $y=$y+1; 
    277279        $lpoint=$cpoint; 
     280        } 
    278281    } 
    279282 
     
    636639            $res = mysql_query($sql); 
    637640            $row = mysql_fetch_array($res); 
     641            if (count($row)> 2) { 
    638642            if ($place==$firstid){ 
    639643                $firstname=$row[place_name]; 
     
    681685            $markertext.='iconFile = "http://maps.google.com/mapfiles/ms/icons/green-dot.png"; marker_start'.$dogooglemap.'.setIcon(iconFile) ; '; 
    682686            $markertext.='iconFile = "http://maps.google.com/mapfiles/ms/icons/red-dot.png"; marker_stop'.$dogooglemap.'.setIcon(iconFile) ; ';  
    683         } 
     687        }} 
    684688        #$blroute .=$pointstring; 
    685689        $options['size']=200; 
  • canalplan-ac/tags/2.5/canalplan/canalplan.php

    r408484 r566813  
    11<?php 
    2 $match=$_GET['match']; 
    3 $place=$_GET['place']; 
    4 $cp_blog_id=$_GET['blogid']; 
     2 
     3 
    54require("../../../../wp-config.php"); 
    65if ($cp_blog_id=="undefined") {unset($cp_blog_id);} 
    76if (strlen($match)>0){ 
     7$match=mysql_real_escape_string($_GET['match']); 
     8$place=mysql_real_escape_string(_GET['place']); 
     9$cp_blog_id=mysql_real_escape_string($_GET['blogid']); 
     10 
    811$sql="set names 'utf8';"; 
    912$zed = mysql_query($sql); 
  • canalplan-ac/tags/2.5/readme.txt

    r559376 r566813  
    44Tags: crosspost, Canalplan 
    55Requires at least: 3.0 
    6 Tested up to: 3.4 
    7 Stable tag: 2.4 
     6Tested up to: 3.4.1 
     7Stable tag: 2.5 
    88 
    99== Description == 
     
    5353== Changelog == 
    5454 
     55= Version 2.5 03/07/2012 = 
     56- Rebuilding the blog revealed a glitch when a place vanished from the database which messed up the maps. Now fixed. 
     57- Database moved on live server - so local data wasn't updating. 
     58 
    5559= Version 2.4 17/06/2012 = 
    5660- Fixed a problem with blogged routes. Was coded to expect a .htaccess re-write rule. No-one seems to have noticed though! 
  • canalplan-ac/trunk/admin-pages/cp-admin-general.php

    r537712 r566813  
    9595    $res = mysql_query($sql); 
    9696    $res2=mysql_fetch_array($res); 
    97     $handle=fopen("http://www.canalplan.org.uk/stable_canal.sqlite","rb"); 
     97    $handle=fopen("http://www.canalplan.org.uk/data/stable_canal.sqlite","rb"); 
    9898    $handle2=fopen("../wp-content/uploads/canalplan_data.sqlite","w"); 
    9999    $contents = ''; 
  • canalplan-ac/trunk/canalplan.php

    r559376 r566813  
    44Plugin URI: http://blogs.canalplan.org.uk/canalplanac/canalplan-plug-in/ 
    55Description: Provides features to integrate your blog with <a href="http://www.canalplan.eu">Canalplan AC</a> - the Canal Route Planner. 
    6 Version: 2.4 
     6Version: 2.5 
    77Author: Steve Atty 
    88Author URI: http://blogs.canalplan.org.uk/steve/ 
     
    2929define ('CANALPLAN_GAZ_URL','http://www.canalplan.eu/gazetteer/'); 
    3030define ('CANALPLAN_MAX_POST_PROCESS',20); 
    31 define('CANALPLAN_CODE_RELEASE','2.4.0 r00'); 
     31define('CANALPLAN_CODE_RELEASE','2.5.0 r00'); 
    3232 
    3333global $table_prefix, $wp_version,$wpdb,$db_prefix; 
     
    242242        $res = mysql_query($sql); 
    243243        $row = mysql_fetch_array($res); 
     244        if (count($row) > 2) { 
    244245        if($place_count==$mid_point) { 
    245246            $centre_lat=$row[lat]; 
     
    257258            $last_long=$row[long]; 
    258259        } 
     260    //  echo count($row).' - '.$place." - ".$row[place_name]." : ".$row[lat]." - ".$row[long]."<br />"; 
    259261        $points=$place.",".$row[lat].",".$row[long]; 
    260262            $pointx = $row[lat]; 
     
    276278        $y=$y+1; 
    277279        $lpoint=$cpoint; 
     280        } 
    278281    } 
    279282 
     
    636639            $res = mysql_query($sql); 
    637640            $row = mysql_fetch_array($res); 
     641            if (count($row)> 2) { 
    638642            if ($place==$firstid){ 
    639643                $firstname=$row[place_name]; 
     
    681685            $markertext.='iconFile = "http://maps.google.com/mapfiles/ms/icons/green-dot.png"; marker_start'.$dogooglemap.'.setIcon(iconFile) ; '; 
    682686            $markertext.='iconFile = "http://maps.google.com/mapfiles/ms/icons/red-dot.png"; marker_stop'.$dogooglemap.'.setIcon(iconFile) ; ';  
    683         } 
     687        }} 
    684688        #$blroute .=$pointstring; 
    685689        $options['size']=200; 
  • canalplan-ac/trunk/canalplan/canalplan.php

    r408484 r566813  
    11<?php 
    2 $match=$_GET['match']; 
    3 $place=$_GET['place']; 
    4 $cp_blog_id=$_GET['blogid']; 
     2 
     3 
    54require("../../../../wp-config.php"); 
    65if ($cp_blog_id=="undefined") {unset($cp_blog_id);} 
    76if (strlen($match)>0){ 
     7$match=mysql_real_escape_string($_GET['match']); 
     8$place=mysql_real_escape_string(_GET['place']); 
     9$cp_blog_id=mysql_real_escape_string($_GET['blogid']); 
     10 
    811$sql="set names 'utf8';"; 
    912$zed = mysql_query($sql); 
  • canalplan-ac/trunk/readme.txt

    r559376 r566813  
    44Tags: crosspost, Canalplan 
    55Requires at least: 3.0 
    6 Tested up to: 3.4 
    7 Stable tag: 2.4 
     6Tested up to: 3.4.1 
     7Stable tag: 2.5 
    88 
    99== Description == 
     
    5353== Changelog == 
    5454 
     55= Version 2.5 03/07/2012 = 
     56- Rebuilding the blog revealed a glitch when a place vanished from the database which messed up the maps. Now fixed. 
     57- Database moved on live server - so local data wasn't updating. 
     58 
    5559= Version 2.4 17/06/2012 = 
    5660- Fixed a problem with blogged routes. Was coded to expect a .htaccess re-write rule. No-one seems to have noticed though! 
Note: See TracChangeset for help on using the changeset viewer.