'. t('This is a list of defined user functions that generated this current request lifecycle. Click on a function name to view its documention.'). '

'; case 'devel/reinstall': return '

'. t('Clicking a module\'s reinstall button will simulate uninstalling/installing a module. hook_uninstall() and hook_install() will be executed and the schema version number will be set to the most recent update number. You may have to manually clear out any existing tables first if the module doesn\'t implement hook_uninstall().'). '

'; case 'devel/session': return '

'. t('Here are the contents of your $_SESSION variable.'). '

'; case 'devel/variable': $api = variable_get('devel_api_url', 'api.drupal.org'); return '

'. t('This is a list of the variables and their values currently stored in variables table and the $conf array of your settings.php file. These variables are usually accessed with variable_get() and variable_set(). Variables that are too long can slow down your pages.', array('@variable-get-doc' => "http://$api/api/HEAD/function/variable_get", '@variable-set-doc' => 'http://$api/api/HEAD/function/variable_set')).'

'; } } /** * Implementation of hook_menu(). */ function devel_menu() { $items = array(); // note: we can't dynamically append destination to querystring. do so at theme layer. fix in D7? $items['devel/cache/clear'] = array( 'title' => 'Empty cache', 'page callback' => 'devel_cache_clear', 'description' => 'Clear the CSS cache and all database cache tables which store page, node, theme and variable caches.', 'access arguments' => array('access devel information'), 'menu_name' => 'devel', ); $items['devel/queries'] = array( 'title' => 'Database queries', 'page callback' => 'devel_queries', 'access callback' => 'devel_menu_access_store_queries', 'access arguments' => array(), 'menu_name' => 'devel', ); $items['devel/queries/empty'] = array( 'title' => 'Empty database queries', 'page callback' => 'devel_queries_empty', 'access callback' => 'devel_menu_access_store_queries', 'access arguments' => array(), 'menu_name' => 'devel', ); $items['devel/reference'] = array( 'title' => 'Function reference', 'description' => 'View a list of currently defined user functions with documentation links.', 'page callback' => 'devel_function_reference', 'access arguments' => array('access devel information'), 'menu_name' => 'devel', ); $items['devel/reinstall'] = array( 'title' => 'Reinstall modules', 'page callback' => 'devel_reinstall', 'description' => 'Run hook_uninstall() and then hook_install() for a given module.', 'access arguments' => array('access devel information'), 'menu_name' => 'devel', ); $items['devel/devel_themer'] = array( 'title callback' => 'devel_menu_title_theme_developer', 'title arguments' => array(NULL), 'title' => 'foo', 'description' => 'Quickly enable or disable theme developer module. Useful for removing HTML cruft added by that module.', 'page callback' => 'devel_devel_themer_toggle', 'access arguments' => array('access devel information'), 'menu_name' => 'devel', ); $items['devel/source'] = array( 'title' => 'Display the PHP code of any file in your Drupal installation', 'page callback' => 'devel_display_source', 'access arguments' => array('display source code'), 'type' => MENU_CALLBACK, 'menu_name' => 'devel', ); $items['devel/menu/reset'] = array( 'title' => 'Rebuild menus', 'description' => 'Rebuild menu based on hook_menu() and revert any custom changes. All menu items return to their default settings.', 'page callback' => 'drupal_get_form', 'page arguments' => array('devel_menu_rebuild'), 'access arguments' => array('access devel information'), 'menu_name' => 'devel', ); $items['devel/variable'] = array( 'title' => 'Variable editor', 'description' => 'Edit and delete site variables.', 'page callback' => 'devel_variable_page', 'access arguments' => array('access devel information'), 'menu_name' => 'devel', ); // we don't want the abbreviated version provided by status report $items['devel/phpinfo'] = array( 'title' => 'PHPinfo()', 'description' => 'View your server\'s PHP configuration', 'page callback' => 'devel_phpinfo', 'access arguments' => array('access devel information'), 'menu_name' => 'devel', ); $items['devel/theme/registry'] = array( 'title' => 'Theme registry', 'description' => 'View a list of available theme functions across the whole site.', 'page callback' => 'devel_theme_registry', 'access arguments' => array('access devel information'), 'menu_name' => 'devel', ); $items['devel/elements'] = array( 'title' => 'Hook_elements()', 'description' => 'View the active form/render elements for this site.', 'page callback' => 'devel_elements_page', 'access arguments' => array('access devel information'), 'menu_name' => 'devel', ); $items['devel/variable/edit/%'] = array( 'title' => 'Variable editor', 'page callback' => 'drupal_get_form', 'page arguments' => array('devel_variable_edit', 3), 'access arguments' => array('access devel information'), 'type' => MENU_CALLBACK, 'menu_name' => 'devel', ); $items['devel/session'] = array( 'title' => 'Session viewer', 'description' => 'List the contents of $_SESSION.', 'page callback' => 'devel_session', 'access arguments' => array('access devel information'), 'menu_name' => 'devel', ); $items['devel/switch'] = array( 'title' => 'Switch user', 'page callback' => 'devel_switch_user', 'access arguments' => array('switch users'), 'type' => MENU_CALLBACK, 'menu_name' => 'devel', ); $items['admin/settings/devel'] = array( 'title' => 'Devel settings', 'description' => 'Helper functions, pages, and blocks to assist Drupal developers. The devel blocks can be managed via the !block page.', array('!block' => l(t('block administration'), 'admin/build/block')), 'page callback' => 'drupal_get_form', 'page arguments' => array('devel_admin_settings'), 'access arguments' => array('administer site configuration'), 'menu_name' => 'devel', ); $items['node/%node/load'] = array( 'title' => 'Dev load', 'page callback' => 'devel_load_object', 'page arguments' => array(1, 'node'), 'access callback' => 'user_access', 'access arguments' => array('access devel information'), 'type' => MENU_LOCAL_TASK, ); $items['node/%node/render'] = array( 'title' => 'Dev render', 'page callback' => 'devel_render_object', 'page arguments' => array('node', 1), 'access callback' => 'user_access', 'access arguments' => array('access devel information'), 'type' => MENU_LOCAL_TASK, ); $items['user/%user/load'] = array( 'title' => 'Devel load', 'page callback' => 'devel_load_object', 'page arguments' => array(1, 'user'), 'access callback' => 'user_access', 'access arguments' => array('access devel information'), 'type' => MENU_LOCAL_TASK, ); $items['user/%user/render'] = array( 'title' => 'Dev render', 'page callback' => 'devel_render_object', 'page arguments' => array('user', 1), 'access callback' => 'user_access', 'access arguments' => array('access devel information'), 'type' => MENU_LOCAL_TASK, ); return $items; } function devel_menu_need_destination() { return array('devel/cache/clear', 'devel/devel_themer', 'devel/reinstall', 'devel/menu/reset', 'admin/og/og', 'devel/variable', 'admin/reports/status/run-cron'); } /** * An implementation of hook_menu_link_alter(). Flag this link as needing alter at display time. * This is more robust that setting alter in hook_menu(). See devel_translated_menu_link_alter(). * **/ function devel_menu_link_alter(&$item, &$menu) { if (in_array($item['link_path'], devel_menu_need_destination())) { $item['options']['alter'] = TRUE; } } /** * An implementation of hook_translated_menu_item_alter(). Append dynamic * querystring 'destination' to several of our own menu items. * **/ function devel_translated_menu_link_alter(&$item) { if (in_array($item['href'], devel_menu_need_destination())) { $item['localized_options']['query'] = drupal_get_destination(); } } function devel_menu_access_store_queries() { return user_access('access devel information') && variable_get('devel_store_queries', 0); } function devel_menu_title_theme_developer() { if (module_exists('devel_themer')) { return t('Disable Theme developer'); } else { return t('Enable Theme developer'); } } function devel_devel_themer_toggle() { if (module_exists('devel_themer')) { module_disable(array('devel_themer')); } else { module_enable(array('devel_themer')); } drupal_rebuild_theme_registry(); drupal_goto(); } /** * Implementation of hook_theme() */ function devel_theme() { // &$cache, $type, $theme, $path return array( 'devel_variable_form' => array( 'arguments' => array('form' => NULL) ), ); } /** * Page callback to display syntax hilighted source code * * note: the path for this function is received via $_GET['path'] * example http://www.example.com/devel/source?file=modules/node/node.module * * @param $standalone * Set to FALSE to place the code inside a Drupal page. Otherwise code displays on its own. */ function devel_display_source($standalone = TRUE) { $path = $_GET['file']; // take out the nasties $path = str_replace('../', '', $path); $output = devel_highlight_file($path, $standalone); if ($output) { if ($standalone) { print $output; exit(); } return $output; } else { drupal_set_message(t('Invalid file path'), 'error'); drupal_not_found(); } } /** * Return PHP highlighted file * * @param $path * path to the file * *warning* there is NO VALIDATION in this function * Beware of paths such as '../../../../../etc/apache/httpd.conf' * * @param $standalone * should the returned HTML be wrapped in a full page or will it be output by Drupal? */ function devel_highlight_file($path = NULL, $standalone = FALSE) { if (file_exists($path)) { $source = highlight_file($path, TRUE); // add anchor links before all functions // with doxygen $source = preg_replace('!(\/\*\*.*?\*\/.*?)(.*?)<\/span>!', ' $0', $source); //$source = preg_replace('!(\/\*\*.*?\*\/).*?function.*?#0000BB">(.*?)<\/span>!', ' $0', $source); if ($standalone) { $source = <<$path $source EOT; } return $source; } else { return FALSE; } } /** * Implementation of hook_init(). */ function devel_init() { if (!devel_silent()) { if (user_access('access devel information')) { devel_set_handler(variable_get('devel_error_handler', DEVEL_ERROR_HANDLER_STANDARD)); // We want to include the class early so that anyone may call krumo() as needed. See http://krumo.sourceforge.net/ has_krumo(); // See http://www.firephp.org/ $path = './'. drupal_get_path('module', 'devel') .'/FirePHPCore/lib/FirePHPCore/fb.php'; if (file_exists($path)) { include_once $path; } } } } // return boolean. no need for cache here. function has_krumo() { // see README.txt or just download from http://krumo.sourceforge.net/ @include_once './'. drupal_get_path('module', 'devel'). '/krumo/class.krumo.php'; if (function_exists('krumo') && php_sapi_name() != 'cli') { return TRUE; } else { return FALSE; } } /** * Decide whether or not to print a debug variable using krumo(). * * @param $input * @return boolean */ function merits_krumo($input) { return (is_object($input) || is_array($input)) && has_krumo(); } /** * Calls the http://www.firephp.org/ fb() function if it is found. * * @return void */ function dfb() { if (function_exists('fb')) { $args = func_get_args(); call_user_func_array('fb', $args); } } function devel_set_handler($handler) { switch ($handler) { case DEVEL_ERROR_HANDLER_STANDARD: // do nothing break; case DEVEL_ERROR_HANDLER_BACKTRACE: if(has_krumo()) { set_error_handler('backtrace_error_handler'); } break; case DEVEL_ERROR_HANDLER_NONE: restore_error_handler(); break; } } function devel_silent() { // isset($_GET['q']) is needed on IIS when calling the front page. q is not set. // Don't interfere with private files/images. return isset($GLOBALS['devel_shutdown']) || strstr($_SERVER['PHP_SELF'], 'update.php') || (isset($_GET['q']) && (in_array($_GET['q'], array('upload/js', 'admin/content/node-settings/rebuild')) || substr($_GET['q'], 0, strlen('system/files')) == 'system/files')); } /** * Implementation of hook_boot(). Runs even for cached pages. */ function devel_boot() { if (!devel_silent()) { devel_start(); } } // kickoff all our tricks. put here all code which must run for ached pages too. called from both hook_boot and hook_init. function devel_start() { if (variable_get('dev_mem', 0) && function_exists('memory_get_usage')) { global $memory_init; $memory_init = memory_get_usage(); } // we need user_access() in the shutdown function. make sure it gets loaded drupal_load('module', 'user'); register_shutdown_function('devel_shutdown'); } function backtrace_error_handler($errno, $message, $filename, $line) { // Don't respond to the error if it was suppressed with a '@' if (error_reporting() == 0) return; if ($errno & (E_ALL ^ E_NOTICE)) { $types = array(1 => 'error', 2 => 'warning', 4 => 'parse error', 8 => 'notice', 16 => 'core error', 32 => 'core warning', 64 => 'compile error', 128 => 'compile warning', 256 => 'user error', 512 => 'user warning', 1024 => 'user notice', 2048 => 'strict warning'); $entry = $types[$errno] .': '. $message .' in '. $filename .' on line '. $line .'.'; if (variable_get('error_level', 1) == 1) { $backtrace = debug_backtrace(); foreach ($backtrace as $call) { $nicetrace[$call['function']] = $call; } krumo($nicetrace); } watchdog('php', '%message in %file on line %line.', array('%error' => $types[$errno], '%message' => $message, '%file' => $filename, '%line' => $line), WATCHDOG_ERROR); } } /** * Implementation of hook_perm(). */ function devel_perm() { return array('access devel information', 'execute php code', 'switch users', 'display source code'); } /** * Implementation of hook_block(). */ function devel_block($op = 'list', $delta = 0, $edit = array()) { if ($op == 'list') { $blocks[0]['info'] = t('Switch user'); // $blocks[1]['info'] = t('Devel'); $blocks[2]['info'] = t('Execute PHP'); return $blocks; } else if ($op == 'configure' && $delta == 0) { $form['devel_switch_user_list_size'] = array( '#type' => 'textfield', '#title' => t('Number of users to display in the list'), '#default_value' => variable_get('devel_switch_user_list_size', 10), '#size' => '3', '#maxlength' => '4', ); return $form; } else if ($op == 'save' && $delta == 0) { variable_set('devel_switch_user_list_size', $edit['devel_switch_user_list_size']); } else if ($op == 'view') { $block = array(); switch ($delta) { case 0: $block = devel_block_switch_user(); break; case 1: // Deleted in favor of custom menu. do not reuse this index. break; case 2: if (user_access('execute php code')) { $block['subject'] = t('Execute PHP'); $block['content'] = drupal_get_form('devel_execute_form'); } break; } return $block; } } function devel_block_switch_user() { $block['subject'] = t('Switch user'); $links = devel_switch_user_list(); if (!empty($links)) { $block['content'] = theme('item_list', $links); $block['content'] .= drupal_get_form('devel_switch_user_form'); return $block; } } function devel_switch_user_list() { $links = array(); if (user_access('switch users')) { $list_size = variable_get('devel_switch_user_list_size', 10); $dest = drupal_get_destination(); // Try to find at least $list_size users that can switch. $roles = user_roles(1, 'switch users'); if (isset($roles[2])) { // If authenticated users have this permission, just grab // the last $list_size users, since there won't be records in // {user_roles} and every user on the system can switch. $users = db_query_range("SELECT DISTINCT u.uid, u.name, u.access FROM {users} u WHERE u.uid > 0 ORDER BY u.access DESC", 0, $list_size); } else { $where = array('u.uid = 1'); if (count($roles)) { $where[] = 'r.rid IN ('. implode(',', array_keys($roles)) .')'; } $where_sql = implode(' OR ', $where); $users = db_query_range("SELECT DISTINCT u.uid, u.name, u.access FROM {users} u LEFT JOIN {users_roles} r ON u.uid = r.uid WHERE $where_sql ORDER BY u.access DESC", 0, $list_size); } while ($user = db_fetch_object($users)) { $links[$user->uid] = l(theme('placeholder', $user->name), 'devel/switch/'. $user->name, array('attributes' => array('title' => t('This user can switch back.')), 'query' => $dest, 'html' => TRUE)); } $num_links = count($links); if ($num_links < $list_size) { // If we don't have enough, add distinct uids until we hit $list_size. $users = db_query_range('SELECT uid, name, access FROM {users} WHERE uid > 0 AND uid NOT IN ('. implode(',', array_keys($links)) .') ORDER BY access DESC', 0, $list_size - $num_links); while (($user = db_fetch_object($users)) && count($links) < $list_size) { $links[$user->uid] = l($user->name ? $user->name : 'anon', 'devel/switch/'. $user->name, array('attributes' => array('title' => t('Caution: this user will be unable switch back.')), 'query' => $dest)); } } } return $links; } function devel_phpinfo() { print phpinfo(); exit; } function devel_switch_user_form() { $form['username'] = array( '#type' => 'textfield', '#description' => t('Enter username'), '#autocomplete_path' => 'user/autocomplete', '#maxlength' => USERNAME_MAX_LENGTH, '#size' => 16, ); $form['submit'] = array( '#type' => 'submit', '#value' => t('Switch'), ); return $form; } function devel_doc_function_form() { $version = devel_get_core_version(VERSION); $form['function'] = array( '#type' => 'textfield', '#description' => t('Enter function name for api lookup'), '#size' => 16, '#maxlength' => 255, ); $form['version'] = array('#type' => 'value', '#value' => $version); $form['submit_button'] = array( '#type' => 'submit', '#value' => t('Submit'), ); return $form; } function devel_doc_function_form_submit($form, &$form_state) { $version = $form_state['values']['version']; $function = $form_state['values']['function']; $api = variable_get('devel_api_url', 'api.drupal.org'); $form_state['redirect'] = "http://$api/api/$version/function/$function"; } function devel_switch_user_form_validate($form, &$form_state) { if (!$account = user_load(array('name' => $form_state['values']['username']))) { form_set_error('username', t('Username not found')); } } function devel_switch_user_form_submit($form, &$form_state) { $form_state['redirect'] = 'devel/switch/'. $form_state['values']['username']; } /** * TODO: i switched params as per http://drupal.org/node/144132#form-alter but needs work still * Implementation of hook_form_alter(). */ function devel_form_alter(&$form, $form_state, $form_id, $key_in = NULL) { if (user_access('access devel information') && variable_get('devel_form_weights', 0)) { $children = element_children($form); if (empty($children)) { if (isset($form['#type']) && !in_array($form['#type'], array('value', 'hidden'))) { if (!isset($form['#title'])) { $form['#title'] = ''; } $form['#title'] .= " (key=$key_in, weight=". (isset($form['#weight']) ? $form['#weight'] : 0) .')'; } } else { foreach (element_children($form) as $key) { // We need to add the weight to fieldsets. if (element_children($form[$key])) { // Which are a container of others. if (!isset($form[$key]['#title'])) { $form[$key]['#title'] = ''; } $form[$key]['#title'] .= " (key=$key, weight=". (isset($form[$key]['#weight']) ? $form[$key]['#weight'] : 0) .')'; } devel_form_alter($form[$key], $form_state, $form_id, $key); } } } } function devel_exit($destination = NULL) { global $user; if (isset($destination) && !devel_silent()) { // The page we are leaving is a drupal_goto(). Present a redirection page // so that the developer can see the intermediate query log. // We don't want to load user module here, so keep function_exists() call. if (isset($user) && function_exists('user_access') && user_access('access devel information') && variable_get('devel_redirect_page', 0)) { $output = t_safe('

The user is being redirected to @destination.

', array('@destination' => $destination)); print theme('page', $output); // Don't allow the automatic redirect to happen. drupal_page_footer(); exit(); } else { $GLOBALS['devel_redirecting'] = TRUE; } } } /** * See devel_start() which registers this function as a shutdown function. */ function devel_shutdown() { // Register the real shutdown function so it runs later than other shutdown functions. register_shutdown_function('devel_shutdown_real'); } /** * See devel_shutdown() which registers this function as a shutdown function. Displays developer information in the footer. */ function devel_shutdown_real() { global $queries, $memory_init, $user; $output = $txt = ''; // Set $GLOBALS['devel_shutdown'] = FALSE in order to supress the // devel footer for a page. Not necessary if your page outputs any // of the Content-type http headers tested below (e.g. text/xml, // text/javascript, etc). This is is advised where applicable. if (!isset($GLOBALS['devel_shutdown']) && !isset($GLOBALS['devel_redirecting'])) { // Try not to break non html pages. if (function_exists('drupal_get_headers')) { $headers = drupal_get_headers(); $formats = array('xml', 'javascript', 'json', 'plain', 'image', 'application', 'x-comma-separated-values'); foreach ($formats as $format) { if (strstr($headers, $format)) { return; } } } // don't append gunk to CLI scripts if (empty($_SERVER['REQUEST_METHOD'])) { return; } if (isset($user) && user_access('access devel information')) { list($counts, $query_summary) = devel_query_summary(); // Query log off, timer on. if (!variable_get('devel_query_display', 0) && variable_get('dev_timer', 0)) { $output .= '
'. devel_timer() .' '. $query_summary. '
'; } // Query log on. $sum = 0; if (variable_get('devel_query_display', FALSE)) { $output .= '
'; $output .= $query_summary; // calling theme() during shutdown is very bad if registry gets rebuilt like when making a change on admin/build/modules // so we check for presence of theme registry before calling theme('table' ) if (function_exists('theme_get_registry') && theme_get_registry()) { $txt = t_safe(' Queries taking longer than @threshold ms and queries executed more than once, are highlighted.', array('@threshold' => variable_get('devel_execution', 5))); if (variable_get('dev_timer', 0)) { $txt .= devel_timer(); } $output .= $txt. devel_query_table($queries, $counts); } else { $output .= $txt; ob_start(); dprint_r($queries); $output .= ob_get_clean(); } $output .= '
'; } if (variable_get('dev_mem', FALSE) && function_exists('memory_get_usage')) { $memory_shutdown = memory_get_usage(); $args = array('@memory_init' => round($memory_init / 1024 / 1024, 2), '@memory_shutdown' => round($memory_shutdown / 1024 / 1024, 2)); $msg = '

Memory usage:

Memory used at: devel_init()=@memory_init MB, devel_shutdown()=@memory_shutdown MB.
'; // theme() may not be available. not t() either. $output .= t_safe($msg, $args); } // TODO: gzip this text if we are sending a gzip page. see drupal_page_header(). } if ($output) { print $output; } } devel_store_queries(); } function devel_store_queries() { if (variable_get('devel_store_queries', 0) && rand(1, variable_get('devel_store_random', 1)) == 1) { global $active_db, $queries, $db_type; $qids = array(); $values = array(); $fields = array(); // We need this for the devel_queries insert below. setlocale(LC_NUMERIC, 'C'); foreach ($queries as $value) { list($function, $query) = explode("\n", $value[0]); $query = preg_replace(array("/'.*'/s", "/\d.*\.\d.*/", "/\d.*/"), array("S", "F", "D"), $query); $hash = md5($function . $query); if (!isset($qids[$hash])) { $qids[$hash] = db_result(devel_db_query("SELECT qid FROM {devel_queries} WHERE hash = '%s'", $hash)); if (!$qids[$hash]) { devel_db_query("INSERT INTO {devel_queries} (query, function, hash) VALUES ('%s', '%s', '%s')", $query, $function, $hash); if($db_type=='pgsql') { $qids[$hash] = db_result(db_query("SELECT lastval();")); } else { $qids[$hash] = mysql_insert_id(); } } } $fields[] = "(%d, '%f')"; $values[] = $qids[$hash]; $values[] = $value[1]; } if (count($fields)) { devel_db_query('INSERT INTO {devel_times} (qid, time) VALUES '. implode(',', $fields), $values); } } } function devel_query_summary() { global $queries; if (variable_get('dev_query', FALSE) && is_array($queries)) { $sum = 0; foreach ($queries as $query) { $text[] = $query[0]; $sum += $query[1]; } $counts = array_count_values($text); return array($counts, t_safe('Executed @queries queries in @time milliseconds.', array('@queries' => count($queries), '@time' => round($sum * 1000, 2)))); } } function t_safe($string, $args) { // get_t caused problems here with theme registry after changing on admin/build/modules. the theme_get_registry call is needed. if (function_exists('t') && function_exists('theme_get_registry')) { theme_get_registry(); return t($string, $args); } else { strtr($string, $args); } } /** * Returns a list of all currently defined user functions in the current * request lifecycle, with links their documentation. */ function devel_function_reference() { $functions = get_defined_functions(); $version = devel_get_core_version(VERSION); $ufunctions = $functions['user']; sort($ufunctions); $api = variable_get('devel_api_url', 'api.drupal.org'); foreach($ufunctions as $function) { $links[] = l($function, "http://$api/api/$version/function/$function"); } return theme('item_list', $links); } function devel_get_core_version($version) { $version_parts = explode('.', $version); // Map from 4.7.10 -> 4.7 if ($version_parts[0] < 5) { return $version_parts[0] .'.'. $version_parts[1]; } // Map from 5.5 -> 5 or 6.0-beta2 -> 6 else { return $version_parts[0]; } } function devel_db_query($query) { global $active_db; $args = func_get_args(); array_shift($args); $query = db_prefix_tables($query); if (isset($args[0]) and is_array($args[0])) { // 'All arguments in one array' syntax $args = $args[0]; } _db_query_callback($args, TRUE); $query = preg_replace_callback(DB_QUERY_REGEXP, '_db_query_callback', $query); return db_query($query, $active_db); } // See http://drupal.org/node/126098 function devel_is_compatible_optimizer() { ob_start(); phpinfo(); $info = ob_get_contents(); ob_end_clean(); // Match the Zend Optimezer version in the phpinfo information $found = preg_match('/Zend Optimizer v([0-9])\.([0-9])\.([0-9])/', $info, $matches); if ($matches) { $major = $matches[1]; $minor = $matches[2]; $build = $matches[3]; if ($major >= 3) { if ($minor >= 3) { return TRUE; } elseif ($minor == 2 && $build >= 8) { return TRUE; } else { return FALSE; } } else { return FALSE; } } else { return TRUE; } } function devel_admin_settings() { $form['queries'] = array('#type' => 'fieldset', '#title' => t('Query log')); $description = t("Collect query info. If disabled, no query log functionality will work."); if (!devel_is_compatible_optimizer()) { $description = t('You must disable or upgrade the php Zend Optimizer extension in order to enable this feature. The minimum required version is 3.2.8. Earlier versions of Zend Optimizer are horribly buggy and segfault your Apache ... ', array('!url' => url('http://drupal.org/node/126098'))). $description; } $form['queries']['dev_query'] = array('#type' => 'checkbox', '#title' => t('Collect query info'), '#default_value' => variable_get('dev_query', 0), '#disabled' => !devel_is_compatible_optimizer() ? TRUE : FALSE, '#description' => $description, ); $form['queries']['devel_query_display'] = array('#type' => 'checkbox', '#title' => t('Display query log'), '#default_value' => variable_get('devel_query_display', 0), '#description' => t('Display a log of the database queries needed to generate the current page, and the execution time for each. Also, queries which are repeated during a single page view are summed in the # column, and printed in red since they are candidates for caching.')); $form['queries']['devel_query_sort'] = array('#type' => 'radios', '#title' => t('Sort query log'), '#default_value' => variable_get('devel_query_sort', DEVEL_QUERY_SORT_BY_SOURCE), '#options' => array(t('by source'), t('by duration')), '#description' => t('The query table can be sorted in the order that the queries were executed or by descending duration.'), ); $form['queries']['devel_execution'] = array('#type' => 'textfield', '#title' => t('Slow query highlighting'), '#default_value' => variable_get('devel_execution', 5), '#size' => 4, '#maxlength' => 4, '#description' => t('Enter an integer in milliseconds. Any query which takes longer than this many milliseconds will be highlighted in the query log. This indicates a possibly inefficient query, or a candidate for caching.'), ); $form['queries']['devel_store_queries'] = array('#type' => 'checkbox', '#title' => t('Store executed queries'), '#default_value' => variable_get('devel_store_queries', 0), '#description' => t('Store statistics about executed queries. See the devel_x tables.')); $form['queries']['devel_store_random'] = array('#type' => 'textfield', '#title' => t('Sampling interval'), '#default_value' => variable_get('devel_store_random', 1), '#size' => 4, '#description' => t('If storing query statistics, only store every nth page view. 1 means every page view, 2 every second, and so on.')); $form['devel_api_url'] = array('#type' => 'textfield', '#title' => t('API Site'), '#default_value' => variable_get('devel_api_url', 'api.drupal.org'), '#description' => t('The base URL for your developer documentation links. You might change this if you run api.module locally.', array('!url' => url('http://drupal.org/project/api')))); $form['dev_timer'] = array('#type' => 'checkbox', '#title' => t('Display page timer'), '#default_value' => variable_get('dev_timer', 0), '#description' => t('Display page execution time in the query log box.'), ); $form['dev_mem'] = array('#type' => 'checkbox', '#title' => t('Display memory usage'), '#default_value' => variable_get('dev_mem', 0), '#description' => t('Display how much memory is used to generate the current page. This will show memory usage when devel_init() is called and when devel_exit() is called. PHP must have been compiled with the --enable-memory-limit configuration option for this feature to work.'), ); $form['devel_redirect_page'] = array('#type' => 'checkbox', '#title' => t('Display redirection page'), '#default_value' => variable_get('devel_redirect_page', 0), '#description' => t('When a module executes drupal_goto(), the query log and other developer information is lost. Enabling this setting presents an intermediate page to developers so that the log can be examined before continuing to the destination page.'), ); $form['devel_form_weights'] = array('#type' => 'checkbox', '#title' => t('Display form element keys and weights'), '#default_value' => variable_get('devel_form_weights', 0), '#description' => t('Form element names are needed for performing themeing or altering a form. Their weights determine the position of the element. Enabling this setting will show these keys and weights beside each form item.'), ); $form['devel_error_handler'] = array('#type' => 'radios', '#title' => t('Error handler'), '#default_value' => variable_get('devel_error_handler', DEVEL_ERROR_HANDLER_STANDARD), '#options' => array(DEVEL_ERROR_HANDLER_NONE => t('None'), DEVEL_ERROR_HANDLER_STANDARD => t('Standard drupal')), '#description' => t('Choose an error handler for your site. Backtrace prints nice debug information when an error is noticed, and you !choose. Backtrace requires the krumo library. None is a good option when stepping through the site in your debugger.', array('!krumo' => url("http://krumo.sourceforge.net"), '!choose' => l(t('choose to show errors on screen'), 'admin/settings/error-reporting'))), ); if (has_krumo()) { $form['devel_error_handler']['#options'][DEVEL_ERROR_HANDLER_BACKTRACE] = t('Backtrace'); } $options = drupal_map_assoc(array('blue', 'default', 'green', 'orange', 'schablon.com')); $form['devel_krumo_skin'] = array( '#type' => 'radios', '#title' => t('Krumo skin'), '#description' => t('Select a skin for your debug messages'), '#options' => $options, '#default_value' => variable_get('devel_krumo_skin', 'default'), ); // Save any old SMTP library if (variable_get('smtp_library', '') != '' && variable_get('smtp_library', '') != drupal_get_filename('module', 'devel')) { variable_set('devel_old_smtp_library', variable_get('smtp_library', '')); } $smtp_options = array( '' => t('Default'), drupal_get_filename('module', 'devel') => t('Log only'), ); if (variable_get('devel_old_smtp_library', '') != '') { $smtp_options[variable_get('devel_old_smtp_library', '')] = t('Other (!library)', array('!library' => variable_get('devel_old_smtp_library', ''))); } $form['smtp_library'] = array( '#type' => 'radios', '#title' => t('SMTP library'), '#options' => $smtp_options, '#default_value' => variable_get('smtp_library', ''), ); return system_settings_form($form); } /** * Menu callback; clears all caches, then redirects to the previous page. */ function devel_cache_clear() { // If you used to implement our own cache clear hook, implement hook_flush_caches instead. See drupal_flush_all_caches() drupal_flush_all_caches(); drupal_set_message('Cache cleared.'); drupal_goto(); } /** * Generates the execute block form. */ function devel_execute_form() { $form['code'] = array( '#type' => 'textarea', '#title' => t('PHP code to execute'), '#description' => t('Enter some code. Do not use <?php ?> tags.') ); $form['op'] = array('#type' => 'submit', '#value' => t('Execute')); $form['#redirect'] = FALSE; $form['#skip_duplicate_check'] = TRUE; return $form; } /** * Process PHP execute form submissions. */ function devel_execute_form_submit($form, &$form_state) { ob_start(); print eval($form_state['values']['code']); dsm(ob_get_clean()); } /** * Menu callback; clear the database, resetting the menu to factory defaults. */ function devel_menu_rebuild() { menu_rebuild(); drupal_set_message(t('The menu router has been rebuilt.')); drupal_goto(); } /** * Implementation of hook_forms(). */ function devel_forms() { $forms = array(); if (user_access('access devel information')) { // registers each devel_reinstall_$module form_id $modules = module_list(); foreach ($modules as $module) { $forms['devel_reinstall_'. $module]['callback'] = 'devel_reinstall_form'; } } return $forms; } function devel_reinstall_form(&$form_state, $module) { $form = array( '#submit' => array('devel_reinstall_submit'), 'submit' => array( '#type' => 'submit', '#value' => t('Reinstall @name module', array('@name' => $module)) ), ); return $form; } /** * Menu callback; Display a list of installed modules with the option to reinstall them via hook_install. */ function devel_reinstall() { $output = ''; $modules = module_list(); sort($modules); foreach ($modules as $module) { $output .= drupal_get_form('devel_reinstall_'. $module, $module); } drupal_set_message(t('Warning - will delete your module tables and variables.'), 'error'); return $output; } /** * Process reinstall menu form submissions. */ function devel_reinstall_submit($form, &$form_state) { include_once './includes/install.inc'; $module = str_replace('devel_reinstall_', '', $form_state['values']['form_id']); module_load_install($module); $versions = drupal_get_schema_versions($module); drupal_set_installed_schema_version($module, SCHEMA_UNINSTALLED); module_invoke($module, 'uninstall'); _drupal_install_module($module); module_invoke($module, 'enable'); drupal_get_schema(NULL, TRUE); drupal_set_message(t('Uninstalled and reinstalled the %name module.', array('%name' => $module))); } // Menu callback. function devel_theme_registry() { init_theme(); $hooks = theme_get_registry(); return kprint_r($hooks, TRUE); } /** * Menu callback; display all variables. */ function devel_variable_page() { // we print our own page so as to avoid blocks $output = drupal_get_form('devel_variable_form'); print theme('page', $output, FALSE); } function devel_variable_form() { $header = array( array(''), array('data' => t('Name'), 'field' => 'name', 'sort' => 'asc'), array('data' => t('Value'), 'field' => 'value'), array('data' => t('Length'), 'field' => 'length'), array('data' => t('Operations')), ); // TODO: we could get variables out of $conf but that would include hard coded ones too. ideally i would highlight overrridden/hard coded variables switch ($GLOBALS['db_type']) { case 'mssql': $sql = "SELECT *, COL_LENGTH('{variable}', 'value') AS length FROM {variable}"; break; default: $sql = "SELECT *, LENGTH(value) AS length FROM {variable}"; break; } $result = db_query($sql. tablesort_sql($header)); while ($row = db_fetch_object($result)) { $variables[$row->name] = ''; $form['name'][$row->name] = array('#value' => check_plain($row->name)); if (merits_krumo($row->value)) { $value = krumo_ob(variable_get($row->name, NULL)); } else { if (drupal_strlen($row->value) > 70) { $value = check_plain(drupal_substr($row->value, 0, 65)) .'...'; } else { $value = check_plain($row->value); } } $form[$row->name]['value'] = array('#value' => $value); $form[$row->name]['length'] = array('#value' => $row->length); $form[$row->name]['edit'] = array('#value' => l(t('edit'), "devel/variable/edit/$row->name")); } $form['variables'] = array('#type' => 'checkboxes', '#options' => $variables); $form['submit'] = array( '#type' => 'submit', '#value' => t('Delete'), ); return $form; } function theme_devel_variable_form($form) { // TODO: this is not being called for some reason // die(form); $children = element_children($form['name']); foreach ($children as $key) { $rows[] = array( drupal_render($form['variables'][$key]), drupal_render($form['name'][$key]), drupal_render($form[$key]['value']), drupal_render($form[$key]['length']), drupal_render($form[$key]['edit']), ); } $header = array( theme('table_select_header_cell'), array('data' => t('Name'), 'field' => 'name', 'sort' => 'asc'), array('data' => t('Value'), 'field' => 'value'), array('data' => t('Length'), 'field' => 'length'), array('data' => t('Operations'), 'colspan' => 2), ); $output = theme('table', $header, $rows); $output .= drupal_render($form); return $output; } function devel_variable_form_submit($form, &$form_state) { $deletes = array_filter($form_state['values']['variables']); array_walk($deletes, 'variable_del'); drupal_set_message(format_plural(count($deletes), 'One variable deleted.', '@count variables deleted.')); } function devel_variable_edit($form_state, $name) { $value = variable_get($name, 'not found'); $form['name'] = array( '#type' => 'value', '#value' => $name ); $form['value'] = array( '#type' => 'item', '#title' => t('Old value'), '#value' => dpr($value, TRUE), ); if (is_string($value) || is_numeric($value)) { $form['new'] = array( '#type' => 'textarea', '#title' => t('New value'), '#default_value' => $value ); $form['submit'] = array( '#type' => 'submit', '#value' => t('Submit'), ); } else { $api = variable_get('devel_api_url', 'api.drupal.org'); $form['new'] = array( '#type' => 'item', '#title' => t('New value'), '#value' => t('Sorry, complex variable types may not be edited yet. Use the Execute PHP block and the variable_set() function.', array('@variable-set-doc' => "http://$api/api/HEAD/function/variable_set")) ); } drupal_set_title($name); return $form; } function devel_variable_edit_submit($form, &$form_state) { variable_set($form_state['values']['name'], $form_state['values']['new']); drupal_set_message(t('Saved new value for %name.', array('%name' => $form_state['values']['name']))); 'devel/variable'; } /** * Menu callback: display the session. */ function devel_session() { global $user; $output = kprint_r($_SESSION, TRUE); $headers = array(t('Session name'), t('Session ID')); dsm($user); $output .= theme('table', $headers, array(array(session_name(), session_id()))); return $output; } /** * Switch from original user to another user and back. * * Note: taken from mailhandler.module. * * Note: You first need to run devel_switch_user without * argument to store the current user. Call devel_switch_user * without argument to set the user back to the original user. * * @param $name The username to switch to. * */ function devel_switch_user($name = NULL) { global $user; static $orig_user = array(); if (isset($name)) { $user = user_load(array('name' => $name)); } // Retrieve the initial user. Can be called multiple times. else if (count($orig_user)) { $user = array_shift($orig_user); array_unshift($orig_user, $user); } // Store the initial user. else { $orig_user[] = $user; } drupal_goto(); } /** * Menu callback; prints the loaded structure of the current node/user. */ function devel_load_object($object, $name = NULL) { $title = isset($object->title) ? $object->title : $object->name; drupal_set_title(check_plain($title)); return kdevel_print_object($object, '$'. $name .'->'); } /** * Menu callback; prints the render structure of the current object (currently node or user). */ function devel_render_object($type, $object) { $output = ''; $title = isset($object->title) ? $object->title : $object->name; // not sure why menu system doesn't give us a reasonable title here. drupal_set_title(check_plain($title)); $function = $type. '_build_content'; $content = $function($object, FALSE, FALSE); return kdevel_print_object($content, '$'. $type .'->'); } function devel_elements_page() { return kdevel_print_object(module_invoke_all('elements')); } /** * Print an object or array using either Krumo (if installed) or devel_print_object() * * @param $object * array or object to print * @param $prefix * prefixing for output items */ function kdevel_print_object($object, $prefix = NULL) { return has_krumo() ? krumo_ob($object) : devel_print_object($object, $prefix); } // Save krumo htlm using output buffering. function krumo_ob($object) { ob_start(); krumo($object); $output = ob_get_contents(); ob_end_clean(); return $output; } /** * Display an object or array * * @param $object * the object or array * @param $prefix * prefix for the output items (example "$node->", "$user->", "$") * @param $header * set to FALSE to suppress the output of the h3 */ function devel_print_object($object, $prefix = NULL, $header = TRUE) { drupal_add_css(drupal_get_path('module', 'devel'). '/devel.css'); $output = '
'; if ($header) { $output .= '

'. t('Display of !type !obj', array('!type' => str_replace(array('$', '->'), '', $prefix), '!obj' => gettype($object))). '

'; } $output .= _devel_print_object($object, $prefix); $output .= '
'; return $output; } /** * Recursive (and therefore magical) function goes through an array or object and * returns a nicely formatted listing of its contents. * * @param $obj * array or object to recurse through * @param $prefix * prefix for the output items (example "$node->", "$user->", "$") * @param $parents * used by recursion * @param $object * used by recursion * @return * fomatted html * * @todo * currently there are problems sending an array with a varname */ function _devel_print_object($obj, $prefix = NULL, $parents = NULL, $object = FALSE) { static $root_type, $out_format; // TODO: support objects with references. See http://drupal.org/node/234581. if (isset($obj->view)) { return; } if (!isset($root_type)) { $root_type = gettype($obj); if ($root_type == 'object') { $object = TRUE; } } if (is_object($obj)) { $obj = (array)$obj; } if (is_array($obj)) { $output = "
\n"; foreach($obj as $field => $value) { if ($field == 'devel_flag_reference') { continue; } if (!is_null($parents)) { if ($object) { $field = $parents .'->'. $field; } else { if (is_int($field)) { $field = $parents .'['. $field .']'; } else { $field = $parents .'[\''. $field .'\']'; } } } $type = gettype($value); $show_summary = TRUE; $summary = NULL; if ($show_summary) { switch ($type) { case 'string' : case 'float' : case 'integer' : if (strlen($value) == 0) { $summary = t("{empty}"); } elseif (strlen($value) < 40) { $summary = htmlspecialchars($value); } else { $summary = format_plural(drupal_strlen($value), '1 character', '@count characters'); } break; case 'array' : case 'object' : $summary = format_plural(count((array)$value), '1 element', '@count elements'); break; case 'boolean' : $summary = $value ? t('TRUE') : t('FALSE'); break; } } if (!is_null($summary)) { $typesum = '('. $type .', '. $summary .')'; } else { $typesum = '('. $type .')'; } $output .= ''; $output .= "
{$prefix}{$field} $typesum
\n"; $output .= "
\n"; // Check for references. if (is_array($value) && isset($value['devel_flag_reference'])) { $value['devel_flag_reference'] = TRUE; } // Check for references to prevent errors from recursions. if (is_array($value) && isset($value['devel_flag_reference']) && !$value['devel_flag_reference']) { $value['devel_flag_reference'] = FALSE; $output .= _devel_print_object($value, $prefix, $field); } elseif (is_object($value)) { $value->devel_flag_reference = FALSE; $output .= _devel_print_object((array)$value, $prefix, $field, TRUE); } else { $value = is_bool($value) ? ($value ? 'TRUE' : 'FALSE') : $value; $output .= htmlspecialchars(print_r($value, TRUE)) ."\n"; } $output .= "
\n"; } $output .= "
\n"; } return $output; } /** * Adds a table at the bottom of the page cataloguing data on all the database queries that were made to * generate the page. */ function devel_query_table($queries, $counts) { $version = devel_get_core_version(VERSION); $header = array ('ms', '#', 'where', 'query'); $i = 0; $api = variable_get('devel_api_url', 'api.drupal.org'); foreach ($queries as $query) { // dprint_r($query); $ar = explode("\n", $query[0]); $function=array_shift($ar); $count = isset($counts[$query[0]]) ? $counts[$query[0]] : 0; $query[0]=join(' ',$ar); $diff = round($query[1] * 1000, 2); if ($diff > variable_get('devel_execution', 5)) { $cell[$i][] = array ('data' => $diff, 'class' => 'marker'); } else { $cell[$i][] = $diff; } if ($count > 1) { $cell[$i][] = array ('data' => $count, 'class' => 'marker'); } else { $cell[$i][] = $count; } $cell[$i][] = l($function, "http://$api/api/$version/function/$function"); $pos = strpos($query[0], '*/') + 3; $cell[$i][] = check_plain(substr($query[0], $pos)); $i++; unset($diff, $count); } if (variable_get('devel_query_sort', DEVEL_QUERY_SORT_BY_SOURCE)) { usort($cell, '_devel_table_sort'); } return theme('table', $header, $cell); } function _devel_table_sort($a, $b) { $a = is_array($a[0]) ? $a[0]['data'] : $a[0]; $b = is_array($b[0]) ? $b[0]['data'] : $b[0]; if ($a < $b) { return 1; } if ($a > $b) { return -1; } return 0; } /** * Displays page execution time at the bottom of the page. */ function devel_timer() { $time = timer_read('page'); return t_safe(' Page execution time was @time ms.', array('@time' => $time)); } /** * Prints the arguments passed into the current function */ function dargs($always = TRUE) { static $printed; if ($always || !$printed) { $bt = debug_backtrace(); print kdevel_print_object($bt[1]['args']); $printed = TRUE; } } /** * Print a variable to the 'message' area of the page. Uses drupal_set_message() */ function dpm($input, $name = NULL) { if (user_access('access devel information')) { $export = kprint_r($input, TRUE, $name); drupal_set_message($export); } } /** * Var_dump() a variable to the 'message' area of the page. Uses drupal_set_message() */ function dvm($input, $name = NULL) { if (user_access('access devel information')) { $export = dprint_r($input, TRUE, $name, 'var_dump', FALSE); drupal_set_message($export); } } // legacy function that was poorly named. use dpm() instead, since the 'p' maps to 'print_r' function dsm($input, $name = NULL) { dpm($input, $name); } /** * An alias for dprint_r(). Saves carpal tunnel syndrome. */ function dpr($input, $return = FALSE, $name = NULL) { return kprint_r($input, $return, $name); } /** * Like dpr, but uses var_dump() instead */ function dvr($input, $return = FALSE, $name = NULL) { return dprint_r($input, $return, $name, 'var_dump', FALSE); } function kprint_r($input, $return = FALSE, $name = NULL, $function = 'print_r') { // We do not want to krumo() strings and integers and such if (merits_krumo($input)) { if (user_access('access devel information')) { return $return ? krumo_ob($input) : krumo($input); } } else { return dprint_r($input, $return, $name, $function); } } /** * Pretty-print a variable to the browser. * Displays only for users with proper permissions. If * you want a string returned instead of a print, use the 2nd param. */ function dprint_r($input, $return = FALSE, $name = NULL, $function = 'print_r', $check= TRUE) { if (user_access('access devel information')) { if ($name) { $name .= ' => '; } ob_start(); $function($input); $output = ob_get_clean(); if ($check) { $output = check_plain($output); } if (count($input, COUNT_RECURSIVE) > DEVEL_MIN_TEXTAREA) { if (merits_krumo($input)) { $printed_value = krumo_ob($input); } else { // don't use fapi here because sometimes fapi will not be loaded $printed_value = "'; } } else { $printed_value = '
' . $name . $output . '
'; } if ($return) { return $printed_value; } else { print $printed_value; } } } /** * Print the function call stack. */ function ddebug_backtrace() { if (user_access('access devel information')) { $trace = debug_backtrace(); array_shift($trace); foreach ($trace as $key => $value) { $rich_trace[$value['function']] = $value; } if (has_krumo()) { print krumo($rich_trace); } else { dprint_r($rich_trace); } } } /** * Debugging version of db_query(). * * Echoes the query to the browser. */ function db_queryd($query) { $args = func_get_args(); array_shift($args); $query = db_prefix_tables($query); if (isset($args[0]) and is_array($args[0])) { // 'All arguments in one array' syntax $args = $args[0]; } _db_query_callback($args, TRUE); $query = preg_replace_callback(DB_QUERY_REGEXP, '_db_query_callback', $query); return _db_query($query, 1); } // Only define our mail wrapper if the devel module is the current mail // wrapper. if (variable_get('smtp_library', '') == drupal_get_filename('module', 'devel')) { /** * Log the mails sent out instead of mailing. */ function drupal_mail_wrapper($message) { $mimeheaders = array(); foreach ($message['headers'] as $name => $value) { // the check_plain nicely encodes <> chars for web presentation $mimeheaders[] = check_plain($name .': '. mime_header_encode($value)); } watchdog( 'devel', 'Mail sent:
Id: %mail_id
To: %to
From: %from
Language: %lang
Subject: %subject
Body: %body

Additional headers:
!header', array( '%mail_id' => $message['id'], '%to' => $message['to'], '%from' => $message['from'], '%lang' => $message['language']->language, '%subject' => $message['subject'], '%body' => $message['body'], '!header' => implode("
", $mimeheaders), WATCHDOG_INFO, ) ); return TRUE; } } function devel_queries() { $header = array( array('data' => t('Total (ms)'), 'field' => 'total_time', 'sort' => 'desc'), array('data' => t('Average (ms)'), 'field' => 'average', 'sort' => 'desc'), array('data' => t('Std deviation (ms)')), array('data' => t('Count'), 'field' => 'count'), array('data' => t('Function'), 'field' => 'q.function'), array('data' => t('Query'), 'field' => 'q.query'), ); global $db_type; if($db_type == 'pgsql') { $result = pager_query('SELECT q.qid, q.query, q.function , t.* FROM {devel_queries} q INNER JOIN (SELECT t.qid, COUNT(t.qid) AS count,SUM(t.time) AS total_time, AVG(t.time) AS average, STDDEV(t.time) AS stddev FROM {devel_times} t GROUP BY t.qid) AS t ON t.qid=q.qid ' . tablesort_sql($header), 30, 0, 'SELECT COUNT(qid) FROM {devel_queries}'); } else { $result = pager_query('SELECT q.qid, q.query, q.function, t.*, COUNT(t.qid) AS count, SUM(t.time) AS total_time, AVG(t.time) AS average, STDDEV(t.time) AS stddev FROM {devel_queries} q INNER JOIN {devel_times} t ON q.qid = t.qid GROUP BY t.qid '. tablesort_sql($header), 30, 0, 'SELECT COUNT(qid) FROM {devel_queries}'); } while ($log = db_fetch_object($result)) { $rows[] = array( round($log->total_time * 1000, 3), round($log->average * 1000, 3), round($log->stddev * 1000, 3), $log->count, $log->function, check_plain($log->query) ); } $output = theme('table', $header, $rows); $output .= theme('pager', NULL, 30, 0); $output .= l(t('Delete collected query statistics'), 'devel/queries/empty'); print theme('page', $output, FALSE); } function devel_queries_empty() { db_query('DELETE FROM {devel_queries}'); db_query('DELETE FROM {devel_times}'); drupal_set_message(t('Stored query statistics deleted.')); drupal_goto('devel/queries'); } /* * migration related functions */ /** * Menu callback. Rebuild node _comment_stats table. * * @return void **/ function devel_rebuild_node_comment_statistics_page() { devel_rebuild_node_comment_statistics(); drupal_set_message('node_comment_statistics table has been rebuilt.'); drupal_goto('admin'); } /** * Update node_comment_statistics table for nodes with comments. * TODO: if 2 comments have exact same timestamp, the function can get wrong uid and name fields. * Handles when comment timestamps have been manually set in admin * * @return void **/ function devel_rebuild_node_comment_statistics() { // Empty table $sql = "DELETE FROM {node_comment_statistics}"; db_query($sql); $sql = "INSERT INTO {node_comment_statistics} (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) (select nid, c.timestamp, name, uid, comment_count FROM {comments} c INNER JOIN (SELECT MAX(timestamp) AS timestamp, COUNT(*) AS comment_count FROM {comments} WHERE status=%d GROUP BY nid) as c2 ON c.timestamp=c2.timestamp)"; db_query($sql, COMMENT_PUBLISHED); // Insert 0 count records into the node_comment_statistics for nodes that are missing. See comment_enable() db_query_temporary("SELECT n.nid, n.changed, n.uid FROM {node} n LEFT JOIN {node_comment_statistics} c ON n.nid = c.nid WHERE c.comment_count IS NULL", 'missing_nids'); db_query("INSERT INTO {node_comment_statistics} (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) SELECT n.nid, n.changed, NULL, n.uid, 0 FROM missing_nids n"); } /** * Set sequences table to a sane state. Useful after a bulk import. * * @return void **/ function sequence_reset($table, $column) { $max = db_result(db_query("SELECT MAX($column) FROM {$table}")); $max = ($max ? $max+1 : 2); db_query("UPDATE {sequences} SET id = $max WHERE name='${table}_$column'"); } /** * Enable or disable indexes for a given table. Useful during a bulk import. * * @return void **/ function devel_table_keys($tables, $verb = 'ENABLE') { foreach ($tables as $table) { db_query("ALTER TABLE $table $verb KEYS"); } } /** * Save contents of an url to filesystem. Works for images. * * @return void **/ function wget($url, $file) { if (file_exists($file)) { return; } print "get: $url\n"; $ch = curl_init($url); $fp = fopen($file, "w"); curl_setopt($ch, CURLOPT_FILE, $fp); curl_setopt($ch, CURLOPT_HEADER, 0); curl_exec($ch); curl_close($ch); fclose($fp); }