Develop and Download Open Source Software

XooNIps

Browse CVS Repository

/[OSDN]/xoonips/AL/commonal.cc

Diff of /xoonips/AL/commonal.cc

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

revision 1.20 by youi, Wed Dec 1 04:37:04 2004 UTC revision 1.21 by youi, Wed Dec 1 10:28:58 2004 UTC
# Line 2  Line 2 
2   *   *
3   * $Revision$   * $Revision$
4   * $Log$   * $Log$
5     * Revision 1.21  2004/12/01 10:28:58  youi
6     * DBカラム名の変更に伴う修正
7     *     institute -> division
8     *     organizaion -> company_name
9     *
10   * Revision 1.20  2004/12/01 04:37:04  youi   * Revision 1.20  2004/12/01 04:37:04  youi
11   * freeResult: unsigned int* を int* へ修正.   * freeResult: unsigned int* を int* へ修正.
12   * コメント部に関数の説明を追記.   * コメント部に関数の説明を追記.
# Line 429  result_t getAccounts( sessionid_t sid, c Line 434  result_t getAccounts( sessionid_t sid, c
434      MYSQL_ROW row;      MYSQL_ROW row;
435      account_t* dst = new account_t[ uidsLen ];      account_t* dst = new account_t[ uidsLen ];
436            
437      sql += "SELECT u1.uid, u1.name, u1.uname, u1.email, u1.url, u1.user_avatar, u1.user_regdate, u1.user_icq, u1.user_from, u1.user_sig, u1.user_viewemail, u1.actkey, u1.user_aim, u1.user_yim, u1.user_msnm, u1.pass, u1.posts, u1.attachsig, u1.rank, u1.level, u1.theme, u1.timezone_offset, u1.last_login, u1.umode, u1.uorder, u1.notify_method, u1.notify_mode, u1.user_occ, u1.bio, u1.user_intrest, u1.user_mailok, u2.activate, u2.address, u2.institute, u2.tel, u2.organization, u2.country, u2.zipcode, u2.fax, u2.base_url, u2.notice_mail, u2.notice_mail_since ";      sql += "SELECT u1.uid, u1.name, u1.uname, u1.email, u1.url, u1.user_avatar, u1.user_regdate, u1.user_icq, u1.user_from, u1.user_sig, u1.user_viewemail, u1.actkey, u1.user_aim, u1.user_yim, u1.user_msnm, u1.pass, u1.posts, u1.attachsig, u1.rank, u1.level, u1.theme, u1.timezone_offset, u1.last_login, u1.umode, u1.uorder, u1.notify_method, u1.notify_mode, u1.user_occ, u1.bio, u1.user_intrest, u1.user_mailok, u2.activate, u2.address, u2.division, u2.tel, u2.company_name, u2.country, u2.zipcode, u2.fax, u2.base_url, u2.notice_mail, u2.notice_mail_since ";
438      sql += "FROM " + dbprefix + "_users AS u1, " + dbprefix + "_vpaccount_users AS u2 ";      sql += "FROM " + dbprefix + "_users AS u1, " + dbprefix + "_vpaccount_users AS u2 ";
439      sql += "WHERE u1.uid = u2.uid AND ( u1.uid=" + string( unsignedIntToString( uids[ 0 ] ) );      sql += "WHERE u1.uid = u2.uid AND ( u1.uid=" + string( unsignedIntToString( uids[ 0 ] ) );
440      for( int i = 1; i < uidsLen; i++ ){      for( int i = 1; i < uidsLen; i++ ){
# Line 478  result_t getAccounts( sessionid_t sid, c Line 483  result_t getAccounts( sessionid_t sid, c
483          dst[ i ].setUserMailok( atoi( row[ 30 ] ) );          dst[ i ].setUserMailok( atoi( row[ 30 ] ) );
484          dst[ i ].setActivate( atoi( row[ 31 ] ) );          dst[ i ].setActivate( atoi( row[ 31 ] ) );
485          dst[ i ].setAddress( row[ 32 ] );          dst[ i ].setAddress( row[ 32 ] );
486          dst[ i ].setInstitute( row[ 33 ] );          dst[ i ].setDivision( row[ 33 ] );
487          dst[ i ].setTel( row[ 34 ] );          dst[ i ].setTel( row[ 34 ] );
488          dst[ i ].setOrganization( row[ 35 ] );          dst[ i ].setCompanyName( row[ 35 ] );
489          dst[ i ].setCountry( row[ 36 ] );          dst[ i ].setCountry( row[ 36 ] );
490          dst[ i ].setZipcode( row[ 37 ] );          dst[ i ].setZipcode( row[ 37 ] );
491          dst[ i ].setFax( row[ 38 ] );          dst[ i ].setFax( row[ 38 ] );
# Line 571  result_t insertAccount( sessionid_t sid, Line 576  result_t insertAccount( sessionid_t sid,
576      }      }
577            
578      //vpaccountのユーザテーブルに残りの情報を書き込む      //vpaccountのユーザテーブルに残りの情報を書き込む
579      sql = "INSERT INTO " + dbprefix + "_vpaccount_users (uid, activate, address, institute, tel, organization, country, zipcode, fax, base_url, notice_mail, notice_mail_since) VALUES (";      sql = "INSERT INTO " + dbprefix + "_vpaccount_users (uid, activate, address, division, tel, company_name, country, zipcode, fax, base_url, notice_mail, notice_mail_since) VALUES (";
580      snprintf( buf, 12, "%d", uid );      snprintf( buf, 12, "%d", uid );
581      sql += string( buf ) + ", ";      sql += string( buf ) + ", ";
582      if( account -> getActivate() ){      if( account -> getActivate() ){
# Line 580  result_t insertAccount( sessionid_t sid, Line 585  result_t insertAccount( sessionid_t sid,
585          sql += "0, ";          sql += "0, ";
586      }      }
587      sql += "'" + string( addSlashes( account -> getAddress() ) ) + "', ";      sql += "'" + string( addSlashes( account -> getAddress() ) ) + "', ";
588      sql += "'" + string( addSlashes( account -> getInstitute() ) ) + "', ";      sql += "'" + string( addSlashes( account -> getDivision() ) ) + "', ";
589      sql += "'" + string( addSlashes( account -> getTel() ) ) + "', ";      sql += "'" + string( addSlashes( account -> getTel() ) ) + "', ";
590      sql += "'" + string( addSlashes( account -> getOrganization() ) ) + "', ";      sql += "'" + string( addSlashes( account -> getCompanyName() ) ) + "', ";
591      sql += "'" + string( addSlashes( account -> getCountry() ) ) + "', ";      sql += "'" + string( addSlashes( account -> getCountry() ) ) + "', ";
592      sql += "'" + string( addSlashes( account -> getZipcode() ) ) + "', ";      sql += "'" + string( addSlashes( account -> getZipcode() ) ) + "', ";
593      sql += "'" + string( addSlashes( account -> getFax() ) ) + "', ";      sql += "'" + string( addSlashes( account -> getFax() ) ) + "', ";
# Line 679  result_t updateAccount( sessionid_t sid, Line 684  result_t updateAccount( sessionid_t sid,
684          sql += "0, ";          sql += "0, ";
685      }      }
686      sql += "address='" + string( addSlashes( account -> getAddress() ) ) + "', ";      sql += "address='" + string( addSlashes( account -> getAddress() ) ) + "', ";
687      sql += "institute='" + string( addSlashes( account -> getInstitute() ) ) + "', ";      sql += "division='" + string( addSlashes( account -> getDivision() ) ) + "', ";
688      sql += "tel='" + string( addSlashes( account -> getTel() ) ) + "', ";      sql += "tel='" + string( addSlashes( account -> getTel() ) ) + "', ";
689      sql += "organization='" + string( addSlashes( account -> getOrganization() ) ) + "', ";      sql += "company_name='" + string( addSlashes( account -> getCompanyName() ) ) + "', ";
690      sql += "country='" + string( addSlashes( account -> getCountry() ) ) + "', ";      sql += "country='" + string( addSlashes( account -> getCountry() ) ) + "', ";
691      sql += "zipcode='" + string( addSlashes( account -> getZipcode() ) ) + "', ";      sql += "zipcode='" + string( addSlashes( account -> getZipcode() ) ) + "', ";
692      sql += "fax='" + string( addSlashes( account -> getFax() ) ) + "', ";      sql += "fax='" + string( addSlashes( account -> getFax() ) ) + "', ";
Legend:
Removed from v.1.20  
changed lines
  Added in v.1.21
Back to OSDN">Back to OSDN
 ViewVC Help
Powered by ViewVC 1.1.26  
About OSDN
Find Software
Develop Software
Help