Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
3 registered (packlite, Rick, Sirdude), 27 Guests and 24 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/07/06
Posts: 28
Top Posters (30 Days)
Ruben Rocha 103
Rick 81
Mark S 72
Thelockman 56
Gizmo 54
driv 35
ntdoc 32
Sirdude 30
packlite 24
AllenAyres 22
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Page 1 of 9 1 2 3 4 5 6 7 8 9 >
Topic Options
Rate This Topic
#3254 - 09/14/06 04:49 PM PHPBB Importer Impressions
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Well not so many bugs as some needed changes/additions...

First, the import went beautiful, went fast too...

However, there isn't a place for the table prefix for the phpbb database...

The "sort order" of forums is all out of wack, easy enough to update manually, but some users will get a little annoyed...

I'll post back after doign some more playing...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3255 - 09/14/06 04:59 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Well I've gone and looked at various things and it did everything well (other than importing permissions which is designed behavior);...

I'd like to point out that PHPBB has UserGroups as well and would like to request that they be imported to the best of your ability...

I know a lot of sites that use PHPBB and use the usergroups to sort out paid subscribers.. these are large forums that I may be able to pursuade into a faster more reliable product wink...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3256 - 09/14/06 05:03 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Well found first blip... Seems that some members are displayed twice in member management... The members that show twice seem to be admin's and mods...

And for some reason only 5 users at a time display in the member management screen... Which gets annoying with more than 1k members as it shows 235 pages or so lol...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3257 - 09/14/06 05:06 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Rick Administrator Online   content

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
The duplicate users in member management is actually a beta 5 bug, fixed for RC1.

Does the table prefix just replace the phpbb_ portion or is it added to that?

Will take a look at the forum sort order and see about importing user groups.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3258 - 09/14/06 05:06 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Originally Posted By: Gizmo
Well found first blip... Seems that some members are displayed twice in member management... The members that show twice seem to be admin's and mods...


Well, I went into PHPMyAdmin and looked at the database; it seems that each user is displayed only once, i wonder why admin/mod's are displayed twice in the member management???
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3259 - 09/14/06 05:08 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Ahh kk, glad to hear member management isn't something i did lol...

The prefix is just phpbb_

The sort order and user groups are the only beef from me; its a shame the permissions are so funky, it'd be awesome to make it seemless hehe
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3260 - 09/14/06 05:08 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Rick Administrator Online   content

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
Oh, and the 5 members per page is a beta 5 bug as well wink
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3261 - 09/14/06 05:09 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Is there a reason why the user titles are "imported user"? heh
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3262 - 09/14/06 05:12 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Rick Administrator Online   content

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
Originally Posted By: Gizmo
Is there a reason why the user titles are "imported user"? heh


Other than the fact that the 2 boards I did a test import with didn't even have titles assigned, no. I'll need to do my own test board and see how regular titles are handled.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3263 - 09/14/06 05:17 PM Re: PHPBB Importer Impressions [Re: Rick]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
We have titles wink... want another sQL dump? hehe
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3264 - 09/14/06 05:18 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
They're listed as "Ranks" in PHPBB/pnPHPBB; also there are custom ranks as well
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3265 - 09/14/06 05:18 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Rick Administrator Online   content

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
I'll just make some imaginary titles, like "lil' Gizmo" and "buggy Gizmo"....
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3266 - 09/14/06 05:18 PM Re: PHPBB Importer Impressions [Re: Rick]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
and "spammer Gizmo" :nods: lol
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3267 - 09/14/06 05:19 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Code:
-- 
-- Table structure for table `phpbb_ranks`
-- 

CREATE TABLE `phpbb_ranks` (
  `rank_id` smallint(5) unsigned NOT NULL auto_increment,
  `rank_title` varchar(50) NOT NULL default '',
  `rank_min` mediumint(8) NOT NULL default '0',
  `rank_special` tinyint(1) default '0',
  `rank_image` varchar(255) default NULL,
  PRIMARY KEY  (`rank_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

-- 
-- Dumping data for table `phpbb_ranks`
-- 

INSERT INTO `phpbb_ranks` VALUES (1, 'Administrator', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (2, 'Moderator', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (3, 'Co-Administrator', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (4, 'Volunteer', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (5, 'Village Idiot', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (6, 'Angel in Devil''s Clothing', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (7, 'Legal Defense', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (8, 'Sensei Ninja Master', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (9, 'Cluebie', 0, 0, '');
INSERT INTO `phpbb_ranks` VALUES (10, 'Poser', 50, 0, '');
INSERT INTO `phpbb_ranks` VALUES (11, 'Member', 100, 0, '');
INSERT INTO `phpbb_ranks` VALUES (12, 'Super Poster', 500, 0, '');
INSERT INTO `phpbb_ranks` VALUES (13, 'Elite Poster', 1000, 0, '');
INSERT INTO `phpbb_ranks` VALUES (14, 'Elite', 2000, 0, '');
INSERT INTO `phpbb_ranks` VALUES (15, 'Call-Center Junkie', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (16, 'Gigolo', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (17, 'I can''t follow the rules', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (18, '<b>Banned</b>', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (20, '<b><font color="#FF0000">Warned</font></b>', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (21, '<b><font color="#FF8000">Spammer</font></b>', -1, 1, '');
INSERT INTO `phpbb_ranks` VALUES (22, 'Former Portland Traffic', -1, 1, '');
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3268 - 09/14/06 05:27 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
I'd also like to possibly see the ability to import the board rules as well...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3269 - 09/14/06 05:30 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
well, it looks like the post level ranks where imported (just not assigned to users); though the custom ranks weren't (just to update you before you go bashing away)
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3270 - 09/14/06 05:34 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Rick Administrator Online   content

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
Ok, I've got the table prefix and ranks fixed.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3271 - 09/14/06 05:34 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
appears that the viewforum redirector is busted, i'm forwarded to a malformed url:
http://www.livebridgesucks.com/forum/%7BURL%7D/ubbthreads.php/ubb/cfrm
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3272 - 09/14/06 05:36 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Rick Administrator Online   content

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
Yeah, line 64 of that should be:

header("Location: {$URL}/ubbthreads.php{$var_start}ubb{$var_eq}cfrm");

missed the $ in URL.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3273 - 09/14/06 05:36 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
This:
Code:
header("Location: {URL}/ubbthreads.php{$var_start}ubb{$var_eq}cfrm");


Is missing a $ in {url}
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3274 - 09/14/06 05:36 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Seems we're both active! lol
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3275 - 09/14/06 05:36 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Rick Administrator Online   content

*****

Registered: 06/04/06
Posts: 7993
Loc: Aberdeen, WA
I'm faster than you!
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#3276 - 09/14/06 05:45 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Well the index and viewforum redirectors work beautiful, but the viewtopic one is busted...

This:
http://www.livebridgesucks.com/forum/viewtopic.php?p=5732&highlight=#5732

Sends me to:
http://www.acsdebate.com/bbs/ubbthreads.php/ubb/cfrm#5732

Which is my index?
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#3277 - 09/14/06 05:45 PM Re: PHPBB Importer Impressions [Re: Gizmo]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
You're a monkey :x
_________________________
UGN Security, Elite Web Gamers &am