Hey Mini! I really appreciate your reply. Here is what I modified your script to:
<?^M
////////////////////////////////////////////^M
// MAKE SURE YOU EDIT THIS WHERE STATED //^M
// Then upload to /includes/cron/ //^M
////////////////////////////////////////////^M
^M
// Edit - Make sure this is correct^M
define('FILE_VERSION', '3.5.2'); // this should match install.php^M
^M
error_reporting(E_ALL & ~E_NOTICE);^M
if (!is_object($vbulletin->db))^M
{^M
exit;^M
}^M
^M
// Edit this line to reflect your database structure^M
$map_query=$vbulletin->db->query_read("SELECT userid,lat_map,lng_map FROM ".TABLE_PREFIX."googlemapme");^M
^M
// Make sure you set this field to the correct number! and set the link URL to your own map!^M
while ($inids = $vbulletin->db->fetch_array($map_query)) {^M
$posid = $inids[userid];^M
$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."userfield SET field8 = '<a href=\"http://www.vfrworld.com/forums
/vbgooglemapme.php?lat=$inids[lat_map]&lng=$inids[lng_map]&zoom=9\"><u>Find Me!</u></a>' WHERE ".TABLE_PREFIX."userfield
.userid = $posid");^M
}^M
^M
log_cron_action("map task updated", $nextitem);^M
?>
I changed your mod to point to googlemapme, so I still think it might be related. I don't know why vbgooglemap would be causing problems in showthread.php. Does my code above help at all? I'm really at a loss. :-(
I appreciate you trying to help, even if we can't figure it out.
|