Changeset 1786
- Timestamp:
- Feb 7, 2007, 8:49:35 PM (17 years ago)
- Location:
- trunk
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/include/functions.php
r1763 r1786 522 522 function mass_inserts($table_name, $dbfields, $datas) 523 523 { 524 global $conf; 525 524 526 if (count($datas) != 0) 525 527 { 526 528 // inserts all found categories 527 $query = '529 $query_begin = ' 528 530 INSERT INTO '.$table_name.' 529 531 ('.implode(',', $dbfields).') 530 532 VALUES'; 531 $first = 1; 533 534 $first = true; 535 $query_value = array(); 536 $query_value_index = 0; 537 532 538 foreach ($datas as $insert) 533 539 { 534 $query .= '540 $query_value[$query_value_index] .= ' 535 541 '; 536 542 if ($first) 537 543 { 538 $first = 0; 544 $first = false; 545 if (strlen($query_value[$query_value_index]) > 6) 546 { 547 $query_value[$query_value_index] .= ','; 548 } 539 549 } 540 550 else 541 551 { 542 $query.= ','; 552 if (strlen($query_value[$query_value_index]) >= $conf['max_allowed_packet']) 553 { 554 $query_value_index ++; 555 $query_value[$query_value_index] .= ' 556 '; 557 $first = true; 558 } 559 else 560 { 561 $query_value[$query_value_index] .= ','; 562 } 543 563 } 544 $query .= '(';564 $query_value[$query_value_index] .= '('; 545 565 foreach ($dbfields as $field_id => $dbfield) 546 566 { 547 567 if ($field_id > 0) 548 568 { 549 $query .= ',';569 $query_value[$query_value_index] .= ','; 550 570 } 551 571 552 572 if (!isset($insert[$dbfield]) or $insert[$dbfield] === '') 553 573 { 554 $query .= 'NULL';574 $query_value[$query_value_index] .= 'NULL'; 555 575 } 556 576 else 557 577 { 558 $query .= "'".$insert[$dbfield]."'";578 $query_value[$query_value_index] .= "'".$insert[$dbfield]."'"; 559 579 } 560 580 } 561 $query.=')'; 562 } 563 $query.= ' 564 ;'; 565 pwg_query($query); 581 $query_value[$query_value_index] .= ')'; 582 } 583 584 $query_end .= ' 585 ;'; 586 foreach ($query_value as $value) 587 { 588 $final_query = $query_begin.$value.$query_end; 589 pwg_query($final_query); 590 } 566 591 } 567 592 } -
trunk/include/config_default.inc.php
r1781 r1786 665 665 $conf['light_slideshow'] = true; 666 666 667 // +-----------------------------------------------------------------------+ 668 // | mysql | 669 // +-----------------------------------------------------------------------+ 670 671 // $conf['max_allowed_packet'] indicates the max size in octets of MySql 672 // request. Used in mass_inserts() function. 673 $conf['max_allowed_packet'] = 1000000; 674 667 675 ?>
Note: See TracChangeset
for help on using the changeset viewer.