Itsuki Minami
New Member
u_u long time without having problems but well now i got one, well after I make vbtubepro work with megavideo everything was alright but as many of you have noticed megavideo changed the player, the script still works but in the process of upgrading megavideo, megavideo erased many of their thumbnails so now i got like 600 thumbs that don't load i'm replacing them little by little but in the meantime I want to put a image that says Broken Thumbnail, now the problem is i don't want to go with eash video to change the thumb will be a long an tedious work so i searched about search and replace in mysql, and i founded this:
the problem with my comand is that i want to replace every img line that has http://imgX.megavideo.com/imgurl.jpg where x is the id of the megavideo server because not every server is the same and every jpg has a different autogereated id i wanted to use the comodin but seems is not working, any suggestions? xD and sorry for writing so along thread xD
PD: i use mysql 5.0
Code:
update 'vb_vbtube_tubes' set 'link1img' = replace(link1img,'%img%','www.mysite.com/images/thumbroto.png')the problem with my comand is that i want to replace every img line that has http://imgX.megavideo.com/imgurl.jpg where x is the id of the megavideo server because not every server is the same and every jpg has a different autogereated id i wanted to use the comodin but seems is not working, any suggestions? xD and sorry for writing so along thread xD
PD: i use mysql 5.0