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
  • Save Onasusweb/d57a409d5f866c553786 to your computer and use it in GitHub Desktop.
Save Onasusweb/d57a409d5f866c553786 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.php
<?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')");
}
}
}
}
}
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment