Hi equinox,
Backup first (under Admin > General > Backup) and then you can just create a new the script like this:
<?php
// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('C:/wamp/www/sb/CMS Builder/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
// load records from 'drills'
list($drillsRecords, $drillsMetaData) = getRecords(array(
'tableName' => 'drills',
'loadUploads' => true,
));
foreach($drillsRecords as $record){
print "Inserting record #{$record['num']}<br/>\n";
mysql_insert('advanced_drills ', $record, true);
}
print "Done!";
?>
Careful not to refresh it multiple times or it will copy the records twice!
Note: If the script doesn't run just update the "// load viewer library" code with code that was generated for your website.
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com