About 49 results: "mysql_query repo:mpercy/deeemm-cms"
Page 1 of 3
Filter Results
Sources
Languages
Filter Results
Try Search On










DM-061-062-Update.php in deeemm-cms https://bitbucket.org/mpercy/deeemm-cms | 39 lines | PHP
  1. ===========================================================================*/
  2. 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());
  3. //users
  4. //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());
  5. ===========================================================================*/
  6. $sql_query = mysql_query("SHOW TABLES FROM $db_name");
  7. 		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'){
  8. 			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());
  9. 			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());
  10. 			echo 'Updated -> ' . $sql_result[0] . '<br>';










Back to Top