sql_query($sql) )
{
die("Couldn't alter privmsgs table");
}
echo $sql = "ALTER TABLE " . PRIVMSGS_TEXT_TABLE . "
ADD privmsgs_bbcode_uid CHAR(10) AFTER privmsgs_text_id";
if( !$result = $db->sql_query($sql) )
{
die("Couldn't alter privmsgs text table");
}
echo "COMPLETE
";
//
// Move bbcode ...
//
echo "Move bbcode uid's ... ";
$sql = "SELECT privmsgs_id, privmsgs_bbcode_uid
FROM " . PRIVMSGS_TABLE;
if( $result = $db->sql_query($sql) )
{
$rowset = $db->sql_fetchrowset($result);
for($i = 0; $i < count($rowset); $i++)
{
$sql = "UPDATE " . PRIVMSGS_TEXT_TABLE . "
SET privmsgs_bbcode_uid = '" . $rowset[$i]['privmsgs_bbcode_uid'] . "'
WHERE privmsgs_text_id = " . $rowset[$i]['privmsgs_id'];
if( !$result = $db->sql_query($sql) )
{
die("Couldn't update privmsgs text bbcode - " . $i);
}
}
$sql = "ALTER TABLE " . PRIVMSGS_TABLE . "
DROP privmsgs_bbcode_uid";
if( !$result = $db->sql_query($sql) )
{
die("Couldn't alter privmsgs table - drop privmsgs_bbcode_uid");
}
}
echo "COMPLETE
";
//
// Stripslashes from titles
//
echo "Strip subject slashes ... ";
$sql = "SELECT privmsgs_subject , privmsgs_id, privmsgs_to_userid, privmsgs_from_userid
FROM " . PRIVMSGS_TABLE;
if( $result = $db->sql_query($sql) )
{
$rowset = $db->sql_fetchrowset($result);
for($i = 0; $i < count($rowset); $i++)
{
$sql = "UPDATE " . PRIVMSGS_TABLE . "
SET privmsgs_subject = '" . addslashes(stripslashes($rowset[$i]['privmsgs_subject'])) . "'
WHERE privmsgs_id = " . $rowset[$i]['privmsgs_id'];
if( !$result = $db->sql_query($sql) )
{
die("Couldn't update subjects - $i");
}
}
}
echo "COMPLETE
";
//
// Update sigs
//
echo "Remove [addsig], stripslashes and update privmsgs table sig enable ...";
$sql = "SELECT privmsgs_text_id , privmsgs_text
FROM " . PRIVMSGS_TEXT_TABLE;
if( $result = $db->sql_query($sql) )
{
$rowset = $db->sql_fetchrowset($result);
$attach_sql = "";
$non_attach_sql = "";
for($i = 0; $i < count($rowset); $i++)
{
if( ereg("\[addsig]$", $rowset[$i]['privmsgs_text']))
{
if( $attach_sql != "" )
{
$attach_sql .= ", ";
}
$attach_sql .= $rowset[$i]['privmsgs_text_id'];
$sql = "UPDATE " . PRIVMSGS_TEXT_TABLE . "
SET privmsgs_text = '" . addslashes(preg_replace("/\[addsig\]/is", "", stripslashes($rowset[$i]['privmsgs_text']))) . "'
WHERE privmsgs_text_id = " . $rowset[$i]['privmsgs_text_id'];
if( !$result = $db->sql_query($sql) )
{
die("Couldn't update privmsgs text - " . $i);
}
}
else
{
$sql = "UPDATE " . PRIVMSGS_TEXT_TABLE . "
SET privmsgs_text = '" . addslashes(stripslashes($rowset[$i]['privmsgs_text'])) . "'
WHERE privmsgs_text_id = " . $rowset[$i]['privmsgs_text_id'];
if( !$result = $db->sql_query($sql) )
{
die("Couldn't update privmsgs text - " . $i);
}
if( $non_attach_sql != "" )
{
$non_attach_sql .= ", ";
}
$non_attach_sql .= $rowset[$i]['privmsgs_text_id'];
}
}
if( $attach_sql != "" )
{
$sql = "UPDATE " . PRIVMSGS_TABLE . "
SET privmsgs_attach_sig = 1
WHERE privmsgs_id IN ($attach_sql)";
if( !$result = $db->sql_query($sql) )
{
die("Couldn't update privmsgs table attach_sig - ");
}
}
if( $non_attach_sql != "" )
{
$sql = "UPDATE " . PRIVMSGS_TABLE . "
SET privmsgs_attach_sig = 0
WHERE privmsgs_id IN ($non_attach_sql)";
if( !$result = $db->sql_query($sql) )
{
die("Couldn't update privmsgs table non_attach_sig - ");
}
}
}
echo "COMPLETE
";
$db->sql_close();
?>
쳾@`$H&*%[lR\rrK"PHvb[NH78ԢVWt
f ]YD$jOD%.22Z0UeXϣ7R"AH(q`I 5mFaj>DhvY+8
f@""`<) ;0@R vJID-@PahA([ST^x'77u^ Uw.$/{LLŃȉS<|+J=w @z ͦ l*P:-Qmh6]+9-G{oIOG(\!o6Mꕯx;vkZ/0@PdU XQd QdVpA/" 1b" $AdEF##aFA[|v~O>3%\&6Nxu]O}3PYBi?ղ: zՑ5W?~m%NOKi7)k|EgG9$&V30@|[z@R`wL8BPSwdyoӰx@[>}FTSO9?>yMmZdO]q96$Υ(L@羇kI?
=- V~'^XlxKR1Tqg2`/cԨV
g5D+1˙A$u7#"r8VDH]HP\?U3nBR<8!.s7'HI=-i0Lu㙬xr;<'BD H
{]C{
A&HhvޒD/(Y0^&hSTy,8 wת 3Mts=5zp5D+oHBɰԡSn3 (ec뢜rnAPaZ֖=bOI@Ԃ+L6K@0i1[>ݔ~m@ V$Zu("?ws;GبwݍZdD:IND
00_qPMdCDY5yM*p\o++9YƜ:زq_J%Go7߱} ᧂx,;#S2#0Dʲ8jt&Zc'Jۗ,&En&
Nւ;
dVF/C8c{S?tW,F?ZpA;(&l6:_W9/ڼofvCژ*C7F@1s?L9
cwFu`5أ#@_%, s/N/qO >~b@Wo+o^,
o!_D/bgŻPΙD6)}2=~9$'H
LFv]nJ5\!"'i1atRc m烎G)/ӦkQ_ܖt;nΘ"mPھm;AdAnT=ڨ|1FZ';؟wS髭':֢j"o~5$̌`pio9]l6oja!A]^Vgz({1K=(/ wne,0Z>|W2L.MRJQ= s$D9'@%P>_%4̲K{`XCIp5Gavj^(