function fix_profile($profile) { $text = html_to_bbcode($profile->response2); if ($text != $profile->response2) { $query = "update profile set response2 = '" . mysql_escape_string($text) . "' where userid=" . $profile->userid; //echo "$profile->response2\n\n"; //echo "$profile->thread $query\n\n"; $retval = mysql_query($query); if (!$retval) { echo mysql_error(); exit; } } }
function fix_forum_preferences($forum_preferences) { $text = html_to_bbcode($forum_preferences->signature); if ($text != $forum_preferences->signature) { $query = "update forum_preferences set signature = '" . _mysql_escape_string($text) . "' where userid=" . $forum_preferences->userid; //echo "$forum_preferences->signature\n\n"; //echo "$forum_preferences->thread $query\n\n"; $retval = _mysql_query($query); if (!$retval) { echo _mysql_error(); exit; } } }
function fix_post($post) { $text = html_to_bbcode($post->content); if ($text != $post->content) { $query = "update post set content = '" . mysql_escape_string($text) . "' where id=" . $post->id; //echo "$post->content\n\n"; //echo "$post->thread $query\n\n"; $retval = mysql_query($query); if (!$retval) { echo mysql_error(); exit; } } }
<?php } ?> <label for="message">Message</label><br /> <div class="message_buttons"> <input type="button" value="Bold" onclick="javascript:insert('[b]', '[/b]', 'message');" /><!-- --><input type="button" value="Italic" onclick="javascript:insert('[i]', '[/i]', 'message');" /><!-- --><input type="button" value="Underlined" onclick="javascript:insert('[u]', '[/u]', 'message');" /><!-- --><input type="button" value="Image" onclick="javascript:insert('[img]', '[/img]', 'message');" /><!-- --><input type="button" value="Link" onclick="javascript:insert('[url]', '[/url]', 'message');" /><!-- --><input type="button" value="Left" onclick="javascript:insert('[left]', '[/left]', 'message');" /><!-- --><input type="button" value="Center" onclick="javascript:insert('[center]', '[/center]', 'message');" /><!-- --><input type="button" value="Right" onclick="javascript:insert('[right]', '[/right]', 'message');" /> </div> <textarea name="message" id="message" cols="70" rows="6"><?php echo html_to_bbcode($dn1['message']); ?> </textarea><br /> <input type="submit" value="Submit" /> </form> <?php } ?> </div> </body> </html> <?php } else { echo '<h2>You don\'t have the right to edit this message.</h2>'; }
$content = $item[1]; if (isset($item[2])) { $title = $item[2]; } else { $n = strpos($content, ". "); if ($n) { $title = substr($content, 0, $n); } else { $title = $content; } } $when = strtotime($item[0]); $title = html_to_bbcode($title); $title = str_replace("\n", " ", $title); $title = mysql_real_escape_string($title); $content = html_to_bbcode($content); $content = str_replace("\n", " ", $content); $content = mysql_real_escape_string($content); $thread_id = BoincThread::insert("(forum, owner, title, create_time, timestamp, replies) values ({$forum_id}, {$user->id}, '{$title}', {$when}, {$when}, 0)"); if (!$thread_id) { echo "thread insert failed\n"; echo "title: [{$title}]\n"; echo "when: {$when}\n"; exit; } $id = BoincPost::insert("(thread, user, timestamp, content) values ({$thread_id}, {$user->id}, {$when}, '{$content}')"); if (!$id) { die("post insert"); } $forum->update("threads=threads+1, posts=posts+1"); }