1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
|
<?php
require_once("../inc/db.inc");
require_once("../inc/util.inc");
require_once('../inc/sanitize_html.inc');
db_init();
set_time_limit(0);
function image_as_bb($text){
// This function depends on sanitized HTML
$pattern = '@<img(.*) src=\"([^>^"]+)\"([^>]*)>@si';
$replacement = '[img]$2[/img]';
$text = preg_replace($pattern, $replacement, $text);
$pattern = "@<img(.*) src='([^>^']+)'([^>]*)>@si";
$replacement = '[img]$2[/img]';
$text = preg_replace($pattern, $replacement, $text);
return $text;
}
function link_as_bb($text){
/* This function depends on sanitized HTML */
// Build some regex (should be a *lot* faster)
$pattern = '@<a href=\"([^>]+)\">@si'; // Gives us the URL in $1...
$replacement = '[url=$1]'; // Turns that URL into a hyperlink
$text = preg_replace($pattern, $replacement, $text);
$pattern = "@<a href='([^>]+)'>@si"; // Gives us the URL in $1...
$replacement = '[url=$1]'; // Turns that URL into a hyperlink
$text = preg_replace($pattern, $replacement, $text);
$pattern = "@</a>@si";
$replacement = '[/url]';
$text = preg_replace($pattern, $replacement, $text);
return $text;
}
function formatting_as_bb($text){
/* This function depends on sanitized HTML */
$in[]="<b>";$out[]="[b]";
$in[]="</b>";$out[]="[/b]";
$in[]="<i>";$out[]="[i]";
$in[]="</i>";$out[]="[/i]";
$in[]="<u>";$out[]="[u]";
$in[]="</u>";$out[]="[/u]";
$in[]="<b>";$out[]="[b]";
$in[]="</b>";$out[]="[/b]";
$in[]="<ul>";$out[]="[list]";
$in[]="</ul>";$out[]="[/list]";
$in[]="<ol>";$out[]="[list=1]";
$in[]="</ol>";$out[]="[/list]";
$in[]="<pre>";$out[]="[pre]";
$in[]="</pre>";$out[]="[/pre]";
$in[]="</br>";$out[]="\n";
$in[]="<br/>";$out[]="\n";
$in[]="<br>";$out[]="\n";
$in[]=">";$out[]=">";
$in[]="<";$out[]="<";
$in[]="&";$out[]="&";
return str_replace($in, $out, $text);
}
function fix_text($text) {
$text = sanitize_html($text);
$text = image_as_bb($text);
$text = link_as_bb($text);
$text = formatting_as_bb($text);
return $text;
}
function fix_post($post) {
$text = fix_text($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();
}
}
}
function fix_posts() {
$start_id = 0; //Set this to something else if you like
$posts = mysql_query("select * from post where id>$start_id order by id");
echo mysql_error();
$i=0;
while ($post = mysql_fetch_object($posts)){
$i++;
if ($i%100 == 0) { //For every 100 posts
echo $post->id.". "; flush(); // print out where we are
//usleep(200000);
}
if ($post->id > $start_id){
fix_post($post);
}
}
}
// use this to patch problem cases; hand-edit
function fix_fix() {
$posts = mysql_query("select * from post where id=99");
$post = mysql_fetch_object($posts);
fix_post($post);
}
fix_posts();
//fix_fix();
?>
|
