So Bad It's Good FoRuM
https://sbig.dead-donkey.com/

Moving to PHPBB3
https://sbig.dead-donkey.com/viewtopic.php?f=32&t=10587
Page 3 of 5

Author:  Vae Victis [ Sun Feb 10, 2008 2:01 pm ]
Post subject:  Re: Moving to PHPBB3

Vae Victis wrote:
Another bug is the ed2k. they've been reparsed during the conversion.
And are borked now.

I should've a fix script for that somewhere...

Not found it yet :probe:

Author:  El Mariachi [ Sun Feb 10, 2008 2:15 pm ]
Post subject:  Re: Moving to PHPBB3

Lux Delux wrote:
My prime achievement was installing it :ohshit:


I'm his witness... he was screaming for cock, because he was nervous... But I wouldn't let him.

Author:  elguaxo [ Sun Feb 10, 2008 2:18 pm ]
Post subject:  Re: Moving to PHPBB3

Vae Victis wrote:
Not found it yet :probe:


This? http://www.phpbb.com/community/viewtopi ... 3#p3180263

Author:  Lux Delux [ Sun Feb 10, 2008 2:32 pm ]
Post subject:  Re: Moving to PHPBB3

Just noticed we need to add the topic descriptions again :teeth:

Author:  Vae Victis [ Sun Feb 10, 2008 2:34 pm ]
Post subject:  Re: Moving to PHPBB3

elguaxo wrote:
Vae Victis wrote:
Not found it yet :probe:


This? http://www.phpbb.com/community/viewtopi ... 3#p3180263

No, it's already working.

Problem is the conversion, phpbb3 converts the old posts and fucks the ed2k links up.
I had a script somewhere I used to fix the links on my forum. But forgot where I put it.

Author:  elguaxo [ Sun Feb 10, 2008 2:38 pm ]
Post subject:  Re: Moving to PHPBB3

My post links to the 11th post of that thread:

DonGato wrote:
As I already did this code if someone can try it when he/she has the same problem as Tmac.
Just take in account the conversion is commented out, it outputs some data for visual confirmation and it's limited to two results.

Code:
    <?php

       // Connects to DB
       $db_connect_id = mysql_connect('localhost', 'username', 'password') or die('Connection Failure to Database');
       mysql_select_db('arforum', $db_connect_id) or die ('Database not found.');

       // Sets Character Encoding
       mysql_query('SET NAMES utf8') or die('Failed setting connection character enconding (utf8)');

       // Gets data [remove "LIMIT 0,2" for conversion]
       $result = mysql_query("SELECT post_id, post_text FROM phpbb_posts WHERE post_text LIKE '%ed2k:/%' LIMIT 0,2") or die('Failed obtaining post');

       // Loop
       while ($row = mysql_fetch_row($result))
       {
          // Check - Bad Post [comment out these 3 lines for conversion]
          echo '<B>OLD POST</B><BR><BR>';
          echo $row[1];
          echo '<BR>-----------------------------------------------------------------------<BR><BR>';

          // Replaces data
          $text = eregi_replace('<!-- m --><a class="postlink" href="ed2k.*">', '', $row[1]);
          $text = str_replace('|/</a><!-- m -->', '|/', $text);
          $text = str_replace("'", "''", $text);

          // Check - Fixed Post [comment out these 3 lines for conversion]
          echo '<B>NEW POST</B><BR><BR>';
          echo $text;
          echo '<BR>-----------------------------------------------------------------------<BR><BR>';

          // Updates DB [uncomment line for conversion]
    //      mysql_query("UPDATE phpbb_posts SET post_text = '" . $text . "' WHERE post_id = '" . $row[0] . "'") or die('Failed updating post');
       }

       // Closes connection to DB
       mysql_close($db_connect_id);

       // Done
       echo '<br><br>Conversion done!<br><br>';

    ?>

Author:  Vae Victis [ Sun Feb 10, 2008 2:59 pm ]
Post subject:  Re: Moving to PHPBB3

Oh that, didn't read the topic :lol:

Basic is the same:
Code:
include ( "class_database.php" ) ;

$db = new Database ;

$sql = 'SELECT post_id, post_text FROM `phpbb3_posts` WHERE post_text LIKE \'%[^<]*<\/a>/', '$1', $msg);
$sql = "UPDATE phpbb3_posts SET post_text = '". addslashes ( $msg ) ."' WHERE post_id=".$value['post_id'];
$db -> QueryPut ( $sql ) ;
}
?>

Found it again, in the trash dir of server.

And also ran it just now. Afaik the ed2k links should be fixed now.

Author:  enterlexx [ Sun Feb 10, 2008 4:09 pm ]
Post subject:  Re: Moving to PHPBB3

:D ouch
work in progress?
as the site looks 800x600 or something with grey borders left and right (1280x1024 on my 19" monitor)

Author:  El Mariachi [ Sun Feb 10, 2008 4:18 pm ]
Post subject:  Re: Moving to PHPBB3

elguaxo wrote:
:Don:


Image

If Lux adds it to the smiley section you can use it all you want
I might just make it bigger though

Author:  elguaxo [ Sun Feb 10, 2008 4:19 pm ]
Post subject:  Re: Moving to PHPBB3

:cracked: :cracked: :cracked:

Author:  Venom [ Sun Feb 10, 2008 4:22 pm ]
Post subject:  Re: Moving to PHPBB3

El Mariachi wrote:
elguaxo wrote:
:Don:


Image

If Lux adds it to the smiley section you can use it all you want
I might just make it bigger though


:cracked:

Author:  El Mariachi [ Sun Feb 10, 2008 4:30 pm ]
Post subject:  Re: Moving to PHPBB3

Here's a better don. I demand it to be a great fucking smiley

Image

Author:  Vae Victis [ Sun Feb 10, 2008 4:40 pm ]
Post subject:  Re: Moving to PHPBB3

Code:
:don:

:don:

Author:  El Mariachi [ Sun Feb 10, 2008 4:51 pm ]
Post subject:  Re: Moving to PHPBB3

:don: :don: :don:

x) :cracked: :cracked: :cracked:

Author:  Vae Victis [ Sun Feb 10, 2008 4:51 pm ]
Post subject:  Re: Moving to PHPBB3

:piss1: :don: :piss2:

Author:  Zissou [ Sun Feb 10, 2008 4:53 pm ]
Post subject:  Re: Moving to PHPBB3

:don: :cracked:

Author:  El Mariachi [ Sun Feb 10, 2008 5:00 pm ]
Post subject:  Re: Moving to PHPBB3

Vae Victis wrote:
:piss1: :don: :piss2:


:cracked: :cracked: :lol:

Author:  vohi [ Sun Feb 10, 2008 5:05 pm ]
Post subject:  Re: Moving to PHPBB3

:don: ahahahahahahhaha
hahahhaha
OMGGG :bang: :bang: :bang: :bang: :bang:
:bow: :bow: :bow: :bow: :cracked: :cracked: :cracked: :cracked: :cracked: :lol: :lol: :lol: :lol:

Author:  elguaxo [ Sun Feb 10, 2008 5:11 pm ]
Post subject:  Re: Moving to PHPBB3

:don: :scored:

Author:  Lux Delux [ Sun Feb 10, 2008 5:14 pm ]
Post subject:  Re: Moving to PHPBB3

:cracked: :cracked: :cracked: :cracked: OMG

Author:  Sammy Stallion [ Sun Feb 10, 2008 6:53 pm ]
Post subject:  Re: Moving to PHPBB3

Congrats on the new layout, guys. May a big brown star always shine upon you.
I hope my nude pianist didn't get :wild: up...

Author:  Sammy Stallion [ Sun Feb 10, 2008 6:53 pm ]
Post subject:  Re: Moving to PHPBB3

Aarghh.... :pork: :censored: :censored:

Author:  ^Rogue^ [ Sun Feb 10, 2008 7:31 pm ]
Post subject:  Re: Moving to PHPBB3

Friend of mine's telling me the ed2k links don't work when you're not logged in. Can this be fixed?

Author:  Pure [ Sun Feb 10, 2008 7:34 pm ]
Post subject:  Re: Moving to PHPBB3

Should it be fixed? Maybe more new registrations this way... :ele:

Author:  Vae Victis [ Sun Feb 10, 2008 7:37 pm ]
Post subject:  Re: Moving to PHPBB3

oh thats cause of me, doing a :don: on you all.


fixed

Author:  ^Rogue^ [ Sun Feb 10, 2008 7:41 pm ]
Post subject:  Re: Moving to PHPBB3

Thanks Vae, you can milk me now. :bow: :dicky:

Pure wrote:
Should it be fixed? Maybe more new registrations this way... :ele:


:spank:

Author:  ^Rogue^ [ Sun Feb 10, 2008 7:41 pm ]
Post subject:  Re: Moving to PHPBB3

Great smiley btw :don:
:cum: :cum: :cum:

Author:  elguaxo [ Sun Feb 10, 2008 7:45 pm ]
Post subject:  Re: Moving to PHPBB3

:don:

Author:  Vae Victis [ Sun Feb 10, 2008 11:20 pm ]
Post subject:  Re: Moving to PHPBB3

Html is allowed for global moderators only now.

Seems to work. Except that in collection threads the ed2k link is still borked..
Who ever thought of making that an html link? :lol:

Author:  Vae Victis [ Sun Feb 10, 2008 11:21 pm ]
Post subject:  Re: Moving to PHPBB3

Well my James Bond collection survived and thats the most important thing :lol:

Page 3 of 5 All times are UTC + 1 hour [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
https://www.phpbb.com/