data_replace.php 1.2 KB

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. //decode by http://dezend.qiling.org QQ 2859470
  3. define('CURSCRIPT', 'data_replace');
  4. require_once dirname(__FILE__) . '/global.php';
  5. require_once MYMPS_INC . '/db.class.php';
  6. (!defined('IN_ADMIN') || !defined('IN_MYMPS')) && exit('Access Denied');
  7. $part = isset($part) ? $part : 'default';
  8. if ($part == 'default') {
  9. $here = '数据库内容替换';
  10. chk_admin_purview('purview_数据库维护');
  11. include mymps_tpl('data_replace');
  12. } else {
  13. if ($part == 'do_action') {
  14. if ($exptable == '' || $rpfield == '') {
  15. write_msg('请指定数据表和字段!', 'olmsg');
  16. exit;
  17. }
  18. if ($rpstring == '') {
  19. write_msg('请指定被替换内容!', 'olmsg');
  20. exit;
  21. }
  22. $rs = $db->query('UPDATE ' . $exptable . ' SET ' . $rpfield . '=REPLACE(' . $rpfield . ',\'' . $rpstring . '\',\'' . $tostring . '\')');
  23. $db->query('OPTIMIZE TABLE `' . $exptable . '`');
  24. if ($rs) {
  25. write_msg('成功完成数据替换!', 'olmsg', 'write_mymps_record');
  26. exit;
  27. } else {
  28. write_msg('数据替换失败!', 'olmsg', 'write_mymps_record');
  29. exit;
  30. }
  31. }
  32. }