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

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 available at: http://www.dragonbyte-tech.com/forum.php

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

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

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

This mod displays a copyright notification in the footer of pages generated by this mod which includes:

• 1 Link to DragonByte Technologies homepage
• 1 Link to Product Description page of this modification

[CRDeveloper]

Im getting this database error at members profiles.
not working

Database error in vBulletin 4.0.5:

Invalid SQL:

                SELECT a.*, q.*, u.username, u.userid FROM vbulletin_dbt_random_questions_answers AS a
                LEFT JOIN vbulletin_dbt_random_questions AS q USING (qid)
                INNER JOIN vbulletin_user AS u USING(userid)
                WHERE a.touserid = 7261 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
Error Number  : 1052
Request Date  : Saturday, August 7th 2010 @ 01:43:33 AM
Error Date    : Saturday, August 7th 2010 @ 01:43:33 AM
Script        : http://www.toxxxicas.com/foro/member.php/7261-GUCCI
Referrer      : http://www.toxxxicas.com/foro/member.php/7261-GUCCI
IP Address    : ##.##.##.##
Username      : ToxXxicas.com
Classname     : vB_Database
MySQL Version : 4.1.22-standard

[DragonByte Tech]

Originally Posted by ToxXxicas

Im getting this database error at members profiles.
not working

Database error in vBulletin 4.0.5:

Invalid SQL:

                SELECT a.*, q.*, u.username, u.userid FROM vbulletin_dbt_random_questions_answers AS a
                LEFT JOIN vbulletin_dbt_random_questions AS q USING (qid)
                INNER JOIN vbulletin_user AS u USING(userid)
                WHERE a.touserid = 7261 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
Error Number  : 1052
Request Date  : Saturday, August 7th 2010 @ 01:43:33 AM
Error Date    : Saturday, August 7th 2010 @ 01:43:33 AM
Script        : http://www.toxxxicas.com/foro/member.php/7261-GUCCI
Referrer      : http://www.toxxxicas.com/foro/member.php/7261-GUCCI
IP Address    : ##.##.##.##
Username      : ToxXxicas.com
Classname     : vB_Database
MySQL Version : 4.1.22-standard

Sorry about that, re-download the files and give it a try now.

- David

[thecelticway]

Forum NOT working~~~~~~ HELP!!!!!!!

Warning: require_once([path]/dbtech/random_questions/hooks/cache_templates.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/class_bootstrap.php(1269) : eval()'d code on line 188

Fatal error: require_once() [function.require]: Failed opening required '/home/celticway/thecelticway.net/forum/dbtech/random_questions/hooks/cache_templates.php' (include_path='.:/usr/local/lib/php:/usr/local/php5/lib/pear') in /home/celticway/thecelticway.net/forum/includes/class_bootstrap.php(1269) : eval()'d code on line 188

[Gemma]

Not working for me either. Pressing submit does nothing. The skip button works though.

[thecelticway]

thanks for the help in getting this uploaded and fixed..... appears to be working ok but how do you configure it.... is it dependent on usergroups

[bada_bing]

I have installed the lite version and so far it looks pretty cool I do however have a few questions as I am interested in the pro version.

I would like to make this feature more visible for my members maybe you have add a feature in the admincp where we can set the random questions in various location such as postbit
near there member name so a member can just click and answer a question about this member.

I would also like to see a vbadvanced module to for this mod.

[bada_bing]

I also just noticed that when I choose random member and answer a question and click Submit it does nothing, but the skip question seems to work.

Also noticed that if I view my own profile and click "Request This User To Answer Questions About You. " and click Submit I get this error message "Invalid Action Specified."

Personally I think this is a glitch, you should not be able to go to your own profile and have this feature "Request This User To Answer Questions About You." doesnt make much sence

[DragonByte Tech]

Originally Posted by thecelticway

Forum NOT working~~~~~~ HELP!!!!!!!


Warning: require_once([path]/dbtech/random_questions/hooks/cache_templates.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/class_bootstrap.php(1269) : eval()'d code on line 188

Fatal error: require_once() [function.require]: Failed opening required '/home/celticway/thecelticway.net/forum/dbtech/random_questions/hooks/cache_templates.php' (include_path='.:/usr/local/lib/php:/usr/local/php5/lib/pear') in /home/celticway/thecelticway.net/forum/includes/class_bootstrap.php(1269) : eval()'d code on line 188

This means that you do not have all the files uploaded either at all or you have them in the wrong place. Please check you have all of them uploaded.

Originally Posted by Gemma

Not working for me either. Pressing submit does nothing. The skip button works though.

Could you PM a test account for your site?

Originally Posted by thecelticway

thanks for the help in getting this uploaded and fixed..... appears to be working ok but how do you configure it.... is it dependent on usergroups

Yes, go to edit a usergroup and you will see a few options.

Originally Posted by bada_bing

I have installed the lite version and so far it looks pretty cool I do however have a few questions as I am interested in the pro version.

I would like to make this feature more visible for my members maybe you have add a feature in the admincp where we can set the random questions in various location such as postbit
near there member name so a member can just click and answer a question about this member.

I would also like to see a vbadvanced module to for this mod.

That is interesting. I could look at something like this in a future version.

Originally Posted by bada_bing

I also just noticed that when I choose random member and answer a question and click Submit it does nothing, but the skip question seems to work.

Also noticed that if I view my own profile and click "Request This User To Answer Questions About You. " and click Submit I get this error message "Invalid Action Specified."

Personally I think this is a glitch, you should not be able to go to your own profile and have this feature "Request This User To Answer Questions About You." doesnt make much sence

The request feature was just something I forgot to take out. I'll release a fixed version soon.

Also for the bug you have, I will look into this right away.

- David

[thecelticway]

Originally Posted by thecelticway View Post

thanks for the help in getting this uploaded and fixed..... appears to be working ok but how do you configure it.... is it dependent on usergroups

Yes, go to edit a usergroup and you will see a few options.


checked the boxes~~~~~~when in a members profile I make the request I get......


vBulletin Message
Invalid Action Specified.

[betts02]

I have purchased the pro version and posted 2 questions on your site,Could you please look them up mate and try to give an answer, cheers