hi,
Where is INSERT INTO in codes , So I change it to save user's email in added column after factor16?
Best Wishes
Where is INSERT INTO in codes , So I change it to save user's email in added column after factor16?
Best Wishes
4 replies
10 years ago
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.
By default, email of user will be stored in _jlexreview table.
10 years ago
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.
10 years ago
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'];
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'];
10 years ago
...It will easy if you are developer and I trust that 
.
In file: components/com_jlexreview/models/reviews.php , you do same as with voting (if this feature is enable).
.In file: components/com_jlexreview/models/reviews.php , you do same as with voting (if this feature is enable).
Reply to
Product Changelogs
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.
^ 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.
# 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.
# 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.
# 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.
# 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.
JLex Block
6.1.7
# Fixed known bugs.
# Updated GEO servers.
# Updated GEO servers.
JLex Review
6.4.1
# Improved template.
# Fixed missing translation errors.
# Fixed field data type errors.
# Fixed known minor bugs.
# Fixed missing translation errors.
# Fixed field data type errors.
# Fixed known minor bugs.