| 382 | | if(!function_exists('create_table_add_character_set') and !defined('IN_ADMIN')) |
| 383 | | { |
| 384 | | /** |
| 385 | | * from admin/include/functions.php |
| 386 | | * |
| 387 | | * adds the caracter set to a create table sql query. |
| 388 | | * all CREATE TABLE queries must call this function |
| 389 | | * @param string query - the sql query |
| 390 | | */ |
| 391 | | function create_table_add_character_set($query) |
| 392 | | { |
| 393 | | defined('DB_CHARSET') or fatal_error('create_table_add_character_set DB_CHARSET undefined'); |
| 394 | | if ('DB_CHARSET'!='') |
| 395 | | { |
| 396 | | if ( version_compare(mysql_get_server_info(), '4.1.0', '<') ) |
| 397 | | { |
| 398 | | return $query; |
| 399 | | } |
| 400 | | $charset_collate = ; |
| 401 | | if (DB_COLLATE!='') |
| 402 | | { |
| 403 | | $charset_collate .= |
| 404 | | } |
| 405 | | if ( is_array($query) ) |
| 406 | | { |
| 407 | | foreach( $query as $id=>$q) |
| 408 | | { |
| 409 | | $q=trim($q); |
| 410 | | $q=trim($q, ';'); |
| 411 | | if (preg_match('/^CREATE\s+TABLE/i',$q)) |
| 412 | | { |
| 413 | | $q.=$charset_collate; |
| 414 | | } |
| 415 | | $q .= ';'; |
| 416 | | $query[$id] = $q; |
| 417 | | } |
| 418 | | } |
| 419 | | else |
| 420 | | { |
| 421 | | $query=trim($query); |
| 422 | | $query=trim($query, ';'); |
| 423 | | if (preg_match('/^CREATE\s+TABLE/i',$query)) |
| 424 | | { |
| 425 | | $query.=$charset_collate; |
| 426 | | } |
| 427 | | $query .= ';'; |
| 428 | | } |
| 429 | | } |
| 430 | | return $query; |
| 431 | | } |
| 432 | | } |