FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Converters » phorum2fud???
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: phorum2fud??? [message #3173 is a reply to message #3172] Thu, 13 June 2002 02:54 Go to previous messageGo to previous message
ezdb is currently offline  ezdb   China
Messages: 158
Registered: May 2002
Location: china
Karma:
Senior Member

/////////////////////
it worked well!



/////////////////////

/* import messages */

$r = Q2("SELECT *, UNIX_TIMESTAMP(datestamp) AS post_stamp
FROM
$tobj->table_name
LEFT JOIN
".$tobj->table_name."_bodies
ON $tobj->table_name.id=".$tobj->table_name."_bodies.id
ORDER BY $tobj->table_name.thread, $tobj->table_name.parent");

print_status("\tImporting (".DB_COUNT($r).") messages for $tobj->table_name");

while ( $obj = DB_ROWOBJ($r) ) {
$fileid = write_body(tags_to_html($obj->body), $len, $off);

Q("INSERT INTO ".$MYSQL_TBL_PREFIX."msg
(

thread_id,
poster_id,
post_stamp,
reply_to,
subject,
approved,
smiley_disabled,
host_name,
offset,
length,
file_id
)
VALUES
(

".$thread_arr[$obj->thread].",
$obj->userid,
$obj->post_stamp,
$obj->parent,
'".addslashes($obj->subject)."',
'Y',
'N',
".STRNULL($obj->host).",
".INTZERO($off).",
".INTZERO($len).",
$fileid
)");
}
QF($r);
unset($thread_arr);

[Updated on: Thu, 13 June 2002 02:57]

Report message to a moderator

[Message index]
 
Read Message icon12.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message icon12.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Converters
Next Topic: Trouble Converting from Phorum
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 05:42:40 GMT 2024

Total time taken to generate the page: 0.03930 seconds