FAQ Manager

INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - Categories Box', 'FAQ Manager Categories Box Settings', '1' , '0');
UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - Categories Box';
INSERT INTO zen_configuration VALUES ('', 'Show FAQ Category Counts', 'SHOW_FAQ_COUNTS', 'true', 'Count recursively how many FAQs are in each FAQ category', @t4, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO zen_configuration VALUES ('', 'FAQ Categories Count Prefix', 'FAQ_CATEGORIES_COUNT_PREFIX', ' (', 'What do you want to Prefix the FAQ count with?<br />Default= (', @t4, 10, NULL, now(), NULL, 'zen_cfg_textarea_small(');
INSERT INTO zen_configuration VALUES ('', 'FAQ Categories Count Suffix', 'FAQ_CATEGORIES_COUNT_SUFFIX', ')', 'What do you want as a Suffix to the FAQ count?<br />Default= )', @t4, 11, NULL, now(), NULL, 'zen_cfg_textarea_small(');
INSERT INTO zen_configuration VALUES ('', 'FAQ Categories SubCategories Indent', 'FAQ_CATEGORIES_SUBFAQ_CATEGORIES_INDENT', '  ', 'What do you want to use as the FAQ subcategories indent?<br />Default=   ', @t4, 12, NULL, now(), NULL, 'zen_cfg_textarea_small(');
INSERT INTO zen_configuration VALUES ('', 'FAQ Categories with 0 FAQs Status', 'FAQ_CATEGORIES_COUNT_ZERO', '0', 'Show FAQ Count for 0 FAQs?<br />0= off<br />1= on', @t4, 13, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO zen_configuration VALUES ('', 'Separator between links Status', 'SHOW_FAQ_CATEGORIES_SEPARATOR_LINK', '1', 'Show FAQ Category Separator between Category Names and Links?<br />0= off<br />1= on', @t4, 14, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO zen_configuration VALUES ('', 'Separator between the Category Name and Count', 'FAQ_CATEGORIES_SEPARATOR', '->', 'What separator do you want between the FAQ Category name and the count?<br />Default = ->', @t4, 15, NULL, now(), NULL, 'zen_cfg_textarea_small(');
INSERT INTO zen_configuration VALUES ('', 'Separator between the Category Name and Sub Categories', 'FAQ_CATEGORIES_SEPARATOR_SUBS', '|_ ', 'What separator do you want between the FAQ Category name and FAQ Sub Category Name?<br />Default = |_ ', @t4, 16, NULL, now(), NULL, 'zen_cfg_textarea_small(');
INSERT INTO zen_configuration VALUES ('', 'Always Open to Show FAQ SubCategories', 'SHOW_FAQ_CATEGORIES_SUBFAQ_CATEGORIES_ALWAYS', '1', 'Always Show Categories and SubCategories<br />0= off, just show Top Categories<br />1= on, Always show Categories and SubCategories when selected', @t4, 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO zen_configuration VALUES ('', 'Show New FAQs Link', 'SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW', 'true', 'Show FAQs New Link in the FAQ Categories Box', @t4, 18, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO zen_configuration VALUES ('', 'Show All FAQs Link', 'SHOW_FAQ_CATEGORIES_BOX_FAQS_ALL', 'true', 'Show FAQs All Link in the FAQ Categories Box', @t4, 19, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - FAQ Info Page', 'FAQ Manager FAQ Info Page Settings', '1' , '0');
UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - FAQ Info Page';
INSERT INTO zen_configuration VALUES ('', 'Previous Next - Navigation Bar Position', 'FAQ_INFO_PREVIOUS_NEXT', '1', 'Location of Previous/Next Navigation Bar<br />0= off<br />1= Top of Page<br />2= Bottom of Page<br />3= Both Top and Bottom of Page', @t4, 30, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''Top of Page''), array(''id''=>''2'', ''text''=>''Bottom of Page''), array(''id''=>''3'', ''text''=>''Both Top & Bottom of Page'')),');
INSERT INTO zen_configuration VALUES ('', 'Previous Next - Sort Order', 'FAQ_INFO_PREVIOUS_NEXT_SORT', '1', 'FAQs Display Order by<br />0= FAQ ID<br />1= FAQ Name<br />6= FAQ Sort Order', @t4, 31, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''FAQ ID''), array(''id''=>''1'', ''text''=>''Name''), array(''id''=>''6'', ''text''=>''FAQ Sort Order'')),');
INSERT INTO zen_configuration VALUES ('', 'Previous Next - Button and Image Status', 'SHOW_FAQ_PREVIOUS_NEXT_STATUS', '0', 'Button and FAQ Image status settings are:<br />0= Off<br />1= On', @t4, 32, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''On'')),');
INSERT INTO zen_configuration VALUES ('', 'Previous Next - Button and Image Settings', 'SHOW_FAQ_PREVIOUS_NEXT_IMAGES', '0', 'Show Previous/Next Button and FAQ Image Settings<br />0= Button Only<br />1= Button and FAQ Image<br />2= FAQ Image Only', @t4, 33, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Button Only''), array(''id''=>''1'', ''text''=>''Button and FAQ Image''), array(''id''=>''2'', ''text''=>''FAQ Image Only'')),');
INSERT INTO zen_configuration VALUES ('', 'Previous Next - Navigation Includes FAQ Category', 'FAQ_INFO_FAQ_CATEGORIES', '1', 'FAQs Category Image and Name Alignment Above Previous/Next Navigation Bar<br />0= off<br />1= Align Left<br />2= Align Center<br />3= Align Right', @t4, 34, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''Align Left''), array(''id''=>''2'', ''text''=>''Align Center''), array(''id''=>''3'', ''text''=>''Align Right'')),');
INSERT INTO zen_configuration VALUES ('', 'Show FAQ Reviews Count', 'SHOW_FAQ_INFO_REVIEWS_COUNT', '1', 'Display FAQ Reviews Count on FAQ Info 0= off 1= on', @t4, 35, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
INSERT INTO zen_configuration VALUES ('', 'Show FAQ Reviews Button', 'SHOW_FAQ_INFO_REVIEWS', '1', 'Display FAQ Reviews Button on FAQ Info 0= off 1= on', @t4, 36, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
INSERT INTO zen_configuration VALUES ('', 'Show Date Added', 'SHOW_FAQ_INFO_DATE_ADDED', '1', 'Display Date Added on FAQ Info 0= off 1= on', @t4, 37, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
INSERT INTO zen_configuration VALUES ('', 'Show FAQ URL', 'SHOW_FAQ_INFO_URL', '1', 'Display URL on FAQ Info 0= off 1= on', @t4, 38, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
INSERT INTO zen_configuration VALUES ('', 'Show FAQ Tell a Friend button', 'SHOW_FAQ_INFO_TELL_A_FRIEND', '1', 'Display the Tell a Friend button on FAQ Info<br /><br />Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button<br />0= off 1= on', @t4, 39, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');

INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - FAQ Listing', 'FAQ Manager FAQ Listing Settings', '1' , '0');
UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - FAQ Listing';
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Name', 'FAQ_LIST_NAME', '1', 'Do you want to display the FAQ Name?', @t4, 50, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Prev/Next Split Page Navigation (1-top, 2-bottom, 3-both)', 'PREV_NEXT_FAQ_BAR_LOCATION', '1', 'Sets the location of the FAQ Prev/Next Split Page Navigation', @t4, 51, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''3''), ');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Listing Default Sort Order', 'FAQ_LISTING_DEFAULT_SORT_ORDER', '', 'FAQ Listing Default sort order?<br />NOTE: Leave Blank for FAQ Sort Order. Sort the FAQ Listing in the order you wish for the default display to start in to get the sort order setting. Example: 2a', @t4, 52, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Number Per Page', 'MAX_DISPLAY_FAQS_LISTING', '10', 'Maximum Number of FAQs to list per page on main page', @t4, 53, NULL, now(), '', '');

INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - New FAQs Page', 'FAQ Manager New FAQs Page Settings', '1' , '0');
UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - New FAQs Page';
INSERT INTO zen_configuration VALUES ('', 'Number of FAQs Per Page', 'MAX_DISPLAY_FAQS_NEW', '10', 'Number of new FAQs listings per page', @t4, 70, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Image', 'FAQ_NEW_LIST_IMAGE', '1102', 'Do you want to display the FAQ Image?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 71, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Name', 'FAQ_NEW_LIST_NAME', '2101', 'Do you want to display the FAQ Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 72, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Date Added', 'FAQ_NEW_LIST_DATE_ADDED', '2601', 'Do you want to display the FAQ Date Added?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 73, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Description', 'FAQ_NEW_LIST_DESCRIPTION', '1', 'Do you want to display the FAQ Description - First 150 characters?<br />0= off<br />1= on', @t4, 74, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO zen_configuration VALUES ('', 'Default Sort Order', 'FAQ_NEW_LIST_SORT_DEFAULT', '6', 'What Sort Order Default should be used for New FAQs Display?<br />Default= 6 for Date New to Old<br /><br />1= FAQs Name<br />2= FAQs Name Desc<br />6= Date Added desc<br />7= Date Added', @t4, 75, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''6'', ''7''), ');
INSERT INTO zen_configuration VALUES ('', 'Image Width', 'IMAGE_FAQ_NEW_LISTING_WIDTH', '50', 'Default = 50', @t4, 76, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Image Height', 'IMAGE_FAQ_NEW_LISTING_HEIGHT', '40', 'Default = 40', @t4, 77, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Number of FAQs Per Page', 'MAX_DISPLAY_FAQS_ALL', '10', 'Number of faqs to list per screen', @t4, 80, NULL, now(), NULL, '');
INSERT INTO zen_configuration VALUES ('', 'New FAQs Page Configuration Group ID', 'FAQ_LISTS_GROUP_ID_NEW', @t4, 'Warning: Only change this if your FAQs All Group ID has changed from the default<br />What is the configuration_group_id for FAQ Listings?', @t4, 90, NULL, now(), '', '');
INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - All FAQs Page', 'FAQ Manager All FAQs Page Settings', '1' , '0');
UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - All FAQs Page';
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Image', 'FAQ_ALL_LIST_IMAGE', '1102', 'Do you want to display the FAQ Image?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 81, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Name', 'FAQ_ALL_LIST_NAME', '2101', 'Do you want to display the FAQ Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 82, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Date Added', 'FAQ_ALL_LIST_DATE_ADDED', '2601', 'Do you want to display the FAQ Date Added?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 83, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Description', 'FAQ_ALL_LIST_DESCRIPTION', '1', 'Do you want to display the FAQ Description - First 150 characters?', @t4, 84, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO zen_configuration VALUES ('', 'Default Sort Order', 'FAQ_ALL_LIST_SORT_DEFAULT', '1', 'What Sort Order Default should be used for All FAQs Display?<br />Default= 1 for FAQ Name<br /><br />1= FAQs Name<br />2= FAQs Name Desc<br />6= Date Added desc<br />7= Date Added', @t4, 85, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''6'', ''7''), ');
INSERT INTO zen_configuration VALUES ('', 'Image Width', 'IMAGE_FAQ_ALL_LISTING_WIDTH', '50', 'Default = 50', @t4, 86, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Image Height', 'IMAGE_FAQ_ALL_LISTING_HEIGHT', '40', 'Default = 40', @t4, 87, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'ALL FAQs Page Configuration Group ID', 'FAQ_LISTS_GROUP_ID_ALL', @t4, 'Warning: Only change this if your FAQs All Group ID has changed from the default<br />What is the configuration_group_id for FAQ Listings?', @t4, 90, NULL, now(), '', '');

INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - General Config', 'FAQ Manager General Config Settings', '1' , '0');
UPDATE zen_configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - General Config';

INSERT INTO zen_configuration VALUES ('', 'FAQ Categories - FAQ Categories To List Per Row', 'MAX_DISPLAY_FAQ_CATEGORIES_PER_ROW', '1', 'How many FAQ categories to list per row', @t4, 91, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Allow faqs To Go Live As Submitted', 'FAQ_LIST_LIVE', 'false', 'Do you want faqs to go live as submitted<br>Set to false for admin approval.', @t4, 92, NULL, now(), NULL, 'zen_cfg_select_option(array('true', 'false'),');
INSERT INTO zen_configuration VALUES ('', 'Define FAQs Submit', 'DEFINE_FAQS_SUBMIT_STATUS', '1', 'Enable the Defined faqs_submit text?<br />0= OFF<br />1= ON', @t4, 93, NULL, now(), NULL, 'zen_cfg_select_option(array('0', '1'),');
INSERT INTO zen_configuration VALUES ('', 'Allow FAQS submission', 'ALLOW_FAQS_SUBMISSION', 'true', 'Allow users to submit FAQs.', @t4, 94, NULL, now(), NULL, 'zen_cfg_select_option(array('true', 'false'),');
INSERT INTO zen_configuration VALUES ('', 'If Allow FAQS submission = true, allow unregistered users submit FAQs', 'UNREGISTERED_FAQS_SUBMIT', 'true', 'Allow unregistered users to submit FAQs.', @t4, 95, NULL, now(), NULL, 'zen_cfg_select_option(array('true', 'false'),');
INSERT INTO zen_configuration VALUES ('', 'Allow Image Upload', 'SUBMIT_FAQ_ALLOW_IMAGE_UPLOAD', 'true', 'Allow Image Upload on FAQ Submit', @t4, 96, NULL, now(), NULL, 'zen_cfg_select_option(array('true', 'false'),');
INSERT INTO zen_configuration VALUES ('', 'Send FAQ Submit Notification Emails To:', 'SEND_FAQ_SUBMIT_EMAILS_TO_EMAILS_TO', '[email protected]', 'Enter the email address that FAQ submit notifications should be sent to', @t4, 97, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Define No FAQs Allowed', 'DEFINE_NO_FAQS_ALLOWED', '1', 'Enable the No FAQs Allowed text?<br>0= OFF<br>1= ON', @t4, 98, NULL, now(), NULL, 'zen_cfg_select_option(array('0', '1'),');

Thanks man!!

I got an error though

[B]Error[/B]

     [B]SQL query:[/B]     
               INSERT  INTO zen_configuration_group
VALUES ( '',  'FAQ Manager - Categories Box',  'FAQ Manager Categories Box Settings',  '1',  '0'
);

     
      [B]MySQL said: [/B]
  #1146 - Table 'haskellg_estore.zen_configuration_group' doesn't exist 

I exported the DB ( selected all ) to a zip.
The store is still working fine though.
I've never backed up a DB before.

Pablosan:

Thanks man!!

I got an error though

[B]Error[/B]

 [B]SQL query:[/B]     
           INSERT  INTO zen_configuration_group

VALUES ( '', 'FAQ Manager - Categories Box', 'FAQ Manager Categories Box Settings', '1', '0'
);

  [B]MySQL said: [/B] 

#1146 - Table 'haskellg_estore.zen_configuration_group' doesn't exist

>  
> I exported the DB ( selected all ) to a zip.
> The store is still working fine though.
> I've never backed up a DB before.
 
I think it is because your original shop database hasn't got 'zen_' prefix. In this case, you need to delete 'zen_' prefix in the sql file, then import it to your DB again. Besides 10 new faq tables are added (i believe they are in your DB already), two old zc shop tables are affected (new entries are inserted), one is **zen_configuration_group**, the other is **zen_configuration** (note: you may not have 'zen_' prefix). When you import the sql, if there is a duplicate error, go to the table, find these new entries and delete them, then try the sql again. (make sure the entries you delete are FAQ related, not others)
 
Because this faq sql only add new tables or entries, it will not affect your existing shop operation.

No error for duplicates. I removed zen_ from the file enitrely.
But now I got this one.
Sorry I'm SQL noob.

: Missing parameter: import_type
: Missing parameter: format

Heres the file.

Also when clicking faq manager in admin, but I assmune thats because the SQL never finished.

1146 Table 'haskellg_estore.faqs' doesn't exist
in:
[select count(*) as count from faqs where faqs_status = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I don't know why it doen't work for you. :huh:Try to add attached FAQ tables first. It should absolutely work fine. :wink2:

the mod works fine except 1 thing.... the main page is pulled on all category (that do not contain product listing) pages. The only way to stop it seems to be removing the faq_application_top.php in open-operations folder.

BTW Hizen your shop seems to have the same issue. Although it's not a major concern since you only have 1 text line there. For me it cannot work because i have more content on the main page :no:

Alik:

the mod works fine except 1 thing.... the main page is pulled on all category (that do not contain product listing) pages. The only way to stop it seems to be removing the faq_application_top.php in open-operations folder.

BTW Hizen your shop seems to have the same issue. Although it's not a major concern since you only have 1 text line there. For me it cannot work because i have more content on the main page :no:

I can see the problem now. That's very strange, the status doesn't change even I changed the value of FAQ 'Categories with 0 FAQs Status' in both zen admin 'extras->faq manager' and in db.

Well I noticed the original sql doesn't have the zen prefix which solved that problem.

I cleaned out all faq related from DB and cut and pasted the orignal sql in.

No errors importing that sql.

There are warnings in faq_types_to_faq_category No index defined!
&
configuration UNIQUE and INDEX keys should not both be set for column configuration_key

I can't make a faq or category with getting fatal error of undefined functions. Fatal error: Call to undefined function zen_get_faq_path()

So I'm stumped. Take a look... http://www.estore.haskellgraphics.com/index.php?main_page=faqs_all

Thanks for your help.

I have the same warning message in my db. However, it doesn't seem to cause some problems for me, or perhaps I haven't noticed them.

For undefined functions, check if you have uploaded all the files, and if you have done the 2nd step in the readme file, some codes need to be added to includes/applicatio_top.php

I added the code ```
// get customers unique IP that paypal does not touch
$customers_ip_address = $_SERVER['REMOTE_ADDR'];
if (!isset($_SESSION['customers_ip_address'])) {
$_SESSION['customers_ip_address'] = $customers_ip_address;
}
?><?php // include the list of extra open-operations files if ($za_dir = @dir(DIR_WS_INCLUDES . 'open-operations')) { while ($zv_file = $za_dir->read()) { if (strstr($zv_file, '.php')) { require(DIR_WS_INCLUDES . 'open-operations/' . $zv_file); } } } ?>

All the files were there I went through it several times. Errors everytime.

Think I better just wait for the working copy and use wordpress in the meantime. After thinking about it wordpress should do the same thing.

Thanks for your help.

Dehaw:

This is a known bug and i'll also get this changed, this piece of code:

p.products_date_available

> 
> needs to be changed to
> 
> ```
p.faqs_date_available 

i'll try and make an effort to get this contrib updated and looking good.

Derek
perfectdesigning.net

So I guess there's no answer forthcoming to this then?

i too cant find the text...i originally asked about it last year around june...now i know it's not a revenue generator for you guys but please zencart is a revenue generator for you, and many of us contribute to the development of it...so can you please tidy this contribution?

i know when i asked about it the answer i got was ''sorry, its not a ticket item so we wont be putting it high on the priority list, but we should have it fixed shortly''- that was about august 2006.

another thing that this atually does is serve as visibility for your company, and an opportunity to correlate your name with a quality module...which in turn increases the chance of getting seen..

so i think theres some real reasons why pefrfect design should address this issue- more than just as a ''nice thing to do''..although let it be said that many of us do actually contribute with no commercial link or thought of financial gain.

is the above fix going to actually arrive guys?

the community needs to know, otherwise please do the right thing and ask zencart to remove it from the module downloads...as you can see it is costing people time and effort as it is.

Cheers.

Tim

Hi Tim,

We, nor anyone else is obligated to develop anything for free, we do it as a contribution to the community.

This contribution was originally developed by Dave at Open operations, we merely took it and fixed alot of bugs to get it working on a clients site, which again was a few years ago.

We are very busy and are trying our best, but we will not drop our paid work to develop a free peice of software or module. This is suppose to be a community and i fail to believe that everyone using this contrib that no one can help and fix a few of the minor problems.

If you take the poll manager or testimonials manager they have been updated by users of this forum and this community, which is good because thats the way open source and the GNU/GPL licence is suppose to work. Although i know there are others that took these modules and are now selling them as their own work.

Under no circumstances are we liable to fix anything for anyone for free, more so its kind of hard to fix a bug that everyone notices but no tells us what page this error appears, are we suppose to go through the code and hope we find the problem?

you said you were told ''sorry, its not a ticket item so we wont be putting it high on the priority list, but we should have it fixed shortly'', who exactly said that? it certainly wasn't us.

You also said "please do the right thing and ask zencart to remove it from the module downloads...as you can see it is costing people time and effort as it is.", this contribution work perfectly on our systems and we haven't come across any bugs so far, but we have removed alot of redundant code and i know there are others that also have it working fine, so why would we ask for it to be removed??

Alot of software have bugs and need updated, if we were charging for this module i'm sure we would make it more of a priority to update it, but we don't so it isn't.

If you require custom coding then ask a developer to fix the problems now? or why don't you use one of the other FAQ contributions, or why don't you do what i personally did and learn the code, which does take time and effort and ultimately cost, but we are certainly reaping the benefit.

or even better, get involved with the project, donate towards its development and also you may want to tell us where this problem exists so we can guide you with what to do.

The module is there its up to each individual to assess which one is best for their needs, if this one doesn't work for you then bin it and use another.

I'll say it again, we are trying to upgrade the contrib but we are very busy and we need to pay the bills so i'm not sure when we can release it, in the meantime as the community for help.

Derek

Derek, the contrib doesnt waork- as attested by this thread..thats why it should be removed. you yourself have posted the issue on this very thread..and there seems no fix.

rather than a great big defensive response to what i think were fair comments (ps it was you or one of your staff that told me about the ''priorities''...almost certain it was you actually) , just a fix or remove it...simple as that.

no need to go on and on about contribs and other's taking your work...

you are making $ on zencart itself so my thoughts are that you ARE obliged to either contribute by way of programming or donations. But that is purely on moral grounds.

all i ask is if you commit to something, see it through. its very frustrating and can only do your business harm to see that what you say doesnt match up with what you do. Like i said, its also free advertising...so in many ways is much more of a ''paying'' effort than you might think.

so is there any fix for the quoted issue?.

Tim

skunkworx:

Derek, the contrib doesnt waork- as attested by this thread..thats why it should be removed. you yourself have posted the issue on this very thread..and there seems no fix.

rather than a great big defensive response to what i think were fair comments (ps it was you or one of your staff that told me about the ''priorities''...almost certain it was you actually) , just a fix or remove it...simple as that.

no need to go on and on about contribs and other's taking your work...

you are making $ on zencart itself so my thoughts are that you ARE obliged to either contribute by way of programming or donations. But that is purely on moral grounds.

all i ask is if you commit to something, see it through. its very frustrating and can only do your business harm to see that what you say doesnt match up with what you do. Like i said, its also free advertising...so in many ways is much more of a ''paying'' effort than you might think.

so is there any fix for the quoted issue?.

Tim

Tim,

This contrib is the result of open operations, all we did is merely fixed a few bugs to get it working for one of our clients, it was already released by open operations before we even touched it.

We are no way obliged to do anything for anyone for free and i'm sure you also wouldn't want to work for free, we all have our bills to pay, and quite frankly i'm not interested in developing a program for free when i need to feed my kids.

I will not be doing any further development on this contrib until we have time, however being a very busy company goodness knows when that will be.

As for removing the contrib, if the guys at zencart want to do that then fine, but it will always be available from our site. I mean the contrib is there for those who wish to use it since it does work and there are many using it as we speak, i really am not that interested if you or anyone else uses it or not, its not our original work and we do not need to stand by it, but we are more than happy for others to download and use it if they so wish.

Yes thats right as a development company who uses zencart we will be making $$ off the back of this great software package, just like many others, although i personally have been a long member of these forums and USED to help out alot in the past but because we are good at what we do we are too busy now, is that good or bad, well i need to feed my family so it must be good.

I don't understand how you can say that we are not a committed company that supports their work, go to our site and read the testimonials submitted by our clients, what do they say??

As i said this contrib was NOT our original work, we only fixed a few bugs to get it working for a client a few years back and then released it again as a near working mod.

Open Operations had a great idea there but failed to deliver and we are currently working on this contrib on a clients site to clean up the code, fix bugs and remove the redundant stuff, but again who knows when that will be done.

So what issue are you talking about? I already asked in my last reply to provide details.

For those that are interested we will be releasing a help desk manager soon!

Derek

p.s. i don't mean to be defensive but it really does get my back up when people think that all development is free because we all use an open source free peice of software, oh and BTW, open source does not mean free.

the issue is quoted at the top of this page.

its the p.products v p.faq code that no one can find.

im just trying to be middle o the road here...my belief obviously differs from yours philosophically as i think that there is some obligation...financial or otherwise...thats all.

skunkworx:

the issue is quoted at the top of this page.

its the p.products v p.faq code that no one can find.

im just trying to be middle o the road here...my belief obviously differs from yours philosophically as i think that there is some obligation...financial or otherwise...thats all.

Tim,

We deal mainly in open source software thats released under the GNU/GPL licence, you should give it a read its quite interesting. The problem we as a company have experienced in the past and continue to do so is alot of people that use these softwares expect to get free support, free development and as you keep pointing out, the developers have an obligation to fix things.

This clearly is incorrect since its up to the companies or developers whether they provide support or continue to develop the software. i know of many companies that release open source software and only provide paid support because thats where alot of the time and energy is consumed. other companies or collaborative developers like the Zen cart team offer user led forums such as this one where users can help each other to solve problems and report bugs, you'll find that although they accept donations from users of zencart that still does not mean that the team must update the software, although in most cases they do, which generally results in some sort of payment whether it be donations or otherwise.

I have always stated that we are prepared to update the module since it would and is useful for our own clients, but as i keep stating we need to try and find the time to do this over and above our day jobs, but just because we released an updated copy of somone elses module that doesn't mean that we are obligated to fix the problems, there is no reason that any other developer on this forum can help.

Anyway enough said, i think your original post could have been worded slightly better, i mean the time i've spent time writing these posts could have been better spent solving the problem.

I know that the problem is stated above but as i said before i refuse to search through everyfile to find out where the problem exists, so tell me the page that you are trying to access, then i can look at the code on the page, otherwise we will be going around in circles.

Derek

So, would you kindly mind telling us which file contains the p.products code line that needs to be changed? I have searched and can't seem to find it.

good luck dude..this is what we all want to know.

it seems that it isnt there at all, and when asked for it, the answer is never given.

just a thesis on the position of the company's position on contributions.

lord knows i tried to get the answer.

Yes this is actually correct!

This line of code does NOT exist in this contribution, i have installed this module 3 times on a fresh system and did not see this problem, which seems to exists within the module. We also done a complete search & replace on all the files for this peice of code which returned no results.

So you ask where do you go from here?

Well, try turning off all the other modules to the side where the faq manager module is currently sitting and then we can see what the conflicting module is.

What does this mean?

This means there is another module within zencart thats conflicting with the faq categories module, once we can figure this out i'll recode the module to stop that happening, until that happens nothing can be done.

skunkworx:

good luck dude..this is what we all want to know.

it seems that it isnt there at all, and when asked for it, the answer is never given.

just a thesis on the position of the company's position on contributions.

lord knows i tried to get the answer.

BTW Tim, i asked in a previous message for you to tell me where the error was showing, i.e. what page, you never replied, so you never got an answer!

The reason i can provide this answer is because i was contacted by a user who respects the fact that this is a FREE unpaid for module that comes as is and is not supported by us, remember we never developed this god damn module we only amended it for our own needs then released it so don't start slandering our company or making us feel like all these problems MUST be fixed by us because they certainly do not and by posting the way you do i'm surpised you get any help.

Read our testimonials, speak to our clients, see what other mods we have helped create or fix, what exactly have you done except moan?

Derek

derek..major meltdown dude...i wasnt the first to ask where the code was.

either put up a contrib that works or expect some people to ask for help to make it work.

and stop whining when they do..its inevitable.

thankyou so lordy god you are the best thing ever to have contributed to zencart. i owe you all of my success.

many of us contribute in many ways and probbaly much more than you do and dont complain and whinge about it. so pull your head in mate..

you've known about this issue since last august and back then promised to fix it.

all peeps are asking is if its going to be fixed..not war and peace on your thoughts on teh world of open source.

are you going to fix it or not?..simple as that...if not, then we can close this threa and move on.

ion the meantime people are viewing this thread that could be your potential customers.

i thought it wouldve been a great opportunity to look real good..but instead youve proven yourself to be difficult, whiney, full of excuses and defensive...man id hat eto contract you for some coding..id be worried about technical aspects i didnt write into my contract...

over to you..shine or whine.

oh, fwiw it was YOU who wrote where the error was..so why ask me?...see the first post on this page..its signed ...derek...

good lord.