• Welcome to Simple Machines Community Forum. Please login or sign up.
October 28, 2021, 04:32:02 AM

News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord


[SMF Converter] phpBB - 2.0.19+

Started by JayBachatero, January 13, 2007, 02:47:08 AM

Previous topic - Next topic

ladynada


Quote from: ladynada on March 09, 2007, 05:57:56 PM
Hi,
Will you let us know in here when your board goes online with SMF, as I would love to see it!
nada

Quote from: Bernie on February 02, 2007, 02:38:27 AM
I'll be happy to Ladynada, but it won't be for awhile yet.  I just took on another project with a higher priority, so getting switched to SMF is on the back burner for the moment.

Also, since it's a WWII history and wargaming board I'm not sure just how interesting you'd find it.  Great community though, a genuine "virtual band of brothers". 

(Where else are you going to find a group that will pay the round-trip airfare for a student from Finland to join us for a tour of Gettysburg?)

Hi,
Okay. You can come see mine now.

http://heartdaughter.com/overcomers/

:)
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

ladynada

Hi Jay,
I have a report on the converter for phpbb to smf.  The avatars folders from phpbb are imported but you put them under the gallery folder, and I think they should go under the avatars folder, just like the actors one is.  I am moving mine there, and they show as being available that way.
thanks,
nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

JayBachatero

Quote from: ladynada on March 10, 2007, 08:33:54 AM
Hi Jay,
I have a report on the converter for phpbb to smf.  The avatars folders from phpbb are imported but you put them under the gallery folder, and I think they should go under the avatars folder, just like the actors one is.  I am moving mine there, and they show as being available that way.
thanks,
nada

No they should be in the attachments directory.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

ladynada

Quote from: JayBachatero on March 10, 2007, 11:48:37 PM
Quote from: ladynada on March 10, 2007, 08:33:54 AM
Hi Jay,
I have a report on the converter for phpbb to smf.  The avatars folders from phpbb are imported but you put them under the gallery folder, and I think they should go under the avatars folder, just like the actors one is.  I am moving mine there, and they show as being available that way.
thanks,
nada

No they should be in the attachments directory.

Heya Jay,
Well, as long as you keep them in their directories it is easy to move them to where SMF will see them.  but yea, in the attachment directory would be perfect, because I had a little fiasco with my SMF creating htaccess file in the attachment directory and I think I am overworked on the bbs because all my folder strings in the config were hosed up.  Finally got it all fixed.
thanks Dude!
nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

JayBachatero

I mean that's where they are supposed to be stored.  avatar_ID_OF_MEMBER.ext.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

ladynada

Quote from: JayBachatero on March 11, 2007, 02:15:31 PM
I mean that's where they are supposed to be stored.  avatar_ID_OF_MEMBER.ext.

yes my cute penguin looking person, they are in the folder I specified in the config, and are filenames like avatar_8.jpg.  It is working fine.

nada



you like my fishie?
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

etdwh

Well, completed our forum migrations last weekend.
Its was a success  :D

There was one issue though...
In some cases, special members != regular members.

For example.
I set some boards to allow access for regular members. Meaning all registered members can access
However, some of our paid members (special group) complained they could not see those boards.
So i had to set the permission for all membergroups.
Im still investigating this, could be normal feature or just something wrong during conversion.

But in the end, its good to ditch phpbb and switch to SMF. Im loving it  :D

ladynada

Quote from: etdwh on March 12, 2007, 05:05:03 AM
Well, completed our forum migrations last weekend.
Its was a success  :D

There was one issue though...
In some cases, special members != regular members.

For example.
I set some boards to allow access for regular members. Meaning all registered members can access
However, some of our paid members (special group) complained they could not see those boards.
So i had to set the permission for all membergroups.
Im still investigating this, could be normal feature or just something wrong during conversion.

But in the end, its good to ditch phpbb and switch to SMF. Im loving it  :D

congrats!

Yes, I spent some time today on the membergroups and permissions.  Something to take note of, is that to get more control and understand what you are doing, it is better to set permissions by boards, and set the one in question to LOCAL - that way you can set the permissions for that board separately from global permissions.

I hope that made sense.

also be careful with the set access to changing membergroups --- ie probably do not give that power to anyone until you are comfortable with using SMF and understand what it does.

also be careful of the manage database and config option, do not check that for anyone but yourself - again - unless you know for sure what it means for your board.

hope that helps, I was all in that today for hours

I love SMF it is very very well done, and I am impressed and blessed already!

nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

JayBachatero

Quote from: ladynada on March 11, 2007, 06:48:13 PM
Quote from: JayBachatero on March 11, 2007, 02:15:31 PM
I mean that's where they are supposed to be stored.  avatar_ID_OF_MEMBER.ext.

yes my cute penguin looking person, they are in the folder I specified in the config, and are filenames like avatar_8.jpg.  It is working fine.

nada



you like my fishie?

I'll look into the avatar problem.
Yea I like your fishie :P.

@etdwh - Permissions are not fully converter in most cases.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Gonad The Barbarian

I provide web hosting for some of my clients and I recently installed SMF for one of them instead of phpBB2, primarily to get a good look at it.  So far, I'm impressed and I'm considering converting a long time phpBB2 board over to SMF. 

My question is........How well does the conversion work.  If it's a lot of work, I might not have the time right now. On the plus side, this board is very vanilla in terms of very few if any modifications or hacks being installed.  Based on that, are my chances pretty good for a smooth transition?

ladynada

Quote from: Gonad The Barbarian on March 12, 2007, 06:51:47 PM
I provide web hosting for some of my clients and I recently installed SMF for one of them instead of phpBB2, primarily to get a good look at it.  So far, I'm impressed and I'm considering converting a long time phpBB2 board over to SMF. 

My question is........How well does the conversion work.  If it's a lot of work, I might not have the time right now. On the plus side, this board is very vanilla in terms of very few if any modifications or hacks being installed.  Based on that, are my chances pretty good for a smooth transition?


Although my PHPBB only had a whopping FIVE users, the conversion was easy and accurate.  I also did it about three times, because I practiced on my local computer a couple of times first.

I love SMF, it is very powerful and intuitive and reminds me, fondly, of my BBS days.  I was a SysOp for years.

Nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

Gonad The Barbarian

Well, this forum has a lot more users than that, but it shouldn't matter.  I was a SysOp for quite a few years myself and my BBS (PCBoard) was the Southeastern U.S. mail hub for the City-2-City network.

Bernie

Quote from: Gonad The Barbarian on March 13, 2007, 09:52:45 AM
Well, this forum has a lot more users than that, but it shouldn't matter.  I was a SysOp for quite a few years myself and my BBS (PCBoard) was the Southeastern U.S. mail hub for the City-2-City network.

Hey Gonad!  Good to see another BBS'r on here.  I ran a few for several years in the 80's, and I'm in the BBS Documentary movie done two years ago.

My current phpBB2 system has about 2,100 members with well over 100k posts, about 3m hits per month and is very heavily modified yet, with a bit of help from Marvelous Jay we were able to do the conversion very smoothly.  Things to watch out for are permissions on specific boards, member groups, and banned IP's.  Many things get prefaced with "phpBB" and that can cause problems.  I've not brought our SMF system fully online yet, and I still have some work to do on it.  If your system is comparable to mine then plan on spending 12-16 hours getting it working. (Ranks and groups properly configured, bans fixed, important mods installed, boards and permissions properly set)

I'd suggest doing a couple of trial runs first (the conversion does not change or modify your phpBB info and files in any way whatsoever) and they try some test logins at different membership levels to make sure the permissions are correct.
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

Gonad The Barbarian

Quote from: Bernie on March 13, 2007, 01:28:39 PM
Hey Gonad!  Good to see another BBS'r on here.  I ran a few for several years in the 80's, and I'm in the BBS Documentary movie done two years ago.

My current phpBB2 system has about 2,100 members with well over 100k posts, about 3m hits per month and is very heavily modified yet, with a bit of help from Marvelous Jay we were able to do the conversion very smoothly.  Things to watch out for are permissions on specific boards, member groups, and banned IP's.  Many things get prefaced with "phpBB" and that can cause problems.  I've not brought our SMF system fully online yet, and I still have some work to do on it.  If your system is comparable to mine then plan on spending 12-16 hours getting it working. (Ranks and groups properly configured, bans fixed, important mods installed, boards and permissions properly set)

I'd suggest doing a couple of trial runs first (the conversion does not change or modify your phpBB info and files in any way whatsoever) and they try some test logins at different membership levels to make sure the permissions are correct.

Thanks for the tips.  I'll keep that in mind if I make the jump. The board that I'm thinking of converting has 300+ members and it's a "guild" board for an online game. 

I ran my BBS back in the 80's also. I think I pulled it down in the mid-1990's (95 or 96) if I remember right.  My board was listed in several books about the subject, etc.  It was known as "PC Solutions of Cleveland".  What was yours?

Bernie

Quote from: Gonad The Barbarian on March 13, 2007, 03:31:42 PM
Quote from: Bernie on March 13, 2007, 01:28:39 PM
Hey Gonad!  Good to see another BBS'r on here.  I ran a few for several years in the 80's, and I'm in the BBS Documentary movie done two years ago.

My current phpBB2 system has about 2,100 members with well over 100k posts, about 3m hits per month and is very heavily modified yet, with a bit of help from Marvelous Jay we were able to do the conversion very smoothly.  Things to watch out for are permissions on specific boards, member groups, and banned IP's.  Many things get prefaced with "phpBB" and that can cause problems.  I've not brought our SMF system fully online yet, and I still have some work to do on it.  If your system is comparable to mine then plan on spending 12-16 hours getting it working. (Ranks and groups properly configured, bans fixed, important mods installed, boards and permissions properly set)

I'd suggest doing a couple of trial runs first (the conversion does not change or modify your phpBB info and files in any way whatsoever) and they try some test logins at different membership levels to make sure the permissions are correct.

Thanks for the tips.  I'll keep that in mind if I make the jump. The board that I'm thinking of converting has 300+ members and it's a "guild" board for an online game. 

I ran my BBS back in the 80's also. I think I pulled it down in the mid-1990's (95 or 96) if I remember right.  My board was listed in several books about the subject, etc.  It was known as "PC Solutions of Cleveland".  What was yours?


Ahoy! Magazine.  :)

Also (after I left the magazine):

The Underground

Underground Empire (Undy II)

and Brooklyn After Dark (BAD)

We were based in NYC (obviously), on FIDO, and ran Renegade.

Give me a shout if you run into problems with SMF and I'll try to help you out.
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

ladynada

Quote from: Gonad The Barbarian on March 13, 2007, 09:52:45 AM
Well, this forum has a lot more users than that, but it shouldn't matter.  I was a SysOp for quite a few years myself and my BBS (PCBoard) was the Southeastern U.S. mail hub for the City-2-City network.

I hear you!  I loved those boards.  I used to be a member of PC-OHIO.

oh those were the days..
nada
WORK for Truth, Print it, Take Time to READ ALL LINKS NOTED  click here --> The TWO Witnesses are Mom and Dad and SMF Skins

etdwh

Quote from: ladynada on March 12, 2007, 06:45:16 AM
Quote from: etdwh on March 12, 2007, 05:05:03 AM

There was one issue though...
In some cases, special members != regular members.

Yes, I spent some time today on the membergroups and permissions.  Something to take note of, is that to get more control and understand what you are doing, it is better to set permissions by boards, and set the one in question to LOCAL - that way you can set the permissions for that board separately from global permissions.

I hope that made sense.

also be careful with the set access to changing membergroups --- ie probably do not give that power to anyone until you are comfortable with using SMF and understand what it does.

also be careful of the manage database and config option, do not check that for anyone but yourself - again - unless you know for sure what it means for your board.

Thanks ladynada.

I looked further into the issue. Seems to affect all converted users, but not new users.
Somehow i didnt notice this when testing at home. Adding 0 to the users additionalGroups in the database helps.

But anyway, i just enable the permissions for each membergroup, and that makes sense too :-)

Quote from: Bernie on March 13, 2007, 01:28:39 PM
My current phpBB2 system has about 2,100 members with well over 100k posts, about 3m hits per month and is very heavily modified yet, with a bit of help from Marvelous Jay we were able to do the conversion very smoothly.  Things to watch out for are permissions on specific boards, member groups, and banned IP's.  Many things get prefaced with "phpBB" and that can cause problems.  I've not brought our SMF system fully online yet, and I still have some work to do on it.  If your system is comparable to mine then plan on spending 12-16 hours getting it working. (Ranks and groups properly configured, bans fixed, important mods installed, boards and permissions properly set)

I'd suggest doing a couple of trial runs first (the conversion does not change or modify your phpBB info and files in any way whatsoever) and they try some test logins at different membership levels to make sure the permissions are correct.

I sorta figured out why the groups are prefix with phpbb_.
This is so when you redo the conversion for any reason, it will be able to delete the groups correctly.
If not, you will get duplicate groups. So i made a change in the SQL file
Code (phpbb2_to_smf.sql) Select

/******************************************************************************/
--- Converting ranks...
/******************************************************************************/

DELETE FROM {$to_prefix}membergroups WHERE ID_GROUP NOT IN (1,2,3);


This will keep the admin, global mod and another group...can't remember ATM  :P

Gonad The Barbarian

If I run the conversion and then spend some time getting all the permissions and user groups right, for let's say a couple of hours.........and I think I'm ready to go live, there is probably no way to import just the message base again, right? 

I mean, if I do this to get all the posts that were made on phpBB2 during the configuration of SMF, the conversion would dork up all my work to reconfigure everything.

I guess there is simply no way to attempt to get all posts pulled over, unless I take down the phpBB2 board and leave it down during the re-config, right?


Bernie

Quote from: Gonad The Barbarian on March 14, 2007, 05:33:13 AM
If I run the conversion and then spend some time getting all the permissions and user groups right, for let's say a couple of hours.........and I think I'm ready to go live, there is probably no way to import just the message base again, right? 

I mean, if I do this to get all the posts that were made on phpBB2 during the configuration of SMF, the conversion would dork up all my work to reconfigure everything.

I guess there is simply no way to attempt to get all posts pulled over, unless I take down the phpBB2 board and leave it down during the re-config, right?



Right.  That's one of the main reasons I've not gone live with my version yet.  We average a few hundred posts a day, and have a very complex permissions system.  To do a proper conversion, and not lose anything, I'll have to put my forums offline for 24-48 hours, and I'm not ready to do that yet.

We do plan to upgrade our server in the next few months, as we're running out of storage and bandwidth (with 300 gigs you'd think that was impossible but...) so I'll probably do the full switchover during that process.
(\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.
If you do this, you can become his
Evil Minion, and not just another victim.

Chuckl

Any idea's on this
Quote
phpBB2 to SMF Converter
Converting...
Converting topics... Unsuccessful!
This query:

    INSERT INTO `matrix_smf`.smf_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
    VALUES ('614', '0', '4786', '4814', '271', '271', '2', '', '0', '5', '172'),
    ('616', '0', '4791', '4791', '27', '27', '2', '', '0', '0', '70'),
    ('617', '0', '4796', '6363', '39', '39', '2', '', '0', '16', '797'),
    ('621', '0', '4821', '4831', '272', '39', '2', '', '0', '1', '296'),
    ('622', '0', '4822', '4832', '233', '5', '3', '', '0', '7', '527'),
    ('623', '0', '4824', '4824', '34', '34', '3', '', '0', '0', '305'),
    ('624', '0', '4828', '4828', '192', '192', '2', '', '0', '0', '203'),
    ('625', '0', '4833', '4907', '196', '3', '1', '', '0', '25', '1094'),
    ('627', '0', '4844', '4844', '213', '213', '2', '', '0', '0', '145'),
    ('628', '0', '4854', '4902', '8', '39', '1', '', '0', '6', '330'),
    ('629', '0', '4857', '4906', '244', '60', '3', '', '0', '4', '267'),
    ('630', '0', '4868', '14564', '277', '277', '2', '', '0', '13', '502'),
    ('631', '0', '4871', '5017', '235', '233', '1', '', '0', '41', '1705'),
    ('632', '0', '4879', '4879', '132', '132', '2', '', '0', '0', '83'),
    ('633', '0', '4883', '4883', '276', '276', '2', '', '0', '0', '79'),
    ('634', '0', '4892', '4896', '260', '5', '2', '', '0', '1', '62'),
    ('635', '0', '4905', '4905', '244', '244', '1', '', '0', '0', '203'),
    ('636', '0', '4911', '4991', '233', '233', '3', '', '0', '7', '361'),
    ('637', '0', '4912', '4920', '50', '14', '2', '', '0', '3', '86'),
    ('638', '0', '4922', '4922', '259', '259', '2', '', '0', '0', '68'),
    ('639', '0', '4935', '4935', '271', '271', '2', '', '0', '0', '76'),
    ('640', '0', '4936', '4996', '279', '279', '2', '', '0', '2', '137'),
    ('641', '0', '4949', '5027', '17', '17', '1', '', '0', '6', '355'),
    ('642', '0', '4954', '4954', '206', '206', '2', '', '0', '0', '55'),
    ('643', '0', '4955', '4971', '4', '22', '1', '', '0', '1', '299'),
    ('644', '0', '4959', '5026', '160', '3', '3', '', '0', '10', '601'),
    ('647', '0', '4976', '37726', '50', '50', '5', '', '0', '21', '2479'),
    ('648', '0', '4992', '4992', '9', '9', '2', '', '0', '0', '64'),
    ('649', '0', '5001', '5037', '60', '281', '2', '', '0', '2', '107'),
    ('650', '0', '5018', '21536', '280', '4', '2', '', '0', '6', '311'),
    ('653', '0', '5024', '5024', '9', '9', '2', '', '0', '0', '79'),
    ('654', '0', '5030', '5030', '60', '60', '2', '', '0', '0', '79'),
    ('655', '0', '5032', '5737', '3', '285', '4', '', '0', '12', '574'),
    ('656', '0', '5040', '5052', '196', '3', '1', '', '0', '2', '237'),
    ('658', '0', '5058', '5060', '14', '14', '1', '', '0', '1', '201'),
    ('659', '0', '5076', '5111', '11', '15', '1', '', '0', '9', '887'),
    ('660', '0', '5089', '5110', '8', '11', '1', '', '0', '4', '319'),
    ('661', '0', '5112', '5217', '239', '160', '1', '', '0', '7', '587'),
    ('662', '0', '5117', '5117', '268', '268', '2', '', '0', '0', '70'),
    ('663', '0', '5119', '5123', '4', '14', '1', '', '0', '3', '462'),
    ('665', '0', '5125', '5357', '5', '239', '1', '', '0', '6', '441'),
    ('666', '0', '5131', '5131', '17', '17', '2', '', '0', '0', '97'),
    ('667', '0', '5133', '5133', '231', '231', '2', '', '0', '0', '161'),
    ('668', '0', '5134', '5134', '19', '19', '2', '', '0', '0', '119'),
    ('669', '0', '5135', '5802', '60', '60', '2', '', '0', '1', '115'),
    ('670', '0', '5138', '5151', '50', '50', '1', '', '0', '4', '273'),
    ('671', '0', '5146', '5213', '268', '260', '2', '', '0', '6', '300'),
    ('672', '0', '5147', '5179', '235', '235', '3', '', '0', '8', '381'),
    ('673', '0', '5159', '5159', '259', '259', '2', '', '0', '0', '110'),
    ('674', '0', '5160', '5324', '233', '233', '3', '', '0', '5', '221'),
    ('675', '0', '5161', '5161', '187', '187', '2', '', '0', '0', '165'),
    ('676', '0', '5169', '8441', '259', '259', '2', '', '0', '4', '258'),
    ('677', '0', '5170', '37752', '2', '2', '2', '', '0', '2', '1573'),
    ('678', '0', '5178', '5308', '235', '235', '2', '', '0', '9', '167'),
    ('679', '0', '5182', '5185', '235', '66', '3', '', '0', '3', '147'),
    ('680', '0', '5189', '5760', '3', '50', '1', '', '0', '43', '1642'),
    ('681', '0', '5194', '5226', '11', '66', '1', '', '0', '7', '511'),
    ('682', '0', '5203', '10435', '7', '360', '5', '', '0', '16', '2292'),
    ('683', '0', '5218', '5272', '160', '268', '1', '', '0', '14', '994'),
    ('684', '0', '5222', '5222', '268', '268', '2', '', '0', '0', '66'),
    ('685', '0', '5234', '5234', '259', '259', '2', '', '0', '0', '78'),
    ('686', '0', '5235', '5292', '14', '17', '1', '', '0', '10', '569'),
    ('687', '0', '5246', '5326', '14', '14', '2', '', '0', '8', '247'),
    ('688', '0', '5249', '5406', '271', '244', '2', '', '0', '3', '151'),
    ('689', '0', '5251', '5452', '244', '289', '1', '', '0', '16', '759'),
    ('690', '0', '5271', '5276', '228', '5', '2', '', '0', '3', '188'),
    ('691', '0', '5288', '5291', '165', '32', '1', '', '0', '2', '245'),
    ('692', '0', '5297', '5297', '5', '5', '2', '', '0', '0', '102'),
    ('693', '0', '5300', '5347', '235', '235', '3', '', '0', '10', '463'),
    ('694', '0', '5307', '5310', '231', '60', '2', '', '0', '1', '84'),
    ('695', '0', '5311', '5340', '285', '285', '2', '', '0', '10', '190'),
    ('696', '0', '5312', '5312', '235', '235', '2', '', '0', '0', '99'),
    ('697', '0', '5316', '5341', '285', '285', '2', '', '0', '2', '89'),
    ('698', '0', '5321', '5321', '132', '132', '2', '', '0', '0', '82'),
    ('699', '0', '5327', '5409', '285', '5', '3', '', '0', '4', '169'),
    ('700', '0', '5333', '5356', '160', '282', '3', '', '0', '4', '263'),
    ('701', '0', '5349', '5396', '285', '285', '3', '', '0', '9', '366'),
    ('702', '0', '5353', '5432', '233', '233', '3', '', '0', '3', '129'),
    ('703', '0', '5358', '5706', '286', '286', '2', '', '0', '6', '282'),
    ('704', '0', '5370', '5683', '287', '233', '1', '', '0', '16', '807'),
    ('705', '0', '5390', '5680', '192', '192', '3', '', '0', '7', '236'),
    ('706', '0', '5397', '5591', '288', '196', '6', '', '0', '23', '1725'),
    ('707', '0', '5408', '5537', '211', '165', '3', '', '0', '9', '472'),
    ('708', '0', '5412', '5436', '186', '186', '2', '', '0', '3', '180'),
    ('709', '0', '5426', '5428', '34', '34', '2', '', '0', '2', '86'),
    ('710', '0', '5433', '5485', '285', '285', '3', '', '0', '3', '172'),
    ('711', '0', '5443', '5443', '165', '165', '2', '', '0', '0', '207'),
    ('712', '0', '5444', '5529', '235', '235', '3', '', '0', '8', '313'),
    ('713', '0', '5450', '5558', '211', '50', '3', '', '0', '2', '222'),
    ('714', '0', '5451', '5761', '268', '22', '1', '', '0', '6', '505'),
    ('715', '0', '5453', '5548', '289', '244', '6', '', '0', '4', '580'),
    ('716', '0', '5461', '5461', '235', '235', '2', '', '0', '0', '70'),
    ('717', '0', '5463', '5567', '289', '235', '3', '', '0', '24', '1257'),
    ('718', '0', '5468', '5714', '289', '160', '1', '', '0', '13', '738'),
    ('719', '0', '5487', '5532', '289', '288', '1', '', '0', '3', '239'),
    ('720', '0', '5493', '5538', '289', '60', '3', '', '0', '2', '136'),
    ('721', '0', '5494', '5863', '289', '289', '1', '', '0', '33', '1641'),
    ('722', '0', '5496', '6366', '208', '196', '6', '', '0', '29', '1291'),
    ('724', '0', '5559', '5605', '285', '9', '3', '', '0', '4', '253'),
    ('725', '0', '5574', '6178', '15', '15', '2', '', '0', '24', '1410'),
    ('726', '0', '5576', '5606', '244', '244', '3', '', '0', '4', '216'),
    ('727', '0', '5586', '5608', '282', '14', '2', '', '0', '1', '106'),
    ('728', '0', '5603', '5617', '39', '39', '1', '', '0', '5', '357'),
    ('729', '0', '5607', '5630', '233', '233', '14', '', '0', '2', '276'),
    ('730', '0', '5619', '5624', '259', '18', '2', '', '0', '1', '104'),
    ('731', '0', '5620', '5620', '34', '34', '3', '', '0', '0', '94'),
    ('732', '0', '5621', '6687', '285', '288', '3', '', '0', '4', '262'),
    ('733', '0', '5625', '5629', '50', '285', '2', '', '0', '4', '136'),
    ('734', '0', '5633', '5670', '15', '15', '2', '', '0', '1', '116'),
    ('735', '0', '5634', '5634', '285', '285', '2', '', '0', '0', '50'),
    ('736', '0', '5635', '5663', '285', '5', '3', '', '0', '2', '139'),
    ('737', '0', '5636', '7350', '235', '235', '1', '', '0', '11', '463'),
    ('738', '0', '5638', '5676', '233', '233', '3', '', '0', '7', '330'),
    ('739', '0', '5641', '5654', '278', '11', '1', '', '0', '7', '387'),
    ('740', '0', '5660', '5668', '192', '192', '2', '', '0', '2', '72'),
    ('741', '0', '5677', '5705', '233', '233', '3', '', '0', '5', '206'),
    ('742', '0', '5684', '5709', '290', '11', '6', '', '0', '4', '422'),
    ('743', '0', '5685', '5788', '290', '290', '2', '', '0', '3', '136'),
    ('744', '0', '5690', '5799', '32', '32', '1', '', '0', '13', '598'),
    ('745', '0', '5701', '5701', '186', '186', '2', '', '0', '0', '69'),
    ('746', '0', '5708', '5708', '235', '235', '3', '', '0', '0', '93'),
    ('747', '0', '5712', '17057', '259', '259', '2', '', '0', '3', '170'),
    ('748', '0', '5715', '6263', '15', '15', '2', '', '0', '8', '351'),
    ('749', '0', '5716', '5743', '15', '15', '2', '', '0', '1', '95'),
    ('750', '0', '5718', '5718', '244', '244', '2', '', '0', '0', '69'),
    ('751', '0', '5720', '5723', '8', '39', '1', '', '0', '2', '240'),
    ('752', '0', '5727', '5727', '216', '216', '2', '', '0', '0', '64'),
    ('753', '0', '5736', '5772', '208', '278', '8', '', '0', '6', '632'),
    ('754', '0', '5741', '5764', '244', '244', '3', '', '0', '2', '106'),
    ('755', '0', '5742', '6765', '235', '304', '4', '', '0', '6', '325'),
    ('756', '0', '5745', '5956', '235', '235', '3', '', '0', '14', '574'),
    ('758', '0', '5751', '5763', '211', '9', '13', '', '0', '1', '224'),
    ('759', '0', '5766', '6211', '15', '285', '2', '', '0', '4', '212'),
    ('760', '0', '5770', '5770', '290', '290', '2', '', '0', '0', '108'),
    ('762', '0', '5775', '5986', '17', '15', '4', '', '0', '11', '605'),
    ('764', '0', '5787', '6166', '60', '60', '2', '', '0', '1', '146'),
    ('765', '0', '5792', '5792', '259', '259', '2', '', '0', '0', '109'),
    ('766', '0', '5796', '5836', '244', '14', '3', '', '0', '11', '240'),
    ('767', '0', '5797', '5797', '231', '231', '2', '', '0', '0', '72'),
    ('768', '0', '5806', '5892', '14', '5', '2', '', '0', '12', '620'),
    ('769', '0', '5808', '6322', '295', '295', '2', '', '0', '5', '213'),
    ('770', '0', '5809', '5955', '295', '295', '6', '', '0', '33', '1833'),
    ('771', '0', '5821', '5821', '285', '285', '3', '', '0', '0', '88'),
    ('772', '0', '5829', '5829', '295', '295', '2', '', '0', '0', '81'),
    ('774', '0', '5846', '6014', '66', '66', '2', '', '0', '3', '156'),
    ('775', '0', '5847', '6002', '248', '196', '3', '', '0', '5', '395'),
    ('777', '0', '5853', '5871', '289', '235', '2', '', '0', '7', '244'),
    ('778', '0', '5872', '5888', '208', '208', '3', '', '0', '5', '210'),
    ('779', '0', '5876', '5885', '285', '15', '2', '', '0', '1', '71'),
    ('780', '0', '5878', '6769', '235', '14', '3', '', '0', '9', '472'),
    ('781', '0', '5882', '5884', '39', '15', '2', '', '0', '1', '79'),
    ('782', '0', '5883', '5883', '291', '291', '3', '', '0', '0', '123'),
    ('783', '0', '5886', '5887', '239', '5', '3', '', '0', '1', '124'),
    ('784', '0', '5890', '5890', '165', '165', '2', '', '0', '0', '95'),
    ('785', '0', '5893', '5936', '285', '285', '2', '', '0', '4', '144'),
    ('786', '0', '5895', '5907', '295', '235', '2', '', '0', '5', '156'),
    ('787', '0', '5897', '6350', '287', '304', '1', '', '0', '6', '399'),
    ('788', '0', '5899', '6599', '259', '259', '2', '', '0', '4', '278'),
    ('789', '0', '5901', '24118', '244', '22', '5', '', '0', '5', '708'),
    ('790', '0', '5918', '6037', '9', '66', '2', '', '0', '4', '224'),
    ('791', '0', '5924', '5954', '298', '3', '6', '', '0', '10', '569'),
    ('792', '0', '5934', '5998', '3', '9', '4', '', '0', '3', '298'),
    ('793', '0', '5949', '5957', '9', '44', '2', '', '0', '1', '103'),
    ('794', '0', '5961', '5962', '299', '244', '2', '', '0', '1', '87'),
    ('795', '0', '5969', '7263', '3', '42', '1', '', '0', '31', '1155'),
    ('796', '0', '5974', '5991', '132', '132', '1', '', '0', '2', '207'),
    ('797', '0', '5978', '6021', '3', '9', '3', '', '0', '4', '257'),
    ('798', '0', '5980', '6017', '295', '295', '2', '', '0', '2', '84'),
    ('799', '0', '5981', '6039', '285', '285', '2', '', '0', '3', '176'),
    ('800', '0', '5988', '6139', '244', '244', '3', '', '0', '5', '358'),
    ('801', '0', '6001', '6001', '132', '132', '2', '', '0', '0', '38'),
    ('802', '0', '6004', '6049', '285', '285', '3', '', '0', '16', '574'),
    ('803', '0', '6005', '6040', '233', '233', '3', '', '0', '2', '187'),
    ('804', '0', '6025', '6029', '285', '5', '2', '', '0', '1', '47'),
    ('805', '0', '6035', '6035', '165', '165', '2', '', '0', '0', '64'),
    ('806', '0', '6042', '6418', '302', '3', '18', '', '1', '136', '6088'),
    ('808', '0', '6050', '6050', '15', '15', '2', '', '0', '0', '66'),
    ('809', '0', '6076', '6487', '3', '224', '1', '', '0', '67', '2751'),
    ('810', '0', '6077', '6157', '3', '3', '1', '', '0', '6', '364'),
    ('811', '0', '6096', '6096', '285', '285', '2', '', '0', '0', '44'),
    ('812', '0', '6098', '6098', '285', '285', '2', '', '0', '0', '45'),
    ('813', '0', '6117', '6146', '307', '307', '3', '', '0', '4', '218'),
    ('815', '0', '6132', '6140', '303', '244', '3', '', '0', '2', '220'),
    ('816', '0', '6160', '6181', '285', '285', '3', '', '0', '4', '163'),
    ('817', '0', '6163', '6163', '259', '259', '2', '', '0', '0', '54'),
    ('818', '0', '6168', '6182', '285', '285', '3', '', '0', '2', '146'),
    ('819', '0', '6172', '6480', '196', '50', '1', '', '0', '10', '586'),
    ('820', '0', '6185', '10469', '244', '289', '5', '', '0', '13', '1913'),
    ('821', '0', '6206', '7539', '208', '50', '8', '', '0', '11', '676'),
    ('822', '0', '6212', '6257', '285', '14', '2', '', '0', '3', '109'),
    ('823', '0', '6216', '6344', '17', '11', '4', '', '0', '15', '1123'),
    ('824', '0', '6220', '6362', '310', '39', '6', '', '0', '15', '973'),
    ('825', '0', '6224', '6696', '15', '15', '2', '', '0', '16', '441'),
    ('826', '0', '6228', '6323', '311', '196', '6', '', '0', '10', '1241'),
    ('827', '0', '6237', '6248', '312', '312', '2', '', '0', '3', '340'),
    ('828', '0', '6261', '6311', '233', '233', '3', '', '0', '4', '153'),
    ('829', '0', '6302', '6334', '60', '60', '2', '', '0', '1', '85'),
    ('830', '0', '6304', '6304', '268', '268', '2', '', '0', '0', '136'),
    ('831', '0', '6330', '6330', '7', '7', '1', '', '0', '0', '120'),
    ('832', '0', '6339', '6493', '285', '285', '13', '', '0', '7', '450'),
    ('833', '0', '6356', '6675', '285', '285', '1', '', '0', '42', '2382'),
    ('834', '0', '6375', '6546', '276', '244', '3', '', '0', '5', '218'),
    ('835', '0', '6376', '6376', '231', '231', '2', '', '0', '0', '99'),
    ('836', '0', '6380', '6422', '318', '311', '1', '', '0', '2', '231'),
    ('837', '0', '6381', '6382', '160', '66', '3', '', '0', '1', '144'),
    ('838', '0', '6384', '6389', '295', '295', '2', '', '0', '2', '87'),
    ('839', '0', '6407', '6411', '7', '7', '3', '', '0', '2', '117'),
    ('840', '0', '6419', '6419', '32', '32', '13', '', '0', '0', '214'),
    ('841', '0', '6426', '6426', '55', '55', '1', '', '0', '0', '156'),
    ('842', '0', '6428', '6823', '3', '244', '1', '', '0', '66', '3477'),
    ('843', '0', '6446', '6479', '268', '66', '2', '', '0', '1', '79'),
    ('844', '0', '6451', '6718', '3', '285', '2', '', '0', '3', '91'),
    ('845', '0', '6459', '6475', '196', '5', '2', '', '0', '1', '82'),
    ('846', '0', '6464', '6492', '235', '285', '3', '', '0', '1', '106'),
    ('849', '0', '6473', '6740', '282', '282', '2', '', '0', '7', '215'),
    ('851', '0', '6482', '14179', '249', '318', '1', '', '0', '7', '525'),
    ('852', '0', '6483', '6672', '50', '224', '1', '', '0', '4', '413'),
    ('853', '0', '6491', '6544', '3', '244', '1', '', '0', '15', '770'),
    ('854', '0', '6500', '7788', '289', '3', '2', '', '0', '2', '126'),
    ('855', '0', '6503', '14142', '208', '208', '3', '', '0', '22', '814'),
    ('856', '0', '6506', '6507', '285', '295', '1', '', '0', '1', '195'),
    ('857', '0', '6513', '6513', '285', '285', '2', '', '0', '0', '51'),
    ('858', '0', '6514', '6692', '310', '310', '2', '', '0', '3', '157'),
    ('859', '0', '6517', '6525', '276', '66', '3', '', '0', '3', '194'),
    ('860', '0', '6532', '6564', '39', '268', '2', '', '0', '7', '176'),
    ('861', '0', '6548', '6553', '278', '285', '3', '', '0', '2', '159'),
    ('862', '0', '6551', '6561', '285', '285', '2', '', '0', '3', '79'),
    ('863', '0', '6557', '6571', '295', '295', '2', '', '0', '2', '92'),
    ('864', '0', '6560', '37831', '285', '248', '13', '', '0', '10', '566'),
    ('865', '0', '6584', '6584', '5', '5', '2', '', '0', '0', '81'),
    ('866', '0', '6595', '6628', '285', '268', '3', '', '0', '9', '304'),
    ('867', '0', '6602', '6602', '276', '276', '2', '', '0', '0', '73'),
    ('868', '0', '6603', '6603', '60', '60', '2', '', '0', '0', '59'),
    ('869', '0', '6604', '6607', '295', '295', '2', '', '0', '2', '77'),
    ('870', '0', '6608', '6863', '66', '66', '2', '', '0', '3', '141'),
    ('873', '0', '6627', '6695', '295', '15', '2', '', '0', '5', '147'),
    ('874', '0', '6629', '7025', '295', '41', '2', '', '0', '1', '87'),
    ('875', '0', '6640', '6686', '285', '3', '1', '', '0', '6', '569'),
    ('877', '0', '6650', '6650', '285', '285', '2', '', '0', '0', '69'),
    ('878', '0', '6653', '7118', '60', '3', '2', '', '0', '6', '237'),
    ('879', '0', '6673', '6673', '233', '233', '3', '', '0', '0', '101'),
    ('880', '0', '6674', '6701', '233', '295', '3', '', '0', '4', '227'),
    ('882', '0', '6685', '10970', '288', '288', '2', '', '0', '3', '240'),
    ('883', '0', '6690', '7478', '18', '34', '2', '', '0', '1', '91'),
    ('884', '0', '6693', '7151', '321', '321', '6', '', '0', '23', '1081'),
    ('885', '0', '6694', '13326', '285', '285', '2', '', '0', '10', '545'),
    ('887', '0', '6723', '6953', '322', '322', '6', '', '0', '23', '907'),
    ('888', '0', '6724', '6808', '60', '50', '2', '', '0', '3', '98'),
    ('889', '0', '6727', '7039', '196', '3', '8', '', '0', '27', '1988'),
    ('890', '0', '6728', '6889', '323', '323', '2', '', '0', '37', '1169'),
    ('891', '0', '6746', '6746', '324', '324', '2', '', '0', '0', '75'),
    ('892', '0', '6751', '6839', '295', '235', '2', '', '0', '8', '211'),
    ('894', '0', '6777', '8052', '8', '289', '1', '', '0', '82', '2874'),
    ('895', '0', '6790', '6790', '208', '208', '2', '', '0', '0', '59'),
    ('896', '0', '6791', '6791', '276', '276', '2', '', '0', '0', '73'),
    ('897', '0', '6826', '6926', '39', '244', '3', '', '0', '4', '230'),
    ('899', '0', '6829', '7040', '39', '3', '1', '', '0', '18', '1269'),
    ('900', '0', '6843', '15328', '7', '366', '2', '', '0', '9', '317'),
    ('903', '0', '6848', '6949', '276', '244', '3', '', '0', '11', '429'),
    ('904', '0', '6852', '6857', '60', '60', '2', '', '0', '1', '90'),
    ('905', '0', '6855', '8117', '39', '18', '12', '', '0', '8', '867'),
    ('906', '0', '6891', '6918', '325', '9', '2', '', '0', '1', '97'),
    ('907', '0', '6892', '6904', '295', '132', '2', '', '0', '6', '175'),
    ('908', '0', '6898', '7348', '322', '15', '1', '', '0', '17', '641'),
    ('909', '0', '6907', '6973', '132', '132', '2', '', '0', '5', '128'),
    ('910', '0', '6911', '6915', '319', '319', '3', '', '0', '2', '193'),
    ('911', '0', '6914', '6914', '304', '304', '2', '', '0', '0', '64'),
    ('912', '0', '6920', '6920', '285', '285', '2', '', '0', '0', '52'),
    ('913', '0', '6933', '6933', '326', '326', '2', '', '0', '0', '60'),
    ('915', '0', '6941', '6941', '288', '288', '2', '', '0', '0', '67'),
    ('916', '0', '6965', '6993', '295', '244', '2', '', '0', '2', '132'),
    ('917', '0', '6976', '10470', '22', '289', '1', '', '0', '24', '1522'),
    ('918', '0', '6985', '7052', '55', '132', '1', '', '0', '8', '562'),
    ('919', '0', '6986', '6986', '132', '132', '13', '', '0', '0', '225'),
    ('920', '0', '6994', '7344', '17', '66', '8', '', '0', '29', '1859'),
    ('921', '0', '6996', '7282', '192', '192', '6', '', '0', '10', '533'),
    ('922', '0', '7004', '7249', '235', '244', '3', '', '0', '17', '683'),
    ('923', '0', '7015', '7352', '239', '304', '2', '', '0', '5', '134'),
    ('924', '0', '7024', '7369', '244', '132', '2', '', '0', '6', '163'),
    ('925', '0', '7026', '7047', '291', '15', '2', '', '0', '1', '52'),
    ('927', '0', '7044', '8107', '327', '346', '1', '', '0', '14', '672'),
    ('928', '0', '7053', '11077', '132', '260', '1', '', '0', '113', '5405'),
    ('929', '0', '7059', '7198', '288', '11', '4', '', '0', '8', '316'),
    ('930', '0', '7065', '7065', '9', '9', '2', '', '0', '0', '54'),
    ('931', '0', '7072', '7196', '329', '11', '6', '', '0', '9', '483'),
    ('932', '0', '7073', '7143', '235', '235', '3', '', '0', '7', '285'),
    ('933', '0', '7090', '8099', '15', '15', '5', '', '0', '6', '557'),
    ('935', '0', '7104', '7238', '3', '27', '3', '', '0', '8', '331'),
    ('936', '0', '7109', '7152', '330', '330', '2', '', '0', '4', '106'),
    ('937', '0', '7114', '7529', '330', '3', '6', '', '0', '49', '2071'),
    ('938', '0', '7145', '7289', '329', '329', '1', '', '0', '9', '334'),
    ('939', '0', '7156', '7214', '329', '50', '1', '', '0', '8', '363'),
    ('940', '0', '7166', '7169', '276', '7', '2', '', '0', '1', '63'),
    ('941', '0', '7172', '7541', '34', '34', '2', '', '0', '2', '165'),
    ('942', '0', '7175', '9468', '244', '260', '2', '', '0', '3', '130'),
    ('943', '0', '7224', '7382', '323', '132', '6', '', '0', '14', '945'),
    ('944', '0', '7231', '7248', '244', '34', '2', '', '0', '1', '52'),
    ('945', '0', '7240', '7259', '3', '132', '4', '', '0', '3', '174'),
    ('946', '0', '7244', '7296', '307', '307', '3', '', '0', '12', '364'),
    ('947', '0', '7265', '7359', '233', '132', '3', '', '0', '4', '197'),
    ('948', '0', '7273', '7411', '326', '15', '4', '', '0', '12', '453'),
    ('949', '0', '7283', '7356', '330', '330', '2', '', '0', '5', '134'),
    ('950', '0', '7288', '7532', '18', '18', '1', '', '0', '13', '399'),
    ('951', '0', '7299', '8553', '307', '307', '3', '', '0', '12', '489'),
    ('953', '0', '7353', '7353', '208', '208', '13', '', '0', '0', '212'),
    ('954', '0', '7362', '7368', '295', '132', '2', '', '1', '1', '117'),
    ('955', '0', '7365', '7375', '288', '235', '1', '', '0', '6', '245'),
    ('956', '0', '7376', '7457', '304', '304', '3', '', '0', '6', '225'),
    ('957', '0', '7380', '8504', '323', '289', '2', '', '0', '12', '355'),
    ('959', '0', '7385', '7504', '323', '233', '3', '', '0', '9', '248'),
    ('960', '0', '7386', '7609', '334', '11', '6', '', '0', '10', '586'),
    ('961', '0', '7387', '7431', '323', '260', '1', '', '0', '3', '172'),
    ('962', '0', '7406', '8154', '319', '347', '6', '', '0', '11', '499'),
    ('964', '0', '7424', '7466', '295', '295', '2', '', '0', '2', '117'),
    ('965', '0', '7427', '7551', '323', '260', '3', '', '0', '12', '351'),
    ('966', '0', '7435', '7435', '69', '69', '2', '', '0', '0', '94'),
    ('967', '0', '7439', '7463', '330', '5', '3', '', '0', '6', '220'),
    ('968', '0', '7462', '7636', '3', '321', '4', '', '0', '7', '299'),
    ('969', '0', '7472', '7477', '285', '34', '3', '', '0', '2', '138'),
    ('971', '0', '7480', '7487', '276', '14', '3', '', '0', '1', '79'),
    ('972', '0', '7481', '7913', '233', '311', '3', '', '0', '8', '301'),
    ('973', '0', '7485', '7594', '323', '9', '3', '', '0', '5', '223'),
    ('975', '0', '7489', '7669', '235', '8', '3', '', '0', '13', '440'),
    ('976', '0', '7493', '7905', '330', '4', '3', '', '0', '9', '479'),
    ('977', '0', '7512', '7536', '329', '304', '1', '', '0', '2', '170'),
    ('978', '0', '7530', '7589', '3', '3', '1', '', '0', '6', '320'),
    ('979', '0', '7542', '7542', '132', '132', '2', '', '0', '0', '67'),
    ('981', '0', '7549', '7693', '14', '14', '2', '', '0', '3', '96'),
    ('982', '0', '7556', '7604', '27', '323', '4', '�

Advertisement: