Asterisk Blacklist Hobby webbhotell


SQL Update

Filed under: PHP — Mathz @ 21:04

UPDATE `Smslog` SET`State`=7 WHERE RIGHT(‘2017-02-13’,Idate) AND State = 14



Filed under: Hemsidor,MySQL,Server — Mathz @ 23:44
  1. Dump all databases by calling:
    mysqldump --extended-insert --all-databases --add-drop-database --disable-keys --flush-privileges --quick --routines --triggers > all-databases.sql
  2. Stop the MySQL server;
  3. Rename or remove (in case you’ve already backed it up) the MySQL data directory and create an empty one with the same name and permissions;
  4. Make the appropriate changes in my.cnf;
  5. Re-initialize the database with the following command (replace the ‘mysqld‘ with the login of the user your MySQL server runs as):
    sudo -u mysqld mysql_install_db
  6. Start the MySQL server;
  7. Get into the ‘mysql‘ console and type:
    SOURCE all-databases.sql;
  8. Restart the MySQL server.



Filed under: PHP — Mathz @ 19:15

Simple regex

Regex quick reference
[abc]     A single character: a, b or c
[^abc]     Any single character but a, b, or c
[a-z]     Any single character in the range a-z
[a-zA-Z]     Any single character in the range a-z or A-Z
^     Start of line
$     End of line
\A     Start of string
\z     End of string
.     Any single character
\s     Any whitespace character
\S     Any non-whitespace character
\d     Any digit
\D     Any non-digit
\w     Any word character (letter, number, underscore)
\W     Any non-word character
\b     Any word boundary character
(...)     Capture everything enclosed
(a|b)     a or b
a?     Zero or one of a
a*     Zero or more of a
a+     One or more of a
a{3}     Exactly 3 of a
a{3,}     3 or more of a
a{3,6}     Between 3 and 6 of a

options: i case insensitive m make dot match newlines x ignore whitespace in regex o perform #{...} substitutions only once


PHP i WordPress

Filed under: Wordpress — Mathz @ 22:03

För att köra PHP kod i WordPress behöver man en kod exekverare. Jag använder mig av PHPExec-2

Powered by WordPress