Recent content by Graham Smith

  1. Graham Smith

    XF 2.0 An exception occurred: [TypeError] Argument 2 passed to XF\App::getCustomFieldsForEdit()

    I ran these queries, and only the third one produced a result (four rows inserted). 1,2and4 did nothing. However, I'm running the latest version. Would that make a difference?
  2. Graham Smith

    Add-on Custom Primary Usergroup Change Automation

    I’m currently looking for someone to write an add-on for our xenForo forum which is (and normally is) running the very latest version. We have two main primary usergroups “2” and “13”. When I run this new add-on, I want to turn all the people in primary usergroup “13” back to primary usergroup...
  3. Graham Smith

    SQL Query

    You sir are an incredibly kind person. Thank you so very much for helping me with this. I'm now able to get the information I need to into Excel.
  4. Graham Smith

    SQL Query

    That's great. Thanks so very much for this… Unfortunately, some of our members have put commas in the 'address' field, and it screws the order of the Excel file up a bit. I'm happy to remove the commas. How would I go about doing that?
  5. Graham Smith

    SQL Query

    Yes, I have access to phpmyadmin on the server. We're running phpMyAdmin version 4.7.7
  6. Graham Smith

    SQL Query

    We have a fairly standard xenForo installation. We’re running off a shared server using PHP 7.0.28 Our database name is: ourforumname_xenforo We have a few Custom Userfields: Field ID: forename Field ID: surname Field ID: address Field ID: membership_number What I’ve been trying to do is...
  7. Graham Smith

    XF 2.0 html Widget

    That’s really useful Chris. Thanks very much - it's really appreciated. I've also tried including the location field, but can't work out how to 'describe' it. I've tried many variations, but can't seem to stumble across the right one… This is the one I'm trying, but I don't think it's right…...
  8. Graham Smith

    XF 2.0 html Widget

    Chris - you are a genius - that worked brilliantly thanks VERY much. As an aside, I'd really love to learn more about writing this sort of stuff. Can you suggest a website/book that's suitable for a complete beginner like me?!
  9. Graham Smith

    XF 2.0 html Widget

    Thanks Chris I've tried this… <xf:if is="{{$xf.visitor.isMemberOf(13)}}"> Your membership number is {$xf.visitor.customFields.your_voc_membership_numbe.value}. You are registered and recognised as a VOC Club Member. You have full access to all features of this Club website.</p> </xf:if> The...
  10. Graham Smith

    XF 2.0 html Widget

    Am trying to output the contents of one of our Custom User Fields within an html widget. I'm using this line, but it outputs nothing. Any ideas? {$user.customFields.••id••of••my••field••.value}
  11. Graham Smith

    Conditional Statements for XenForo 2

    @ge66 Thanks for your reply. As I'm a bit 'dense', would it be possible for you to explain to me in small steps exactly what I need to do here, as I think I DID check the 'Advanced' mode.
  12. Graham Smith

    Conditional Statements for XenForo 2

    @DL6 Please excuse my ignorance, but I'm really stuck here, and have been trying for what seems like hours. ---------------- 1. I've made an html widget called "test1". I've turned OFF all the display positions. The contents is: <xf:if is="{{$xf.visitor.isMemberOf(13)}}"> This text should show...
  13. Graham Smith

    Conditional Statements for XenForo 2

    Seriously? Put a widget inside a widget? Surely that'll just show the widget again? I'm trying to hide the widget from certain usergroups.
  14. Graham Smith

    Conditional Statements for XenForo 2

    Is it possible to wrap a conditional statement around a complete/whole widget? As far as I see it, if you put a conditional statement around the contents of the widget, it still shows the widget, even if there's no content to show. I'm trying to hide certain widgets from certain usergroups if...
  15. Graham Smith

    XF 2.0 Custom Userfield in Template

    We have a Custom User Field with a Field ID of "custom_userfield_one" Please can someone help me with the code to put it within an html widget as follows… This is just static text: {custom_userfield_one} Probably not that difficult, but I can't find any reference as to how to do it anywhere...
Top