proudcommerce
/ admin_header_links.tpl
Created Jul 17, 2020
Workaround for OXID Admin Logout / Session-Timeout
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> |
proudcommerce
/ pc-ide-helper.php
Last active Jul 11, 2020
Script to generate a .module-helper.php file for OXID eShop 6.x to resolve _parent classes for the IDE
View pc-ide-helper.php
| moved: https://github.com/proudcommerce/oxid-ide-modulehelper |
proudcommerce
/ OXID eShop - getLogger fix OXID 6.2
Created May 26, 2020
Fix for OXID 6.2 circular reference service problems
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() { |
proudcommerce
/ OXID eShop - config.inc.php configuration values
Last active Mar 10, 2020
Configuration values with default values
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) |
proudcommerce
/ OXID eShop - Switch oxvendor and oxmanufacturers
Last active Jul 4, 2020
Set oxvendor = oxmanufacturers and oxmanufacutrers = oxvendor
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 |
proudcommerce
/ Rundeck Mattermost Webhook Notification
Created Sep 9, 2019
Get data from rundeck webhook notification and send to mattermost.
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'; |
proudcommerce
/ OXID eShop - MySQL Snippets
Last active Feb 23, 2021
collection of useful and important mysql snippets for the oxid eshop
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 | |
proudcommerce
/ OXID eShop - check if column exists
Created Jan 8, 2015
this function checks if a given column in a given database table exists. thanks to tim from shoptimax for this snippet.
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); | |
| } |
proudcommerce
/ OXID eShop - gets first subcategory and redirect to this
Last active Aug 29, 2015
gets first subcategory of a main category and redirect to this.uses an array, which main categories should be checked.
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 |
proudcommerce
/ OXID eShop - Redirect old seo urls
Created Dec 25, 2013
Script for saving old seo urls. Redirects old seo urls (e. g. from an other shop software after relaunch) to the new oxid shop seo urls.
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 |