@@ -27,7 +27,7 @@ discard block |
||
27 | 27 | define('_MD_SF_CONTEXTMODULELINK', 'Contextually linked to this module'); |
28 | 28 | define('_MD_SF_CONTEXTMODULELINK_FAQ', 'Contextually linked to this module'); |
29 | 29 | define('_MD_SF_CONTEXTMODULELINK_FAQ_DSC', |
30 | - "Select the module to which this Q&A will be linked. If the Contextual Q&A block is visible on that module, the 'How do I' statement of this Q&A will be displayed."); |
|
30 | + "Select the module to which this Q&A will be linked. If the Contextual Q&A block is visible on that module, the 'How do I' statement of this Q&A will be displayed."); |
|
31 | 31 | define('_MD_SF_CONTEXTPAGE', 'Contextually linked to this URL'); |
32 | 32 | define('_MD_SF_CONTEXTPAGEDEF', 'Contextual Page'); |
33 | 33 | define('_MD_SF_CONTEXTPAGEDEF_DSC', 'Page for which this Q&A gives explanation <b>Example :</b> modules/newbb'); |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | define('_MD_SF_ERRORSAVINGDB', 'ERROR: Database has NOT been Updated due to an Error!'); |
54 | 54 | define('_MD_SF_EXACTURL', 'Exact URL?'); |
55 | 55 | define('_MD_SF_EXACTURL_DSC', |
56 | - "If set to 'Yes', the Q&A will only display in the'Specific URL set above'. If set to 'No', the Q&A will be displayed all pages that match a part of the root of the specific URL.ie modules/newbb/*.php"); |
|
56 | + "If set to 'Yes', the Q&A will only display in the'Specific URL set above'. If set to 'No', the Q&A will be displayed all pages that match a part of the root of the specific URL.ie modules/newbb/*.php"); |
|
57 | 57 | define('_MD_SF_FAQ_NEW_ANSWER_NEED_APPROBATION', 'Your answer was submitted successfully and will be reviewed by a moderator.'); |
58 | 58 | define('_MD_SF_FAQ_NEW_ANSWER_PUBLISHED', 'Your answer was submitted successfully and will be automatically published in the Q&A section, as a replacement of the original answer.'); |
59 | 59 | define('_MD_SF_FAQCOMEFROM', 'This Q&A was found on '); |
@@ -77,9 +77,9 @@ discard block |
||
77 | 77 | define('_MD_SF_MAIL', 'Send Q&A'); |
78 | 78 | define('_MD_SF_MAINHEAD', 'Welcome to the'); |
79 | 79 | define('_MD_SF_MAININTRO', |
80 | - "In this area of the site, you will find the answers to the frequently asked questions. Each Q&A is placed in a category for easier finding. This is the section from where the random Q&As in the right column of the site come from. Should you not find the answer to a particular question, don't hesitate to <a href='" |
|
81 | - . XOOPS_URL |
|
82 | - . "/forms/askus/form.php'>Ask us a Question!</a>"); |
|
80 | + "In this area of the site, you will find the answers to the frequently asked questions. Each Q&A is placed in a category for easier finding. This is the section from where the random Q&As in the right column of the site come from. Should you not find the answer to a particular question, don't hesitate to <a href='" |
|
81 | + . XOOPS_URL |
|
82 | + . "/forms/askus/form.php'>Ask us a Question!</a>"); |
|
83 | 83 | define('_MD_SF_MAINNOSELECTCAT', 'You did not select a valid category'); |
84 | 84 | define('_MD_SF_MAINNOFAQS', 'There are no Q&As in this category'); |
85 | 85 | define('_MD_SF_MODERATION_MAIN_HEAD', 'Moderation section of '); |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | define('_MD_SF_REQUEST', 'Request a new Q&A'); |
120 | 120 | define('_MD_SF_REQUEST_ERROR', 'An error occured. Your request was not sent.'); |
121 | 121 | define('_MD_SF_REQUEST_INTRO', |
122 | - 'You did not find the answer to the question you were looking for? No problem! Simply fill the following form in order to request the answer for a new question. The site administrator will review your request and publish this new question in the Open Questions section for someone to answer it!'); |
|
122 | + 'You did not find the answer to the question you were looking for? No problem! Simply fill the following form in order to request the answer for a new question. The site administrator will review your request and publish this new question in the Open Questions section for someone to answer it!'); |
|
123 | 123 | define('_MD_SF_REQUEST_RECEIVED_NEED_APPROVAL', 'Your request has been sent and will be published in the Open Questions section upon approval by a moderator.<br>Thank you for your contribution!'); |
124 | 124 | define('_MD_SF_REQUEST_RECEIVED_AND_PUBLISHED', 'Your request has been sent and automatically published in the Open Questions section. Thank you for your contribution!'); |
125 | 125 | define('_MD_SF_REQUESTED', 'Requested'); |
@@ -140,7 +140,7 @@ discard block |
||
140 | 140 | define('_MD_SF_SUBMITANSWER', 'Submit answer'); |
141 | 141 | define('_MD_SF_SUBMITANSWERTO', 'Submit an answer to %s'); |
142 | 142 | define('_MD_SF_SUBMITANSWER_INTRO', |
143 | - 'please fill this form to submit an answer for this question. The site adminisrator will review it and then publish it as soon as possible. Thank you in advance for your contribution.'); |
|
143 | + 'please fill this form to submit an answer for this question. The site adminisrator will review it and then publish it as soon as possible. Thank you in advance for your contribution.'); |
|
144 | 144 | define('_MD_SF_SUBMITANSWERBUTTON', 'Submit the answer'); |
145 | 145 | define('_MD_SF_SUBMITAPPROVED', 'The answer you sent has been received. Since the auto-approve option is on, the answer has been accepted and the Q&A has been published.'); |
146 | 146 | define('_MD_SF_SUBMIT_FROM_ADMIN', 'Since you are an admin of the module, the Q&A was automatically published with all permissions.'); |
@@ -27,14 +27,14 @@ discard block |
||
27 | 27 | define('_AM_SF_ANSWERING', 'Answering'); |
28 | 28 | define('_AM_SF_ANSWERED', 'Answered'); |
29 | 29 | define('_AM_SF_ANSWERED_EXP', |
30 | - '<b>Answered questions</b> : Questions in the Open Questions section that have been answered by users. Once an answer has been approved for a question, this very question becomes a submitted Q&A and will require approval as well.'); |
|
30 | + '<b>Answered questions</b> : Questions in the Open Questions section that have been answered by users. Once an answer has been approved for a question, this very question becomes a submitted Q&A and will require approval as well.'); |
|
31 | 31 | define('_AM_SF_ANSWERED_MODERATE', 'Moderate the answer to this question'); |
32 | 32 | define('_AM_SF_ANSWERISDELETED', 'The answer has been deleted.'); |
33 | 33 | define('_AM_SF_ANSWERNOTFOUND', 'Error : No official answer was found'); |
34 | 34 | define('_AM_SF_APPROVE', 'Approve'); |
35 | 35 | define('_AM_SF_APPROVED', 'Approved answer'); |
36 | 36 | define('_AM_SF_APPROVED_INFO', |
37 | - 'The answer for this question has been approved. This question has now been promoted to the status of submitted Q&A and needs an approval to be published in the Q&A section.'); |
|
37 | + 'The answer for this question has been approved. This question has now been promoted to the status of submitted Q&A and needs an approval to be published in the Q&A section.'); |
|
38 | 38 | define('_AM_SF_APPROVED_MODERATE', "Moderate this Q&A's submission"); |
39 | 39 | define('_AM_SF_APPROVED_TITLE', 'Approved answer'); |
40 | 40 | define('_AM_SF_APPROVESUB', 'Approve submission'); |
@@ -51,10 +51,10 @@ discard block |
||
51 | 51 | define('_AM_SF_ASKED', 'Asked'); |
52 | 52 | define('_AM_SF_ASKED_APPROVE_SUCCESS', 'The asked question was answered and the Q&A was published in the public section of the site.'); |
53 | 53 | define('_AM_SF_ASKED_EXP', |
54 | - '<b>Asked questions</b> : questions that have been asked by users. These questions have not yet been approved by a moderator. Once approved, the <i>Asked question</i> will become an <i>Open question<i> and be displayed in the <b>Open Questions</b> section.'); |
|
54 | + '<b>Asked questions</b> : questions that have been asked by users. These questions have not yet been approved by a moderator. Once approved, the <i>Asked question</i> will become an <i>Open question<i> and be displayed in the <b>Open Questions</b> section.'); |
|
55 | 55 | define('_AM_SF_ASKED_TITLE', 'Asked Question'); |
56 | 56 | define('_AM_SF_ASKED_TITLE_INFO', |
57 | - 'This is a question asked by a user. You can review the question and write the answer.<br>Uppon approval, the Q&A will be published in the public section of the site.'); |
|
57 | + 'This is a question asked by a user. You can review the question and write the answer.<br>Uppon approval, the Q&A will be published in the public section of the site.'); |
|
58 | 58 | define('_AM_SF_AUTHFAQ', 'Publish the submitted answer'); |
59 | 59 | define('_AM_SF_AUTHORIZE', 'Authorize'); |
60 | 60 | define('_AM_SF_BACK2IDX', 'Cancelled. Taking you back to the index'); |
@@ -81,7 +81,7 @@ discard block |
||
81 | 81 | define('_AM_SF_CATHEADER', 'Categories Management'); |
82 | 82 | define('_AM_SF_CONTEXTMODULELINK', 'Contextually linked to this module'); |
83 | 83 | define('_AM_SF_CONTEXTMODULELINK_FAQ', |
84 | - "Contextually linked to this module<span style='font-size: xx-small; font-weight: normal; display: block;'>Select the module to which this Q&A will be<br>linked. If the Contextual FAQ block is visible<br>on that module, the 'How do I' statement of<br>this Q&A will be displayed.</span>"); |
|
84 | + "Contextually linked to this module<span style='font-size: xx-small; font-weight: normal; display: block;'>Select the module to which this Q&A will be<br>linked. If the Contextual FAQ block is visible<br>on that module, the 'How do I' statement of<br>this Q&A will be displayed.</span>"); |
|
85 | 85 | define('_AM_SF_CONTEXTOPTIONS', 'Contextual options'); |
86 | 86 | define('_AM_SF_CONTEXTPAGE', 'Contextually linked to this URL'); |
87 | 87 | define('_AM_SF_CONTEXTURLLINK', 'Link to this URL'); |
@@ -97,7 +97,7 @@ discard block |
||
97 | 97 | define('_AM_SF_DELETE', 'Delete'); |
98 | 98 | define('_AM_SF_DELETEART', 'Delete Q&A'); |
99 | 99 | define('_AM_SF_DELETE_CAT_CONFIRM', |
100 | - 'Please note that by deleting a category, all the sub-categories and the Q&A of this category will be deleted as well, along with any comments that may have been posted related to these Q&A. Are you sure you wish to delete this category?'); |
|
100 | + 'Please note that by deleting a category, all the sub-categories and the Q&A of this category will be deleted as well, along with any comments that may have been posted related to these Q&A. Are you sure you wish to delete this category?'); |
|
101 | 101 | define('_AM_SF_DELETE_CAT_ERROR', 'An error occured while deleting this category.'); |
102 | 102 | define('_AM_SF_DELETECOL', 'Delete category'); |
103 | 103 | define('_AM_SF_DELETESUBM', 'Delete submission'); |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | define('_AM_SF_ERROR_ANSWER_NOT_SAVED', 'An error occured. The answer was not saved in the database.'); |
124 | 124 | define('_AM_SF_ERROR_FAQ_NOT_SAVED', 'An error occured. The Q&A was not saved in the database.'); |
125 | 125 | define('_AM_SF_EXACTURL', |
126 | - "Exact URL?<span style='font-size: xx-small; font-weight: normal; display: block;'>If set to 'Yes', the Q&A will only display in the'Specific URL set above'. If set to 'No', the Q&A will be displayed in all pages that match a part of the root of the specific URL. ie; modules/newbb/*.php</span>"); |
|
126 | + "Exact URL?<span style='font-size: xx-small; font-weight: normal; display: block;'>If set to 'Yes', the Q&A will only display in the'Specific URL set above'. If set to 'No', the Q&A will be displayed in all pages that match a part of the root of the specific URL. ie; modules/newbb/*.php</span>"); |
|
127 | 127 | define('_AM_SF_FAQ_EDIT', 'Edit this Q&A'); |
128 | 128 | define('_AM_SF_FAQ_NEW_ANSWER_PUBLISHED', 'The original answer was replaced by this answer.'); |
129 | 129 | define('_AM_SF_FAQ_REVIEW', 'Edit this answer before approbation'); |
@@ -135,7 +135,7 @@ discard block |
||
135 | 135 | define('_AM_SF_HELP', 'Help'); |
136 | 136 | define('_AM_SF_HOWDOI', 'How do I...'); |
137 | 137 | define('_AM_SF_HOWDOI_FAQ', |
138 | - "How do I...<span style='font-size: xx-small; font-weight: normal; display: block;'>This will be used in the Contextual FAQ Block.<br>It should be a short version of the question.</span>"); |
|
138 | + "How do I...<span style='font-size: xx-small; font-weight: normal; display: block;'>This will be used in the Contextual FAQ Block.<br>It should be a short version of the question.</span>"); |
|
139 | 139 | define('_AM_SF_ID', 'Id'); |
140 | 140 | define('_AM_SF_IMPORT', 'Import'); |
141 | 141 | define('_AM_SF_IMPORT_ALL_QUESTIONS', 'All questions'); |
@@ -158,7 +158,7 @@ discard block |
||
158 | 158 | define('_AM_SF_IMPORT_ONLY_VISIBLE', 'Only visible questions '); |
159 | 159 | define('_AM_SF_IMPORT_PARENT_CATEGORY', 'SmartFAQ Parent Category'); |
160 | 160 | define('_AM_SF_IMPORT_PERMISSIONS', |
161 | - "Permissions<span style='font-size: xx-small; font-weight: normal; display: block;'>Groups that will have permissions to see these imported Q&As.<br>this Q&A.</span>"); |
|
161 | + "Permissions<span style='font-size: xx-small; font-weight: normal; display: block;'>Groups that will have permissions to see these imported Q&As.<br>this Q&A.</span>"); |
|
162 | 162 | define('_AM_SF_IMPORT_RESULT', 'Here is the result of the import.'); |
163 | 163 | define('_AM_SF_IMPORT_SETTINGS', 'Import Settings'); |
164 | 164 | define('_AM_SF_IMPORT_SUCCESS', 'The Q&A set was successfully imported in the module.'); |
@@ -177,7 +177,7 @@ discard block |
||
177 | 177 | define('_AM_SF_MODART', 'Modify a Q&A'); |
178 | 178 | define('_AM_SF_MODCOL', 'Modify existing category'); |
179 | 179 | define('_AM_SF_MODERATORS_DEF', |
180 | - "Moderators<span style='font-size: xx-small; font-weight: normal; display: block;'>Users that will act as moderators for this<br>category. They will be able to add, edit,<br>approve and delete questions and Q&A<br>within this category.</span>"); |
|
180 | + "Moderators<span style='font-size: xx-small; font-weight: normal; display: block;'>Users that will act as moderators for this<br>category. They will be able to add, edit,<br>approve and delete questions and Q&A<br>within this category.</span>"); |
|
181 | 181 | define('_AM_SF_MODIFY', 'Modify'); |
182 | 182 | define('_AM_SF_MODIFYCOL', 'Modify category'); |
183 | 183 | define('_AM_SF_MODIFYTHISCOL', 'Modify this category?'); |
@@ -214,7 +214,7 @@ discard block |
||
214 | 214 | define('_AM_SF_OFFLINE_FIELD', "Offline<span style='font-size: xx-small; font-weight: normal; display: block;'>Select 'No' to put this Q&A back<br>on line in the Q&A section.</span>"); |
215 | 215 | define('_AM_SF_OFFLINEEDITING', 'Editing an offline Q&A'); |
216 | 216 | define('_AM_SF_OFFLINEEDITING_INFO', |
217 | - "You can edit this offline Q&A. Modifications will be saved for this item. However, if you would like to display this Q&A in the Q&A section, you will need to set the <b>Offline</b> field to 'No'."); |
|
217 | + "You can edit this offline Q&A. Modifications will be saved for this item. However, if you would like to display this Q&A in the Q&A section, you will need to set the <b>Offline</b> field to 'No'."); |
|
218 | 218 | define('_AM_SF_OPEN_QUESTION', 'Open Question'); |
219 | 219 | define('_AM_SF_OPEN_QUESTIONS', 'Open Questions'); |
220 | 220 | define('_AM_SF_OPENED', 'Opened'); |
@@ -222,21 +222,21 @@ discard block |
||
222 | 222 | define('_AM_SF_OPENED_TITLE', 'Published questions in the Open Questions section'); |
223 | 223 | define('_AM_SF_OPENED_DSC', 'Here is a list of all the published questions in the Open Questions section.'); |
224 | 224 | define('_AM_SF_OPENED_EXP', |
225 | - '<b>Opened questions</b> : Questions that have been asked by a user, and approved by a moderator. These questions are displayed in the <i>Open Questions</i> section of this module, waiting for user to answer them.'); |
|
225 | + '<b>Opened questions</b> : Questions that have been asked by a user, and approved by a moderator. These questions are displayed in the <i>Open Questions</i> section of this module, waiting for user to answer them.'); |
|
226 | 226 | define('_AM_SF_OPTIONS', 'Options'); |
227 | 227 | define('_AM_SF_OPTS', 'Preferences'); |
228 | 228 | define('_AM_SF_OPEN_QUESTION_ANSWERING', 'Answering an open question'); |
229 | 229 | define('_AM_SF_OPEN_QUESTION_ANSWERING_INFO', 'You are now answering an open question, which will become a Q&A and be published in the Q&A section. '); |
230 | 230 | define('_AM_SF_OPENED_ANSWERING_SUCCESS', 'The open question has been answered and published in the Q&A section!'); |
231 | 231 | define('_AM_SF_PARENT_CATEGORY_EXP', |
232 | - "Parent category<span style='font-size: xx-small; font-weight: normal; display: block;'>If you want this new category to be a sub-category, select a parent here. If it is to be a top level category, leave this blank.</span>"); |
|
232 | + "Parent category<span style='font-size: xx-small; font-weight: normal; display: block;'>If you want this new category to be a sub-category, select a parent here. If it is to be a top level category, leave this blank.</span>"); |
|
233 | 233 | define('_AM_SF_PERMISSIONS', 'Permissions'); |
234 | 234 | define('_AM_SF_PERMISSIONS_FAQ', "Permissions<span style='font-size: xx-small; font-weight: normal; display: block;'>Groups that will have permissions to see<br>this Q&A.</span>"); |
235 | 235 | define('_AM_SF_PERMISSIONS_QUESTION', "Permissions<span style='font-size: xx-small; font-weight: normal; display: block;'>Groups that will have permissions to see this Question.</span>"); |
236 | 236 | define('_AM_SF_PERMISSIONS_CAT_READ', |
237 | - "Read permissions<span style='font-size: xx-small; font-weight: normal; display: block;'>Groups that will have permissions to see<br>this Category, as well as any open questions<br>and Q&A inside that category.</span>"); |
|
237 | + "Read permissions<span style='font-size: xx-small; font-weight: normal; display: block;'>Groups that will have permissions to see<br>this Category, as well as any open questions<br>and Q&A inside that category.</span>"); |
|
238 | 238 | define('_AM_SF_PERMISSIONS_APPLY_ON_FAQS', |
239 | - "Apply read permissions on Q&A<span style='font-size: xx-small; font-weight: normal; display: block;'>Apply the above Read Permissions on all<br>Q&A within that category, overriding the<br>current permissions for all these Q&A.</span>"); |
|
239 | + "Apply read permissions on Q&A<span style='font-size: xx-small; font-weight: normal; display: block;'>Apply the above Read Permissions on all<br>Q&A within that category, overriding the<br>current permissions for all these Q&A.</span>"); |
|
240 | 240 | define('_AM_SF_PERMISSIONSADMIN', 'Permissions Management'); |
241 | 241 | define('_AM_SF_PERMISSIONSVIEWMAN', 'Permissions to view categories'); |
242 | 242 | define('_AM_SF_PERMISSIONSADMINMAN', 'Permissions to moderate categories'); |
@@ -272,7 +272,7 @@ discard block |
||
272 | 272 | define('_AM_SF_REQUEST_QUEUE', 'The question has been successfully added to the Open Questions section.'); |
273 | 273 | define('_AM_SF_REJECTED_QUESTION', 'Rejected question'); |
274 | 274 | define('_AM_SF_REJECTED_QUESTION_EXP', |
275 | - '<b>Rejected question</b> : Questions that have been asked by users but rejected by a moderator. Rejected questions are not displayes in the Open Questions section.'); |
|
275 | + '<b>Rejected question</b> : Questions that have been asked by users but rejected by a moderator. Rejected questions are not displayes in the Open Questions section.'); |
|
276 | 276 | define('_AM_SF_REJECTED_SMARTFAQ', 'Rejected Q&A'); |
277 | 277 | define('_AM_SF_REJECTED_SMARTFAQ_EXP', '<b>Rejected Q&A</b> : Q&As that have been submitted by user, but rejected by a moderator. Rejected Q&As are not displayed in the Q&A section.'); |
278 | 278 | define('_AM_SF_REQUESTED_BY', 'Question asked by : '); |
@@ -289,8 +289,8 @@ discard block |
||
289 | 289 | define('_AM_SF_SUBMISSIONSMNGMT', 'Submitted Q&A'); |
290 | 290 | define('_AM_SF_SPECIFIC_URL_SELECT', 'Specific URL...'); |
291 | 291 | define('_AM_SF_SPECIFIC_URL', "Specific URL</span><span style='font-size: xx-small; font-weight: normal; display: block;'>If you have set the 'Contextually link to<br>this module' to <i>" |
292 | - . _AM_SF_SPECIFIC_URL_SELECT |
|
293 | - . "</i>, please<br>specify the URL.<br>\n<b>Example :</b> modules/newbb</span>"); |
|
292 | + . _AM_SF_SPECIFIC_URL_SELECT |
|
293 | + . "</i>, please<br>specify the URL.<br>\n<b>Example :</b> modules/newbb</span>"); |
|
294 | 294 | define('_AM_SF_SUBMISSION_MODERATE', "Moderate this Q&A's submission"); |
295 | 295 | define('_AM_SF_SUBMITTED', 'Submitted'); |
296 | 296 | define('_AM_SF_SUBMITTED_EXP', '<b>Submitted Q&A</b> : Q&A that have been submitted by users. Once approved, they will be displayed in the Q&A section.'); |
@@ -298,7 +298,7 @@ discard block |
||
298 | 298 | define('_AM_SF_SUBMITTED_ANSWER_ACCEPTED', 'The submitted answer has been approved.'); |
299 | 299 | define('_AM_SF_SUBMITTED_ANSWER_INFO', 'Here is a list of submitted answers for that question. Select one of them to be the official answer for that question.'); |
300 | 300 | define('_AM_SF_SUBMITTED_INFO', |
301 | - 'This Q&A has been submitted by a member. You can make some modifications if you like. Upon approval, this Q&A will be displayed in the Q&A section of this site.'); |
|
301 | + 'This Q&A has been submitted by a member. You can make some modifications if you like. Upon approval, this Q&A will be displayed in the Q&A section of this site.'); |
|
302 | 302 | define('_AM_SF_SUBMITTED_APPROVE_SUCCESS', 'The submitted Q&A has been published in the Q&A section.'); |
303 | 303 | define('_AM_SF_SUBMITTED_TITLE', 'Approving a submitted Q&A'); |
304 | 304 | define('_AM_SF_FAQ_DELETE_ERROR', 'An error occured while deleting this Q&A.'); |
@@ -333,10 +333,10 @@ discard block |
||
333 | 333 | |
334 | 334 | if ($category->isNew()) { |
335 | 335 | $sql = sprintf('INSERT INTO %s (categoryid, parentid, name, description, total, weight, created) VALUES (NULL, %u, %s, %s, %u, %u, %u)', $this->db->prefix('smartfaq_categories'), |
336 | - $parentid, $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, time()); |
|
336 | + $parentid, $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, time()); |
|
337 | 337 | } else { |
338 | 338 | $sql = sprintf('UPDATE %s SET parentid = %u, name = %s, description = %s, total = %s, weight = %u, created = %u WHERE categoryid = %u', $this->db->prefix('smartfaq_categories'), $parentid, |
339 | - $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, $created, $categoryid); |
|
339 | + $this->db->quoteString($name), $this->db->quoteString($description), $total, $weight, $created, $categoryid); |
|
340 | 340 | } |
341 | 341 | if (false != $force) { |
342 | 342 | $result = $this->db->queryF($sql); |
@@ -520,10 +520,10 @@ discard block |
||
520 | 520 | $ret = array(); |
521 | 521 | $limit = $start = 0; |
522 | 522 | $sql = 'SELECT DISTINCT c.categoryid, c.parentid, c.name, c.description, c.total, c.weight, c.created FROM ' |
523 | - . $this->db->prefix('smartfaq_categories') |
|
524 | - . ' AS c INNER JOIN ' |
|
525 | - . $this->db->prefix('smartfaq_faq') |
|
526 | - . ' AS f ON c.categoryid = f.categoryid'; |
|
523 | + . $this->db->prefix('smartfaq_categories') |
|
524 | + . ' AS c INNER JOIN ' |
|
525 | + . $this->db->prefix('smartfaq_faq') |
|
526 | + . ' AS f ON c.categoryid = f.categoryid'; |
|
527 | 527 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
528 | 528 | $sql .= ' ' . $criteria->renderWhere(); |
529 | 529 | if ($criteria->getSort() != '') { |
@@ -474,10 +474,10 @@ |
||
474 | 474 | |
475 | 475 | if ($answerObj->isNew()) { |
476 | 476 | $sql = sprintf('INSERT INTO %s (answerid, `status`, faqid, answer, uid, datesub, notifypub) VALUES (NULL, %u, %u, %s, %u, %u, %u)', $this->db->prefix('smartfaq_answers'), $status, $faqid, |
477 | - $this->db->quoteString($answer), $uid, time(), $notifypub); |
|
477 | + $this->db->quoteString($answer), $uid, time(), $notifypub); |
|
478 | 478 | } else { |
479 | 479 | $sql = sprintf('UPDATE %s SET STATUS = %u, faqid = %s, answer = %s, uid = %u, datesub = %u, notifypub = %u WHERE answerid = %u', $this->db->prefix('smartfaq_answers'), $status, $faqid, |
480 | - $this->db->quoteString($answer), $uid, $datesub, $notifypub, $answerid); |
|
480 | + $this->db->quoteString($answer), $uid, $datesub, $notifypub, $answerid); |
|
481 | 481 | } |
482 | 482 | |
483 | 483 | if (false != $force) { |
@@ -647,16 +647,16 @@ discard block |
||
647 | 647 | } |
648 | 648 | |
649 | 649 | return $text |
650 | - . $xoopsConfig['sitename'] |
|
651 | - . ' : <a href=' |
|
652 | - . XOOPS_URL |
|
653 | - . '/modules/smartfaq/faq.php?faqid=' |
|
654 | - . $this->faqid() |
|
655 | - . '>' |
|
656 | - . XOOPS_URL |
|
657 | - . '/modules/smartfaq/faq.php?faqid=' |
|
658 | - . $this->faqid() |
|
659 | - . '</a>'; |
|
650 | + . $xoopsConfig['sitename'] |
|
651 | + . ' : <a href=' |
|
652 | + . XOOPS_URL |
|
653 | + . '/modules/smartfaq/faq.php?faqid=' |
|
654 | + . $this->faqid() |
|
655 | + . '>' |
|
656 | + . XOOPS_URL |
|
657 | + . '/modules/smartfaq/faq.php?faqid=' |
|
658 | + . $this->faqid() |
|
659 | + . '</a>'; |
|
660 | 660 | } |
661 | 661 | |
662 | 662 | /** |
@@ -778,14 +778,14 @@ discard block |
||
778 | 778 | |
779 | 779 | if ($faq->isNew()) { |
780 | 780 | $sql = sprintf('INSERT INTO %s (faqid, categoryid, question, howdoi, diduno, uid, datesub, `status`, counter, weight, html, smiley, xcodes, cancomment, comments, notifypub, modulelink, contextpage, exacturl, partialview) VALUES (NULL, %u, %s, %s, %s, %u, %u, %u, %u, %u, %u, %u, %u, %u, %u, %u, %s, %s, %u, %u)', |
781 | - $this->db->prefix('smartfaq_faq'), $categoryid, $this->db->quoteString($question), $this->db->quoteString($howdoi), $this->db->quoteString($diduno), $uid, time(), $status, |
|
782 | - $counter, $weight, $html, $smiley, $xcodes, $cancomment, $comments, $notifypub, $this->db->quoteString($modulelink), $this->db->quoteString($contextpage), $exacturl, |
|
783 | - $partialview); |
|
781 | + $this->db->prefix('smartfaq_faq'), $categoryid, $this->db->quoteString($question), $this->db->quoteString($howdoi), $this->db->quoteString($diduno), $uid, time(), $status, |
|
782 | + $counter, $weight, $html, $smiley, $xcodes, $cancomment, $comments, $notifypub, $this->db->quoteString($modulelink), $this->db->quoteString($contextpage), $exacturl, |
|
783 | + $partialview); |
|
784 | 784 | } else { |
785 | 785 | $sql = sprintf('UPDATE %s SET categoryid = %u, question = %s, howdoi = %s, diduno = %s, uid = %u, datesub = %u, `status` = %u, counter = %u, weight = %u, html = %u, smiley = %u, xcodes = %u, cancomment = %u, comments = %u, notifypub = %u, modulelink = %s, contextpage = %s, exacturl = %u, partialview = %u WHERE faqid = %u', |
786 | - $this->db->prefix('smartfaq_faq'), $categoryid, $this->db->quoteString($question), $this->db->quoteString($howdoi), $this->db->quoteString($diduno), $uid, $datesub, $status, |
|
787 | - $counter, $weight, $html, $smiley, $xcodes, $cancomment, $comments, $notifypub, $this->db->quoteString($modulelink), $this->db->quoteString($contextpage), $exacturl, |
|
788 | - $partialview, $faqid); |
|
786 | + $this->db->prefix('smartfaq_faq'), $categoryid, $this->db->quoteString($question), $this->db->quoteString($howdoi), $this->db->quoteString($diduno), $uid, $datesub, $status, |
|
787 | + $counter, $weight, $html, $smiley, $xcodes, $cancomment, $comments, $notifypub, $this->db->quoteString($modulelink), $this->db->quoteString($contextpage), $exacturl, |
|
788 | + $partialview, $faqid); |
|
789 | 789 | } |
790 | 790 | if (false != $force) { |
791 | 791 | $result = $this->db->queryF($sql); |
@@ -1618,10 +1618,10 @@ discard block |
||
1618 | 1618 | $criteria->setOrder('DESC'); |
1619 | 1619 | |
1620 | 1620 | $sql = 'SELECT faq.faqid, faq.question, faq.datesub, faq.uid FROM ' |
1621 | - . $this->db->prefix('smartfaq_faq') |
|
1622 | - . ' AS faq INNER JOIN ' |
|
1623 | - . $this->db->prefix('smartfaq_answers') |
|
1624 | - . ' AS answer ON faq.faqid = answer.faqid'; |
|
1621 | + . $this->db->prefix('smartfaq_faq') |
|
1622 | + . ' AS faq INNER JOIN ' |
|
1623 | + . $this->db->prefix('smartfaq_answers') |
|
1624 | + . ' AS answer ON faq.faqid = answer.faqid'; |
|
1625 | 1625 | |
1626 | 1626 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
1627 | 1627 | $whereClause = $criteria->renderWhere(); |
@@ -67,9 +67,9 @@ |
||
67 | 67 | if ($pid != 0 && !in_array($pid, array_keys($item_ids))) { |
68 | 68 | // one of the parent items were not selected, so skip this item |
69 | 69 | $msg[] = sprintf(_MD_AM_PERMADDNG, '<b>' . $perm_name . '</b>', '<b>' . $perm_data['itemname'][$item_id] . '</b>', '<b>' . $group_list[$group_id] . '</b>') |
70 | - . ' (' |
|
71 | - . _MD_AM_PERMADDNGP |
|
72 | - . ')'; |
|
70 | + . ' (' |
|
71 | + . _MD_AM_PERMADDNGP |
|
72 | + . ')'; |
|
73 | 73 | continue 2; |
74 | 74 | } |
75 | 75 | } |
@@ -41,12 +41,12 @@ |
||
41 | 41 | // Left headings... |
42 | 42 | echo "<img src='" . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/' . $versioninfo->getInfo('image') . "' alt='' hspace='0' vspace='0' align='left' style='margin-right: 10px;'/></a>"; |
43 | 43 | echo "<div style='margin-top: 10px; color: #33538e; margin-bottom: 4px; font-size: 18px; line-height: 18px; font-weight: bold; display: block;'>" |
44 | - . $versioninfo->getInfo('name') |
|
45 | - . ' version ' |
|
46 | - . $versioninfo->getInfo('version') |
|
47 | - . ' (' |
|
48 | - . $versioninfo->getInfo('status_version') |
|
49 | - . ')</div>'; |
|
44 | + . $versioninfo->getInfo('name') |
|
45 | + . ' version ' |
|
46 | + . $versioninfo->getInfo('version') |
|
47 | + . ' (' |
|
48 | + . $versioninfo->getInfo('status_version') |
|
49 | + . ')</div>'; |
|
50 | 50 | if ($versioninfo->getInfo('author_realname') != '') { |
51 | 51 | $author_name = $versioninfo->getInfo('author') . ' (' . $versioninfo->getInfo('author_realname') . ')'; |
52 | 52 | } else { |
@@ -37,25 +37,25 @@ discard block |
||
37 | 37 | } |
38 | 38 | } |
39 | 39 | $modify = "<a href='category.php?op=mod&categoryid=" |
40 | - . $categoryObj->categoryid() |
|
41 | - . "'><img src='" |
|
42 | - . $pathIcon16 |
|
43 | - . '/edit.png' |
|
44 | - . "' title='" |
|
45 | - . _AM_SF_EDITCOL |
|
46 | - . "' alt='" |
|
47 | - . _AM_SF_EDITCOL |
|
48 | - . "' /></a>"; |
|
40 | + . $categoryObj->categoryid() |
|
41 | + . "'><img src='" |
|
42 | + . $pathIcon16 |
|
43 | + . '/edit.png' |
|
44 | + . "' title='" |
|
45 | + . _AM_SF_EDITCOL |
|
46 | + . "' alt='" |
|
47 | + . _AM_SF_EDITCOL |
|
48 | + . "' /></a>"; |
|
49 | 49 | $delete = "<a href='category.php?op=del&categoryid=" |
50 | - . $categoryObj->categoryid() |
|
51 | - . "'><img src='" |
|
52 | - . $pathIcon16 |
|
53 | - . '/delete.png' |
|
54 | - . "' title='" |
|
55 | - . _AM_SF_DELETECOL |
|
56 | - . "' alt='" |
|
57 | - . _AM_SF_DELETECOL |
|
58 | - . "' /></a>"; |
|
50 | + . $categoryObj->categoryid() |
|
51 | + . "'><img src='" |
|
52 | + . $pathIcon16 |
|
53 | + . '/delete.png' |
|
54 | + . "' title='" |
|
55 | + . _AM_SF_DELETECOL |
|
56 | + . "' alt='" |
|
57 | + . _AM_SF_DELETECOL |
|
58 | + . "' /></a>"; |
|
59 | 59 | |
60 | 60 | $spaces = ''; |
61 | 61 | for ($j = 0; $j < $level; ++$j) { |
@@ -64,18 +64,18 @@ discard block |
||
64 | 64 | |
65 | 65 | echo '<tr>'; |
66 | 66 | echo "<td class='even' align='lefet'>" |
67 | - . $spaces |
|
68 | - . "<a href='" |
|
69 | - . XOOPS_URL |
|
70 | - . '/modules/' |
|
71 | - . $xoopsModule->dirname() |
|
72 | - . '/category.php?categoryid=' |
|
73 | - . $categoryObj->categoryid() |
|
74 | - . "'><img src='" |
|
75 | - . XOOPS_URL |
|
76 | - . "/modules/smartfaq/assets/images/icon/subcat.gif' alt='' /> " |
|
77 | - . $categoryObj->name() |
|
78 | - . '</a></td>'; |
|
67 | + . $spaces |
|
68 | + . "<a href='" |
|
69 | + . XOOPS_URL |
|
70 | + . '/modules/' |
|
71 | + . $xoopsModule->dirname() |
|
72 | + . '/category.php?categoryid=' |
|
73 | + . $categoryObj->categoryid() |
|
74 | + . "'><img src='" |
|
75 | + . XOOPS_URL |
|
76 | + . "/modules/smartfaq/assets/images/icon/subcat.gif' alt='' /> " |
|
77 | + . $categoryObj->name() |
|
78 | + . '</a></td>'; |
|
79 | 79 | echo "<td class='even' align='left'>" . $description . '</td>'; |
80 | 80 | echo "<td class='even' align='center'>" . $categoryObj->weight() . '</td>'; |
81 | 81 | echo "<td class='even' align='center'> $modify $delete </td>"; |
@@ -332,11 +332,11 @@ discard block |
||
332 | 332 | $categoryid = isset($_GET['categoryid']) ? (int)$_GET['categoryid'] : 0; |
333 | 333 | xoops_cp_header(); |
334 | 334 | xoops_confirm(array( |
335 | - 'op' => 'del', |
|
336 | - 'categoryid' => $categoryObj->categoryid(), |
|
337 | - 'confirm' => 1, |
|
338 | - 'name' => $categoryObj->name() |
|
339 | - ), 'category.php', _AM_SF_DELETECOL . " '" . $categoryObj->name() . "'. <br> <br>" . _AM_SF_DELETE_CAT_CONFIRM, _AM_SF_DELETE); |
|
335 | + 'op' => 'del', |
|
336 | + 'categoryid' => $categoryObj->categoryid(), |
|
337 | + 'confirm' => 1, |
|
338 | + 'name' => $categoryObj->name() |
|
339 | + ), 'category.php', _AM_SF_DELETECOL . " '" . $categoryObj->name() . "'. <br> <br>" . _AM_SF_DELETE_CAT_CONFIRM, _AM_SF_DELETE); |
|
340 | 340 | xoops_cp_footer(); |
341 | 341 | } |
342 | 342 | exit(); |
@@ -46,8 +46,8 @@ |
||
46 | 46 | echo '<span style="color: #567; margin: 3px 0 12px 0; font-size: small; display: block; ">' . sprintf(_AM_SF_IMPORT_MODULE_FOUND_NO_FAQ, $importFromModuleName, $totalCat) . '</span>'; |
47 | 47 | } else { |
48 | 48 | echo '<span style="color: #567; margin: 3px 0 12px 0; font-size: small; display: block; ">' |
49 | - . sprintf(_AM_SF_IMPORT_MODULE_FOUND, $importFromModuleName, $totalCat, $totalFAQ) |
|
50 | - . '</span>'; |
|
49 | + . sprintf(_AM_SF_IMPORT_MODULE_FOUND, $importFromModuleName, $totalCat, $totalFAQ) |
|
50 | + . '</span>'; |
|
51 | 51 | |
52 | 52 | $form = new XoopsThemeForm(_AM_SF_IMPORT_SETTINGS, 'import_form', XOOPS_URL . '/modules/smartfaq/admin/' . $scriptname); |
53 | 53 |