---

pr_member_create.h

Go to the documentation of this file.

/*
 * $Id: pr_member_create.h,v 1.2 2002/12/10 13:38:12 dsamersoff Exp $
 *
 */

#ifndef pr_member_create_h 
#define pr_member_create_h 
 
#include <dsSPWrapper.h>
#include <pw_generate.h>

           
class pr_member_create : public dsSPWrapper
{

 public:
       SQLOUT long member_id;
       SQLIN  char first_name[71];
       SQLIN  char last_name[71];
       SQLIN  char e_mail[130];
       SQLIN  char phone[65];
       SQLIN  char member_login[31];
       SQLIN  char member_password[31];   
       SQLIN  char country_tag[5];
       SQLIN  char zip_code[31];
       SQLIN  char address[257];          
       SQLIN  char city[71];          
       SQLIN  char state_tag[5];

       SQLIN char signup_key[64];


    virtual void Dump(ostream& os)
    {
      os <<  "memeber_id:         '"  << member_id          << "'\n";
      os <<  "first_name:         '"  << first_name         << "'\n";
      os <<  "last_name:          '"  << last_name          << "'\n";
      os <<  "e_mail:             '"  << e_mail             << "'\n";
      os <<  "phone:              '"  << phone              << "'\n";
      os <<  "member_login:       '"  << member_login       << "'\n";
      os <<  "member_password:    '"  << member_password    << "'\n";
      os <<  "country_tag:        '"  << country_tag        << "'\n";
      os <<  "zip_code:           '"  << zip_code           << "'\n";
      os <<  "address:            '"  << address            << "'\n";
      os <<  "city:               '"  << city               << "'\n";
      os <<  "state_tag:          '"  << state_tag          << "'\n";

      os <<  "signup_key:         '"  << signup_key   << "'\n";
    }

    
    virtual void Execute(dsOCI *pg)
    {
        _fl->log(0xFF, "PR_MEMBER_CREATE (%s)", member_login);

        const char *query = "BEGIN PK_SIGNUP.PR_MEMBER_CREATE(:member_id,"\
                              ":first_name,:last_name,:e_mail,:phone,"\
                              ":member_login,:member_password,:country_tag,:zip_code,"\
                              ":address,:city,:state_tag,"\
                              ":signup_key); END" );


         OCIStmt *stmt = pg->PrepareCall(query);

           pg->BindParam(stmt, "member_id",          SQLT_INT, &member_id,          sizeof(member_id)         );
           pg->BindParam(stmt, "first_name",         SQLT_STR, first_name,          sizeof(first_name)        );
           pg->BindParam(stmt, "last_name",          SQLT_STR, last_name,           sizeof(last_name)         );
           pg->BindParam(stmt, "e_mail",             SQLT_STR, e_mail,              sizeof(e_mail)            );
           pg->BindParam(stmt, "phone",              SQLT_STR, phone,               sizeof(phone)             );
           pg->BindParam(stmt, "member_login",       SQLT_STR, member_login,        sizeof(member_login)      );
           pg->BindParam(stmt, "member_password",    SQLT_STR, member_password,     sizeof(member_password)   );
           pg->BindParam(stmt, "country_tag",        SQLT_STR, country_tag,         sizeof(country_tag)       );
           pg->BindParam(stmt, "zip_code",           SQLT_STR, zip_code,            sizeof(zip_code)          );
           pg->BindParam(stmt, "address",            SQLT_STR, address,             sizeof(address)           );
           pg->BindParam(stmt, "city",               SQLT_STR, city,                sizeof(city)              );
           pg->BindParam(stmt, "state_tag",          SQLT_STR, state_tag,           sizeof(state_tag)         );

           pg->BindParam(stmt, "signup_key",         SQLT_STR,  signup_key,         sizeof(signup_key)        );


         pg->Execute( stmt, 1, COMMIT_ON_SUCCESS );

         pg->ReleaseCall(stmt);
         delete query;
    }

    pr_member_create(dsCGI *cgi)
    {
        website_id         = cgi->geti("website_id");

        size_strcpy(first_name,      cgi->gete("first_name"),      sizeof(first_name)      );
        size_strcpy(last_name,       cgi->gete("last_name"),       sizeof(last_name)       );
        size_strcpy(e_mail,          cgi->gete("e_mail"),          sizeof(e_mail)          );
        size_strcpy(phone,           cgi->get("phone", "N/A"),      sizeof(phone)           );
        size_strcpy(member_login,    cgi->gete("member_login"),    sizeof(member_login)    );
        
        // Password should not be passed throuph cgi: 
        //      size_strcpy(member_password, cgi->gete("member_password"), sizeof(member_password) );
         size_strcpy(member_password, raw_generate_passwd(), sizeof(member_password) );

        size_strcpy(country_tag,     cgi->gete("country_tag"),    sizeof(country_tag) );
        size_strcpy(zip_code,        cgi->get("zip_code","N/A"),   sizeof(zip_code)    );
        size_strcpy(address,         cgi->get("address","N/A"),    sizeof(address)     );          
        size_strcpy(city,            cgi->get("city","N/A"),       sizeof(city)        );          
        size_strcpy(state_tag,       cgi->get("state_tag","N/A"),  sizeof(state_tag)   );

        size_strcpy(signup_key, cgi->gete("key"),        sizeof(signup_key)); 
    }


};

#endif

---