Miscellaneous Hacks - [DBTech] Random Questions v2 (vB3)

Random Questions: What is it?

DragonByte Technologies is proud to present version 1.0 of [DBTech] Random Questions.


The Random Questions mod is intended to increase activity in your forum, attract back old members, and encourage members to form friendships (and thus stay).

It accomplishes this by allowing/encouraging users to answer random questions about each other. The questions are settable by the admin (5 included in the Lite XML as an example). The questions can be anything from ?What do you think {usernames} favourite game is?? to ?Do you think {username} Wants a pet dinosaur??. These questions usually serve to bring random people closer together, and have people communicate with each other who otherwise might not have. It's a great way to inspire closer bonds in your community (And, of course, having friends is one of the big reason people stay on forums).

-------------------------------------------------------------------------------------------

If you like this mod please hit the button to the right ---->

Please remember to click the, button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
--------------------------------------------------------------------------------------------

[b]Priority support & Product Demos available at: http://www.dragonbyte-tech.com/forum.php

-------------------------------------------------------------------------------------------

Translations available @ [url="http://www.dragonbyte-tech.com/forums/91-Translations[/URL]
Support for translations handled by the translator in its respective threads only.

-------------------------------------------------------------------------------------------

Lite Feature List:

v2.0 Features:

Answer Rating: You can rate the answers people have given you via your own profile. Let people know what you think of their answers!


v1.1 Features:

Random Questions: This lets users click on a tab to start answering random questions about other members, anything from should they post more, to what animal would they be. The questions load in realtime AJAX, and after submitting an answer, a new question will fade in.

Notifications: Users are notified whenever a new answer is submitted about them, letting them keep up to date on what people are saying about them!

Profile ?Answers? Tab: Adds a new tab to the profile letting you keep track of what answers have been made about you.

Permissions: Set who can use the mod, exactly what answers they can see and what options are available to them.

Question Manager: Allows admins to add, edit or delete questions to be asked. You can add an Unlimited number of questions in here


Extra Pro Features:

Extra Privacy Options: Set whether your answer is public or private, per answer. This lets you answer a question about someone without the rest of the forum seeing what you said.

Specify who to answer about: This lets you choose who you want to answer questions about ? Everyone, Friends, Online users or even specify a particular person!

User Options: A variety of extra options for users, allowing them to submit questions for consideration, toggle the notification on new answers and more.

Requests: Lets users send PMs requesting specific other users answer questions about them

User Limitations: Require X posts to have questions answered about that member, require X answers to see answers about oneself.


Feature List: Lite
Front-End

• Answer Questions Page
  • Ajax submitting/reloading of questions
  • Log statistics about each answer
  • Send notification for new answers

• Profiles
  • Answers Tab
  • Answer Ratings

AdminCP

• vBulletin Options
  • Global enable/disable
  • Turn statistic tracking on/off
  • Turn request PM's on/off
  • Turn review questions on/off

• Usergroup Permissions
  • Can view own answers
  • Can view all answers
  • Can view private answers
  • Can specify own questions
  • Can submit questions for review
  • Can send request PM

• Edit User
  • Is user banned from viewing/answering questions

• Question Manager
  • Add/Edit/Delete questions
  • View/Approve pending questions for review

Feature List: Pro
Front-End

• Answer Questions Page
  • Set answer as public/private
  • Specify if answering for - random users/specified user/friends/users online
  • Require x posts to be included
  • Require X answers to read answers

• Options
  • Specify own questions page
  • Toggle notification on new answers
  • Define usernames to answer questions about
  • Submit questions for review page

• Profiles
  • Send request PM asking for question to be asked about yourself

• Misc
  • Random Answer Widget/Bar

[deadlySniper]

Ok sorry the wrong post in the other area

I am getting this error when trying to edit my options in the UserCP

Fatal error:  Class 'vB_Template' not found in /home/****/public_html/ventrilox.com/forums/dbtech/random_questions/hooks/profile_editoptions.php  on line 3

[DragonByte Tech]

Try re-downloading aand re-uploading, I believe I fixed it


Fillip

[matthewhotdude]

Now you dont have the option to invite people to ask questions about you

[DragonByte Tech]

It was never intended to be a Lite feature and the link was included by mistake


Fillip

[matthewhotdude]

Oh you tease

[matthewhotdude]

Disable Random Question NotificationsDo you want to recieve a new notification when somebody has answered a random question about you.
Yes
No

That option in USERCP is there anyway to set the default to yes for all users?

[matthewhotdude]

Whats the submit button for?

[DragonByte Tech]

Submitting ratings, clicking it will have no effect when you've already rated all your answers.

Fillip

[FleXy]

Hello, after clean install (not update) on members.php I see this error:

Database error in vBulletin 3.8.5:

Invalid SQL:

SELECT a.*, q.*, u.username, u.userid FROM vb_dbt_random_questions_answers AS a
LEFT JOIN vb_dbt_random_questions AS q USING (qid)
INNER JOIN vb_user AS u USING(userid)
WHERE a.touserid = 6201 AND
(private = 0 OR userid = 1 OR touserid = 1)
ORDER BY a.dateline DESC
LIMIT 0, 30;

MySQL Error : Column 'userid' in where clause is ambiguous

How to fix or what to do to make it work? thanks!

[DragonByte Tech]

Originally Posted by FleXy

Hello, after clean install (not update) on members.php I see this error:

Database error in vBulletin 3.8.5:

Invalid SQL:

SELECT a.*, q.*, u.username, u.userid FROM vb_dbt_random_questions_answers AS a
LEFT JOIN vb_dbt_random_questions AS q USING (qid)
INNER JOIN vb_user AS u USING(userid)
WHERE a.touserid = 6201 AND
(private = 0 OR userid = 1 OR touserid = 1)
ORDER BY a.dateline DESC
LIMIT 0, 30;

MySQL Error : Column 'userid' in where clause is ambiguous


How to fix or what to do to make it work? thanks!

Hey,

I'll have this fixed for you soon.

- David