@@ 365-382 (lines=18) @@ | ||
362 | * @return bool true if success, false if an error occured |
|
363 | * |
|
364 | */ |
|
365 | public function updateFieldsValues() |
|
366 | { |
|
367 | global $xoopsDB; |
|
368 | ||
369 | $ret = true; |
|
370 | ||
371 | foreach ($this->getUpdatedFields() as $updatedField) { |
|
372 | $query = sprintf('UPDATE %s SET %s = %s', $this->name(), $updatedField['name'], $updatedField['value']); |
|
373 | $ret = $ret && $xoopsDB->query($query); |
|
374 | if (!$ret) { |
|
375 | echo "<li class='err'>" . sprintf(_AM_SPARTNER_DB_MSG_UPDATE_TABLE_ERR, $this->name()) . '</li>'; |
|
376 | } else { |
|
377 | echo "<li class='ok'>" . sprintf(_AM_SPARTNER_DB_MSG_UPDATE_TABLE, $this->name()) . '</li>'; |
|
378 | } |
|
379 | } |
|
380 | ||
381 | return $ret; |
|
382 | } |
|
383 | ||
384 | /** |
|
385 | * Use to drop fields |
@@ 486-503 (lines=18) @@ | ||
483 | * @return bool true if success, false if an error occured |
|
484 | * |
|
485 | */ |
|
486 | public function updateFieldsValues() |
|
487 | { |
|
488 | global $xoopsDB; |
|
489 | ||
490 | $ret = true; |
|
491 | ||
492 | foreach ($this->getUpdatedFields() as $updatedField) { |
|
493 | $query = sprintf('UPDATE %s SET %s = %s', $this->name(), $updatedField['name'], $updatedField['value']); |
|
494 | $ret = $ret && $xoopsDB->query($query); |
|
495 | if (!$ret) { |
|
496 | echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()) . '<br>'; |
|
497 | } else { |
|
498 | echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()) . '<br>'; |
|
499 | } |
|
500 | } |
|
501 | ||
502 | return $ret; |
|
503 | } |
|
504 | ||
505 | /** |
|
506 | * Use to update fields values |