This repository has been archived by the owner on Jul 3, 2024. It is now read-only.
-
-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathREADME.txt
122 lines (104 loc) · 4.82 KB
/
README.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
****************************************************************************
Missing Images Checker for ZenCart
Copyright (C) 2014 Paul Williams/IWL Entertainment
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 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
****************************************************************************
Features
========
Scans your ZenCart database and images folder for any missing images and reports
on them.
Version Date
==============
v2.0 ** NOT YET **
* Thanks to Zen4All and their changes, this coding is being reworked and moved
from being a standalone script to a full-fledged admin panel module. This
means that there will be a full documentation page (not too complex) and
the inclusion of installation SQL scripts for adding the menu option
to the admin menu (likely under 'tools').
* In addition, since it is being directly incorporated with ZenCart, this
coding is being re-licensed under GPLv2.
TODO:
* Remove all hard coded *anything* from the actual module code and move
the texts to define files for the module.
* Work on "action buttons" to either remove the image from the database and/or
delete the actual image file from the store.
* Instead of just going through one LARGE scan of the database, possibly look
into separating and searching by category instead.
* Anything as needed.
v1.0.2 2014-07-24 13:50
* Removed the choice of running the script as MySQLi or MySQL. The script
will now check if it can run mysqli_connect. If not, it will run
mysql_connect. If that fails, the script will not run. The user also
has the option to force MySQL although this should NOT really be used. I
will still reserve the right to remove this option at a later time once
MySQL is removed from PHP.
* Consolidated the location of the query that is being run by the script to
one location. (There is no difference in SQL language between MySQL and
MySQLi. So having two seperate queries which produced the same result table
was a bit redundant.)
v1.0.1 2014-07-24 12:58
* Improved call for database_tables.php as suggested by lat9.
Thanks for the code suggestion.
v1.0 2014-07-16 02:37
* Initial release
Author
======
Paul Williams ([email protected])
Description
===========
This script will run through your ZenCart database, provided by you in the
connection information of the script, and then retrieve all images from the
products table of ZenCart. Then, the script will run through each of those
images making sure that the image exists and is saved in the correct format.
(For example, a .gif is actually a GIF.) This is useful if you use a batch
product uploader like easyPopulate and you don't know which of your images
are missing.
Known Issues
============
* People on shared servers or those without the ability to turn Safe Mode off
will experience more time outs on larger databases. This is because I
cannot force the script to essentially reset the execution_timer. This will
be worked on in a later version. You can try to edit the script on line 118
and change the SQL query a little bit. If you do, you may end up having
to run this script a couple of times.
Support thread
==============
http://www.zen-cart.com/showthread.php?213966
GitHub
======
https://github.com/retched/missing-images-zen
Affected files
==============
None
Affects DB
==========
None
DISCLAIMER
==========
Installation of this contribution is done at your own risk.
While there are no changes made to your database or files, it is still suggested
to backup your ZenCart database and any and all applicable files before
proceeding.
Install (Needs to be rewritten)
=======
0. Backup your database.
1. Unzip and edit /missing_images.php under the area "Configuration Variables".
Be careful of ANY quotation marks. The quotation marks MUST stay. Be sure
to read the notes under each $variable.
2. Save the edits.
3. Upload your modified /missing_images.php to your store directory. (It
does not have to be in the root of the store directory but it does
have to be on the same server as it.)
4. Run the script via web browser.
Un-Install (Needs to be rewritten)
==========
1. Delete all files that were copied from the installation package.