Integrate LeSane's Store with Trivia

[Lesane]

Like i said, i don't have the hack installed so i cannot test it.

[xxxsaint]

That one gives this :
Parse error: parse error, unexpected T_STRING in quiz.php on line 319

[xxxsaint]

bump

[xxxsaint]

ok well this latest code that lesane tried to help me with gives me this error :

Parse error: parse error in /****/****/****/****/forums/quiz.php on line 320

and my line 320 is this :

$current_time = vbdate($timeformat, time());


any ideas , help , suggestions would be greatly apprecieated.

[xxxsaint]

Hey Hey , I think I am getting closer here , after reading thru some of the php help files , I noticed that Lesane left out a " in his code line ,

$updatestore = $DB_site->query_first("UPDATE user SET storep=storep+'$storeamount' WHERE userid='$bbuserinfo[userid]');

so I inserted it

$updatestore = $DB_site->query_first("UPDATE user SET storep=storep+'$storeamount' WHERE userid='$bbuserinfo[userid]'");

and it did award points in a quiz i did for a test , but now it gave me this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /****/****/****/****/forums/admin/db_mysql.php on line 154

which when I look that up comes from this block of code :

function fetch_array($query_id=-1,$query_string="") {
// retrieve row
if ($query_id!=-1) {
$this->query_id=$query_id;
}
if ( isset($this->query_id) ) {
$this->record = mysql_fetch_array($this->query_id);
} else {
if ( !empty($query_string) ) {
$this->halt("Invalid query id (".$this->query_id.") on this query: $query_string");
} else {
$this->halt("Invalid query id ".$this->query_id." specified");
}
}

return $this->record;
}

and line 154 is this line right here :

$this->record = mysql_fetch_array($this->query_id);

Any help will be extremely apprecieated.

[Lesane]

Try this line:

PHP Code:

$updatestore = $DB_site->query("UPDATE user SET storep=storep+'$storeamount' WHERE userid='$bbuserinfo[userid]'"); 


[xxxsaint]

WHOOOOO HOOOOOOo !!!!!!!!



THAT'S IT !

TY TY TY TY TY TY TY TY so very much man, you just don't know how much time i was spending manually going in there and awarding points , I really apprecieate your help

[xxxsaint]

I've seen others asking for this hack so you might wanna release it

[xxxsaint]

Now that the code is working and paying 10 points for every correct answer , is there a way to reward those that get 100% on their quiz and give them 1000 points instead of 100 ?

[Lesane]

I'm glad it's working properly now.

I have it way too busy to release a hack, you have my permission to use the code and release it as an addon if you want.

If you want to give them 1000 points instead of 100 then find this line in quiz.php:

PHP Code:

$storeamount = 10 * $totalcorrect; 


And change it to:

PHP Code:

$storeamount = 100 * $totalcorrect;