Added some more hooks to the page editing pipeline. It should now be possible to add controls to the page editor, send the data from them out to the server, and process them on the server side.
+ − <?php
+ −
+ − // Migrate usernames in the logs table
+ −
+ − global $db, $session, $paths, $template, $plugins; // Common objects
+ −
+ − $q = $db->sql_query('SELECT user_id, username FROM ' . table_prefix . 'users;');
+ − if ( !$q )
+ − $db->_die();
+ −
+ − $map = array();
+ − while($row = $db->fetchrow())
+ − {
+ − $map[ $row['username'] ] = $row['user_id'];
+ − }
+ − $db->free_result();
+ −
+ − $q = $db->sql_query('SELECT author FROM ' . table_prefix . 'logs WHERE author_uid = 1;');
+ − if ( !$q )
+ − $db->_die();
+ −
+ − $updated = array();
+ −
+ − while ( $row = $db->fetchrow($q) )
+ − {
+ − if ( isset($map[ $row['author'] ]) && !is_valid_ip($row['author']) && !in_array($row['author'], $updated) )
+ − {
+ − $author = $db->escape($row['author']);
+ − $sql = "UPDATE " . table_prefix . "logs SET author_uid = {$map[ $row['author'] ]} WHERE author = '$author';";
+ − if ( !$db->sql_query($sql) )
+ − $db->_die();
+ − $updated[] = $row['author'];
+ − }
+ − }
+ −