Quote:
Originally Posted by Flow Fusion
geez it's seems when I upload the "showthread.php" everything goes to hell. I don't know which one to edit. From the
In /showthread.php
-------------------------------
==>Find:
'pollresult'
==>Replace With:
'pollresult',
'awards_bit'
==>Find:
usertextfield.*,
==>Replace With:
usertextfield.*, useraward.*,
==>Find:
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
==>Replace With:
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)
Their is 2 of each these. And on the LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
in my file it has
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
See how it has AS as oppose to ON?
Please help?
|
u dont need to start from scratch
just replace
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid) - (which is`nt even their mind you as announcement.userid aint there so search upto that bit and replace thelot )
and replace with
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=userid.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)
replace both in showthread as there is 2 occurances.
also images do appear in admin cp in awards manager - they dont appear when u bring an account up to give em to that user so hacks works fine