_mf_

I also noticed there’s a phpinfo.php file in the WP main directory. I prefer to remove it so it doesn’t give information on my setup.
My list of files to remove/rename/move elsewhere looks like this:
/phpinfo.php
/licence.txt
/readme.html
/wp-config-sample.php
/wp-admin/import-*.*
/wp-admin/install.php
/wp-admin/install-helper.php
/wp-admin/install-config.php
/wp-admin/upgrade.php
/wp-admin/upgrade-functions.php

Ok, so I’ve found a fix for the problem Mr. Peer was having. Turns out the PHP setup in his server must have magic_quotes_gpc to OFF. So, if I fixed all the queries to add slashes to them (so it works for him), it would not work for me (or others whose servers have this setting on). See:
https://www.zend.com/manual/function.get-magic-quotes-gpc.php
Check the comments in the code, I think it’s self explanatory. I also added a feature to import all posts to a single user, if wanted. So version 0.3 of the pMachine 2.0 importer is online.
If anyone’s willing to test it again, pls. comment back here.

…arbitrary fields that can be accessed by hacks ?? ?

Yes, Xibe. That can easily be added as new functionality. I didn’t have any “closed” posts in PM so I didn’t implement it. I’ll add that to the “to-do” list.

I knew someone had already done this before. I’ll be checking it later this wekend, but if anyone feels like it, go ahead. A different approach, more elegant than what I was talking about. Not sure how it deals with DST, though.

> And where would they set it?
Cookies / sessions, just like some sites manage language detection. A few years ago one would have argued 99% of the Internet was english. Geographic location and time zones differentiation canbe managed the same way. GeoURL info can be used in many ways, I’m hust saying this is one of the ways UTC (GMT) info can be used.
You’re right, perhaps this is still too new/specific to be part of the main package, I think the time will come. ??

Xibe: The current code is like what you posted.
Mr. Peer: Don’t know what I was thinking… This is untested but you can try it. Find these two lines:
$content = $post[‘body’] . “<P />” . $post[‘more’];
$excerpt = $post[‘blurb’];
Change to:
$content = addslashes($post[‘body’] . “<P />” . $post[‘more’]);
$excerpt = addslashes($post[‘blurb’]);
This may also be needed for the users descriptions. Change:
$wp_description = $user[‘bio’] . “\nLocation: ” . $user[‘location’] . “\nOccupation: ” . $user[‘occupation’] . “\nInterests: ” . $user[‘interests’] ;
To:
$wp_description = addslashes($user[‘bio’] . “\nLocation: ” . $user[‘location’] . “\nOccupation: ” . $user[‘occupation’] . “\nInterests: ” . $user[‘interests’] );
Reference:
https://ca2.php.net/manual/en/function.addslashes.php
I will be testing and posting a fix tonight.

MrPeer: I think your PHP setup’s magic_quotes settings may affect this. So, escaping the string may not be the best idea. Let’s try this… change the lines around line 263 for this:
$query = ‘INSERT INTO $tableposts
(post_author, post_date, post_content, post_title, post_category, post_excerpt, post_name, post_status, post_modified)
VALUES
(“$post_author_id”, “$posted”, “$content”, “$title”, “$category”, “$excerpt”, “$post_name”, “publish”, “$posted”)’;
Let us know if that works for you.

I meant visitors as opposed to guests.

Perhaps I wasn’t clear. I really think this is a different topic. If you don’t agree, it doesn’t mean it’s SPAM. And relax! I am not trying to convince anyone here. We can agree to disagree.
Let me explain this differently. When my visitors read my posts, I want them to know at what time at their location I posted and maybe also at what time of *my*location I posted. They could do that if they had a time zone setting in their profile (which to the best of my knowledge, isn’t the case right now). Comments and posts time would be adjusted automatically. It’s very simple code. And yes, there are occasions when I post from different time zones.
I have the strangest feeling that you actually agree with this when reading your post, despite the agressive tone. Feel free to email me via my website if you feel so strongly abouth this. Otherwise perhaps we can continue constructive comments here.
Cheers,
mf.

The SQL query has to be escaped so the single quotes don’t break it. I’ll be releasing a new version when time permits, unless someone sends me the fix before. Thx. for pointing that out, MrPeer!

I don’t understand why we have to insist on understanding GWT (which, by the way, has been replaced by UTC.
Simply ask to “adjust the time” by displaying the current server’s time among 23 other options (timezone offsets). For example, let’s say your server is set at 14:30 but your real time is 18:30.
The field would display “14:30” in a drop-down list and propose to choose 00:30, 01:30, 02:30…
If you choose 18:30 then the calculation is done by the admin script (18:30 – 14:30 = 4 hours offset). So… the offset stored in the DB would be +4 . No need to change DB structures or other logic, simply the interface. Any takers for this 5 minutes mod ? ?? Don’t forget about daytime savings ??

WillM: In fact being asked to clean up my code to include it as part of the package indicates they *do* appreciate it ??
Mr. Peer: Can you share the exact error messages as generated , including the SQL queries ? I have lots of single quotes in my french posts and imported without problem.

Actually, sometimes I think it makes sense to announce/publish stuff here for revision and comments. Then it’s worth the effort to put it cleanly in Wiki. However the Wiki has better tools for history comparison/tracking, IMHO.

I’ve added it to the Wiki, feel free to edit/update it there.