The Arcive of Official vBulletin Modifications Site.

[HTL] & [very simple TXT] vB-Bugs · **Released**: 02-03-2004

OK, this is my first Hack release, so please forgive me if it's crap.

vB-Bugs
Version: 0.1f Alpha
vB-version: 3.0.0 Release Candidate 2
Developer: Kirby
Install difficulty: Easy
File edits: 1
Template edits: 0

Description of the Hack:
This is a basic vBulletin-powered Bug-Tracker
It is based on vB-Todolist originalli created by RekiM who kindly gave me permission to make this "port".

Features

User-definable Types, Severities and States
Front-End fully phrased
XHTML-Compliant
Various possibilities to Filter/Search

Requirements

vBulletin 3 RC2
mySQL > 4.0.2

Please note that this is an alpha release only and I can't and
won't take any responsibilities. Use it as-is at you own risk.

HACK INSTALLATION DETAILS:
New files for this Hack:
bugs.php
admincp/bugsadmin.php

Files modified for this Hack:
admincp/index.php

New templates for this Hack:
bugs_addbug
bugs_addbugnote
bugs_listbit
bugs_bugnote
bugs_details
bugs_list
BUGS

New DB tables for this Hack:
bugs
bugnotes
bugtypes
bugseverities
bugstates

This post was generated by the Hack Tracking Log

squawell · #22 02-05-2004, 04:20 AM

i got this error when i click add bug in admincp

Code:

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: SELECT userid,username FROM user WHERE usergroupid IN () ORDER BY username
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 ') ORDER BY username' at line 1

mysql error number: 1064

any idea thankz...

KuraFire · #23 02-05-2004, 07:58 AM

you can have fulltext searches in mysql 3

providing you know how to hack mysql and write that in yourself.

*sigh* ahwell, guess I can't use this then, and neither can EvB then...

PranK · #24 02-05-2004, 08:05 AM

awesome!

/me clicks install!

Thanks!

Andreas · #25 02-05-2004, 08:53 AM

@squawell

Lines 163 & 187 in bugsadmin.php

Change

PHP Code:


			
"WHERE usergroupid IN ($admingroups)"

Tp

PHP Code:


			
"WHERE usergroupid=$vboptions[bugadmingroup] OR $vboptions[bugadmingroup] IN (membergroupids)"

@KuraFire
Why not just upgrade mySQL?

I think this would be good anyway (=> Query Cache, reduced load on our server significantly).
You could also use this with mySQL 3 with some modifications:
- modify the definition for table bugs in the setup
- change bugs.php sql

StarBuG · #26 02-05-2004, 09:04 AM

Sorry but after i deleted the hack in the HTL menu and updated as you said I still get this mysql errer when i go to:

Bugs - Add

Code:

Invalid SQL: SELECT userid,username FROM user WHERE usergroupid IN () ORDER BY username
mysql error: You have an error in your SQL syntax near ') ORDER BY username' at line 1
 
mysql error number: 1064
 
Date: Thursday 05th of February 2004 12:02:53 PM
Script: http://www.hiphop-battles.com/forum/...min.php?do=add

I have one BIG question:
Where do I specify WICH FORUMS are the bug forums?????

It?s not in Options, it?s not in Manage Forums, it?s not an admin menu like you added 4 so where do I have to look?

Quote:

Originally Posted by KirbyDE

> But where do I say wich forums are my support forums
> I have 2 so I would need to specify 2 forums. Is this possible?
Hmm. Seems like I don't understand this question.
Which forums do you want to specify? And what for?

I have a multilanguage Project and I have a German Support Category with a Bug Forum in it and an English Support Category with also a Bug Forum in it.
First I need to know where to specify the Forums and I realy would need to have these 2 Forums both as bug Forums
if you wanna have a look http://www.hiphop-battles.com/forum/index.php

Quote:

Originally Posted by KirbyDE

@StarBug
> can there be more then one usergroup specified? I would need this!
No. May I ask why you would need more then 1 group?

I am Admin, from my developers some are Admin some are just Developers.
And I will have a support Crew in the future where I defenetly don?t want to give them admin rights or let them see our Developer Forums in full but I would like to have them decide what kind of bug it is, if they can help help users then change the status of the bug so I don?t have to do all the work alone.

Can?t be to hard to make it possible to define more then one usergroup and more then one bug forum!! PLEASE

Is this possible?

Greetings

Star

NTLDR · #27 02-05-2004, 09:16 AM

Quote:

Originally Posted by StarBuG

I have one BIG question:
Where do I specify WICH FORUMS are the bug forums?????

It?s not in Options, it?s not in Manage Forums, it?s not an admin menu like you added 4 so where do I have to look?

This has nothing to do with forums, it doesn't use them at all. Its a bug tracker just like the one at vB.com.

StarBuG · #28 02-05-2004, 09:24 AM

DOH

But I found another bug

I added a few Bug Types and wanted to remove one.
After clicking yes i got this:

Invalid SQL: DELETE FROM bugtypes WHERE typeid=
mysql error: You have an error in your SQL syntax near '' at line 1

The Type is still there!

Also when I go to by forum on bugs.php?do=add
Then I have a big button "Reset Fields" below my textbox but only a tinywiny submitbutton (I think it is submitt because you forgott the text for the button)

Greetings

Star

Andreas · #29 02-05-2004, 09:25 AM

Quote:

Originally Posted by StarBuG

Sorry but after i deleted the hack in the HTL menu and updated as you said I still get this mysql errer when i go to:

Bugs - Add

https://vborg.vbsupport.ru/showpost....1&postcount=24

Quote:

I have one BIG question:
Where do I specify WICH FORUMS are the bug forums?????

Nowhere, as this has nothing to do with forums - it's just a generic bug tracker that uses vB's database for user stuff and some vB-functions for the GUI.

Quote:

I am Admin, from my developers some are Admin some are just Developers.
And I will have a support Crew in the future where I defenetly don?t want to give them admin rights or let them see our Developer Forums in full but I would like to have them decide what kind of bug it is, if they can help help users then change the status of the bug so I don?t have to do all the work alone.

Well, you could just create a new usergroup that has no rights at all and put all your members you want to become bug admins in this group (as membership group)

Nevertheless i'll modify the code to allow several groups.
An updated ZIP will come later.

> Can?t be to hard to make it possible to define more then one usergroup
Yes. As stated above i'll do that.

> and more then one bug forum!! PLEASE

I'm sorry but this is not possible (I even don't understand what you want to achieve).

StarBuG · #30 02-05-2004, 09:34 AM

the forum thing was because i did not understand the idea completly now i do

But I have more bugs:

when I go to by forum on bugs.php?do=add
Then I have a big button "Reset Fields" below my textbox but only a tinywiny submitbutton (I think it is submitt because you forgott the text for the button)

If I click on Edit Bug I get an empty page just the navbar and your copyright text.

Add Bugnote is also not possible same as above

I added a few Bug Types and wanted to remove one.
After clicking yes i got this:

Invalid SQL: DELETE FROM bugtypes WHERE typeid=
mysql error: You have an error in your SQL syntax near '' at line 1

The Type is still there!

Greetings

Star

Andreas · #31 02-05-2004, 09:46 AM

Quote:

when I go to by forum on bugs.php?do=add
Then I have a big button "Reset Fields" below my textbox but only a tinywiny submitbutton (I think it is submitt because you forgott the text for the button)

There should definitly be a text ...
Take a look at template bugs_addbug:

Code:

<input type="submit" value="$vbphrase[submit]" name="submit" />

Varname "submit" belongs to phrasegroup GLOBAL and thus is available everywhere ...

> If I click on Edit Bug I get an empty page just the navbar and your copyright text.
> Add Bugnote is also not possible same as above
Hmm. Not reproducable here.
Do you have Template Names as comments in HTML turned on?
If so would it be possible to check if the template bugs_addbug or bugs_adbugnote actually get's called?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05208 seconds Memory Usage 2,329KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_code (2)bbcode_php (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!