Archive for myfreeforum.org Before posting please check the "stickies" in the support forums.
Please ask questions in real English and not "txt". You will get a better response.
Please do not ask support questions via PMs.
 



       myfreeforum.org Forum Index -> What's new? Announcements!
admin (no pm's please)

PhpBB2/phpbb3 DATE added to quiz portal score table.

Code:

{quiz_scores.DATE}


now shows date the user took the quiz.
P Shivers

I take it this is not retroactive?
admin (no pm's please)

It should be, the date was always stored.
P Shivers

Sorry to be a pest, but I have tried this and it's not showing. I added it to cms_quiz.tpl in my template
Code:
<!-- BEGIN quiz_scores -->
<td>{quiz_scores.USERNAME}</td><td>{quiz_scores.SCORE}</td><td>{quiz_score.DATE}</td></tr>
  <!-- END quiz_scores -->

Even tried to change the code to match the other functions like this:
Code:
<!-- BEGIN quiz_scores -->
<td>{quiz_scores.USERNAME}</td><td>{quiz_scores.SCORE}</td><td>{quiz_scores.DATE}</td></tr>
  <!-- END quiz_scores -->

Here is the page link I am using
http://arachnophiles.myfreeforum.org/contestquiz.html
admin (no pm's please)

It is quizcores.DATE

and my apologies I thought the date was being stored, it isn't yet. I will add it now.
P Shivers

Now I am getting this on all templates. I only edited theme 4 with the new function, but I get this error on all templates.
Code:
General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '25,100, NOW())' at line 2 [1064]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: pshivers@arachnophiles.com

admin (no pm's please)

try now.
P Shivers

No go. Even cleared the cash and tried on a different template.
admin (no pm's please)

It is not a template issue.

Is the error still exactly the same?
admin (no pm's please)

I think I see the issue, try now.
P Shivers

Working now. Thanks.

If it were a different message, I would have posted it. Sorry for the confusion.
admin (no pm's please)

P Shivers wrote:
Working now. Thanks.

If it were a different message, I would have posted it. Sorry for the confusion.


People as a rule don't though.. my fault I tested on phpbb2 and thought this was an slice of code where the phpbb3 coding was compatible, it was not.
P Shivers

admin (no pm's please) wrote:
my fault I tested on phpbb2 and thought this was an slice of code where the phpbb3 coding was compatible, it was not.
It is not usually compatable is it. LOL That is the whole issue you seem to be battling with these days. Tug of war with you in the middle holding the ropes.
My job is hard enough, I surely don't want yours.

Thanks again for all your awesome assistance.

       myfreeforum.org Forum Index -> What's new? Announcements!
Page 1 of 1
Create your own free forum | Buy a domain to use with your forum