Recent content by lobsterpasties

  1. L

    XF 2.2 sql syntax to remove avatar from users

    I have a few queries which I run on the db at certain times. These are automated and don't require manual input. I want to remove avatars and custom titles from people who are not paying members. I can remove the custom titles easily and that is working very nicely every morning at about 1.00, I...
  2. L

    XF 2.2 sql syntax to remove avatar from users

    Sorry Paul I don't understand what this means? I can query the group to find whether they should have avatars, but the bit I can't find is the link between the avatar and the user in the database. If I know this I won't need to do it manually.
  3. L

    XF 2.2 sql syntax to remove avatar from users

    That's no issue. Where is the flag?
  4. L

    XF 2.2 sql syntax to remove avatar from users

    Thank you. When someone stops paying I need them to have no avatar so I will need an alternative.
  5. L

    XF 2.2 sql syntax to remove avatar from users

    I have downgraded some of my users and want to remove their avatars in bulk. Can anyone tell me how the avatars work, as I can't find any avatar infor in the database (other than date, height etc) I want an sql query to remove a specific users avatar.
  6. L

    Not a bug Accounts (user groups) downgraded from paid user upgrades expiring do not downgrade features

    I have encountered the same issue. Is there a way of triggering anything like an sql query when a downgrade occurs as I would like to remove the avatar and change the custom title.
  7. L

    [OzzModz] Style Default per Domain

    Hi. I downloaded this for my forum (https://reissued.co.uk) as I had a similar thing on Vbulletin. Unfortunately it breaks my forum quite badly. This is a 2.2 Xenforo installation running on Windows 2016 IIS with PHP 8.1 and I get lots of permissions errors on the forum. This is replicable by...
  8. L

    Optimal versions for new install.

    Just in case anyone is looking. On Windows IIS. PHP 8.2 ran nicely with XF other then the image support. There is no Imagemagic dll that works on IIS with PHP 8.2. The downloadable 8.1 dll versions don't work with PHP 8.2 but with 8.1 they work flawlessly.
  9. L

    XF 2.2 Animated avatars.

    I had animated avatars on Vbulletin and I have now imported my forum. They are working fine (I have imagic installed) but they are really annoying, whereas in Vb they weren't as prominent. I would like the avatars on the forum pages and home pages not to be animated, but to be animated on the...
  10. L

    XF 2.2 Importing VB forum.

    Thank you all, I assumed it was the case.
  11. L

    XF 2.2 Importing VB forum.

    I have had a couple of people trying to register on the forum whilst I have been setting it up for importing from VBulletin 3.8 to go live. I want the forum import to be a clean import with matching id's so I am starting again but it takes a few hours to do the import. I have no idea how they...
  12. L

    XF 2.2 Moving forum folders from one server to another.

    I have got the db working and I will copy over the existing folders as I don't want to reinstall everything. Do I copy the Data and Internal_data folder contents or do they get recreated?
  13. L

    XF 2.2 I am having email issues.

    I have changed from using the php smtp server, to using the smtp server settings in the forum. That is now working perfectly. Thanks for your help.
  14. L

    XF 2.2 I am having email issues.

    I am running XF2.2 on php 8.2 on windows server. SMTP is set up and working on mail.xxx.com Port 25 I can request a password reset no problem, the email is sent out and no errors in the server error log. This indicates to me that the smtp mail server is fine. However when I reply to a message...
Top Bottom