vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   vBQuiz 1.0 (https://vborg.vbsupport.ru/showthread.php?t=39719)

Mickie D 01-26-2003 03:47 PM

hi i get this error anyone help me ???

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT quizid, quiztitle, description, timestamp, userid, catid, imagename
FROM quiz
WHERE approve = 1
ORDER BY timestamp DESC
LIMIT
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Sunday 26th of January 2003 12:40:14 PM
Script: http://www.world-of-digital.com/forums/forums/quiz.php
Referer:



thanks in advance for any help given :)

geniuscrew 01-29-2003 02:24 PM

Everyone thinks it will work just like that lol

As stated previously, you must go to Admin CP >> Vbulletin Options >> Quizzes >> Save Changes

to get rid of the error ;)

Intex 02-01-2003 02:18 PM

Installed this great hack. But have one problem that I don't really see answered in the threads. The problem is regarding the image that goes with the quizzes.

I created a directory named quizzes in my /images directory, i.e. /images/quizzes. But when submitting a new quiz with an image, it accepts it no problems, but doesn't show. I've seen other mention this here but with no answers. Its defniitely not permissions on my server as it has full access. It certainly hasn't uploaded it to the relvevant directory.

I even wondered if it might be due to restrictions on the forum main options regarding image width, size and type, but it isn't that either.

I also looked at the source on the quiz page for that quiz and I didn't see any reference to the graphic.

Any ideas ?

P.S. Do you have a release date for v2 ?

LilTara 02-01-2003 04:01 PM

I just installed on 2.2.9 with no problems whatsoever :) Great hack! :D

ChurchMedia 02-03-2003 03:33 AM

Quote:

Originally posted by xxxsaint
if someone could figure out how to integrate this to award 10 points per correct answer into lesane's store it would be really really really really really really nice :P
Here's how you do it!

In quiz.php, find (around line 650):

PHP Code:

 $date    vbdate($dateformattime());
    
$line    str_repeat('-'40);
    
$message result_switch($totalcorrect$question_count); 

Add AFTER:

PHP Code:

    $addpoints $totalcorrect*10;
    
$DB_site->query("UPDATE user SET storep=storep+$addpoints WHERE userid='$userinfo[userid]'"); 

You can change the 10 to however many points you want...

In the email_quizresults template you can add:

Code:

You earned $addpoints points!
That's it!

Molok 02-03-2003 08:33 AM

My problem that i have a german Board. All Templates are only in my default style and not in my german Sie style.

Is there a possibility to move fast the quiz templates in my german style ?

pcoskat 02-03-2003 10:35 PM

What a lovely hack!!!

Question: when uploading an image to the quiz, is it possible to add a hyperlink to the image? (ie: I'd like to base my quizes on specific books, and have the image be 'of' the book, with that image linked to amazon.com - possible?)

kat

ChurchMedia 02-04-2003 02:10 AM

TWTCommish,

I wrote a hack allowing an admin to add a longer answer or explanation to a question. The explanation is then shown on the results page. The zip file containes the altered quiz.php and admin_quiz.php files and new contents for the quiz_resultbit template.

Before I post this to the hacks section, I wanted to make sure it hasn't been done already -- and wanted to know what you think about it.

Here are some screenshots:

Add A Question
Edit A Question
Results Page

If I'm not repeating someone else's work and everything looks good, let me know. Thanks! :)

Molok 02-04-2003 06:07 AM

Is it possible that Registred User can send a quiz and the admin can only approve the quiz ?

ethics 02-04-2003 10:47 AM

ChurchMedia is on fire!

Thank you, I've had (politics forum) plenty of quizzes where I wished I could explain after the answer was given. ;)


All times are GMT. The time now is 04:08 AM.

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.01786 seconds
  • Memory Usage 1,746KB
  • 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
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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