I get the same error as WheelzChair....


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 27th of April 2003 04:53:57 AM
Script: http://attack.elementznet.com/quiz.php
Referer:

Hi

I have a problem with me cannot one the question not see, what
that lies?

Does someone have a solution for it?

http://www.dede1.de/Board/quiz.php?quizid=1&taking=1

Does this work with 2.3.0 ?

yes, perfectly

Does it?!?!

Awesome!

/me licks install!!

Any chances to add a ALL TIME BEST PLAYERS at quiz's home?

Hey!

I need help too!

I added 2 quizzes with no images, then a third with an image, now the three quizzes have the same image?!?!?!

How come?

Btw @ movieforums.com... Movie quizzes show 10 but only 9 displayed... another bug?

I had problems with the blank page loads, I had to add the ID and then I have seen no major bugs. Thank you again.

Not wanting to go through all 52 pages of this post, I went and fixed the admin CP slightly. If this is a double fix / post I apologize.

Anyways, What I did is make it so that the templates are listed under not your custom templates, but under the default templates under it's own collaspable category there. It also makes it so that ALL of your styles see the templates, and not just your default style so you don't have to worry about doing the manual additions.

Anyways, Ready?

Here we go:

1) Find the following bit of code in your admin/template.php:

Directly below that add the following code:

2) Save and upload file.

3) using phpmyadmin or another similar manager for your mysql database run the following query (this simply changes the template id to '-1' so that it becomes part of the default templates.)

(this should update ~46 templates.)

That's it, just reload your Admin CP and then view the templates. (The email and error templates for vBQuiz are under the 'email' and 'error' template categories ;))

This was done on 2.3.0, but should work for any 2.X version.

Superb! Thnks!

no problem, I was just surprised that I couldn't find anyone else who did this already ;)

What about vB3.0? Any reason why it shouldn't?

i goit MYSQL error.. i installed everything.. created a categorie..than created an quiz and some questions..but when i wanna cvall this site:
http://spielplanet2.de/forum/quiz.php

you will see i get an error :(
whats wrong.. i dindnt touch the code of the quiz php..all tables semms to be in right place..and the install script created everything needed..but..it wont work..why?

greets

now i got an BLANK page.. what i did wrong here?

ok..it works.. it added all templates only to one TEMPLATE PACK..and not to all styles i got.. so i added now manually to the TEMPLATES all the quiz templatees..and it WORKS fine now :).. very nice.. i like it and i searched long time for something like this.. kewl.. very kool.. ..hellyeahh i like it :)

Help!

I need support!

All of a sudden, ONLY THE TOP SCORES views stopped working, both the high and the all time scores...

ONLY those links are not working.

All it loads is an empty HTML page:

I doublechecked the tables, which seem fine.

I replaced the translated quiz.php with the original quiz.php

I checked carefully the templates but they all look fine (I just translated them and saw them WORKING for at least one month!)


Now I get nothing only on the popup contents!

Any explanation?

Can any1 help me finding out the source of the problem?


Thanks!

Have you checked your require('./global.php'); statement, and made sure that with that specific line that your file is located in the $ROOT/forum/ directory? If the file is in another directory, you'll need to do some finageling.

anytime you get a blank page, then you are either not calling $ROOT/forum/global.php properly, or your eval'd templates are screwing up. Typically it is due to $ROOT/forum/global.php not being called right.

I installed the hack and added a quiz and all I get when I go to the quiz.php file is a blank page. Install was a success. Any hints on what could be wrong.

Thanks

Did u approve the quiz ?

Is there a way to hide the scores from all but admins?
I want to use this in a corporate environment, but we will
have legal problems if people's scores are generally available.

One way around it would be to allow multiple test results, but have the latest REPLACE the old score. This way, if they do poorly and don't retake the quiz, it's their own problem. If they do finally get a mastery level score, that is all that will be captured.

TWTCommish,

Can you help? Will this move to vB 3.0 with any hitches?

Your help will be greatly appreciated.

i just installed the quiz, its very nice :)

however, i do have a small problem. I added a quiz, questions, approved it....etc

but when i go to site.com/forums/quiz.php and click on the quiz, then click on the Take Quiz link, i get this error:

Error: invalid quiz specified.

Back to Main Quiz Page

any ideas of what could be wrong?

NOTHING will move to 3.0 without any hitches. The code is being more or less rewritten. Damn near every hack here will have to be rewritten as well...especially larger hacks such as this one.

I am getting some javascript errors that are popping up 1 per each quiz on the quiz listing page has anybody else experienced this?

In Vbulletin Options I see Quiz Options 4 times.... How can I fix this :(

Also I am getting this on http://sanguinox.com/quiz.php

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

But It let me add cat's and a quiz from admin no trouble.

What template needs to be fixed in order to fix this page:

http://www.futurelooks.com/forums/quiz.php?catid=1

to insanctus , go to vb admin cp > Options > Press submit changes

Splitfyre, can u create a test acc...

Here's the screenshot. What template do I need to modify to ensure that this lines up correctly?

change this template ( add align=center in table open tag)

quiz_category_nav

sorry?

n e 1?

change to this.

Is there anyway to allow my members to post their own quizes? I've seen it at a board, but I don't know how they did it. ;_;

Great Hack dude I also would like to know what Hypey said as that would be sweet thanks for the hack man

hi have installed this hack and its just what I was looking for thx man:D

1 thing I would like to have these 2 entries in members profiles I managed the template changes to add those under the location in members profiles but what db queries or file changes could I do to add the amounts

Quizz Entered:
Quizz Won:

thx for any help

ich habe auf dem brainstorm24.com board eine art ad-on gesehen...


wie bekomme ich es also hin das, wenn ich das quiz starte dieser hinweis dann kommt: (bereits gespielt)

und die anzahl der fagen siehe bild ......

http://www.century-community.de/privat/paridus/quiz.jpg

Um i installed and eveyrthing but nothing shows up when i go to quiz.php =/ just a blank. What could be wrong?

edit: bah forget that lol i found out what happend. But another problem was that i submit the questions but they get deleted.

this is a very cool hack thx :)

any plans on having a system so a member can submit a quiz for approval by admin?, I think that kind of feature would be hugely popular.

Does this quiz allow pictures in the questions? I use a PHP based script to do this but I would like a VB based one. I use it for Vehicle ID questions which require a picture and then possible answers etc.

I would be willing to pay someone to modify this to make it work like mine,

Thanks again,

-Jason

http://www.trackpads.com/quiz