Thread: Major Additions - VBGooglemap Member Edition
View Single Post
  #314  
Old 05-02-2007, 11:58 AM
bulbasnore bulbasnore is offline
 
Join Date: Dec 2004
Posts: 95
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yet another dangerous 'accessory' for your googlemap, from the reckless bulbasnore. If this destroys your map and your forum, its not my fault.

We have a need to let the displaygroupid determine the map pin color for registered members (groupid = 2). Here is the job we cron in order to do that:

PHP Code:
<?php
/*======================================================================*\
|| #################################################################### ||
|| # ---------------------------------------------------------------- # ||
|| # Copyright ?2007 Kim Cary                                         # ||
|| # This file may be redistributed in whole or significant part.     # ||
|| # You could signficantly damage or destroy your board or computer  # ||
|| # with this file. Author will not be liable for any damages.       # ||
|| #################################################################### ||
\*======================================================================*/

// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
if (!
is_object($vbulletin->db))
{
        exit;
}
// ######################## END PHP ENVIRONMENT ###########################

        
$vbulletin->db->query_write("

        UPDATE  `googlemapme`, `user`
        SET  `googlemapme`.usergroupid =  `user`.displaygroupid 
        WHERE  `user`.displaygroupid > 0 AND `user`.usergroupid = 2 AND ( `googlemapme`.userid =  `user`.userid )

        "
);
        
log_cron_action('Set the googlemap userid to the displaygroup for registered users'$nextitem);

/*======================================================================*\
|| ####################################################################
|| # Version: 5:33, Wed May 2, 2007
|| ####################################################################
\*======================================================================*/
?>
If that helps you, by all means feel free to use it! If you don't know what this is, or how to install it, you are safer not to ask!

Regards,
'snore
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01280 seconds
  • Memory Usage 1,780KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete