Quizzer 1 1.0.01 Beta (for testing only) - Posted (5198 Views)
cripto9t
Average Member
cripto9t
Posts: 881
881
Quizzer1 1.0.01 Beta for testing only.
Download - Right Click and Save
Tested on Snitz 3.4.6 with a mySql db.
Snitz users are needed to download and test my quiz mod for snitz. It's an add-on, meaning there are very few changes to the original forum code. It is also a very easy install, just a few new files to add to your forum folder and a database update to add the quiz tables.
I would like to get the existing features tested and working properly before I try to add anymore. I will try to update the zip once a week until a final release is reached.
Feedback, suggestions and constructive criticism are welcome.
I'll post Updates Here

Updates
  • 2/4/07 - 1.0.0 Beta (Initial Release)
  • 2/5/07 - 1.0.01 Beta (Update for my friends with access)
Notes
  • This version of the quiz Quizzer 1 does not and will not record members score. That will be for Quizzer 2.
  • There is no test forum

Quiz Description
  • Features
    • Admin on/off switch
    • Unlimited questions and choices with admin control
    • Multiple choice and true/false quiz options
    • Admins and/or Moderators write quizzes (admin control)
    • "Members only" or "all vistors" option with Admin control

    • Retake time limits with Admin control (uses cookies)

    • Random questions with Admin control

    • Option to show corrected answers after grading

    • Records number of entries, hi-score, average score and last date taken for each quiz

    • Active Quiz Page

    • Use forum code in questions and answers

    • "Save quiz as draft" option
    • Quiz Archive
    • A very primitive attempt at question templates


  • Wish List

    • Topic Quizzes
    • Member Input Questions

    • Essay Questions
    • Quiz Categories

    • Real Question Templates

    • Question Paging

    • Printer Friendly


<
    _-/Cripto9t\-_
Last edited by cripto9t on 05 February 2007, 17:14
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
runsh
Starting Member
runsh
Posts: 34
34
Thanks for the mod. I installed the mod but have problem making quizes active. on admin I turned quizes on several time but it resets to off.
I use access db. I use 3.4.06 version. any idea why
<
Posted
cripto9t
Average Member
cripto9t
Posts: 881
881
Did you make the changes from the read-me in "config.asp"?<
    _-/Cripto9t\-_
Posted
runsh
Starting Member
runsh
Posts: 34
34
yes I did. I'll try with fresh copy of snitz again.<
Posted
runsh
Starting Member
runsh
Posts: 34
34
I installed a new copy of forum and added the mod. now it truns quiz on but when try to access active quizzes I get this error:
Microsoft JET Database Engine error '80040e14'

Join expression not supported.

/froumq/quiz_active.asp, line 72
<
Posted
cripto9t
Average Member
cripto9t
Posts: 881
881
Also I forgot to ask , did you install the table in admin options>mod setup? If you did look in admin options >forum variables and look for the quiz variables in the list. They start with "STRQUIZ" and make sure they are listed. If not try running the Database update again.
I might not be around for the rest of the night. The Super Bowl is about to start.
GO COLTS!!!!!!!!!!<
    _-/Cripto9t\-_
Posted
runsh
Starting Member
runsh
Posts: 34
34
yes setup is fine, is listed in variable. I think there is a problem with generated tables in db, look at this image from generated db table!!

<
Posted
runsh
Starting Member
runsh
Posts: 34
34
Microsoft JET Database Engine error '80040e14'

Join expression not supported.

/froumq/quiz.asp, line 81
<
Posted
runsh
Starting Member
runsh
Posts: 34
34
is probably something related to access db . I google it and found similar problem but don't know how to fix it.

http://www.thescripts.com/forum/thread189027.html

http://www.experts-exchange.com/Databases/MS_Access/Q_21239773.html<
Posted
cripto9t
Average Member
cripto9t
Posts: 881
881
runsh, in "quiz_active.asp" replace this code
Code:
strSql = "SELECT QUIZ_ID, Q_AUTHOR, Q_TITLE, Q_DATE, Q_STATUS, Q_TYPE, Q_QUESTIONS, Q_ENTRIES, Q_HISCORE, Q_ACED, Q_AVERAGE, Q_LAST_QUIZ, Q_RETAKE, Q_ANON, Q_RANDOM, Q_RANDOM_QUESTIONS, M_NAME, Q_DESCRIPTION" & _
         " FROM " & strTablePrefix & "QUIZ" & _
         " LEFT JOIN " & strTablePrefix & "MEMBERS" & _
         " ON Q_AUTHOR = MEMBER_ID" & _
         " WHERE Q_STATUS = " & PageView
if PageView = 0 then strSql = strSql & " AND Q_AUTHOR = " & MemberID 
strSql = strSql & " ORDER BY QUIZ_ID DESC;"
With this
Code:
strSql = "SELECT QUIZ_ID, Q_AUTHOR, Q_TITLE, Q_DATE, Q_STATUS, Q_TYPE, Q_QUESTIONS, Q_ENTRIES, Q_HISCORE, Q_ACED, Q_AVERAGE, Q_LAST_QUIZ, Q_RETAKE, Q_ANON, Q_RANDOM, Q_RANDOM_QUESTIONS, M_NAME, Q_DESCRIPTION" & _
         " FROM " & strTablePrefix & "QUIZ, " & strMemberTablePrefix & "MEMBERS" & _
         " WHERE Q_STATUS = " & PageView & " AND Q_AUTHOR = MEMBER_ID"
if PageView = 0 then strSql = strSql & " AND Q_AUTHOR = " & MemberID 
strSql = strSql & " ORDER BY QUIZ_ID DESC;"
Let me know if it works. I want this to work all around.<
    _-/Cripto9t\-_
Posted
cripto9t
Average Member
cripto9t
Posts: 881
881
I have no way to test with access. Does anyone with access knowledge see why the first query above would get that error?
strTablePrefix should be strMemberTablePrefix - That might be the problem if the prefix was changed in config.asp.<
    _-/Cripto9t\-_
You Must enter a message