{"id":99,"date":"2007-10-21T21:22:57","date_gmt":"2007-10-21T19:22:57","guid":{"rendered":"http:\/\/tricker.cz\/?p=99"},"modified":"2007-10-21T21:22:57","modified_gmt":"2007-10-21T19:22:57","slug":"xml-feed-z-oscommerce-pro-jyxocz","status":"publish","type":"post","link":"https:\/\/tricker.cz\/?p=99","title":{"rendered":"XML feed produkt\u016f z osCommerce pro Jyxo.cz"},"content":{"rendered":"<p>Proto\u017ee jsem si do WordPressu (kdy\u017e u\u017e jsem ho op\u011bt aktualizoval) cht\u011bl p\u0159idat zv\u00fdraz\u0148ov\u00e1n\u00ed syntaxe pro kusy k\u0102\u0142du (HTML, CSS, JS, MySQL, Python, Perl&#8230;), tak jsem si tam taky p\u0159idal <a href=\"http:\/\/wordpress.org\/extend\/plugins\/wp-syntax\/\">takov\u00fd plugin<\/a>, co to umo\u017e\u0148uje. Co by ne! Kdy\u017e si tam budu cht\u00edt p\u0159idat plugin, kter\u00fd mi v administraci po p\u0159ihl\u00e1\u0161en\u00ed zobraz\u00ed fotku m\u00e9ho pr\u00e1deln\u00edho ko\u0161e, tak si takov\u00fd plugin t\u0159ebas ud\u011bl\u00e1m. Co by ne!<\/p>\n<p>Ka\u017edop\u00e1dn\u011b&#8230; kdy\u017e u\u017e jsem ten plugin p\u0159idal, tak ho mus\u00edm na n\u011b\u010dem tak\u00e9 ozkou\u0161et a nejl\u00e9pe na n\u011b\u010dem, co publikuji. Pokud by tedy n\u00e1hodou n\u011bkdo pot\u0159eboval skript, kter\u00fd mu vygeneruje XML feed ze v\u0161ech produkt\u016f ze slepence je\u017e se zove osCommerce, zde jest. Tento feed na\u010dte Jyxo.cz (a pravd\u011bpodobn\u011b tak\u00e9 Seznam.cz). Sta\u010d\u00ed ho vlo\u017eit do ko\u0159enov\u00e9ho adres\u00e1\u0159e katalogu, pro jistotu zkontrolovat v\u00fdsledek a pot\u00e9 klidn\u011b pou\u017e\u00edvat.<\/p>\n<p>Mo\u017en\u00e1, \u017ee \u010dasem p\u0159id\u00e1m i n\u011bco d\u016fmysln\u011bj\u0161\u00edho a v\u00edce o\u0161et\u0159en\u00e9ho, ne\u017e jen tuto p\u00e1r let starou z\u00e1le\u017eitost. Jo a co se t\u00fdk\u00e1 p\u0159\u00edpadn\u00fdch autorsk\u00fdch pr\u00e1v, pak je mi \u0161um\u00e1k jak budete tenhle skript\u00edk kop\u00edrovat, pozm\u011b\u0148ovat a u\u017e\u00edvat (skript se zobraz\u00ed po rozkliknut\u00ed cel\u00e9ho p\u0159\u00edsp\u011bvku).<\/p>\n<p><!--more--><\/p>\n<pre line=\"1\" lang=\"php\">\n< ?php\n\n  \/*\n   * @author (c) Michal \"MultiTricker\" \u0139\u00a0ev\u010d\u00edk\n   * @link http:\/\/multi.tricker.cz - multi@tricker.cz\n   * @description Feed soubor pro Jyxo.cz a seznam.cz\n   * @lastchange 15.12.2005 13:31:34\n  *\/\n\n  \/\/ hlavicka\n  header (\"Content-type: text\/xml\");\n  echo \"\"; \n\n  \/\/ konfigurak osCommerce\n  require \"includes\/configure.php\";\n\n  \/\/ pripojeni k DB\n  MySQL_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD);\n  MySQL_select_db(DB_DATABASE);\n\n  \/\/ kam odkazovat\n  $cesta = HTTP_SERVER;\n\n  \/\/ pripadne doplnime lomitko...\n  if(substr($cesta, -1) != \"\/\"){ $cesta .= \"\/\"; }\n\n  echo \"\";\n\n  \/\/ hlavne jednoduse\n$query = MySQL_query(\"SELECT products.products_id AS pid, products.products_image,\n                             products.products_price,\n                             products_description.products_id AS did,\n                             products_description.products_name, products_description.products_description\n                        FROM products, products_description\n                       WHERE products.products_id=products_description.products_id\");\n\n  \/\/ zpracujeme\n  while($r = MySQL_fetch_assoc($query))\n  {\n\n  \/\/ orizneme, zaokrouhlime\n  $r['products_description'] = strip_tags($r['products_description']);\n  $r['products_price'] = round($r['products_price']);\n\n  \/\/ podomacku \"inteligentne \"zkrouhneme popis produktu\n  $temp_p=160; $temp_je=0;\n  if(strlen($r['products_description']) <= $temp_p){$temp_je=1; $temp_p=500;}\n  while($temp_je == 0)\n  {\n    if(substr($r['products_description'], $temp_p, 1) == \".\")\n    { $temp_je = 1; $temp_p = $temp_p+1; }\n    else\n    { $temp_p++; }\n  }\n  $r['products_description'] = substr($r['products_description'], 0, $temp_p);\n\n    \/\/ a vypisujem\n    echo \"\n\".iconv(\"windows-1250\", \"UTF-8\", $r['products_name']).\"\n      \".iconv(\"windows-1250\", \"UTF-8\", $r['products_description']).\"\n      \".$cesta.\"product_info.php?products_id=\".$r['pid'].\"\n      \".$cesta.\"images\/\".rawurlencode($r['products_image']).\"\n\".$r['products_price'].\"\n\".round($r['products_price'] * 1.19).\"\n\n    \";\n\n  }\n\n \/\/ konec\n echo \"\";\n\n?><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Proto\u017ee jsem si do WordPressu (kdy\u017e u\u017e jsem ho op\u011bt aktualizoval) cht\u011bl p\u0159idat zv\u00fdraz\u0148ov\u00e1n\u00ed syntaxe pro kusy k\u0102\u0142du (HTML, CSS, JS, MySQL, Python, Perl&#8230;), tak jsem si tam taky p\u0159idal takov\u00fd plugin, co to umo\u017e\u0148uje. Co by ne! Kdy\u017e si&#8230; <a class=\"more-link\" href=\"https:\/\/tricker.cz\/?p=99\">Pokra\u010dovat ve \u010dten\u00ed &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[10,11,12,13,17],"_links":{"self":[{"href":"https:\/\/tricker.cz\/index.php?rest_route=\/wp\/v2\/posts\/99"}],"collection":[{"href":"https:\/\/tricker.cz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tricker.cz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tricker.cz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tricker.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=99"}],"version-history":[{"count":0,"href":"https:\/\/tricker.cz\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions"}],"wp:attachment":[{"href":"https:\/\/tricker.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tricker.cz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tricker.cz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}