vb.org Archive - vBSupport v2.0.0 Beta 2

Page 3 of 16

Last »

Show 40 post(s) from this thread on one page

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

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - vBSupport v2.0.0 Beta 2 (https://vborg.vbsupport.ru/showthread.php?t=94023)

kylek

09-22-2005 06:24 PM

Quick question,

I am the only admin on my board and want to set the settings so that I am the only one who will deal with support issues. When editing a category, do I need to check the box "administrators" under the allowed technicians usergroup list or just leave none checked?

Also wondering when notifications to admins will be added.

Thanks for this support system by the way!!

mikexxx

09-24-2005 10:48 AM

I get this when i reply to a ticket:

Fatal error: Cannot redeclare vB_DataManager_TicketReply::$ticketreply in /home/.sites/xxx/xxxxxxxxx/web/includes/class_dm_ticketreply.php on line 132

LoOnEyToOnZ

09-25-2005 08:21 AM

Hi im using RC3 and i get this when i try to post an attachment

"Invalid Post specified. If you followed a valid link, please notify the administrator"

CMX_CMGSCCC

09-25-2005 05:20 PM

uae: I see the problem there and will post a v0.8a soon.

kylek: By default Admin has access to all features even if the settings are not set I believe.

If you want to get rid of this feature, look inside vBSupport.php inside the function get_admingroup_ids().

Remove the following code:

Code:

        // make sure admins are in the group

        if (!in_array(6, $admingroupids))

        {

                $adminsfound++;

                $admingroupids[] = 6;

        }

Then it will only use the settings set in the Usergroup settings.

mikexxx: Did you reupload the entire /UPLOAD folder to your server?

LoOnEyToOnZ: Did you choose allow overwrite when installing the plugin? It sounds like one of the queries didnt get ran properly.

Try to run this query:

Code:

ALTER TABLE " . TABLE_PREFIX . "attachment ADD COLUMN ticketreplyid INT UNSIGNED NOT NULL DEFAULT '0';

-CMX

BradE

09-25-2005 05:52 PM

Love this hack, so many uses for this system.

The only problem is have is what others have noted, if no post icon is selected it gives a red x. It isn't an overwrite problem because this was a fresh install on my part. The red x points to http://www.yourforum.com/forum

TruthElixirX

09-25-2005 06:56 PM

I like it. Thanks. :D. Using it to report bugs for our 3.5 upgrade.

mtha	09-25-2005 08:11 PM

Very nice

I want to see some more administrative functions:

- Category's moderator(s). Moderator will receive PM and/or email when there's new ticket in the category (maybe option to turn it on/off too)

Display ticket lists (all kind of list): (ref - vb bug tracker)

Display Assigntech person in ticket list (if none, says unassigned)
Display ticketID could help, when member have question about some specific ticket

Admin Support
- List Open Tickets
- List Closed Tickets

- Search ticket by ticketid, assign person

optional: browse tickets by category, just like in the forum/post relationship

- User can change type of subscription on his ticket
- Admin can edit preposted ticket (with permission allow editting on)

LoOnEyToOnZ

09-26-2005 08:01 AM

Hi CMX

I tried running that query and got this 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 '" . TABLE_PREFIX . "attachment ADD COLUMN ticketreplyid INT UNS "

peterska2

09-26-2005 08:16 AM

LoOnEy, replace the " . TABLE_PREFIX . " with your table prefix, if you have one.

eg
[sql]ALTER TABLE vb35_attachment ADD COLUMN ticketreplyid INT UNSIGNED NOT NULL DEFAULT '0';[/sql]
or
[sql]ALTER TABLE attachment ADD COLUMN ticketreplyid INT UNSIGNED NOT NULL DEFAULT '0';[/sql]

LoOnEyToOnZ

09-26-2005 09:06 AM

Ok i tried and i get this

"#1060 - Duplicate column name 'ticketreplyid' "

Seems like i that column is already there...and btw i go to this URL when i click to add attachments "http://<domain>/forums/newattachment.php?t=1&specialattachment=1&poststar ttime=1127743923&posthash=20e4 18899d84f43e9169841589b95117"

Disi	09-26-2005 10:39 AM

Hiho,,
great Plugin i use it in my vB and it works great :D

CMX_CMGSCCC do you mind if i Translate it into german?

regards

Disi

Cyricx

09-26-2005 11:39 AM

Great hack :)

One suggestion for ya :)

Have it send a PM to a specific user depending on what category it is that a new ticket has been submitted.

Or even just make the email be based on what category it is, rather the one global address that it sends an email to :)

[high]* Cyricx clicks install![/high]

hydrostatic

09-29-2005 01:13 AM

When clicking Quick Reply in FF, it leads to full reply instead of Quick Reply.

Disi	09-30-2005 10:40 AM

Quote:

Originally Posted by Disi

Hiho,
great Plugin i use it in my vB and it works great :D

CMX_CMGSCCC do you mind if i Translate it into german?

regards

Disi

Ok here's the Translation for the German ones

->kick<-

Disi	09-30-2005 11:39 AM

Maybee you can include in the later version, every language thing into a seperate file so its easier to translate :)

Disi	09-30-2005 11:50 AM

ufff, got an error after qick replaying:

Code:

Fatal error: Cannot redeclare vB_DataManager_TicketReply::$ticketreply in includes/class_dm_ticketreply.php on line 132

Mone'

09-30-2005 12:22 PM

Quote:

Originally Posted by Disi

ufff, got an error after qick replaying:

Code:

Fatal error: Cannot redeclare vB_DataManager_TicketReply::$ticketreply in includes/class_dm_ticketreply.php on line 132

same here just after posting a ticket

kall	10-01-2005 01:34 AM

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT ticket.*
,icon.title AS icontitle, icon.iconpath
FROM ticket AS ticket
LEFT JOIN icon AS icon ON(icon.iconid = ticket.iconid)
WHERE postuserid = 1 AND open = 1
ORDER BY replydateline DESC
LIMIT 0, 20;

MySQL Error : Unknown column 'ticket.iconid' in 'on clause'

Any ideas how to fix this?

CMX_CMGSCCC

10-01-2005 11:23 AM

I see the bug for the ticketreply redeclaration. I will fix it now and release shortly.

As far as the ticket.iconid, I have no idea as iconid has always been a part of the ticket MySQL table. Maybe try uinstalling and reinstalling.

-CMX

Disi	10-01-2005 06:30 PM

Well i got a little idea :)

How about moving the Text-things (like email) from the .php into a phrase?

Is it possible?

regards

Disi

jluerken

10-02-2005 09:27 AM

Is this hack working with table prefixes?

Disi	10-02-2005 03:29 PM

Quote:

Originally Posted by jluerken

Is this hack working with table prefixes?

Short answere, Yes :)

mtha	10-02-2005 04:29 PM

I want to change the postbit template, how can I do that? it doesnt use vB's postbit/postbit_legacy

jluerken

10-04-2005 04:01 PM

Quote:

Originally Posted by jluerken

Is this hack working with table prefixes?

It would be wonderful to get an answer on this :D

Also I would like to see a running demo without the need to register somewhere :D

csidlernet

10-05-2005 02:36 AM

Thanks!!!
/me hits install

eMike

10-05-2005 04:31 AM

Amazing hack!

But I get the exact same problem as this guy did.
Everything else works great and I did the "Overwrite" even if i did not upgrade from any previous versions.

Can I manually edit something to fix this?

mariannet

10-05-2005 08:01 AM

Hi

I'm missing an image in the ticket list:

DGoulden

10-05-2005 01:40 PM

great system thanks!

mikexxx

10-05-2005 02:24 PM

Quote:

Originally Posted by mariannet

Hi

I'm missing an image in the ticket list:

I have the same problem. https://vborg.vbsupport.ru/showpost....6&postcount=70

CMX_CMGSCCC

10-05-2005 04:47 PM

I have looked at the posts here and implemented some of the ideas for v0.9.

I have also looked at the bug reports, but the only one I cant seem to figure out is the one that kall is reporting because ticket.iconid should be a valid column. (It does have the TABLE_PREFIX for the query as well.)

The bug after posting should have been fixed since v0.8b.

jluerken: Yes, it does support TABLE_PREFIX's.

mtha: If you want to change the postbit, edit the postbit_ticket to your liking.

Disi: It should be possible, using a form and an ereg_replace to add the links to the sites. I'll look into that for a future version.

But for now, I will release v0.9 with the new features as follows:

1) Added ID to ticket list for easier reference.
2) Added categoryadmins for add/updating categories.
NOTE: Enter the userid's of the users you want to be
notified upon a new ticket creation for the specified
category. Separate entries with a comma (',') and do
not put any spaces either.
3) Added admin options for List Open/Closed Tickets.
4) Added ability to search for tickets by assigned tech.

-CMX

jluerken

10-05-2005 04:54 PM

CMX, many thanks for the answer.

One more question.

Is there a list of the used phrases available?
I want to have the user section in english and german.
The admin part can stay in english.

Now I need to know if there is any hard coded phrases in v0.9 in the user front end and which phrases do I all have to translate?

eMike

10-05-2005 05:37 PM

Upgraded to 0.9 and still missing the posticon image in the ticket list.

Is there any file / template I can edit to remove it completely or add a permanent default posticon?

mtha	10-05-2005 09:00 PM

Code:

Database error in vBulletin 3.5.0:



Invalid SQL:

INSERT INTO pm (pmid, pmtextid, userid, folderid, messageread) VALUES (0, 67818, , 0, 0);



MySQL Error  : 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 ' 0, 0)' at line 1

Error Number : 1064

For category doesnt have $categoryadmin => ERROR

mtha	10-05-2005 09:54 PM

For category doesnt have $categoryadmin => ERROR[/QUOTE]

fix:

in VBSupport.php

Look for

PHP Code:


		
			
                    // get the category info
                    if ($category = $db->query_first("
                        SELECT *
                        FROM " . TABLE_PREFIX . "ticketcategory
                        WHERE categoryid = " . $vbulletin->GPC['categoryid'] . "
                    "))

REPLACE WITH

PHP Code:


		
			
                    // get the category info
                    $category = $db->query_first("
                        SELECT categoryadmins
                        FROM " . TABLE_PREFIX . "ticketcategory
                        WHERE categoryid = " . $vbulletin->GPC['categoryid'] . "
                    ");
                    if (!empty($category['categoryadmins']))
                    {

mtha	10-05-2005 10:06 PM

Quote:

Originally Posted by eMike

Upgraded to 0.9 and still missing the posticon image in the ticket list.

Is there any file / template I can edit to remove it completely or add a permanent default posticon?

support_ticketlistbit

look for

HTML Code:

        <if condition="$show['messageicon']">

                <td class="alt1"><img src="$ticket[iconpath]" alt="$ticket[icontitle]" border="0" /></td>

        </if>

replace with

HTML Code:

        <if condition="$show['messageicon']">

                <td class="alt1">

                        <if condition="$ticket[iconpath]"><img src="$ticket[iconpath]" alt="$ticket[icontitle]" border="0" /></if>

                </td>

        </if>

mtha	10-05-2005 10:50 PM

Quote:

mtha: If you want to change the postbit, edit the postbit_ticket to your liking.

Wow, too far from the rest :) You should have named it support_postbit or support_postbit_ticket or something like that

Quote:

Originally Posted by mtha

- Category's moderator(s).

Display ticket lists
Display Assigntech person in ticket list (if none, says unassigned)

Admin Support

- Search ticket by ticketid

optional: browse tickets by category, just like in the forum/post relationship

- User can change type of subscription on his ticket
- Admin can edit ticket (with permission allow editting on)

add to the list:

- Display CatID before editing category name

Code:

        <td>[$category[categoryid]] <input type="hidden" name="category[$category[categoryid]]" value="$category[categoryid]"><input type="text" name="categoryname[$category[categoryid]]" value="$category[categoryname]" size=50></td>

- newticket in predefined category
could be "vBSupport.php?do=newticket&catid=xxx" it will select the catid by default, or only display that specific catid

- Search ticket by ticketid, postuserid, open status (open or closed)

mtha	10-05-2005 11:36 PM

Question:

When you create or edit a category, there're options for

Allowed Usergroups
Allowed Technician Usergroups

What is the function of these usergroups?

Xplorer4x4

10-06-2005 12:25 AM

Whene ever I open the drop down menu for ticket catagoreys, the catgoreys do not show up. Only the user IDs asigned to those catgories do.

Xplorer4x4

10-06-2005 12:28 AM

Quote:

Originally Posted by mtha

Question:

When you create or edit a category, there're options for

Allowed Usergroups
Allowed Technician Usergroups

What is the function of these usergroups?

Allowed Usergroups are the groups allowed to post tickets.

Allowed Technician Usergroups are the groups that can assign tickets and so forth I believe.

CMX_CMGSCCC

10-06-2005 12:38 AM

Quote:

Originally Posted by mtha

Question:

When you create or edit a category, there're options for

Allowed Usergroups
Allowed Technician Usergroups

What is the function of these usergroups?

Allowed Usergroups mean that those usergroups can create a new ticket in that category. (This is so your admins can create tickets in a specified category that normal users cant create. Like how do we handle X user inside a category named 'Problem Users', etc..)

Allowed Technician Usergroup is the usergroups that are allowed to be assigned to the ticket in that category.

-CMX

All times are GMT. The time now is 05:23 AM.

Page 3 of 16

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02043 seconds Memory Usage 1,849KB 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 (6)bbcode_code_printable (2)bbcode_html_printable (2)bbcode_php_printable (11)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: