Having our weekend break 13:19:38

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)

New topic

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

ali
8 years ago
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
8 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'];
JLexArt
8 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.
ali
8 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.
JLexArt
8 years ago
...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

Latest articles

Sign in to your account
Use your social accounts to sign in