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 |
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 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 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 |
Author: | Vae Victis [ Sun Feb 10, 2008 2:34 pm ] |
Post subject: | Re: Moving to PHPBB3 |
elguaxo wrote: 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 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 |
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: 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 |
Author: | Venom [ Sun Feb 10, 2008 4:22 pm ] |
Post subject: | Re: Moving to PHPBB3 |
El Mariachi wrote: elguaxo wrote: :Don: If Lux adds it to the smiley section you can use it all you want I might just make it bigger though |
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 |
Author: | Vae Victis [ Sun Feb 10, 2008 4:40 pm ] |
Post subject: | Re: Moving to PHPBB3 |
Code: :don: |
Author: | El Mariachi [ Sun Feb 10, 2008 4:51 pm ] |
Post subject: | Re: Moving to PHPBB3 |
Author: | Vae Victis [ Sun Feb 10, 2008 4:51 pm ] |
Post subject: | Re: Moving to PHPBB3 |
Author: | Zissou [ Sun Feb 10, 2008 4:53 pm ] |
Post subject: | Re: Moving to PHPBB3 |
Author: | El Mariachi [ Sun Feb 10, 2008 5:00 pm ] |
Post subject: | Re: Moving to PHPBB3 |
Vae Victis wrote: |
Author: | vohi [ Sun Feb 10, 2008 5:05 pm ] |
Post subject: | Re: Moving to PHPBB3 |
ahahahahahahhaha hahahhaha OMGGG |
Author: | elguaxo [ Sun Feb 10, 2008 5:11 pm ] |
Post subject: | Re: Moving to PHPBB3 |
Author: | Lux Delux [ Sun Feb 10, 2008 5:14 pm ] |
Post subject: | Re: Moving to PHPBB3 |
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 up... |
Author: | Sammy Stallion [ Sun Feb 10, 2008 6:53 pm ] |
Post subject: | Re: Moving to PHPBB3 |
Aarghh.... |
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... |
Author: | Vae Victis [ Sun Feb 10, 2008 7:37 pm ] |
Post subject: | Re: Moving to PHPBB3 |
oh thats cause of me, doing a 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. Pure wrote: Should it be fixed? Maybe more new registrations this way... |
Author: | ^Rogue^ [ Sun Feb 10, 2008 7:41 pm ] |
Post subject: | Re: Moving to PHPBB3 |
Great smiley btw |
Author: | elguaxo [ Sun Feb 10, 2008 7:45 pm ] |
Post subject: | Re: Moving to PHPBB3 |
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? |
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 |
Page 3 of 5 | All times are UTC + 1 hour [ DST ] |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group https://www.phpbb.com/ |