Viewing Paste 425

Formated Paste

  1. // SleePy is lazy, so I will just check to see if db_query exists
  2. if(!function_exists('db_query'))
  3. {
  4. db_extend('Packages');
  5. function db_query($query, $file, $line)
  6. {
  7. global $smcFunc;
  8. return $smcFunc['db_query']('', $query, array('db_error_skip' => true));
  9. }
  10. }
  11. // All work here is for back support for SMF 1.1, It is easier to support 2.0 and backport.
  12. else
  13. {
  14. $smcFunc = $func;
  15. $smcFunc['db_num_rows'] = 'mysql_num_rows';
  16. $smcFunc['db_free_result'] = 'mysql_free_result';
  17. $smcFunc['db_fetch_assoc'] = 'mysql_fetch_assoc';
  18. $smcFunc['db_list_columns'] = 'mysql_show_columns';
  19. $smcFunc['db_add_column'] = 'mysql_create_columns';
  20.  
  21. // Quickly emulate these functions.
  22. function mysql_show_columns($table_name)
  23. {
  24. global $smcFunc, $db_prefix;
  25.  
  26. $result = db_query("SHOW FIELDS FROM {$table_name}", __FILE__, __LINE__);;
  27. $columns = array();
  28. while ($row = $smcFunc['db_fetch_assoc']($result))
  29. $columns[] = $row['Field'];
  30. return $columns;
  31. }
  32. function mysql_create_columns($table_name, $column_info)
  33. {
  34. global $db_prefix;
  35.  
  36. return db_query('ALTER TABLE ' . $table_name . '
  37. ADD ' . $column_info['name'] . ' ' . $column_info['type'] . ' ' . (empty($column_info['null']) ? 'NOT NULL' : '') . ' ' .
  38. (empty($column_info['default']) ? '' : 'default \'' . $column_info['default'] . '\'') . ' ' .
  39. (empty($column_info['auto']) ? '' : 'auto_increment') . ' ', __FILE__, __LINE__);
  40. }
  41. }
  42.  
Name:
Email:
Code/text to paste:
  • Enable code highlighting
  • Code Language:
  • A duck, cat and a goose walk into a bar. How many animals walked into a bar?:
Highslide for Wordpress Plugin