|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
Hey, After I imported my phpBB forum software to VBulletin, I need to fix all of my custom BB Codes. One of my BB codes is for WorldStarHipHop videos. This is the BB Code I used to use for my phpBB forum: Code: [wshh]http://www.worldstarhiphop.com/videos/video.php?v=wshhvpf7qedV84D9BUqV[/wshh] But here is the code I have to use for my VBulletin forum: Code: [wshh]wshhvpf7qedV84D9BUqV[/wshh] Instead of editing every single one of my forum threads, I am going to use MYSQL to replace the characters. Here are some of the codes I have tried: Code: UPDATE post SET pagetext = replace( pagetext, substring( pagetext, locate( '[wshh]http://www.worldstarhiphop.com/videos/video.php?v=', pagetext ) , 55 ) , '[wshh]http://www.worldstarhiphop.com/videos/video.php?v=' ) WHERE LOCATE( '[wshh]', pagetext ) >0; and: Code: UPDATE post SET pagetext = replace( pagetext, substring( pagetext, locate( '[wshh]http://www.worldstarhiphop.com/videos/video.php?v=%', pagetext ) , 56 ) , '[wshh]http://www.worldstarhiphop.com/videos/video.php?v=%' ) WHERE LOCATE( '[wshh]', pagetext ) >0; But none have worked. Does anyone know how I can do this? Hope you understand, thanks ![]() |
![]() |
مواقع النشر (المفضلة) |
| |