| Ohh-Dutch |
11-13-2006 05:25 PM |
Code:
Database error in vBulletin 3.5.4:
Invalid SQL:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'DownloadsII Create Thread on Edit', 'dl_post_upload_edit', 'global $vbulletin;\r\n$cat = $db->query_first(\"SELECT category, dl_forumid_cat, dl_userid_cat, dl_no_threads, dl_threadid\r\n FROM \" . TABLE_PREFIX . \"dl_cats, \" . TABLE_PREFIX . \"dl_files\r\n WHERE \" . TABLE_PREFIX . \"dl_cats.id = \". TABLE_PREFIX . \"dl_files.category AND\r\n \" . TABLE_PREFIX . \"dl_files.id=\".$db->sql_prepare($_GET[\'id\']));\r\n\r\n// only try to build new thread if we have a forumid greater than zero, thread creation permitted, and no existing thread\r\n \r\nif (($vbulletin->options[\'downloadsii_createthread_default_forumid\'] > 0 OR $cat[\'dl_forumid_cat\'] > 0) AND $cat[\'dl_no_threads\'] == 0 AND ($permissions[\'dl2_threadpermissions\'] & $vbulletin->bf_ugp[\'dl2_threadpermissions\'][\'cancreatethreads\']) AND $cat[\'dl_threadid\'] < 1 )\r\n{\r\n $id = $_GET[\'id\'];\r\n\r\n if ($cat[\'dl_forumid_cat\'] > 0)\r\n {\r\n $foruminfo = fetch_foruminfo(&$cat[\'dl_forumid_cat\'], 1);\r\n } else {\r\n $foruminfo = fetch_foruminfo(&$vbulletin->options[\'downloadsii_createthread_default_forumid\'], 1);\r\n }\r\n \r\n \r\n\r\n if (!$foruminfo[\'forumid\'])\r\n {\r\n eval(standard_error(fetch_error(\'invalidid\', $vbphrase[\'forum\'], $vbulletin->options[\'contactuslink\'])));\r\n }\r\n \r\n if (!$foruminfo[\'allowposting\'] OR $foruminfo[\'link\'] OR !$foruminfo[\'cancontainthreads\'])\r\n {\r\n eval(standard_error(fetch_error(\'forumclosed\')));\r\n }\r\n \r\n \r\n $forumperms = fetch_permissions($foruminfo[\'forumid\']);\r\n if (!($forumperms & $vbulletin->bf_ugp_forumpermissions[\'canpostnew\']))\r\n {\r\n print_no_permission();\r\n }\r\n \r\n \r\n // determine the userid to use\r\n if ($cat[\'dl_userid_cat\'] > 0)\r\n {\r\n $userid = $cat[\'dl_userid_cat\'];\r\n \r\n } elseif ($vbulletin->options[\'downloadsii_createthread_default_userid\'] > 0){\r\n \r\n $userid = $vbulletin->options[\'downloadsii_createthread_default_userid\'];\r\n \r\n } else {\r\n \r\n $userid = $vbulletin->userinfo[\'userid\'];\r\n }\r\n \r\n $userstuff = fetch_userinfo($userid,1);\r\n $forumid = $foruminfo[\'forumid\'];\r\n $postuserid = $userstuff[\'userid\'];\r\n $username = $userstuff[\'username\'];\r\n /* $pagetext = $_POST[\'desc\']; */\r\n /* $title = $_POST[\'dname\']; */\r\n eval(\'$pagetext .= \"\' . fetch_template(\'downloadii_create_newthread\') . \'\";\');\r\n eval(\'$title .= \"\' . fetch_template(\'downloadii_create_newthread_title\') . \'\";\');\r\n \r\n $allowsmilie = \'1\';\r\n \r\n if ($_POST[\'purgatory\'] == 1)\r\n {\r\n $visible = 0;\r\n } else {\r\n $visible = 1;\r\n } \r\n \r\n // code to create new thread\r\n require_once(DIR . \'/includes/functions_databuild.php\'); /* included to build new thread and update counters */ \r\n $threaddm =& datamanager_init(\'Thread_FirstPost\', $vbulletin, ERRTYPE_ARRAY, \'threadpost\');\r\n $threadinfo = array();\r\n \r\n $threaddm->set_info(\'forum\', $foruminfo);\r\n $threaddm->set_info(\'thread\', $threadinfo);\r\n $threaddm->setr(\'forumid\', $forumid);\r\n $threaddm->setr(\'userid\', $userid);\r\n $threaddm->setr(\'pagetext\', $pagetext);\r\n $threaddm->setr(\'title\', $title);\r\n $threaddm->set(\'allowsmilie\', $allowsmilie);\r\n $threaddm->set(\'visible\', $visible);\r\n \r\n $threaddm->pre_save();\r\n if(count($threaddm->errors) < 1)\r\n {\r\n $threadid = $threaddm->save();\r\n unset($threaddm);\r\n build_thread_counters($threaddm);\r\n } else {\r\n eval(standard_error(fetch_error($threaddm->errors, $vbphrase[\'forum\'], $vbulletin->options[\'contactuslink\'])));\r\n }\r\n \r\n build_forum_counters($foruminfo[\'forumid\']); \r\n // end code to create new thread\r\n\r\n if ($threadid > 0)\r\n {\r\n $db->query_write(\"UPDATE \" . TABLE_PREFIX . \"dl_files SET `dl_threadid`=\'\".$threadid.\"\' WHERE `id`=\".$db->sql_prepare($id));\r\n eval(\'$desc_new .= \"\' . fetch_template(\'downloadii_create_newthread_desc\') . \'\";\');\r\n $db->query_write(\"UPDATE \" . TABLE_PREFIX . \"dl_files SET `description`=\'\".$desc_new.\"\' WHERE `id`=\".$db->sql_prepare($id));\r\n }\r\n \r\n\r\n}elseif (($vbulletin->options[\'downloadsii_createthread_default_forumid\'] > 0 OR $cat[\'dl_forumid_cat\'] > 0) AND $cat[\'dl_no_threads\'] == 0 AND ($permissions[\'dl2_threadpermissions\'] & $vbulletin->bf_ugp[\'dl2_threadpermissions\'][\'cancreatethreads\']) AND $cat[\'dl_threadid\'] > 0 )\r\n{\r\n\r\n require_once(\'./includes/class_dm.php\');\r\n require_once(\'./includes/class_dm_threadpost.php\');\r\n \r\n $postdm = new vB_DataManager_Post($vbulletin, ERRTYPE_STANDARD);\r\n \r\n $postthreadid = $cat[\'dl_threadid\'];\r\n // determine the userid to use\r\n if ($cat[\'dl_userid_cat\'] > 0)\r\n {\r\n $userid = $cat[\'dl_userid_cat\'];\r\n \r\n } elseif ($vbulletin->options[\'downloadsii_createthread_default_userid\'] > 0){\r\n \r\n $userid = $vbulletin->options[\'downloadsii_createthread_default_userid\'];\r\n \r\n } else {\r\n \r\n $userid = $vbulletin->userinfo[\'userid\'];\r\n }\r\n \r\n $userstuff = fetch_userinfo($userid,1);\r\n $postuserid = $userstuff[\'userid\'];\r\n $id = $_GET[\'id\'];\r\n\r\n \r\n $threadinfo = fetch_threadinfo($postthreadid);\r\n $foruminfo = fetch_foruminfo($threadinfo[\'forumid\']);\r\n \r\n if (!$foruminfo[\'forumid\'])\r\n {\r\n eval(standard_error(fetch_error(\'invalidid\', $vbphrase[\'forum\'], $vbulletin->options[\'contactuslink\'])));\r\n }\r\n \r\n if (!$foruminfo[\'allowposting\'] OR $foruminfo[\'link\'] OR !$foruminfo[\'cancontainthreads\'])\r\n {\r\n eval(standard_error(fetch_error(\'forumclosed\')));\r\n }\r\n \r\n \r\n $forumperms = fetch_permissions($foruminfo[\'forumid\']);\r\n if (!($forumperms & $vbulletin->bf_ugp_forumpermissions[\'canpostnew\']))\r\n {\r\n print_no_permission();\r\n }\r\n \r\n eval(\'$postpagetext .= \"\' . fetch_template(\'downloadii_create_post\') . \'\";\');\r\n \r\n $postdm->set_info(\'forum\', $foruminfo);\r\n $postdm->set_info(\'thread\', $threadinfo); \r\n $postdm->set(\'threadid\', $postthreadid);\r\n //$postdm->set(\'username\', $postusername);\r\n // Use $postusername if posting as a guest, use $postuserid if posting as a user\r\n $postdm->set(\'userid\', $postuserid);\r\n $postdm->set(\'pagetext\', $postpagetext);\r\n $postdm->set(\'allowsmilie\', 1);\r\n $postdm->set(\'visible\', 1);\r\n $postdm->set(\'dateline\', TIMENOW);\r\n $postdm->save();\r\n unset($postdm); \r\n require_once(DIR . \'/includes/functions_databuild.php\');\r\n build_forum_counters($threadinfo[\'forumid\']); \r\n}', 'dl2_thread');
any idea how u can help? |
More Information