1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298 |
- <?php
- function system_requirements($phase) {
- global $base_url;
- $requirements = array();
-
- $t = get_t();
-
- if ($phase == 'runtime') {
- $requirements['drupal'] = array(
- 'title' => $t('Drupal'),
- 'value' => VERSION,
- 'severity' => REQUIREMENT_INFO,
- 'weight' => -10,
- );
-
-
- $profile = drupal_get_profile();
- if ($profile != 'standard') {
- $info = system_get_info('module', $profile);
- $requirements['install_profile'] = array(
- 'title' => $t('Install profile'),
- 'value' => $t('%profile_name (%profile-%version)', array(
- '%profile_name' => $info['name'],
- '%profile' => $profile,
- '%version' => $info['version']
- )),
- 'severity' => REQUIREMENT_INFO,
- 'weight' => -9
- );
- }
- }
-
- $software = $_SERVER['SERVER_SOFTWARE'];
- $requirements['webserver'] = array(
- 'title' => $t('Web server'),
- 'value' => $software,
- );
-
- $phpversion = phpversion();
- if (function_exists('phpinfo')) {
- $requirements['php'] = array(
- 'title' => $t('PHP'),
- 'value' => ($phase == 'runtime') ? $phpversion .' ('. l($t('more information'), 'admin/reports/status/php') .')' : $phpversion,
- );
- }
- else {
- $requirements['php'] = array(
- 'title' => $t('PHP'),
- 'value' => $phpversion,
- 'description' => $t('The phpinfo() function has been disabled for security reasons. To see your server\'s phpinfo() information, change your PHP settings or contact your server administrator. For more information, <a href="@phpinfo">Enabling and disabling phpinfo()</a> handbook page.', array('@phpinfo' => 'http://drupal.org/node/243993')),
- 'severity' => REQUIREMENT_INFO,
- );
- }
- if (version_compare($phpversion, DRUPAL_MINIMUM_PHP) < 0) {
- $requirements['php']['description'] = $t('Your PHP installation is too old. Drupal requires at least PHP %version.', array('%version' => DRUPAL_MINIMUM_PHP));
- $requirements['php']['severity'] = REQUIREMENT_ERROR;
-
- return $requirements;
- }
-
-
-
- elseif (version_compare($phpversion, '5.2.5') < 0 && strlen(@htmlspecialchars(chr(0xC0) . chr(0xAF), ENT_QUOTES, 'UTF-8'))) {
- $requirements['php']['description'] = $t('Your PHP installation is too old. Drupal requires at least PHP 5.2.5, or PHP @version with the htmlspecialchars security patch backported.', array('@version' => DRUPAL_MINIMUM_PHP));
- $requirements['php']['severity'] = REQUIREMENT_ERROR;
-
- return $requirements;
- }
-
- $requirements['php_register_globals'] = array(
- 'title' => $t('PHP register globals'),
- );
- $register_globals = trim(ini_get('register_globals'));
-
-
-
-
-
- if (!empty($register_globals) && strtolower($register_globals) != 'off') {
- $requirements['php_register_globals']['description'] = $t('<em>register_globals</em> is enabled. Drupal requires this configuration directive to be disabled. Your site may not be secure when <em>register_globals</em> is enabled. The PHP manual has instructions for <a href="http://php.net/configuration.changes">how to change configuration settings</a>.');
- $requirements['php_register_globals']['severity'] = REQUIREMENT_ERROR;
- $requirements['php_register_globals']['value'] = $t("Enabled ('@value')", array('@value' => $register_globals));
- }
- else {
- $requirements['php_register_globals']['value'] = $t('Disabled');
- }
-
- $requirements['php_extensions'] = array(
- 'title' => $t('PHP extensions'),
- );
- $missing_extensions = array();
- $required_extensions = array(
- 'date',
- 'dom',
- 'filter',
- 'gd',
- 'hash',
- 'json',
- 'pcre',
- 'pdo',
- 'session',
- 'SimpleXML',
- 'SPL',
- 'xml',
- );
- foreach ($required_extensions as $extension) {
- if (!extension_loaded($extension)) {
- $missing_extensions[] = $extension;
- }
- }
- if (!empty($missing_extensions)) {
- $description = $t('Drupal requires you to enable the PHP extensions in the following list (see the <a href="@system_requirements">system requirements page</a> for more information):', array(
- '@system_requirements' => 'http://drupal.org/requirements',
- ));
- $description .= theme('item_list', array('items' => $missing_extensions));
- $requirements['php_extensions']['value'] = $t('Disabled');
- $requirements['php_extensions']['severity'] = REQUIREMENT_ERROR;
- $requirements['php_extensions']['description'] = $description;
- }
- else {
- $requirements['php_extensions']['value'] = $t('Enabled');
- }
- if ($phase == 'install' || $phase == 'update') {
-
- $requirements['database_extensions'] = array(
- 'title' => $t('Database support'),
- );
-
- $database_ok = extension_loaded('pdo');
- if (!$database_ok) {
- $pdo_message = $t('Your web server does not appear to support PDO (PHP Data Objects). Ask your hosting provider if they support the native PDO extension. See the <a href="@link">system requirements</a> page for more information.', array(
- '@link' => 'http://drupal.org/requirements/pdo',
- ));
- }
- else {
-
- $drivers = drupal_detect_database_types();
- if (empty($drivers)) {
- $database_ok = FALSE;
- $pdo_message = $t('Your web server does not appear to support any common PDO database extensions. Check with your hosting provider to see if they support PDO (PHP Data Objects) and offer any databases that <a href="@drupal-databases">Drupal supports</a>.', array(
- '@drupal-databases' => 'https://www.drupal.org/requirements/database',
- ));
- }
-
-
- if (!defined('PDO::ATTR_DEFAULT_FETCH_MODE')) {
- $database_ok = FALSE;
- $pdo_message = $t('Your web server seems to have the wrong version of PDO installed. Drupal 7 requires the PDO extension from PHP core. This system has the older PECL version. See the <a href="@link">system requirements</a> page for more information.', array(
- '@link' => 'http://drupal.org/requirements/pdo#pecl',
- ));
- }
- }
- if (!$database_ok) {
- $requirements['database_extensions']['value'] = $t('Disabled');
- $requirements['database_extensions']['severity'] = REQUIREMENT_ERROR;
- $requirements['database_extensions']['description'] = $pdo_message;
- }
- else {
- $requirements['database_extensions']['value'] = $t('Enabled');
- }
- }
- else {
-
- $class = 'DatabaseTasks_' . Database::getConnection()->driver();
- $tasks = new $class();
- $requirements['database_system'] = array(
- 'title' => $t('Database system'),
- 'value' => $tasks->name(),
- );
- $requirements['database_system_version'] = array(
- 'title' => $t('Database system version'),
- 'value' => Database::getConnection()->version(),
- );
- }
-
- $charset_requirements = _system_check_db_utf8mb4_requirements($phase);
- if (!empty($charset_requirements)) {
- $requirements['database_charset'] = $charset_requirements;
- }
-
- $memory_limit = ini_get('memory_limit');
- $requirements['php_memory_limit'] = array(
- 'title' => $t('PHP memory limit'),
- 'value' => $memory_limit == -1 ? t('-1 (Unlimited)') : $memory_limit,
- );
- if (!drupal_check_memory_limit(DRUPAL_MINIMUM_PHP_MEMORY_LIMIT, $memory_limit)) {
- $description = '';
- if ($phase == 'install') {
- $description = $t('Consider increasing your PHP memory limit to %memory_minimum_limit to help prevent errors in the installation process.', array('%memory_minimum_limit' => DRUPAL_MINIMUM_PHP_MEMORY_LIMIT));
- }
- elseif ($phase == 'update') {
- $description = $t('Consider increasing your PHP memory limit to %memory_minimum_limit to help prevent errors in the update process.', array('%memory_minimum_limit' => DRUPAL_MINIMUM_PHP_MEMORY_LIMIT));
- }
- elseif ($phase == 'runtime') {
- $description = $t('Depending on your configuration, Drupal can run with a %memory_limit PHP memory limit. However, a %memory_minimum_limit PHP memory limit or above is recommended, especially if your site uses additional custom or contributed modules.', array('%memory_limit' => $memory_limit, '%memory_minimum_limit' => DRUPAL_MINIMUM_PHP_MEMORY_LIMIT));
- }
- if (!empty($description)) {
- if ($php_ini_path = get_cfg_var('cfg_file_path')) {
- $description .= ' ' . $t('Increase the memory limit by editing the memory_limit parameter in the file %configuration-file and then restart your web server (or contact your system administrator or hosting provider for assistance).', array('%configuration-file' => $php_ini_path));
- }
- else {
- $description .= ' ' . $t('Contact your system administrator or hosting provider for assistance with increasing your PHP memory limit.');
- }
- $requirements['php_memory_limit']['description'] = $description . ' ' . $t('See the <a href="@url">Drupal requirements</a> for more information.', array('@url' => 'http://drupal.org/requirements'));
- $requirements['php_memory_limit']['severity'] = REQUIREMENT_WARNING;
- }
- }
-
- if ($phase == 'runtime') {
- $conf_dir = drupal_verify_install_file(conf_path(), FILE_NOT_WRITABLE, 'dir');
- $conf_file = drupal_verify_install_file(conf_path() . '/settings.php', FILE_EXIST|FILE_READABLE|FILE_NOT_WRITABLE);
- if (!$conf_dir || !$conf_file) {
- $requirements['settings.php'] = array(
- 'value' => $t('Not protected'),
- 'severity' => REQUIREMENT_ERROR,
- 'description' => '',
- );
- if (!$conf_dir) {
- $requirements['settings.php']['description'] .= $t('The directory %file is not protected from modifications and poses a security risk. You must change the directory\'s permissions to be non-writable. ', array('%file' => conf_path()));
- }
- if (!$conf_file) {
- $requirements['settings.php']['description'] .= $t('The file %file is not protected from modifications and poses a security risk. You must change the file\'s permissions to be non-writable.', array('%file' => conf_path() . '/settings.php'));
- }
- }
- else {
- $requirements['settings.php'] = array(
- 'value' => $t('Protected'),
- );
- }
- $requirements['settings.php']['title'] = $t('Configuration file');
- }
-
- if ($phase == 'runtime') {
-
-
- file_ensure_htaccess();
- $htaccess_files['public://.htaccess'] = array(
- 'title' => $t('Public files directory'),
- 'directory' => variable_get('file_public_path', conf_path() . '/files'),
- );
- if ($private_files_directory = variable_get('file_private_path')) {
- $htaccess_files['private://.htaccess'] = array(
- 'title' => $t('Private files directory'),
- 'directory' => $private_files_directory,
- );
- }
- $htaccess_files['temporary://.htaccess'] = array(
- 'title' => $t('Temporary files directory'),
- 'directory' => variable_get('file_temporary_path', file_directory_temp()),
- );
- foreach ($htaccess_files as $htaccess_file => $info) {
-
-
- if (!file_exists($htaccess_file) || !($contents = @file_get_contents($htaccess_file)) || strpos($contents, 'Drupal_Security_Do_Not_Remove_See_SA_2013_003') === FALSE) {
- $requirements[$htaccess_file] = array(
- 'title' => $info['title'],
- 'value' => $t('Not fully protected'),
- 'severity' => REQUIREMENT_ERROR,
- 'description' => $t('See <a href="@url">@url</a> for information about the recommended .htaccess file which should be added to the %directory directory to help protect against arbitrary code execution.', array('@url' => 'http://drupal.org/SA-CORE-2013-003', '%directory' => $info['directory'])),
- );
- }
- }
- }
-
- if ($phase == 'runtime') {
-
- $threshold_warning = variable_get('cron_threshold_warning', 172800);
-
- $threshold_error = variable_get('cron_threshold_error', 1209600);
-
- $help = $t('For more information, see the online handbook entry for <a href="@cron-handbook">configuring cron jobs</a>.', array('@cron-handbook' => 'http://drupal.org/cron'));
-
- $cron_last = variable_get('cron_last');
- if (!is_numeric($cron_last)) {
- $cron_last = variable_get('install_time', 0);
- }
-
- $severity = REQUIREMENT_OK;
- if (REQUEST_TIME - $cron_last > $threshold_error) {
- $severity = REQUIREMENT_ERROR;
- }
- elseif (REQUEST_TIME - $cron_last > $threshold_warning) {
- $severity = REQUIREMENT_WARNING;
- }
-
- $summary = $t('Last run !time ago', array('!time' => format_interval(REQUEST_TIME - $cron_last)));
- $description = '';
- if ($severity != REQUIREMENT_OK) {
- $description = $t('Cron has not run recently.') . ' ' . $help;
- }
- $description .= ' ' . $t('You can <a href="@cron">run cron manually</a>.', array('@cron' => url('admin/reports/status/run-cron')));
- $description .= '<br />' . $t('To run cron from outside the site, go to <a href="!cron">!cron</a>', array('!cron' => url($base_url . '/cron.php', array('external' => TRUE, 'query' => array('cron_key' => variable_get('cron_key', 'drupal'))))));
- $requirements['cron'] = array(
- 'title' => $t('Cron maintenance tasks'),
- 'severity' => $severity,
- 'value' => $summary,
- 'description' => $description
- );
- }
-
- $directories = array(
- variable_get('file_public_path', conf_path() . '/files'),
-
-
- variable_get('file_private_path', FALSE),
- );
-
-
-
- if ($phase == 'install') {
- $directories[] = variable_get('file_temporary_path', FALSE);
- }
- else {
- $directories[] = variable_get('file_temporary_path', file_directory_temp());
- }
- $requirements['file system'] = array(
- 'title' => $t('File system'),
- );
- $error = '';
-
- foreach ($directories as $directory) {
- if (!$directory) {
- continue;
- }
- if ($phase == 'install') {
- file_prepare_directory($directory, FILE_CREATE_DIRECTORY);
- }
- $is_writable = is_writable($directory);
- $is_directory = is_dir($directory);
- if (!$is_writable || !$is_directory) {
- $description = '';
- $requirements['file system']['value'] = $t('Not writable');
- if (!$is_directory) {
- $error .= $t('The directory %directory does not exist.', array('%directory' => $directory)) . ' ';
- }
- else {
- $error .= $t('The directory %directory is not writable.', array('%directory' => $directory)) . ' ';
- }
-
- if ($phase == 'runtime') {
- $description = $error . $t('You may need to set the correct directory at the <a href="@admin-file-system">file system settings page</a> or change the current directory\'s permissions so that it is writable.', array('@admin-file-system' => url('admin/config/media/file-system')));
- }
- elseif ($phase == 'install') {
-
-
- $description = $error . $t('An automated attempt to create this directory failed, possibly due to a permissions problem. To proceed with the installation, either create the directory and modify its permissions manually or ensure that the installer has the permissions to create it automatically. For more information, see INSTALL.txt or the <a href="@handbook_url">online handbook</a>.', array('@handbook_url' => 'http://drupal.org/server-permissions'));
- $requirements['file system']['value'] = '';
- }
- if (!empty($description)) {
- $requirements['file system']['description'] = $description;
- $requirements['file system']['severity'] = REQUIREMENT_ERROR;
- }
- }
- else {
- if (file_default_scheme() == 'public') {
- $requirements['file system']['value'] = $t('Writable (<em>public</em> download method)');
- }
- else {
- $requirements['file system']['value'] = $t('Writable (<em>private</em> download method)');
- }
- }
- }
-
- if ($phase == 'runtime') {
- $requirements['update'] = array(
- 'title' => $t('Database updates'),
- 'severity' => REQUIREMENT_OK,
- 'value' => $t('Up to date'),
- );
-
- foreach (module_list() as $module) {
- $updates = drupal_get_schema_versions($module);
- if ($updates !== FALSE) {
- $default = drupal_get_installed_schema_version($module);
- if (max($updates) > $default) {
- $requirements['update']['severity'] = REQUIREMENT_ERROR;
- $requirements['update']['value'] = $t('Out of date');
- $requirements['update']['description'] = $t('Some modules have database schema updates to install. You should run the <a href="@update">database update script</a> immediately.', array('@update' => base_path() . 'update.php'));
- break;
- }
- }
- }
- }
-
- if ($phase == 'runtime') {
- if (!empty($GLOBALS['update_free_access'])) {
- $requirements['update access'] = array(
- 'value' => $t('Not protected'),
- 'severity' => REQUIREMENT_ERROR,
- 'description' => $t('The update.php script is accessible to everyone without authentication check, which is a security risk. You must change the $update_free_access value in your settings.php back to FALSE.'),
- );
- }
- else {
- $requirements['update access'] = array(
- 'value' => $t('Protected'),
- );
- }
- $requirements['update access']['title'] = $t('Access to update.php');
- }
-
- if ($phase == 'update') {
- $profile = drupal_get_profile();
- $files = system_rebuild_module_data();
- foreach ($files as $module => $file) {
-
- if (!$file->status || $module == $profile) {
- continue;
- }
-
- $name = $file->info['name'];
- $php = $file->info['php'];
- if (version_compare($php, PHP_VERSION, '>')) {
- $requirements['php']['description'] .= $t('@name requires at least PHP @version.', array('@name' => $name, '@version' => $php));
- $requirements['php']['severity'] = REQUIREMENT_ERROR;
- }
-
- foreach ($file->requires as $requirement) {
- $required_module = $requirement['name'];
-
- if (!isset($files[$required_module])) {
- $requirements["$module-$required_module"] = array(
- 'title' => $t('Unresolved dependency'),
- 'description' => $t('@name requires this module.', array('@name' => $name)),
- 'value' => t('@required_name (Missing)', array('@required_name' => $required_module)),
- 'severity' => REQUIREMENT_ERROR,
- );
- continue;
- }
-
- $required_file = $files[$required_module];
- $required_name = $required_file->info['name'];
- $version = str_replace(DRUPAL_CORE_COMPATIBILITY . '-', '', $required_file->info['version']);
- $compatibility = drupal_check_incompatibility($requirement, $version);
- if ($compatibility) {
- $compatibility = rtrim(substr($compatibility, 2), ')');
- $requirements["$module-$required_module"] = array(
- 'title' => $t('Unresolved dependency'),
- 'description' => $t('@name requires this module and version. Currently using @required_name version @version', array('@name' => $name, '@required_name' => $required_name, '@version' => $version)),
- 'value' => t('@required_name (Version @compatibility required)', array('@required_name' => $required_name, '@compatibility' => $compatibility)),
- 'severity' => REQUIREMENT_ERROR,
- );
- continue;
- }
- }
- }
- }
-
- include_once DRUPAL_ROOT . '/includes/unicode.inc';
- $requirements = array_merge($requirements, unicode_requirements());
- if ($phase == 'runtime') {
-
- if (!module_exists('update')) {
- $requirements['update status'] = array(
- 'value' => $t('Not enabled'),
- 'severity' => REQUIREMENT_WARNING,
- 'description' => $t('Update notifications are not enabled. It is <strong>highly recommended</strong> that you enable the update manager module from the <a href="@module">module administration page</a> in order to stay up-to-date on new releases. For more information, <a href="@update">Update status handbook page</a>.', array('@update' => 'http://drupal.org/documentation/modules/update', '@module' => url('admin/modules'))),
- );
- }
- else {
- $requirements['update status'] = array(
- 'value' => $t('Enabled'),
- );
- }
- $requirements['update status']['title'] = $t('Update notifications');
-
- if (variable_get('drupal_http_request_fails', TRUE) && !system_check_http_request()) {
- $requirements['http requests'] = array(
- 'title' => $t('HTTP request status'),
- 'value' => $t('Fails'),
- 'severity' => REQUIREMENT_ERROR,
- 'description' => $t('Your system or network configuration does not allow Drupal to access web pages, resulting in reduced functionality. This could be due to your webserver configuration or PHP settings, and should be resolved in order to download information about available updates, fetch aggregator feeds, sign in via OpenID, or use other network-dependent services. If you are certain that Drupal can access web pages but you are still seeing this message, you may add <code>$conf[\'drupal_http_request_fails\'] = FALSE;</code> to the bottom of your settings.php file.'),
- );
- }
- }
- return $requirements;
- }
- function _system_check_db_utf8mb4_requirements($phase) {
- global $install_state;
-
-
-
-
- if (isset($install_state['settings_verified']) && !$install_state['settings_verified']) {
- return array();
- }
- $connection = Database::getConnection();
- $t = get_t();
- $requirements['title'] = $t('Database 4 byte UTF-8 support');
- $utf8mb4_configurable = $connection->utf8mb4IsConfigurable();
- $utf8mb4_active = $connection->utf8mb4IsActive();
- $utf8mb4_supported = $connection->utf8mb4IsSupported();
- $driver = $connection->driver();
- $documentation_url = 'https://www.drupal.org/node/2754539';
- if ($utf8mb4_active) {
- if ($utf8mb4_supported) {
- if ($phase != 'install' && $utf8mb4_configurable && !variable_get('drupal_all_databases_are_utf8mb4', FALSE)) {
-
-
- $requirements['value'] = $t('Enabled, but database tables need conversion');
- $requirements['description'] = $t('Please convert all database tables to utf8mb4 prior to enabling it in settings.php. See the <a href="@url">documentation on adding 4 byte UTF-8 support</a> for more information.', array('@url' => $documentation_url));
- $requirements['severity'] = REQUIREMENT_ERROR;
- }
- else {
-
- $requirements['value'] = $t('Enabled');
- $requirements['description'] = $t('4 byte UTF-8 for @driver is enabled.', array('@driver' => $driver));
- $requirements['severity'] = REQUIREMENT_OK;
- }
- }
- else {
-
- $requirements['value'] = $t('Not supported');
- $requirements['description'] = $t('4 byte UTF-8 for @driver is activated, but not supported on your system. Please turn this off in settings.php, or ensure that all database-related requirements are met. See the <a href="@url">documentation on adding 4 byte UTF-8 support</a> for more information.', array('@driver' => $driver, '@url' => $documentation_url));
- $requirements['severity'] = REQUIREMENT_ERROR;
- }
- }
- else {
- if ($utf8mb4_supported) {
-
- $requirements['value'] = $t('Not enabled');
- $requirements['description'] = $t('4 byte UTF-8 for @driver is not activated, but it is supported on your system. It is recommended that you enable this to allow 4-byte UTF-8 input such as emojis, Asian symbols and mathematical symbols to be stored correctly. See the <a href="@url">documentation on adding 4 byte UTF-8 support</a> for more information.', array('@driver' => $driver, '@url' => $documentation_url));
- $requirements['severity'] = REQUIREMENT_INFO;
- }
- else {
-
- $requirements['value'] = $t('Disabled');
- $requirements['description'] = $t('4 byte UTF-8 for @driver is disabled. See the <a href="@url">documentation on adding 4 byte UTF-8 support</a> for more information.', array('@driver' => $driver, '@url' => $documentation_url));
- $requirements['severity'] = REQUIREMENT_INFO;
- }
- }
- return $requirements;
- }
- function system_install() {
-
- drupal_install_schema('system');
- $versions = drupal_get_schema_versions('system');
- $version = $versions ? max($versions) : SCHEMA_INSTALLED;
- drupal_set_installed_schema_version('system', $version);
-
-
- module_list(TRUE);
- module_implements('', FALSE, TRUE);
-
- drupal_static_reset('drupal_get_schema_versions');
-
- system_rebuild_theme_data();
-
- variable_set('theme_default', 'bartik');
- db_update('system')
- ->fields(array('status' => 1))
- ->condition('type', 'theme')
- ->condition('name', 'bartik')
- ->execute();
-
- $cron_key = drupal_random_key();
- variable_set('cron_key', $cron_key);
- }
- function system_schema() {
-
-
-
- $schema['variable'] = array(
- 'description' => 'Named variable/value pairs created by Drupal core or any other module or theme. All variables are cached in memory at the start of every Drupal request so developers should not be careless about what is stored here.',
- 'fields' => array(
- 'name' => array(
- 'description' => 'The name of the variable.',
- 'type' => 'varchar',
- 'length' => 128,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'value' => array(
- 'description' => 'The value of the variable.',
- 'type' => 'blob',
- 'not null' => TRUE,
- 'size' => 'big',
- 'translatable' => TRUE,
- ),
- ),
- 'primary key' => array('name'),
- );
- $schema['actions'] = array(
- 'description' => 'Stores action information.',
- 'fields' => array(
- 'aid' => array(
- 'description' => 'Primary Key: Unique actions ID.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '0',
- ),
- 'type' => array(
- 'description' => 'The object that that action acts on (node, user, comment, system or custom types.)',
- 'type' => 'varchar',
- 'length' => 32,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'callback' => array(
- 'description' => 'The callback function that executes when the action runs.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'parameters' => array(
- 'description' => 'Parameters to be passed to the callback function.',
- 'type' => 'blob',
- 'not null' => TRUE,
- 'size' => 'big',
- ),
- 'label' => array(
- 'description' => 'Label of the action.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '0',
- ),
- ),
- 'primary key' => array('aid'),
- );
- $schema['batch'] = array(
- 'description' => 'Stores details about batches (processes that run in multiple HTTP requests).',
- 'fields' => array(
- 'bid' => array(
- 'description' => 'Primary Key: Unique batch ID.',
-
-
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'token' => array(
- 'description' => "A string token generated against the current user's session id and the batch id, used to ensure that only the user who submitted the batch can effectively access it.",
- 'type' => 'varchar',
- 'length' => 64,
- 'not null' => TRUE,
- ),
- 'timestamp' => array(
- 'description' => 'A Unix timestamp indicating when this batch was submitted for processing. Stale batches are purged at cron time.',
- 'type' => 'int',
- 'not null' => TRUE,
- ),
- 'batch' => array(
- 'description' => 'A serialized array containing the processing data for the batch.',
- 'type' => 'blob',
- 'not null' => FALSE,
- 'size' => 'big',
- ),
- ),
- 'primary key' => array('bid'),
- 'indexes' => array(
- 'token' => array('token'),
- ),
- );
- $schema['blocked_ips'] = array(
- 'description' => 'Stores blocked IP addresses.',
- 'fields' => array(
- 'iid' => array(
- 'description' => 'Primary Key: unique ID for IP addresses.',
- 'type' => 'serial',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'ip' => array(
- 'description' => 'IP address',
- 'type' => 'varchar',
- 'length' => 40,
- 'not null' => TRUE,
- 'default' => '',
- ),
- ),
- 'indexes' => array(
- 'blocked_ip' => array('ip'),
- ),
- 'primary key' => array('iid'),
- );
- $schema['cache'] = array(
- 'description' => 'Generic cache table for caching things not separated out into their own tables. Contributed modules may also use this to store cached items.',
- 'fields' => array(
- 'cid' => array(
- 'description' => 'Primary Key: Unique cache ID.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'data' => array(
- 'description' => 'A collection of data to cache.',
- 'type' => 'blob',
- 'not null' => FALSE,
- 'size' => 'big',
- ),
- 'expire' => array(
- 'description' => 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'created' => array(
- 'description' => 'A Unix timestamp indicating when the cache entry was created.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'serialized' => array(
- 'description' => 'A flag to indicate whether content is serialized (1) or not (0).',
- 'type' => 'int',
- 'size' => 'small',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- ),
- 'indexes' => array(
- 'expire' => array('expire'),
- ),
- 'primary key' => array('cid'),
- );
- $schema['cache_bootstrap'] = $schema['cache'];
- $schema['cache_bootstrap']['description'] = 'Cache table for data required to bootstrap Drupal, may be routed to a shared memory cache.';
- $schema['cache_form'] = $schema['cache'];
- $schema['cache_form']['description'] = 'Cache table for the form system to store recently built forms and their storage data, to be used in subsequent page requests.';
- $schema['cache_page'] = $schema['cache'];
- $schema['cache_page']['description'] = 'Cache table used to store compressed pages for anonymous users, if page caching is enabled.';
- $schema['cache_menu'] = $schema['cache'];
- $schema['cache_menu']['description'] = 'Cache table for the menu system to store router information as well as generated link trees for various menu/page/user combinations.';
- $schema['cache_path'] = $schema['cache'];
- $schema['cache_path']['description'] = 'Cache table for path alias lookup.';
- $schema['date_format_type'] = array(
- 'description' => 'Stores configured date format types.',
- 'fields' => array(
- 'type' => array(
- 'description' => 'The date format type, e.g. medium.',
- 'type' => 'varchar',
- 'length' => 64,
- 'not null' => TRUE,
- ),
- 'title' => array(
- 'description' => 'The human readable name of the format type.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- ),
- 'locked' => array(
- 'description' => 'Whether or not this is a system provided format.',
- 'type' => 'int',
- 'size' => 'tiny',
- 'default' => 0,
- 'not null' => TRUE,
- ),
- ),
- 'primary key' => array('type'),
- 'indexes' => array(
- 'title' => array('title'),
- ),
- );
-
-
- $schema['date_formats'] = array(
- 'description' => 'Stores configured date formats.',
- 'fields' => array(
- 'dfid' => array(
- 'description' => 'The date format identifier.',
- 'type' => 'serial',
- 'not null' => TRUE,
- 'unsigned' => TRUE,
- ),
- 'format' => array(
- 'description' => 'The date format string.',
- 'type' => 'varchar',
- 'length' => 100,
- 'not null' => TRUE,
- 'binary' => TRUE,
- ),
- 'type' => array(
- 'description' => 'The date format type, e.g. medium.',
- 'type' => 'varchar',
- 'length' => 64,
- 'not null' => TRUE,
- ),
- 'locked' => array(
- 'description' => 'Whether or not this format can be modified.',
- 'type' => 'int',
- 'size' => 'tiny',
- 'default' => 0,
- 'not null' => TRUE,
- ),
- ),
- 'primary key' => array('dfid'),
- 'unique keys' => array('formats' => array('format', 'type')),
- );
- $schema['date_format_locale'] = array(
- 'description' => 'Stores configured date formats for each locale.',
- 'fields' => array(
- 'format' => array(
- 'description' => 'The date format string.',
- 'type' => 'varchar',
- 'length' => 100,
- 'not null' => TRUE,
- 'binary' => TRUE,
- ),
- 'type' => array(
- 'description' => 'The date format type, e.g. medium.',
- 'type' => 'varchar',
- 'length' => 64,
- 'not null' => TRUE,
- ),
- 'language' => array(
- 'description' => 'A {languages}.language for this format to be used with.',
- 'type' => 'varchar',
- 'length' => 12,
- 'not null' => TRUE,
- ),
- ),
- 'primary key' => array('type', 'language'),
- );
- $schema['file_managed'] = array(
- 'description' => 'Stores information for uploaded files.',
- 'fields' => array(
- 'fid' => array(
- 'description' => 'File ID.',
- 'type' => 'serial',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'uid' => array(
- 'description' => 'The {users}.uid of the user who is associated with the file.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'filename' => array(
- 'description' => 'Name of the file with no path components. This may differ from the basename of the URI if the file is renamed to avoid overwriting an existing file.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'uri' => array(
- 'description' => 'The URI to access the file (either local or remote).',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- 'binary' => TRUE,
- ),
- 'filemime' => array(
- 'description' => "The file's MIME type.",
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'filesize' => array(
- 'description' => 'The size of the file in bytes.',
- 'type' => 'int',
- 'size' => 'big',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'status' => array(
- 'description' => 'A field indicating the status of the file. Two status are defined in core: temporary (0) and permanent (1). Temporary files older than DRUPAL_MAXIMUM_TEMP_FILE_AGE will be removed during a cron run.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'size' => 'tiny',
- ),
- 'timestamp' => array(
- 'description' => 'UNIX timestamp for when the file was added.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- ),
- 'indexes' => array(
- 'uid' => array('uid'),
- 'status' => array('status'),
- 'timestamp' => array('timestamp'),
- ),
- 'unique keys' => array(
- 'uri' => array('uri'),
- ),
- 'primary key' => array('fid'),
- 'foreign keys' => array(
- 'file_owner' => array(
- 'table' => 'users',
- 'columns' => array('uid' => 'uid'),
- ),
- ),
- );
- $schema['file_usage'] = array(
- 'description' => 'Track where a file is used.',
- 'fields' => array(
- 'fid' => array(
- 'description' => 'File ID.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'module' => array(
- 'description' => 'The name of the module that is using the file.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'type' => array(
- 'description' => 'The name of the object type in which the file is used.',
- 'type' => 'varchar',
- 'length' => 64,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'id' => array(
- 'description' => 'The primary key of the object using the file.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'count' => array(
- 'description' => 'The number of times this file is used by this object.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- ),
- 'primary key' => array('fid', 'type', 'id', 'module'),
- 'indexes' => array(
- 'type_id' => array('type', 'id'),
- 'fid_count' => array('fid', 'count'),
- 'fid_module' => array('fid', 'module'),
- ),
- );
- $schema['flood'] = array(
- 'description' => 'Flood controls the threshold of events, such as the number of contact attempts.',
- 'fields' => array(
- 'fid' => array(
- 'description' => 'Unique flood event ID.',
- 'type' => 'serial',
- 'not null' => TRUE,
- ),
- 'event' => array(
- 'description' => 'Name of event (e.g. contact).',
- 'type' => 'varchar',
- 'length' => 64,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'identifier' => array(
- 'description' => 'Identifier of the visitor, such as an IP address or hostname.',
- 'type' => 'varchar',
- 'length' => 128,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'timestamp' => array(
- 'description' => 'Timestamp of the event.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'expiration' => array(
- 'description' => 'Expiration timestamp. Expired events are purged on cron run.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- ),
- 'primary key' => array('fid'),
- 'indexes' => array(
- 'allow' => array('event', 'identifier', 'timestamp'),
- 'purge' => array('expiration'),
- ),
- );
- $schema['menu_router'] = array(
- 'description' => 'Maps paths to various callbacks (access, page and title)',
- 'fields' => array(
- 'path' => array(
- 'description' => 'Primary Key: the Drupal path this entry describes',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'load_functions' => array(
- 'description' => 'A serialized array of function names (like node_load) to be called to load an object corresponding to a part of the current path.',
- 'type' => 'blob',
- 'not null' => TRUE,
- ),
- 'to_arg_functions' => array(
- 'description' => 'A serialized array of function names (like user_uid_optional_to_arg) to be called to replace a part of the router path with another string.',
- 'type' => 'blob',
- 'not null' => TRUE,
- ),
- 'access_callback' => array(
- 'description' => 'The callback which determines the access to this router path. Defaults to user_access.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'access_arguments' => array(
- 'description' => 'A serialized array of arguments for the access callback.',
- 'type' => 'blob',
- 'not null' => FALSE,
- ),
- 'page_callback' => array(
- 'description' => 'The name of the function that renders the page.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'page_arguments' => array(
- 'description' => 'A serialized array of arguments for the page callback.',
- 'type' => 'blob',
- 'not null' => FALSE,
- ),
- 'delivery_callback' => array(
- 'description' => 'The name of the function that sends the result of the page_callback function to the browser.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'fit' => array(
- 'description' => 'A numeric representation of how specific the path is.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'number_parts' => array(
- 'description' => 'Number of parts in this router path.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'size' => 'small',
- ),
- 'context' => array(
- 'description' => 'Only for local tasks (tabs) - the context of a local task to control its placement.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'tab_parent' => array(
- 'description' => 'Only for local tasks (tabs) - the router path of the parent page (which may also be a local task).',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'tab_root' => array(
- 'description' => 'Router path of the closest non-tab parent page. For pages that are not local tasks, this will be the same as the path.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'title' => array(
- 'description' => 'The title for the current page, or the title for the tab if this is a local task.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'title_callback' => array(
- 'description' => 'A function which will alter the title. Defaults to t()',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'title_arguments' => array(
- 'description' => 'A serialized array of arguments for the title callback. If empty, the title will be used as the sole argument for the title callback.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'theme_callback' => array(
- 'description' => 'A function which returns the name of the theme that will be used to render this page. If left empty, the default theme will be used.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'theme_arguments' => array(
- 'description' => 'A serialized array of arguments for the theme callback.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'type' => array(
- 'description' => 'Numeric representation of the type of the menu item, like MENU_LOCAL_TASK.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'description' => array(
- 'description' => 'A description of this item.',
- 'type' => 'text',
- 'not null' => TRUE,
- ),
- 'position' => array(
- 'description' => 'The position of the block (left or right) on the system administration page for this item.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'weight' => array(
- 'description' => 'Weight of the element. Lighter weights are higher up, heavier weights go down.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'include_file' => array(
- 'description' => 'The file to include for this element, usually the page callback function lives in this file.',
- 'type' => 'text',
- 'size' => 'medium',
- ),
- ),
- 'indexes' => array(
- 'fit' => array('fit'),
- 'tab_parent' => array(array('tab_parent', 64), 'weight', 'title'),
- 'tab_root_weight_title' => array(array('tab_root', 64), 'weight', 'title'),
- ),
- 'primary key' => array('path'),
- );
- $schema['menu_links'] = array(
- 'description' => 'Contains the individual links within a menu.',
- 'fields' => array(
- 'menu_name' => array(
- 'description' => "The menu name. All links with the same menu name (such as 'navigation') are part of the same menu.",
- 'type' => 'varchar',
- 'length' => 32,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'mlid' => array(
- 'description' => 'The menu link ID (mlid) is the integer primary key.',
- 'type' => 'serial',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'plid' => array(
- 'description' => 'The parent link ID (plid) is the mlid of the link above in the hierarchy, or zero if the link is at the top level in its menu.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'link_path' => array(
- 'description' => 'The Drupal path or external path this link points to.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'router_path' => array(
- 'description' => 'For links corresponding to a Drupal path (external = 0), this connects the link to a {menu_router}.path for joins.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'link_title' => array(
- 'description' => 'The text displayed for the link, which may be modified by a title callback stored in {menu_router}.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- 'translatable' => TRUE,
- ),
- 'options' => array(
- 'description' => 'A serialized array of options to be passed to the url() or l() function, such as a query string or HTML attributes.',
- 'type' => 'blob',
- 'not null' => FALSE,
- 'translatable' => TRUE,
- ),
- 'module' => array(
- 'description' => 'The name of the module that generated this link.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => 'system',
- ),
- 'hidden' => array(
- 'description' => 'A flag for whether the link should be rendered in menus. (1 = a disabled menu item that may be shown on admin screens, -1 = a menu callback, 0 = a normal, visible link)',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'size' => 'small',
- ),
- 'external' => array(
- 'description' => 'A flag to indicate if the link points to a full URL starting with a protocol, like http:// (1 = external, 0 = internal).',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'size' => 'small',
- ),
- 'has_children' => array(
- 'description' => 'Flag indicating whether any links have this link as a parent (1 = children exist, 0 = no children).',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'size' => 'small',
- ),
- 'expanded' => array(
- 'description' => 'Flag for whether this link should be rendered as expanded in menus - expanded links always have their child links displayed, instead of only when the link is in the active trail (1 = expanded, 0 = not expanded)',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'size' => 'small',
- ),
- 'weight' => array(
- 'description' => 'Link weight among links in the same menu at the same depth.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'depth' => array(
- 'description' => 'The depth relative to the top level. A link with plid == 0 will have depth == 1.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'size' => 'small',
- ),
- 'customized' => array(
- 'description' => 'A flag to indicate that the user has manually created or edited the link (1 = customized, 0 = not customized).',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'size' => 'small',
- ),
- 'p1' => array(
- 'description' => 'The first mlid in the materialized path. If N = depth, then pN must equal the mlid. If depth > 1 then p(N-1) must equal the plid. All pX where X > depth must equal zero. The columns p1 .. p9 are also called the parents.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'p2' => array(
- 'description' => 'The second mlid in the materialized path. See p1.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'p3' => array(
- 'description' => 'The third mlid in the materialized path. See p1.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'p4' => array(
- 'description' => 'The fourth mlid in the materialized path. See p1.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'p5' => array(
- 'description' => 'The fifth mlid in the materialized path. See p1.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'p6' => array(
- 'description' => 'The sixth mlid in the materialized path. See p1.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'p7' => array(
- 'description' => 'The seventh mlid in the materialized path. See p1.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'p8' => array(
- 'description' => 'The eighth mlid in the materialized path. See p1.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'p9' => array(
- 'description' => 'The ninth mlid in the materialized path. See p1.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'updated' => array(
- 'description' => 'Flag that indicates that this link was generated during the update from Drupal 5.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'size' => 'small',
- ),
- ),
- 'indexes' => array(
- 'path_menu' => array(array('link_path', 128), 'menu_name'),
- 'menu_plid_expand_child' => array('menu_name', 'plid', 'expanded', 'has_children'),
- 'menu_parents' => array('menu_name', 'p1', 'p2', 'p3', 'p4', 'p5', 'p6', 'p7', 'p8', 'p9'),
- 'router_path' => array(array('router_path', 128)),
- ),
- 'primary key' => array('mlid'),
- );
- $schema['queue'] = array(
- 'description' => 'Stores items in queues.',
- 'fields' => array(
- 'item_id' => array(
- 'type' => 'serial',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'description' => 'Primary Key: Unique item ID.',
- ),
- 'name' => array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- 'description' => 'The queue name.',
- ),
- 'data' => array(
- 'type' => 'blob',
- 'not null' => FALSE,
- 'size' => 'big',
- 'serialize' => TRUE,
- 'description' => 'The arbitrary data for the item.',
- ),
- 'expire' => array(
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'description' => 'Timestamp when the claim lease expires on the item.',
- ),
- 'created' => array(
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'description' => 'Timestamp when the item was created.',
- ),
- ),
- 'primary key' => array('item_id'),
- 'indexes' => array(
- 'name_created' => array('name', 'created'),
- 'expire' => array('expire'),
- ),
- );
- $schema['registry'] = array(
- 'description' => "Each record is a function, class, or interface name and the file it is in.",
- 'fields' => array(
- 'name' => array(
- 'description' => 'The name of the function, class, or interface.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'type' => array(
- 'description' => 'Either function or class or interface.',
- 'type' => 'varchar',
- 'length' => 9,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'filename' => array(
- 'description' => 'Name of the file.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- ),
- 'module' => array(
- 'description' => 'Name of the module the file belongs to.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => ''
- ),
- 'weight' => array(
- 'description' => "The order in which this module's hooks should be invoked relative to other modules. Equal-weighted modules are ordered by name.",
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- ),
- 'primary key' => array('name', 'type'),
- 'indexes' => array(
- 'hook' => array('type', 'weight', 'module'),
- ),
- );
- $schema['registry_file'] = array(
- 'description' => "Files parsed to build the registry.",
- 'fields' => array(
- 'filename' => array(
- 'description' => 'Path to the file.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- ),
- 'hash' => array(
- 'description' => "sha-256 hash of the file's contents when last parsed.",
- 'type' => 'varchar',
- 'length' => 64,
- 'not null' => TRUE,
- ),
- ),
- 'primary key' => array('filename'),
- );
- $schema['semaphore'] = array(
- 'description' => 'Table for holding semaphores, locks, flags, etc. that cannot be stored as Drupal variables since they must not be cached.',
- 'fields' => array(
- 'name' => array(
- 'description' => 'Primary Key: Unique name.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => ''
- ),
- 'value' => array(
- 'description' => 'A value for the semaphore.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => ''
- ),
- 'expire' => array(
- 'description' => 'A Unix timestamp with microseconds indicating when the semaphore should expire.',
- 'type' => 'float',
- 'size' => 'big',
- 'not null' => TRUE
- ),
- ),
- 'indexes' => array(
- 'value' => array('value'),
- 'expire' => array('expire'),
- ),
- 'primary key' => array('name'),
- );
- $schema['sequences'] = array(
- 'description' => 'Stores IDs.',
- 'fields' => array(
- 'value' => array(
- 'description' => 'The value of the sequence.',
- 'type' => 'serial',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- ),
- 'primary key' => array('value'),
- );
- $schema['sessions'] = array(
- 'description' => "Drupal's session handlers read and write into the sessions table. Each record represents a user session, either anonymous or authenticated.",
- 'fields' => array(
- 'uid' => array(
- 'description' => 'The {users}.uid corresponding to a session, or 0 for anonymous user.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'sid' => array(
- 'description' => "A session ID. The value is generated by Drupal's session handlers.",
- 'type' => 'varchar',
- 'length' => 128,
- 'not null' => TRUE,
- ),
- 'ssid' => array(
- 'description' => "Secure session ID. The value is generated by Drupal's session handlers.",
- 'type' => 'varchar',
- 'length' => 128,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'hostname' => array(
- 'description' => 'The IP address that last used this session ID (sid).',
- 'type' => 'varchar',
- 'length' => 128,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'timestamp' => array(
- 'description' => 'The Unix timestamp when this session last requested a page. Old records are purged by PHP automatically.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'cache' => array(
- 'description' => "The time of this user's last post. This is used when the site has specified a minimum_cache_lifetime. See cache_get().",
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'session' => array(
- 'description' => 'The serialized contents of $_SESSION, an array of name/value pairs that persists across page requests by this session ID. Drupal loads $_SESSION from here at the start of each request and saves it at the end.',
- 'type' => 'blob',
- 'not null' => FALSE,
- 'size' => 'big',
- ),
- ),
- 'primary key' => array(
- 'sid',
- 'ssid',
- ),
- 'indexes' => array(
- 'timestamp' => array('timestamp'),
- 'uid' => array('uid'),
- 'ssid' => array('ssid'),
- ),
- 'foreign keys' => array(
- 'session_user' => array(
- 'table' => 'users',
- 'columns' => array('uid' => 'uid'),
- ),
- ),
- );
- $schema['system'] = array(
- 'description' => "A list of all modules, themes, and theme engines that are or have been installed in Drupal's file system.",
- 'fields' => array(
- 'filename' => array(
- 'description' => 'The path of the primary file for this item, relative to the Drupal root; e.g. modules/node/node.module.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'name' => array(
- 'description' => 'The name of the item; e.g. node.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'type' => array(
- 'description' => 'The type of the item, either module, theme, or theme_engine.',
- 'type' => 'varchar',
- 'length' => 12,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'owner' => array(
- 'description' => "A theme's 'parent' . Can be either a theme or an engine.",
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'status' => array(
- 'description' => 'Boolean indicating whether or not this item is enabled.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'bootstrap' => array(
- 'description' => "Boolean indicating whether this module is loaded during Drupal's early bootstrapping phase (e.g. even before the page cache is consulted).",
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'schema_version' => array(
- 'description' => "The module's database schema version number. -1 if the module is not installed (its tables do not exist); 0 or the largest N of the module's hook_update_N() function that has either been run or existed when the module was first installed.",
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => -1,
- 'size' => 'small',
- ),
- 'weight' => array(
- 'description' => "The order in which this module's hooks should be invoked relative to other modules. Equal-weighted modules are ordered by name.",
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'info' => array(
- 'description' => "A serialized array containing information from the module's .info file; keys can include name, description, package, version, core, dependencies, and php.",
- 'type' => 'blob',
- 'not null' => FALSE,
- ),
- ),
- 'primary key' => array('filename'),
- 'indexes' => array(
- 'system_list' => array('status', 'bootstrap', 'type', 'weight', 'name'),
- 'type_name' => array('type', 'name'),
- ),
- );
- $schema['url_alias'] = array(
- 'description' => 'A list of URL aliases for Drupal paths; a user may visit either the source or destination path.',
- 'fields' => array(
- 'pid' => array(
- 'description' => 'A unique path alias identifier.',
- 'type' => 'serial',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'source' => array(
- 'description' => 'The Drupal path this alias is for; e.g. node/12.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'alias' => array(
- 'description' => 'The alias for this path; e.g. title-of-the-story.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'language' => array(
- 'description' => "The language this alias is for; if 'und', the alias will be used for unknown languages. Each Drupal path can have an alias for each supported language.",
- 'type' => 'varchar',
- 'length' => 12,
- 'not null' => TRUE,
- 'default' => '',
- ),
- ),
- 'primary key' => array('pid'),
- 'indexes' => array(
- 'alias_language_pid' => array('alias', 'language', 'pid'),
- 'source_language_pid' => array('source', 'language', 'pid'),
- ),
- );
- return $schema;
- }
- function system_schema_cache_7054() {
- return array(
- 'description' => 'Generic cache table for caching things not separated out into their own tables. Contributed modules may also use this to store cached items.',
- 'fields' => array(
- 'cid' => array(
- 'description' => 'Primary Key: Unique cache ID.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'data' => array(
- 'description' => 'A collection of data to cache.',
- 'type' => 'blob',
- 'not null' => FALSE,
- 'size' => 'big',
- ),
- 'expire' => array(
- 'description' => 'A Unix timestamp indicating when the cache entry should expire, or 0 for never.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'created' => array(
- 'description' => 'A Unix timestamp indicating when the cache entry was created.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'serialized' => array(
- 'description' => 'A flag to indicate whether content is serialized (1) or not (0).',
- 'type' => 'int',
- 'size' => 'small',
- 'not null' => TRUE,
- 'default' => 0,
- ),
- ),
- 'indexes' => array(
- 'expire' => array('expire'),
- ),
- 'primary key' => array('cid'),
- );
- }
- function system_update_last_removed() {
- return 6055;
- }
- function system_update_dependencies() {
-
-
- $dependencies['system'][7053] = array(
- 'block' => 7002,
- );
-
-
- $dependencies['system'][7061] = array(
- 'node' => 7001,
- );
-
-
-
- $dependencies['system'][7067] = array(
- 'user' => 7007,
- );
- return $dependencies;
- }
- function system_update_7000() {
- $result = db_query("SELECT rid, perm FROM {permission} ORDER BY rid");
- foreach ($result as $role) {
- $renamed_permission = $role->perm;
- $renamed_permission = preg_replace('/(?<=^|,\ )create\ blog\ entries(?=,|$)/', 'create blog content', $renamed_permission);
- $renamed_permission = preg_replace('/(?<=^|,\ )edit\ own\ blog\ entries(?=,|$)/', 'edit own blog content', $renamed_permission);
- $renamed_permission = preg_replace('/(?<=^|,\ )edit\ any\ blog\ entry(?=,|$)/', 'edit any blog content', $renamed_permission);
- $renamed_permission = preg_replace('/(?<=^|,\ )delete\ own\ blog\ entries(?=,|$)/', 'delete own blog content', $renamed_permission);
- $renamed_permission = preg_replace('/(?<=^|,\ )delete\ any\ blog\ entry(?=,|$)/', 'delete any blog content', $renamed_permission);
- $renamed_permission = preg_replace('/(?<=^|,\ )create\ forum\ topics(?=,|$)/', 'create forum content', $renamed_permission);
- $renamed_permission = preg_replace('/(?<=^|,\ )delete\ any\ forum\ topic(?=,|$)/', 'delete any forum content', $renamed_permission);
- $renamed_permission = preg_replace('/(?<=^|,\ )delete\ own\ forum\ topics(?=,|$)/', 'delete own forum content', $renamed_permission);
- $renamed_permission = preg_replace('/(?<=^|,\ )edit\ any\ forum\ topic(?=,|$)/', 'edit any forum content', $renamed_permission);
- $renamed_permission = preg_replace('/(?<=^|,\ )edit\ own\ forum\ topics(?=,|$)/', 'edit own forum content', $renamed_permission);
- if ($renamed_permission != $role->perm) {
- db_update('permission')
- ->fields(array('perm' => $renamed_permission))
- ->condition('rid', $role->rid)
- ->execute();
- }
- }
- }
- function system_update_7001() {
- variable_set('cron_key', drupal_random_key());
- }
- function system_update_7002() {
- $schema['blocked_ips'] = array(
- 'description' => 'Stores blocked IP addresses.',
- 'fields' => array(
- 'iid' => array(
- 'description' => 'Primary Key: unique ID for IP addresses.',
- 'type' => 'serial',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'ip' => array(
- 'description' => 'IP address',
- 'type' => 'varchar',
- 'length' => 32,
- 'not null' => TRUE,
- 'default' => '',
- ),
- ),
- 'indexes' => array(
- 'blocked_ip' => array('ip'),
- ),
- 'primary key' => array('iid'),
- );
- db_create_table('blocked_ips', $schema['blocked_ips']);
- }
- function system_update_7003() {
- $messages = array();
- $type = 'host';
- $result = db_query("SELECT mask FROM {access} WHERE status = :status AND type = :type", array(
- ':status' => 0,
- ':type' => $type,
- ));
- foreach ($result as $blocked) {
- if (filter_var($blocked->mask, FILTER_VALIDATE_IP, FILTER_FLAG_NO_RES_RANGE) !== FALSE) {
- db_insert('blocked_ips')
- ->fields(array('ip' => $blocked->mask))
- ->execute();
- }
- else {
- $invalid_host = check_plain($blocked->mask);
- $messages[] = t('The host !host is no longer blocked because it is not a valid IP address.', array('!host' => $invalid_host ));
- }
- }
- if (isset($invalid_host)) {
- drupal_set_message('Drupal no longer supports wildcard IP address blocking. Visitors whose IP addresses match ranges you have previously set using <em>access rules</em> will no longer be blocked from your site when you put the site online. See the <a href="http://drupal.org/node/24302">IP address and referrer blocking Handbook page</a> for alternative methods.', 'warning');
- }
-
- if (!empty($result)) {
- $result = db_query("SELECT mask FROM {access} WHERE status = :status AND type = :type", array(
- ':status' => 1,
- ':type' => $type,
- ));
- $or = db_condition('or');
- foreach ($result as $allowed) {
- $or->condition('ip', $allowed->mask, 'LIKE');
- }
- if (count($or)) {
- db_delete('blocked_ips')
- ->condition($or)
- ->execute();
- }
- }
- }
- function system_update_7004(&$sandbox) {
-
- $renamed_deltas = array(
- 'blog' => array('0' => 'recent'),
- 'book' => array('0' => 'navigation'),
- 'comment' => array('0' => 'recent'),
- 'forum' => array(
- '0' => 'active',
- '1' => 'new',
- ),
- 'locale' => array('0' => LANGUAGE_TYPE_INTERFACE),
- 'node' => array('0' => 'syndicate'),
- 'poll' => array('0' => 'recent'),
- 'profile' => array('0' => 'author-information'),
- 'search' => array('0' => 'form'),
- 'statistics' => array('0' => 'popular'),
- 'system' => array('0' => 'powered-by'),
- 'user' => array(
- '0' => 'login',
- '1' => 'navigation',
- '2' => 'new',
- '3' => 'online',
- ),
- );
- $moved_deltas = array(
- 'user' => array('navigation' => 'system'),
- );
-
- if (!isset($sandbox['progress'])) {
-
- $forum_block_num_0 = variable_get('forum_block_num_0');
- if (isset($forum_block_num_0)) {
- variable_set('forum_block_num_active', $forum_block_num_0);
- variable_del('forum_block_num_0');
- }
- $forum_block_num_1 = variable_get('forum_block_num_1');
- if (isset($forum_block_num_1)) {
- variable_set('forum_block_num_new', $forum_block_num_1);
- variable_del('forum_block_num_1');
- }
- }
- update_fix_d7_block_deltas($sandbox, $renamed_deltas, $moved_deltas);
- }
- function system_update_7005() {
- db_drop_field('blocks', 'throttle');
- db_drop_field('system', 'throttle');
- variable_del('throttle_user');
- variable_del('throttle_anonymous');
- variable_del('throttle_level');
- variable_del('throttle_probability_limiter');
- }
- function system_update_7007() {
-
- $messages = array();
- $result = db_query("SELECT rid, perm FROM {permission} ORDER BY rid ASC");
- $query = db_insert('role_permission')->fields(array('rid', 'permission'));
- foreach ($result as $role) {
- foreach (array_unique(explode(', ', $role->perm)) as $perm) {
- $query->values(array(
- 'rid' => $role->rid,
- 'permission' => $perm,
- ));
- }
- $messages[] = t('Inserted into {role_permission} the permissions for role ID !id', array('!id' => $role->rid));
- }
- $query->execute();
- db_drop_table('permission');
- return implode(', ', $messages);
- }
- function system_update_7009() {
- $current_primary = variable_get('menu_primary_links_source');
- if (isset($current_primary)) {
- variable_set('menu_main_links_source', $current_primary);
- variable_del('menu_primary_links_source');
- }
- }
- function system_update_7011() {
-
- $rids = array();
- $rids = db_query("SELECT rid FROM {role_permission} WHERE permission = :perm", array(':perm' => 'administer nodes'))->fetchCol();
-
- if (empty($rids)) {
- return;
- }
- $insert = db_insert('role_permission')->fields(array('rid', 'permission'));
- foreach ($rids as $rid) {
- $insert->values(array(
- 'rid' => $rid,
- 'permission' => 'bypass node access',
- ));
- }
- $insert->execute();
- }
- function system_update_7013() {
- $timezone = NULL;
- $timezones = system_time_zones();
-
-
- if (($timezone_name = variable_get('date_default_timezone_name')) && isset($timezones[$timezone_name])) {
- $timezone = $timezone_name;
- }
-
-
- if (!$timezone && ($timezone_id = variable_get('date_default_timezone_id', 0))) {
- try {
- $timezone_name = db_query('SELECT name FROM {event_timezones} WHERE timezone = :timezone_id', array(':timezone_id' => $timezone_id))->fetchField();
- if (($timezone_name = str_replace(' ', '_', $timezone_name)) && isset($timezones[$timezone_name])) {
- $timezone = $timezone_name;
- }
- }
- catch (PDOException $e) {
-
-
- }
- }
-
- $offset = variable_get('date_temporary_timezone');
-
- if (!isset($offset)) {
- $offset = variable_get('date_default_timezone', 0);
- }
-
-
-
- if (!$timezone && $offset) {
- $timezone_name = timezone_name_from_abbr('', intval($offset), date('I'));
- if ($timezone_name && isset($timezones[$timezone_name])) {
- $timezone = $timezone_name;
- }
- }
-
- if (!$timezone) {
- $timezone = 'UTC';
- }
- variable_set('date_default_timezone', $timezone);
- drupal_set_message(format_string('The default time zone has been set to %timezone. Check the <a href="@config-url">date and time configuration page</a> to configure it correctly.', array('%timezone' => $timezone, '@config-url' => url('admin/config/regional/settings'))), 'warning');
-
- variable_del('date_temporary_timezone');
- }
- function system_update_7015() {
- db_update('menu_links')
- ->fields(array('link_path' => 'user/logout'))
- ->condition('link_path', 'logout')
- ->execute();
- db_update('menu_links')
- ->fields(array('router_path' => 'user/logout'))
- ->condition('router_path', 'logout')
- ->execute();
- db_update('menu_links')
- ->fields(array(
- 'menu_name' => 'user-menu',
- 'plid' => 0,
- ))
- ->condition(db_or()
- ->condition('link_path', 'user/logout')
- ->condition('router_path', 'user/logout')
- )
- ->condition('module', 'system')
- ->condition('customized', 0)
- ->execute();
- }
- function system_update_7016() {
-
- if (db_driver() == 'pgsql') {
- $result = db_query("SELECT c.relname AS table, a.attname AS field,
- pg_catalog.format_type(a.atttypid, a.atttypmod) AS type
- FROM pg_catalog.pg_attribute a
- LEFT JOIN pg_class c ON (c.oid = a.attrelid)
- WHERE pg_catalog.pg_table_is_visible(c.oid) AND c.relkind = 'r'
- AND pg_catalog.format_type(a.atttypid, a.atttypmod) LIKE '%unsigned%'");
- foreach ($result as $row) {
- switch ($row->type) {
- case 'smallint_unsigned':
- $datatype = 'int';
- break;
- case 'int_unsigned':
- case 'bigint_unsigned':
- default:
- $datatype = 'bigint';
- break;
- }
- db_query('ALTER TABLE ' . $row->table . ' ALTER COLUMN "' . $row->field . '" TYPE ' . $datatype);
- db_query('ALTER TABLE ' . $row->table . ' ADD CHECK ("' . $row->field . '" >= 0)');
- }
- db_query('DROP DOMAIN IF EXISTS smallint_unsigned');
- db_query('DROP DOMAIN IF EXISTS int_unsigned');
- db_query('DROP DOMAIN IF EXISTS bigint_unsigned');
- }
- }
- function system_update_7017() {
-
- $settings = variable_get('theme_settings', array());
-
- $settings = array_merge($settings, variable_get('theme_' . variable_get('theme_default', 'garland') . '_settings', array()));
- $types = _update_7000_node_get_types();
- foreach ($types as $type) {
- if (isset($settings['toggle_node_info_' . $type->type])) {
- variable_set('node_submitted_' . $type->type, $settings['toggle_node_info_' . $type->type]);
- }
- }
-
- $theme_settings = variable_get('theme_settings', array());
- foreach ($theme_settings as $setting => $value) {
- if (substr($setting, 0, 16) == 'toggle_node_info') {
- unset($theme_settings[$setting]);
- }
- }
- variable_set('theme_settings', $theme_settings);
- }
- function system_update_7018() {
- db_drop_index('system', 'modules');
- db_drop_index('system', 'type_name');
- db_change_field('system', 'type', 'type', array('type' => 'varchar', 'length' => 12, 'not null' => TRUE, 'default' => ''));
- db_add_index('system', 'type_name', array('type', 'name'));
- }
- function system_update_7020() {
- $module_list = array('field_sql_storage', 'field', 'field_ui');
- module_enable($module_list, FALSE);
- }
- function system_update_7021() {
- db_update('role_permission')
- ->fields(array('permission' => 'use PHP for settings'))
- ->condition('permission', 'use PHP for block visibility')
- ->execute();
- }
- function system_update_7027() {
- $module_list = array('text', 'number', 'list', 'options');
- module_enable($module_list, FALSE);
- }
- function system_update_7029() {
- db_insert('role_permission')
- ->fields(array(
- 'rid' => DRUPAL_AUTHENTICATED_RID,
- 'permission' => 'view own unpublished content',
- ))
- ->execute();
- }
- function system_update_7032() {
- db_drop_index('flood', 'allow');
- db_change_field('flood', 'hostname', 'identifier', array('type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => ''));
- db_add_index('flood', 'allow', array('event', 'identifier', 'timestamp'));
- }
- function system_update_7033() {
- if (variable_get('cache') == 2) {
- variable_set('cache', 1);
- return t('Aggressive caching was disabled and replaced with normal caching. Read the page caching section in default.settings.php for more information on how to enable similar functionality.');
- }
- }
- function system_update_7034() {
- $files_directory = variable_get('file_directory_path', NULL);
- if (variable_get('file_downloads', 1) == 1) {
-
- if (!empty($files_directory)) {
- variable_set('file_public_path', $files_directory);
- }
- }
- elseif (variable_get('file_downloads', 1) == 2) {
- variable_set('file_default_scheme', 'private');
- if (!empty($files_directory)) {
- variable_set('file_private_path', $files_directory);
- }
- }
- variable_del('file_downloads');
- $schema['file_managed'] = array(
- 'description' => 'Stores information for uploaded files.',
- 'fields' => array(
- 'fid' => array(
- 'description' => 'File ID.',
- 'type' => 'serial',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'uid' => array(
- 'description' => 'The {user}.uid of the user who is associated with the file.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'filename' => array(
- 'description' => 'Name of the file with no path components. This may differ from the basename of the filepath if the file is renamed to avoid overwriting an existing file.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- 'binary' => TRUE,
- ),
- 'uri' => array(
- 'description' => 'URI of file.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- 'binary' => TRUE,
- ),
- 'filemime' => array(
- 'description' => "The file's MIME type.",
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'filesize' => array(
- 'description' => 'The size of the file in bytes.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'status' => array(
- 'description' => 'A field indicating the status of the file. Two status are defined in core: temporary (0) and permanent (1). Temporary files older than DRUPAL_MAXIMUM_TEMP_FILE_AGE will be removed during a cron run.',
- 'type' => 'int',
- 'not null' => TRUE,
- 'default' => 0,
- 'size' => 'tiny',
- ),
- 'timestamp' => array(
- 'description' => 'UNIX timestamp for when the file was added.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- ),
- 'indexes' => array(
- 'uid' => array('uid'),
- 'status' => array('status'),
- 'timestamp' => array('timestamp'),
- ),
- 'unique keys' => array(
- 'uri' => array('uri'),
- ),
- 'primary key' => array('fid'),
- );
- db_create_table('file_managed', $schema['file_managed']);
- }
- function system_update_7036() {
-
- $rids = db_query("SELECT rid FROM {role_permission} WHERE permission = :perm", array(':perm' => 'administer site configuration'))->fetchCol();
-
- if (empty($rids)) {
- return;
- }
- $insert = db_insert('role_permission')->fields(array('rid', 'permission'));
- foreach ($rids as $rid) {
- $insert->values(array(
- 'rid' => $rid,
- 'permission' => 'access site in maintenance mode',
- ));
- }
- $insert->execute();
- }
- function system_update_7042() {
-
-
-
- db_drop_field('url_alias', 'source');
- db_drop_field('url_alias', 'alias');
-
- db_drop_index('url_alias', 'src_language_pid');
- db_drop_unique_key('url_alias', 'dst_language_pid');
-
- db_change_field('url_alias', 'src', 'source', array('type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => ''));
- db_change_field('url_alias', 'dst', 'alias', array('type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => ''));
-
-
- db_add_index('url_alias', 'source_language_pid', array('source', 'language', 'pid'));
- db_add_index('url_alias', 'alias_language_pid', array('alias', 'language', 'pid'));
-
- drupal_path_alias_whitelist_rebuild();
- }
- function system_update_7044() {
-
-
- db_drop_table('actions_aid');
- }
- function system_update_7045() {
- db_add_field('flood', 'expiration', array('description' => 'Expiration timestamp. Expired events are purged on cron run.', 'type' => 'int', 'not null' => TRUE, 'default' => 0));
- db_add_index('flood', 'purge', array('expiration'));
- }
- function system_update_7046() {
- if (variable_get('theme_default') == 'minnelli' || variable_get('admin_theme') == 'minnelli') {
-
- db_update('system')
- ->fields(array('status' => 1))
- ->condition('type', 'theme')
- ->condition('name', 'garland')
- ->execute();
- if (variable_get('theme_default') != 'garland') {
-
-
- $settings = variable_get('theme_minnelli_settings', array());
-
- $settings['garland_width'] = 'fixed';
- variable_set('theme_garland_settings', $settings);
-
- foreach (variable_get('color_garland_files', array()) as $file) {
- @drupal_unlink($file);
- }
- if (isset($file) && $file = dirname($file)) {
- @drupal_rmdir($file);
- }
- variable_del('color_garland_palette');
- variable_del('color_garland_stylesheets');
- variable_del('color_garland_logo');
- variable_del('color_garland_files');
- variable_del('color_garland_screenshot');
- }
- if (variable_get('theme_default') == 'minnelli') {
- variable_set('theme_default', 'garland');
- }
- if (variable_get('admin_theme') == 'minnelli') {
- variable_set('admin_theme', 'garland');
- }
- }
- }
- function system_update_7047() {
- variable_set('site_frontpage', drupal_get_normal_path(variable_get('site_frontpage', 'node')));
- }
- function system_update_7048() {
- db_update('url_alias')
- ->fields(array('language' => LANGUAGE_NONE))
- ->condition('language', '')
- ->execute();
- }
- function system_update_7049() {
- if (variable_get('install_profile', 'standard') == 'default') {
- variable_set('install_profile', 'standard');
- }
- }
- function system_update_7050() {
- db_change_field('batch', 'bid', 'bid', array('description' => 'Primary Key: Unique batch ID.', 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE));
- }
- function system_update_7051() {
- db_change_field('blocked_ips', 'ip', 'ip', array('description' => 'IP address', 'type' => 'varchar', 'length' => 40, 'not null' => TRUE, 'default' => ''));
- }
- function system_update_7052() {
- db_change_field('menu_router', 'file', 'include_file', array('type' => 'text', 'size' => 'medium'));
- }
- function system_update_7053() {
- if (db_table_exists('menu_custom')) {
-
- db_insert('menu_custom')
- ->fields(array('menu_name' => 'user-menu', 'title' => 'User Menu', 'description' => "The <em>User</em> menu contains links related to the user's account, as well as the 'Log out' link."))
- ->execute();
- db_insert('menu_custom')
- ->fields(array('menu_name' => 'management', 'title' => 'Management', 'description' => "The <em>Management</em> menu contains links for administrative tasks."))
- ->execute();
- }
- block_flush_caches();
-
- $blocks = db_query("SELECT theme, status, region, weight, visibility, pages FROM {block} WHERE module = 'system' AND delta = 'navigation'");
- $deltas = db_or()
- ->condition('delta', 'user-menu')
- ->condition('delta', 'management');
- foreach ($blocks as $block) {
- db_update('block')
- ->fields(array(
- 'status' => $block->status,
- 'region' => $block->region,
- 'weight' => $block->weight,
- 'visibility' => $block->visibility,
- 'pages' => $block->pages,
- ))
- ->condition('theme', $block->theme)
- ->condition('module', 'system')
- ->condition($deltas)
- ->execute();
- }
- }
- function system_update_7054() {
-
-
-
- $cache_tables = array(
- 'cache' => 'Generic cache table for caching things not separated out into their own tables. Contributed modules may also use this to store cached items.',
- 'cache_form' => 'Cache table for the form system to store recently built forms and their storage data, to be used in subsequent page requests.',
- 'cache_page' => 'Cache table used to store compressed pages for anonymous users, if page caching is enabled.',
- 'cache_menu' => 'Cache table for the menu system to store router information as well as generated link trees for various menu/page/user combinations.',
- );
- $schema = system_schema_cache_7054();
- foreach ($cache_tables as $table => $description) {
- $schema['description'] = $description;
- db_drop_table($table);
- db_create_table($table, $schema);
- }
- }
- function system_update_7055() {
- $spec = array(
- 'description' => 'The value of the variable.',
- 'type' => 'blob',
- 'not null' => TRUE,
- 'size' => 'big',
- 'translatable' => TRUE,
- );
- db_change_field('variable', 'value', 'value', $spec);
- $spec = array(
- 'description' => 'Parameters to be passed to the callback function.',
- 'type' => 'blob',
- 'not null' => TRUE,
- 'size' => 'big',
- );
- db_change_field('actions', 'parameters', 'parameters', $spec);
- $spec = array(
- 'description' => 'A serialized array containing the processing data for the batch.',
- 'type' => 'blob',
- 'not null' => FALSE,
- 'size' => 'big',
- );
- db_change_field('batch', 'batch', 'batch', $spec);
- $spec = array(
- 'description' => 'A serialized array of function names (like node_load) to be called to load an object corresponding to a part of the current path.',
- 'type' => 'blob',
- 'not null' => TRUE,
- );
- db_change_field('menu_router', 'load_functions', 'load_functions', $spec);
- $spec = array(
- 'description' => 'A serialized array of function names (like user_uid_optional_to_arg) to be called to replace a part of the router path with another string.',
- 'type' => 'blob',
- 'not null' => TRUE,
- );
- db_change_field('menu_router', 'to_arg_functions', 'to_arg_functions', $spec);
- $spec = array(
- 'description' => 'A serialized array of arguments for the access callback.',
- 'type' => 'blob',
- 'not null' => FALSE,
- );
- db_change_field('menu_router', 'access_arguments', 'access_arguments', $spec);
- $spec = array(
- 'description' => 'A serialized array of arguments for the page callback.',
- 'type' => 'blob',
- 'not null' => FALSE,
- );
- db_change_field('menu_router', 'page_arguments', 'page_arguments', $spec);
- $spec = array(
- 'description' => 'A serialized array of options to be passed to the url() or l() function, such as a query string or HTML attributes.',
- 'type' => 'blob',
- 'not null' => FALSE,
- 'translatable' => TRUE,
- );
- db_change_field('menu_links', 'options', 'options', $spec);
- $spec = array(
- 'description' => 'The serialized contents of $_SESSION, an array of name/value pairs that persists across page requests by this session ID. Drupal loads $_SESSION from here at the start of each request and saves it at the end.',
- 'type' => 'blob',
- 'not null' => FALSE,
- 'size' => 'big',
- );
- db_change_field('sessions', 'session', 'session', $spec);
- $spec = array(
- 'description' => "A serialized array containing information from the module's .info file; keys can include name, description, package, version, core, dependencies, and php.",
- 'type' => 'blob',
- 'not null' => FALSE,
- );
- db_change_field('system', 'info', 'info', $spec);
- }
- function system_update_7057() {
- $spec = array(
- 'description' => "A session ID. The value is generated by PHP's Session API.",
- 'type' => 'varchar',
- 'length' => 128,
- 'not null' => TRUE,
- 'default' => '',
- );
- db_change_field('sessions', 'sid', 'sid', $spec);
- }
- function system_update_7058() {
- variable_del('cron_semaphore');
- }
- function system_update_7059() {
- $spec = array(
- 'description' => 'Track where a file is used.',
- 'fields' => array(
- 'fid' => array(
- 'description' => 'File ID.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- ),
- 'module' => array(
- 'description' => 'The name of the module that is using the file.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'type' => array(
- 'description' => 'The name of the object type in which the file is used.',
- 'type' => 'varchar',
- 'length' => 64,
- 'not null' => TRUE,
- 'default' => '',
- ),
- 'id' => array(
- 'description' => 'The primary key of the object using the file.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- 'count' => array(
- 'description' => 'The number of times this file is used by this object.',
- 'type' => 'int',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- ),
- ),
- 'primary key' => array('fid', 'type', 'id', 'module'),
- 'indexes' => array(
- 'type_id' => array('type', 'id'),
- 'fid_count' => array('fid', 'count'),
- 'fid_module' => array('fid', 'module'),
- ),
- );
- db_create_table('file_usage', $spec);
- }
- function system_update_7060() {
- if (!db_table_exists('upload')) {
- return;
- }
- if (!db_query_range('SELECT 1 FROM {upload}', 0, 1)->fetchField()) {
-
-
- foreach (_update_7000_node_get_types() as $node_type) {
- variable_del('upload_' . $node_type->type);
- }
- db_drop_table('upload');
- return;
- }
-
- $context['types'] = array();
- foreach (_update_7000_node_get_types() as $node_type) {
- if (variable_get('upload_' . $node_type->type, 0)) {
- $context['types'][$node_type->type] = $node_type->type;
- }
- }
-
-
-
-
-
- $results = db_query('SELECT DISTINCT type FROM {node} n INNER JOIN {node_revision} nr ON n.nid = nr.nid INNER JOIN {upload} u ON nr.vid = u.vid');
- foreach ($results as $row) {
- if (!isset($context['types'][$row->type])) {
- drupal_set_message(t('The content type %rowtype had uploads disabled but contained uploaded file data. Uploads have been re-enabled to migrate the existing data. You may delete the "File attachments" field in the %rowtype type if this data is not necessary.', array('%rowtype' => $row->type)));
- $context['types'][$row->type] = $row->type;
- }
- }
-
-
- if (count($context['types']) > 0) {
- module_enable(array('file'));
- $field = array(
- 'field_name' => 'upload',
- 'type' => 'file',
- 'module' => 'file',
- 'locked' => FALSE,
- 'cardinality' => FIELD_CARDINALITY_UNLIMITED,
- 'translatable' => FALSE,
- 'settings' => array(
- 'display_field' => 1,
- 'display_default' => variable_get('upload_list_default', 1),
- 'uri_scheme' => file_default_scheme(),
- 'default_file' => 0,
- ),
- );
- $upload_size = variable_get('upload_uploadsize_default', 1);
- $instance = array(
- 'field_name' => 'upload',
- 'entity_type' => 'node',
- 'bundle' => NULL,
- 'label' => 'File attachments',
- 'required' => 0,
- 'description' => '',
- 'widget' => array(
- 'weight' => '1',
- 'settings' => array(
- 'progress_indicator' => 'throbber',
- ),
- 'type' => 'file_generic',
- ),
- 'settings' => array(
- 'max_filesize' => $upload_size ? ($upload_size . ' MB') : '',
- 'file_extensions' => variable_get('upload_extensions_default', 'jpg jpeg gif png txt doc xls pdf ppt pps odt ods odp'),
- 'file_directory' => '',
- 'description_field' => 1,
- ),
- 'display' => array(
- 'default' => array(
- 'label' => 'hidden',
- 'type' => 'file_table',
- 'settings' => array(),
- 'weight' => 0,
- 'module' => 'file',
- ),
- 'full' => array(
- 'label' => 'hidden',
- 'type' => 'file_table',
- 'settings' => array(),
- 'weight' => 0,
- 'module' => 'file',
- ),
- 'teaser' => array(
- 'label' => 'hidden',
- 'type' => 'hidden',
- 'settings' => array(),
- 'weight' => 0,
- 'module' => NULL,
- ),
- 'rss' => array(
- 'label' => 'hidden',
- 'type' => 'file_table',
- 'settings' => array(),
- 'weight' => 0,
- 'module' => 'file',
- ),
- ),
- );
-
- _update_7000_field_create_field($field);
-
- foreach ($context['types'] as $bundle) {
- $instance['bundle'] = $bundle;
- _update_7000_field_create_instance($field, $instance);
-
-
- variable_del('upload_' . $bundle);
- }
- }
- else {
-
- db_drop_table('upload');
- }
- }
- function system_update_7061(&$sandbox) {
- if (!db_table_exists('upload')) {
- return;
- }
- if (!isset($sandbox['progress'])) {
-
- db_delete('upload')
- ->notExists(
- db_select('files', 'f')
- ->fields('f', array('fid'))
- ->where('f.fid = {upload}.fid')
- )
- ->execute();
-
-
-
- db_delete('upload')
- ->notExists(
- db_select('node_revision', 'nr')
- ->fields('nr', array('vid'))
- ->where('nr.vid = {upload}.vid')
- )
- ->execute();
-
-
-
- if (!db_table_exists('system_update_7061')) {
- $table = array(
- 'description' => t('Stores temporary data for system_update_7061.'),
- 'fields' => array('vid' => array('type' => 'int', 'not null' => TRUE)),
- 'primary key' => array('vid'),
- );
- db_create_table('system_update_7061', $table);
- }
- $query = db_select('upload', 'u');
- $query->distinct();
- $query->addField('u','vid');
- db_insert('system_update_7061')
- ->from($query)
- ->execute();
-
-
-
-
-
-
-
-
- $sandbox['duplicate_filepath_fids_to_use'] = db_query("SELECT filepath, MAX(fid) FROM {files} GROUP BY filepath HAVING COUNT(*) > 1")->fetchAllKeyed();
-
- $sandbox['progress'] = 0;
- $sandbox['last_vid_processed'] = -1;
- $sandbox['max'] = db_query("SELECT COUNT(*) FROM {system_update_7061}")->fetchField();
- }
-
-
- $limit = variable_get('upload_update_batch_size', 100);
- $vids = db_query_range('SELECT vid FROM {system_update_7061} WHERE vid > :lastvid ORDER BY vid', 0, $limit, array(':lastvid' => $sandbox['last_vid_processed']))
- ->fetchCol();
-
- if (!empty($vids)) {
- $node_revisions = array();
- $result = db_query('SELECT u.fid, u.vid, u.list, u.description, n.nid, n.type, u.weight FROM {upload} u INNER JOIN {node_revision} nr ON u.vid = nr.vid INNER JOIN {node} n ON n.nid = nr.nid WHERE u.vid IN (:vids) ORDER BY u.vid, u.weight, u.fid', array(':vids' => $vids));
- foreach ($result as $record) {
-
-
-
- $file = db_select('files', 'f')
- ->fields('f', array('fid', 'uid', 'filename', 'filepath', 'filemime', 'filesize', 'status', 'timestamp'))
- ->condition('f.fid', $record->fid)
- ->execute()
- ->fetchAssoc();
- if (!$file) {
- continue;
- }
-
-
- if (isset($sandbox['duplicate_filepath_fids_to_use'][$file['filepath']]) && $record->fid != $sandbox['duplicate_filepath_fids_to_use'][$file['filepath']]) {
- $file = db_select('files', 'f')
- ->fields('f', array('fid', 'uid', 'filename', 'filepath', 'filemime', 'filesize', 'status', 'timestamp'))
- ->condition('f.fid', $sandbox['duplicate_filepath_fids_to_use'][$file['filepath']])
- ->execute()
- ->fetchAssoc();
- }
-
- $file['description'] = $record->description;
- $file['display'] = $record->list;
-
-
- $node_revisions[$record->vid]['nid'] = $record->nid;
- $node_revisions[$record->vid]['vid'] = $record->vid;
- $node_revisions[$record->vid]['type'] = $record->type;
- $node_revisions[$record->vid]['file'][LANGUAGE_NONE][] = $file;
- }
-
-
-
- $basename = variable_get('file_directory_path', conf_path() . '/files');
- $scheme = file_default_scheme() . '://';
- foreach ($node_revisions as $vid => $revision) {
- foreach ($revision['file'][LANGUAGE_NONE] as $delta => $file) {
-
-
- $file['uri'] = $scheme . preg_replace('!^' . preg_quote($basename) . '!', '', $file['filepath']);
-
-
-
-
-
- if (($file_uri_scheme = file_uri_scheme($file['uri'])) && ($file_uri_target = file_uri_target($file['uri']))) {
- $file['uri'] = $file_uri_scheme . '://' . $file_uri_target;
- }
- unset($file['filepath']);
-
-
- db_merge('file_managed')
- ->key(array(
- 'fid' => $file['fid'],
- ))
- ->fields(array(
- 'uid' => $file['uid'],
- 'filename' => $file['filename'],
- 'uri' => $file['uri'],
- 'filemime' => $file['filemime'],
- 'filesize' => $file['filesize'],
- 'status' => $file['status'],
- 'timestamp' => $file['timestamp'],
- ))
- ->execute();
-
- $file = (object) $file;
- file_usage_add($file, 'file', 'node', $revision['nid']);
-
- $revision['file'][LANGUAGE_NONE][$delta] = array('fid' => $file->fid, 'display' => $file->display, 'description' => $file->description);
- }
-
- $node = (object) $revision;
- _update_7000_field_sql_storage_write('node', $node->type, $node->nid, $node->vid, 'upload', $node->file);
-
- $sandbox['progress']++;
- $sandbox['last_vid_processed'] = $vid;
- }
- }
-
-
- if (count($vids) < $limit) {
- $finished = TRUE;
- }
-
- if (empty($sandbox['max']) || isset($finished)) {
- db_drop_table('upload');
- db_drop_table('system_update_7061');
- return t('Upload module has been migrated to File module.');
- }
- else {
-
- $sandbox['#finished'] = $sandbox['progress'] / $sandbox['max'];
- }
- }
- function system_update_7062() {
- db_drop_index('system', 'bootstrap');
- db_drop_index('system', 'system_list');
- db_add_index('system', 'system_list', array('status', 'bootstrap', 'type', 'weight', 'name'));
- }
- function system_update_7063() {
-
-
-
- $result = db_query('SELECT ml.mlid FROM {menu_links} ml INNER JOIN {menu_router} mr ON ml.router_path = mr.path WHERE ml.module = :system AND ml.customized = 0 AND mr.type IN(:callbacks)', array(':callbacks' => array(0, 4), ':system' => 'system'));
- foreach ($result as $record) {
- db_delete('menu_links')->condition('mlid', $record->mlid)->execute();
- }
- }
- function system_update_7064() {
- db_drop_field('menu_router', 'block_callback');
- }
- function system_update_7065() {
- $spec = array(
- 'description' => "A session ID. The value is generated by Drupal's session handlers.",
- 'type' => 'varchar',
- 'length' => 128,
- 'not null' => TRUE,
- );
- db_drop_primary_key('sessions');
- db_change_field('sessions', 'sid', 'sid', $spec, array('primary key' => array('sid', 'ssid')));
-
- db_delete('sessions')->condition('sid', '')->execute();
- }
- function system_update_7066() {
- $d6_file_directory_temp = variable_get('file_directory_temp', file_directory_temp());
- variable_set('file_temporary_path', $d6_file_directory_temp);
- variable_del('file_directory_temp');
- }
- function system_update_7067() {
-
-
-
- $admin_roles = user_roles(FALSE, 'access administration pages');
- foreach (array_keys($admin_roles) as $rid) {
- _update_7000_user_role_grant_permissions($rid, array('view the administration theme'), 'system');
- }
-
-
-
- if (variable_get('admin_theme')) {
- if (empty($admin_roles)) {
- drupal_set_message('The new "View the administration theme" permission is required in order to view your site\'s administration theme. You can grant this permission to your site\'s administrators on the <a href="' . url('admin/people/permissions', array('fragment' => 'module-system')) . '">permissions page</a>.');
- }
- else {
- drupal_set_message('The new "View the administration theme" permission is required in order to view your site\'s administration theme. This permission has been automatically granted to the following roles: <em>' . check_plain(implode(', ', $admin_roles)) . '</em>. You can grant this permission to other roles on the <a href="' . url('admin/people/permissions', array('fragment' => 'module-system')) . '">permissions page</a>.');
- }
- }
- }
- function system_update_7068() {
- $spec = array(
- 'description' => "The language this alias is for; if 'und', the alias will be used for unknown languages. Each Drupal path can have an alias for each supported language.",
- 'type' => 'varchar',
- 'length' => 12,
- 'not null' => TRUE,
- 'default' => '',
- );
- db_change_field('url_alias', 'language', 'language', $spec);
- }
- function system_update_7069() {
- variable_del('site_offline');
- }
- function system_update_7070() {
- variable_del('drupal_badge_color');
- variable_del('drupal_badge_size');
- }
- function system_update_7071() {
- db_drop_index('date_format_type', 'title');
- db_add_index('date_format_type', 'title', array('title'));
- db_change_field('registry', 'filename', 'filename', array(
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- ));
- }
- function system_update_7072() {
- variable_del('site_offline_message');
- }
- function system_update_7073() {
- db_change_field('file_managed', 'filename', 'filename', array(
- 'description' => 'Name of the file with no path components. This may differ from the basename of the URI if the file is renamed to avoid overwriting an existing file.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- 'binary' => TRUE,
- ));
- db_drop_unique_key('file_managed', 'uri');
- db_change_field('file_managed', 'uri', 'uri', array(
- 'description' => 'The URI to access the file (either local or remote).',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- 'binary' => TRUE,
- ));
- db_add_unique_key('file_managed', 'uri', array('uri'));
- }
- function system_update_7074() {
-
-
-
- }
- function system_update_7076() {
- $query = db_select('menu_links', 'ml', array('fetch' => PDO::FETCH_ASSOC))
- ->fields('ml', array('mlid', 'options'));
- foreach ($query->execute() as $menu_link) {
- if (strpos($menu_link['options'], 'query') !== FALSE) {
- $menu_link['options'] = unserialize($menu_link['options']);
- if (isset($menu_link['options']['query']) && is_string($menu_link['options']['query'])) {
- $menu_link['options']['query'] = drupal_get_query_array($menu_link['options']['query']);
- db_update('menu_links')
- ->fields(array(
- 'options' => serialize($menu_link['options']),
- ))
- ->condition('mlid', $menu_link['mlid'], '=')
- ->execute();
- }
- }
- }
- }
- function system_update_7077() {
- db_change_field('file_managed', 'filename', 'filename', array(
- 'description' => 'Name of the file with no path components. This may differ from the basename of the URI if the file is renamed to avoid overwriting an existing file.',
- 'type' => 'varchar',
- 'length' => 255,
- 'not null' => TRUE,
- 'default' => '',
- ));
- }
- function system_update_7078() {
- db_drop_unique_key('date_formats', 'formats');
- db_change_field('date_formats', 'format', 'format', array(
- 'description' => 'The date format string.',
- 'type' => 'varchar',
- 'length' => 100,
- 'not null' => TRUE,
- 'binary' => TRUE,
- ), array('unique keys' => array('formats' => array('format', 'type'))));
- }
- function system_update_7079() {
- $spec = array(
- 'description' => 'The size of the file in bytes.',
- 'type' => 'int',
- 'size' => 'big',
- 'unsigned' => TRUE,
- 'not null' => TRUE,
- 'default' => 0,
- );
- db_change_field('file_managed', 'filesize', 'filesize', $spec);
- }
- function system_update_7080() {
- $spec = array(
- 'description' => 'The date format string.',
- 'type' => 'varchar',
- 'length' => 100,
- 'not null' => TRUE,
- 'binary' => TRUE,
- );
- db_change_field('date_format_locale', 'format', 'format', $spec);
- }
- function system_update_7081() {
-
-
-
- db_delete('system')
- ->condition('filename', 'profiles/default/default.profile')
- ->condition('type', 'module')
- ->condition('status', 0)
- ->condition('schema_version', 0)
- ->execute();
- }
- function system_update_7082() {
-
- }
|