SQL query tables

[rnedelkow]

Hi,

I'm looking for sql queries that can fetch info like :

- user posts including content/body
- nodes (channels) and sub-nodes(sub-channels)
- user profile attributes...

[rnedelkow]

Thanks Wayne. JIRA VBV-17737 for anyone interested.

[rnedelkow]

It's only for threads they are subscribed to.

[rnedelkow]

The purpose would be to remove a user's access to the site if they are no longer active members. i.e. No logins within 180 days. I don't plan to delete them, but could something like a cron job determine...

[rnedelkow]

Is there a setting in 5.3.3 to automatically inactivate users based on their activity?

[rnedelkow]

I'm really just trying to figure out the workflow to make this work. Am I on the right path?

1. Create 2 notices
2. Place javascript in footer template. Script chooses between either notice based on certain

...

[rnedelkow]

Thanks Glenn. I'm trying to do something similar to what you've done in the past when a user has no avatar. The option to configure the notice when a user uploads a specific type of file doesn't exis...

[rnedelkow]

How do you make a notice appear for certain users only? I have the if / else part, but where do I put it? I'm using the default theme.

[rnedelkow]

You saved my bacon again. Thank you very much!

[rnedelkow]

I tried updating the template via AdminCP as well but no luck. I'll check out the debug option though. Thanks!

[rnedelkow]

Thanks Glenn. I tried that too. Unfortunately, reverting the template clears the css but saving changes gives me a generic error. I read one of your other posts that suggests there's a mismatch in the...

[rnedelkow]

I made changes to css_additional and can't save, or save and reload due to an edit conflict. Is there anything that can be done besides upgrading to the latest version?

[rnedelkow]

Glenn, you rock! Thank you for sharing that.

[rnedelkow]

Thanks for the suggestion. I tried that but it still shifts the cells to the left on mobile. I think it has to do with the breadcrumbs not being displayed on mobile and leaving the <td> visible...

[rnedelkow]

I did change the stylevars for Wrapper Max Width and Wrapper Min Width both to 90%. Also the Wrapper Margin to Top= 0px, Right=65px, Bottom=0px, Left 65px. Use the 'top' value for all sides set to &q...

[rnedelkow]

Hi Wayne, I'm on android using Chrome but Firefox displays the same thing. It also reproduces if I resize the tab on desktop.

...

[rnedelkow]

My site looks fine on the desktop but on mobile, the body moves slightly to the left and looks misaligned just under the top blue row. How can I get the correct spacing on mobile?

...

[rnedelkow]

I think this was caused by an admin user that was created for vBulletin Support regarding another case.

[rnedelkow]

I wish that were the case but no reference to vB Support email anywhere in those two settings or the distro. I updated the ticket - Thanks Wayne.

[rnedelkow]

Turns out config.php had a reference to the forwarding email address in GoDaddy. I changed ['Database']['technicalemail'] to a generic distribution group email I regularly use, and updated to the webmaster's...