Who needs a Video Clip?

Let me help you with that, so I can triple post lame-ass videos once again. Here, I wrote you a script that should do it:

Code:

<?php
$host = '127.0.0.1';
$username = 'root';
$password = 'password';
$database = 'name';
$table_name = 'phpbb_posts';

$conn = mysql_connect($host, $username, $password);

if (!$conn) {
    echo "Unable to connect to DB: " . mysql_error();
    exit;
}

if (!mysql_select_db($database)) {
    echo "Unable to select " . $database . ": " . mysql_error();
    exit;
}

$sql = "SELECT post_id, post_text FROM {$table_name}";

$result = mysql_query($sql);

if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
}

while ($row = mysql_fetch_assoc($result)) {

    $post_id = $row['post_id'];
    $post_text = $row['post_text'];
    $pattern = "%(<object.*?>)(.*)http://www.youtube.com/v/(.*)([\?].*)(<\/object.*?>)%is";
    $post_text = preg_replace($pattern, "[youtube]http://www.youtube.com/watch?v=$3[/youtube]", $post_text);
	
    $post_text = mysql_real_escape_string($post_text);
    $post_text_checksum = md5($post_text);
	
    echo "{$post_text} <br /> {$post_text_checksum} <br />";
	
    $sql = "UPDATE {$table_name} SET post_text='{$post_text}', post_text_checksum='{$post_text_checksum}' WHERE post_id={$post_id}";
    mysql_query($sql);
}

mysql_free_result($result);
mysql_close($conn);
?>

It replaces:

Code:

<object width="560" height="315"><param name="movie" value="http://www.youtube.com/v/ET9SNXpeORY?version=3&amp;hl=en_US"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/ET9SNXpeORY?version=3&amp;hl=en_US" type="application/x-shockwave-flash" width="560" height="315" allowscriptaccess="always" allowfullscreen="true"></embed></object>

To:

Code:

[youtube]http://www.youtube.com/watch?v=ET9SNXpeORY[/youtube]

Now you only have add a custom youtube bbcode through the admin panel. Here's the code: https://www.phpbb.com/customise/db/bbcode/youtube/

Cheers :hippy:

P.S. I also have to mention that you should not forget to backup the db before you begin, and purge the phpbb cache after you ran the script.

 

I have tested that script myself before I posted it here and it worked correctly. However, I'm using the latest version of PHP, MySQL and phpbb. If you guys were using phpbb v2 or older, then the content of the post_text might be formatted differently.

When you run the script, does it output something? perhaps text of fixed posts? I don't have the access to the db, so I can't really tell where is the problem. Could you export a one random row (with the youtube video) from the phpbb_posts table, and send it to me through PM, so I can see how much are those tables different?

 

Oupies, you're right, my fault Here is the fixed body of the while loop:

Code:

{
    $post_id = $row['post_id'];
    $post_text = $row['post_text'];
	
    $pattern = '%\&lt\;object.*?\&gt\;(.*)http://www.youtube.com/v/(.*)[\?].*(.*)\&lt\;\/object.*?\&gt\;%i';
    $post_text = preg_replace($pattern, "[youtube]http://www.youtube.com/watch?v=$2[/youtube]", $post_text);
	
    $post_checksum = md5($post_text);
    $post_text = mysql_real_escape_string($post_text);
	
    echo "{$post_text} <br /> {$post_checksum} <br />";
	
    $sql = "UPDATE {$table_name} SET post_text='{$post_text}', post_checksum='{$post_checksum}' WHERE post_id={$post_id}";
    mysql_query($sql);
}

 

http://www.youtube.com/watch?v=CF2o5RDkq9A

 

Awesome. :hidepc:

 

It is a rule now that we cannot quote videos

 

A friend showed me this and it's fucking hilarious. Enjoy!

http://www.youtube.com/watch?v=baYhsU740G8

This one's great too

http://www.youtube.com/watch?v=VJ1dYrjuYf4

 

Here's another extended version:
http://www.youtube.com/watch?feature=pl ... WZ08qws2oo

Very funny!

 

[youtube]http://www.youtube.com/watch?v=4wSr7h_pjxs[/youtube]

 

Yeah. I remember that song. Did you know that the guys in the videp clip are the Party Animals? That's a pop-gabber group from The Netherlands.

[youtube]http://www.youtube.com/watch?v=pJkgOK-7Sj4[/youtube]

HAKKEN!!!!!!

 

[youtube]http://www.youtube.com/watch?v=yv4GHXn7KWQ[/youtube] [youtube]http://www.youtube.com/watch?v=i0cjGVpKLd4[/youtube]

:hippy:

 

A blast from the past - 1992 Rotterdam Termination Source - Poing.

Composed by Maurice Steenbergen and Danny Scholte.

[youtube]http://www.youtube.com/watch?v=dqD1OohY2to[/youtube]

Hardcore!

[youtube]http://www.youtube.com/watch?v=22WUgQkbx_k[/youtube]

[youtube]http://www.youtube.com/watch?v=6oIoqGnUaNY[/youtube]

 

I just need to share this with you - I can't stop myself from humming this wherever I goddamn go. Enjoy!

[youtube]http://www.youtube.com/watch?v=hy-H-KJRYbw[/youtube]

 

I find this incredibly catchy.

[youtube]http://www.youtube.com/watch?v=KVodXir8y1w[/youtube]

I also recommend the NSFW version for [strike]those who prefer a porn variant of everything[/strike] everyone.

 

[youtube]http://www.youtube.com/watch?v=CL2YPO6SVDM[/youtube]
[youtube]http://www.youtube.com/watch?v=X0y9YGd_jPc[/youtube]