 END$$
 
 DROP PROCEDURE IF EXISTS `newscounters`$$
-CREATE DEFINER=`mgreenhill`@`%` PROCEDURE `newscounters`()
+CREATE DEFINER=`travis`@`%` PROCEDURE `newscounters`()
 BEGIN
 UPDATE nuke_stories SET weeklycounter = 0;
 END$$
 
 DROP PROCEDURE IF EXISTS `PopulateLocoClass`$$
-CREATE DEFINER=`mgreenhill`@`%` PROCEDURE `PopulateLocoClass`(IN loco_number VARCHAR(8), IN loco_number_last VARCHAR(8), IN loco_class_id INT, IN loco_gauge_id INT, IN loco_status_id INT, IN loco_manufacturer_id INT, IN prefix TEXT)
+CREATE DEFINER=`travis`@`%` PROCEDURE `PopulateLocoClass`(IN loco_number VARCHAR(8), IN loco_number_last VARCHAR(8), IN loco_class_id INT, IN loco_gauge_id INT, IN loco_status_id INT, IN loco_manufacturer_id INT, IN prefix TEXT)
 BEGIN
 
 simple_loop: LOOP

END$$

DROP PROCEDURE IF EXISTS `update_viewed_thread`$$
CREATE DEFINER=`mgreenhill`@`%` PROCEDURE `update_viewed_thread`(IN `val_topic_id` INT, IN `val_user_id` INT)
BEGIN
SELECT SQL_CALC_FOUND_ROWS topic_id, user_id FROM viewed_threads WHERE topic_id = val_topic_id AND user_id = val_user_id;


END$$

DROP PROCEDURE IF EXISTS `geophotos`$$
CREATE DEFINER=`travis`@`%` PROCEDURE `geophotos`(IN location_id int, IN dist int, IN max int)
BEGIN
DECLARE location_lon double;
DECLARE location_lat double;
