{"id":232809,"date":"2023-01-29T17:48:00","date_gmt":"2023-01-29T14:48:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232809"},"modified":"2023-02-10T16:41:18","modified_gmt":"2023-02-10T13:41:18","slug":"jak-ozywic-stare-posty-za-pomoca-php-i-crontab-wordpress","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/pl\/jak-ozywic-stare-posty-za-pomoca-php-i-crontab-wordpress\/","title":{"rendered":"Jak o\u017cywi\u0107 stare posty za pomoc\u0105 PHP i Crontab (WordPress)"},"content":{"rendered":"\n

Za\u0142\u00f3\u017cmy, \u017ce masz sporo przyzwoitych post\u00f3w na swoim blogu i zastanawiasz si\u0119, czy istnieje spos\u00f3b na automatyczne i regularne publikowanie na Twitterze\/Facebooku (lub innych sieciach spo\u0142eczno\u015bciowych).<\/p>\n

To nie jest trudne. Chocia\u017c ten post poprowadzi Ci\u0119 do publikowania na Twitterze, ale zasada jest podobna w przypadku innych sieci spo\u0142eczno\u015bciowych. Ten post<\/a> przedstawia funkcj\u0119 PHP do publikowania na Twitterze.<\/p>\n

Nie chcemy publikowa\u0107 tej samej tre\u015bci\/artyku\u0142\u00f3w raz za razem w kr\u00f3tkim czasie. Dlatego musimy stworzy\u0107 tabel\u0119 SQL, kt\u00f3ra przechowuje histori\u0119 ponownie opublikowanych post\u00f3w.<\/p>\n

--\n-- Table structure for table `twitter`\n--\n\nCREATE TABLE IF NOT EXISTS `twitter` (`id` bigint(32) unsigned NOT NULL,\n  `url` varchar(255) NOT NULL,\n  `posttime` datetime NOT NULL) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;<\/code><\/pre>\n
Tabela ma trzy pola, jedno to klucz podstawowy (automatyczna inkrementacja), drugie pole to lokalizacja adresu URL, kt\u00f3ry zosta\u0142 ponownie opublikowany, a trzecie to data i godzina.<\/p>\n
Wszystkie pola powinny by\u0107 odpowiednio zaindeksowane.<\/p>\n
ALTER TABLE `twitter`\n ADD PRIMARY KEY (`id`), ADD KEY `url` (`url`,`posttime`), ADD KEY `posttime` (`posttime`);<\/code><\/pre>\n
Teraz, je\u015bli masz wordpress, musisz sprawdzi\u0107 prawid\u0142owe posty i losowo wybra\u0107 jeden.<\/p>\n
\u00a0 \/\/ database constants\n\u00a0 require('db.php');\n\u00a0 \/\/ twitter function\n\u00a0 require('twitter.php');\n\u00a0 mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die(mysql_error());\n\u00a0 mysql_select_db(DB_NAME);\n\u00a0 $today = date(\"Y-m-d h:i:s\");\n\u00a0 \/\/ get total number of valid posts\n\u00a0 $query = \"\n \u00a0 \u00a0 \u00a0select \n \u00a0 \u00a0 \u00a0 \u00a0count(1)\n \u00a0 \u00a0 \u00a0from \n \u00a0 \u00a0 \u00a0 \u00a0`wp_posts`\n \u00a0 \u00a0 \u00a0where \n \u00a0 \u00a0 \u00a0 \u00a0(`post_type` = 'page' or `post_type` = 'post') and \n \u00a0 \u00a0 \u00a0 \u00a0(`post_status` = 'publish')\n \u00a0\";\n\u00a0 $result = mysql_query($query) or die(mysql_error());\n\u00a0 $total = mysql_result($result, 0, 0);\n\u00a0 $cnt = 0;\n\u00a0 if ($total > 0) {\n\u00a0 \u00a0 while (1) {\n\u00a0 \u00a0 \u00a0 \/\/ pick a random npost\n\u00a0 \u00a0 \u00a0 $idx = mt_rand(0, $total - 1);\n\u00a0 \u00a0 \u00a0 $query = \"\n \u00a0 \u00a0 \u00a0 \u00a0select \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`post_name`, `post_title` \n \u00a0 \u00a0 \u00a0 \u00a0from \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`wp_posts`\n \u00a0 \u00a0 \u00a0 \u00a0where \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0(`post_type` = 'page' or `post_type` = 'post') and \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0(`post_status` = 'publish')\n \u00a0 \u00a0 \u00a0 \u00a0limit $idx, 1\n \u00a0 \u00a0 \u00a0\";\n\u00a0 \u00a0 \u00a0 $result = mysql_query($query) or die(mysql_error());\n\u00a0 \u00a0 \u00a0 $row = mysql_fetch_array($result);\n\u00a0 \u00a0 \u00a0 \/\/ post URL\n\u00a0 \u00a0 \u00a0 $url = \"<a class=\"vglnk\" target=\"_blank\" href=\"http:\/\/www.codingforspeed.com\/\".$row['post_name'].\"\/\" rel=\"nofollow\"><span>http<\/span><span>:\/\/<\/span><span>www<\/span><span>.<\/span><span>codingforspeed<\/span><span>.<\/span><span>com<\/span><span>\/\".$<\/span><span>row<\/span><span>['<\/span><span>post<\/span><span>_<\/span><span>name<\/span><span>'].\"\/<\/span><\/a>\";\n\u00a0 \u00a0 \u00a0 $title = $row['post_title'];\n\u00a0 \u00a0 \u00a0 $query2 = \"select date(`posttime`) from `twitter` where `url` = '$url' order by `posttime` desc limit 1\";\n\u00a0 \u00a0 \u00a0 $result2 = mysql_query($query2) or die(mysql_error());\n\u00a0 \u00a0 \u00a0 if (mysql_num_rows($result2) > 0) {\n\u00a0 \u00a0 \u00a0 \u00a0 $last = mysql_result($result2, 0, 0);\n\u00a0 \u00a0 \u00a0 \u00a0 \/\/ last reposted date\/time\n\u00a0 \u00a0 \u00a0 \u00a0 $diff = abs((strtotime($today) - strtotime($last)) \/ 24 \/ 3600);\n\u00a0 \u00a0 \u00a0 \u00a0 if ($diff <= 90) {\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $cnt ++;\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if ($cnt > 16) { \/\/ max retry time to avoid endless loop\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 break;\u00a0 \n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 continue; \/\/ try next random post\n\u00a0 \u00a0 \u00a0 \u00a0 }\n\u00a0 \u00a0 \u00a0 }\n\u00a0 \u00a0 \u00a0 \/\/ record the post in the table\n\u00a0 \u00a0 \u00a0 $query = \"\n \u00a0 \u00a0 \u00a0 \u00a0insert into `twitter`\n \u00a0 \u00a0 \u00a0 \u00a0set \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`url` = '$url',\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`posttime` = '$today'\n \u00a0 \u00a0 \u00a0\";\n\u00a0 \u00a0 \u00a0 mysql_query($query) or die(mysql_error());\n\u00a0 \u00a0 \u00a0 $msg = \"#Repost \".$title;\n\u00a0 \u00a0 \u00a0 echo \"$msg $url\";\n\u00a0 \u00a0 \u00a0 postTwitter($msg, $url);\n\u00a0 \u00a0 \u00a0 break;\n\u00a0 \u00a0 }\n\u00a0 }<\/code><\/pre>\n
Chodzi o to, aby uzyska\u0107 losowy post i sprawdzi\u0107, czy zosta\u0142 ponownie opublikowany w ci\u0105gu ostatnich 90 dni (w razie potrzeby zmie\u0144), je\u015bli nie, opublikuj go i zapisz w bazie danych. W przeciwnym razie wypr\u00f3buj kolejne losowe posty, dop\u00f3ki nie zostanie wypr\u00f3bowanych kilka razy. Je\u015bli nie zostan\u0105 znalezione takie \u201eprawid\u0142owe" posty (np. brak nowych artyku\u0142\u00f3w od d\u0142u\u017cszego czasu), to wykryje to i porzuci p\u0119tl\u0119.<\/p>\n
Sprawd\u017a r\u00f3wnie\u017c ten post<\/a>, aby uzyska\u0107 losowy wiersz za pomoc\u0105 SQL.<\/p>\n
Nast\u0119pn\u0105 rzecz\u0105 jest odpowiednie przetestowanie i umieszczenie w crontab<\/a><\/strong> np. raz dziennie.<\/p>\n
0 8 * * * php \/home\/justyy.lai\/auto.php > \/dev\/null 2>&1<\/code><\/pre>\n
Wiadomo\u015b\u0107 publikowan\u0105 na Twitterze mo\u017cna dostosowa\u0107 i doda\u0142em tag hash \u201e#Repost”, aby odr\u00f3\u017cni\u0107 od innych normalnych post\u00f3w. \u0141\u0105cz\u0119 r\u00f3wnie\u017c moje konto na Twitterze ze stron\u0105 na Facebooku, aby za ka\u017cdym razem, gdy twittery s\u0105 publikowane na Twitterze, strona na Facebooku status jest r\u00f3wnie\u017c synchronizowany, co jest dla mnie du\u017co \u0142atwiejsze.<\/p>\n
\u0179r\u00f3d\u0142o nagrywania:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Jak o\u017cywi\u0107 stare posty za pomoc\u0105 PHP i Crontab<\/p>\n","protected":false},"author":1,"featured_media":220869,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[679,897,997,805,836,845,866],"tags":[1169],"class_list":["post-232809","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blogowac","category-kod","category-marketing-tresci","category-php-7","category-przewodnik-dla-poczatkujacych","category-samouczki","category-wordpress-7","tag-affiai-pl"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/posts\/232809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/comments?post=232809"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/posts\/232809\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/media\/220869"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/media?parent=232809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/categories?post=232809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/pl\/wp-json\/wp\/v2\/tags?post=232809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}