{"id":233074,"date":"2023-02-04T14:00:00","date_gmt":"2023-02-04T11:00:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=233074"},"modified":"2023-02-04T14:00:49","modified_gmt":"2023-02-04T11:00:49","slug":"kuinka-laehettaeae-automaattisesti-yksi-blogiviesti-sosiaalisiin-verkostoihin-universaali-ratkaisu-ifttt-n-ja-crontabin-kanssa","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/fi\/kuinka-laehettaeae-automaattisesti-yksi-blogiviesti-sosiaalisiin-verkostoihin-universaali-ratkaisu-ifttt-n-ja-crontabin-kanssa\/","title":{"rendered":"Kuinka l\u00e4hett\u00e4\u00e4 automaattisesti yksi blogiviesti sosiaalisiin verkostoihin? Universaali ratkaisu IFTTT:n ja Crontabin kanssa"},"content":{"rendered":"\n

Viestien s\u00e4\u00e4nn\u00f6llinen l\u00e4hett\u00e4minen sosiaalisiin verkostoihin auttaa lis\u00e4\u00e4m\u00e4\u00e4n sivuston liikennett\u00e4 tehokkaasti, esim. Facebook<\/a>, Twitter<\/a>, Tumblr<\/a>. On varmasti hyv\u00e4, jos voimme automatisoida t\u00e4m\u00e4n prosessin. IFTTT<\/a> :n ja crontabin k\u00e4yt\u00f6n ansiosta t\u00e4m\u00e4 on helppoa.<\/p>\n

IFTTT Maker Channel<\/h2>\n

Maker-kanava IFTTT:ss\u00e4 voidaan laukaista "vastaanottamalla verkkopyynt\u00f6", ja se tukee enint\u00e4\u00e4n kolmea parametria eli arvo1, arvo2 ja arvo3 JSON<\/a> -muodossa. Voit esimerkiksi kutsua SayHi-tapahtuman kahdella parametrilla {"arvo1\u2033:"Hei","arvo2\u2033:"Computing"}.<\/p>\n

curl -X POST -H \"Content-Type: application\/json\" -d '{\"value1\":\"Hello\",\"value2\":\"Computing\"}' <a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/maker.ifttt.com\/trigger\/{SayHi}\/with\/key\/REPLACE_KEY\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>maker<\/span><span>.<\/span><span>ifttt<\/span><span>.<\/span><span>com<\/span><span>\/<\/span><span>trigger<\/span><span>\/{<\/span><span>SayHi<\/span><span>}\/<\/span><span>with<\/span><span>\/<\/span><span>key<\/span><span>\/<\/span><span>REPLACE<\/span><span>_<\/span><span>KEY<\/span><\/a><\/code><\/pre>\n
L\u00e4hett\u00e4minen sosiaaliseen verkostoon IFTTT:n kautta<\/h2>\n
On yksinkertaista luoda uusi sovelma (IFTTT-<\/a> s\u00e4\u00e4nt\u00f6) Makerin ja valitsemasi sosiaalisen verkoston, esim. Facebookin<\/a>, avulla. Sinun on my\u00f6s m\u00e4\u00e4ritett\u00e4v\u00e4 tapahtuman nimi, jotta Maker toimii (joka on IFTTT:n "t\u00e4m\u00e4" osa).<\/p>\n
maker-vastaanota-web-pyynt\u00f6<\/p>\n
Sitten sinun on m\u00e4\u00e4ritett\u00e4v\u00e4 toiminto (joka on IFTTT<\/a> :n "se" osa ).<\/p>\n
\"Kuinka<\/a><\/p>\n
arvo1-, arvo2- ja arvo3-parametrien valmistaja-konfiguraatio<\/p>\n
Automaattinen PHP-skripti<\/h2>\n
Nyt voimme kirjoittaa PHP-skriptin automatisoimaan t\u00e4m\u00e4n: valitse viesti (esim. satunnainen tai tunnuksella), jota ei ole l\u00e4hetetty viimeisten esim. 90 p\u00e4iv\u00e4n aikana, laita linkki tietokantaan ja kutsu Maker-kanava, joka k\u00e4ynnist\u00e4\u00e4 s\u00e4\u00e4nn\u00f6n. l\u00e4hett\u00e4\u00e4ksesi valitsemaasi sosiaaliseen verkostoon.<\/p>\n
Jos valitsemme WordPressiss\u00e4 satunnaisen viestin, PHP-skripti<\/a> on jotain t\u00e4llaista:<\/p>\n
<?php\n\u00a0 \/\/ <a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/helloacm.com\/how-to-prevent-script-running-from-browsers\/\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>helloacm<\/span><span>.<\/span><span>com<\/span><span>\/<\/span><span>how<\/span><span>-<\/span><span>to<\/span><span>-<\/span><span>prevent<\/span><span>-<\/span><span>script<\/span><span>-<\/span><span>running<\/span><span>-<\/span><span>from<\/span><span>-<\/span><span>browsers<\/span><span>\/<\/span><\/a>\n\u00a0 require('deny-from-web.php'); \/\/ avoid calling from the web URL, \n\u00a0 require('db.php'); \u00a0\n\u00a0 $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, \"blog_database\");\n\u00a0 $today = date(\"Y-m-d h:i:s\");\n\u00a0 $query = \"select \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` = 'post') and \n \u00a0 \u00a0 \u00a0 \u00a0(`post_status` = 'publish')\n \u00a0\";\n\u00a0 $result = mysqli_query($connection, $query);\n\u00a0 $row = mysqli_fetch_row($result);\n\u00a0 $total = $row[0];\n\u00a0 $cnt = 0;\n\u00a0 if ($total > 0) {\n\u00a0 \u00a0 while (1) {\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`, `ID`, `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` = '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 = mysqli_query($connection, $query);\n\u00a0 \u00a0 \u00a0 $row = mysqli_fetch_array($result);\n\u00a0 \u00a0 \u00a0 $url = \"<a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/helloacm.com\/\".$row['post_name\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>helloacm<\/span><span>.<\/span><span>com<\/span><span>\/\".$<\/span><span>row<\/span><span>['<\/span><span>post<\/span><span>_<\/span><span>name<\/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 = mysqli_query($connection, $query2);\n\u00a0 \u00a0 \u00a0 if (mysqli_num_rows($result2) > 0) {\n\u00a0 \u00a0 \u00a0 \u00a0 $lastrow = mysqli_fetch_row($result2);\n\u00a0 \u00a0 \u00a0 \u00a0 $last = $lastrow[0];\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) {\/\/ 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;\n\u00a0 \u00a0 \u00a0 \u00a0 }\n\u00a0 \u00a0 \u00a0 }\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 mysqli_query($connection, $query);\n\u00a0 \u00a0 \u00a0 $msg = $title; \u00a0 \u00a0 \u00a0\n\u00a0 \u00a0 \u00a0 $value1 = $url;\n\u00a0 \u00a0 \u00a0 $value2 = $title;\n\u00a0 \u00a0 \u00a0 echo \"value2 = \". $value2. \" n\";\n\u00a0 \u00a0 \u00a0 echo \"value1 = \". $value1. \" n\"; \u00a0 \u00a0 \u00a0 \u00a0 \n\u00a0 \u00a0 \u00a0 \/\/ invoke the IFTTT Maker Channel \u00a0 \u00a0\n\u00a0 \u00a0 \u00a0 shell_exec(\"curl -s -X POST -H \"Content-Type: application\/json\" -d '{\"value1\":\"$value1\",\"value2\":\"$value2\"}' <a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/maker.ifttt.com\/trigger\/{justyy}\/with\/key\/YOUR_KEY\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>maker<\/span><span>.<\/span><span>ifttt<\/span><span>.<\/span><span>com<\/span><span>\/<\/span><span>trigger<\/span><span>\/{<\/span><span>justyy<\/span><span>}\/<\/span><span>with<\/span><span>\/<\/span><span>key<\/span><span>\/<\/span><span>YOUR<\/span><span>_<\/span><span>KEY<\/span><\/a>\");\n\u00a0 \u00a0 \u00a0 break;\n\u00a0 \u00a0 }\n\u00a0 }\n\u00a0 echo \"Done!n\";<\/code><\/pre>\n
Jotta yll\u00e4 oleva toimisi, sinun on luotava taulukko l\u00e4hetettyjen artikkelien tallentamiseen (MySQL<\/a> :n kautta ):<\/p>\n
--\n-- Table structure for table `twitter`\n--\n\nCREATE TABLE `twitter` (`id` bigint(32) NOT NULL,\n  `url` varchar(255) NOT NULL,\n  `posttime` date NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;\n\n--\n-- Indexes for dumped tables\n--\n\n--\n-- Indexes for table `twitter`\n--\nALTER TABLE `twitter`\n  ADD PRIMARY KEY (`id`),\n  ADD KEY `urla` (`url`),\n  ADD KEY `dd` (`posttime`);\n\n--\n-- AUTO_INCREMENT for dumped tables\n--\n\n--\n-- AUTO_INCREMENT for table `twitter`\n--\nALTER TABLE `twitter`\n  MODIFY `id` bigint(32) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;<\/code><\/pre>\n
Crontab-m\u00e4\u00e4ritykset automaattista blogikirjoitusta varten<\/h2>\n
Viimeinen vaihe yll\u00e4 olevan skriptin testaamisen j\u00e4lkeen on PHP-komennon<\/a> lis\u00e4\u00e4minen crontab<\/a> – t\u00f6ihin. Voit m\u00e4\u00e4ritt\u00e4\u00e4 taajuuden esim. @daily tai @weekly, @monthly jne.<\/p>\n
@daily php \/path-to-your-script\/ifftt-post-blog.php<\/code><\/pre>\n
:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Kuinka l\u00e4hett\u00e4\u00e4 automaattisesti yksi blogiviesti sosiaalisiin verkostoihin? Universaali ratkaisu IFTTT:n ja Crontabin kanssa<\/p>\n","protected":false},"author":1,"featured_media":224083,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[782,750,1018,719,895,813,834,843,864],"tags":[1166],"class_list":["post-233074","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-avoimen-laehdekoodin-ohjelmisto","category-avoin-laehdekoodi","category-hyodyllisia-sivustoja","category-kehittaejae","category-koodi","category-laajennuksia","category-opas-aloittelijoille","category-opetusohjelmia","category-wordpress-5","tag-affiai-fi"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts\/233074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/comments?post=233074"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts\/233074\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/media\/224083"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/media?parent=233074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/categories?post=233074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/tags?post=233074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}