Post by rgbrewer » Wed Dec 20, 2017 11:34 pm

Hi guys,

Client asked me today to display a Modal when the customer first signs in for that day -- until dismissed.

I see oc_customer_login table, but reading the code it seems that table might be just logging *incorrect* login attempts? Or is date_updated the most recent successful login and the count is the number of logins that day?

2.3.0.2

Anyway, wondering how you guys would approach this.

Cheers

New member

Posts

Joined
Sat Apr 22, 2017 9:30 am

Post by straightlight » Thu Dec 21, 2017 12:00 am

Or is date_updated the most recent successful login and the count is the number of logins that day?
I believe you are referring to the date_modified field since the date_updated field does not exist in the customer_login table. However, your assumption is correct. The date_modified field gets updated as per the customer attempts to login into his account whenever a failed attempt is involved.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by rgbrewer » Thu Dec 21, 2017 12:08 am

Ah, yes. Thank you!

New member

Posts

Joined
Sat Apr 22, 2017 9:30 am

Post by thekrotek » Thu Dec 21, 2017 12:12 am

You need to look into customer_activity table and query it by "customer_id" and key "fields"

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by rgbrewer » Thu Dec 21, 2017 2:04 am

My customer activity table is suspiciously empty... I have bypassed it somewhere. Thanks for the tip.

New member

Posts

Joined
Sat Apr 22, 2017 9:30 am

Post by straightlight » Thu Dec 21, 2017 2:21 am

Your assumption is correct. I do not see any codes in the v2.3.0.2 which reflects on the already existing table of the oc_customer_activity table. It might be missing from the core but may have been fixed afterwards with the more recent versions of OC.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by thekrotek » Thu Dec 21, 2017 4:21 am

There's a plenty code for different kinds of activity in 2.3.0.2 source. Search for "activity" in OC files.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by straightlight » Thu Dec 21, 2017 5:05 am

Sorry, it was a typo.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by straightlight » Thu Dec 21, 2017 5:09 am

catalog/model/account/activity.php file is the location.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: Majestic-12 [Bot] and 17 guests