vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   HelpDesk v1.63 (https://vborg.vbsupport.ru/showthread.php?t=77155)

jerett 04-20-2005 02:31 AM

Anyone know why the nav link might not show up for the helpdesk?

KTBleeding 04-20-2005 04:56 AM

Quote:

Originally Posted by jerett
Anyone know why the nav link might not show up for the helpdesk?

Did you edit the navbar template?

mholtum 04-20-2005 08:52 AM

/me installs! Great Hack thanks.

MoK 04-20-2005 11:18 AM

Hallo Community,

This is my first Post here, and at first i would to say sorry for my bad english *lol*. It?s not my favourite Language :nervous: ... I?ve install these Hack, but when i made a new Ticket i?ve got a SQL Database Error when i submint him! The Auto-Messega arrive me, and the Ticket i can see it in the Help Desk, but when i will open it, it is the same Database Error as when i submint the Ticket... I Hope your can help me and i hope so much that you can understand me :rolleyes:

This is the Database Error i become:

Code:

Datenbankfehler in vBulletin 3.0.7:

Ungueltige SQL-Abfrage: SELECT DISTINCT userid FROM user AS user, ticket AS ticket LEFT JOIN ticketdepartment AS ticketdepartment ON (ticketdepartment.departmentid = ticket.departmentid) WHERE ( FIND_IN_SET(, membergroupids) OR usergroupid = ) AND (userid = 1 OR ticket.postuserid = 1)
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 ' membergroupids) OR usergroupid = ) AND (userid = 1 OR ticket.p

mysql error number: 1064

Datum: 20.04.2005 13:55:25
Skript: http://www.diegilde2.de/Forum/forum/helpdesk.php?do=ticket&tid=2
Referer: http://www.diegilde2.de/Forum/forum/helpdesk.php?do=unresolved
Benutzername: MoK

best regards MoK

WhSox21 04-20-2005 12:53 PM

For some reason it looks like $bbuserinfo is not being set. I honestly have no idea why that's not working correctly? I would need more information on your files.

MoK 04-20-2005 01:40 PM

Thank you for youre Answer,

and which informations you need?

greetz MoK

MoK 04-20-2005 06:08 PM

I have found the Problem :)

It?s a great Hack! Thank you WhSox21 for this !!!!!!!!

misuse 04-21-2005 05:55 AM

Great work. Easy install. Submitted request at the URL listed.

evenmonkeys 04-21-2005 06:05 AM

It would appear that the bug I had you fix seems to be popping back up. I have users who are finding ways around your fix. They're still able to view and reply to other tickets.

MikeWarner 04-21-2005 01:00 PM

Quote:

Originally Posted by xYarub
It would appear that the bug I had you fix seems to be popping back up. I have users who are finding ways around your fix. They're still able to view and reply to other tickets.

I am also getting this.

WhSox21 04-21-2005 04:58 PM

Very odd. Let me look into this.

evenmonkeys 04-22-2005 06:40 PM

Find anything out yet? =\

TheMusicMan 04-25-2005 07:21 PM

Quote:

Originally Posted by xYarub
Find anything out yet? =\

Hey WhSox21

Superb hack matey... spot on.

I appreciate you have a hard time managing all the feature requests when they are posted in here, but is there any way you might be able to either post the updated feature request list here, or perhaps create a page on your site where we could see the list...? Maybe even with a status on each feature i.e. if you're thinking of implementing it, if so, progress etc...

Again, I think it is fair to say that everyone here very much appreciates the great work you have done on the Helpdesk system. Thank you for your tolerance, patience and skill...

John

Tom1234 04-27-2005 01:49 AM

WhSox21,

Can you confirm the ability for others to view tickets they shouldn't have access to or do you need more information? Sounds like a pretty major bug that needs plugging ASAP.

MikeWarner 04-27-2005 07:04 AM

Tom - I have PMed him a screen shot of me doing this to his own forum - he is acting on it but is busy at the moment. He has PMed me to let me know that there will be a fix soon. I'm sure WhSox21 will sort it out as soon as he has a moment.

Lostnode 04-30-2005 06:30 AM

Quote:

Originally Posted by WhSox21
Very odd. Let me look into this.

Any chance the fixes are complete. I dunno if you have heard this from "Deaths" (original post - https://vborg.vbsupport.ru/showthrea...light=helpdesk)

Quote:

Originally Posted by Deaths
I strongly _NOT_ recommend this hack, as it has some _SERIOUS_ security issues! (https://vborg.vbsupport.ru/showpost....&postcount=451 as an example)

He says he'll fix it, but this would be the second fix for the same bug, and I don't think he'll every be able to patch it.

PS I've found more than 5 security exploits, 4 of them each a different way of looking at other tickets, and 1 is an SQL injection.

SQL Injections are pretty bad, I have had a few of my sites compromised becasue of this. I am very interested your script for my hosting site, but wish not to have to deal with security holes. Any truths to this? And if Death hasn;t contacted you with his finds, message him, he should have reported them to you so you could fix them (if they do indeed exist that is)

WhSox21 04-30-2005 06:52 AM

Deaths may be mad because his helpdesk hack was removed from here. But yes, I just looked and there are a few SQL injection problems, but only a few! These will be fixed tomorrow with the other bug. I've just finished my exams this week and have a little bit more free time.

I'm sorry for the lack of updates guys.

WhSox21 04-30-2005 08:03 AM

I just spent a few hours on this and I've got the problems sorted out. Deaths has not contacted me about the problems, but I don't see any other possible problems.

Let me know how this update works out!

Deaths 04-30-2005 08:06 AM

I'll take a look at the current code, and let you know if I find any more problems :)

WhSox21 04-30-2005 08:17 AM

I have also added the ability to view the requests via this page:
http://www.hackvb.com/helpdesk.php

Just click on the link in the top left.

mholtum 04-30-2005 03:22 PM

When I upgrade I get this:
Code:

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO vb3_phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'helpdesk_auto_response', '$vboptions[bbtitle] Auto Response', '4000')
mysql error: Duplicate entry 'helpdesk_auto_response-0-4000' for key 2

mysql error number: 1062

Date: Saturday 30th of April 2005 09:21:02 AM
Script: http://www.theflyfishingforum.com/forums/admincp/helpdesk_install.php?do=upgrade&step=2
Referer:
Username: fshfanatic
IP Address: 68.99.209.240


WhSox21 04-30-2005 04:18 PM

Did you read the instructions in the file? You are not required to upgrade unless you are using an older version.

rjordan 04-30-2005 04:49 PM

I got the same error upgrading from 1.53. I ended up removing and reinstalling.

WhSox21 04-30-2005 05:04 PM

I'll look into that. That's only a minor problem.

For a temporary fix, just uninstall the phrases before you run the upgrade process. This won't make you lose any information unless if you've changed the phrases.

WhSox21 04-30-2005 05:05 PM

What about the other problems? How's everything else?

MikeWarner 04-30-2005 05:59 PM

security issues seems fixed now - many thanks for the good work. Turning off PM notification would be good though.

Thanks

Lostnode 05-01-2005 09:48 AM

Quote:

Originally Posted by WhSox21
I just spent a few hours on this and I've got the problems sorted out. Deaths has not contacted me about the problems, but I don't see any other possible problems.

Let me know how this update works out!

As long as the SQL Injections are gone, I am as good as sold.

evenmonkeys 05-02-2005 07:31 PM

Lovely, man! Looks awesome and it's working great!

JayJay 05-02-2005 10:32 PM

Is there anyway to stop the "A ticket has been updated" message?

Sorry, I've had little time recently, so I haven't scoured this thread, apologies in advance if this has been asked prior to this.

WhSox21 05-02-2005 10:37 PM

Easiest way is to put // (a comment) on lines 434 - 438

This is the code of those lines:
PHP Code:

    while ($userinfo $DB_site->fetch_array($updatequery))
    {
        
sendprivatemessage ($userinfo'The following ticket has been updated:
[URL]'
.$vboptions[bburl].'/helpdesk.php?do=ticket&tid='.$_REQUEST['tid'] . '[/URL]''HelpDesk Ticket Update');
    } 


deta 05-05-2005 04:57 PM

Problem

If I answer to a ticket, then absolutely each registiete user gets pn sent "upgrade ticket.." and not only that the ticket write has.

The current 1,63 installed version.

Ask for urgent assistance.

Thanks

cu Deta

WhSox21 05-05-2005 05:13 PM

Your Department settings are incorrect.

deta 05-05-2005 06:24 PM

Quote:

Originally Posted by WhSox21
Your Department settings are incorrect.

????

WhSox21 05-06-2005 01:29 PM

Please read the whole first post above. It states how to setup the departments here:
https://vborg.vbsupport.ru/showpost....&postcount=242

hotrod1 05-07-2005 03:04 PM

How do you admin the tickets? I am an admin on my forum and I have access to deparment settings and such but I can't access tickets sent in by customers. Thanks and it was a breeze to install.

WhSox21 05-07-2005 09:14 PM

You must have department access with your primary usergroup only. Once that's set correctly up then you will see a section on the left hand side for Unresolved tickets.

hotrod1 05-07-2005 10:00 PM

Oh I see now because a user said that they sent a ticket but I never got one. But I sent a test message myself and I got it.

3clipse 05-09-2005 10:13 AM

some of the templates on my forums do not take advantage of drop down menus and as such the thread tools menu doesnt work, is there a work around for this?

deta 05-12-2005 07:19 PM

It would be great if it was possible for certain users, the tickets may answer which with new ticket would get a PN.

WhSox21 05-12-2005 07:36 PM

I have no idea what you mean by this?


All times are GMT. The time now is 11:40 PM.

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.02050 seconds
  • Memory Usage 1,820KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (7)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