scripts/contentregexp.php

   1 <?php
   2 //requiring main config file with path/database etc. constants
   3 require('../config/config.inc');
   4
   5 //connecting to database and creating universal $db object
   6 require(SYSTEM_ROOT.'/inc/log.inc');
   7 require(SYSTEM_ROOT.'/inc/database.inc');
   8 require(SYSTEM_ROOT.'/inc/nodes.inc');
   9 $db=new CLASS_DATABASE();
  10 $db_old=new CLASS_DATABASE("kyberia","kyberia","cyb3ry","127.0.0.1");
  11
  12 $q="select node_id,node_content from node_content order by node_id";
  13 $set=$db->query($q);
  14
  15 while ($set->next()) {
  16         $node_content=$set->getString('node_content');
  17         $new_content=preg_replace_callback("/(http:\/\/www.kyberia.sk\/([a-zA-Z]*).php)?\?(action=([a-zA-Z]*))?\&(node_id=([0-9]*))?(\&alone=([0-9]*))?/i","changeRegExp",$node_content);
  18         if ($new_content!=$node_content) {
  19                 $node_id=$set->getString('node_id');
  20                 $new_content=AddSlashes($new_content);
  21                 $db->query("update node_content set node_content='$new_content' where node_id='$node_id'");
  22                 echo $node_id." updated<br>";
  23         }
  24 }
  25
  26 function changeRegExp($match) {
  27 global $db;
  28
  29                 if ($match[8]) {
  30                         $q="select node_id from nodes where node_type='4' and old_id='".$match[8]."'";
  31                         $s=$db->query($q);
  32                         $s->next();
  33                         $id=$s->getString('node_id');
  34                         return "/id/$id";
  35                 }
  36                 else {
  37                         if ($match[4]=='forum') {
  38                                 $q="select node_id from nodes where node_type='3' and old_id='".$match[6]."'";
  39                                 $s=$db->query($q);
  40                                 $s->next();
  41                                 $id=$s->getString('node_id');
  42                                 return "/id/$id";
  43                         }
  44                 }
  45 }
  46
  47 ?>
  48
  49