|
Importing Custom BBCodes from PHPBB3 Broken, SQL Query Help Needed Hello, I am importing a board from PHPBB3 which had a few custom BBCodes in use. For some reason, impex appends random characters into these bbcodes in posts. For example, Code: [airliners]1746000[/airliners] becomes Code: [airliners:212cgqdu]1746000[/airliners:212cgqdu] I attempted to fix this by modifying an SQL query found in another thread... Code: UPDATE post SET pagetext = replace( pagetext, substring( pagetext, locate( '[airliners', pagetext ) , 17 ) , '[airliners' ) WHERE LOCATE( '[airliners', pagetext ) >0 ...but this still left two stray characters. Can anyone help please? Thanks! |
| الساعة الآن 12:59 AM |
Powered by vBulletin® Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir