You are not logged in.
Pages: 1
For small boards is there some kind of "rent a geek" thread?
Apologies as I did not see any other place to post this - but it must be a common query I guess!
I have small hobbyist board of 3000 members and the Moderators and I are not really tech minded at all – re php especially – it is all a foreign language to most of us.
We have set it up for years, it has members, we get quite a few posts, and we PRAY things run along pretty smoothly.
One moderator backs up the data base each day which is a blessing!
We are a bit nervous to update from current version 3.0.4, to most recent version 3.0.6 in case something goes wrong.
Our main issue is - we have a lot of images posted on the site all hosted in photobucket – posted by many different members.
We are trying to work out a way to somehow get 1,000s of those photobucket links saved to our server, so that we host them and not photobucket as when folks are inactive with photobucket for 90 days (lots of them!), the link on there they posted is effectively dead – totally messing up threads.
Is there some universal “sweep” that can be done to achieve this across the database????
And from then on we need all new images to be hosted on our server, and not on photobucket only – as we now do. That seems to be possible with our avatars, but not photos in threads.
The tech knowledge on this board is awesome, and I am probably the only one posting here who is not tech savvy enough to do these small mods and tweaks, but that is the fact of the matter.
But surely there are some tech savvy folks who might for some bucks offer to assist out for a few hours here and there – I hope I am allowed to ask here on that – apologies in advance if it breaks any rule - mods will move or edit it I am sure it it does. 
Please email me at ozstamps[at]gmail.com if you can help, or suggest anyone reliable who might have a few hours here and there to hold our hands here!
It is hardly the thing you can look in Craig’s List for – “phpbb geek wanted for a few hours now and again”. 
At least if we locate someone through here I can see from their post numbers they are pretty reliable and known here, and that is important.
Thanks for reading, and do hope someone can assist in some way! We did have a helpful guy in Florida who helped out but he has gone AWOL.
Offline
Beware, when you upgrade to 3.0.6 you will need to find a 3.0.6 compatible template for your board. Alot of sites lost their "more smileys" (easy fix) and polls (not so easy fix) when upgrading to 3.0.6 .
So yeah, make sure your template is 3.0.6 compatible.
Another thing to do is just disallow people to post images from image hosts that expire inactive accounts. It's horse puckey that they can't keep seldom used images hosted, because at todays storage prices, keeping a 10K image around costs a literal micropenny.
My friend Michele at http://www.michelespaintshop.com/forum allows users to upload images, and subscribed members can see and download them, but to save bandwidth, and offsite linking abuse, unless you are logged into the board, they are not shown. You might consider that.
Your universal sweep of photobucket (I have a much nastier name for them due to the same behavior you wish to avoid), may be doable, but you need a MySQL guru for it. That I am not. you might google image search ' "photobucket.com" site:yoursite.com ' (with the double quotes, minus the apostrophes) . That could expose a bunch of it.
This site is NOT a phpbb support forum, but I understand your frustration. Try my friend Miche's site mentioned above. She should be able to help you out. (My site is not image intensive so I don't care where images are hosted.)
Zap
Offline
something like
select * from phpbb_posts where post like '%photobucket%';
should work, given `phpbb_posts` and `posts` are the valid tables and columns
Offline
Pages: 1
