vb.org Archive

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)

Andreas 08-15-2005 09:36 PM

I don't see a reason why the Phrase shouldn't be there.
Installcodes are being run if the Version Number of the Installcode is higher then the Installed Version.
So if there is no new Code necessary for a new Version, leave the Version Number of the Install Code as it is.
If there is new Code necessary, create a new Installcode-Block with the New Version Number - or make the install-Code the the installed Version.
As you are truning off mySQL Errors, those (if they happen) will not stop Execution.

Btw: You got some fubar Hook calls in your Classes ;)

CMX_CMGSCCC 08-15-2005 10:45 PM

Quote:

Originally Posted by KirbyDE
I don't see a reason why the Phrase shouldn't be there.
Installcodes are being run if the Version Number of the Installcode is higher then the Installed Version.
So if there is no new Code necessary for a new Version, leave the Version Number of the Install Code as it is.
If there is new Code necessary, create a new Installcode-Block with the New Version Number - or make the install-Code the the installed Version.
As you are truning off mySQL Errors, those (if they happen) will not stop Execution.

Btw: You got some fubar Hook calls in your Classes ;)

I commented all of the hook calls out for now. As I wasnt sure if I should create new hook calls and if I did create new hook calls, how do I add them to the hooks system?

-CMX

RoryF 08-16-2005 07:42 AM

I unistalled in my localhost, went to update usergroup permissions and i got this error.

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    
`title` = 'Fusion City Staff',
    `
description` = '',
    `
usertitle` = 'Fusion City Staff',
    `
opentag` = '<b><font color=#336600>',
    `
closetag` = '</b></font>',
    `
passwordexpires` = '0',
    `
passwordhistory` = '0',
    `
ispublicgroup` = '0',
    `
canoverride` = '0',
    `
forumpermissions` = '1048575',
    `
attachlimit` = '0',
    `
pmquota` = '5000',
    `
pmpermissions` = '3',
    `
pmsendmax` = '0',
    `
calendarpermissions` = '63',
    `
wolpermissions` = '31',
    `
adminpermissions` = '1',
    `
genericpermissions` = '4194303',
    `
genericoptions` = '31',
    `
profilepicmaxwidth` = '120',
    `
profilepicmaxheight` = '120',
    `
profilepicmaxsize` = '20000000',
    `
avatarmaxwidth` = '150',
    `
avatarmaxheight` = '150',
    `
avatarmaxsize` = '20000000',
    `
profileviewpermissions` = '15',
    `
supportpermissions` = '0'
WHERE usergroupid=13;

MySQL Error  Unknown column 'supportpermissions' in 'field list'
Error Number 1054
Date         
TuesdayAugust 16th 2005 04:37:40 AM
Script       
http://fusion-city.net/forum/admincp/usergroup.php
Referrer     http://fusion-city.net/forum/admincp/usergroup.php?do=edit&usergroupid=13
IP Address   217.44.9.153
Username     
Rory
Classname    
vB_Database 

Some stuff from the support system is still there, and i had to drop the tables in the database manually.

jesus likes pie 08-16-2005 12:26 PM

Is there a way that a popup pops up when you get a new ticket? Like with PMs...

if not, it would be an awesome addition.

jesus likes pie 08-19-2005 09:27 PM

bump

lamilein 08-24-2005 05:56 PM

heya, i hope your move went along good :)

nice plugin i have to say, trying it atm and found something that bothers me:
Code:

http://localhost/vb35rc2/vBSupport.php?do=newticket
Fatal error: Cannot redeclare vB_DataManager_Ticket::$ticket in C:\Programme\xampp\htdocs\vb35rc2\includes\class_dm_ticket.php on line 110

got it running on w2k advanced sp4 using xampp (www.apachefriends.org) 1.4.15 std install
(contains:
+ Apache 2.0.54
+ MySQL 4.1.13
+ PHP 5.0.4 + PHP 4.4.0 + PEAR
+ eAccelerator 0.9.3 (PHP5) / 0.9.4-dev(PHP4)
+ Zend Optimizer 2.5.10a )
and using IE5.00
maybe you've got an idea :)

CMX_CMGSCCC 08-24-2005 06:21 PM

Quote:

Originally Posted by lamilein
heya, i hope your move went along good :)

nice plugin i have to say, trying it atm and found something that bothers me:
Code:

http://localhost/vb35rc2/vBSupport.php?do=newticket
Fatal error: Cannot redeclare vB_DataManager_Ticket::$ticket in C:\Programme\xampp\htdocs\vb35rc2\includes\class_dm_ticket.php on line 110

got it running on w2k advanced sp4 using xampp (www.apachefriends.org) 1.4.15 std install
(contains:
+ Apache 2.0.54
+ MySQL 4.1.13
+ PHP 5.0.4 + PHP 4.4.0 + PEAR
+ eAccelerator 0.9.3 (PHP5) / 0.9.4-dev(PHP4)
+ Zend Optimizer 2.5.10a )
and using IE5.00
maybe you've got an idea :)

I have fixed this bug, it was declaring $ticket twice inside class_dm_ticket.php.

I'm working on version v0.5 at the moment. I was trying to find a way to do the a popup like the pmpopup. I'll have to research some more of the plugin hooks to get that working, but it seems possible.

The stuff I have done for v0.5 right now are as follows:

1) Added new admin feature to 'List New Tickets'.
2) Updated the installer to verify the fields exist before
trying to create them.
3) Fixed the replycount increment code when people reply to
a ticket.
4) Added vBSupport.php?do=rebuildreplycount to rebuild the
ticket reply counts.
5) Fixed a redeclaration bug inside class_dm_ticket.php.

I want to add a couple more features for v0.5 before releasing it.

1) The admin feature to search for tickets. (i.e. search for tickets containing words, or search for tickets in a specified category, or search the titles only, and some more options for the search.)

2) I want to add pages to the ticketlisting. Right now it displays all of the tickets on the same page, I want to fix that and add the page system like vB has for the threads and such. (As well as add an admin option to specify how many tickets you want to list per page for users and for admins.)

The search feature I have started and got a basis 'search' function added, just need to get a good template for the searching options and it should be finished.

The pages I havent started yet, but it should be easy. I hope to have the new version out by this Friday. But I've been really busy as of late, we have just moved into our new home my in-laws are visiting from Germany until September 3rd, so I may not hit the Friday date, but I'm trying :)

-CMX

The Geek 08-24-2005 06:37 PM

keep up the great work. Its coming along quite nicely. The only thing I would like to see is some initial entry boxes for things like url, ftp, admin account access, that are availible for certain categories of tickets.

The only sketchy thing is handling that kind of sensitive data (ie. md5 it and delete it when ticket closes). I would still be happy as larry without it - its just a suggestion ;)

CMX_CMGSCCC 08-24-2005 09:39 PM

Quote:

Originally Posted by The Geek
keep up the great work. Its coming along quite nicely. The only thing I would like to see is some initial entry boxes for things like url, ftp, admin account access, that are availible for certain categories of tickets.

The only sketchy thing is handling that kind of sensitive data (ie. md5 it and delete it when ticket closes). I would still be happy as larry without it - its just a suggestion ;)

It could probably be done, but creating a new ticketfields table. It would obviously add more queries as well. I might look into it when I get some free time.

-CMX

Neal-UK 08-24-2005 10:13 PM

Quote:

Originally Posted by CMX_CMGSCCC
It could probably be done, but creating a new ticketfields table. It would obviously add more queries as well. I might look into it when I get some free time.

-CMX

An option that sends a PM or e-mail to the user when ticket replied too, and when a new ticket created the admin / mods are notified. Very good mod though.

Xplorer4x4 08-25-2005 05:02 PM

Quote:

Originally Posted by nealparry
An option that sends a PM or e-mail to the user when ticket replied too, and when a new ticket created the admin / mods are notified. Very good mod though.

I second that motion. Some sort of notifcation system should be implied at the very least.

*instaled* :)

Xplorer4x4 08-25-2005 06:15 PM

V0.6 already?????? That was quick. :-p

mikexxx 08-26-2005 06:03 PM

Quote:

Originally Posted by nealparry
An option that when a new ticket created the admin / mods are notified. Very good mod though.

I agree, this will be nice.

WhisperPntr 08-27-2005 05:46 PM

Very nice script! I'm currently modifying it to include status (like pending, approved, etc) and also added the quick template organization plugin.

If you want me to show the code for adding the status, or you don't want me working on it, please pm me. :) Thanks again.

Code:

                <plugin active="1">
                        <title>vBSupport Template Grouping</title>
                        <hookname>template_groups</hookname>
                        <phpcode><![CDATA[$only = array_merge($only, array('support' => 'vBSupport')); ]]></phpcode>
                </plugin>


GiJoe 08-28-2005 01:53 AM

this rocks! Thank you for the time and effort of making this available to us! :D

Xplorer4x4 08-28-2005 05:06 AM

The only thing this majorly lacks now, as mentioned above, is a system to notify the staff. An option like WhisperPntr said would be nice but a notifcation system is vital to this system IMO.

WhisperPntr 08-28-2005 05:41 AM

Hi there CMX, I am almost done adding a status option to the script. If you're interested in the small add ons, please pm me or post back here.

Xplorer, the staff member are notified by pms and emails last I checked.

CMX_CMGSCCC 08-28-2005 06:39 AM

Quote:

Originally Posted by WhisperPntr
Very nice script! I'm currently modifying it to include status (like pending, approved, etc) and also added the quick template organization plugin.

If you want me to show the code for adding the status, or you don't want me working on it, please pm me. :) Thanks again.

Code:

                <plugin active="1">
                        <title>vBSupport Template Grouping</title>
                        <hookname>template_groups</hookname>
                        <phpcode><![CDATA[$only = array_merge($only, array('support' => 'vBSupport')); ]]></phpcode>
                </plugin>


In this game, the more eyes/help on the coding the better. I have just used the microstats plugin to see that there were a lot of uncached templates. In the v0.7 version, that will be fixed, there should be 0 uncached templates when v0.7 is out.

I'll add your plugin code to the installer for v0.7 as well. I have just changed the ticketlistbit template to show the data like this as well.

I also have done the followint stuff for v0.7:

1) Used the microstats hack to see that some templates were
uncached. Added lines to the PHP to cache them, it should
speed up the load times of 'showticket' dramatically.
2) Updated the ticketlistbit template a bit to be more useful.
a) It shows tickets with no replies in BOLD.
b) It shows the category under the ticket / ticket starter.
c) It shows the open/closed status.
d) It shows the last poster to the ticket.
e) It shows the number of replies to the ticket.
f) It shows an open/closed icon in addition to the ticket
icon. (It will use new icons if the ticket has been
updated since your last visit.)
3) It now lists the tickets in the order they have been
created / replied to.
4) Rebuild Reply Count has been changed to Rebuild Info.
a) It updates the replycount.
b) It updates the lastposter.
c) It sets replydateline to dateline if equal to 0.
NOTE: If you are upgrading, you should run Rebuild Info after
you have installed the product XML.

There are a few more things I want to get into v0.7, then a release will happen. (Like the notification thing, it will require a new flag to the "user" table so it can be enabled per user basis and not via usergroup.)

-CMX

Xplorer4x4 08-28-2005 07:10 AM

Quote:

Originally Posted by WhisperPntr
Xplorer, the staff member are notified by pms and emails last I checked.

I see that the person submiting the ticket is able to be notfied via email and/or PM but i do not get a notification when somone posts a ticket.

WhisperPntr 08-28-2005 12:18 PM

Hey CMX,

That sounds great and it would be great to work alongside you as well as develop an extra plugin to have this interface with Ron1n's vbpurchase (a hack which I already have his permission to update and use).

Here are some screens of the changes that I've done, as well as a modification of the ticket template.

If you're interested in seeing the code changes, I'll modify the script I have to use your 0.7 version and then send the changes I added to you. They're very rudimentary and are based on the category updates.

Cheers!
~Whisper

CMX_CMGSCCC 08-28-2005 03:21 PM

Quote:

Originally Posted by WhisperPntr
Hey CMX,

That sounds great and it would be great to work alongside you as well as develop an extra plugin to have this interface with Ron1n's vbpurchase (a hack which I already have his permission to update and use).

Here are some screens of the changes that I've done, as well as a modification of the ticket template.

If you're interested in seeing the code changes, I'll modify the script I have to use your 0.7 version and then send the changes I added to you. They're very rudimentary and are based on the category updates.

Cheers!
~Whisper

Sounds good, I'll release v0.7 now so you can add the stuff. The other feature I want to add will take a little longer than I have today. And I'm going on a mini-vacation with the family this Monday to Thursday. So better to release v0.7 now and save the "notification per user" til I get back.

-CMX

Xplorer4x4 08-28-2005 06:09 PM

I have found a few bugs. First off if you only upload the product XML file your system will look like this:
http://img174.imageshack.us/img174/5...pimage22og.png
I uploaded all the file over writing the old ones and it fixed it.

The only other bug I see is there is no post icon asigned for a closed ticket. I just see a red X linked to www.yoursite.com/forums

Wasn;t sure if you guys were aware of that or not so figuered I would make note of it.

I would still love to see a staff notifcation method. :p

CMX_CMGSCCC 08-28-2005 08:49 PM

Quote:

Originally Posted by Xplorer4x4
I have found a few bugs. First off if you only upload the product XML file your system will look like this:
http://img174.imageshack.us/img174/5...pimage22og.png
I uploaded all the file over writing the old ones and it fixed it.

The only other bug I see is there is no post icon asigned for a closed ticket. I just see a red X linked to www.yoursite.com/forums

Wasn;t sure if you guys were aware of that or not so figuered I would make note of it.

I would still love to see a staff notifcation method. :p

The first bug was because the files were not all uploaded I would have guessed. The second was a bug in the way the double icon system was working. I have fixed that in v0.7b, and added a quick notification to notify the assigned tech that the ticket was replied to. Later on, I will make it more elaborate so each admin can choose if they want to get notified or not, and via PM or Email too.

-CMX

Xplorer4x4 08-28-2005 09:04 PM

Quote:

Originally Posted by CMX_CMGSCCC
The first bug was because the files were not all uploaded I would have guessed.

Nope all the files were uploaded as I have been runing this since version 0.5. Plus wouldn't the hack itself be usless with out all the files?

CMX_CMGSCCC 08-28-2005 09:23 PM

Quote:

Originally Posted by Xplorer4x4
Nope all the files were uploaded as I have been runing this since version 0.5. Plus wouldn't the hack itself be usless with out all the files?

Yes, but between versions sometimes the class_*.php files do not get changed unless a new feature was added to the database. So I imagine some people were just uploading the vBSupport.php file. The class_ files have been updated to add a couple new features, and to get the replydateline working as well.

Do you still have this problem with the v0.7b zip?

-CMX

WhisperPntr 08-29-2005 09:29 AM

Thanks CMX. I'll be working on the changes now and send you a zip file sometime my tonight or tomorrow. I will mark the changes I've made with either a
PHP Code:

<!-- WhisperPntr //--> 

or a
PHP Code:

##WhisperPntr 

both of which you may feel free to delete once the code is to your liking.

Quote:

Originally Posted by CMX_CMGSCCC
Sounds good, I'll release v0.7 now so you can add the stuff. The other feature I want to add will take a little longer than I have today. And I'm going on a mini-vacation with the family this Monday to Thursday. So better to release v0.7 now and save the "notification per user" til I get back.

-CMX


Xplorer4x4 08-29-2005 06:33 PM

Quote:

Originally Posted by CMX_CMGSCCC
Yes, but between versions sometimes the class_*.php files do not get changed unless a new feature was added to the database. So I imagine some people were just uploading the vBSupport.php file. The class_ files have been updated to add a couple new features, and to get the replydateline working as well.

Do you still have this problem with the v0.7b zip?

-CMX

When I said I had to reupload the PHP files I was upgrading to 6.0 or 7.0. Sorry I can't recall which one specifacly as you have released like 3 versions in the past week. It was proabbly the orignal 7.0 upgrade.

Your upgrade instructions say upload the new XML file, yet here you say we need to upload the PHP files sometimes. Make up your mind. :p

WhisperPntr 08-30-2005 12:30 AM

Quote:

Originally Posted by Xplorer4x4
When I said I had to reupload the PHP files I was upgrading to 6.0 or 7.0. Sorry I can't recall which one specifacly as you have released like 3 versions in the past week. It was proabbly the orignal 7.0 upgrade.

Your upgrade instructions say upload the new XML file, yet here you say we need to upload the PHP files sometimes. Make up your mind. :p

When in doubt upload ALL the files from the UPLOAD directory over the other ones. Also through the admin panel, choose to OVERWRITE the xml file. This is the way to update the xml file. As for "making up [his] mind" that's not particularily nice way to address this. Even if you mean no harm out of it, consider saving the developer's time when it is working well for other people but not for you.

In other developments, CMX I fixed a conditional so that pms are no longer sent to you if you are the replyer to the ticket (in other words, it doesn't send a pm about your own reply).

In addition, I am adding a very simple method of notification that is reliant on who replied to the ticket. It sends a notification pm about a non-self reply to all who replied in the ticket as well as whomever is assigned ONCE until another reply is made.

Let me know how you feel about this notification method.

Xplorer4x4 08-30-2005 06:59 PM

Quote:

Originally Posted by WhisperPntr
When in doubt upload ALL the files from the UPLOAD directory over the other ones. Also through the admin panel, choose to OVERWRITE the xml file. This is the way to update the xml file.

When I upgraded, I had no doubts because the instructions say XML file only.

Quote:

As for "making up [his] mind" that's not particularily nice way to address this. Even if you mean no harm out of it, consider saving the developer's time when it is working well for other people but not for you.
Well I personally do not find it very nice that you feel the need to criticize the way I comunicate with CMX. IF CMX feels it would of been more appropriate to simply say his upgrade isntructions were slighlty inadequate, then it his his place to do so and I aplogize.

Well seeing as I reported that with in about 30 minuetes of the hack being released, there is no need for anyone else to report it unless they have a fix correct? CMX resolved the issue.

Can we leave it at that please and move on as I was simply trying to help out you the codders?

mikexxx 09-02-2005 06:28 AM

If a user create a new ticket and no post icon is selected I get a red cross. If I look into the code there is no default icon.

<td class="alt1"><img src="" alt="" border="0" /></td>

peterska2 09-03-2005 11:06 PM

/me clicks install

mikexxx 09-04-2005 10:14 AM

In this style: support_ticketlistnone

The text in that style isn’t in the language phrases. So when somebody (like me) translate all the phrase to another language the is still text in the style. Maybe you chance that for future release.

CMX_CMGSCCC 09-04-2005 03:12 PM

Quote:

Originally Posted by mikexxx
If a user create a new ticket and no post icon is selected I get a red cross. If I look into the code there is no default icon.

<td class="alt1"><img src="" alt="" border="0" /></td>

Did you reupload all of the files in the /UPLOAD folder and when you imported the product file did you select Allow Overwrite to Yes?

As far as the support_ticketlistnone phrase, I will add that for v0.8.

I'm waiting for the code from WhisperPntr to finalize v0.8.

Send me the updates if you see this WhisperPntr.

As far as the upgrade instructions go, I thought it was obvious to reupload all of the files, but in any case, I have added that to the instructions for the upgrade at the bottom of the readme and the post.

-CMX

CMX_CMGSCCC 09-14-2005 03:42 AM

I guess WhisperPntr is MIA, I'll start looking into the update v0.8 when I get time. Its getting to the busy season of the year, 10-15 PS2 games a week until thanksgiving, and I have to hack code breaker codes for all of them, so time might be a bit limited. But I'll see what I can do.

-CMX

hydrostatic 09-17-2005 09:29 PM

Is it possible to do a Who's Online integration for this?

CMX_CMGSCCC 09-21-2005 12:43 AM

Updated to v0.8:

1) Bugfix: It doesnt send the assigned tech a PM if they reply.
2) Bugfix: Rebuild Info didnt work for names with ' in them.
3) Template support_listbitnone uses a phrase now.
4) Added Custom WOL hooks to show up in the WOL info.
5) Added some hook locations to vBSupport.php, more could be
added over time as well.
NOTE: The hook locations are inside the included file:
/UPLOAD/includes/xml/hooks_support.xml

-CMX

Delphiprogrammi 09-21-2005 04:51 PM

i always get "you are not authorized to manage xxxx" and i'm logged in as admin .... now what the heck ?

Xplorer4x4 09-21-2005 10:36 PM

Quote:

Originally Posted by Delphiprogrammi
i always get "you are not authorized to manage xxxx" and i'm logged in as admin .... now what the heck ?

Did you go into user group settings and assign permsions for all the usergroups?

uae 09-22-2005 05:24 AM

Thanks for the hack,

I got this error when using a single or double quotation in the search field:

Code:


Database error in vBulletin 3.5.0 Release Candidate 3:
Invalid SQL:
  SELECT COUNT(*) AS tickets
  FROM ticket AS ticket
  WHERE (ticket.categoryid = '1') AND (ticket.title like '%'%');
MySQL Error  : You have an error in your SQL syntax near '')
 ' at line 4
Error Number : 1064
Date                : Thursday, September 22nd 2005 @ 10:21:28 AM
Script          : http://vb/vBSupport.php
Referrer        : http://vb/vBSupport.php?do=newsearch
IP Address  : 127.0.0.1
Username        : admin
Classname        : vb_database


Delphiprogrammi 09-22-2005 10:41 AM

Quote:

Originally Posted by Xplorer4x4
Did you go into user group settings and assign permsions for all the usergroups?

done & problem solved working fine now


All times are GMT. The time now is 08:17 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01814 seconds
  • Memory Usage 1,891KB
  • 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
  • (5)bbcode_code_printable
  • (3)bbcode_php_printable
  • (20)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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