Yorick
Elite
Berichten: 1901
Rating: 11
|
 Geplaatst: Za Okt 18, 2008 11:49 am Onderwerp: probleem met script op wamp te draaien |
 |
|
|
Als ik mn wampserver (dus lokaal) start kan ik gewoon een phpbb forum enzo draaien.. maar als ik bvb een converterscript (van phpbb3 naar fireboard) wil draaien herkent ie precies php niet want ie laat gewoon stukken tekst precies zien dan (zie hieronder). Hoe moet ik dat oplossen?
[quote]
| Code: | Invalid query:
$query
" . mysql_error()); // $result = mysql_query($query) or alert("
Invalid query:
$query
" . mysql_error()); //Populate Categories echo "
Populating Categories...\n"; $query="TRUNCATE TABLE {$josConfig_dbprefix}fb_categories"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); // Import the main categories $query="INSERT INTO {$josConfig_dbprefix}fb_categories (id,parent,name,cat_emoticon,locked,alert_admin,moderated,moderators,pub_access,pub_recurse,admin_access,admin_recurse,ordering,future2,published,checked_out,checked_out_time,review,hits,description) SELECT forum_id + 500, 0, forum_name, 0, 0, 0, 0, NULL, 0, 0, 0, 0, left_id, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, '' FROM {$phpbb_dbprefix}forums WHERE parent_id='0' ORDER BY left_id"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); // Import the forums $query="INSERT INTO {$josConfig_dbprefix}fb_categories (id,parent,name,ordering,description,pub_access,pub_recurse,published,numPosts,numTopics,id_last_msg) SELECT forum_id, parent_id + 500, forum_name, left_id, forum_desc, 0, 0, 1, forum_posts, forum_topics, forum_last_post_id FROM {$phpbb_dbprefix}forums"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); $query="update {$josConfig_dbprefix}fb_categories, {$josConfig_dbprefix}fb_messages set time_last_msg={$josConfig_dbprefix}fb_messages.time WHERE {$josConfig_dbprefix}fb_categories.id_last_msg={$josConfig_dbprefix}fb_messages.id and id_last_msg>0"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); echo "OK\n"; //Populate Messages Table echo "
Populating Messages Table...\n"; $query="TRUNCATE TABLE {$josConfig_dbprefix}fb_messages"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); // Read all threads and posts from phpbb // $query="SELECT p.post_id, p.poster_ip, p.topic_id, p.poster_id, p.post_time, t.topic_title, t.forum_id, t.topic_views" $query="SELECT p.post_id, p.poster_ip, p.topic_id, p.poster_id, p.post_time, p.post_username, t.topic_title, t.forum_id, t.topic_views,t.topic_type, p.post_subject" ." FROM {$phpbb_dbprefix}posts AS p, {$phpbb_dbprefix}topics AS t" // $JMI ." WHERE p.topic_id = t.topic_id" // $JMI ." ORDER BY p.topic_id, p.post_id"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); // Iterate over all the posts and add them to simpleboard after some conversion $currentthread = ""; $lastpost = 0; while ($row = mysql_fetch_object($result)) { // Convert ip to sb-format // $row->poster_ip = phpbb_decode_ip($ip); $JMI mal! $row->poster_ip = phpbb_decode_ip($row->poster_ip); // Check if we have a new thread number if ( $currenttopicid != $row->topic_id ) { $currenttopicid = $row->topic_id; $currentthread = $row->post_id; $lastpost = 0; $subject = addslashes( $row->topic_title ); $postparent = 0 ; } else { if ( $row->post_subject == "" ) { // $JMI ini $subject = "Re: " . addslashes( $row->topic_title ); } else { $subject = addslashes( $row->post_subject ); } // $JMI fin $postparent = $currentthread ; } // Insert the post into the database $query="INSERT INTO `{$josConfig_dbprefix}fb_messages`" ." (id, ip, phpbb_userid, userid, name, time, thread, subject, hits, catid, parent, ordering)" // $JMI ." VALUES ('$row->post_id', '$row->poster_ip', '$row->poster_id', '$row->poster_id', '$row->poster_id', " ." VALUES ('$row->post_id', '$row->poster_ip', '$row->poster_id', '$row->poster_id', '$row->post_username', " // $JMI ." '$row->post_time', '$currentthread', '$subject', '$row->topic_views', '$row->forum_id', '$lastpost')"; ." '$row->post_time', '$currentthread', '$subject', '$row->topic_views', '$row->forum_id', '$postparent', '$row->topic_type')"; $updateresult = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); $lastpost = $row->post_id; } mysql_free_result($result); echo "OK\n"; //Populate Messages_Text Table echo "
Populating Messages_Text Table...\n"; $query="TRUNCATE TABLE {$josConfig_dbprefix}fb_messages_text"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); $query="SELECT post_id, post_text, bbcode_uid FROM {$phpbb_dbprefix}posts"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); $mtext = array(); $mpostid = array(); while ($row = mysql_fetch_object($result)) { $text = addslashes($row->post_text); $text = prep($text); $text = preg_replace('/:'.$row->bbcode_uid.'/', '', $text); $mtext[] = addslashes($text); $mpostid[] = $row->post_id; } mysql_free_result($result); for ($i=0; $i < count($mtext); $i++){ $query="INSERT INTO `{$josConfig_dbprefix}fb_messages_text`" ." (mesid, message) VALUES" ." (".$mpostid[$i].", \"".$mtext[$i]."\")"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); } echo "OK\n"; //Populate Users Table echo "
Populating Users Table...\n"; $query="TRUNCATE TABLE {$josConfig_dbprefix}fb_users"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); // Get the group id:s for regular users and administrators in Mambo. $query = "SELECT group_id FROM {$josConfig_dbprefix}core_acl_aro_groups WHERE name='Registered' OR name='Administrator' ORDER BY name ASC"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); $admingid = mysql_result( $result, 0, 0 ); $usergid = mysql_result( $result, 1, 0 ); // Read all users from phpBB2 $query="SELECT u.*, b.ban_userid FROM {$phpbb_dbprefix}users AS u LEFT OUTER JOIN {$phpbb_dbprefix}banlist AS b ON u.user_id = b.ban_userid WHERE user_id > 0 ORDER BY u.user_id"; // Read all users from postnuke //$query="SELECT u.* FROM {$phpbb_dbprefix}users AS u WHERE pn_uid > 0 ORDER BY u.pn_uid"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); // The query to pull the existing nuke data $count=0; while($row = mysql_fetch_object( $result )): // Is this user banned? $block = "0"; if ( $row->ban_userid ) { $block = "1"; } // Set user type and group id // if ( $row->user_level == "1" ) { // $usertype = "administrator"; // $gid = $admingid; // } else { $usertype = "Registered"; $gid = $usergid; //} $emailadmin = "0"; // } // Convert date for last visit and register date. $registerDate = date( "Y-m-d H:i:s", $row->user_regdate ); $lastvisitDate = date( "Y-m-d H:i:s", $row->user_lastvisit); $text = preg_replace('/:'.$row->bbcode_uid.'/', '', $text); // Convert bbcode in signature $row->user_sig = preg_replace('/:'.$row->user_sig_bbcode_uid.'/','', $row->user_sig); $row->user_sig = prep( $row->user_sig ); $row->user_from = prep( $row->user_from ); // No imported users will get mails from the admin $emailadmin = "0"; print "$row->username: "; // Insert user into Mambo user table $query = " INSERT INTO {$josConfig_dbprefix}users (name, username, email, password, usertype, block, sendEmail, gid, registerDate, lastvisitDate) VALUES ('$row->username', '$row->username', '$row->user_email', '$row->user_password', '$usertype', '$block', '$emailadmin', '$gid', '$registerDate', '$lastvisitDate') "; mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); $newuserid = mysql_insert_id( ); print "$newuserid - NEW \n"; // Add user to core acl groups map $query = "INSERT INTO {$josConfig_dbprefix}core_acl_groups_aro_map ( group_id, aro_id ) VALUES ( $gid, $newuserid )"; mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); // Add user to core acl aro map $query = "INSERT INTO {$josConfig_dbprefix}core_acl_aro (aro_id,section_value,value,order_value,name,hidden) VALUES ( $newuserid, 'users', $newuserid, 0, '$row->username', 0 )"; mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); // Update all posts from this user with the correct userid and username $query = "UPDATE `{$josConfig_dbprefix}fb_messages` SET userid = '$newuserid', name = '$row->username' WHERE phpbb_userid = '$row->user_id'"; mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); $query = "INSERT INTO `{$josConfig_dbprefix}fb_users` (userid, posts, signature, location, ICQ, AIM, YIM, MSN, websiteurl) VALUES ('$newuserid', '$row->user_posts', '$row->user_sig', '$row->user_from', '$row->user_icq', '$row->user_aim', '$row->user_yim', '$row->user_msnm', '$row->user_website')"; mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); $id++; $aroid++; $count++; endwhile; mysql_free_result($result); // Remove the placeholder for the userid from phpBB2 $query="ALTER TABLE `{$josConfig_dbprefix}fb_messages` DROP `phpbb_userid`"; $result = mysql_query($query) or die("
Invalid query:
$query
" . mysql_error()); echo "
Inserted ".$count." Users"; /*******************************************************************************************************************************************************/ /* FUNCIONES AUXILIARES */ function phpbb_decode_ip($int_ip) { if ($int_ip == '00000000') { return '0.0.0.0'; } else { return long2ip("0x{$int_ip}"); } } //--- Function to prepare strings for MySQL storage ---/ function prep($s) { // Parse out the $uid things that fuck up bbcode $s = preg_replace('/\</', '<', $s); $s = preg_replace('/\>/', '>', $s); $s = preg_replace('/\:/', ':', $s); $s = preg_replace('/\./', '.', $s); $s = preg_replace('/\"/','',$s); $s = preg_replace('/\&/','&',$s); // $s = preg_replace('/\[b:(.*?)\]/', '[b]', $s); $s = preg_replace('/\[\/b:(.*?)\]/', '[/b]', $s); // $s = preg_replace('/\[i:(.*?)\]/', '[i]', $s); $s = preg_replace('/\[\/i:(.*?)\]/', '[/i]', $s); // $s = preg_replace('/\[u:(.*?)\]/', '[u]', $s); $s = preg_replace('/\[\/u:(.*?)\]/', '[/u]', $s); // quote $s = preg_replace('/\[quote:(.*?)\]/', '[quote]', $s); $s = preg_replace('/\[quote(:(.*?))?="(.*?)"\]/', '[b]\\3[/b]\n[quote]', $s); $s = preg_replace('/\[\/quote:(.*?)\]/', '[/quote]', $s); // image #$s = preg_replace('/\[img:(.*?)="(.*?)"\]/', '[img="\\2"]', $s); $s = preg_replace('/\[img:(.*?)\](.*?)\[\/img:(.*?)\]/si', '[img]\\2[/img]', $s); // color $s = preg_replace('/\[color=(.*?):(.*?)\]/', '[color=\\1]', $s); $s = preg_replace('/\[\/color:(.*?)\]/', '[/color]', $s); // size $s = preg_replace('/\[size=\d:(.*?)\]/', '[size=1]', $s); $s = preg_replace('/\[size=1[0123]:(.*?)\]/', '[size=2]', $s); $s = preg_replace('/\[size=1[4567]:(.*?)\]/', '[size=3]', $s); $s = preg_replace('/\[size=((1[89])|(2[01])):(.*?)\]/', '[size=4]', $s); $s = preg_replace('/\[size=2[234567]:(.*?)\]/', '[size=5]', $s); $s = preg_replace('/\[size=((2[89])|(3[01])):(.*?)\]/', '[size=6]', $s); $s = preg_replace('/\[size=3[2-9]:(.*?)\]/', '[size=7]', $s); $s = preg_replace('/\[\/size:(.*?)\]/', '[/size]', $s); // code $s = preg_replace('/\[code:(.*?):(.*?)\]/', '[code:\\1]', $s); $s = preg_replace('/\[\/code:(.*?):(.*?)\]/', '[/code:\\1]', $s); // lists $s = preg_replace('/\[list(:(.*?))?\]/', '[ul]', $s); $s = preg_replace('/\[list=([a1]):(.*?)\]/', '[ol]', $s); $s = preg_replace('/\[\*:(.*?)\]/', '[li]', $s); $s = preg_replace('/\[\/list:u:(.*?)\]/', '[/ul]', $s); $s = preg_replace('/\[\/list:o:(.*?)\]/', '[/ol]', $s); $s = preg_replace('/\/', '[b]', $s); $s = preg_replace('/\<\/b>/', '[/b]', $s); $s = preg_replace('/\/', '', $s); $s = preg_replace('/\:.*?:/', '', $s); $s = preg_replace('/\\\S\\S/', '', $s); $s = preg_replace('/\(.*?)<\/a>/','[url=\\1]\\2[/url]' ,$s ); $s = preg_replace('/\(.*?)<\/a>/','[url=\\1]\\2[/url]' ,$s ); $s = preg_replace('/\/','' , $s); $s = preg_replace('/\<\/a>/' ,'' , $s); $s = preg_replace('/\\\\/', '', $s); $s = addslashes($s); return $s; } ?>
Skipped: |
|
|
Main
