modules/links/update-weblinks-old.php

<?php
// $Id: update-weblinks-old.php,v 1.2 2006/01/21 19:21:28 syscrusher Exp $

/**
 * @file
 * PHP page for updating legacy "weblink" nodes, from the old table format prior to
 * Drupal 4.6.
 *
 * WARNING 1: This script will NOT work with Ber Kessels' new weblink.module for
 * Drupal 4.6. Use update-weblinks.php instead!
 *
 * WARNING 2: Monitoring is not yet supported, and therefore this script does not
 * migrate URL monitoring parameters. If you need that feature, you need to wait
 * a bit before deploying the new links package.
 *
 * TO USE: First, update your site to Drupal 4.7 so that your {node} table gets
 *         converted.
 *
 *         Second, install the new links module package, including links_related and
 *         links_weblink.
 *
 *         Next, copy this script to your Drupal root directory (the "top level" of
 *         your Drupal site) and run it. It will convert no more than 1000 links at
 *         a time, to minimize the chance of timeouts. You can safely re-run the
 *         script multiple times.
 *
 * THIS CODE IS EXPERIMENTAL -- NOT FOR PRODUCTION USE
 */

require_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

$sql = "SELECT DISTINCT n.nid, n.title, wl.* FROM {node} n INNER JOIN {weblink} wl ON n.nid=wl.nid LEFT JOIN {links_node} ln ON wl.nid=ln.nid WHERE n.type='weblink' AND ln.nid IS NULL LIMIT 1000";
$sql2 = "INSERT INTO {links_node} (lid,nid,link_title,weight,clicks,module) values (%d,%d,'%s',-5,%d,'links_weblink')";

print('<html><body>');
$count=0;
$result = db_query($sql);
while ($row = db_fetch_object($result)) {
  $n_url = links_normalize_url($row->weblink);
  if (empty($n_url)) {
    print("<br>Node ".$row->nid." was not converted (empty URL)");
    continue;
  }
  $lid = links_put_link($n_url);
  if (! $lid) {
    print("<br>Node ".$row->nid." was not converted (failed link insert)");
    continue;
  } 
  links_delete_links_for_node($row->nid);
  $title = links_suggest_link_title($lid, $row->title);
  $clicks = $row->click;
  $result2 = db_query($sql2, $lid, $row->nid, $title, $clicks);
  $count++;
}
print("<P>Processed $count weblink records. The script limits the number in one run to prevent timeouts. If no errors, rerun this script until the count is zero; it may take several iterations.");
print("<P>WARNING: Monitoring parameters are not yet supported and are currently ignored.");
print('</body></html>');
?>
1	<?php
2	// $Id: update-weblinks-old.php,v 1.2 2006/01/21 19:21:28 syscrusher Exp $
3
4	/**
5	* @file
6	* PHP page for updating legacy "weblink" nodes, from the old table format prior to
7	* Drupal 4.6.
8	*
9	* WARNING 1: This script will NOT work with Ber Kessels' new weblink.module for
10	* Drupal 4.6. Use update-weblinks.php instead!
11	*
12	* WARNING 2: Monitoring is not yet supported, and therefore this script does not
13	* migrate URL monitoring parameters. If you need that feature, you need to wait
14	* a bit before deploying the new links package.
15	*
16	* TO USE: First, update your site to Drupal 4.7 so that your {node} table gets
17	* converted.
18	*
19	* Second, install the new links module package, including links_related and
20	* links_weblink.
21	*
22	* Next, copy this script to your Drupal root directory (the "top level" of
23	* your Drupal site) and run it. It will convert no more than 1000 links at
24	* a time, to minimize the chance of timeouts. You can safely re-run the
25	* script multiple times.
26	*
27	* THIS CODE IS EXPERIMENTAL -- NOT FOR PRODUCTION USE
28	*/
29
30	require_once './includes/bootstrap.inc';
31	drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
32
33	$sql = "SELECT DISTINCT n.nid, n.title, wl.* FROM {node} n INNER JOIN {weblink} wl ON n.nid=wl.nid LEFT JOIN {links_node} ln ON wl.nid=ln.nid WHERE n.type='weblink' AND ln.nid IS NULL LIMIT 1000";
34	$sql2 = "INSERT INTO {links_node} (lid,nid,link_title,weight,clicks,module) values (%d,%d,'%s',-5,%d,'links_weblink')";
35
36	print('<html><body>');
37	$count=0;
38	$result = db_query($sql);
39	while ($row = db_fetch_object($result)) {
40	$n_url = links_normalize_url($row->weblink);
41	if (empty($n_url)) {
42	print("<br>Node ".$row->nid." was not converted (empty URL)");
43	continue;
44	}
45	$lid = links_put_link($n_url);
46	if (! $lid) {
47	print("<br>Node ".$row->nid." was not converted (failed link insert)");
48	continue;
49	}
50	links_delete_links_for_node($row->nid);
51	$title = links_suggest_link_title($lid, $row->title);
52	$clicks = $row->click;
53	$result2 = db_query($sql2, $lid, $row->nid, $title, $clicks);
54	$count++;
55	}
56	print("<P>Processed $count weblink records. The script limits the number in one run to prevent timeouts. If no errors, rerun this script until the count is zero; it may take several iterations.");
57	print("<P>WARNING: Monitoring parameters are not yet supported and are currently ignored.");
58	print('</body></html>');
59	?>