Skip to content

Instantly share code, notes, and snippets.

@Onasusweb

Onasusweb/gist:d57a409d5f866c553786

Forked from tenisakb/gist:10865999
Last active August 29, 2015 14:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Onasusweb/d57a409d5f866c553786 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Onasusweb/d57a409d5f866c553786 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @tenisakb tenisakb created this gist Apr 16, 2014.
    267 changes: 267 additions & 0 deletions gistfile1.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,267 @@
    <?php
    /*header("Content-type: text/csv");
    header("Content-Disposition: attachment; filename=file.csv");
    header("Pragma: no-cache");
    header("Expires: 0");
    */

    function friendly_url($nadpis) {
    $url = $nadpis;
    $url = preg_replace('~[^\\pL0-9_]+~u', '-', $url);
    $url = trim($url, "-");
    $url = iconv("utf-8", "us-ascii//TRANSLIT", $url);
    $url = strtolower($url);
    $url = preg_replace('~[^-a-z0-9_]+~', '', $url);
    $polex = array ("a","b","c","d","e","f","g","h","ch","i","j","k","l","m","n","o","p","q","k","r","s","t","v","u","w","ai","bi","ci","di","ei","fi","gi","hi","chi","ii","ji","ki","li","mi","ni","oi","pi","qi","ki","ri","si","ti","vi","ui","wi","ax","bx","cx","dx","ex","fx","gx","hx","chx","ix","jx","kx","lx","mx","nx","ox","px","qx","kx","rx","sx","tx","vx","ux","wx");
    $rax=rand(0,74);
    $raxi=rand(0,74);
    $raxii=rand(0,74);
    return $url.$polex[$rax].$polex[$raxi].$polex[$raxii];
    }

    ?>id;"Active (0/1)";Name*;"Parent Category";"Root category (0/1)";Description;Meta-title;Meta-keywords;Meta-description;"URL rewritten";"Image URL";"ID ou nom de la boutique"
    <?php
    $db_server='localhost';
    $db_login='kategorieaut';
    $db_password='kategorieaut';
    $db_name='kategorieaut';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");

    $vysledeko_pred_predxxxxx = mysql_query("select * from kategorie__1 WHERE id='5'");
    while($zaz_pred_predsss = mysql_fetch_object($vysledeko_pred_predxxxxx)){
    $nazev_sql2_idross = $zaz_pred_predsss->id;
    $nazev_sql2_nazev_pred_pred_zeross = $zaz_pred_predsss->nazev;

    $db_server='localhost';
    $db_login='prestashop_auta';
    $db_password='prestashop_auta';
    $db_name='prestashop_auta';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");

    $nazscko=friendly_url($nazev_sql2_nazev_pred_pred_zeross);
    $xxxxxxmkmk = mysql_query("select * from ps_category_lang order by id_category DESC LIMIT 1");
    while($mkmssss = mysql_fetch_object($xxxxxxmkmk)){
    $naross = ($mkmssss->id_category)+1;
    }

    mysql_query("INSERT INTO ps_category_lang VALUES('$naross','1','2','$nazev_sql2_nazev_pred_pred_zeross','NULL','$nazscko','NULL','NULL','NULL')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross','1')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross','2')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross','3')");
    mysql_query("INSERT INTO ps_category_shop VALUES('$naross','1','1')");
    mysql_query("INSERT INTO ps_category VALUES('$naross','2','1','0','0','0','1','2014-04-13 01:04:06','2014-04-13 01:04:06','0','0')");






    $db_server='localhost';
    $db_login='kategorieaut';
    $db_password='kategorieaut';
    $db_name='kategorieaut';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");

    $vysledeko_pred_pred = mysql_query("select * from kategorie__2 where id_nadkategorie='$nazev_sql2_idross'");
    while($zaz_pred_pred = mysql_fetch_object($vysledeko_pred_pred)){
    $nazev_sql2_nazev_pred_pred = $zaz_pred_pred->nazev;
    $id_sql2_nazev_pred_pred = $zaz_pred_pred->id;
    $id_sql2_nazev_pred_pred_nadzero = $zaz_pred_pred->nazev;
    $id_sql2_nazev_pred_pred_nadzero = str_replace($nazev_sql2_nazev_pred_pred_zeross, '', $id_sql2_nazev_pred_pred_nadzero);

    $db_server='localhost';
    $db_login='prestashop_auta';
    $db_password='prestashop_auta';
    $db_name='prestashop_auta';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");
    $xxxxx2k = mysql_query("select * from ps_category_lang order by id_category DESC LIMIT 1");
    while($mkmssss = mysql_fetch_object($xxxxx2k)){
    $naross_2= $mkmssss->id_category;
    $naross_2=$naross_2+1;
    }
    $nazsc_2=friendly_url($id_sql2_nazev_pred_pred_nadzero);
    mysql_query("INSERT INTO ps_category_lang VALUES('$naross_2','1','2','$id_sql2_nazev_pred_pred_nadzero','NULL','$nazsc_2','NULL','NULL','NULL')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_2','1')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_2','2')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_2','3')");
    mysql_query("INSERT INTO ps_category_shop VALUES('$naross_2','1','1')");
    mysql_query("INSERT INTO ps_category VALUES('$naross_2','$naross','1','0','0','0','1','2014-04-13 01:04:06','2014-04-13 01:04:06','0','0')");





    $db_server='localhost';
    $db_login='kategorieaut';
    $db_password='kategorieaut';
    $db_name='kategorieaut';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");

    $vysledekossss = mysql_query("select * from kategorie__3 where id_nadkategorie='$id_sql2_nazev_pred_pred'");
    while($zaz_pxmld = mysql_fetch_object($vysledekossss)){
    $nazev_sqlred_pred = $zaz_pxmld->nazev;
    $id_sqred_pred = $zaz_pxmld->id;





    $db_server='localhost';
    $db_login='prestashop_auta';
    $db_password='prestashop_auta';
    $db_name='prestashop_auta';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");
    $xxxxx3k = mysql_query("select * from ps_category_lang order by id_category DESC LIMIT 1");
    while($mkm3ss = mysql_fetch_object($xxxxx3k)){
    $naross_3= $mkm3ss->id_category;
    $naross_3=$naross_3+1;
    }
    $nazsc_3=friendly_url($nazev_sqlred_pred);
    mysql_query("INSERT INTO ps_category_lang VALUES('$naross_3','1','2','$nazev_sqlred_pred','NULL','$nazsc_3','NULL','NULL','NULL')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_3','1')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_3','2')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_3','3')");
    mysql_query("INSERT INTO ps_category_shop VALUES('$naross_3','1','1')");
    mysql_query("INSERT INTO ps_category VALUES('$naross_3','$naross_2','1','0','0','0','1','2014-04-13 01:04:06','2014-04-13 01:04:06','0','0')");







    $db_server='localhost';
    $db_login='kategorieaut';
    $db_password='kategorieaut';
    $db_name='kategorieaut';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");

    $vysledxfours = mysql_query("select * from kategorie__4 where id_nadkategorie='$id_sqred_pred'");
    while($zaz_pfourd = mysql_fetch_object($vysledxfours)){
    $nazev_sfourd_pred = $zaz_pfourd->nazev;
    $id_sfourd_pred = $zaz_pfourd->id;



    $db_server='localhost';
    $db_login='prestashop_auta';
    $db_password='prestashop_auta';
    $db_name='prestashop_auta';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");
    $xxxxx4k = mysql_query("select * from ps_category_lang order by id_category DESC LIMIT 1");
    while($mkm4ss = mysql_fetch_object($xxxxx4k)){
    $naross_4= $mkm4ss->id_category;
    $naross_4=$naross_4+1;
    }
    $nazsc_4=friendly_url($nazev_sfourd_pred);
    mysql_query("INSERT INTO ps_category_lang VALUES('$naross_4','1','2','$nazev_sfourd_pred','NULL','$nazsc_4','NULL','NULL','NULL')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_4','1')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_4','2')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_4','3')");
    mysql_query("INSERT INTO ps_category_shop VALUES('$naross_4','1','1')");
    mysql_query("INSERT INTO ps_category VALUES('$naross_4','$naross_3','1','0','0','0','1','2014-04-13 01:04:06','2014-04-13 01:04:06','0','0')");






    $db_server='localhost';
    $db_login='kategorieaut';
    $db_password='kategorieaut';
    $db_name='kategorieaut';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");

    $vyslesssours = mysql_query("select * from kategorie__5 where id_nadkategorie='$id_sfourd_pred'");
    while($zaz_sxxsrd = mysql_fetch_object($vyslesssours)){
    $nazesssss_pred = $zaz_sxxsrd->nazev;
    $isssssspred = $zaz_sxxsrd->id;



    $db_server='localhost';
    $db_login='prestashop_auta';
    $db_password='prestashop_auta';
    $db_name='prestashop_auta';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");
    $xxxxx5k = mysql_query("select * from ps_category_lang order by id_category DESC LIMIT 1");
    while($mkm5ss = mysql_fetch_object($xxxxx5k)){
    $naross_5= $mkm5ss->id_category;
    $naross_5=$naross_5+1;
    }
    $nazsc_5=friendly_url($nazesssss_pred);
    mysql_query("INSERT INTO ps_category_lang VALUES('$naross_5','1','2','$nazesssss_pred','NULL','$nazsc_5','NULL','NULL','NULL')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_5','1')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_5','2')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_5','3')");
    mysql_query("INSERT INTO ps_category_shop VALUES('$naross_5','1','1')");
    mysql_query("INSERT INTO ps_category VALUES('$naross_5','$naross_4','1','0','0','0','1','2014-04-13 01:04:06','2014-04-13 01:04:06','0','0')");






    $db_server='localhost';
    $db_login='kategorieaut';
    $db_password='kategorieaut';
    $db_name='kategorieaut';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");

    $vyslmmrs = mysql_query("select * from kategorie__6 where id_nadkategorie='$isssssspred'");
    while($zaz_mmm = mysql_fetch_object($vyslmmrs)){
    $nazesmmmpred = $zaz_mmm->nazev;
    $immspred = $zaz_mmm->id;

    $db_server='localhost';
    $db_login='prestashop_auta';
    $db_password='prestashop_auta';
    $db_name='prestashop_auta';
    $spojeni=@MySQL_Connect($db_server ,$db_login, $db_password);
    @MySQL_Select_DB($db_name)or die('<p style="color: #CC0000">Nastala chyba v pripojeni k databazi');
    mysql_query("set names utf8");
    $xxxxx6k = mysql_query("select * from ps_category_lang order by id_category DESC LIMIT 1");
    while($mkm6ss = mysql_fetch_object($xxxxx6k)){
    $naross_6= $mkm6ss->id_category;
    $naross_6=$naross_6+1;
    }
    $nazsc_6=friendly_url($nazesmmmpred);
    mysql_query("INSERT INTO ps_category_lang VALUES('$naross_6','1','2','$nazesmmmpred','NULL','$nazsc_6','NULL','NULL','NULL')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_6','1')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_6','2')");
    mysql_query("INSERT INTO ps_category_group VALUES('$naross_6','3')");
    mysql_query("INSERT INTO ps_category_shop VALUES('$naross_6','1','1')");
    mysql_query("INSERT INTO ps_category VALUES('$naross_6','$naross_5','1','0','0','0','1','2014-04-13 01:04:06','2014-04-13 01:04:06','0','0')");


    }
    }
    }
    }
    }
    }


    ?>