Hall of Fame

[Marius P.]

Manual changes apply to :


- vibe_config.php
- .htaccess (main in root)
- database





root/vibe_config.php:
Add

Code Select Expand

define( 'page', 'read' );
define( 'embedcode', 'embed' );

after

Code Select Expand

// SEO url structure

Save the vibe_config.php file and keep it.



.htaccess file : (main one, near load.php)


Add

Code Select Expand

RewriteRule ^embed/([^/]*)/$ /embed.php?id=$1 [L]

After

Code Select Expand

RewriteBase /

Database changes:

Code Select Expand

ALTER TABLE  `#db-prefix#videos` ADD  `token` VARCHAR( 255 ) NOT NULL AFTER  `id` ;
ALTER TABLE  `#db-prefix#videos` ADD  `tmp_source` MEDIUMTEXT NOT NULL AFTER  `source` ;
ALTER TABLE  `#db-prefix#videos` CHANGE  `pub`  `pub` INT( 11 ) NOT NULL DEFAULT  '0';
CREATE TABLE IF NOT EXISTS `#db-prefix#ads` (
  `ad_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ad_spot` varchar(64) NOT NULL DEFAULT '',
  `ad_type` varchar(64) NOT NULL DEFAULT '0',
  `ad_content` longtext NOT NULL,
  `ad_title` varchar(64) NOT NULL,
  `ad_pos` varchar(64) NOT NULL,
  PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
 
 
CREATE TABLE IF NOT EXISTS `#db-prefix#pages` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `menu` int(11) NOT NULL DEFAULT '0',
  `date` text COLLATE utf8_swedish_ci NOT NULL,
  `title` varchar(300) COLLATE utf8_swedish_ci NOT NULL,
  `pic` longtext COLLATE utf8_swedish_ci NOT NULL,
  `content` longtext COLLATE utf8_swedish_ci NOT NULL,
  `tags` varchar(500) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=0 ;

Replace BEFORE using the sql code #db-prefix# to your actual prefix , ex : vibe_


Overwrite all files except /vibe_config.php
Chmod the new now folder /rawmedia to writeable (ex: 0777)

[Marius P.]

If you are not familiar with sql you can use this:


1. Create a file called up.php


with the following content:

Code Select Expand

<?php  error_reporting(E_ALL); 
//Vital file include
require_once("load.php");
 
 
$db->query("ALTER TABLE  `".DB_PREFIX."videos` ADD  `token` VARCHAR( 255 ) NOT NULL AFTER  `id`");
$db->query("ALTER TABLE  `".DB_PREFIX."videos` ADD  `tmp_source` MEDIUMTEXT NOT NULL AFTER  `source`");
$db->query("ALTER TABLE  `".DB_PREFIX."videos` CHANGE  `pub`  `pub` INT( 11 ) NOT NULL DEFAULT  '0'");
$db->query("CREATE TABLE IF NOT EXISTS `".DB_PREFIX."ads` (
  `ad_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ad_spot` varchar(64) NOT NULL DEFAULT '',
  `ad_type` varchar(64) NOT NULL DEFAULT '0',
  `ad_content` longtext NOT NULL,
  `ad_title` varchar(64) NOT NULL,
  `ad_pos` varchar(64) NOT NULL,
  PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ");
 
 
 
 
$db->query("CREATE TABLE IF NOT EXISTS `".DB_PREFIX."pages` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `menu` int(11) NOT NULL DEFAULT '0',
  `date` text COLLATE utf8_swedish_ci NOT NULL,
  `title` varchar(300) COLLATE utf8_swedish_ci NOT NULL,
  `pic` longtext COLLATE utf8_swedish_ci NOT NULL,
  `content` longtext COLLATE utf8_swedish_ci NOT NULL,
  `tags` varchar(500) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=0 ");
 
 
$db->debug();
?>

2. Upload up.php in your PHPVibe root (near load.php)
3. Run up.php in browser, ex: yourinstall.com/up.php it should show you an errorless debug.
4. Delete up.php from server.


this php file will make the sql changes for the upgrade.

[Noel]

Will you post the download link here?

[Marius P.]

I will add it in the pack on the store.

[Marius P.]

It's uploaded.

[Noel]

Congratulations with the new release!! ... But I can not find it :/

[Marius P.]

Download http://store.phprevolution.com/buy.php?id=14 It's in the zip

[Noel]

Got it... phpvibe_cms.zip

Let make some backups 1st and than install it.

Will report back.

[Marius P.]

Ok, I'm here for another 2h , after that going in vacation, no more internet.

[Noel]

Update done (no problems)
Now it's testing time....

Will report back

[Marius P.]

Make sure the two crons have execute permissions set, videocon.php and cron.php and the php bin path it's set in admin.

[Noel]

Till now I've not been using the crons.
Any extra info on how to set this up?

The Scheduled tasks (Crons management) is showing: No crons yet
How do I add the crons to this?

Also.. Have a nice holiday! You (and rest of team) deserves it!

[Marius P.]

Thank you! Same to you!
If you don't use the cron, but use conversion with ffmpeg, you need to setup the videocron.php to be executable from php.


You also need exec and shell_exec enabled for ffmpeg (plus de actual ffmpeg and plugins).


Just try, if it doesn't work, you'll know why and what to do

[Noel]

That should be okay on my server.

You also need exec and shell_exec enabled for ffmpeg (plus de actual ffmpeg and plugins).

I'm getting this with videocron.php: Warning: Unknown column 'tmp_source' in 'field list' in /var/www/clients/client1/web102/web/lib/class.ezsql.php on line 249

Going to give it some more testing tomorrow.
I will get it working!

One more question. How do I add a scheduled task to the admin?

[Marius P.]

My bad!


run this in bd:

Code Select Expand

ALTER TABLE `vibe_videos` ADD `tmp_source` MEDIUMTEXT NOT NULL AFTER `source` ;

change vibe_ to your prefix.

[Marius P.]

I've updated the db.sql in setup and first post here...idk how I've missed that :|

[Noel]

That fixed the warning!
Does FFMPEG leave a log? Looks like something is not working here as the uploaded MP4 does not convert.
Where does it get moved to after conversion?

[Marius P.]

It doesn't convert .mp4, I've added a skip to it for .mp4 files as per the discussions in development, just the other formats in .mp4

It uploads to /rawmedia and moves to /media if you don't change the folders in admin.

[Marius P.]

You can edit lib/upload-ffmpeg.php

and change

Code Select Expand

if($ext !== "mp3" && $ext !== "mp4") {

to

Code Select Expand

if($ext !== "mp3") {

and you get the same processing/conversion/recoding for .mp4 files.

[Noel]

Will do..

And now.. it's time for you to shutdown that PC and go on your holiday!

L8ter......

[Marius P.]

Yeah Thanks! Merry Christmas!

[Noel]

You to.. Happy Holidays


And.. My PHP5 is not in "/usr/bin/php5"
Will change it to the correct place.

[Noel]

LOL...

I'm testing this on one of my servers that does not have FFMPEG :-)
And me thinking .. w.t.f. can be wrong ......
Pffff.. who needs a holiday now :-/

[Fleswodka]

MARIO TYTYTY you rock!! love to see its your passion!!

[Marius P.]

MARIO TYTYTY you rock!! love to see its your passion!!

Thank you! Please report any issue with this so I can patch it before New Year's.

Pffff.. who needs a holiday now :-/

I honestly do, I have 5 months of work straight on 3 projects and I really need a break, and Alex and Natali from here as well.