Post Macros 4.3.2

[Liam W]

Well, this went as badly as it could've done.

The version I just added (3.6.5) should fix the server errors. Please make sure you check the database modifications and apply them if they need applying.

You should disable Post Macros until they have been applied & the code in 3.6.5 has been uploaded.

If you get an error relating to not being install SQL in 3.6.5, ignore it - you don't need to import the XML.

Sorry all.

Liam

 

[Liam W]

Liam W updated Post Macros with a new update entry:

Fixes

Fix bug in installer in last version. The last version wouldn't have installed - install this one.

If you tried to install the last one, and it appeared to work, then you may need to manually run the following SQL:

ALTER TABLE xf_user_option ADD macros_hide_qr TINYINT(1) NOT NULL DEFAULT 0, ADD macros_hide_ntnr TINYINT(1) NOT NULL DEFAULT 0, ADD macros_hide_convo_qr TINYINT(1) NOT NULL DEFAULT 0, ADD macros_hide_convo_ncnr TINYINT(1) NOT NULL DEFAULT 0

and...

Read the rest of this update entry...

 

[Liam W]

Liam W updated Post Macros with a new update entry:

Fixes

Fix bugs with the installer that caused server errors.

This version has been installed onto XF Liam (twice), the dev forum & a new install on another dev forum. No errors arose, so I'm happy this version does fix the errors...

Read the rest of this update entry...

 

[Sunka]

If your installed version is 3.6.4 or 3.6.5, then make sure the correct tables are in place after updating - the tables may not have installed (which should've stopped installation, but some systems don't).

How?

 

[Liam W]

How?

Make sure the xf_user_option table as the following fields, by visual check in phpMyAdmin or by running the below query:

macros_hide_qr
macros_hide_ntnr
macros_hide_convo_qr
macros_hide_convo_ncnr

SELECT macros_hide_qr, macros_hide_ntnr, macros_hide_convo_qr, macros_hide_convo_ncnr FROM xf_user_option LIMIT 1;

If the above SQL gives an error relating to field list, you'll need to run the SQL below:

ALTER TABLE xf_user_option ADD macros_hide_qr TINYINT(1) NOT NULL DEFAULT 0, ADD macros_hide_ntnr TINYINT(1) NOT NULL DEFAULT 0, ADD macros_hide_convo_qr TINYINT(1) NOT NULL DEFAULT 0, ADD macros_hide_convo_ncnr TINYINT(1) NOT NULL DEFAULT 0;

Liam

 

[Mouth]

Any thoughts of splitting and creating a staff only macros add-on?
I'm interested, but don't want or need the users functionality and 20 GBP is a little high when I only want the staff macros functionality.

 

[Sunka]

SELECT macros_hide_qr, macros_hide_ncnr, macros_hide_convo_qr, macros_hide_convo_ncnr FROM xf_user_option LIMIT 1;

@Liam W - when I run above query, result is error relating to field list (#1054 - Unknown column 'macros_hide_ncnr' in 'field list'), and if I after that run this code below:

ALTER TABLE xf_user_option ADD macros_hide_qr TINYINT(1) NOT NULL DEFAULT 0, ADD macros_hide_ntnr TINYINT(1) NOT NULL DEFAULT 0, ADD macros_hide_convo_qr TINYINT(1) NOT NULL DEFAULT 0, ADD macros_hide_convo_ncnr TINYINT(1) NOT NULL DEFAULT 0;

Error show: #1060 - Duplicate column name 'macros_hide_qr'

 

[Sunka]

This is what I have in database now:

 

[Liam W]

This is what I have in database now:

That is correct. I got the SQL wrong (although I've now edited the post and fixed it).

 

[Sunka]

So I dont have to do anything now?

 

[Liam W]

So I dont have to do anything now?

Nope, everything should work

Liam

 

[Sunka]

@Liam W, after last update some bbcodes are not parsed.
BBcode php, code, html are not working, also quote bbcode is change to indent...

 

[Rob]

I want this but I can't work out if it is working with conversations or not. I know @Liam W said it should be easy to add, but can't see for sure it's been added.

 

[Liam W]

I want this but I can't work out if it is working with conversations or not. I know @Liam W said it should be easy to add, but can't see for sure it's been added.

It does work for conversations. Are you a member of XF Liam? Create a macro and go to the create conversation page

Liam

 

[Liam W]

Liam W updated Post Macros with a new update entry:

Improvements & Fixes

This is a basic maintenance update to stop the display of the macro options on the preferences page if the user does not have permission to use/view macros.

It also adds a title to the macro options on the user preferences page.

Under the hood, I have changed it to use event hints for all events (where allowed), and have split the single view extension into multiple - allowing for slightly improved performance & better code style.

You may get an error saying there is an...

Read the rest of this update entry...

 

[Liam W]

Liam W updated Post Macros with a new update entry:

Bug Fix & TinyMCE Quattro

• Fix a permission confirmation bug
• Add support for the TinyMCE Quattro add-on

Read the rest of this update entry...

 

[Liam W]

Liam W updated Post Macros with a new update entry:

Several Improvements & New Features

• Improved macro modify template (bbcode editor is correct size)
• Added macro preview feature when editing or creating
• Added delete confirmation to admin macros
• Added the ability to lock the thread or set a thread prefix for macros. This only applies when replying to a thread, and will only work for staff.

Read the rest of this update entry...

 

[The Sandman]

Um... where'd your site go?

 

[Liam W]

Um... where'd your site go?

Wha...?

Liam

 

[The Sandman]

Wha...?

For some reason the Buy Now link isn't working - had to go to your site manually.

Update won't run.

An error occurred while running SQL in class LiamW_Macros_DatabaseSchema_Macros