This link will show all user posts:
Now how can I dispaly only posts with green diamond icon? Such "diamond" post ids are stored in xf_QT_best_answer table so I can get their ids with this query:
SELECT `xf_post`.`post_id` FROM...
I have an ordered array of IDs gathered from complex SELECT query.
Now I need to get entities with IDs from my array but in the order they are listed in IDs array!
It can be done with this query:
SELECT * FROM table WHERE id IN (5,4,3,1,6) ORDER BY FIELD(id, 5,4,3,1,6);
But the porblem...
So this is where I have ended up after days of trying.
What I am doing is using JSON to gather data from another site then inserting that into the database. This will happen only once, then there will be a daily check that will check for specific updates to the data and update the entry once a...
I'm attempting to build a custom query page whereby a user (for admin use only) can enter a username into a textbox, click a search button, and retrieve the stored information connected to the username. Currently, I have blocks of code, but I'm not entirely sure how to combine it...
I need help. I need a .php file which is asking for a costum user field and a user group.
4711 must be filled in the custom user field ID 123456 AND be part of user group X.
The output is a echo with OK or WRONG.
I would be so happy if anybody...
I am implementing a live feed on my xenforo homepage, meaning that it shows a list of recent posts, updated in real time, resulting in some heavy sql query(ies) every 1 second..
I am just testing it myself right now, so 1 user, and it's already putting the CPU under pressure, the way...
I just finished a test import of ZooChat from vB3.8+PhotoPost to XenForo+XFMG, with 423K posts and 277K photos, including 2,219 galleries. My initial testing is quite positive - no major issues so far, even with large numbers of galleries.
However, I've found that the Media home page is taking...
I want to edit the message user info area to add in new fields. I figured out custom user fields, but I want to display two things in the user block part: 'Group' and 'Member No.'.
E.g. where the green arrow (above) is situated, it would read as follows.
we've got slow queries running because our classifieds archive forum has 540,000 threads.
So I want to move the older ones out to a non-public forum.
At the rate it's taking the system, it will take days.
Can I just run a query to change the node id of the threads?
I am trying to make a own template and I wish to use an add-on to get own strings and few arrays but somehow I not get it to work correctly could someone maybe see what I do wrong?
I created an addon by following this tutorial: Unmaintained - Global Template Variable
the content looks...