XF 2.2 Integrate my own SQL Query

[Speil]

Hi,
I've got this Query:

SELECT count(listing_id) as anzahl FROM `xf_z61_classifieds_listing` where listing_status like 'sold' group by listing_status

I want to show $anzahl in my board statistic widget. Where do I have to implement the SQL / PHP code to define and use variable $anzahl in the corresponding template?
Is there another way than building a whole add on just for this?

thx

 

[Kruzya]

You can manually edit file, but I don’t recommend this, because your changes will be rollbacked with every update with this modified class.
You need create an add on with class extension via XFCP.

 

[Speil]

thx, will head over to the development forum