object(HotopayModel)#817 (23) {
["error"]=>
int(0)
["message"]=>
string(7) "success"
["variables"]=>
array(0) {
}
["httpStatusCode"]=>
int(200)
["module"]=>
string(7) "hotopay"
["module_info"]=>
NULL
["origin_module_info"]=>
NULL
["module_config"]=>
NULL
["module_path"]=>
string(52) "/home/eond/web/eond.com/public_html/modules/hotopay/"
["xml_info"]=>
NULL
["module_srl"]=>
NULL
["mid"]=>
NULL
["act"]=>
NULL
["template_path"]=>
NULL
["template_file"]=>
NULL
["layout_path"]=>
NULL
["layout_file"]=>
NULL
["edited_layout_file"]=>
NULL
["stop_proc"]=>
bool(false)
["user"]=>
object(Rhymix\Framework\Helpers\SessionHelper)#816 (20) {
["member_srl"]=>
int(0)
["user_id"]=>
NULL
["user_name"]=>
NULL
["nick_name"]=>
NULL
["email_address"]=>
NULL
["phone_number"]=>
NULL
["homepage"]=>
NULL
["blog"]=>
NULL
["birthday"]=>
NULL
["denied"]=>
NULL
["status"]=>
NULL
["is_admin"]=>
string(1) "N"
["is_site_admin"]=>
NULL
["profile_image"]=>
NULL
["image_name"]=>
NULL
["image_mark"]=>
NULL
["signature"]=>
NULL
["description"]=>
NULL
["group_list"]=>
array(0) {
}
["menu_list"]=>
array(0) {
}
}
["request"]=>
object(Rhymix\Framework\Request)#10 (13) {
["method"]=>
string(3) "GET"
["compat_method"]=>
string(3) "GET"
["url"]=>
string(21) "xe/379602/page/465443"
["hostname"]=>
string(8) "eond.com"
["domain"]=>
NULL
["protocol"]=>
string(5) "https"
["callback_function"]=>
string(0) ""
["_route_status":protected]=>
int(200)
["_route_options":protected]=>
object(stdClass)#11 (5) {
["cache_control"]=>
bool(true)
["check_csrf"]=>
bool(true)
["is_forwarded"]=>
bool(false)
["is_indexable"]=>
bool(true)
["enable_session"]=>
bool(true)
}
["module"]=>
string(5) "board"
["mid"]=>
string(2) "xe"
["act"]=>
string(16) "dispBoardContent"
["args"]=>
array(4) {
["document_srl"]=>
string(6) "379602"
["page"]=>
int(1)
["mid"]=>
string(2) "xe"
["act"]=>
string(16) "dispBoardContent"
}
}
["ajaxRequestMethod"]=>
array(2) {
[0]=>
string(6) "XMLRPC"
[1]=>
string(4) "JSON"
}
["gzhandler_enable"]=>
bool(true)
}
1. 글 내용 변경하기
UPDATE xe_documents SET content = REPLACE( content, "부을장수온돌침대", "부을쿠션흙침대" ) ;# 8 열에 적용되었습니다.
UPDATE xe_documents SET title = REPLACE( title, "부을장수온돌침대", "부을쿠션흙침대" ) ;# 3 열에 적용되었습니다.
UPDATE xe_documents SET nick_name = "부을장수온돌침대" WHERE nick_name = "부을쿠션흙침대";# 결과값이 없습니다. (빈 레코드 리턴).
부을장수온돌침대라는 텍스트를 부을쿠션흙침대로 변경하는 코드입니다.
UPDATE xe_documents SET content = REPLACE( content, "korindia.eond.com", "korindia.com" ) ;
UPDATE xe_comments SET content = REPLACE( content, "korindia.eond.com", "korindia.com" ) ;
UPDATE xe_member_message SET content = REPLACE( content, "korindia.eond.com", "korindia.com" ) ;
UPDATE xe_modules SET content = REPLACE( content, "korindia.eond.com", "korindia.com" ) ;
2. XE 글작성자 닉네임을 한꺼번에 변경하기
update xe_documents set nick_name = "바꿀 닉네임" where nick_name= "바꾸기 전 닉네임";
출처 : http://blissy.tistory.com/m/88
3. 댓글 닉네임에도 변경하는 방법
update xe_comments set nick_name = "바꿀 닉네임" where nick_name= "바꾸기전 닉네임";
4. 위젯 바로가기 링크 주소 변경하기
UPDATE xe_menu_item SET url = REPLACE( url, "이전 주소", "새로운 주소" ) ;
UPDATE xe_menu_item SET url = REPLACE( url, "http://korindia.eond.com/xe/", "http://korindia.com/" ) ;
잘못된 예
SELECT * FROM `xe_member_group` WHERE 1
UPDATE * SET * = REPLACE(*, "http://korindia.eond.com/xe/", "http://korindia.com/");
UPDATE * SET * = "korindia.eond.com/xe" WHERE nick_name = "korindia.com"
5. 위젯스타일 바로가기 주소 교체하기
UPDATE xe_modules SET content = REPLACE( content, "korindia.eond.com%2Fxe", "korindia.com" ) ;
UPDATE xe_modules SET content = REPLACE( content, "korindia.eond.com%252Fxe", "korindia.com" ) ;
UPDATE xe_modules SET content = REPLACE( content, "korindia.eond.com%252Fxe", "korindia.com" ) ;
http%3A%2F%2Feond.com%2Fxe
관리자 > 캐시재설정 > 완료
6. 메뉴 바로가기에 주소 한꺼번에 변경하기
UPDATE xe_menu_item SET url = REPLACE(url, "http://www.watchclone66.co.kr/","/");
UPDATE xe_menu_item SET url = REPLACE( url, "http://www.watchclone66.co.kr/", "/" ) ;
UPDATE xe_menu_item SET url = REPLACE( url, "https://www.watchclonee.co.kr/", "/" ) ;
댓글 1
댓글작성칸으로