forum.coppermine-gallery.net
No Support => Modifications/Add-Ons/Hacks => Mods: Miscellaneous => Topic started by: Amit Badkas on June 27, 2005, 12:04:01 pm
-
FAQ mod for Coppermine Photo Gallery version 1.4.
It has three PHP scripts attached in the zip.
First script is 'faqInstaller.php' which is used to handle installation of FAQ mod.
Second script is 'myfaq.php' which is used to display FAQs with their categories and, if logged in as admin, to delete FAQs and their categories.
Third script is 'manageFAQ.php' which is used by admin to add/edit FAQs and their categories.
To install this mod, unzip the PHP files where you have installed your CPG. Run 'faqInstaller.php' as admin from your web browser, ex:- http://www.somedomain.com/cpg/faqInstaller.php and it will create two database tables.
If you already have any one of these two database tables created then you have to move or delete those tables and run the installer again.
After installation is done, please remove 'faqInstaller.php' for security purpose and access FAQ URL, ex:- http://www.somedomain.com/cpg/myfaq.php to view/manage your FAQs.
For the first time, there are no FAQs/categories. You have to create the FAQ/category by logged in as admin and to click on one of the 'Add New Category' or 'Add FAQ Entry' links.
If you click on 'Add New Category' link then a pop-up window will open which has a textbox to enter title for new category. You cannot have two categories with same title.
If you click on 'Add New Entry' link then a pop-up window will open which has a drop-down of categories (if exists), a textarea to enter question text and another textarea to enter answer text. You can save FAQ in any category or if you do not want to save the FAQ in any category then select 'No category' option. You can use CPG's bbcodes for answer's text.
To edit/delete any FAQ/category, click on respective links next to FAQ/category titles.
If you delete a category which has FAQs then those FAQs will be moved under root category.
You have to manually add link for FAQ page in the navigation area.
That's all :)
Screenshot for 'Add FAQ' screen :-
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2FfaqAdmin_addFAQ.jpg&hash=8e1ac550c5d34ed247227dbfb6584bd6eca35f58)
Screenshot for 'Add Category' screen :-
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2FfaqAdmin_addCategory.jpg&hash=609d6501c821604cbad159cb36f5fd5abdb5613b)
Screenshot for main screen for admin :-
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2FfaqAdmin_general.jpg&hash=12eb5fbcaa94a34d9f3737b161bc4d18f086e9ac)
Screenshot for 'Edit FAQ' screen :-
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2FfaqAdmin_editFAQ.jpg&hash=4738714b24e81d9400db658340ef91abe82020be)
Screenshot for 'Edit Category' screen :-
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2FfaqAdmin_editCategory.jpg&hash=689219ad1eb038a31519192d082dec50abec73b9)
Note:- You can see working example of this mod at NagpurBirds (http://www.nagpurbirds.org/myfaq.php).
-
Hi all,
More modifications made in FAQ mod to make category tree collapsible.
The attached zip contains modified myfaq.php and two images. The images should be placed in your coppermine installation's images directory and it must be 'images'.
That's all !!!
Screenshot to view how this looks :-
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2Ffaq_collapsibleTree.jpg&hash=addd98544643243c03a60c45e466dde7d44c261a)
Amit :)
-
split discussion about cpg1.3.x version of this mod into a separate thread: FAQ mod for CPG-1.3 (http://forum.coppermine-gallery.net/index.php?topic=20077.0)
-
hi Amit,
Nice but i've get this error message when i run faqInstaller.php, do you know why ?
(CPG 1.4.0 in Admin mode)
Fatal error: Call to undefined function: cpg_db_fetch_row() in /var/www/MyHost.fr/b/f/webotron/myDir/faqInstaller.php on line 18 Line 18 is visible here :
// Query to select tables in the database
$query = 'SHOW TABLES FROM '.$CONFIG['dbname'];
$result = cpg_db_query($query);
while ($row = cpg_db_fetch_row($result)) {
if ($row[0] == $CONFIG['TABLE_PREFIX'].'faqs') {
$faqTableExists = true;
} else if ($row[0] == $CONFIG['TABLE_PREFIX'].'faqCategories') {
$categoryTableExists = true;
} else if ($faqTableExists && $categoryTableExists) {
break;
}
}Correction on faqCatgeories by faqCategories
Thanx
PYAP
-
Hi PYAP,
The function 'cpg_db_fetch_row' exists in 'functions.inc.php' of CPG-1.4.x. Please check your file, if the function is not there please get the updated file from cvs.
Amit :)
-
function 'cpg_db_fetch_row' exists in 'functions.inc.php' of CPG-1.4.x. Please check your file..from cvs.
it's OK now, i had downloaded some brand new files ;D
But i have the same error message again ???
In futur can i place your MOD (for 1.4.x and 1.3.x), here, in our French Coppermine Board (http://forum.coppermine-gallery.net/index.php?board=38.0) ? (in few days)
Thanx
PYAP
-
Hi PYAP,
it's OK now, i had downloaded some brand new files ;D
But i have the same error message again ???
The function 'cpg_db_fetch_row' is not in my mod but in CPG-1.4.x itself, so it is possible that there is something wrong in your 'functions.inc.php' file.
In futur can i place your MOD (for 1.4.x and 1.3.x), here, in our French Coppermine Board (http://forum.coppermine-gallery.net/index.php?board=38.0) ? (in few days)
Yes. You can.
Amit :)
-
Pascal: cpg1.4.0 is completely outdated, there have been huge changes from the alpha release to the cpg1.4.1 beta. It's mandatory that you upgrade to cpg1.4.1, preferably the latest devel cvs checkout. There's no point in hunting down particular issues for cpg1.4.0.
-
GauGau,
cpg1.4.0 is completely outdated
Well ! i'm waiting CPG NG ;D
PYAP
-
Hi all,
Links 'Collapse All' and 'Expand All' have been added for collapsible category tree.
Attached the modified 'myfaq.php' script.
Screenshots to view how these links will be displayed :-
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2Ffaq_collapseAll.jpg&hash=a8d8976ba103f8cb21ba87c041968a660fc0f4d4)
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2Ffaq_expandAll.jpg&hash=3868314e2f61cf6f219ea07d2d0ae15ffbf7d96c)
Amit :)
-
Hi all,
Attached new PHP scripts in a zip for FAQ mod having multi-level categories.
One more file 'faqFunctions.inc.php' has been added into the mod and many changes made in 'manageFAQ.php' and 'myfaq.php'.
I hope all of you will like it.
Main screen :-
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2Ffaq_mlc1.jpg&hash=73219d57e92b9ceb64f6c57e9644657ccda10f2f)
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2Ffaq_mlc2.jpg&hash=80eac85979d83bbbde8e1feeef9276ca6fd2493f)
Screen to add category (pop-up window) :-
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2F65.254.32.58%2F%7Eamitrb%2FfaqScreenshots%2Ffaq_mlc3.jpg&hash=a1a554ae4a541a09acbf01a4f66dd09f8c8c8e7d)
Thanks :)
Amit
-
For database table modifications related to multi-level categories, you have to run following two queries :-
ALTER TABLE `cpg140_faqCatgeoriesTest` ADD `parentCategory` INT NOT NULL AFTER `categoryId`;ALTER TABLE `cpg140_faqCatgeoriesTest` ADD INDEX (`parentCategory`);
Also don't forget to change database table prefix according to your need.
Amit :)
-
This doesn´t work for me. :(
Everytime i try to run www.mysite.com/faqInstaller.php, i come to a blank page.
What sql am i supposed to use for this, maybe i can do it manually?
-
Have you got the correct version of CPG? The version you have selected is 1.3.x and this mod is only for 1.4.x
-
Have you got the correct version of CPG? The version you have selected is 1.3.x and this mod is only for 1.4.x
I´m not sure which version of CPG i have. :-[
Is there a easy way to find out which version i´m using?
-
View the HTML source of the index.php page. The version is written at the bottom of the page.
-
View the HTML source of the index.php page. The version is written at the bottom of the page.
Oh, ok...
It seems that i´m using version: 1.3.3. :\'(
Is there another "faq mod" i can use instead?
-
Yes, there is a mod for 1.3.x
http://forum.coppermine-gallery.net/index.php?topic=20077.0
But a lot of features are missing from it like collapsible tree and multi-level categories.
-
But a lot of features are missing from it like collapsible tree and multi-level categories.
That´s to bad... :-\\
-
If you know PHP, you can take this 1.4 mod and change it for 1.3
As far as I know, some function names related to database needs to be changed. But do it on your own risk. :)
-
If you know PHP, you can take this 1.4 mod and change it for 1.3
As far as I know, some function names related to database needs to be changed. But do it on your own risk. :)
Why not just add the functions from 1.4 and add it to 1.3? ;)
-
:D :D
That is not possible. Think how much code we will have to change for this.
I just checked the code once again,
find all the occurances of
cpg_db_query
and
cpg_db_fetch_row and replace it with
db_query
and
db_fetch_row
This should be sufficient to make it work with 1.3.x
-
:D :D
That is not possible. Think how much code we will have to change for this.
I just checked the code once again,
find all the occurances of
cpg_db_query
and
cpg_db_fetch_row and replace it with
db_query
and
db_fetch_row
This should be sufficient to make it work with 1.3.x
Is that all? ;D
But i have allready installed the "old" mod, can i just replace the files or what?
-
Hi,
But i have allready installed the "old" mod, can i just replace the files or what?
I have posted the procedure to add/change code in your FAQ mod to work single-level collapsible tree in topic http://forum.coppermine-gallery.net/index.php?topic=20077 because your posts are related to CPG-1.3.x.
Thanks :)
Amit
-
Hi,
But i have allready installed the "old" mod, can i just replace the files or what?
I have posted the procedure to add/change code in your FAQ mod to work single-level collapsible tree in topic http://forum.coppermine-gallery.net/index.php?topic=20077 because your posts are related to CPG-1.3.x.
Thanks :)
Amit
Thanks mate... ;D
-
FAQ mod for Coppermine Photo Gallery version 1.4.
It has four PHP scripts attached in the zip.
First script is 'faqInstaller.php' which is used to handle installation of FAQ mod.
Second script is 'myfaq.php' which is used to display FAQs with their categories and, if logged in as admin, to delete FAQs and their categories.
Third script is 'manageFAQ.php' which is used by admin to add/edit FAQs and their categories.
Fourth script is 'faqFunctions.inc.php' which has functions related to FAQ mod.
There are also two images which you have to place in 'images' directory of your coppermine installation.
To install this mod, unzip the PHP files where you have installed your CPG. Run 'faqInstaller.php' as admin from your web browser, ex:- http://www.somedomain.com/cpg/faqInstaller.php and it will create two database tables.
If you already have any one of these two database tables created then you have to move or delete those tables and run the installer again.
After installation is done, please remove 'faqInstaller.php' for security purpose and access FAQ URL, ex:- http://www.somedomain.com/cpg/myfaq.php to view/manage your FAQs.
For the first time, there are no FAQs/categories. You have to create the FAQ/category by logged in as admin and to click on one of the 'Add New Category' or 'Add FAQ Entry' links.
If you click on 'Add New Category' link then a pop-up window will open which has a textbox to enter title for new category. You can also select parent category for a category. You cannot have two categories with same title.
If you click on 'Add New Entry' link then a pop-up window will open which has a drop-down of categories (if exists), a textarea to enter question text and another textarea to enter answer text. You can save FAQ in any category or if you do not want to save the FAQ in any category then select 'No category' option. You can use CPG's bbcodes for answer's text.
To edit/delete any FAQ/category, click on respective links next to FAQ/category titles.
If you delete a category which has FAQs then those FAQs will be moved under root category.
You have to manually add link for FAQ page in the navigation area.
That's all :)
-
Amit, looks like an excellent mod!
I am having issues downloading the .zip? The forum gives me the message: "It seems that you are not allowed to download or view attachments on this board." and gives me the login interface. This happens when I am logged in as a user. Is there some other level of access I need or other process to download this code?
Thanks
~Kevin
-
Hi kcocco,
Thanks for appreciating my work.
Amit, looks like an excellent mod!
I am having issues downloading the .zip? The forum gives me the message: "It seems that you are not allowed to download or view attachments on this board." and gives me the login interface. This happens when I am logged in as a user. Is there some other level of access I need or other process to download this code?
Thanks
~Kevin
I think your session was expired. Please try after login again. I have checked the download with two more forum users and it worked for me.
Amit :)
-
Amit,
I was able to get the download to work using Firefox browser. I was previously using IE (not my machine) with no success?
Thank you
~Kevin
-
Kevin,
I was able to get the download to work using Firefox browser. I was previously using IE (not my machine) with no success?
I always prefers Firefox on Linux and Windows both. In fact, on Windows, Firefox runs as faster as IE.
Amit :)
-
Hi all,
You can view demo of FAQ mod for CPG-1.4 with multi-level categories and collapsible category tree on My Site (http://65.254.32.58/~amitrb/cpg140/myfaq.php).
Amit :)
-
Hi,
Attached modified 'manageFAQ.php' file with new PNG toolbar images (should be placed in 'images' directory of your coppermine installation) and 'faq.js' javascript file (should be placed in root directory of your coppermine installation, i.e., where 'manageFAQ.php' file resides).
You can view demo of bbCode toolbar on My Site (http://65.254.32.58/~amitrb/toolbarExample.html).
That's all.
Amit :)
-
This mod is very good, I'm planning to add it to the core code of the next version. Is that OK, Amit?
-
Hi GauGau,
This mod is very good, I'm planning to add it to the core code of the next version. Is that OK, Amit?
Thanks for recognizing my work and considering it in the core code of future version.
Amit :)
-
Thanks for that great Mod. There is only one Problem I have a Gallery with German as Language and sometimes I need to write letters like ä,ö,ü but if I write them an save them I only se a ? and not the ä or ü or ö. If I look into the database via phpymyadmin and change the lette to ä or ü or ö nothing change in phmyadmin you can the the right letter but in myfaq.php you only see a ?. Where is the Problem? What do I have to change ;)
Thx
-
Great work! Thanks for a very useful Mod.
;)