Changeset 140

Show
Ignore:
Timestamp:
2008-03-18 16:38:36 (10 months ago)
Author:
hannes
Message:

putting default blank avatar into PHP script instead of assigning a default value to the database field, as at least MySQL doesn't seem to like that

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/classes/pages/Register.php

    r137 r140  
    100100                             * not every db supports this, but usually, it should work without locking, too; there just is the risk of a wrong member id being returned in the second query which is very unlikely - it can only occur on forums with very high traffic */ 
    101101                            @$C->query('LOCK TABLE ' . $SETTINGS['dbtableprefix'] . 'members WRITE'); 
    102                             $q = $C->prepare('INSERT INTO ' . $SETTINGS['dbtableprefix'] . 'members (membername, memberemail, memberpassword, registered, memberstatus) VALUES (:user, :email, :pw, :ts, :member)'); 
     102                            $q = $C->prepare('INSERT INTO ' . $SETTINGS['dbtableprefix'] . 'members (membername, memberemail, memberpassword, registered, memberstatus, memberavatar) VALUES (:user, :email, :pw, :ts, :member, :avatar)'); 
    103103                            // the actual password will be entered seperately 
    104104                            $_pw = '*'; 
    …… 
    110110                            $q->bindParam(':ts', $_t->format('Y-m-d H:i:s'), PDO::PARAM_STR, 19); 
    111111                            $q->bindParam(':member', $_member, PDO::PARAM_STR, 6); 
     112                            $q->bindValue(':avatar', 'images/spacer.gif', PDO::PARAM_STR); 
    112113                            $q->execute(); 
    113114                            $q = NULL; 

  • trunk/db/mysql.sql

    r111 r140  
    7979  memberemailhidden INTEGER NOT NULL DEFAULT 0, 
    8080  memberhomepage VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL, 
    81   memberavatar VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'images/spacer.gif', 
     81  memberavatar VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, 
    8282  memberpassword VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, 
    8383  memberstatus VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, 

  • trunk/db/sqlite.sql

    r111 r140  
    7979  memberemailhidden INTEGER NOT NULL DEFAULT 0, 
    8080  memberhomepage VARCHAR(255) NULL COLLATE NOCASE, 
    81   memberavatar VARCHAR(255) NOT NULL DEFAULT 'images/spacer.gif', 
     81  memberavatar VARCHAR(255) NOT NULL, 
    8282  memberpassword VARCHAR(255) NOT NULL COLLATE BINARY, 
    8383  memberstatus VARCHAR(255) NOT NULL COLLATE NOCASE,