indie

That's all Greek to me. Looking for someone to post it for me, can pay.

Unfortunately nothing, that's why I am asking. This is not my skill department. But I can surely paste a query lol. What I need is a regex code to change the above. So where the **** would be 6453, in the below code, the **** would also be 6453. So all it keeps is the attachment number. Thanks!

Not two codes no. Yes, looking for regex to take care of it.

I am trying to change this [sharedmedia=core:attachments:****] into this [ATTACH]****[/ATTACH] And leave the same numbers intact, the *s are unique numbers per post. Thanks for any help!

I'm looking to clean up some old vBulletin BBcode. I want to remove the actual codes and what is between them. So for example, I want to remove: [QT]random text here alpha-numeric etc.[/QT] Thanks!

Thanks! I missed that one.

Thanks I'll try those. 1st one is a mysql query, second is a regex search/replace?

Okay I can use EditPad Lite text editor which has regex. I just don't know what to do in search and replace. ([A-Za-z0-9\-\_]+) I know something like this can be added to the end of the URL to find the video code, but then what? When I click to replace it just adds that regex code to the URL, and it won't highlight the bbcode tag after it for removal. I just want to do this: Thanks

Do you mean PHP can be used to change it in MYSQL? Not familiar with coding. Found this not sure it will help me: http://stackoverflow.com/questions/24261555/removing-bbcode-url-tag-from-string

The purpose is one forum software treats this as an embed not a link (great). Moving to the new software they will be hyperlinks (not great) but if they are plain text with no bbcode they will be embedded after the import and the post task has run.

I need to remove the url wrapper code.

Any help appreciated. So let's say in the db I have: [url]https://www.youtube.com/watch?v=RandomCharactersHere[/url] And I want it to be: https://www.youtube.com/watch?v=RandomCharactersHere I want to remove the URL code but only from youtube links so a replace all will not work unless it knows it is a YT link. Would something like this work? http://stackoverflow.com/a/35584060 So you could append [a-zA-Z0-9] to https://www.youtube.com/watch?v= So code that would essentially say: To trim tail: Find [url]https://www.youtube.com/watch?v=[a-zA-Z0-9][/url] and remove [/url] after string. To trim head: Find [url]https//www.youtube.com/watch...(not sure if I need entire string in this one) remove [url] before string. Would it need to know how many characters the video number was? [a-zA-Z0-9]{8} If so, I could go through however many it could possibly be to change them all. Of course I would also need to do this with url and URL to cover all cases but I could just do it twice, and also the share code https://youtu.be/, but I can figure the share code out once I get this. Thanks for any help!

Can that be used in conjunction with the widget Twitter provides? And if so how? Thanks a lot.

Any help appreciated.

Thanks, but I'm not seeing cache code.

Does anyone know how to cache Tweets as to not reach the API rate limit? I am using the Twitter-provided widget to display multiple profiles on a website, but the API hits the limit of 150 per hour. Is there any way to cache the Tweets and still use this widget? Or does anyone know of a good widget that caches, or simple code? If anyone knows, please explain in newbie terms. Thanks a lot!

Awesome, thanks.

Awesome, so this is possible!! I could also replace with tags, I would just need to put that youtube URL after the first opening tag, and then replace the closing tag. So if I did that instead, the code would be: UPDATE `table` SET `field` = REPLACE(`field`, '[yt]', '[media]http://www.youtube.com/watch?v='), `field` = REPLACE(`field`, '[/yt]', '[/media]') And this: [yt]video_number_here[/yt] Becomes: [media]http://www.youtube.com/watch?v=video_number_here Correct? No spacing, or line break issues? Thanks so much. I'll have to test on a test db before trying live.

I have a forum, and in the db I want to update some bbcode. With the new forum software, when a youtube URL is pasted it embeds. I want to remove the old bbcode, but that will render previous posts unembedded. I have a solution, I just don't know how to do it. I need to do a replace all, similar to that in a text editor. The old bbcode is: [yt]video_number_here[/yt] In a text editor if I search for [yt] and replace all with http://www.youtube.com/watch?v= I get: http://www.youtube.com/watch?v=video_number_here[/yt] Now to remove the end tag, I search for [/yt] and replace all with the replacement field blank, and I get: http://www.youtube.com/watch?v=video_number_here Well that's how it would be done in a text editor, but I have no idea how I would do this in my db. Are there any queries that could do this? And please let me know if they are case sensitive, for the [yt]. Thanks for any help.

Thanks for sharing! Unfortunately I get: Parse error: syntax error, unexpected '{' in ***/contact.php on line 13

Good point. I was hoping it was something someone had that they could share or something someone knew of that they could recommend. If that is not an option I understand. Thanks

I would like a pretty simple email contact form to put on my website. I would like it to show the IP of the sender if possible, and make sure they use a valid email. Fields should be name, username (but not required), and comment. I would like the ability to just paste the code into a website page, and I can style it myself. Thanks

Thanks. Where does that go in the code?

How could I make this code shorten or round the average number to the nearest hundredth? For example: 3.7777777776 would become 3.77, or 3.78 rounded. I'd like the ability for hundredths. Sometimes it shows tenths (3.5) sometimes hundredths (3.75), but don't want any longer than that. Some results are whole numbers, and I don't want it to affect that. 3 should stay 3, not 3.00. Thanks!

Thanks everyone for your help. AbraCadaver, Your code works great, thanks!