5
Quote:
panigrc wrote:
mikhail can you give me the link because I couldn't find it ?
Sure!
Was commented here:
https://xoops.org/modules/newbb/viewtopic.php?viewmode=flat&topic_id=34209&forum=30
and here:
https://xoops.org/modules/newbb/viewtopic.php?topic_id=37486&start=10
And this is the code (please, look how easy is):
###### PURE SQL, PHP NOT NEEDED
REPLACE INTO
xoops_wiwi( id, keyword, title, body, lastmodified, u_id, visible, parent, pageid, prid, contextBlock )
SELECT
cur_id, cur_title, cur_title, cur_text, UNIX_TIMESTAMP(cur_timestamp), cur_user, 1, 'underpop', cur_id, cur_id, ''
FROM cur
Obs: "cur" is the name of the main wikipedia table. And this code can be used with phpmyadmin.
I use something like UNIX_TIMESTAMP(thedate) and TIMESTAMP(thedate) to covert some phpnuke tables that use a diferent date format. But a simple code like this solve the "problem".