Jump to content
php.lv forumi

So sick!

Reģistrētie lietotāji
 View Profile  See their activity

  • Posts

    67

  • Joined

  • Last visited

 Content Type 

Posts posted by So sick!

  13. OpenCart satura izvade XML

    in Gatavi skripti

    Posted · Edited by So sick!

    Šo fīču taisīju vienam interneta veikalam, taču, tas interneta veikals vairs nepastāv un tāpēc izdomāju publicēt šo skriptiņu.. nekas liels, bet nu.. gatavs skriptiņš :)

    <?php
header("Content-type: text/xml");
// Settings
$website = 'veikals.lv';
// Connection
$link = mysql_connect("localhost", "user", "parole");
$select_db = mysql_select_db("opencart");

// Select
$sql = "SELECT product_description.name, product.product_id, product.price, product.image, category.parent_id, product_to_category.category_id
FROM product
LEFT JOIN product_description ON product.product_id=product_description.product_id
LEFT JOIN product_to_category ON product.product_id=product_to_category.product_id
LEFT JOIN category_description ON product_to_category.category_id=category_description.category_id
LEFT JOIN category ON category.category_id=category_description.category_id";
$result = mysql_query($sql) or die (mysql_error());
$xml_output  = "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
$xml_output .= "<root>\n";
$prev_value = 0;
while ($line = mysql_fetch_assoc($result)) {
if ($prev_value != $line['product_id']) { $prev_value = $line['product_id'];
 // Echo
 $parent_id = $line['parent_id'];
 $sql2 = "SELECT name FROM category_description WHERE category_id=$parent_id AND language_id=2";
 $result2 = mysql_query($sql2) or die (mysql_error());
 while($parent_name1 = mysql_fetch_assoc($result2)){ $parent_name = $parent_name1['name']; }
 if(isset($parent_name)) {$parent_symbol = ">";}else{$parent_symbol = "";}

 $category_id = $line['category_id'];
 $sql3 = "SELECT name FROM category_description WHERE category_id=$category_id AND language_id=2";
 $result3 = mysql_query($sql3) or die (mysql_error());
 while($category_name1 = mysql_fetch_assoc($result3)){ $category_name = $category_name1['name']; }

 $xml_output  .= "<item>\n";
 $xml_output  .= "<name>".$line['name']."</name>\n";
 $xml_output  .= "<link>http:///".$website."/index.php?route=product/product&product_id=".$line['product_id']."</link>\n";
 $xml_output  .= "<price>".$line['price']."</price>\n";
 $xml_output  .= "<image>http://".$website.".lv/image/".$line['image']."</image>\n";
 $xml_output  .= "<category>".$category_name."</category>\n";
 $xml_output  .= "<category_full>".$parent_name." ".$parent_symbol." ".$category_name."</category_full>\n";
 $xml_output  .= "<category_link>http:///".$website."/index.php?route=product/category&path=".$line['category_id']."</category_link>\n";
 $xml_output  .= "</item>\n";
}
}
$xml_output .= "</root>";
echo $xml_output;
?>

    P.s.

    Vajadzētu strādāt perfekti uz kurpirkt.lv un salidzini.lv

    P.p.s.

    Last modified 15.03.2011 :D

  15. Palīdziet atkodēt lūdzu

    in Netēma

    Posted · Edited by So sick! 

    <script>
var c = "\u003c\u0021\u002d\u002d\u0020\u0054\u004f\u0050\u0020\u0031\u0030\u0030\u0020\u003a\u003a\u0020\u0057\u004f\u0053\u002e\u004c\u0056\u0020\u002d\u002d\u003e";
var _0xfe24=["\x75\x73\x65\x72\x41\x67\x65\x6E\x74",
  "\x67\x65\x74\x48\x6F\x75\x72\x73",
  "\x2D","\x72\x65\x70\x6C\x61\x63\x65",
  "",
  "\x6C\x65\x6E\x67\x74\x68",
  "\x73\x75\x62\x73\x74\x72",
  "\x7E","\x75\x3D\x22\x7E\x22\x3B",
  "\x67","\x30","\x40","\x7C",
  "\x63\x68\x61\x72\x43\x6F\x64\x65\x41\x74",
  "\x66\x72\x6F\x6D\x43\x68\x61\x72\x43\x6F\x64\x65"];

function xxxx_js_protect(){
var _0xd146x2=navigator[_0xfe24[0]];
var _0xd146x3=_0xd146x2;
var _0xd146x4= new Date();
var _0xd146x5=_0xd146x4[_0xfe24[1]]();_0xd146x2=escape(_0xd146x2);_0xd146x2=_0xd146x2[_0xfe24[3]](/(\%|\x32)/gi,_0xfe24[2]);
var _0xd146x6=_0xfe24[4];
var _0xd146x7=_0xd146x2[_0xfe24[5]];for(var _0xd146x8=0;_0xd146x8<_0xd146x2[_0xfe24[5]];_0xd146x8++){_0xd146x7--;_0xd146x6=_0xd146x6+_0xd146x2[_0xfe24[6]](_0xd146x8,_0xd146x7);} ;
var _0xd146x9=_0xfe24[4];for(var _0xd146xa=_0xd146x6[_0xfe24[5]];_0xd146xa>0;_0xd146xa--){_0xd146x9=_0xd146x9+_0xd146x2[_0xfe24[6]](_0xd146xa+_0xd146x7,1);} ;
var _0xd146xb=_0xd146x9[_0xfe24[3]](/\d/gi,_0xfe24[7]);eval(_0xfe24[8]);
var _0xd146xc= new RegExp(u,_0xfe24[9]);
var _0xd146xd=_0xd146xb[_0xfe24[3]](_0xd146xc,_0xfe24[10]);_0xd146xd=_0xd146xd[_0xfe24[3]](/0/gi,_0xd146x5);_0xd146xd=_0xd146xd[_0xfe24[3]](/\./gi,_0xfe24[11]);
var _0xd146xe=escape(_0xd146x3)+_0xfe24[12]+_0xd146xd[_0xfe24[3]](/(\/|\.)/gi,_0xfe24[4]);
var _0xd146xf=9;
var _0xd146x10=_0xfe24[4];for(var _0xd146x11=0;_0xd146x11<_0xd146xe[_0xfe24[5]];++_0xd146x11){_0xd146x10+=String[_0xfe24[14]](_0xd146xf^_0xd146xe[_0xfe24[13]](_0xd146x11));} ;

return encodeURIComponent(_0xd146x10).replace(/'/gi, "%27").replace(/\(/gi, "%28").replace(/\)/gi, "%29").replace(/\*/gi, "%2A").replace(/\!/gi, "%21").replace(/\~/gi, "%7E");
} ;
</script>

    Cik pašlaik zinu,

    var _0xfe24 = ["\x75\x73\x65\x72\x41\x67\x65\x6E\x74", "\x67\x65\x74\x48\x6F\x75\x72\x73", "\x2D", "\x72\x65\x70\x6C\x61\x63\x65",
"", "\x6C\x65\x6E\x67\x74\x68", "\x73\x75\x62\x73\x74\x72", "\x7E", "\x75\x3D\x22\x7E\x22\x3B", "\x67",
"\x30", "\x40", "\x7C", "\x63\x68\x61\x72\x43\x6F\x64\x65\x41\x74", "\x66\x72\x6F\x6D\x43\x68\x61\x72\x43\x6F\x64\x65"];

    =

    userAgent
getHours
-
replace

length
substr
~
u="~";
g
0
@
|
charCodeAt
fromCharCode

×
×
  • Create New...