tgely Posted October 4, 2011 Posted October 4, 2011 Hi, I have made a contribution for admin SQL and installation module. This module enable to use configuration table for define constans filenames and table names automatic Create automatic left boxes for administration ------------------------------------------------ Directories: catalog\admin\ catalog\admin\includes\ catalog\admin\includes\boxes\ catalog\admin\includes\languages\ catalog\admin\includes\languages\english\ catalog\admin\includes\languages\english\column_left\ catalog\admin\includes\languages\english\modules\ catalog\admin\includes\languages\english\modules\cfg_modules\ catalog\admin\includes\modules\ catalog\admin\includes\modules\cfg_modules\ catalog\includes\ catalog\includes\languages\ catalog\includes\languages\english\ catalog\includes\languages\english\modules\ catalog\includes\languages\english\modules\sql\ catalog\includes\modules\ catalog\includes\modules\sql\ Files: catalog\admin\example.php catalog\admin\extends_example.php catalog\admin\extends_example2.php catalog\admin\includes\boxes\extends.php catalog\admin\includes\languages\english\column_left\example.php catalog\admin\includes\languages\english\column_left\extends_example.php catalog\admin\includes\languages\english\column_left\extends_example2.php catalog\admin\includes\languages\english\example.php catalog\admin\includes\languages\english\extends_example.php catalog\admin\includes\languages\english\extends_example2.php catalog\admin\includes\languages\english\modules\cfg_modules\cfgm_sql.php catalog\admin\includes\modules\cfg_modules\cfgm_sql.php catalog\includes\languages\english\modules\sql\sql_extends.php catalog\includes\modules\sql\sql_extends.php --------------------------------------------------- Concept: read user manual below. --------------------------------------------------- INSTALLATION --------------------------------------------------- Make a backup first!!! *************************************************** 1. Copy new files (look at languages!) 2. Install only one row by hand: insert new module into catalog/admin/includes/column_left.php include(DIR_WS_BOXES . 'extends.php'); 3. Install at admin SQL modules Add Extends module Thats all. Look at example contents in left boxes with links ----------------------------------------------------- USER MANUAL - Extends Box - SQL module ----------------------------------------------------- Languages files for extends boxes admin/includes/languages/english/column_left/ File definitions: Grouping by first name tag Box Group 1 filename sort order +------------------------------------+---------------+ mainfile_name.php (this is the main) 2 mainfile_name2.php 3 mainfile_name3.php 4 Box Group 2 filename sort order +------------------------------------+---------------+ mainfile1_name2.php 3 mainfile1_name1.php (this is the main) 2 Box Group 3 filename sort order +------------------------------------+---------------+ other_file.php (this is the main) 5 Define main filename as with sort options in configure table. The first sort order value is the main file in a group. Precondition in language files ------------------------------- In the main language file need to place the BOX_HEADER_MAINFILE definitions. Look at languages files in column_left directory Group 2 mainfile1_name2.php mainfile1_name1.php (this is the main) The mainfile1_name1.php contains define('BOX_HEADER_MAINFILE1', 'This is mainfile1 box header text'); ----------------------------------------------------- USER MANUAL - SQL Modules ----------------------------------------------------- SQL modules can use database to create CONSTANT Look at sql_extends.php module's install method. SQL modules can help admin installations and database manipulations. Use SQL Module for define('FILENAME_ Use SQL Module for define('TABLE_ I predefined FILENAME_ configuration hidden group for future in extends module. Create modules for manipulations ---------------------------------------------------- Admin users can do SQL injection into database on easy way by modules. The installed SQL modules show the contributions in order. I hope some developers will use this contribution in the future. Regards Gergely Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.
tgely Posted October 14, 2011 Author Posted October 14, 2011 Final version here: http://addons.oscommerce.com/info/8186 Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.
kplace Posted October 30, 2011 Posted October 30, 2011 Where can I find instructions for the menu maker. I don't know what to put for group class etc. Quote
tgely Posted October 30, 2011 Author Posted October 30, 2011 Group class is for css designs. You can give css classes but this is only an option for designers. Quote osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.
Guest Posted August 9, 2012 Posted August 9, 2012 Hi Gergely, I have some little problems with my install of the smc package and the simple menu. I just encounterd this message: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_ALLMANUFACTURERS' at line 1 select manufacturers_name, manufacturers_id, manufacturers_image from manufacturers order by manufacturers_name limit -0, MAX_DISPLAY_ALLMANUFACTURERS [TEP STOP] Edit ; i do not have a line in my database that says : MAX_DISPLAY_ALLMANUFACTURERS , but should there be one? Thats not good. Second : I have a question about the Simple Menu : I installed all that is needed and it seems to work but with two little problems: 1) in de menumaker menu i can not delete or change the sequense in wich i want to show the categories. 2) when i put in the first categorie item (parent) and then put some other categories (child) under that , wich i give the correct parent number , the child categories do not show under the parent categorie i assined them to but under the manufacturers categorie as a grand child categorie. You can see it here: click As you can see the Manufacturers categorie has the child categorie and on the first child categorie it has another one wich should be under the first categorie. I checked my files 4 times and read thru the whole post but i can´t find anything that tells me were to look. Can you help me to resolve this please? Thanks in advance, Rob Quote
Guest Posted August 13, 2012 Posted August 13, 2012 Hi Gergely I have installed the version 1.2 of the Simple Menu but i get this message: 1054 - Unknown column 'x.sort_order' in 'order clause' select x.*, y.text, y.menu_text_id from menu x left join menu_text y on x.menu_id = y.menu_id where y.language_id = '1' and x.parent = '0' and show_condition = '0' ORDER BY x.parent, x.sort_order ASC [TEP STOP] What is going wrong here? Can you help me resolve this please. Gr, Rob Quote
Guest Posted August 13, 2012 Posted August 13, 2012 And another little one: When i try to save a menu item i get this. Maybe it´s related. 1054 - Unknown column 'sort_order' in 'field list' update menu set show_condition = 'on', class = 'accesoires', link = 'index.php?cPath=23', link_param = '', parent = '0', sort_order = '2' where menu_id = '14' [TEP STOP] Gr, Rob Quote
Guest Posted August 14, 2012 Posted August 14, 2012 OK , update, i created a new column " sort_order " in the database and now the admin side works. Now i need to make it show up on the website! Quote
Guest Posted August 14, 2012 Posted August 14, 2012 It´s working!!!! it still need some tweeking as the menu sort order isn´t working yet but we are getting there.. Quote
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.