whatsonchiangmai.com's dashboard

Why can't they fix this simple thing?

Just add a simple "Display Order" or "Priority Weight" field to the database and add to the metadata for each slide. Very easy. Then when displaying use this parameter to order.

Solved :-) Please do it. Thanks.

Hi Russ,

Google docs does not format PPT very well and they don't have nearly as good social networking features as SlideShare.

Best is for SlideShare to simply add the capability to change the dates of entries, similarly to how blog posts are updated.

Hi Folks,

I agree! I need to upload a number of older presentations; however, the current configuration does not permit us to change the dates (backdate, for example) so we can upload older presentations or reorder them.

This is really, really important. Did I say, it was very important?

Update:

The WordPress plugin, disable revisions and autosave, worked on the new posts. For some very strange reason, adding to the SQL query as we discussed did not work.

Anyway, I found a new bug related to Locations, which I will post later.

Thanks for the help. I installed the plugin and will give it a try.

Also, I will try to rearrange the SQL "hot fix" and report back; but like you, it should not make a difference.

There may be a different table that needs modifying besides the posts table, because I used MyPHPAdmin to delete all the other entries for the posts in the database, and still get the same problem, even when I clean up the posts table!!!

Hi Johnstonian,

Thanks for the reply. I checked the link and followed your fix in the code below:

function get_location_posts ($number = -1) {
global $table_prefix, $wpdb;
$geopress_table = $table_prefix . "geopress";

$sql = "SELECT * FROM $geopress_table, $wpdb->postmeta";
$sql .= " INNER JOIN $wpdb->posts ON $wpdb->posts.id = $wpdb->postmeta.post_id";
$sql .= " WHERE $wpdb->postmeta.meta_key = '_geopress_id'";
$sql .= " AND $wpdb->postmeta.meta_value = $geopress_table.geopress_id";
$sql .= " AND $wpdb->posts.post_status = 'publish'";
$sql .= " AND coord != ''";
if($number >= 0) {
$sql .= " LIMIT ".$number;
}
$result = $wpdb->get_results( $sql );

// Build a hash of Location => Posts @ location
$locations = array();
foreach ($result as $loc) {
if($locations[$loc->name] == null) {
$locations[$loc->name] = array();
}
array_push($locations[$loc->name], $loc);
}
return $locations;
}
function get_locations ($number = -1) {
global $table_prefix, $wpdb;
$geopress_table = $table_prefix . "geopress";

$sql = "SELECT * FROM $geopress_table";
$sql .= " INNER JOIN $wpdb->postmeta ON $wpdb->postmeta.meta_key = '_geopress_id'";
$sql .= " AND $wpdb->postmeta.meta_value = $geopress_table.geopress_id";
$sql .= " AND $wpdb->posts.post_status = 'publish'";
$sql .= " WHERE coord != '' GROUP BY 'name'";
if($number >= 0) {
$sql .= " LIMIT ".$number;
}
$result = $wpdb->get_results( $sql );
// echo $sql; // debug
return $result;
}

----------------

It does not appear to have worked on my end .....

http://www.whatsonchiangmai.com/map/

I wonder why?

We already tried to mod the code in mapabstraction.php (see below), but it still shows the default Google red marker.... that is why I am asking for support:

/**
* toGoogle returns a Google Maps compatible marker pin
* @returns Google Maps compatible marker
*/
Marker.prototype.toGoogle = function() {
var options = new Object();
if(this.labelText) {
options.title = this.labelText;
}
if(this.iconUrl){

baseIcon = new GIcon();
baseIcon.image = "images/dd-start.png";
/** baseIcon.shadow = "shadow.png"; **/
baseIcon.iconSize = new GSize(12, 20);
baseIcon.shadowSize = new GSize(12, 20);
baseIcon.iconAnchor = new GPoint(6, 10);
baseIcon.infoWindowAnchor = new GPoint(10, -5);

options.icon = baseIcon;
}
var gmarker = new GMarker( this.location.toGoogle(),options);

if(this.infoBubble) {
var theInfo = this.infoBubble;
GEvent.addListener(gmarker, "click", function() {
gmarker.openInfoWindowHtml(theInfo);
});
}

return gmarker;

Hi Johnstonian,

The link you provided to the old question provide no answer, so that is why we asked again.

Pointing folks to the API docs is not very helpful either, but thanks anyway :-)

This site is listed as the support site for GeoPress! Where are the developers who support the code??

So far, the only place for support is on the Google Maps API group, but this is not specific to GeoPress.

I thought this site was for support, but there are no supporters!