| 1 | <? |
| 2 | |
| 3 | require('config/config.inc'); |
| 4 | require(SYSTEM_ROOT.'inc/database.inc'); |
| 5 | |
| 6 | $db=new CLASS_DATABASE(); |
| 7 | |
| 8 | $query = "select * from nodes where node_name = 'maart' and external_link = 'db://user'"; |
| 9 | $set = $db->query($query); |
| 10 | |
| 11 | $count = $set->getNumRows(); |
| 12 | |
| 13 | // echo "<b>Fixing ownership problems for $count users...</b><br><br>"; |
| 14 | |
| 15 | while($set->next()) |
| 16 | { |
| 17 | echo $set->getString('node_id')." :: ".$set->getString('node_name')."<br>"; |
| 18 | $victims[] = $set->getString('node_id'); |
| 19 | } |
| 20 | |
| 21 | // foreach($victims as $target) |
| 22 | // { |
| 23 | // $query = "update nodes set node_creator = '$target' where node_id = '$target'"; |
| 24 | // $db->query($query); |
| 25 | // echo "User_id $target ownership problem fixed.<br>"; |
| 26 | // } |
| 27 | |
| 28 | // echo "<br><br><b>Fix script finished!<br>U has to believe that nothing has fucked up ;o)!</b>"; |
| 29 | |
| 30 | ?> |