@@ -11,7 +11,7 @@ discard block |
||
| 11 | 11 | $uid = $xoopsUser ? $xoopsUser->getVar('uid') : 0; |
| 12 | 12 | $isAdmin = (sf_userIsAdmin() || sf_moderator()); |
| 13 | 13 | |
| 14 | -$xoopsTpl->assign('sf_adminpage', "<a href='" . XOOPS_URL . "/modules/smartfaq/admin/index.php'>" . _MD_SF_ADMIN_PAGE . '</a>'); |
|
| 14 | +$xoopsTpl->assign('sf_adminpage', "<a href='".XOOPS_URL."/modules/smartfaq/admin/index.php'>"._MD_SF_ADMIN_PAGE.'</a>'); |
|
| 15 | 15 | $xoopsTpl->assign('isAdmin', $isAdmin); |
| 16 | 16 | |
| 17 | 17 | $xoopsTpl->assign(array('lang_on' => _MD_SF_ON, 'lang_postedby' => _MD_SF_POSTEDBY, 'lang_faq' => _MD_SF_QUESTION, 'lang_datesub' => _MD_SF_DATESUB, 'lang_hits' => _MD_SF_HITS)); |
@@ -28,4 +28,4 @@ discard block |
||
| 28 | 28 | |
| 29 | 29 | $xoopsTpl->assign('ref_smartfaq', 'SmartFAQ is developed by The SmartFactory (http://www.smartfactory.ca), a division of InBox Solutions (http://www.inboxsolutions.net)'); |
| 30 | 30 | |
| 31 | -$xoopsTpl->assign('xoops_module_header', "<link rel='stylesheet' type='text/css' href='" . XOOPS_URL . "/modules/smartfaq/assets/css/smartfaq.css'/>"); |
|
| 31 | +$xoopsTpl->assign('xoops_module_header', "<link rel='stylesheet' type='text/css' href='".XOOPS_URL."/modules/smartfaq/assets/css/smartfaq.css'/>"); |
|
@@ -6,8 +6,8 @@ discard block |
||
| 6 | 6 | * Licence: GNU |
| 7 | 7 | */ |
| 8 | 8 | |
| 9 | -include_once __DIR__ . '/header.php'; |
|
| 10 | -include_once(XOOPS_ROOT_PATH . '/header.php'); |
|
| 9 | +include_once __DIR__.'/header.php'; |
|
| 10 | +include_once(XOOPS_ROOT_PATH.'/header.php'); |
|
| 11 | 11 | |
| 12 | 12 | global $xoopsUser, $xoopsConfig, $xoopsModuleConfig, $xoopsModule; |
| 13 | 13 | |
@@ -73,7 +73,7 @@ discard block |
||
| 73 | 73 | |
| 74 | 74 | // Storing the FAQ object in the database |
| 75 | 75 | if (!$newFaqObj->store()) { |
| 76 | - redirect_header('javascript:history.go(-1)', 3, _MD_SF_REQUEST_ERROR . sf_formatErrors($newFaqObj->getErrors())); |
|
| 76 | + redirect_header('javascript:history.go(-1)', 3, _MD_SF_REQUEST_ERROR.sf_formatErrors($newFaqObj->getErrors())); |
|
| 77 | 77 | } |
| 78 | 78 | |
| 79 | 79 | // Get the cateopry object related to that FAQ |
@@ -88,7 +88,7 @@ discard block |
||
| 88 | 88 | } else { |
| 89 | 89 | // Subscribe the user to On Published notification, if requested |
| 90 | 90 | if ($notifypub == 1) { |
| 91 | - include_once XOOPS_ROOT_PATH . '/include/notification_constants.php'; |
|
| 91 | + include_once XOOPS_ROOT_PATH.'/include/notification_constants.php'; |
|
| 92 | 92 | $notificationHandler = xoops_getHandler('notification'); |
| 93 | 93 | $notificationHandler->subscribe('question', $newFaqObj->faqid(), 'approved', XOOPS_NOTIFICATION_MODE_SENDONCETHENDELETE); |
| 94 | 94 | } |
@@ -108,17 +108,17 @@ discard block |
||
| 108 | 108 | global $xoopsUser, $myts; |
| 109 | 109 | |
| 110 | 110 | $xoopsOption['template_main'] = 'smartfaq_submit.tpl'; |
| 111 | - include_once(XOOPS_ROOT_PATH . '/header.php'); |
|
| 112 | - include_once __DIR__ . '/footer.php'; |
|
| 111 | + include_once(XOOPS_ROOT_PATH.'/header.php'); |
|
| 112 | + include_once __DIR__.'/footer.php'; |
|
| 113 | 113 | |
| 114 | 114 | $name = $xoopsUser ? ucwords($xoopsUser->getVar('uname')) : 'Anonymous'; |
| 115 | 115 | |
| 116 | - $moduleName =& $myts->displayTarea($xoopsModule->getVar('name')); |
|
| 116 | + $moduleName = & $myts->displayTarea($xoopsModule->getVar('name')); |
|
| 117 | 117 | $xoopsTpl->assign('whereInSection', $moduleName); |
| 118 | 118 | $xoopsTpl->assign('lang_submit', _MD_SF_REQUEST); |
| 119 | 119 | |
| 120 | 120 | $xoopsTpl->assign('lang_intro_title', _MD_SF_REQUEST); |
| 121 | - $xoopsTpl->assign('lang_intro_text', _MD_SF_GOODDAY . "<b>$name</b>, " . $myts->displayTarea($xoopsModuleConfig['requestintromsg'])); |
|
| 121 | + $xoopsTpl->assign('lang_intro_text', _MD_SF_GOODDAY."<b>$name</b>, ".$myts->displayTarea($xoopsModuleConfig['requestintromsg'])); |
|
| 122 | 122 | |
| 123 | 123 | include_once 'include/request.inc.php'; |
| 124 | 124 | |
@@ -128,7 +128,7 @@ discard block |
||
| 128 | 128 | |
| 129 | 129 | include_once 'include/request.inc.php'; |
| 130 | 130 | |
| 131 | - include_once XOOPS_ROOT_PATH . '/footer.php'; |
|
| 131 | + include_once XOOPS_ROOT_PATH.'/footer.php'; |
|
| 132 | 132 | |
| 133 | 133 | break; |
| 134 | 134 | } |
@@ -272,7 +272,7 @@ |
||
| 272 | 272 | define('_AM_SF_STATUS_EXP', "Status<span style='font-size: xx-small; font-weight: normal; display: block;'>Select the status of the Q&A.</span>"); |
| 273 | 273 | define('_AM_SF_SUBMISSIONSMNGMT', 'Submitted Q&A'); |
| 274 | 274 | define('_AM_SF_SPECIFIC_URL_SELECT', 'Specific URL...'); |
| 275 | -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>" . _AM_SF_SPECIFIC_URL_SELECT . "</i>, please<br />specify the URL.<br />\n<b>Example :</b> modules/newbb</span>"); |
|
| 275 | +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>"._AM_SF_SPECIFIC_URL_SELECT."</i>, please<br />specify the URL.<br />\n<b>Example :</b> modules/newbb</span>"); |
|
| 276 | 276 | define('_AM_SF_SUBMISSION_MODERATE', "Moderate this Q&A's submission"); |
| 277 | 277 | define('_AM_SF_SUBMITTED', 'Submitted'); |
| 278 | 278 | 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.'); |
@@ -74,7 +74,7 @@ discard block |
||
| 74 | 74 | define('_MD_SF_INTARTICLE', 'Have a look at this FAQ at %s'); |
| 75 | 75 | define('_MD_SF_MAIL', 'Send Q&A'); |
| 76 | 76 | define('_MD_SF_MAINHEAD', 'Welcome to the'); |
| 77 | -define('_MD_SF_MAININTRO', "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='" . XOOPS_URL . "/forms/askus/form.php'>Ask us a Question!</a>"); |
|
| 77 | +define('_MD_SF_MAININTRO', "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='".XOOPS_URL."/forms/askus/form.php'>Ask us a Question!</a>"); |
|
| 78 | 78 | define('_MD_SF_MAINNOSELECTCAT', 'You did not select a valid category'); |
| 79 | 79 | define('_MD_SF_MAINNOFAQS', 'There are no Q&As in this category'); |
| 80 | 80 | define('_MD_SF_MODERATION_MAIN_HEAD', 'Moderation section of '); |
@@ -126,7 +126,7 @@ discard block |
||
| 126 | 126 | define('_MD_SF_SPECIFIC_URL_SELECT', 'Specific URL...'); |
| 127 | 127 | define('_MD_SF_SENDSTORY', 'Send this Q&A to a friend'); |
| 128 | 128 | define('_MD_SF_SPECIFIC_URL', 'Specific URL'); |
| 129 | -define('_MD_SF_SPECIFIC_URL_DSC', "If you have set the 'Contextually link to this module' to <i>" . _MD_SF_SPECIFIC_URL_SELECT . "</i>, please specify the URL.<br />\n<b>Example :</b> modules/newbb"); |
|
| 129 | +define('_MD_SF_SPECIFIC_URL_DSC', "If you have set the 'Contextually link to this module' to <i>"._MD_SF_SPECIFIC_URL_SELECT."</i>, please specify the URL.<br />\n<b>Example :</b> modules/newbb"); |
|
| 130 | 130 | define('_MD_SF_SUB_INTRO', 'please fill this form to send your Q&A. The site administrator will review it and then publish it as soon as possible. Thank you in advance for your contribution.'); |
| 131 | 131 | define('_MD_SF_SUB_SNEWNAME', 'Submit a Q&A'); |
| 132 | 132 | define('_MD_SF_SUB_SMNAME', 'Submit a Q&A'); |
@@ -6,9 +6,9 @@ discard block |
||
| 6 | 6 | * Licence: GNU |
| 7 | 7 | */ |
| 8 | 8 | |
| 9 | -include_once __DIR__ . '/header.php'; |
|
| 9 | +include_once __DIR__.'/header.php'; |
|
| 10 | 10 | |
| 11 | -$faqid = isset($_GET['faqid']) ? (int)$_GET['faqid'] : 0; |
|
| 11 | +$faqid = isset($_GET['faqid']) ? (int) $_GET['faqid'] : 0; |
|
| 12 | 12 | |
| 13 | 13 | if ($faqid == 0) { |
| 14 | 14 | redirect_header('javascript:history.go(-1)', 1, _MD_SF_NOFAQSELECTED); |
@@ -43,23 +43,23 @@ discard block |
||
| 43 | 43 | |
| 44 | 44 | echo "<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>\n"; |
| 45 | 45 | echo "<html>\n<head>\n"; |
| 46 | -echo '<title>' . _MD_SF_FAQCOMEFROM . ' ' . $xoopsConfig['sitename'] . "</title>\n"; |
|
| 47 | -echo "<meta http-equiv='Content-Type' content='text/html; charset=" . _CHARSET . "' />\n"; |
|
| 48 | -echo "<meta name='AUTHOR' content='" . $xoopsConfig['sitename'] . "' />\n"; |
|
| 49 | -echo "<meta name='COPYRIGHT' content='Copyright (c) 2001 by " . $xoopsConfig['sitename'] . "' />\n"; |
|
| 50 | -echo "<meta name='DESCRIPTION' content='" . $xoopsConfig['slogan'] . "' />\n"; |
|
| 51 | -echo "<meta name='GENERATOR' content='" . XOOPS_VERSION . "' />\n\n\n"; |
|
| 46 | +echo '<title>'._MD_SF_FAQCOMEFROM.' '.$xoopsConfig['sitename']."</title>\n"; |
|
| 47 | +echo "<meta http-equiv='Content-Type' content='text/html; charset="._CHARSET."' />\n"; |
|
| 48 | +echo "<meta name='AUTHOR' content='".$xoopsConfig['sitename']."' />\n"; |
|
| 49 | +echo "<meta name='COPYRIGHT' content='Copyright (c) 2001 by ".$xoopsConfig['sitename']."' />\n"; |
|
| 50 | +echo "<meta name='DESCRIPTION' content='".$xoopsConfig['slogan']."' />\n"; |
|
| 51 | +echo "<meta name='GENERATOR' content='".XOOPS_VERSION."' />\n\n\n"; |
|
| 52 | 52 | |
| 53 | 53 | echo "<body bgcolor='#ffffff' text='#000000' onload='window.print()'> |
| 54 | 54 | <div style='width: 650px; border: 1px solid #000; padding: 20px;'> |
| 55 | - <div style='text-align: center; display: block; margin: 0 0 6px 0;'><img src='" . XOOPS_URL . "/modules/smartfaq/assets/images/logo_module.png' border='0' alt='' /><h2 style='margin: 0;'>" . $faqObj->question() . "</h2></div> |
|
| 56 | - <div align='center'>" . $who_where . "</div> |
|
| 55 | + <div style='text-align: center; display: block; margin: 0 0 6px 0;'><img src='" . XOOPS_URL."/modules/smartfaq/assets/images/logo_module.png' border='0' alt='' /><h2 style='margin: 0;'>".$faqObj->question()."</h2></div> |
|
| 56 | + <div align='center'>" . $who_where."</div> |
|
| 57 | 57 | <div style='text-align: center; display: block; padding-bottom: 12px; margin: 0 0 6px 0; border-bottom: 2px solid #ccc;'></div> |
| 58 | 58 | <div></div> |
| 59 | - <b><p>" . $faqObj->question() . '</p></b> |
|
| 60 | - <p>' . $answerObj->answer() . "</p> |
|
| 59 | + <b><p>" . $faqObj->question().'</p></b> |
|
| 60 | + <p>' . $answerObj->answer()."</p> |
|
| 61 | 61 | <div style='padding-top: 12px; border-top: 2px solid #ccc;'></div> |
| 62 | - <p>" . $comeFrom . '</p> |
|
| 62 | + <p>" . $comeFrom.'</p> |
|
| 63 | 63 | </div> |
| 64 | 64 | <br />'; |
| 65 | 65 | |
@@ -6,11 +6,11 @@ |
||
| 6 | 6 | * Licence: GNU |
| 7 | 7 | */ |
| 8 | 8 | |
| 9 | -include dirname(dirname(__DIR__)) . '/mainfile.php'; |
|
| 9 | +include dirname(dirname(__DIR__)).'/mainfile.php'; |
|
| 10 | 10 | |
| 11 | -include_once XOOPS_ROOT_PATH . '/modules/smartfaq/include/functions.php'; |
|
| 12 | -include_once XOOPS_ROOT_PATH . '/modules/smartfaq/class/category.php'; |
|
| 13 | -include_once XOOPS_ROOT_PATH . '/modules/smartfaq/class/faq.php'; |
|
| 14 | -include_once XOOPS_ROOT_PATH . '/modules/smartfaq/class/answer.php'; |
|
| 11 | +include_once XOOPS_ROOT_PATH.'/modules/smartfaq/include/functions.php'; |
|
| 12 | +include_once XOOPS_ROOT_PATH.'/modules/smartfaq/class/category.php'; |
|
| 13 | +include_once XOOPS_ROOT_PATH.'/modules/smartfaq/class/faq.php'; |
|
| 14 | +include_once XOOPS_ROOT_PATH.'/modules/smartfaq/class/answer.php'; |
|
| 15 | 15 | |
| 16 | 16 | $myts = MyTextSanitizer::getInstance(); |
@@ -91,9 +91,9 @@ discard block |
||
| 91 | 91 | if (!$attach_key) { |
| 92 | 92 | return false; |
| 93 | 93 | } |
| 94 | - $this->attachment_array[(string)$attach_key]['num_download']++; |
|
| 94 | + $this->attachment_array[(string) $attach_key]['num_download']++; |
|
| 95 | 95 | |
| 96 | - return $this->attachment_array[(string)$attach_key]['num_download']; |
|
| 96 | + return $this->attachment_array[(string) $attach_key]['num_download']; |
|
| 97 | 97 | } |
| 98 | 98 | |
| 99 | 99 | /** |
@@ -106,7 +106,7 @@ discard block |
||
| 106 | 106 | $attachment_save = base64_encode(serialize($this->attachment_array)); |
| 107 | 107 | } |
| 108 | 108 | $this->setVar('attachment', $attachment_save); |
| 109 | - $sql = 'UPDATE ' . $GLOBALS['xoopsDB']->prefix('smartfaq_answers') . ' SET attachment=' . $GLOBALS['xoopsDB']->quoteString($attachment_save) . ' WHERE post_id = ' . $this->getVar('answerid'); |
|
| 109 | + $sql = 'UPDATE '.$GLOBALS['xoopsDB']->prefix('smartfaq_answers').' SET attachment='.$GLOBALS['xoopsDB']->quoteString($attachment_save).' WHERE post_id = '.$this->getVar('answerid'); |
|
| 110 | 110 | if (!$result = $GLOBALS['xoopsDB']->queryF($sql)) { |
| 111 | 111 | //xoops_error($GLOBALS["xoopsDB"]->error()); |
| 112 | 112 | return false; |
@@ -138,8 +138,8 @@ discard block |
||
| 138 | 138 | |
| 139 | 139 | foreach ($attach_old as $key => $attach) { |
| 140 | 140 | if (in_array($key, $attach_array)) { |
| 141 | - @unlink(XOOPS_ROOT_PATH . '/' . $xoopsModuleConfig['dir_attachments'] . '/' . $attach['name_saved']); |
|
| 142 | - @unlink(XOOPS_ROOT_PATH . '/' . $xoopsModuleConfig['dir_attachments'] . '/thumbs/' . $attach['name_saved']); // delete thumbnails |
|
| 141 | + @unlink(XOOPS_ROOT_PATH.'/'.$xoopsModuleConfig['dir_attachments'].'/'.$attach['name_saved']); |
|
| 142 | + @unlink(XOOPS_ROOT_PATH.'/'.$xoopsModuleConfig['dir_attachments'].'/thumbs/'.$attach['name_saved']); // delete thumbnails |
|
| 143 | 143 | continue; |
| 144 | 144 | } |
| 145 | 145 | $this->attachment_array[$key] = $attach; |
@@ -165,12 +165,12 @@ discard block |
||
| 165 | 165 | static $counter = 0; |
| 166 | 166 | $this->attachment_array = $this->getAttachment(); |
| 167 | 167 | if ($name_saved) { |
| 168 | - $key = (string)(time() + ($counter++)); |
|
| 168 | + $key = (string) (time()+($counter++)); |
|
| 169 | 169 | $this->attachment_array[$key] = array( |
| 170 | 170 | 'name_saved' => $name_saved, |
| 171 | 171 | 'name_display' => isset($name_display) ? $name_display : $name_saved, |
| 172 | 172 | 'mimetype' => $mimetype, |
| 173 | - 'num_download' => isset($num_download) ? (int)$num_download : 0 |
|
| 173 | + 'num_download' => isset($num_download) ? (int) $num_download : 0 |
|
| 174 | 174 | ); |
| 175 | 175 | } |
| 176 | 176 | $attachment_save = null; |
@@ -196,30 +196,30 @@ discard block |
||
| 196 | 196 | if (is_array($attachments) && count($attachments) > 0) { |
| 197 | 197 | $iconHandler = sf_getIconHandler(); |
| 198 | 198 | $mime_path = $iconHandler->getPath('mime'); |
| 199 | - include_once XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname', 'n') . '/include/functions.image.php'; |
|
| 199 | + include_once XOOPS_ROOT_PATH.'/modules/'.$xoopsModule->getVar('dirname', 'n').'/include/functions.image.php'; |
|
| 200 | 200 | $image_extensions = array('jpg', 'jpeg', 'gif', 'png', 'bmp'); // need improve !!! |
| 201 | - $post_attachment .= '<br /><strong>' . _MD_ATTACHMENT . '</strong>:'; |
|
| 201 | + $post_attachment .= '<br /><strong>'._MD_ATTACHMENT.'</strong>:'; |
|
| 202 | 202 | $post_attachment .= '<br /><hr size="1" noshade="noshade" /><br />'; |
| 203 | 203 | foreach ($attachments as $key => $att) { |
| 204 | 204 | $file_extension = ltrim(strrchr($att['name_saved'], '.'), '.'); |
| 205 | 205 | $filetype = $file_extension; |
| 206 | - if (file_exists(XOOPS_ROOT_PATH . '/' . $mime_path . '/' . $filetype . '.gif')) { |
|
| 207 | - $icon_filetype = XOOPS_URL . '/' . $mime_path . '/' . $filetype . '.gif'; |
|
| 206 | + if (file_exists(XOOPS_ROOT_PATH.'/'.$mime_path.'/'.$filetype.'.gif')) { |
|
| 207 | + $icon_filetype = XOOPS_URL.'/'.$mime_path.'/'.$filetype.'.gif'; |
|
| 208 | 208 | } else { |
| 209 | - $icon_filetype = XOOPS_URL . '/' . $mime_path . '/unknown.gif'; |
|
| 209 | + $icon_filetype = XOOPS_URL.'/'.$mime_path.'/unknown.gif'; |
|
| 210 | 210 | } |
| 211 | - $file_size = @filesize(XOOPS_ROOT_PATH . '/' . $xoopsModuleConfig['dir_attachments'] . '/' . $att['name_saved']); |
|
| 212 | - $file_size = number_format($file_size / 1024, 2) . ' KB'; |
|
| 211 | + $file_size = @filesize(XOOPS_ROOT_PATH.'/'.$xoopsModuleConfig['dir_attachments'].'/'.$att['name_saved']); |
|
| 212 | + $file_size = number_format($file_size / 1024, 2).' KB'; |
|
| 213 | 213 | if ($xoopsModuleConfig['media_allowed'] && in_array(strtolower($file_extension), $image_extensions)) { |
| 214 | - $post_attachment .= '<br /><img src="' . $icon_filetype . '" alt="' . $filetype . '" /><strong> ' . $att['name_display'] . '</strong> <small>(' . $file_size . ')</small>'; |
|
| 215 | - $post_attachment .= '<br />' . sf_attachmentImage($att['name_saved']); |
|
| 214 | + $post_attachment .= '<br /><img src="'.$icon_filetype.'" alt="'.$filetype.'" /><strong> '.$att['name_display'].'</strong> <small>('.$file_size.')</small>'; |
|
| 215 | + $post_attachment .= '<br />'.sf_attachmentImage($att['name_saved']); |
|
| 216 | 216 | $isDisplayed = true; |
| 217 | 217 | } else { |
| 218 | 218 | global $xoopsUser; |
| 219 | 219 | if (empty($xoopsModuleConfig['show_userattach'])) { |
| 220 | - $post_attachment .= '<a href="' . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname', 'n') . '/dl_attachment.php?attachid=' . $key . '&post_id=' . $this->getVar('post_id') . '"> <img src="' . $icon_filetype . '" alt="' . $filetype . '" /> ' . $att['name_display'] . '</a> ' . _MD_FILESIZE . ': ' . $file_size . '; ' . _MD_HITS . ': ' . $att['num_download']; |
|
| 220 | + $post_attachment .= '<a href="'.XOOPS_URL.'/modules/'.$xoopsModule->getVar('dirname', 'n').'/dl_attachment.php?attachid='.$key.'&post_id='.$this->getVar('post_id').'"> <img src="'.$icon_filetype.'" alt="'.$filetype.'" /> '.$att['name_display'].'</a> '._MD_FILESIZE.': '.$file_size.'; '._MD_HITS.': '.$att['num_download']; |
|
| 221 | 221 | } elseif ($xoopsUser && $xoopsUser->uid() > 0 && $xoopsUser->isactive()) { |
| 222 | - $post_attachment .= '<a href="' . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname', 'n') . '/dl_attachment.php?attachid=' . $key . '&post_id=' . $this->getVar('post_id') . '"> <img src="' . $icon_filetype . '" alt="' . $filetype . '" /> ' . $att['name_display'] . '</a> ' . _MD_FILESIZE . ': ' . $file_size . '; ' . _MD_HITS . ': ' . $att['num_download']; |
|
| 222 | + $post_attachment .= '<a href="'.XOOPS_URL.'/modules/'.$xoopsModule->getVar('dirname', 'n').'/dl_attachment.php?attachid='.$key.'&post_id='.$this->getVar('post_id').'"> <img src="'.$icon_filetype.'" alt="'.$filetype.'" /> '.$att['name_display'].'</a> '._MD_FILESIZE.': '.$file_size.'; '._MD_HITS.': '.$att['num_download']; |
|
| 223 | 223 | } else { |
| 224 | 224 | $post_attachment .= _MD_NEWBB_SEENOTGUEST; |
| 225 | 225 | } |
@@ -328,9 +328,9 @@ discard block |
||
| 328 | 328 | $tags = array(); |
| 329 | 329 | $tags['MODULE_NAME'] = $myts->displayTarea($smartModule->getVar('name')); |
| 330 | 330 | $tags['FAQ_NAME'] = $faqObj->question(); |
| 331 | - $tags['FAQ_URL'] = XOOPS_URL . '/modules/' . $smartModule->getVar('dirname') . '/faq.php?faqid=' . $faqObj->faqid(); |
|
| 331 | + $tags['FAQ_URL'] = XOOPS_URL.'/modules/'.$smartModule->getVar('dirname').'/faq.php?faqid='.$faqObj->faqid(); |
|
| 332 | 332 | $tags['CATEGORY_NAME'] = $faqObj->getCategoryName(); |
| 333 | - $tags['CATEGORY_URL'] = XOOPS_URL . '/modules/' . $smartModule->getVar('dirname') . '/category.php?categoryid=' . $faqObj->categoryid(); |
|
| 333 | + $tags['CATEGORY_URL'] = XOOPS_URL.'/modules/'.$smartModule->getVar('dirname').'/category.php?categoryid='.$faqObj->categoryid(); |
|
| 334 | 334 | $tags['FAQ_QUESTION'] = $faqObj->question(); |
| 335 | 335 | |
| 336 | 336 | // TODO : Not sure about the 'formpreview' ... |
@@ -389,8 +389,8 @@ discard block |
||
| 389 | 389 | */ |
| 390 | 390 | public function get($id = null, $fields = null) |
| 391 | 391 | { |
| 392 | - if ((int)$id > 0) { |
|
| 393 | - $sql = 'SELECT * FROM ' . $this->db->prefix('smartfaq_answers') . ' WHERE answerid=' . $id; |
|
| 392 | + if ((int) $id > 0) { |
|
| 393 | + $sql = 'SELECT * FROM '.$this->db->prefix('smartfaq_answers').' WHERE answerid='.$id; |
|
| 394 | 394 | if (!$result = $this->db->query($sql)) { |
| 395 | 395 | return false; |
| 396 | 396 | } |
@@ -518,11 +518,11 @@ discard block |
||
| 518 | 518 | { |
| 519 | 519 | $ret = array(); |
| 520 | 520 | $limit = $start = 0; |
| 521 | - $sql = 'SELECT * FROM ' . $this->db->prefix('smartfaq_answers'); |
|
| 521 | + $sql = 'SELECT * FROM '.$this->db->prefix('smartfaq_answers'); |
|
| 522 | 522 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 523 | - $sql .= ' ' . $criteria->renderWhere(); |
|
| 523 | + $sql .= ' '.$criteria->renderWhere(); |
|
| 524 | 524 | if ($criteria->getSort() != '') { |
| 525 | - $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 525 | + $sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder(); |
|
| 526 | 526 | } |
| 527 | 527 | $limit = $criteria->getLimit(); |
| 528 | 528 | $start = $criteria->getStart(); |
@@ -536,9 +536,9 @@ discard block |
||
| 536 | 536 | $answer = new sfAnswer(); |
| 537 | 537 | $answer->assignVars($myrow); |
| 538 | 538 | if (!$id_as_key) { |
| 539 | - $ret[] =& $answer; |
|
| 539 | + $ret[] = & $answer; |
|
| 540 | 540 | } else { |
| 541 | - $ret[$myrow['answerid']] =& $answer; |
|
| 541 | + $ret[$myrow['answerid']] = & $answer; |
|
| 542 | 542 | } |
| 543 | 543 | unset($answer); |
| 544 | 544 | } |
@@ -600,7 +600,7 @@ discard block |
||
| 600 | 600 | $criteria->setOrder($order); |
| 601 | 601 | $criteria->setLimit($limit); |
| 602 | 602 | $criteria->setStart($start); |
| 603 | - $ret =& $this->getObjects($criteria); |
|
| 603 | + $ret = & $this->getObjects($criteria); |
|
| 604 | 604 | |
| 605 | 605 | return $ret; |
| 606 | 606 | } |
@@ -613,9 +613,9 @@ discard block |
||
| 613 | 613 | */ |
| 614 | 614 | public function getCount(CriteriaElement $criteria = null) |
| 615 | 615 | { |
| 616 | - $sql = 'SELECT COUNT(*) FROM ' . $this->db->prefix('smartfaq_answers'); |
|
| 616 | + $sql = 'SELECT COUNT(*) FROM '.$this->db->prefix('smartfaq_answers'); |
|
| 617 | 617 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 618 | - $sql .= ' ' . $criteria->renderWhere(); |
|
| 618 | + $sql .= ' '.$criteria->renderWhere(); |
|
| 619 | 619 | } |
| 620 | 620 | $result = $this->db->query($sql); |
| 621 | 621 | if (!$result) { |
@@ -634,10 +634,10 @@ discard block |
||
| 634 | 634 | */ |
| 635 | 635 | public function getCountByFAQ($criteria = null) |
| 636 | 636 | { |
| 637 | - $sql = 'SELECT faqid, COUNT(*) FROM ' . $this->db->prefix('smartfaq_answers'); |
|
| 637 | + $sql = 'SELECT faqid, COUNT(*) FROM '.$this->db->prefix('smartfaq_answers'); |
|
| 638 | 638 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 639 | - $sql .= ' ' . $criteria->renderWhere(); |
|
| 640 | - $sql .= ' ' . $criteria->getGroupby(); |
|
| 639 | + $sql .= ' '.$criteria->renderWhere(); |
|
| 640 | + $sql .= ' '.$criteria->getGroupby(); |
|
| 641 | 641 | } |
| 642 | 642 | |
| 643 | 643 | //echo "<br />$sql<br />"; |
@@ -664,9 +664,9 @@ discard block |
||
| 664 | 664 | */ |
| 665 | 665 | public function deleteAll(CriteriaElement $criteria = null, $force = true, $asObject = false) |
| 666 | 666 | { |
| 667 | - $sql = 'DELETE FROM ' . $this->db->prefix('smartfaq_answers'); |
|
| 667 | + $sql = 'DELETE FROM '.$this->db->prefix('smartfaq_answers'); |
|
| 668 | 668 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 669 | - $sql .= ' ' . $criteria->renderWhere(); |
|
| 669 | + $sql .= ' '.$criteria->renderWhere(); |
|
| 670 | 670 | } |
| 671 | 671 | if (!$this->db->query($sql)) { |
| 672 | 672 | return false; |
@@ -686,10 +686,10 @@ discard block |
||
| 686 | 686 | */ |
| 687 | 687 | public function updateAll($fieldname, $fieldvalue, CriteriaElement $criteria = null, $force = false) |
| 688 | 688 | { |
| 689 | - $set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->db->quoteString($fieldvalue); |
|
| 690 | - $sql = 'UPDATE ' . $this->db->prefix('smartfaq_answers') . ' SET ' . $set_clause; |
|
| 689 | + $set_clause = is_numeric($fieldvalue) ? $fieldname.' = '.$fieldvalue : $fieldname.' = '.$this->db->quoteString($fieldvalue); |
|
| 690 | + $sql = 'UPDATE '.$this->db->prefix('smartfaq_answers').' SET '.$set_clause; |
|
| 691 | 691 | if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 692 | - $sql .= ' ' . $criteria->renderWhere(); |
|
| 692 | + $sql .= ' '.$criteria->renderWhere(); |
|
| 693 | 693 | } |
| 694 | 694 | //echo "<br />" . $sql . "<br />"; |
| 695 | 695 | if (!$this->db->queryF($sql)) { |
@@ -706,8 +706,8 @@ discard block |
||
| 706 | 706 | public function getLastPublishedByFaq($faqids) |
| 707 | 707 | { |
| 708 | 708 | $ret = array(); |
| 709 | - $sql = 'SELECT faqid, answer, uid, datesub FROM ' . $this->db->prefix('smartfaq_answers') . ' |
|
| 710 | - WHERE faqid IN (' . implode(',', $faqids) . ') AND status = ' . _SF_AN_STATUS_APPROVED . ' GROUP BY faqid'; |
|
| 709 | + $sql = 'SELECT faqid, answer, uid, datesub FROM '.$this->db->prefix('smartfaq_answers').' |
|
| 710 | + WHERE faqid IN (' . implode(',', $faqids).') AND status = '._SF_AN_STATUS_APPROVED.' GROUP BY faqid'; |
|
| 711 | 711 | $result = $this->db->query($sql); |
| 712 | 712 | if (!$result) { |
| 713 | 713 | return $ret; |
@@ -715,7 +715,7 @@ discard block |
||
| 715 | 715 | while ($row = $this->db->fetchArray($result)) { |
| 716 | 716 | $answer = new sfAnswer(); |
| 717 | 717 | $answer->assignVars($row); |
| 718 | - $ret[$row['faqid']] =& $answer; |
|
| 718 | + $ret[$row['faqid']] = & $answer; |
|
| 719 | 719 | unset($answer); |
| 720 | 720 | } |
| 721 | 721 | |
@@ -11,7 +11,7 @@ |
||
| 11 | 11 | |
| 12 | 12 | // defined('XOOPS_ROOT_PATH') || exit('XOOPS root path not defined'); |
| 13 | 13 | |
| 14 | -include_once XOOPS_ROOT_PATH . '/class/uploader.php'; |
|
| 14 | +include_once XOOPS_ROOT_PATH.'/class/uploader.php'; |
|
| 15 | 15 | |
| 16 | 16 | /** |
| 17 | 17 | * Class sfUploader |
@@ -16,7 +16,7 @@ discard block |
||
| 16 | 16 | //Verifies that a MySQL table exists |
| 17 | 17 | $xoopsDB = XoopsDatabaseFactory::getDatabaseConnection(); |
| 18 | 18 | $realname = $xoopsDB->prefix($table); |
| 19 | - $sql = 'SHOW TABLES FROM ' . XOOPS_DB_NAME; |
|
| 19 | + $sql = 'SHOW TABLES FROM '.XOOPS_DB_NAME; |
|
| 20 | 20 | $ret = $xoopsDB->queryF($sql); |
| 21 | 21 | while (list($m_table) = $xoopsDB->fetchRow($ret)) { |
| 22 | 22 | if ($m_table == $realname) { |
@@ -53,9 +53,9 @@ discard block |
||
| 53 | 53 | * Include the language constants for the SmartObjectDBUpdater |
| 54 | 54 | */ |
| 55 | 55 | global $xoopsConfig; |
| 56 | -$common_file = XOOPS_ROOT_PATH . '/modules/smartfaq/language/' . $xoopsConfig['language'] . '/smartdbupdater.php'; |
|
| 56 | +$common_file = XOOPS_ROOT_PATH.'/modules/smartfaq/language/'.$xoopsConfig['language'].'/smartdbupdater.php'; |
|
| 57 | 57 | if (!file_exists($common_file)) { |
| 58 | - $common_file = XOOPS_ROOT_PATH . '/modules/smartfaq/language/english/smartdbupdater.php'; |
|
| 58 | + $common_file = XOOPS_ROOT_PATH.'/modules/smartfaq/language/english/smartdbupdater.php'; |
|
| 59 | 59 | } |
| 60 | 60 | |
| 61 | 61 | include($common_file); |
@@ -152,14 +152,14 @@ discard block |
||
| 152 | 152 | public function getExistingFieldsArray() |
| 153 | 153 | { |
| 154 | 154 | global $xoopsDB; |
| 155 | - $result = $xoopsDB->query('SHOW COLUMNS FROM ' . $this->name()); |
|
| 155 | + $result = $xoopsDB->query('SHOW COLUMNS FROM '.$this->name()); |
|
| 156 | 156 | while ($existing_field = $xoopsDB->fetchArray($result)) { |
| 157 | 157 | $fields[$existing_field['Field']] = $existing_field['Type']; |
| 158 | 158 | if ($existing_field['Null'] !== 'YES') { |
| 159 | 159 | $fields[$existing_field['Field']] .= ' NOT NULL'; |
| 160 | 160 | } |
| 161 | 161 | if ($existing_field['Extra']) { |
| 162 | - $fields[$existing_field['Field']] .= ' ' . $existing_field['Extra']; |
|
| 162 | + $fields[$existing_field['Field']] .= ' '.$existing_field['Extra']; |
|
| 163 | 163 | } |
| 164 | 164 | } |
| 165 | 165 | |
@@ -235,9 +235,9 @@ discard block |
||
| 235 | 235 | $query = sprintf('INSERT INTO %s VALUES (%s)', $this->name(), $data); |
| 236 | 236 | $ret = $xoopsDB->query($query); |
| 237 | 237 | if (!$ret) { |
| 238 | - echo ' ' . sprintf(_SDU_MSG_ADD_DATA_ERR, $this->name()) . '<br />'; |
|
| 238 | + echo ' '.sprintf(_SDU_MSG_ADD_DATA_ERR, $this->name()).'<br />'; |
|
| 239 | 239 | } else { |
| 240 | - echo ' ' . sprintf(_SDU_MSG_ADD_DATA, $this->name()) . '<br />'; |
|
| 240 | + echo ' '.sprintf(_SDU_MSG_ADD_DATA, $this->name()).'<br />'; |
|
| 241 | 241 | } |
| 242 | 242 | } |
| 243 | 243 | |
@@ -393,9 +393,9 @@ discard block |
||
| 393 | 393 | |
| 394 | 394 | $ret = $xoopsDB->query($query); |
| 395 | 395 | if (!$ret) { |
| 396 | - echo ' ' . sprintf(_SDU_MSG_CREATE_TABLE_ERR, $this->name()) . '<br />'; |
|
| 396 | + echo ' '.sprintf(_SDU_MSG_CREATE_TABLE_ERR, $this->name()).'<br />'; |
|
| 397 | 397 | } else { |
| 398 | - echo ' ' . sprintf(_SDU_MSG_CREATE_TABLE, $this->name()) . '<br />'; |
|
| 398 | + echo ' '.sprintf(_SDU_MSG_CREATE_TABLE, $this->name()).'<br />'; |
|
| 399 | 399 | } |
| 400 | 400 | |
| 401 | 401 | return $ret; |
@@ -414,11 +414,11 @@ discard block |
||
| 414 | 414 | $query = sprintf('DROP TABLE %s', $this->name()); |
| 415 | 415 | $ret = $xoopsDB->query($query); |
| 416 | 416 | if (!$ret) { |
| 417 | - echo ' ' . sprintf(_SDU_MSG_DROP_TABLE_ERR, $this->name()) . '<br />'; |
|
| 417 | + echo ' '.sprintf(_SDU_MSG_DROP_TABLE_ERR, $this->name()).'<br />'; |
|
| 418 | 418 | |
| 419 | 419 | return false; |
| 420 | 420 | } else { |
| 421 | - echo ' ' . sprintf(_SDU_MSG_DROP_TABLE, $this->name()) . '<br />'; |
|
| 421 | + echo ' '.sprintf(_SDU_MSG_DROP_TABLE, $this->name()).'<br />'; |
|
| 422 | 422 | |
| 423 | 423 | return true; |
| 424 | 424 | } |
@@ -442,9 +442,9 @@ discard block |
||
| 442 | 442 | $ret = $ret && $xoopsDB->query($query); |
| 443 | 443 | if ($alteredField['showerror']) { |
| 444 | 444 | if (!$ret) { |
| 445 | - echo ' ' . sprintf(_SDU_MSG_CHGFIELD_ERR, $alteredField['name'], $this->name()) . '<br />'; |
|
| 445 | + echo ' '.sprintf(_SDU_MSG_CHGFIELD_ERR, $alteredField['name'], $this->name()).'<br />'; |
|
| 446 | 446 | } else { |
| 447 | - echo ' ' . sprintf(_SDU_MSG_CHGFIELD, $alteredField['name'], $this->name()) . '<br />'; |
|
| 447 | + echo ' '.sprintf(_SDU_MSG_CHGFIELD, $alteredField['name'], $this->name()).'<br />'; |
|
| 448 | 448 | } |
| 449 | 449 | } |
| 450 | 450 | } |
@@ -468,9 +468,9 @@ discard block |
||
| 468 | 468 | //echo $query; |
| 469 | 469 | $ret = $ret && $xoopsDB->query($query); |
| 470 | 470 | if (!$ret) { |
| 471 | - echo ' ' . sprintf(_SDU_MSG_NEWFIELD_ERR, $newField['name'], $this->name()) . '<br />'; |
|
| 471 | + echo ' '.sprintf(_SDU_MSG_NEWFIELD_ERR, $newField['name'], $this->name()).'<br />'; |
|
| 472 | 472 | } else { |
| 473 | - echo ' ' . sprintf(_SDU_MSG_NEWFIELD, $newField['name'], $this->name()) . '<br />'; |
|
| 473 | + echo ' '.sprintf(_SDU_MSG_NEWFIELD, $newField['name'], $this->name()).'<br />'; |
|
| 474 | 474 | } |
| 475 | 475 | } |
| 476 | 476 | |
@@ -493,9 +493,9 @@ discard block |
||
| 493 | 493 | $query = sprintf('UPDATE %s SET %s = %s', $this->name(), $updatedField['name'], $updatedField['value']); |
| 494 | 494 | $ret = $ret && $xoopsDB->query($query); |
| 495 | 495 | if (!$ret) { |
| 496 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()) . '<br />'; |
|
| 496 | + echo ' '.sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()).'<br />'; |
|
| 497 | 497 | } else { |
| 498 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()) . '<br />'; |
|
| 498 | + echo ' '.sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()).'<br />'; |
|
| 499 | 499 | } |
| 500 | 500 | } |
| 501 | 501 | |
@@ -518,9 +518,9 @@ discard block |
||
| 518 | 518 | //echo $query."<br>"; |
| 519 | 519 | $ret = $ret && $xoopsDB->query($query); |
| 520 | 520 | if (!$ret) { |
| 521 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()) . '<br />'; |
|
| 521 | + echo ' '.sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()).'<br />'; |
|
| 522 | 522 | } else { |
| 523 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()) . '<br />'; |
|
| 523 | + echo ' '.sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()).'<br />'; |
|
| 524 | 524 | } |
| 525 | 525 | } |
| 526 | 526 | |
@@ -544,9 +544,9 @@ discard block |
||
| 544 | 544 | |
| 545 | 545 | $ret = $ret && $xoopsDB->query($query); |
| 546 | 546 | if (!$ret) { |
| 547 | - echo ' ' . sprintf(_SDU_MSG_DROPFIELD_ERR, $droppedField, $this->name()) . '<br />'; |
|
| 547 | + echo ' '.sprintf(_SDU_MSG_DROPFIELD_ERR, $droppedField, $this->name()).'<br />'; |
|
| 548 | 548 | } else { |
| 549 | - echo ' ' . sprintf(_SDU_MSG_DROPFIELD, $droppedField, $this->name()) . '<br />'; |
|
| 549 | + echo ' '.sprintf(_SDU_MSG_DROPFIELD, $droppedField, $this->name()).'<br />'; |
|
| 550 | 550 | } |
| 551 | 551 | } |
| 552 | 552 | |
@@ -615,11 +615,11 @@ discard block |
||
| 615 | 615 | $query = sprintf('ALTER TABLE %s RENAME %s', $from, $to); |
| 616 | 616 | $ret = $xoopsDB->query($query); |
| 617 | 617 | if (!$ret) { |
| 618 | - echo ' ' . sprintf(_SDU_MSG_RENAME_TABLE_ERR, $from) . '<br />'; |
|
| 618 | + echo ' '.sprintf(_SDU_MSG_RENAME_TABLE_ERR, $from).'<br />'; |
|
| 619 | 619 | |
| 620 | 620 | return false; |
| 621 | 621 | } else { |
| 622 | - echo ' ' . sprintf(_SDU_MSG_RENAME_TABLE, $from, $to) . '<br />'; |
|
| 622 | + echo ' '.sprintf(_SDU_MSG_RENAME_TABLE, $from, $to).'<br />'; |
|
| 623 | 623 | |
| 624 | 624 | return true; |
| 625 | 625 | } |