PageRenderTime 55ms CodeModel.GetById 35ms RepoModel.GetById 0ms app.codeStats 0ms

/updates/DM-061-062-Update.php

https://bitbucket.org/mpercy/deeemm-cms
PHP | 39 lines | 14 code | 8 blank | 17 comment | 12 complexity | 00f76c7dcac5f4e5bc5faa6b43a2eaee MD5 | raw file
Possible License(s): LGPL-2.1, BSD-2-Clause
  1. <?php
  2. defined( '_INDM' ) or die( 'POSSIBLE HACK ATTEMPT!' );
  3. //===========================================================================
  4. $new_version = '0.6.2 (BETA)';
  5. /*===========================================================================
  6. //>update version number
  7. ===========================================================================*/
  8. mysql_query("UPDATE `" . $db_table_prefix . "admin` SET `version` = '$new_version' WHERE `id` = 0") OR DIE ("<b>A fatal MySQL error occured</b>.\n<br />Query: " . $sql_query . "<br />\nError: (" . mysql_errno() . ") " . mysql_error());
  9. echo $version . ' -> ' . $new_version . ' Update<br><br>';
  10. /*===========================================================================
  11. //>update control tables in database
  12. ===========================================================================*/
  13. //admin
  14. //orphan
  15. //static_content
  16. //stats
  17. //structure
  18. //users
  19. //mysql_query("ALTER TABLE `" . $db_table_prefix . "core_structure` ADD `href_only` varchar(10) NOT NULL AFTER `display_in_margin`") OR DIE ("<b>A fatal MySQL error occured</b>.\n<br />Query: " . $sql_query . "<br />\nError: (" . mysql_errno() . ") " . mysql_error());
  20. /*===========================================================================
  21. //>update non control (content) tables in database
  22. ===========================================================================*/
  23. $sql_query = mysql_query("SHOW TABLES FROM $db_name");
  24. while($sql_result = mysql_fetch_array($sql_query)) {
  25. if ($sql_result[0] != $db_table_prefix.'admin' && $sql_result[0] != $db_table_prefix.'orphan' && $sql_result[0] != $db_table_prefix.'static_content' && $sql_result[0] != $db_table_prefix.'stats' && $sql_result[0] != $db_table_prefix.'structure' && $sql_result[0] != $db_table_prefix.'users'){
  26. mysql_query("ALTER TABLE `" . $sql_result[0] . "` ADD `link_url` varchar(200) NOT NULL AFTER `image`") OR DIE ("<b>A fatal MySQL error occured</b>.\n<br />Query: " . $sql_query . "<br />\nError: (" . mysql_errno() . ") " . mysql_error());
  27. mysql_query("ALTER TABLE `" . $sql_result[0] . "` ADD `display_in_navabar` varchar(50) DEFAULT 'on' NOT NULL AFTER `link_url`") OR DIE ("<b>A fatal MySQL error occured</b>.\n<br />Query: " . $sql_query . "<br />\nError: (" . mysql_errno() . ") " . mysql_error());
  28. echo 'Updated -> ' . $sql_result[0] . '<br>';
  29. }
  30. }
  31. ?>