Changeset 33 for trunk/actions/my/register_translator.action.php

Timestamp:

09/03/05 22:42:52 (7 years ago)

Author:

alexx

Message:

• Auth: Remove MySQL PASSWORD hashing method to hash password, replace by MD5 hashing, add code to make a smooth transition between hashing method
• XML engine: Fix a trivial recent bug in dotnode-xml.php
• Robots: fix a bug in crontab script robots/launch_robots.sh (add cd dirname $0)
• CSS: Add max_width to image in blog (work on Mozilla/*, Opera but not good on Safari (no proportional resizing), of course, that doesn't work on IE)
• DB: changing DB structure !!!

  ALTER TABLE `user` ADD `passwd_md5` CHAR( 32 ) NOT NULL AFTER `passwd` ;
  ALTER TABLE `user` CHANGE `passwd` `passwd` VARCHAR( 42 ) NULL ;
  ALTER TABLE `dntp_translator` ADD `passwd_md5` CHAR( 32 ) NOT NULL AFTER `passwd` ;
  ALTER TABLE `dntp_translator` CHANGE `passwd` `passwd` VARCHAR( 42 ) NULL ;
  

Files:

• trunk/actions/my/register_translator.action.php (modified) (1 diff)

trunk/actions/my/register_translator.action.php

@@ -23 +23 @@
  ******************** http://opensource.ikse.net/projects/dotnode ***/
 
-$passwd = $db->getOne('SELECT passwd FROM user WHERE id=?', array($_SESSION['my_id']));
+$passwd = $db->getOne('SELECT passwd_md5 FROM user WHERE id=?', array($_SESSION['my_id']));
 $data = array(
         'id_dotnode' => $_SESSION['my_id'],
         'login' => $_SESSION['my_login'],
-        'passwd' => $passwd,
+        'passwd_md5' => $passwd,
         'comment' => stripslashes($_POST['comment']),
         'status' => 'waiting',