categories - modifications

Hi

i need to add extra field to property categories (it will be two letters category code) and another field to county (it will be county shortcode)

then i need to generate extra field in property (which will be ref no) and that field will be generated from 3 other fields:

XXXYYYYZZ

XXX = county shortcode
YYYY = property ID
ZZ = category code

please help as i can't even find where to add category shortcode (already added extra field in database but have no idea where to add it in backend)

thank you for any help

Hi,
In OS Property, the extra fields are only used for Properties. You can't not define the extra fields for category. \
In your case, i think you have solution
ZZ is the category ID, it is the unique number of each category. You can see it in the categories list or in the database.
XXX is country code, you can have them from database.
YYYY is the property ID, you can create the extra field for it.
But the main problem is OS Property hasn't got feature to get the data for one extra fields from other fields. So you should enter value for this field by manually.
Thanks
Dam

hi, thank you for reply

but unfortunately it has to be the way i described

i can manipulate extra fields with php but i can't find which files are responsible for editing category

to populate ref field with XXXYYYYZZ i can put some code into file responsible for property editing (i will get XX, YYYY and ZZ from required fields from database and then save it to extra field in database)


sound easy to me but... i can't find which files i should modify

I think you are Joomla php developer
In case you want to add field in categories, you can modify the data table by using phpmyadmin
Table name : #__osrs_categories, and add column into that table,
for example
name : category_code
attribute : varchar 3
And then, you can add that value for categories by using phpmyadmin, Because we have limited number of categories, right?
After that you can retrieve data (category code) and update to the extra field.

i'm not that good developer

i already altered database but i can't find which file is responsible for displaying property details (page where i want to display my extra field)