Forum

This forum is now read-only. Support is provided at https://wordpress.org/support/plugin/sermon-browser/

Please consider registering
guest
sp_LogInOut Log Insp_Registration Register
Register | Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Feed Topic RSSsp_TopicIcon
Global video embed size replace
15 January, 2015
3:54 pm
Mark Phillips
Member
Members
Forum Posts: 10
Member Since:
15 January, 2015
sp_UserOfflineSmall Offline

I'm in the processing of moving all sermons from an old site to a new one I'm developing. I can't find the video embed code anywhere in the database. Does that mean it's encrypted/encoded?

I was hoping to be able to do a global replace to resize all videos to suit the new site dimensions.

Can it be done?

Thanks

17 January, 2015
12:16 am
Extrafino
Enthusiast
Members
Forum Posts: 43
Member Since:
5 July, 2013
sp_UserOfflineSmall Offline

I do not have any videos in SermonBrowser, but since you can't upload videos to SermonBrowser, the embed codes have to be in the database. Look in sb_sermons for the id of the sermon. Then look for that id in the field "sermon_id" in the table sb_stuff. The field "name" should contain the embed code for the video.

18 January, 2015
4:01 pm
Mark Phillips
Member
Members
Forum Posts: 10
Member Since:
15 January, 2015
sp_UserOfflineSmall Offline

Thanks. I can see what I think is the embed code but it's not in an editable form. Other attachments are but not video embed codes :(

18 January, 2015
8:55 pm
Extrafino
Enthusiast
Members
Forum Posts: 43
Member Since:
5 July, 2013
sp_UserOfflineSmall Offline

What does an uneditable form look like?

18 January, 2015
9:04 pm
Mark Phillips
Member
Members
Forum Posts: 10
Member Since:
15 January, 2015
sp_UserOfflineSmall Offline

Something like this:

PGlmcmFtZSBzcmM9Imh0dHA6Ly9wbGF5ZXIudmltZW8uY29tL3ZpZGVvLzY3NTUxOTQwIiB3aWR0aD0iNTAwIiBoZWlnaHQ9IjM3NSIgZnJhbWVib3JkZXI9IjAiIHdlYmtpdEFsbG93RnVsbFNjcmVlbiBtb3phbGxvd2Z1bGxzY3JlZW4gYWxsb3dGdWxsU2NyZWVuPjwvaWZyYW1lPg==

18 January, 2015
9:33 pm
Extrafino
Enthusiast
Members
Forum Posts: 43
Member Since:
5 July, 2013
sp_UserOfflineSmall Offline

OK, I get it now. SermonBrowser saves embed codes using base64_encode, that's where the jumbled mess comes from.

You can see what the code is using tools like this http://www.tools4noobs.com/onl.....64_decode/

But that makes it hard to do a global resize.

Maybe changing a containing div via css would be an option

18 January, 2015
9:38 pm
Mark Phillips
Member
Members
Forum Posts: 10
Member Since:
15 January, 2015
sp_UserOfflineSmall Offline

Thanks. Can you resize a video with div/css? Will it not just overflow?

18 January, 2015
9:42 pm
Mark Phillips
Member
Members
Forum Posts: 10
Member Since:
15 January, 2015
sp_UserOfflineSmall Offline

Actually, found this:

http://webdesignerwall.com/tut.....tic-videos

Will give it a go.

18 January, 2015
10:58 pm
Mark Phillips
Member
Members
Forum Posts: 10
Member Since:
15 January, 2015
sp_UserOfflineSmall Offline

Finally got it working. For anyone else interested, I had to use jQuery :

http://stackoverflow.com/quest.....ing-jquery

And how to add a jQuery script to WordPress:

http://stackoverflow.com/quest.....-wordpress

19 January, 2015
4:52 am
Extrafino
Enthusiast
Members
Forum Posts: 43
Member Since:
5 July, 2013
sp_UserOfflineSmall Offline

Glad you worked it out

Forum Timezone: Europe/London
Most Users Ever Online: 381
Currently Online:
Guest(s) 2
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Rich Brown: 358
Matt Schlueter: 93
Mindy: 72
Don Johnson: 65
anointed: 57
0be1: 55
Member Stats:
Guest Posters: 7
Members: 3188
Moderators: 1
Admins: 1
Forum Stats:
Groups: 1
Forums: 2
Topics: 1713
Posts: 7499
Newest Members:
marktest, deatles50, ValeriaGoodriz, dapedPup, oapedPup, Margarettoimb
Moderators: Ben Miller: 1628
Administrators: Mark Barnes: 435