i did this, maybe there is better code, but it works for me:
- Code: Alles auswählen
#
#FIND:
#
// confirms new keyword
case 'new_keyword_confirms':
$admin_lexicon_action_url = append_sid("admin_lexicon_edit.$phpEx");
($categorie_id == 0) ? $categorie_id = 1 : '';
$bbcode_uid = make_bbcode_uid();
$explanation = prepare_message(trim($explanation), $html_on, $bbcode_on, $smile_on, $bbcode_uid);
$mode = '';
// insert new keyword in database
$sql="INSERT INTO " . LEXICON_ENTRY_TABLE . " ( id, keyword, explanation, bbcode_uid, cat) VALUES ('', '$keyword', '$explanation', '$bbcode_uid', $categorie_id)";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error update lexicon entry', '', __LINE__, __FILE__, $sql);
}
// Grab lexicon categories
$sql = "SELECT cat_id, cat_titel FROM " . LEXICON_CAT_TABLE;
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not get categories list', '', __LINE__, __FILE__, $sql);
}
while($row = $db->sql_fetchrow($result))
{
$lexicon_categories[$row['cat_id']] = $row['cat_titel'];
}
$db->sql_freeresult($result);
$message = '<br />' . sprintf($lang['Keyword_caused'], $keyword, $lexicon_categories[$categorie_id]);
$message .= '<br /><br /><meta http-equiv="refresh" content="1;url=' . $admin_lexicon_action_url . '">';
message_die(GENERAL_MESSAGE, $message);
break;
#
# REPLACE WITH:
#
case 'new_keyword_confirms':
$exist = 0;
$keyword = strtolower($keyword);
$sql = "SELECT keyword FROM " . LEXICON_ENTRY_TABLE;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Kon encyclopediewoord niet checken', '', __LINE__, __FILE__, $sql);
}
while($row = $db->sql_fetchrow($result))
{
$existkeyword = $row['keyword'];
if ($existkeyword == $keyword){$exist = 1;}
}
$db->sql_freeresult($result);
if ($exist)
{
$message = '<br /><br />This word allready exists in the Lexicon<br />Click <a href="#" onClick="history.go(-1)">Back</a> to give your word another name or to copy your text and see if you can improve the existing word with it.<br><br>Click <a href="lexicon.php">here</a> to go to the Lexicon.';
message_die(GENERAL_MESSAGE, $message);
break;
}
else
{
$admin_lexicon_action_url = append_sid("lexicon_edit.$phpEx");
($categorie_id == 0) ? $categorie_id = 1 : '';
$bbcode_uid = make_bbcode_uid();
$explanation = prepare_message(trim($explanation), $html_on, $bbcode_on, $smile_on, $bbcode_uid);
$poster = $userdata['username'];
$mode = '';
// insert new keyword in database
$sql="INSERT INTO " . LEXICON_ENTRY_TABLE . " ( id, keyword, explanation, bbcode_uid, cat, poster) VALUES ('', '$keyword', '$explanation', '$bbcode_uid', $categorie_id, '$poster')";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error update lexicon entry', '', __LINE__, __FILE__, $sql);
}
// Grab lexicon categories
$sql = "SELECT cat_id, cat_titel FROM " . LEXICON_CAT_TABLE;
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not get categories list', '', __LINE__, __FILE__, $sql);
}
while($row = $db->sql_fetchrow($result))
{
$lexicon_categories[$row['cat_id']] = $row['cat_titel'];
}
$db->sql_freeresult($result);
$message = '<br />' . sprintf($lang['Keyword_caused'], $keyword, $lexicon_categories[$categorie_id]);
$message .= '<br /><br /><meta http-equiv="refresh" content="1;url=' . $admin_lexicon_action_url . '">';
message_die(GENERAL_MESSAGE, $message);
break;
}