pH-7

--
-- Author:        Pierre-Henry Soria <ph7software@gmail.com>
-- Copyright:     (c) 2016, Pierre-Henry Soria. All Rights Reserved.
-- License:       GNU General Public License; See PH7.LICENSE.txt and PH7.COPYRIGHT.txt in the root directory.
--

--- Replace 'PH7_' by your prefix set in "~/_protected/app/configs/config.ini" [database] prefix var
INSERT INTO PH7_Settings (`name`, value, `desc`, `group`) VALUES
('numberProfileSplashPage', 44, 'Number of profiles to display on the splash homepage', 'general');

pH-7

--
-- Author:        Pierre-Henry Soria <hello@ph7cms.com>
-- Copyright:     (c) 2016, Pierre-Henry Soria. All Rights Reserved.
-- License:       GNU General Public License; https://www.gnu.org/licenses/gpl-3.0.en.html
--

--- Replace 'PH7_' by your prefix set in "~/_protected/app/configs/config.ini" [database] prefix

INSERT INTO PH7_Settings (`name`, value, `desc`, `group`) VALUES
('usersBlock', 1, '0 to disable or 1 to enable the profile photos on the homepage', 'homepage'),

pH-7

--
-- Author:        Pierre-Henry Soria <hello@ph7cms.com>
-- Copyright:     (c) 2016, Pierre-Henry Soria. All Rights Reserved.
-- License:       GNU General Public License; https://www.gnu.org/licenses/gpl-3.0.en.html
--

--- Replace 'PH7_' by your prefix set in "~/_protected/app/configs/config.ini" [database] prefix

ALTER TABLE PH7_SysModsEnabled ADD COLUMN moduleTitle varchar(50) NOT NULL;

pH-7

#!/bin/bash

##
# Author:          Pierre-Henry Soria <ph7software@gmail.com>
# Copyright:       (c) 2012-2017, Pierre-Henry Soria. All Rights Reserved.
# License:         GNU General Public License; See PH7.LICENSE.txt and PH7.COPYRIGHT.txt in the root directory.
##

accepted_ext="-name '*.php' -or -name '*.css' -or -name '*.js' -or -name '*.html' -or -name '*.xml' -or -name '*.xsl' -or -name '*.xslt' -or -name '*.json' -or -name '*.yml' -or -name '*.tpl' -or -name '*.phs' -or -name '*.ph7' -or -name '*.sh' -or -name '*.sql' -or -name '*.ini' -or -name '*.md' -or -name '*.markdown' -or -name '.htaccess'"
exec="find . -type f \( $accepted_ext \) -print0 | xargs -0 perl -wi -pe"

pH-7

--
-- Author:        Pierre-Henry Soria <hello@ph7cms.com>
-- Copyright:     (c) 2017, Pierre-Henry Soria. All Rights Reserved.
-- License:       GNU General Public License; https://www.gnu.org/licenses/gpl-3.0.en.html
--

--- Replace 'PH7_' by your prefix set in "~/_protected/app/configs/config.ini" [database] prefix


INSERT INTO PH7_Settings (`name`, value, `desc`, `group`) VALUES

pH-7

--
-- Author:        Pierre-Henry Soria <hello@ph7cms.com>
-- Copyright:     (c) 2017, Pierre-Henry Soria. All Rights Reserved.
-- License:       GNU General Public License; https://www.gnu.org/licenses/gpl-3.0.en.html
--

--- Replace 'PH7_' by your prefix set in "~/_protected/app/configs/config.ini" [database] prefix


INSERT INTO PH7_Settings (`name`, value, `desc`, `group`) VALUES

pH-7

 PS1='\[\033[0;36m\]\h:\w\[\033[0;32m\]$(__git_ps1)\n\[\033[0;32m\]\[\033[0m\033[0;32m\]'

pH-7

Keybase proof

I hereby claim:

• I am ph-7 on github.
• I am ph7 (https://keybase.io/ph7) on keybase.
• I have a public key ASBpSP6Z_pxWI1qQTkdQyMoomXruMnS2L4Zxmzda78uKewo

To claim this, I am signing this object:

pH-7

--
-- Author:        Pierre-Henry Soria <hi@ph7.me>
-- Copyright:     (c) 2017, Pierre-Henry Soria. All Rights Reserved.
-- License:       GNU General Public License
--

-- Change reserved MySQL column names
-- Using backticks around reserved MySQL words is ugly and not working well with all environments
ALTER TABLE pH7_Settings CHANGE `name` settingName varchar(64) NOT NULL;
ALTER TABLE pH7_Settings CHANGE `value` settingValue varchar(150) DEFAULT '';

pH-7

function doSearch(array, targetValue) {
	var min = 0;
	var max = array.length - 1;
    var guess;

    while (max >= min) {
        guess =  Math.floor((max + min) / 2 );
        
        if (targetValue === array[guess]) {
           return guess;