DeepakJ

Thanks for all the help I fixed it. I simply used mysql_escape_string on it and it works fine now. Thanks!

Please!!

I'm finding it difficult to figure out what is wrong with this script. I know the problem lies with the post text value but am unsure exactly what. INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('2', ' ', 'Service Pack 1 for VisualMill 5 has been released!', 'Please go to Downloads->Service Packs and download the Service Pack 1 for VisualMill. <br><br>You can also get the complete product with Serice Pack included from the Support->Download 5.0 link.<br><br>The bugs fixed in this Service Pack are as follows:<br><br>1. Allow user to keep visibility of part/regions in the Stock View. A new check box has been added in the Display Preferences.<br>2. Crash when loading part without layers when active layer is not Default<br>3. Cannot import regions as IGES files<br>4. When selection regions all, the surfaces get highlighted.<br>5. Re-roughing does not work after the Rotate Table or the Set MCS operations<br>6. Browser/Geometry - [DEL] key does not work<br>7. Copy and paste mops in the Mops Browser is not working<br>8. Parasolid 2004 files can now be imported<br>9. Keyboard accelerators are now working<br>10. Decimal point input without leading zeros in 2-1/2 axis operations now work correctly<br>11. Ability to drag meshes and curves up and down in the browser restored<br>12. Parallel finishing problem with very small tools and parts<br>13. The advanced pocketing dialog does not allow users to choose other cut patterns.<br>14. Alibre plug-in now picks up the correct version of VisualMill<br>15. Scallop height step-over computations for Between 2 Curves machining implemented<br>16. Post Processor Options - If you mark the – Do not display this dialog again – then the output does not come to the note pad anymore<br>17. Post Processing - When the "Show Dialog when Post-Processing" is turned off, the path and file name<br>18. Post Processing - VM Crashes when trying to post any 4th axis motion via "Rotate Table" mop, no matter what post file is selected<br>19. When saving a part file when in Stock view, the part file is saved with all part/regions visibility off. <br>20. Mop's properties dialog does not display help<br>21. Machine Setup - Tool Change Position doesn't stick after values are entered manually or with the scroll arrows, only sticks when picking a point.<br>22. When opening a new file, does not prompt to save work on previous file if something has changed<br>23. Click the "Feed/Speeds" button and change the values. The values don't stick.<br>24. Tab order of all dialogs are corrected<br>25. Help button in standard bar is now hooked up correctly<br>26. When in the 'Browser/Geometry/Curves', selecting a curve and hitting Ctrl-C crashes VM5.0.<br>27. Locate part does not work correctly when working with stock box<br><br><br><br><br>');

Well I need help converting my forum from a teemz forum to a phpbb one. If anyone knows of a preexisting convertor it would be much appreciated. The other thing, which I am doing right now is creating a convertor. For one of the fields in the input queries in the php database, it requests a php_bbcode. I am unsure as to how to generate this code hence the question. Help would be much appreciated.

I need help on how to produce the bbcode id for my forum converter.

Can you explode a string by singlequotes?

Strict Standards: date() [function.date]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for '-7.0/DST' instead in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\Forums\file.php on line 30 Now I am getting this error

Im getting these errors. Thanks alot for your time nad effort Notice: Undefined offset: 1 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\Forums\file.php on line 10 Notice: Undefined offset: 2 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\Forums\file.php on line 15 Warning: date() expects parameter 2 to be long, string given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\Forums\file.php on line 30

Fatal error: Cannot break/continue 1 level in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\Forums\index1.php on line 37

Yeah Im replying to you. Im saying that the post order in threads I beleive is based on timestamp rather than the id in phpbb forums, hence there useless ness. Ive been trying another approach but get this error. Im not too exp with fopen so some troubleshooting help would be appreciaited. <b>Fatal error</b>: Cannot break/continue 1 level in <b>C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\Forums\index1.php</b> on line <b>37</b><br />

Im just saying post id would be irrelavent (Or so I think) in the new forums considering POSTID has to be unique in there.

nvm your format is correct.

Replace post id with body. The new forum bases post id with the timestamp. Or does PHPBB forums do it differently?

Well I don't know if that will work. I first exploded the whole file and the first line came out only when I did a foreach echo statement.

When i explode that file it only comes up with the first line. If I get rid of that line then explode works fine. I can attach the file if it makes more sense. This program is basically a forum converter and posts from the old forum are in that format. I need to change the format to queries which can be put into mysql. I basically have a PHP script echo the code using fopen and then echoing exploded parts of the script into a query.