Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

What Are The 'object_Id', 'object_Type', And 'type' Columns In The Comments And Reviews Addon? Rate Topic   - - - - -

 
  • bebopboy
  • Advanced Member
  • Trial users
  • Join Date: 04-Feb 20
  • 73 posts

Posted 29 June 2020 - 04:14 AM #1

Hello, I want to edit the functionality of the Comments and Reviews addon such that it will limit the user to one review per product (per user, not per IP address) and also when they want to Comment again, it will just edit their previous review instead of adding a new one.
 

The first step to this is understanding how the data is sent to the database, and I saw that they have thread_id, object_id, object_type, and type as the fields in 'discussions' table. thread_id is obvious, but how about the other fields, does anyone know what they are and how they're filled? Thanks.



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20678 posts

Posted 29 June 2020 - 06:01 AM #2

object_id - ID of category, products, page, etc

object_type - category, products, page, etc

type - Communication and Rating, Communication, Rating or Disabled


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • bebopboy
  • Advanced Member
  • Trial users
  • Join Date: 04-Feb 20
  • 73 posts

Posted 29 June 2020 - 08:39 AM #3

Ah, I see. Thanks so much for this!



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20678 posts

Posted 29 June 2020 - 01:27 PM #4

You are welcome! )


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)