Having our weekend break 06:08:46

It is currently a weekend from where we are at. Rest assured that we will get back to your posts as soon as the week starts!

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

JLex Transfer 1.6.6 is ready!

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
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
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
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
...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

JLex Transfer 1.6.7
^ Added a "resume migration" feature for cases of interruption.
^ Added advanced options for the category.
# Improve user interface
# Optimize the data importing.
# Fixed known issues
JLex Review 6.5.1
^ Bridging feature. See its documentation for details.
^ Option resize image if too large.
# Fixed route issue.
# Fixed known bugs.
JLex Comment 3.7.3
^ The option to accept the Terms & Conditions once
^ The option allows you to edit comments within X minutes.
^ Viewport - Optimize page loading speed.
^ "Roles" are now available to guests.
^ Added options to adjust image quality.
# Fixed the issue of not receiving notifications.
# Fixed the bugs reported on Pagespeed.
JLex GuestBook 2.1.2
# Fixed login with Facebook and retrieved a user's profile picture.
# Improve layout and assets.
# Fixed known bugs.
JLex Comment 3.6.7
^ Option to load script location (Head or Body Tag).
# Improve data structure.
# Fix known bugs.
JLex Review 6.4.7
# Fixed login with Facebook.
# Fixed the issue of being unable to retrieve a user's profile picture on Facebook.
# Fixed known bugs.
JLex Comment 3.6.1
^ Integrate the Finder (Smart search) plugin.
# Fixed login with Facebook.
# Fixed the issue of being unable to retrieve a user's profile picture on Facebook.
# Fixed a bug related to editing comments in the front-end.
# Fixed bug "Jump to comment is broken".
# Improved the data structure.
✨ All extensions are now fully compatible with Joomla 5.4.x and 6.
Sign in to your account

Use your social accounts to sign in