{"id":6726,"date":"2019-05-15T21:07:54","date_gmt":"2019-05-15T13:07:54","guid":{"rendered":"https:\/\/www.npc.ink\/?p=6726"},"modified":"2019-05-15T21:07:54","modified_gmt":"2019-05-15T13:07:54","slug":"typecho%e6%a8%a1%e6%9d%bf%e8%ae%be%e7%bd%ae%e6%95%b0%e6%8d%ae%e5%a4%87%e4%bb%bd%e4%b8%8e%e6%81%a2%e5%a4%8d","status":"publish","type":"post","link":"https:\/\/www.npc.ink\/6726.html","title":{"rendered":"Typecho\u6a21\u677f\u8bbe\u7f6e\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d"},"content":{"rendered":"

\u6765\u6e90\u4e8e\uff1a<\/strong><\/p>\n

https:\/\/qqdie.com\/archives\/typecho-templates-backup-and-restore.html<\/a><\/p>\n

typecho\u6a21\u677f\u8bbe\u7f6e\u6570\u636e\u4f1a\u5728\u4f60\u6362\u6a21\u677f\u7684\u65f6\u5019\u88ab\u6e05\u7a7a\uff0c\u8fd9\u6837\u7684\u8bbe\u7f6e\u5176\u5b9e\u6211\u8fd8\u662f\u86ee\u559c\u6b22\u7684\uff0c\u4e0d\u4f1a\u6709\u6570\u636e\u6b8b\u7559\u3002<\/p>\n

\u7136\u800cWP\u7528\u6237\u8f6c\u5230typecho\u540e\u8ddf\u6211\u62b1\u6028\uff0c\u8bf4\u6a21\u677f\u6362\u6210\u522b\u7684\u7136\u540e\u518d\u5207\u6362\u56de\u6765\uff0c\u4e4b\u524d\u8bbe\u7f6e\u597d\u7684\u6570\u636e\u90fd\u6ca1\u4e86\uff0c\u5e0c\u671b\u6211\u5728yodu<\/a>\u6a21\u677f\u4e0a\u52a8\u52a8\u624b\u811a\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002<\/p>\n

\u7136\u800c\u6211\u662f\u6709\u4e9b\u8fdf\u7591\u7684\uff0c\u4e1c\u897f\u4e0d\u662f\u4f60\u8bf4\u505a\u6211\u5c31\u8981\u505a\u7684\uff0c\u6211\u5fc5\u987b\u8bd5\u4e00\u4e0b...\u5426\u5219\u7b54\u5e94\u592a\u5feb\u53c8\u641e\u4e0d\u51fa\u6765\uff0c\u5c82\u4e0d\u662f\u5f88\u96be\u53d7\uff01<\/p>\n

\u4e0d\u8fc7\u65e2\u7136\u53d1\u4e86\u8fd9\u7bc7\u6587\u7ae0\uff0c\u5c31\u8bf4\u660e\u5df2\u7ecf\u641e\u5b9a\u4e86<\/p>\n

\"Typecho\u6a21\u677f\u8bbe\u7f6e\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d-Npcink\"
<\/figcaption><\/figure>\n

\u4ee3\u7801<\/strong><\/p>\n

\u5728themeConfig($form)<\/code>\u51fd\u6570\u91cc\u6dfb\u52a0<\/p>\n

$db = Typecho_Db::get();\r\n$sjdq=$db->fetchRow($db->select()->from ('table.options')->where ('name = ?', 'theme:Yodu'));\r\n$ysj = $sjdq['value'];\r\nif(isset($_POST['type']))\r\n{ \r\nif($_POST[\"type\"]==\"\u5907\u4efd\u6a21\u677f\u6570\u636e\"){\r\nif($db->fetchRow($db->select()->from ('table.options')->where ('name = ?', 'theme:Yodubf'))){\r\n$update = $db->update('table.options')->rows(array('value'=>$ysj))->where('name = ?', 'theme:Yodubf');\r\n$updateRows= $db->query($update);\r\necho '<div<\/span> class<\/span>=\"tongzhi\"<\/span>><\/span>\u5907\u4efd\u5df2\u66f4\u65b0\uff0c\u8bf7\u7b49\u5f85\u81ea\u52a8\u5237\u65b0\uff01\u5982\u679c\u7b49\u4e0d\u5230\u8bf7\u70b9\u51fb';\r\n?>    \r\n<a<\/span> href<\/span>=\"<?php Helper::options()->adminUrl('options-theme.php'); ?>\"<\/span>><\/span>\u8fd9\u91cc<\/a<\/span>><\/div<\/span>><\/span>\r\n<script<\/span> language<\/span>=\"JavaScript\"<\/span>><\/span>window.setTimeout(\"location=\\'<?php<\/span> Helper::options()->adminUrl('options-theme.php'<\/span>); ?><\/span>\\'\", 2500);<\/script<\/span>><\/span>\r\n<?php<\/span>\r\n}else<\/span>{\r\nif<\/span>($ysj){\r\n     $insert = $db->insert('table.options'<\/span>)->rows(array<\/span>('name'<\/span> => 'theme:Yodubf'<\/span>,'user'<\/span> => '0'<\/span>,'value'<\/span> => $ysj));\r\n     $insertId = $db->query($insert);\r\necho<\/span> '<div class=\"tongzhi\">\u5907\u4efd\u5b8c\u6210\uff0c\u8bf7\u7b49\u5f85\u81ea\u52a8\u5237\u65b0\uff01\u5982\u679c\u7b49\u4e0d\u5230\u8bf7\u70b9\u51fb'<\/span>;\r\n?><\/span>    \r\n<a<\/span> href<\/span>=\"<?php Helper::options()->adminUrl('options-theme.php'); ?>\"<\/span>><\/span>\u8fd9\u91cc<\/a<\/span>><\/div<\/span>><\/span>\r\n<script<\/span> language<\/span>=\"JavaScript\"<\/span>><\/span>window.setTimeout(\"location=\\'<?php<\/span> Helper::options()->adminUrl('options-theme.php'<\/span>); ?><\/span>\\'\", 2500);<\/script<\/span>><\/span>\r\n<?php<\/span>\r\n}\r\n}\r\n        }\r\nif<\/span>($_POST[\"type\"<\/span>]==\"\u8fd8\u539f\u6a21\u677f\u6570\u636e\"<\/span>){\r\nif<\/span>($db->fetchRow($db->select()->from ('table.options'<\/span>)->where ('name = ?'<\/span>, 'theme:Yodubf'<\/span>))){\r\n$sjdub=$db->fetchRow($db->select()->from ('table.options'<\/span>)->where ('name = ?'<\/span>, 'theme:Yodubf'<\/span>));\r\n$bsj = $sjdub['value'<\/span>];\r\n$update = $db->update('table.options'<\/span>)->rows(array<\/span>('value'<\/span>=>$bsj))->where('name = ?'<\/span>, 'theme:Yodu'<\/span>);\r\n$updateRows= $db->query($update);\r\necho<\/span> '<div class=\"tongzhi\">\u68c0\u6d4b\u5230\u6a21\u677f\u5907\u4efd\u6570\u636e\uff0c\u6062\u590d\u5b8c\u6210\uff0c\u8bf7\u7b49\u5f85\u81ea\u52a8\u5237\u65b0\uff01\u5982\u679c\u7b49\u4e0d\u5230\u8bf7\u70b9\u51fb'<\/span>;\r\n?><\/span>    \r\n<a<\/span> href<\/span>=\"<?php Helper::options()->adminUrl('options-theme.php'); ?>\"<\/span>><\/span>\u8fd9\u91cc<\/a<\/span>><\/div<\/span>><\/span>\r\n<script<\/span> language<\/span>=\"JavaScript\"<\/span>><\/span>window.setTimeout(\"location=\\'<?php<\/span> Helper::options()->adminUrl('options-theme.php'<\/span>); ?><\/span>\\'\", 2000);<\/script<\/span>><\/span>\r\n<?php<\/span>\r\n}else<\/span>{\r\necho<\/span> '<div class=\"tongzhi\">\u6ca1\u6709\u6a21\u677f\u5907\u4efd\u6570\u636e\uff0c\u6062\u590d\u4e0d\u4e86\u54e6\uff01<\/div>'<\/span>;\r\n}\r\n}\r\nif<\/span>($_POST[\"type\"<\/span>]==\"\u5220\u9664\u5907\u4efd\u6570\u636e\"<\/span>){\r\nif<\/span>($db->fetchRow($db->select()->from ('table.options'<\/span>)->where ('name = ?'<\/span>, 'theme:Yodubf'<\/span>))){\r\n$delete = $db->delete('table.options'<\/span>)->where ('name = ?'<\/span>, 'theme:Yodubf'<\/span>);\r\n$deletedRows = $db->query($delete);\r\necho<\/span> '<div class=\"tongzhi\">\u5220\u9664\u6210\u529f\uff0c\u8bf7\u7b49\u5f85\u81ea\u52a8\u5237\u65b0\uff0c\u5982\u679c\u7b49\u4e0d\u5230\u8bf7\u70b9\u51fb'<\/span>;\r\n?><\/span>    \r\n<a<\/span> href<\/span>=\"<?php Helper::options()->adminUrl('options-theme.php'); ?>\"<\/span>><\/span>\u8fd9\u91cc<\/a<\/span>><\/div<\/span>><\/span>\r\n<script<\/span> language<\/span>=\"JavaScript\"<\/span>><\/span>window.setTimeout(\"location=\\'<?php<\/span> Helper::options()->adminUrl('options-theme.php'<\/span>); ?><\/span>\\'\", 2500);<\/script<\/span>><\/span>\r\n<?php<\/span>\r\n}else<\/span>{\r\necho<\/span> '<div class=\"tongzhi\">\u4e0d\u7528\u5220\u4e86\uff01\u5907\u4efd\u4e0d\u5b58\u5728\uff01\uff01\uff01<\/div>'<\/span>;\r\n}\r\n}\r\n    }\r\necho<\/span> '<form class=\"protected\" action=\"?yodubf\" method=\"post\">\r\n<input type=\"submit\" name=\"type\" class=\"btn btn-s\" value=\"\u5907\u4efd\u6a21\u677f\u6570\u636e\" \/>&nbsp;&nbsp;<input type=\"submit\" name=\"type\" class=\"btn btn-s\" value=\"\u8fd8\u539f\u6a21\u677f\u6570\u636e\" \/>&nbsp;&nbsp;<input type=\"submit\" name=\"type\" class=\"btn btn-s\" value=\"\u5220\u9664\u5907\u4efd\u6570\u636e\" \/><\/form>'<\/span>;\r\n<\/pre>\n
SQL<\/strong><\/p>\n
\u7136\u540e\u5c06\u91cc\u9762\u51fa\u73b0\u7684\u6240\u6709\u201cyodu\u201d\u6539\u6210\u4f60\u7684\u6a21\u677f\u76ee\u5f55<\/strong>\u7684\u540d\u5b57\uff0c\u5982\u679c\u62ff\u4e0d\u51c6\u5c31\u53bb\u6570\u636e\u5e93\u91cc\u770b\u770b\u6a21\u677f\u7684\u503c\u540d\u5b57\u3002<\/p>\n
\u5907\u4efd<\/strong><\/p>\n
\u5f53\u7528\u6237\u70b9\u51fb\u5907\u4efd<\/strong>\u65f6\uff0c\u5148\u5224\u65ad\u662f\u5426\u5df2\u7ecf\u5b58\u5728\u5907\u4efd\uff0c\u5982\u679c\u4e0d\u5b58\u5728\u5c31\u63d2\u5165\u4e00\u6761\u65b0\u7684\u6570\u636e\uff0c\u6570\u636ename\u4e3ayodubf\uff0cvalue\u4e3a\u6a21\u677f\u539f\u672c\u7684\u6570\u636e\u3002\u6b64\u65f6\u5c31\u5b58\u5728\u4e86\u4e00\u6761\u5907\u4efd\u6570\u636e\u3002<\/p>\n
\u5982\u679c\u518d\u6b21\u70b9\u51fb\u5907\u4efd<\/strong>\u6309\u94ae\u4f1a\u53d1\u751f\u4ec0\u4e48\u5462\uff1f\u4f1a\u89e6\u53d1\u66f4\u65b0\u6570\u636e\u7684\u8bed\u53e5\uff0c\u5c31\u662f\u8bfb\u53d6\u6a21\u677f\u7684\u8bbe\u7f6e\u6570\u636e\uff0c\u7136\u540e\u5c06\u5907\u4efd\u7684\u6a21\u677f\u6570\u636e\u66f4\u65b0\u3002<\/p>\n
\u8fd8\u539f<\/strong><\/p>\n
\u5f53\u7528\u6237\u70b9\u51fb\u8fd8\u539f<\/strong>\u6309\u94ae\u65f6\uff0c\u4f1a\u5224\u65ad\u662f\u5426\u5b58\u5728\u5907\u4efd\uff0c\u5982\u679c\u4e0d\u5b58\u5728\u5c31\u53d1\u51fa\u63d0\u793a\u8bf4\u4e0d\u5b58\u5728\u6570\u636e\u65e0\u6cd5\u6062\u590d\uff1b\u5982\u679c\u5b58\u5728\uff0c\u5c31\u4f1a\u8fdb\u884c\u4e00\u4e2a\u53cd\u5411\u7684\u66f4\u65b0\u64cd\u4f5c\uff0c\u5c06\u5907\u4efd\u7684\u6570\u636e\u66f4\u65b0\u5230\u6a21\u677f\u9ed8\u8ba4\u8bbe\u7f6e\u6570\u636e\u3002<\/p>\n
\u8fd9\u4e2a\u64cd\u4f5c\u5b8c\u6210\u540e\u4f1a\u89e6\u53d1\u4e2a\u5c0f\u95ee\u9898\uff0c\u6bd4\u8f83\u5f71\u54cd\u4f53\u9a8c\u7684\u3002\u5c31\u662f\u5728\u70b9\u51fb\u8fd8\u539f<\/strong>\u6309\u94ae\u65f6\u7f51\u9875\u662f\u5148\u5237\u65b0\u540e\u6267\u884cphp\u8fd8\u539f\u8bed\u53e5\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\u8fd8\u539f\u5b8c\u6210\u540e\uff0c\u4f60\u770b\u5230\u7684\u6a21\u677f\u8bbe\u7f6e\u9875\u9762\u6570\u636e\u5e76\u6ca1\u6709\u8fd8\u539f\uff0c\u4f46\u662f\u5b9e\u9645\u6570\u636e\u5e93\u91cc\u9762\u5df2\u7ecf\u8fd8\u539f\u597d\u4e86\u7684\uff0c\u8fd9\u4e00\u70b9\u5f88\u5f71\u54cd\u4f53\u9a8c\u3002<\/p>\n
\u4e8e\u662f\u4e4e\uff0c\u6211\u9e21\u8d3c\u7684\u5f04\u4e86\u4e2ajs\u81ea\u52a8\u5237\u65b0\u8bed\u53e5\uff0c\u5e76\u53d1\u51fa\u63d0\u793a\u6587\u5b57\uff0c\u8fd9\u6837\u4e00\u4e0b\u5b50\u5c31\u53cb\u597d\u591a\u4e86\uff0c\u6ce8\u610f\u6587\u7ae0\u4e2d\u4ee3\u7801\u65b9\u9762\u6211\u5e76\u672a\u7ed9\u51facss\u6837\u5f0f\uff0c\u6240\u4ee5\u7f8e\u89c2\u5ea6\u4e0a\u9700\u8981\u81ea\u884c\u4f18\u5316\u3002<\/p>\n
\u5220\u9664<\/strong><\/p>\n
\u5220\u9664\u5c31\u7b80\u5355\u4e86\uff0c\u5224\u65ad\u662f\u5426\u5b58\u5728\u5907\u4efd\uff0c\u4e0d\u5b58\u5728\u5c31\u544a\u8bc9\u7528\u6237\u4e0d\u7528\u5220\u4e86\uff0c\u4f60\u538b\u6839\u5c31\u6ca1\u6709\u5907\u4efd\u6570\u636e\uff0c\u5982\u679c\u6709\u5907\u4efd\u5c31\u6267\u884c\u5220\u9664\u8bed\u53e5\uff0c\u53d1\u51fa\u63d0\u793a\u3002<\/p>\n
\u4e00\u4e9b\u6ca1\u7528\u7684\u8bf4\u660e<\/strong><\/p>\n
1\uff0c\u5176\u5b9e\u8fd9\u4e1c\u897f\u5e94\u8be5\u53ef\u4ee5\u5199\u6210\u61d2\u4eba\u7248\u7684\uff0c\u6a21\u677f\u540d\u5b57\u4ec0\u4e48\u7684\u7528php\u83b7\u53d6\u4e0b\uff0c\u5c31\u4e0d\u7528\u6211\u8fd9\u6837\u5199\u6b7b\u4e86\uff0c\u4f46\u662f\u5f53\u65f6\u6211\u5904\u4e8e\u8bd5\u4e00\u8bd5\u7684\u5fc3\u6001\u5199\u7684\uff0c\u6240\u4ee5\u5c31\u80fd\u7b80\u5355\u5c31\u7b80\u5355\u4e86\uff0c\u73b0\u5728\u53c8\u61d2\u5f97\u5f04\u4e86\uff0c\u8981\u4e0d\u662f\u4e3a\u4e86\u6c34\u6587\uff0c\u8fd9\u4e2a\u6211\u90fd\u61d2\u5f97\u8d34\u51fa\u6765\u3002<\/p>\n
2\uff0c\u522b\u770b\u6587\u7ae0\u4e2d\u4ee3\u7801\u8fd9\u4e48\u4e71\uff0c\u6761\u4f8b\u5c31\u4e0d\u6e05\u6670\uff0c\u5176\u5b9e\u6211\u5f53\u65f6\u627e\u4e86\u5f20\u7eb8\u5199\u7684\u903b\u8f91\u7136\u540e\u624d\u6309\u7167\u987a\u5e8f\u4e00\u6b65\u4e00\u6b65\u7684\u5199\u7684\uff0c\u4e5f\u6d4b\u8bd5\u4e86\u5f88\u591a\u56de\u3002<\/p>\n
3\uff0c\u6700\u5f00\u59cb\u60f3\u5199\u81ea\u52a8\u8fd8\u539f\u6a21\u677f\u6570\u636e\u6765\u7740\uff0c\u5c31\u662f\u68c0\u6d4b\u5230\u6a21\u677f\u542f\u7528\u5c31\u81ea\u52a8\u8fd8\u539f\u66fe\u7ecf\u7684\u5907\u4efd\u6570\u636e\uff0c\u7136\u800c\u5f53\u65f6\u60f3\u4e0d\u901a\u5982\u679c\u53bb\u5224\u65ad\u6a21\u677f\u542f\u7528\u3002<\/p>\n
4\uff0c\u5f53\u4f60\u60f3\u5c06\u672c\u6587\u7ae0\u4ee3\u7801\u6295\u5165\u4f7f\u7528\u65f6\uff0c\u6700\u597d\u518d\u6d4b\u8bd5\u535a\u5ba2\u8fdb\u884c\u6d4b\u8bd5\uff0c\u4ee5\u514d\u4f24\u5bb3\u4f60\u7684\u6570\u636e\u5e93\uff0c\u540c\u65f6\u5efa\u8bae\u6d4b\u8bd5\u65f6\u6253\u5f00\u6570\u636e\u5e93\u7ba1\u7406\u9875\u9762\uff0c\u89c2\u770b\u6570\u636e\u5e93\u5bf9\u5e94\u8868\u7684\u53d8\u5316<\/p>\n
\u7f51\u9875\u4e0b\u8f7d\uff08\u9632\u4ee3\u7801\u4e22\u5931\uff09\uff1a<\/h2>\n
<\/i><\/div>
\r\n            
\r\n                
\u5907\u7528\u7f51\u9875<\/h2>\r\n                
\r\n                    \u63d0\u53d6\u7801\uff1a\u65e0\r\n                <\/div>\r\n                
\r\n                    \u89e3\u538b\u7801\uff1a\u65e0\r\n                <\/div>\r\n            <\/div>\r\n            
\u4e0b\u8f7d<\/a><\/div>\r\n        <\/div><\/div>\n
\u8fd9\u4e2a\u4e3b\u9898\u5c31\u4f7f\u7528\u4e86\u8fd9\u4e2a\u529f\u80fd<\/p>\n
\r\n        \r\n        \"Typecho\u6a21\u677f\u8bbe\u7f6e\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d-Npcink\"<\/picture>\r\n        <\/span>
\r\n            \r\n            \"Typecho\u6a21\u677f\u8bbe\u7f6e\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d-Npcink\"<\/picture>\r\n            <\/a>\r\n        <\/div><\/a><\/a>
\r\n                
Photograph - \u7cbe\u81f4\u7684Typecho\u76f8\u518c\u4e3b\u9898<\/a><\/h2>\r\n                
\r\n                    
\"Typecho\u6a21\u677f\u8bbe\u7f6e\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d-Npcink\"Muze<\/a><\/div>\r\n                    
    \r\n                        
  • \r\n                            
  • \r\n                            <\/i>\u559c\u6b22\uff1a<\/span>0\r\n                        <\/li>\r\n                        
  • \r\n                            <\/i>\u6d4f\u89c8\uff1a<\/span>12.2k\r\n                        <\/li>\r\n                    <\/ul>\r\n                <\/div>\r\n            <\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
    \u7ed9Typecho\u5f00\u53d1\u4e3b\u9898\u65f6\uff0c\u53ef\u4ee5\u6dfb\u52a0\u4e00\u4e2a\u529f\u80fd<\/p>\n","protected":false},"author":1,"featured_media":6720,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[227],"tags":[],"collection":[],"class_list":["post-6726","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-typecho"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/posts\/6726"}],"collection":[{"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/comments?post=6726"}],"version-history":[{"count":0,"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/posts\/6726\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/media\/6720"}],"wp:attachment":[{"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/media?parent=6726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/categories?post=6726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/tags?post=6726"},{"taxonomy":"collection","embeddable":true,"href":"https:\/\/www.npc.ink\/wp-json\/wp\/v2\/collection?post=6726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}