View admin_header_links.tpl
[{* Create module with tmeplate block for: admin_header_links *}] | |
[{$smarty.block.parent}] | |
<script> | |
setInterval(function () { | |
window.location.href=window.location.href; | |
}, 1800000); | |
</script> |
View pc-ide-helper.php
moved: https://github.com/proudcommerce/oxid-ide-modulehelper |
View OXID eShop - getLogger fix OXID 6.2
# thx to alfred (https://github.com/alfredbez) for sharing | |
# add to modules/functions.php | |
use Monolog\Logger; | |
use Monolog\Handler\StreamHandler; | |
use OxidEsales\EshopCommunity\Internal\Container\ContainerFactory; | |
use Psr\Log\LoggerInterface; | |
use Symfony\Component\DependencyInjection\Exception\ServiceCircularReferenceException; | |
function getLogger() { |
View OXID eShop - config.inc.php configuration values
iLangPerTable (8) | |
= definiert die mögliche Zahl an Sprachtabellen | |
sLangTableSuffix (_set) | |
= optionaler Suffix für Sprachtabellen | |
iPasswordLength (6) | |
= definiert die Mindestlänge des Kundenpasswortes | |
blSkipFormatConversion (false) |
View OXID eShop - Switch oxvendor and oxmanufacturers
# 1. Export oxvendors table + data (eg. oxvendor.sql) | |
# 2. Export oxmanufacturers table + data (eg. oxmanufacturers.sql) | |
# 3. Clean up manufacturers | |
DELETE FROM oxmanufacturers; | |
# 4. Clean up vendors | |
DELETE FROM oxvendor; | |
# 5. Replace "oxvendor" with "oxmanufacturers" in oxvendor.sql | |
# 6. Import oxvendor.sql | |
# 7. Replace "oxmanufacturers" with "oxvendor" in oxmanufacturers.sql | |
# 8. Import oxmanufacturers.sql |
View Rundeck Mattermost Webhook Notification
<?php | |
/* | |
* ProudCommerce | 2019 | |
* www.proudcommerce.com | |
* | |
* https://docs.mattermost.com/developer/webhooks-incoming.html | |
* https://github.com/ThibaudDauce/mattermost-php | |
*/ | |
require __DIR__ . '/vendor/autoload.php'; |
View OXID eShop - MySQL Snippets
/*** 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 | |
View OXID eShop - check if column exists
protected function _dbColumnExist($sTable, $sColumn) | |
{ | |
$sDbName = oxRegistry::getConfig()->getConfigParam('dbName'); | |
$sSql = sprintf("SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '%s' AND TABLE_NAME = '%s' " | |
. " AND COLUMN_NAME = '%s'", | |
$sDbName, $sTable, $sColumn); | |
return oxDb::getDb()->getOne($sSql); | |
} |
View OXID eShop - gets first subcategory and redirect to this
<?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 | 2014 | |
* @link https://gist.github.com/proudcommerce | |
* @link http://www.proudcommerce.com |
View OXID eShop - Redirect old seo urls
<?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 |