Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL Module and Admin Boxes for v2.3.1


tgely

Recommended Posts

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

:blink:
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.

Link to comment
Share on other sites

  • 2 weeks later...

:blink:
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.

Link to comment
Share on other sites

  • 3 weeks later...

Group class is for css designs. You can give css classes but this is only an option for designers.

:blink:
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.

Link to comment
Share on other sites

  • 9 months later...

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...