Major Additions - 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

[Harley D]

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.

[hws]

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

There are several problems in support.php where

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

should read

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

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

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.

[MaryTheG(r)eek]

I beg your bardon??? 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:

Originally Posted by hws

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

should read

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

While the correct is:

    if($vbulletin->options["microsupport_products"])
    {
       $products = getProducts($ticket["productid"]);
    }
    if($vbulletin->options["microsupport_departments"])
    {
       $departments = getDepartments($ticket["departmentid"]);
    }

You wrote:

Originally Posted by hws

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

[Paul M]

Take a chill pill people.

Mods have bugs (even mine !) thats life.

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

[MaryTheG(r)eek]

Originally Posted by Paul M

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

[MaryTheG(r)eek]

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

[greenleaf]

crap, doesnt work. Remove this!~

[greenleaf]

Fix this!

[MaryTheG(r)eek]

Originally Posted by greenleaf

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