Changeset 5812 for temp/trunk
- Timestamp:
- 2006/09/25 18:01:41 (20 years ago)
- Location:
- temp/trunk
- Files:
-
- 2 edited
-
data/class/SC_Query.php (modified) (1 diff)
-
html/admin/system/bkup.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
temp/trunk/data/class/SC_Query.php
r5765 r5812 375 375 $seqtable = $table . "_" . $colname . "_seq"; 376 376 $sql = "SELECT SETVAL('$seqtable', $data)"; 377 $ret = $this->conn->getOne($sql); 377 378 }else if (DB_TYPE == "mysql") { 378 379 $sql = "ALTER TABLE $table AUTO_INCREMENT=$data"; 379 }380 $ret = $this->conn->getOne($sql);380 $ret = $this->conn->query($sql); 381 } 381 382 382 383 return $ret; -
temp/trunk/html/admin/system/bkup.php
r5811 r5812 383 383 if ($err) { 384 384 385 sfprintr("1111111111"); 386 385 387 // ¥È¥é¥ó¥¶¥¯¥·¥ç¥ó³«»Ï 386 //$objQuery->begin(); 388 $objQuery->begin(); 389 sfprintr("1111111111"); 387 390 388 391 // DB¤ò¥¯¥ê¥¢ 389 392 $err = lfDeleteAll($objQuery); 393 sfprintr("1111111111"); 390 394 391 395 // INSERT¼Â¹Ô 392 396 if ($err) $err = lfExeInsertSQL($objQuery, $bkup_dir . "bkup_data.csv"); 397 sfprintr("1111111111"); 393 398 394 399 // ¼«Æ°ºÎÈÖ¤ÎÃͤò¥»¥Ã¥È 395 400 if ($err) lfSetAutoInc($objQuery, $bkup_dir . "autoinc_data.csv"); 401 sfprintr("1111111111"); 396 402 397 403 if ($err) { … … 404 410 sfDelFile($bkup_dir); 405 411 } 406 412 sfprintr("1111111111"); 413 407 414 // ¥ê¥¹¥È¥¢À®¸ù¤Ê¤é¥³¥ß¥Ã¥È¼ºÇԤʤé¥í¡¼¥ë¥Ð¥Ã¥¯ 408 415 if ($err) { 409 //$objQuery->commit();416 $objQuery->commit(); 410 417 $objPage->restore_msg = "¥ê¥¹¥È¥¢½ªÎ»¤·¤Þ¤·¤¿¡£"; 411 418 $objPage->restore_err = true; 412 419 }else{ 413 //$objQuery->rollback();420 $objQuery->rollback(); 414 421 $objPage->restore_msg = "¥ê¥¹¥È¥¢¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£"; 415 422 $objPage->restore_name = $bkup_name; 416 423 $objPage->restore_err = false; 417 424 } 425 sfprintr("1111111111"); 426 418 427 } 419 428 }
Note: See TracChangeset
for help on using the changeset viewer.
