kermie

<?php
/**
 * This file was modified to fix the security bulletin 2016-001!
 */
/**
 *    This file is part of OXID eShop Community Edition.
 *
 *    OXID eShop Community Edition is free software: you can redistribute it and/or modify
 *    it under the terms of the GNU General Public License as published by
 *    the Free Software Foundation, either version 3 of the License, or

kermie

<?php
// ===================================================
// = place this file in the root of your OXID eShop! =
// ===================================================

require_once 'bootstrap.php';

// CONFIG
$sTheme  = 'azure';
$iLangId = 0; // German

kermie

/*** ARTIKEL / ARTICLES ***/
/******************************************************/

/* artikelnamen aller artikel anzeigen, welcher einer bestimmten kategorie zugeordnet sind [proudcommerce.com] */
select oxarticles.oxtitle, oxarticles.OXVARSELECT as Variant, oxcategories.OXTITLE as Kategorie from oxarticles left join oxobject2category on oxarticles.OXID = oxobject2category.OXOBJECTID left join oxcategories on oxcategories.OXID = oxobject2category.OXCATNID where oxcategories.OXROOTID = '<YOUR-CATEGORY-OXID>';

/* variantenpreise (oxvarmin, oxvarmax) anhand der aktuellen artikel aktualisieren [foxido.de] */
UPDATE oxarticles B, (SELECT oxparentid,MIN( oxprice ) AS min ,MAX( oxprice ) AS max FROM oxarticles GROUP BY oxparentid) AS A SET oxvarminprice = A.min, oxvarmaxprice = A.max WHERE B.oxid = A.oxparentid

kermie

grep -R --include=*.tpl '\boxmultilang\b' tpl/ | sed -r "s/ident=([^$])/\\nident=\1/g" | grep ^ident= | sed -r 's/}.*$//' | tr "'" '"' | sort -u | while read LINE; do KEY=$(echo "$LINE" | awk -F'"' '{print$2}'); echo -e $LINE"\t"$KEY"\t"$(grep -Rl --include=*.php $KEY ./ | wc -l); done | grep 0$

kermie

<?php
//WARNING: this file deletes content from DB! be careful!
// Use this in a oxid e-sales shop 4.7.0 or higher
//if you understand, remove or comment the next line:
die('Please read the comments!');

include('bootstrap.php');
/**
  * defines 'php model class' => 'database table'
  */

kermie

<?php
/**
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * @copyright (c) Proud Sourcing GmbH | 2013
 * @link https://gist.github.com/proudcommerce
 * @version 1.0.0

kermie

<?php
/**
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * @copyright (c) Proud Sourcing GmbH | 2013
 * @link https://gist.github.com/proudcommerce
 * @version 1.0.0