MyBB - Mods - Reviews

Poking through the code, I find myself scratching my head and asking "Why?" Some of the things which are hardcoded in just don't make sense, mainly the restrictions on what a manager (by default, MyBB's Administrator group) can do. Managers CANNOT submit a ticket. This makes absolutely no sense whatsoever. You should be able to submit bugs on your own project.

To remove this restriction, open helpcenter.php (the one uploaded to the root of the forum, not inc/plugins) and comment out these lines:

111
112
740
741
791
792

Basically what you're looking for is:

Code:

if ($manager)

        error_no_permission();

and commenting out those two lines:

Code:

//if ($manager)

    //    error_no_permission();

Also, while you're at it, I believe line #31 should read:

Code:

define('THIS_SCRIPT',
'helpcenter.php');

Now in the AdminCP, go to Templates & Styles--> Templates--> Global Templates--> helpcenter_manager_nav. After this line:

Code:

<tbody
style="{$collapsed['helpcentermanagement_e']}"
id="helpcentermanagement_e">

Add these lines:

Code:

    <tr><td class="trow1
smalltext"><a
href="{$mybb->settings['bburl']}/helpcenter.php?action=submitticket">{$lang->helpcenter_submit_ticket}</a></td></tr>

    <tr><td class="trow1 smalltext"><a
href="{$mybb->settings['bburl']}/helpcenter.php?action=myopened">{$lang->helpcenter_yourtickets_opened}</a></td></tr>

    <tr><td class="trow1 smalltext"><a
href="{$mybb->settings['bburl']}/helpcenter.php?action=myclosed">{$lang->helpcenter_yourtickets_closed}</a></td></tr>

Click on "Save and Return to Listing".

Now open inc/languages/english/helpcenter.lang.php and change:

Code:

$l['helpcenter_yourtickets_opened'] = 'Opened
tickets';

$l['helpcenter_yourtickets_closed'] = 'Closed
tickets';

to:

Code:

$l['helpcenter_yourtickets_opened'] = 'Your Opened
tickets';

$l['helpcenter_yourtickets_closed'] = 'Your Closed
tickets';

This results in a somewhat inconsistent experience, but it's better than nothing.

All in all though, looking through the code I sometimes really wonder what the author is thinking.

Written By: KDulcimer, 24th August 2010

I installed the plugin, works fine. But then there is no "SUBMIT TICKET" anywhere I can find. And without that why have a ticketsystem when one can't submit any tickets ?
Shame, had hopes for it.

Wolf

Written By: Wolfseye, 15th August 2010

one of the most complex hard code plugins, and FREE release ! :)

Written By: FBI, 15th August 2010

it's a nice plugin for help forums . i just searching for this for about a year.

Written By: SVRN, 29th August 2010

Updated to 1.6 with MySQL 5.1.x http://fbe.am/69e

The plugin is very well writen but the categories are just eye candy, you can't do anything with them.

Written By: TGM, 7th May 2012

Couldn't add this,

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 11
Query:
CREATE TABLE `mybb_helpcenter_tickets` ( `tid` bigint(30) UNSIGNED NOT NULL auto_increment, `uid` bigint(30) UNSIGNED NOT NULL default '0', `date` bigint(30) UNSIGNED NOT NULL default '0', `name` varchar(300) NOT NULL default '', `messages` int(10) UNSIGNED NOT NULL default '0', `opened` smallint(1) UNSIGNED NOT NULL default '1', `priority` smallint(1) UNSIGNED NOT NULL default '0', `cid` bigint(30) UNSIGNED NOT NULL default '0', PRIMARY KEY (`tid`) ) TYPE=MyISAM

Written By: General Pony, 21st October 2012

i do not know why but i can not reply even if i am admin:
http://i.imgur.com/CKP42.jpg

Written By: hellomen, 23rd October 2012

I have the same problem as hellomen.

How to fix?

Written By: AndyJay, 7th April 2013

Couldn't add this,

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 11
Query:
CREATE TABLE `mybb_helpcenter_tickets` ( `tid` bigint(30) UNSIGNED NOT NULL auto_increment, `uid` bigint(30) UNSIGNED NOT NULL default '0', `date` bigint(30) UNSIGNED NOT NULL default '0', `name` varchar(300) NOT NULL default '', `messages` int(10) UNSIGNED NOT NULL default '0', `opened` smallint(1) UNSIGNED NOT NULL default '1', `priority` smallint(1) UNSIGNED NOT NULL default '0', `cid` bigint(30) UNSIGNED NOT NULL default '0', PRIMARY KEY (`tid`) ) TYPE=MyISAM

Anyome know how to fix that

Written By: ErdnussKeksLP, 29th May 2013

open the plugin file in a text editor (eg. notepad++) and change TYPE=MyISAM to Engine=MyISAM , save the file and use it.

If you have the Error which i Posted above
Credits for the fix goes to .m.

Written By: ErdnussKeksLP, 29th May 2013

I can't get this configured. I've sent the creator a PM on these boards. Please help, this would be awesome.

Written By: WCKicksAss, 11th June 2013

When users open a personal message
Gives the following error
=======================
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query:
SELECT * FROM mybb_users WHERE uid=
======================

What can I do to fix this error?

Written By: MR.SASHA, 13th July 2013

MyBB Mods

Site in read-only mode

Welcome!

Reviews

Help Center - 1.1 by Diogo Parrinha