Zen mode 00:00:15

It is currently our zen mode where we get some rest so that we can come back to work feeling refreshed the next day and assist you with your issues. Some answers may already be available on our documentation.

Official support hours are from 8:30AM — 5:00PM Monday to Saturday (GMT +7)

Release JLex Transfer v1.3.7 🥳

Jlex Review add one column to _jlexreview_factor to save user's information

ali
hi,

Where is INSERT INTO in codes , So I change it to save user's email in added column after factor16?

Best Wishes

4 replies

ali
It needs 3 steps :
1 : add needed element in factor.php located in administrator/components/com_jlexreview/tables/factor.php
2: add columns after f16 in _jlexreview_factor table, I have needed date so I added extra TIMESTAMP field with default  CURRENT_TIMESTAMP and userID as varchar,
3: in components/com_jlexreview/models/reviews.php line 1132 I added $ftData['usid']=$post['author_email'];
Victor
I recommend you don't should change structure of table. It can affect to JLex Review component.
By default, email of user will be stored in _jlexreview table.
ali
Yes,But I need to report _jlexreview_factor table , Now I just need to add userID in last of table when it inserting new row in _jlexreview_factor.
Victor
...It will easy if you are developer and I trust that :D.
In file: components/com_jlexreview/models/reviews.php , you do same as with voting (if this feature is enable).
Reply to

Product Changelogs

Product Changelogs

JLex Transfer 1.3.7
^ Support dark mode in the backend.
# Fixed bug when importing user list.
JLex Comment 3.4.8
^ hCaptcha integration.
^ Read-only mode.
^ Hide all comments of entry.
^ Dark mode for admin.
# Improved default theme.
JLex Block 6.0.3
# Important: Upgrade required to be compatible with Joomla 5 (B/C plugin).
# Fixed conflicts with system plugins.
JLex Attachments 1.4.4
^ Drag & drop file to upload
^ Sortable file list
JLex Review 6.2.3
^ Support dark mode on the backend.
# Updated all themes.
# Works without B/C plugin.
JLex Comment 3.4.2
# Fixed page scrolling when clicking on links.
# Improved link tag.
# Fixed avatar for Gravatar and CB.
Youtube Feed Pro 5.9.7
# Fixed the issue of not being able to get data from YouTube or data loading time being too long.
See more
Sign in to your account

Use your social accounts to sign in