|
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 3 Weeks ago
|
|
kittymcooper wrote:
On the time - look at the column user_regdate in your phpBB database. The code is assuming that column is a unix timestamp. What do you see there? This is the code that moves the time over:
| Code: |
$registerDate = date( "Y-m-d H:i:s", $row->user_regdate );
$lastvisitDate = date( "Y-m-d H:i:s", $row->user_lastvisit );
|
On everyone being an Admin, the code assumes that the phpBB database column user_level is 1 for admins - this is the code
| Code: |
// Set user type and group id
if ( $row->user_level == "1" ) {
$usertype = "administrator";
$gid = $admingid;
} else {
$usertype = "Registered";
$gid = $usergid;
}
|
if that is not the case for your data, then you can make everyone just a registered user by changing the above code to
| Code: |
$usertype = "Registered";
$gid = $usergid;
|
and the readme explains how to move the avatars:
"3. Copy all files from your old site's forum images/avatars to images/comprofiler
or if you do not have CB, to images/fbfiles/avatars/"
I do not know if the avatars get put into the joomla database properly on a system that does not have CB as I have not tested it that way
OK, I updated the DB, now all of them are "Registered", but in the Users inside the admin, they are still as "Administrator", why is this?
THANK YOU!
============ LAST NEWS =============
I ALREADY FIX IT!!
|
|
yayojet (User)
Junior Boarder
Posts: 21
|
 Logged
|
|
|
Last Edit: 2008/09/17 13:39 By yayojet.
|
|
|
|
|
|
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 3 Weeks ago
|
|
|
One last thing. I have that everybody got registered at 1969-12-31 18:00:00 when in my original is at Aug 31, 2007, for example. I know it wasn't coverted because of how is written, is there a way I can update this column only? from my previous site to this one? I just saw that one is a varchar and the other one is a datetime.
It's the LAST thing I need before migrating!!!
Thank you.
|
|
yayojet (User)
Junior Boarder
Posts: 21
|
Logged
|
|
|
Last Edit: 2008/09/17 14:10 By yayojet.
|
|
|
|
|
|
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 2 Weeks ago
|
|
|
Anyone? Please? The only thing I need is the date of creation of the account. Thank you!!
|
|
yayojet (User)
Junior Boarder
Posts: 21
|
Logged
|
|
|
|
|
|
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 2 Weeks ago
|
|
I have an Oct.1 deadline that is tight so no time to help you and I thought I answered the date question before
You need to change this code:
| Code: |
$registerDate = date( "Y-m-d H:i:s", $row->user_regdate );
$lastvisitDate = date( "Y-m-d H:i:s", $row->user_lastvisit );
|
Once you determine how that user_regdate is stored in your old databse, you can convert it properly. If it is some kind of time string try:
| Code: |
$registerDate = date( "Y-m-d H:i:s", strtotime ($row->user_regdate) );
$lastvisitDate = date( "Y-m-d H:i:s", strtotime ($row->user_lastvisit) );
|
|
|
|
Logged
|
|
|
------------------------------------------------------------------
Kitty Munson Cooper, web designer and programmer,
Open Sky Web Design
|
|
|
|
|
|
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 2 Weeks ago
|
|
kittymcooper wrote:
I have an Oct.1 deadline that is tight so no time to help you and I thought I answered the date question before
You need to change this code:
| Code: |
$registerDate = date( "Y-m-d H:i:s", $row->user_regdate );
$lastvisitDate = date( "Y-m-d H:i:s", $row->user_lastvisit );
|
Once you determine how that user_regdate is stored in your old databse, you can convert it properly. If it is some kind of time string try:
| Code: |
$registerDate = date( "Y-m-d H:i:s", strtotime ($row->user_regdate) );
$lastvisitDate = date( "Y-m-d H:i:s", strtotime ($row->user_lastvisit) );
|
hopefully you get your deadline done.. because you seem to be the only one willing and experience programmer to get the converter to actually work.. 
|
|
|
Logged
|
|
|
Database Version: 5.0.51a-community
Database Collation: utf8_general_ci
PHP Version: 5.2.5
Web Server: Apache/2.0.63 (Unix)
Joomla! Version: Joomla! 1.5.7
|
|
|
|
|
|
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 2 Weeks ago
|
|
|
Thanks subfighter -
I have not forgotten you but I have yet to have the time to work on my new joomla site and make this converter work for joomla 1.5 - mid October is most likely now as I have an early November deadline on another project.
So anyone else with requests for this converter just post them here. I will work on this again in a few weeks time.
|
|
|
Logged
|
|
|
------------------------------------------------------------------
Kitty Munson Cooper, web designer and programmer,
Open Sky Web Design
|
|
|
|
|
|
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 2 Weeks ago
|
|
|
Yes, I hope too you finish your work before deathline!!
Is there a way I can change it directly from phpMyAdmin, I mean, using sql sintaxis? Will be MORE easy to me.
Thank you so much and keep the good work!!
|
|
yayojet (User)
Junior Boarder
Posts: 21
|
Logged
|
|
|
Last Edit: 2008/09/23 23:23 By yayojet.
|
|
|
|
|
|
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 2 Weeks ago
|
|
|
try posting your request in a mySQL forum or the google mySQL group - be specific about the column format that you have and explain you want to change it to a mySQL datetime
|
|
|
Logged
|
|
|
------------------------------------------------------------------
Kitty Munson Cooper, web designer and programmer,
Open Sky Web Design
|
|
|
|
|
|
Re:>>>>phpBB2 to Fireboard - Yes IT w 3 Months, 2 Weeks ago
|
|
|
actually that is wrong, if you are changing it in the old database you want to change it to a unix timestamp which is what the converter expects
|
|
|
Logged
|
|
|
------------------------------------------------------------------
Kitty Munson Cooper, web designer and programmer,
Open Sky Web Design
|
|
|
|
|
|
Re:>>>>phpBB2 to Fireboard - Yes IT w 2 Months, 1 Week ago
|
|
kittymcooper wrote:
Thanks subfighter -
I have not forgotten you but I have yet to have the time to work on my new joomla site and make this converter work for joomla 1.5 - mid October is most likely now as I have an early November deadline on another project.
So anyone else with requests for this converter just post them here. I will work on this again in a few weeks time.
any news on this Kitty> 
|
|
|
Logged
|
|
|
Database Version: 5.0.51a-community
Database Collation: utf8_general_ci
PHP Version: 5.2.5
Web Server: Apache/2.0.63 (Unix)
Joomla! Version: Joomla! 1.5.7
|
|
|
|
|
|
