Julian.Kellett

A Quick and Easy Guide To Creating WordPress Admin Pages

by

https://wpmudev.com/blog/creating-wordpress-admin-pages/ Creating a Top-Level Admin Page The first step is to create a menu entry with the add_menu_page() function. Here’s a full example, explanation ensues: add_action( ‘admin_menu’, ‘my_admin_menu’ ); function my_admin_menu() { add_menu_page( ‘My Top Level Menu Example’, ‘Top Level Menu’, ‘manage_options’, ‘myplugin/myplugin-admin-page.php’, ‘myplguin_admin_page’, ‘dashicons-tickets’, 6 ); } view rawtop level hosted with ❤ by GitHub The function takes seven arguments. … Read more

Install via Composer

by

Create a file named composer.json in the root of your project and add the following code to it: { “require”: { “microsoft/windowsazure”: “^0.5” } } Download composer.phar in your project root. Open a command prompt and execute this in your project root php composer.phar install If you are using the PHP version 8, some of … Read more

Find Database User and Role

by

SELECT RoleP.name AS DatabaseRoleName ,ISNULL(UserP.name, ‘No members’) AS DatabaseUserName ,UserP.principal_id ,UserP.create_date FROM sys.database_role_members AS DRM RIGHT OUTER JOIN sys.database_principals AS RoleP ON DRM.role_principal_id = RoleP.principal_id LEFT OUTER JOIN sys.database_principals AS UserP ON DRM.member_principal_id = UserP.principal_id WHERE RoleP.type = ‘R’ and UserP.name = ‘my-name’ ORDER BY RoleP.name, ISNULL(UserP.name, ‘No members’);

Decode URL

by

CREATE FUNCTION dbo.UrlDecode(@url varchar(3072)) RETURNS varchar(3072) AS BEGIN DECLARE @count int, @c char(1), @cenc char(2), @i int, @urlReturn varchar(3072) SET @count = Len(@url) SET @i = 1 SET @urlReturn = ” WHILE (@i <= @count) BEGIN SET @c = substring(@url, @i, 1) IF @c LIKE ‘[!%]’ ESCAPE ‘!’ BEGIN SET @cenc = substring(@url, @i + … Read more

Encode URL

by

Version 2 CREATE FUNCTION dbo.UrlEncode(@url NVARCHAR(1024)) RETURNS NVARCHAR(3072)ASBEGIN DECLARE @count INT, @c NCHAR(1), @i INT, @urlReturn NVARCHAR(3072) SET @count = LEN(@url) SET @i = 1 SET @urlReturn = ” WHILE (@i <= @count) BEGIN SET @c = SUBSTRING(@url, @i, 1) IF @c LIKE N'[A-Za-z0-9()”*\-._!~]’ COLLATE Latin1_General_BIN ESCAPE N’\’ COLLATE Latin1_General_BIN BEGIN SET @urlReturn = @urlReturn … Read more

Transforming to an automated Database DevOps process

by

A Real-world Implementation of Database DevOps: People, Processes, Tools | Redgate (red-gate.com) For this implementation we will look at a team of professionals developing bespoke .NET solutions for their customers. Broadly, their ‘old’, manual database development, test and release processes looked like this. It used a shared development and test databases, a couple of ‘standalone’ … Read more