• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

query

  1. szymme

    [100$ for solution] SQL Query

    Hello, I need help. I need a .php file which is asking for a costum user field and a user group. Like ........\check.php?Account=4711 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...
  2. vlom31

    Please Help! SQL + Caching optimization

    Hi all, 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...
  3. Sim

    Fixed Cache or optimise recent comments block query

    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...
  4. Hizen

    XF 1.5 Postbit/User info Query: Group and Member No.

    Hello XenForo, 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. Joined: Posts: From...
  5. Stuart Wright

    XF 1.4 I have 460,000 threads to move to a different forum. Can I do an SQL statement?

    Hi folks, 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? Thanks
  6. E

    question about database query / Strings, arrays

    Hello, 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...