vb.org Archive - Major Additions - microSUPPORT (FAQ & Ticketing)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Major Additions - microSUPPORT (FAQ & Ticketing) (https://vborg.vbsupport.ru/showthread.php?t=229982)

microSUPPORT (FAQ & Ticketing)

Removed by Author
as I've upgraded to vB4
and thus I can't have vB3 legally installed
--------------

microSUPPORT
ver 1.2.0 (Released 11 May 2009)

Fully working Ticketing & F.A.Q Support Module

by MicroHellas
http://www.microhellas.com

Compatible with versions: 3.6.x - 3.7.x - 3.8.x

1.- Usage

I developed this module for my own use. I used to use in the past Kayako and DeskPRO. Really professional support scripts but with so, so, so many features for my needs, so finally I was wasting more time trying to use them, than to offer real support. That's why I decided to code my own module, having in mind to be easy like usining emails, but of course with much more features. Now, I'm sharing this with you, wishing to become a useful tools in your hands.

2.- Installation

The installation is pretty easy, has been checked many times for installing and uninstalling the product. Just follow these steps below:

Download and unzip the file microSUPPORT.zip
Open the folder vbulletin and select all files and subfolders inside it
Connect to your website and open the directory where is your vBulletin installation (usally forum, forums, portal etc).
Upload the selected files to your site. If you fellow the right way then the file support.php must be on the same level as the index.php file of vBulletin.
Before any new installation is good to backup your database before, even if nobody is doing it (including me). At lease turn your site off
Check at your AdminCP->vBulletin Options->Plugin/Hook System that Plugin system is enabled.
From your AdminCP->Plugin System->Manage Products choose Add/Import Product and import the product: product-microsupport.xml

3.- Configuration

As every vBulletin product, you need to make some initial configuration before it goes live.

MicroSUPPORT Options
Setup FAQ categories, Support Departments, Supported Products. Setting Ticket statuses is optional as you can only edit them. Actually this is only for those operating a non-English site, to translate the statuses. Otherwise you can't add/delete statuses.
Setup usergroup permissions.

4.- Template Modification

The module is using it's own templates, so it doesn't needs any template modification except if you want to add a link to the navbar. In this case you need to modify the NavBar template.

Open it and find:

Code:
<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>
Add below:

Code:
<td class="vbmenu_control"><a href="support.php$session[sessionurl_q]">Support</a></td>

5.- Copyright

You can modify the code as you like to meet your special needs
You can distribute this module AS IS, but NOT FOR PROFIT
My copyright link must remain always visible.
Even if there is an option to automatically turn off my copyright link, you can't do that unless you donate for my work.

Enjoy it
Maria

Are there any screenshots or a demo?

Quote:

Originally Posted by Kolbi (Post 1928909)

Are there any screenshots or a demo?

Just added. I was searching my HD to find them.

Maria

I don't have a good use for this right now, but... very nice. Very, very nice.

Here is a screenshoot from the upgrade to vBulletin 4.

Maria

When i try going to /support.php i get

Fatal error: Call to undefined function getresponsetime() in /home/xxxxxx/public_html/forums/support.php on line 155

OK now, for some reason many of the files i uploaded were the wrong file size, i just uploded again and it over wrote the wrong size files.

I don't have any departments showing in the drop down menu when going to submit a ticket.

And also it has uncached templates.

Uncached templates: editor_clientscript (1)
Uncached templates: editor_css (1)
Uncached templates: editor_posttemplates (1)
Uncached templates: editor_posttemplates_js (1)

Lets try it, tankss looks nice

[QUOTE=Andyrew;1930851]I don't have any departments showing in the drop down menu when going to submit a ticket.

Departments won't show for me unless I have products enabled.

There is some way to deactivate the mail send?
want to use this product for another purpose

Thanks a lot

How would I set the Theme/Skin to one specifically for the Support area, without the option of the user changing it.
This would allow me to match my Store's theme with the Support theme so they feel/look more related.

Unfortunatelly this is very buggy and does not work as downloaded.

There are several problems in support.php where

Code:

if($vbulletin->options["microsupport_products"])

should read

Code:

if($vbulletin->options["microsupport_departments"])

sometimes and many calls for department and product IDs do not even have this conditional.

Also there is a serious bug in the getRecordById function in microsupport/includes/functions.php causing empty return values from this function.

There may be other bugs also, since I have stopped trying to debug the scripts after that.

Do not download it unless a new version has been posted by the programmer and QA has been done seriously.

Edit:
Debugged the getRecordById function:

Replace

Code:

function getRecordById($tablename, $id, $rowname = 'id')

{

  global $db, $vbulletin;

  $result = $db->query_read("SELECT * FROM ".TABLE_PREFIX."".$tablename." WHERE ".$rowname."=".$id." LIMIT 1");

  if(!$result) return array ("id" => 0, "name" => '');

  if(mysql_num_rows($result) == 0) return array ("id" => 0, "name" => '');

  $ret = array();

  while($row = mysql_fetch_assoc($result)) {

    $ret = $row;

  }

  mysql_free_result($result);

  return $ret;

}

with

Code:

function getRecordById($tablename, $id, $rowname = 'id')

{

  global $db, $vbulletin;

  $result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . $tablename . " WHERE " . $rowname . " = " . $id . " LIMIT 1");

  if($db->num_rows($result) == 0) return array ("id" => 0, "name" => '');

  $ret = array();

  while($row = $db->fetch_array($result)) {

    $ret = $row;

  }

  $db->free_result($result);

  return $ret;

}

But as said, there are likely more bugs in this mod.

I beg your bardon???:mad: Who are you who dare to prompt members to stop downloading the mod, before even be totally sure that what you wrore are correct?

You wrote:

Quote:

Originally Posted by hws (Post 1951470)

Code:

if($vbulletin->options["microsupport_products"])

should read

Code:

if($vbulletin->options["microsupport_departments"])

While the correct is:

Code:

    if($vbulletin->options["microsupport_products"])

    {

       $products = getProducts($ticket["productid"]);

    }

    if($vbulletin->options["microsupport_departments"])

    {

       $departments = getDepartments($ticket["departmentid"]);

    }

You wrote:

Quote:

Originally Posted by hws (Post 1951470)

and many calls for department and product IDs do not even have this conditional.

without to check if the "missing code" exists as condition in the templates.

3.- You wrote that my function causes "empty return values from this function", while you don't know what this function does. Its impossible to return empty value as the record has checked in the php file that exists, and this function only returns the name or the title of that record.

4.- You wrote "since I have stopped trying to debug the scripts after that.", without telling us who asked you to debug it? If you didn't found it as you expecting to be, just let it out from your super site.

5.- As I seen you're Member. Where is your work here? What did you offer to community, other than ....debugin advices? Could you please click on the "coder" beside my name and count how many mods I've released for vB4, in just 20 days that it's in stable mode? Where are the debugers like you and their work??

6.- As I seen this was your first post. My congratulation for the time that spent to register a new account targeting to blackmail my mods.

Please note that you don't have the right to write "Do not download it unless a new version has been posted by the programmer and QA has been done seriously.", unless its a security issue, which must be report to moderators and not post in public.

Maria

Take a chill pill people.

Mods have bugs (even mine !) thats life.

Report them and move on - thats all you need to do. :)

Quote:

Originally Posted by Paul M (Post 1952377)

Take a chill pill people.

Mods have bugs (even mine !) thats life.

Report them and move on - thats all you need to do. :)

I do, agree. I always welcome any bug report and I'm trying my best to fix it. But this is a different issue. Do you believe that someone who registered here at Nov 2003, after 6+ years, made his first post in such a way? I'm not so idiot to believe something like this. He just registered a new email on his account, and came to discredit me as coder.

That's for the history.
Maria

Due to lack of free time, I must decrease the time that I'm spending here for support. By having a long thread for each of my 16 mods, most often I'm bypassing questions. That's why for urgent questions please visit my site, where it's easier to support you, by having a thread per question.

Thank you
Maria

crap, doesnt work. Remove this!~

Quote:

Originally Posted by greenleaf (Post 1958949)

Fix this!

Unable even to decide on what you want. In any case, I'll remove this and all my 3.8.x mods, as I've upgraded to vB4 and can't have a legal installation of vB3.x

Maria

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (19)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01191 seconds Memory Usage 1,800KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (19)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: