Emaze Auction: Create/Edit User

To edit a user(s), you must first choose which user(s) to edit. You can select the user(s) by user ID, username, and/or name. Don't worry about choosing the same user more than once since the system will simply filter them out.

After choosing the user(s) you want to edit, choose the order in which you want those users listed. The list will be displayed in the same middle frame. You can then click on the user to edit their info, which will be done in this window.

You may also search for the user(s) by entering their last name, first name, username, email address, or organization. This can be the full or partial value.

Finally, the resulting list of users will also allow you to delete the users from the user database. Simply check the checkbox next to the users you want to delete, and then click on the "Delete Users" button which will be at the bottom of the list. Be sure to check the checkbox following the Delete button. ", "ALL")> ", "ALL")> ", "ALL")> SELECT userID, userStatus, userVerifyCode, email FROM Member WHERE username = '#Form.username#' SELECT userID, userStatus, userVerifyCode, email FROM Member WHERE username = '#Form.username#' AND userID <> #userID# #messageBadRegistration#

#Evaluate(errorList)#

#messageBadRegistration2# INSERT INTO Member (username, password, firstName, lastName, email, mothersMaidenName, phone, phoneExtension, phone2, phone2Extension, organization, userEmailEvents, creditCardType, creditCardNumber, creditCardExpiration, creditCardName, address, address2, city, state, zipCode, country, billingSameAsShipping, billingAddress, billingAddress2, billingCity, billingState, billingZipCode, billingCountry, useCookie, userVerifyCode, userStatus, userCreatedDateTime, userEditedDateTime, feedbackRating, feedbackCountPositive, feedbackCountNegative, feedbackCountNeutral, feedbackCountTotal, numberOfBids, numberOfWins, amountOfAuctionPurchases, accountBalance, accountBalanceAsOfDateTime) VALUES ('#Form.username#', '#password#', NULL, NULL, '#Form.firstName#', NULL, NULL, '#Form.lastName#', NULL, NULL, '#Form.email#', NULL, NULL, '#Form.mothersMaidenName#', NULL, NULL, '#Form.phone#', NULL, NULL, '#Form.phoneExtension#', NULL, NULL, '#Form.phone2#', NULL, NULL, '#Form.phone2Extension#', NULL, NULL, '#Form.organization#', NULL, NULL, '#Form.userEmailEvents#', NULL, NULL, '#Form.creditCardType#', NULL, NULL, '#creditCardNumber#', NULL, NULL, '#creditCardExpiration#', NULL, NULL, '#Form.creditCardName#', NULL, NULL, '#Form.address#', NULL, NULL, '#Form.address2#', NULL, NULL, '#Form.city#', NULL, NULL, '#state#', NULL, NULL, '#Form.zipCode#', NULL, NULL, '#country#', 0, NULL, NULL, '#Form.billingAddress#', NULL, NULL, '#Form.billingAddress2#', NULL, NULL, '#Form.billingCity#', NULL, NULL, '#billingState#', NULL, NULL, '#Form.billingZipCode#', NULL, NULL, '#billingCountry#', 1, NULL, NULL, '#Form.address#', NULL, NULL, '#Form.address2#', NULL, NULL, '#Form.city#', NULL, NULL, '#state#', NULL, NULL, '#Form.zipCode#', NULL, NULL, '#country#', 0, 1, '#userVerifyCode#', #userStatus#, #nowDateTime#, #nowDateTime#, 0, 0, 0, 0, 0, 0, 0, 0, 0, #nowDateTime#) UPDATE Member SET useCookie = 1,0, username = '#Form.username#', password = '#password#', firstName = NULL,'#Form.firstName#', lastName = NULL,'#Form.lastName#', email = NULL,'#Form.email#', mothersMaidenName = NULL,'#Form.mothersMaidenName#', phone = NULL,'#Form.phone#', phoneExtension = NULL,'#Form.phoneExtension#', phone2 = NULL,'#Form.phone2#', phone2Extension = NULL,'#Form.phone2Extension#', organization = NULL,'#Form.organization#', userEmailEvents = NULL,'#Form.userEmailEvents#', creditCardType = '#Form.creditCardType#', creditCardNumber = '#creditCardNumber#', creditCardExpiration = '#creditCardExpiration#', creditCardName = '#Form.creditCardName#', address = NULL,'#Form.address#', address2 = NULL,'#Form.address2#', city = NULL,'#Form.city#', state = NULL,'#state#', zipCode = NULL,'#Form.zipCode#', country = NULL,'#country#', billingSameAsShipping = 1, billingAddress = NULL,'#Form.address#', billingAddress2 = NULL,'#Form.address2#', billingCity = NULL,'#Form.city#', billingState = NULL,'#state#', billingZipCode = NULL,'#Form.zipCode#', billingCountry = NULL,'#country#', billingSameAsShipping = 0, billingAddress = NULL,'#Form.billingAddress#', billingAddress2 = NULL,'#Form.billingAddress2#', billingCity = NULL,'#Form.billingCity#', billingState = NULL,'#billingState#', billingZipCode = NULL,'#Form.billingZipCode#', billingCountry = NULL,'#billingCountry#', userEditedDateTime = #nowDateTime# WHERE userID = #userID# ", "ALL")> SELECT * FROM Member WHERE userID = #userID# ", ">", "ALL")> ", ">", "ALL")> ", ">", "ALL")> ", ">", "ALL")> ", ">", "ALL")> ", ">", "ALL")>

#textUsername#: #requiredFieldMarker#

#textPasswordEdit#

#textPassword#: #requiredFieldMarker#

#textPasswordVerify# #requiredFieldMarker#

CHECKED> #textUseCookies#

#textFirstName#:

#textLastName#:

#textEmail#:

#textEmailVerify#:

#textEmailMeWhen# CHECKED> #textEmailWinner#
CHECKED> #textEmailLoser#
CHECKED> #textEmailOutbid#
CHECKED> #textEmailAutobid#

#textOrganization#:

#textPhone#: #textPhoneExtension#:

#textPhone2#: #textPhone2Extension#:

#textShippingInformation#

#textAddress#:

#textAddress2#

#textCity#:

#textState#:
#textStateOther#

#textZipCode#:

#textCountry#:
#textCountryOther#

#textBillingInformation#

#textCreditCardType#:

#textCreditCardEdit#

#textCreditCardNumber#: #textCreditCardNumberFormat#

#textCreditCardExpiration#: / #textCreditCardExpirationFormat#

#textCreditCardName#:

CHECKED> #textBillingSameAsShipping#

#textBillingAddress#:

#textBillingAddress2#

#textBillingCity#:

#textBillingState#:
#textStateOther#

#textBillingZipCode#:

#textBillingCountry#:
#textCountryOther#

#textMothersMaidenName#:

#textUsername#:	#requiredFieldMarker#
	#textPasswordEdit#
#textPassword#:	#requiredFieldMarker#
#textPasswordVerify#	#requiredFieldMarker#
	CHECKED> #textUseCookies#
#textFirstName#:
#textLastName#:
#textEmail#:
#textEmailVerify#:
#textEmailMeWhen#	CHECKED> #textEmailWinner# CHECKED> #textEmailLoser# CHECKED> #textEmailOutbid# CHECKED> #textEmailAutobid#
#textOrganization#:
#textPhone#:	#textPhoneExtension#:
#textPhone2#:	#textPhone2Extension#:
#textShippingInformation#
#textAddress#:
#textAddress2#
#textCity#:
#textState#:	#textStateOther#
#textZipCode#:
#textCountry#:	#textCountryOther#

#textBillingInformation#
#textCreditCardType#:
	#textCreditCardEdit#
#textCreditCardNumber#:	#textCreditCardNumberFormat#
#textCreditCardExpiration#:	/ #textCreditCardExpirationFormat#
#textCreditCardName#:

CHECKED>	#textBillingSameAsShipping#
#textBillingAddress#:
#textBillingAddress2#
#textBillingCity#:
#textBillingState#:	#textStateOther#
#textBillingZipCode#:
#textBillingCountry#:	#textCountryOther#
#textMothersMaidenName#: