vb.org Archive
Page 12 of 16 « First 21011 12 1314 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)

soletrader 10-03-2006 09:59 PM
Can anyone post the working vbsupport.php for 3.6? I would appreciate it. Thank you

codemoxie 10-04-2006 11:56 AM
Anyone have a solution to the above bug? Support has been dead on our site for the last week :(

JamieLee2k 10-07-2006 09:39 AM
This is working for 3.6.1 but haven't tried it on 3.6.2 yet, can anyone tell me if I can assign admin/mod to a forum I create?

Example:
If I create 4 forums:
Premiership
championship
Div 1
Div 2

Now I want to assign say
john to Premiership
bob to Championship
Mark to Div 1
Jamie to Div 2

This is so they can look after there own tickets rather than looking at everyones tickets from all divisions

JamieLee2k 10-07-2006 11:11 PM
I am testing this on my PC before I go live with it, I have installed it fine and it works like a dream apart from 2 things in which I think I am missing.

1. How do I assign an admin/mod to a category so they can sort tickets out in that category only?
2. How can I create a usergroup so they can post a thread in to any category they wish? at the moment a registered user can't post a ticket as there are no categorys to choose from yet there are categorys there.

precharge 10-09-2006 07:32 AM
I don't see an update for 3.6.1 ? I get the same error after an upgrade

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,3)

ORDER BY post.dateline;

Derekclarke 10-09-2006 12:22 PM
since upgrade to 3.6.2 this is not working, i have not had any reports of problems on any other 3.6.0 or 3.6.1 versions, and i did not test it so cannot comment.

however, i have tried to remove this adn drop all the tables from the databse and then re-install.

but when a new ticket is created, it doen not give an option to choose a catagory. and you cannot post a support ticket without selecting a catagory.

Any ideas with this?

Thanks
Derek

JamieLee2k 10-09-2006 01:10 PM
I have tried this on my PC and it works on 3.6.1 for sure but that was using windows and not Unix or Linux

CypherSTL 10-09-2006 01:23 PM
Unix or Linux or Windows would not make any difference, I have tried, PHP is PHP no matter what OS it is installed on...not working on 3.6.1 nor 3.6.2, tried fresh install as well with no luck. There where alot of template changes in 3.6.1 from 3.6.0 and some more from 3.6.1. to 3.6.2 which i am sure you are aware of, it was somewhere in these changes that broke the hack.

I am running Versions:
PHP - 4.4.3
MySQL - 4.1.21

JulianWolf 10-09-2006 03:20 PM
There are some little thinks I?d like to have in this great hack. They really seam little to me, has anybody an Idea, how to?

First question

If a ticket-moderator has a new ticket assigned to him or a new answer to an existing ticket there should appear a little grafic in the nav-menu. Just like a sentance under the messages-sentence (navbar):

Quote:
Welcome, JulianWolf.
You last visited: 21. Sep 2006 at 20:00
Private Messages: Unread 0, Total 57.
You have x new tickets to moderate
As far as this only affects the assigned tickets I?d love to have another sentence just for a smaller group (only the support-admins, who can assign tickets):

Quote:
Welcome, JulianWolf.
You last visited: 21. Sep 2006 at 20:00
Private Messages: Unread 0, Total 57.
You have x new tickets to moderate
There are x unassigned tickets in the system
This would completely solve the eMail-question. As long as I have a visual information on the navbar I don?t need another eMail-notification.

Second question, a little more complex

Can I directly assign tickets by the category? Means: A ticket from category x should always directly assigned to moderator a, a ticket from category y always to moderator b and so on.

Third question, a very easy one

How can I built up a link where the category is prechoiced? For example I like to have a link "Forum-Problems" which should automatically go to the "new ticket"-page with the link "http://www.nlp-deutschland.de/forum/vbsupport.php?do=newthread". This is easy, but how can I pre-choice that the link also puts the category "Forum-Problems" as the standart-choice in the form?

Last question

I?m a little unsecure about "forgotten tickets". For example: If another moderator doesn?t answer on the ticket, is there a way to "warn" the moderators?

An example: If a ticket isn?t answered in 3 days there is a warning-message on every ticket-admin like that one:

Quote:
Welcome, JulianWolf.
You last visited: 21. Sep 2006 at 20:00
Private Messages: Unread 0, Total 57.
You have x new tickets to moderate
There are x unassigned tickets in the system
There are x old tickets still open
Is all that solvable? And, what do you think? Is it usefull?

Best wishes, Julian!

Jealousy10312 10-09-2006 04:52 PM
I would not use this hack. There are so many flaws with it, it's insane.

CypherSTL 10-09-2006 08:37 PM
Quote:
Originally Posted by Jealousy10312
I would not use this hack. There are so many flaws with it, it's insane.
The hack works flawlessly with it's intended install on 3.5.4, however it does work flawlessly on 3.6.0, the problem is that many of us love this hack but are on 3.6.1 or 3.6.2 and there have been many changes since 3.6.0 that the hack is "broke" in newer versions than 3.6.0. Once this can be ported correctly to these version that it is broke in it will again work flawlessly.

soletrader 10-09-2006 09:16 PM
It doesnt work with 3.6

CypherSTL 10-09-2006 10:13 PM
I have had it installed on 3.6.0 since it went gold with no problems, it broke when I upgraded to 3.6.1

JamieLee2k 10-10-2006 10:57 AM
here see for yourself http://82.16.74.99/forum/vbsupport.php? This is on my PC at the moment running latest versions of MySQL, PHP and Apache

username and pass is test/test

mtha 10-21-2006 06:43 AM
CMX, any plan to upgrade this one to work with 3.6.2 and release next version?

Intex 10-22-2006 06:47 AM
When submitting a ticket is the admin and the member supposed to get an email / PM notifying that a new ticket has been received / submitted?

EasyTarget 10-24-2006 07:29 PM
Quote:
Originally Posted by mtha
CMX, any plan to upgrade this one to work with 3.6.2 and release next version?
CMX_CMGSCCC
Coder

Last Online:
Jul 2006

bhall23 10-26-2006 10:51 PM
I am using v2.0.0 beta 1. is there a way to do this with 2.0.0 https://vborg.vbsupport.ru/showpost....&postcount=125 ?

or, if not, is there a way to have the drop down of categories be in the same order as they are set to display order in the admin?

Sabrina2007 11-01-2006 06:22 PM
Good day, First times apology for my very bad English. I built myself today into vBulletion 3.6.2. Now there are there however somehow problems, if I liked to attach at a provided ticket an appendix come the PopUp window where one the appendix to select and can high-load, only in the window appears my starting side of the board. Desweitern inserted SMI-read not plotted. A Mailbenachrichtig or a pn do not get I also if a ticket were provided. Now my Fragem goes it at all with 3.6.2. And here times a Fehlmeldung also times repeatedly appears: Data base error in vBulletin 3.6.2: Invalid SQL: SELECT post.postid, IF (post.userid = 0, post office username, user username) AS username, post office PAGE text, post.allowsmilie, post.userid, post office DATE LINE FROM vb3_vbs_ticket_post AS post office LEFT JOIN vb3_user AS user ON (user.userid = post.userid) WHERE post.visible = 1 AND post.threadid = ORDER BY DATE LINE DESC, postid DESC LIMIT 11; MySQL error: You have at error in your SQL syntax. Check the manual that corresponds tons your MySQL server version for the right syntax ton use near 'ORDER BY DATE LINE DESC, postid DESC LIMIT 11 ' RK LINE 8 Error no. : 1064 Date: Wednesday, November 1st 2006 @ 08:21: 17 PM Script: http://www.xxxxxx/vbu.../vbsupport.php Referrer: http://www.xxxxxxx/vbu...p?do=newthread IP address: xxxxxx User name: sabrina Class name: vb_database For an assistance like I the error behebn can would be very grateful I. MFG Sabrina

nymyth 11-06-2006 04:59 PM
Sabrina,

This mod has a lot of problems with 3.6.2, id uninstall if i were you....

CypherSTL 11-06-2006 05:23 PM
If you wish to use this mod and are 3.6.x it is best to stick with 3.6.0 as 3.6.1 and 3.6.2 are not compatable, there where to many code changes in 3.6.1 and even more in 3.6.2

Also remember this mod IS for 3.5.4 anyways, so it is just by chance it even works with 3.6.0

dethfire 11-15-2006 07:36 PM
bump for conversion

JamieLee2k 11-16-2006 02:07 PM
Trying to put in the template change in the navbar

The following error occurred when attempting to evaluate this template:

Parse error: syntax error, unexpected T_CHARACTER, expecting ']' in xxxxxx/xxxxxxx/xxxxxxxx/xxxxxxx/xxxxxx/forum/includes/adminfunctions_template.php(3593) : eval()'d code on line 101

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

Can anyone tell me why this might be wrong, it has worked fine in other styles I have done just not this new one

DS MrSinister 11-30-2006 02:49 AM
yes its missing a ] after the q.

try this code!

Code:
<!-- vbSupport start -->
                        <if condition="$vboptions['vbsupport_enabled']"><td class="vbmenu_control"><a href="vbsupport.php$session[sessionurl_q]">$vbphrase[vbsupport_title]</a></td></if>
<!-- vbSupport end -->

MrPHD 12-02-2006 01:24 PM
Installed and working nice.Thanks

erkme73 12-05-2006 03:10 PM
Your website needs just a few more pop-ups... Any chance this will be modded to work on 3.6.x?

BobbyBig 12-05-2006 06:23 PM
Please make that workable for 3.6.4 - Because this is really great mod

Guest201202001 12-06-2006 08:23 AM
for the version 3.6.4??? this is a good mod

erkme73 12-06-2006 11:35 PM
I just got done reading about 80% of the posts in this thread. It's pretty clear that the problem isn't specifically 3.6.x - it's only if you UPGRADE from an older version to a newer version of vBulletin that the line40 error pops up. I would have hoped this would not have been too challenging to solve, but clearly either the interest or technical level isn't there to beat the bug out of the code.

I would really like to install this, or something like it. Has anyone been able to install this mod on an upgraded 3.6.4 version of vBulletin? Are there any comparable mods/hacks that would offer the same features?

TIA...

Guest201202001 12-13-2006 11:44 PM
works very well with 3.6.4

if u r going to take an error: like this
Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
level,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM vbs_ticket_post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
WHERE post.postid IN (0,141,153)

ORDER BY post.dateline;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054

jusd add this query at your forum DB:
Code:
ALTER TABLE user ADD level INT UNSIGNED NOT NULL DEFAULT '0'


this worked to me.

Magnetism 12-14-2006 07:41 AM
Getting the error

Warning: Invalid argument supplied for foreach() in /vbsupport.php on line 391

When posting a new ticket, any ideas on how to fix this?

sinisterpain 12-24-2006 01:19 PM
Has anyone found or resolved the problem with Categorys not working in 3.6.4. Is CMX still working on this hack since it is a useful tool for a lot of forums.

sinisterpain 12-31-2006 09:03 PM
It appears to me just going thru the code in functions_vbsupport that some thing here is not right. It will not read the datastore for the variables. Not a coder so I can not figure out why the categories are not displaying. The author seems to have disapeared and while it its functional in 3.6.4 without categories it much more beneficial if they were too work. Would greatly appreciate any help. If its wrong to post this, I appologize

Code:
// function to build the category options
function vbsupport_build_category_options($selcatid)
{
  global $vbulletin, $vbphrase, $show;

  // clear out $categoryoptions
  $categoryoptions = '';
  //check if they are allowed to change ticket categories
    $show['category'] = false;
  if (!empty($vbulletin->vbs_category) && is_array($vbulletin->vbs_category))
      {

    // always set this first value
    $categoryoptions = "<option value=0>" . $vbphrase['vbsupport_none'] . "</option>";

    // process all of the vbs_category
    foreach($vbulletin->vbs_category AS $categoryid => $category)
    {
      // check if this category is accessible
      if (($category['active'] > 0) AND vbsupport_check_allowed($vbulletin->userinfo, $category['allowedgroups'], $category['deniedgroups']))
      {
        // check if its integrated with vbbux / vbplaza
        if ($vbulletin->options['vbsupport_vbbuxplaza_integrate'] > 0)
        {
          // check if the cost is more than 0
          if ($category['cost'] > 0)
          {
            // format the cost properly
            $category['cost'] = vb_number_format($category['cost'], $vbulletin->options['vbbux_decimalplaces']);

            // update the $category['name'] to show the cost
            $category['name'] .= " (" . $category['cost'] . " " . $vbphrase['vbbux_name'] . " " . $vbphrase['vbbux_points'] . ")";
          }
        }

        // check if this is the one assigned
        if ($categoryid == $selcatid)
        {
          $categoryoptions .= "<option value=" . $categoryid . " selected>" . $category['name'] . "</option>";
        }
        else
        {
          $categoryoptions .= "<option value=" . $categoryid . ">" . $category['name'] . "</option>";
        }
      }
    }

    // set it so this user can set a category
    $show['category'] = true;
  }

  // return the $categoryoptions
  return $categoryoptions;
}

sinisterpain 01-04-2007 02:54 AM
Ok, with some research I finally got this to show the categories and assigned admins in both the support thread created and in creating a new ticket in vB 3.6.4.

you need to edit the author's files in the upload folder includes/vbsupport_functions.php file and the vbsupport.php file as follows:

vbsupport_functions.php

find:
Code:
// function to build the category options
function vbsupport_build_category_options($selcatid)
{
  global $vbulletin, $vbphrase, $show;

  // clear out $categoryoptions
  $categoryoptions = '';

  // check if they are allowed to change ticket categories
  $show['category'] = false;
  if (!empty($vbulletin->vbs_category) && is_array($vbulletin->vbs_category))
 {
change to:

Code:
// function to build the category options
function vbsupport_build_category_options($selcatid)
{
  global $vbulletin, $vbphrase, $show;

  // clear out $categoryoptions
  $categoryoptions = '';

  // check if they are allowed to change ticket categories
  $show['category'] = false;
  $vbulletin->datastore->do_db_fetch("'vbs_category'");
  if (!empty($vbulletin->vbs_category) && is_array($vbulletin->vbs_category))
  {
In vbsupport.php

find:
Code:
  // build the assigned user (if any)
      $show['assigned'] = true;
      $assigned = $vbulletin->vbs_admin[$thread['assigneduserid']];
      if (!empty($assigned) && is_array($assigned))
      {
change to:
Code:
// build the assigned user (if any)
      $show['assigned'] = true;
      $vbulletin->datastore->do_db_fetch("'vbs_admin'");
      $assigned = $vbulletin->vbs_admin[$thread['assigneduserid']];
      if (!empty($assigned) && is_array($assigned))
      {
find:
Code:
// build the category (if any)
      $category = $vbulletin->vbs_category[$thread['categoryid']];
      if (!empty($category) && is_array($category))
      {
change to:
Code:
// build the category (if any)
      $vbulletin->datastore->do_db_fetch("'vbs_category'");
      $category = $vbulletin->vbs_category[$thread['categoryid']];
      if (!empty($category) && is_array($category))
      {
I am posting this fix since no word or activity has come from the author since July 2006. I feel that alot of members could really use this hack for their boards. The call for the datastore was not working which required a do_db_fetch since it did not recognize the vbs_category and would only see the datastore folder in the data base when using the call $vbulletin->vbs_categaory. These edits may not be needed by everyone, if you did a fresh install of 3.6.4 and not the upgrade the authors files may work without the edits you need to try the authors file and if categorys do not work then use the edits.

tank14 01-05-2007 12:39 AM
Quote:
Originally Posted by sam anders (Post 1052102)
i know the coder of this mod is having issues with pc but wondering if any one as any ideas on the above?
Same issue here.

sinisterpain 01-05-2007 12:43 AM
Forgot another edit which must be made to the admincp/vbsupport.php file inorder for emails and pms to work with the categorys. Since the pm and emails get sent based on the individual category set up. Once the file edit is made in the admincp-> manage categorys select a category for edit and at the bottom you should see check boxes with administators listed for email and PM option. Select the admin and save this will send a pm based on who is selected for a specific category.

in the folder admincp/vbsupport.php

find:

Code:
function print_admin_user_row($title, $name = 'multibox', $columns = 0, $userlist)
{
  global $vbulletin;

  // build $userids
  if (empty($userlist))
  {
    // build an empty $userlist
    $userlist = '0';
  }
  $ids = explode(',', $userlist);

  // build the options
  $options = array();
  foreach($vbulletin->vbs_admin AS $userid => $user)
{

change to:

Code:
function print_admin_user_row($title, $name = 'multibox', $columns = 0, $userlist)
{
  global $vbulletin;

  // build $userids
  if (empty($userlist))
  {
    // build an empty $userlist
    $userlist = '0';
  }
  $ids = explode(',', $userlist);

  // build the options
  $options = array();
  $vbulletin->datastore->do_db_fetch("'vbs_admin'");
  foreach($vbulletin->vbs_admin AS $userid => $user)
  {
find:
Code:
// unserialize the datastore
$vbulletin->vbs_category = unserialize($vbulletin->vbs_category);
$vbulletin->vbs_admin = unserialize($vbulletin->vbs_admin);
change to:
Code:
$vbulletin->datastore->do_db_fetch("'vbs_category'");
$vbulletin->vbs_category = unserialize($vbulletin->vbs_category);
$vbulletin->datastore->do_db_fetch("'vbs_admin'");
$vbulletin->vbs_admin = unserialize($vbulletin->vbs_admin);

sinisterpain 01-07-2007 01:19 PM
Quote:
Originally Posted by tank14 (Post 1151027)
Same issue here.
Your case is unique as we discussed on MSN, you are running a 3.6.4 install on a 3.5.4 skin, with a fresh install of 3.6.4. You do not require most if not any edits that I supplied. But you need to be sure that all of your permisions are set properly. Also you need to explain your problem in detail not just quote another thread.

BigJohnny 01-09-2007 01:43 PM
the zip for 2.0 is corrupt... :(

sinisterpain 01-09-2007 08:10 PM
Quote:
Originally Posted by BigJohnny (Post 1154574)
the zip for 2.0 is corrupt... :(
I just downloaded it and it works fine for me

BigJohnny 01-09-2007 09:58 PM
yup your right... it was a problemwith me.


All times are GMT. The time now is 04:47 PM.
Page 12 of 16 « First 21011 12 1314 Last »
Show 40 post(s) from this thread on one page

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.01999 seconds
  • Memory Usage 1,859KB
  • 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
  • (14)bbcode_code_printable
  • (8)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