that worked like a charm, thank you so much!

np at all, thanks for your help!

sent to smartys@punbb.org

you want my old phpbb3 DB correct?

using the above code gave the the original DB error I posted about. With the way it is now I repopulated my search index, did a search and was able to view the results, even the posts. in the admin CP i cant see the forums though

some of what? I could export the forums/catagory/posts tables and post that here if you like. and BTW i was able to get this far by not using the updated forums.php file from the converter.

hmm, looking at my new punbb DB all of the tables are populated with the old phpbb3 information, it just isnt showing.

I'll try it, and I am using the second forums.php file you posted. I see where the OP got punbb installed on his site, so I have hope that this will work smile

could it be where i have ran the converter multiple times? should i try from a fresh install again? ATM i can see member count, post count, tpoic count, but it doesnt show any forums or catagories

10

(55 replies, posted in PunBB 1.2 discussion)

I get this error:

File: /homepages/36/d175509457/htdocs/shadow/punbb/converter/PhpBB/forums.php
Line: 41

Converter reported: Unable to save to database.

Query: INSERT INTO `xxxxxxxxxx`.PUNBB_forums (id,forum_name,forum_desc,num_topics,num_posts,last_poster,last_post_id,last_post,cat_id) VALUES('1','xxxxxxx','xxxxxxxxxxx','16','20','drndadoo','141','1187343698','17')

Database reported: Duplicate entry '1' for key 1 (Errno: 1062)

does my coding look right? i'll be the first to admit im a coding retard.

i think im making things worse sad here is what i got:

preparse:

$a = array( '#\[url=("|\'|)(.*?)\\1\]\s*#i',
                '#\[url\]\s*#i',
                '#\s*\[/url\]#i',
                '#\[email=("|\'|)(.*?)\\1\]\s*#i',
                '#\[email\]\s*#i',
                '#\s*\[/email\]#i',
                '#\[img\]\s*(.*?)\s*\[/img\]#is',
                '#\[colou?r=("|\'|)(.*?)\\1\](.*?)\[/colou?r\]#is',
                '#\[size=\s*([0-9]*?)\s*\]\s*(.*?)\s*\[/size\]#');


    $b = array(    '[url=$2]',
                '[url]',
                '[/url]',
                '[email=$2]',
                '[email]',
                '[/email]',
                '[img]$1[/img]',
                '[color=$2]$3[/color]',
                '[size=$1]$2[/size]');

the rest:

$pattern = array('#\[size=([0-9]*?)\](.*?)\[/size\]#',
                 '#\[b\](.*?)\[/b\]#s',
                     '#\[i\](.*?)\[/i\]#s',
                     '#\[u\](.*?)\[/u\]#s',
                '#\[youtube\]http://www.youtube.com/watch\?v=(.*?)\[/youtube\]#s',
                '#\[googlevid\]http://video.google.com/videoplay\?docid=(.*?)\[/googlevid\]#s',
                     '#\[url\]([^\[]*?)\[/url\]#e',
                     '#\[url=([^\[]*?)\](.*?)\[/url\]#e',
                     '#\[email\]([^\[]*?)\[/email\]#',
                     '#\[email=([^\[]*?)\](.*?)\[/email\]#',
                     '#\[ul\](.*?)\[/ul\]#',
                     '#\[ol\](.*?)\[/ol\]#',
                     '#\[uli\](.*?)\[/uli\]#',
                     '#\[oli\](.*?)\[/oli\]#',
                     '#\[color=([a-zA-Z]*|\#?[0-9a-fA-F]{6})](.*?)\[/color\]#s',
                     '#\[font=(.*?)](.*?)\[/font\]#',
                     '#\[style="(.*?)"\](.*?)\[/style\]#',
                     '#\[hr /\]#',
                     '#\[hr\]#',
                     '#\[table\](.*?)\[/table\]#',
                     '#\[caption\](.*?)\[/caption\]#',
                     '#\[tr\](.*?)\[/tr\]#',
                     '#\[td\](.*?)\[/td\]#',
                     '#\[s\](.*?)\[/s\]#',
                     '#\[pre\](.*?)\[/pre\]#',
                     '#\[sup\](.*?)\[/sup\]#',
                     '#\[sub\](.*?)\[/sub\]#',
                     '#\[h\](.*?)\[/h\]#');


    $replace = array('<span style="font-size: $1">$2</span>',
                 '<strong>$1</strong>',
                     '<em>$1</em>',
                     '<span class="bbu">$1</span>',
                'object width="425" height="350"><param name="movie" value="http://www.youtube.com/v/$1"></param><embed src="http://www.youtube.com/v/$1" type="application/x-shockwave-flash" width="425" height="350"></embed></object>',
                '<embed style="width:400px; height:326px;" id="VideoPlayback" type="application/x-shockwave-flash" src="http://video.google.com/googleplayer.swf?docId=$1&hl=en"></embed>',
                'handle_url_tag(\'$1\')',
                     'handle_url_tag(\'$1\', \'$2\')',
                     '<a href="mailto:$1">$1</a>',
                     '<a href="mailto:$1">$2</a>',
                     '<ul>$1</ul>',
                     '<ol>$1</ol>',
                     '<li>?  $1</li>',
                     '<li>$1</li>',
                     '<span style="color: $1">$2</span>',
                     '<span style="font-family: $1">$2</span>',
                     '<div align="$1">$2</span>',
                     '<span style="$1">$2</span>',
                     '<hr />',
                     '<hr />',
                     '<table>$1</table>',
                     '<tr>$1</tr>',
                     '<td>$1</td>',
                     '<del>$1</del>',
                     '<pre>$1</pre>',
                     '<sup>$1</sup>',
                     '<sub>$1</sub>',
                     '<span style="background-color: #FFFF00; color: #000000">$1</span>');

i'm still not getting a parse error, but size won work using a 1-9 variable.

awsome, thanks!

i tried to add the [size] tag and cant get it to work for some reason

here is what mine looks like:

$pattern = array('#\[size=(.*?)](.*?)\[/size\]#',
                 '#\[b\](.*?)\[/b\]#s',
                 '#\[i\](.*?)\[/i\]#s',
                 '#\[u\](.*?)\[/u\]#s',

and the replace is:

$replace = array('<span style="font-size: $1">$2</span>',
             '<strong>$1</strong>'
             '<em>$1</em>',
             '<span class="bbu">$1</span>',

i dont get a parse error it just wont work. any clue as to why? thanks.

15

(8 replies, posted in PunBB 1.2 show off)

i guess your forum is nice, i couldnt see it. rest of site looks good.