/[libdata]/branches/paul_xx/admin/include/scribe_fix.php
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /branches/paul_xx/admin/include/scribe_fix.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

branches/paul/admin/include/scribe_fix.php revision 68 by dpavlin, Thu Mar 18 19:24:54 2004 UTC branches/paul_xx/admin/include/scribe_fix.php revision 69 by dpavlin, Thu Mar 18 20:01:09 2004 UTC
# Line 54  function errorTrap($page_id){ Line 54  function errorTrap($page_id){
54          // Distinct orders          // Distinct orders
55          $sql = "SELECT DISTINCT element_order FROM element WHERE page_id ="          $sql = "SELECT DISTINCT element_order FROM element WHERE page_id ="
56                  . $page_id;                  . $page_id;
57          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
58          $num_orders = mysql_num_rows($rs);          $num_orders = xx_num_rows($rs);
59          printf("Unique orders: %d<br>\n", $num_orders);          printf("Unique orders: %d<br>\n", $num_orders);
60                    
61          // Number of rows (should be the same)          // Number of rows (should be the same)
62          $sql = "SELECT element_id FROM element WHERE page_id = "          $sql = "SELECT element_id FROM element WHERE page_id = "
63                  . $page_id;                  . $page_id;
64          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
65          $num_rows = mysql_num_rows($rs);          $num_rows = xx_num_rows($rs);
66          printf("Number of rows: %d<BR>\n", $num_rows);          printf("Number of rows: %d<BR>\n", $num_rows);
67                    
68          // Smallest order (if rows present, should be 1)          // Smallest order (if rows present, should be 1)
69          $sql = "SELECT MIN(element_order) as min_order FROM element WHERE page_id = "          $sql = "SELECT MIN(element_order) as min_order FROM element WHERE page_id = "
70                  . $page_id;                  . $page_id;
71          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
72          $row = mysql_fetch_array ($rs, MYSQL_ASSOC);          $row = xx_fetch_array ($rs, xx_ASSOC);
73          $min_order = $row["min_order"];          $min_order = $row["min_order"];
74          printf("First order: %d<br>\n", $min_order);          printf("First order: %d<br>\n", $min_order);
75                    
76          // Largest order (should equal distinct rows and number of rows          // Largest order (should equal distinct rows and number of rows
77          $sql = "SELECT MAX(element_order) as max_order FROM element WHERE page_id = "          $sql = "SELECT MAX(element_order) as max_order FROM element WHERE page_id = "
78                  . $page_id;                  . $page_id;
79          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
80          $row = mysql_fetch_array ($rs, MYSQL_ASSOC);          $row = xx_fetch_array ($rs, xx_ASSOC);
81          $max_order = $row["max_order"];          $max_order = $row["max_order"];
82          printf("Last order: %d<br><br>\n", $max_order);          printf("Last order: %d<br><br>\n", $max_order);
83                    
# Line 89  function errorTrap($page_id){ Line 89  function errorTrap($page_id){
89          $c1_sql = "SELECT element_id, parent_id, element_order, indent_level FROM element WHERE page_id = "          $c1_sql = "SELECT element_id, parent_id, element_order, indent_level FROM element WHERE page_id = "
90                  . $page_id                  . $page_id
91                  . " AND parent_id > 0 ORDER BY element_order";                  . " AND parent_id > 0 ORDER BY element_order";
92          $c1_rs = mysql_tryquery($c1_sql);          $c1_rs = xx_tryquery($c1_sql);
93                                    
94          while ($c1_row = mysql_fetch_array ($c1_rs, MYSQL_ASSOC)) {          while ($c1_row = xx_fetch_array ($c1_rs, xx_ASSOC)) {
95                  $parent_id = $c1_row["parent_id"];                  $parent_id = $c1_row["parent_id"];
96                  $indent_level = $c1_row["indent_level"];                  $indent_level = $c1_row["indent_level"];
97                  $element_id = $c1_row["element_id"];                  $element_id = $c1_row["element_id"];
# Line 100  function errorTrap($page_id){ Line 100  function errorTrap($page_id){
100                  // For each row returned, hunt for the parent                  // For each row returned, hunt for the parent
101                  $c2_sql ="SELECT element_id, element_order, indent_level FROM element WHERE element_id = "                  $c2_sql ="SELECT element_id, element_order, indent_level FROM element WHERE element_id = "
102                           . $parent_id;                           . $parent_id;
103                  $c2_rs = mysql_tryquery($c2_sql);                  $c2_rs = xx_tryquery($c2_sql);
104                  $c2_row = mysql_fetch_array ($c2_rs, MYSQL_ASSOC);                  $c2_row = xx_fetch_array ($c2_rs, xx_ASSOC);
105                  $c2_indent_level = $c2_row["indent_level"];                  $c2_indent_level = $c2_row["indent_level"];
106                  $c2_element_id = $c2_row["element_id"];                  $c2_element_id = $c2_row["element_id"];
107                  $c2_element_order = $c2_row["element_order"];                  $c2_element_order = $c2_row["element_order"];
# Line 173  function errorTrap($page_id){ Line 173  function errorTrap($page_id){
173                  . $page_id                  . $page_id
174                  . " ORDER BY element_order";                  . " ORDER BY element_order";
175    
176          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
177    
178          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
179                  $element_id = $row["element_id"];                  $element_id = $row["element_id"];
180                  $indent_level = $row["indent_level"];                            $indent_level = $row["indent_level"];          
181                  $parent_id = $row["parent_id"];                          $parent_id = $row["parent_id"];        
# Line 237  function genCalc($element_id, $gen_level Line 237  function genCalc($element_id, $gen_level
237                          . " AND page_id = "                          . " AND page_id = "
238                          . $page_id;                          . $page_id;
239                                                    
240                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
241                  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                  $row = xx_fetch_array ($rs, xx_ASSOC);
242                  $probe_parent_id = $row["parent_id"];                  $probe_parent_id = $row["parent_id"];
243                  $probe_element_id = $row["parent_id"];                            $probe_element_id = $row["parent_id"];          
244                                    
# Line 291  function isOrphan($element_id, $element_ Line 291  function isOrphan($element_id, $element_
291                  // testing                  // testing
292                  // printf("orphan probe sql was: %s ", $sql);                  // printf("orphan probe sql was: %s ", $sql);
293    
294                  $rs = mysql_tryquery($sql);                  $rs = xx_tryquery($sql);
295                  $row = mysql_fetch_array ($rs, MYSQL_ASSOC);                  $row = xx_fetch_array ($rs, xx_ASSOC);
296                  $par_found = $row["par_found"];                  $par_found = $row["par_found"];
297    
298                  // Should have only one match.  If none (or multiple) set to 0.                  // Should have only one match.  If none (or multiple) set to 0.
# Line 331  function purgeOrphans($page_id) { Line 331  function purgeOrphans($page_id) {
331                  . $page_id                  . $page_id
332                  . " ORDER BY element_order";                  . " ORDER BY element_order";
333    
334          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
335    
336          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
337                  $element_id = $row["element_id"];                  $element_id = $row["element_id"];
338                  $element_order = $row["element_order"];                  $element_order = $row["element_order"];
339                  $parent_id = $row["parent_id"];                          $parent_id = $row["parent_id"];        
# Line 350  function purgeOrphans($page_id) { Line 350  function purgeOrphans($page_id) {
350                                  . $element_id                                  . $element_id
351                                  . " AND parent_id = "                                  . " AND parent_id = "
352                                  . $parent_id;                                  . $parent_id;
353                          if (mysql_tryquery ($sub_sql)) printf("Element %d was an orphan.  Deleted it.<br>\n", $element_id);                                              if (xx_tryquery ($sub_sql)) printf("Element %d was an orphan.  Deleted it.<br>\n", $element_id);                        
354    
355                  } // delete all elements which are orphaned                  } // delete all elements which are orphaned
356    
# Line 379  function purgeRelationships($page_id) { Line 379  function purgeRelationships($page_id) {
379                  SET parent_id = 0, indent_level = 0                  SET parent_id = 0, indent_level = 0
380                  WHERE page_id = "                  WHERE page_id = "
381                  . $page_id;                  . $page_id;
382          if (mysql_tryquery ($sql)) printf("Purged all!<br>\n");          if (xx_tryquery ($sql)) printf("Purged all!<br>\n");
383    
384  } // end purgeRelationships  } // end purgeRelationships
385    
# Line 469  function updateGenerations($page_id) { Line 469  function updateGenerations($page_id) {
469                  . $page_id                  . $page_id
470                  . " ORDER BY element_order";                  . " ORDER BY element_order";
471    
472          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
473    
474          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
475                  $element_id = $row["element_id"];                  $element_id = $row["element_id"];
476                  $indent_level = $row["indent_level"];                  $indent_level = $row["indent_level"];
477                  $parent_id = $row["parent_id"];                  $parent_id = $row["parent_id"];
# Line 496  function updateGenerations($page_id) { Line 496  function updateGenerations($page_id) {
496                                  . $page_id                                  . $page_id
497                                  . " AND element_id = "                                  . " AND element_id = "
498                                  . $element_id;                                  . $element_id;
499                          if (mysql_tryquery ($sub_sql)) printf("Element #%d reported generation of %d, but calculated at %d.  Fixed.<br>\n", $element_id, $indent_level, $gen_level);                          if (xx_tryquery ($sub_sql)) printf("Element #%d reported generation of %d, but calculated at %d.  Fixed.<br>\n", $element_id, $indent_level, $gen_level);
500    
501                  } // if there is a discrepancy with calculated generation level                  } // if there is a discrepancy with calculated generation level
502    
# Line 535  function updateOrders($page_id) { Line 535  function updateOrders($page_id) {
535                  . $page_id                  . $page_id
536                  . " ORDER BY element_order";                  . " ORDER BY element_order";
537    
538          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
539    
540          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
541                  $element_id = $row["element_id"];                  $element_id = $row["element_id"];
542                  $element_order = $row["element_order"];                  $element_order = $row["element_order"];
543    
# Line 558  function updateOrders($page_id) { Line 558  function updateOrders($page_id) {
558                                  . $page_id                                  . $page_id
559                                  . " AND element_id = "                                  . " AND element_id = "
560                                  . $element_id;                                  . $element_id;
561                          if (mysql_tryquery ($sub_sql)) printf("Row #%d reported cardinal order of %d, but calculated at %d.  Fixed.<br>\n", $element_count, $element_order, $element_count);                          if (xx_tryquery ($sub_sql)) printf("Row #%d reported cardinal order of %d, but calculated at %d.  Fixed.<br>\n", $element_count, $element_order, $element_count);
562    
563                  } // if an order discrepancy was found                  } // if an order discrepancy was found
564    
# Line 598  function updateOrphans($page_id) { Line 598  function updateOrphans($page_id) {
598                  . $page_id                  . $page_id
599                  . " ORDER BY element_order";                  . " ORDER BY element_order";
600    
601          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
602    
603          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
604                  $element_id = $row["element_id"];                  $element_id = $row["element_id"];
605                  $element_order = $row["element_order"];                  $element_order = $row["element_order"];
606                  $parent_id = $row["parent_id"];                  $parent_id = $row["parent_id"];
# Line 623  function updateOrphans($page_id) { Line 623  function updateOrphans($page_id) {
623                                  . $page_id                                  . $page_id
624                                  . " AND element_id = "                                  . " AND element_id = "
625                                  . $element_id;                                  . $element_id;
626                          if (mysql_tryquery ($sub_sql)) printf("Element #%d orphaned.  Reassigned to parent #%d<br>\n", $element_id, $new_parent_id);                          if (xx_tryquery ($sub_sql)) printf("Element #%d orphaned.  Reassigned to parent #%d<br>\n", $element_id, $new_parent_id);
627    
628                  } // reassign problematic elements                  } // reassign problematic elements
629    
Legend:
Removed from v.68  
changed lines
  Added in v.69
  ViewVC Help
Powered by ViewVC 1.1.26