OK one more problem.
It's this chunk of code;
PHP Code:
$done = $mysidia->db->select("solved_riddles", array("name", "uid"), "name = '{$active}'", "uid = '$mysidia->user->uid'")->fetchColumn();
if($done){...}
else{...}
It is not doing what it is supposed to do. It is showing me the if{} content regardless of whether the uid+name are added to the table or not. The code simply adds a new row whenever someone solves a riddle, it records the riddle name and the user ID. This part is fully functioning.
The if{} statement is supposed to make it so that users who have solved see the if{} content, and users who have not see the else{} content.
If someone could point out my error here I'd be mighty thankful...and then I could run through some more tests and release the damn thing as a mod