{"id":232995,"date":"2023-02-02T09:58:00","date_gmt":"2023-02-02T06:58:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232995"},"modified":"2023-02-07T13:05:27","modified_gmt":"2023-02-07T10:05:27","slug":"kuinka-luoda-ranking-sivu-wordpressissae-gd-star-rating-laajennuksen-perusteella","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/fi\/kuinka-luoda-ranking-sivu-wordpressissae-gd-star-rating-laajennuksen-perusteella\/","title":{"rendered":"Kuinka luoda ranking-sivu WordPressiss\u00e4 GD Star Rating -laajennuksen perusteella?"},"content":{"rendered":"

GD Star Rating Plugin<\/a> on kuuluisa laajennus, jonka avulla lukijat (ilman kirjautumista tai rekister\u00f6itymist\u00e4) voivat antaa pisteit\u00e4 artikkeleille, viesteille, sivuille ja jopa kommenteille.<\/p>\n

Siksi voi olla hy\u00f6dyllist\u00e4 asettaa luokitukset paremmuusj\u00e4rjestykseen ja n\u00e4hd\u00e4, mitk\u00e4 viestit ovat suosittuja. Esimerkiksi t\u00e4m\u00e4n sivun<\/a> toisessa taulukossa n\u00e4kyv\u00e4t arvosanat sijoituksen mukaan.<\/p>\n

T\u00e4llaisen sivun luomiseksi tarvitset WordPress-laajennuksen, joka sis\u00e4lt\u00e4\u00e4 PHP-koodin sivuille\/viesteille. Voit etsi\u00e4 "Sis\u00e4llyt\u00e4 HTML ja PHP" ja lis\u00e4t\u00e4 laajennuksen.<\/p>\n

Kun olet tehnyt t\u00e4m\u00e4n, luo uusi sivu (Viesti on OK) ja laita seuraava:<\/p>\n

Sis\u00e4llyt\u00e4 GD Star Rating Rank -sivu<\/p>\n

Siirry sitten wordpress-teeman kansioon ja luo top.php<\/strong> yll\u00e4 m\u00e4\u00e4ritetyll\u00e4 tavalla.<\/p>\n

<?php\n\u00a0 global $wpdb;\n\u00a0 $query = \"\n \u00a0 \u00a0 \u00a0SELECT \n \u00a0 \u00a0 \u00a0 \u00a0`p`.`ID`, \n \u00a0 \u00a0 \u00a0 \u00a0`p`.`post_name` as `name`, \n \u00a0 \u00a0 \u00a0 \u00a0`p`.`post_title` as `title`, \n \u00a0 \u00a0 \u00a0 \u00a0`visitor_votes` + `user_votes` as `total_votes`, \n \u00a0 \u00a0 \u00a0 \u00a0`visitor_votes`, \n \u00a0 \u00a0 \u00a0 \u00a0`user_votes` \u00a0\n \u00a0 \u00a0 \u00a0FROM \u00a0`\".$wpdb->prefix.\"gdsr_data_article` as `da` \n \u00a0 \u00a0 \u00a0 \u00a0INNER JOIN $wpdb->posts as `p` ON `da`.`post_id` = `p`.`ID` \n \u00a0 \u00a0 \u00a0having\n \u00a0 \u00a0 \u00a0 \u00a0`total_votes` > 0\n \u00a0 \u00a0 \u00a0order by \n \u00a0 \u00a0 \u00a0 \u00a0`total_votes` desc \n \u00a0 \u00a0 \u00a0limit 20\n \u00a0\";\n\u00a0 $results = $wpdb->get_results($query);\n\u00a0 if ($results) { \n\u00a0 \u00a0 \u00a0 \u00a0 $position = 0;\n\u00a0 \u00a0 \u00a0 \u00a0 foreach ($results as $toppost) {\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $position++; \n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 echo \"#\".$position.\"<a title='\".htmlentities($toppost->title, ENT_QUOTES).\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \"' href='\/archives\/\".($toppost->ID).\"\/'>\".$toppost->title.\"<\/a> - \".\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ($toppost->total_votes).\" <BR>\";\n\u00a0 \u00a0 \u00a0 \u00a0 }\n\u00a0 }\n?><\/code><\/pre>\n
Sinun on ehk\u00e4 s\u00e4\u00e4dett\u00e4v\u00e4 wordpress-viestien URL-lomakkeita, jos ne ovat erilaisia, paitsi t\u00e4ss\u00e4 n\u00e4kyv\u00e4.<\/p>\n
\"Kuinka<\/a><\/p>\n
WordPressin pysyv\u00e4n linkin asetukset<\/p>\n
:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Kuinka luoda sijoitussivu WordPressiss\u00e4 GD Star Rating -laajennuksen perusteella?<\/p>\n","protected":false},"author":1,"featured_media":224746,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[895,813,834,843,803,864],"tags":[1166],"class_list":["post-232995","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-koodi","category-laajennuksia","category-opas-aloittelijoille","category-opetusohjelmia","category-php-5","category-wordpress-5","tag-affiai-fi"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts\/232995","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=232995"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts\/232995\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/media\/224746"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/media?parent=232995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/categories?post=232995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fi\/wp-json\/wp\/v2\/tags?post=232995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}