Pagina 1 van 1
debug mode - quiz hack.
Geplaatst: 16 nov 2005, 11:18
door gies
na installatie van de quiz hack, krijg ik deze error:
Code: Selecteer alles
Error in posting
DEBUG MODE
SQL Error : 1064 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 '// ADDED , topic_quiz AND , 1 BY Quiz Hack topic_time, forum_i
INSERT INTO phpbb2_topics (topic_title, topic_poster,// ADDED , topic_quiz AND , 1 BY Quiz Hack topic_time, forum_id, topic_status, topic_type, topic_vote, topic_quiz) VALUES ('Quiz question #1 ...', 2, 1132135283, 1, 0, 0, 0, 1 )
Line : 391
File : functions_post.php
dit is de link naar mijn functions_post.
Weet iemand wat ik fout heb gedaan ???
Geplaatst: 16 nov 2005, 11:23
door Paul
Je hebt de instructies niet goed uitgeveord.
Geplaatst: 16 nov 2005, 11:28
door gies
Als er dit staat:
Code: Selecteer alles
#
#-----[ FIND ]------------------------------------------
#
$sql = ($mode != "editpost") ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster,
#
#-----[ IN-LINE, FIND ]------------------------------------------
#
topic_type, topic_vote
#
#-----[ IN-LINE, AFTER, ADD ]------------------------------------------
#
, topic_quiz
#
#-----[ IN-LINE, FIND ]------------------------------------------
#
$topic_type, $topic_vote
#
#-----[ IN-LINE, AFTER, ADD ]------------------------------------------
#
, " . ( empty($post_data['topic_quiz']) ? '0' : '1' ) . "
#
#-----[ AFTER, ADD ]------------------------------------------
#
// ADDED , topic_quiz AND , " . ( empty($post_data['topic_quiz']) ? '0' : '1' ) . " BY Quiz Hack
waar komt "// ADDED , topic_quiz AND , " . ( empty($post_data['topic_quiz']) ? '0' : '1' ) . " BY Quiz Hack" dan achter te staan ????
Geplaatst: 16 nov 2005, 11:30
door Paul
Dat komt dan op de eerstevolgende regel te staan, na die regel
Geplaatst: 16 nov 2005, 11:33
door gies
dus dan krijg je:
Code: Selecteer alles
$sql = ($mode != "editpost") ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote, topic_quiz) VALUES ('$post_subject', " . $userdata['user_id'] . ", $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $topic_vote, " . ( empty($post_data['topic_quiz']) ? '0' : '1' ) . "
// ADDED , topic_quiz AND , " . ( empty($post_data['topic_quiz']) ? '0' : '1' ) . " BY Quiz Hack
)" : "UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject', topic_type = $topic_type " . (($post_data['edit_vote'] || !empty($poll_title)) ? ", topic_vote = " . $topic_vote : "") . " WHERE topic_id = $topic_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
}
Ik heb het warschijnlijk overal fout gedaan, dus kan het niet snel uittesten vandaar dat ik het vraag.
?????
Geplaatst: 16 nov 2005, 11:51
door Paul
Nee, eerstvolgende regel, na dat script statment, dus na ;. (In dit geval na:
)
Geplaatst: 16 nov 2005, 12:04
door gies
nu krijg ik:
Code: Selecteer alles
Fatal error: Call to a member function on a non-object in /public_html/phpBB2/includes/functions_post.php on line 491
wat is dat nu weer ???
Geplaatst: 16 nov 2005, 12:06
door Paul
Geef eens 5 regels erboven en onder?
Geplaatst: 16 nov 2005, 12:09
door gies
regel 480 t/m 500:
Code: Selecteer alles
if ($delete_option_sql != '')
{
$sql = "DELETE FROM " . VOTE_RESULTS_TABLE . "
WHERE vote_option_id IN ($delete_option_sql)
AND vote_id = $poll_id";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error deleting pruned poll options', '', __LINE__, __FILE__, $sql);
}
}
}
$cash_message = $GLOBALS['cm_posting']->update_post($mode, $post_data, $forum_id, $topic_id, $post_id, $topic_type, $bbcode_uid, $post_username, $post_message);
$meta = '<meta http-equiv="refresh" content="3;url=' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . "=" . $post_id) . '#' . $post_id . '">';
$message = $lang['Stored'] . '<br />' . $cash_message . '<br /><br />' . sprintf($lang['Click_view_message'], '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . "=" . $post_id) . '#' . $post_id . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_forum'], '<a href="' . append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id") . '">', '</a>');
return false;
}
//
// Update post stats and details
regel 491 is:
Code: Selecteer alles
$cash_message = $GLOBALS['cm_posting']->update_post($mode, $post_data, $forum_id, $topic_id, $post_id, $topic_type, $bbcode_uid,
Geplaatst: 16 nov 2005, 12:24
door Paul
Komt door die stomme cash mod.
Geplaatst: 16 nov 2005, 13:55
door gies
Code: Selecteer alles
/templates/xxx/posting_body.tpl
#
#-----[ FIND ]------------------------------------------
#
formErrors = "{L_EMPTY_MESSAGE}";
}
#
#-----[ AFTER, ADD ]------------------------------------------
#
<!-- BEGIN switch_quiz_answer_js -->
{switch_quiz_answer_js.JS}
<!-- END switch_quiz_answer_js -->
ik kan alleen
formErrors = "{L_EMPTY_MESSAGE}"; of iets wat erop lijkt niet vinden in mijn posting_body.
Waar meot ik het zetten ???
Post je de volgende keer even een link naar de code? Dat is voor iedereen beter! -- Bee
Geplaatst: 16 nov 2005, 17:01
door Bee
Dit wordt het dan:
Code: Selecteer alles
<script language="JavaScript" src="bbcode_box/add_bbcode.js" type="text/javascript"></script>
vervangen door
Code: Selecteer alles
<script src="bbcode_box/add_bbcode.js" type="text/javascript">
<!-- BEGIN switch_quiz_answer_js -->
{switch_quiz_answer_js.JS}
<!-- END switch_quiz_answer_js -->
</script>
Geplaatst: 16 nov 2005, 17:10
door gies
thanx