Trekspertise - A History Of The Klingon People (Part One)

Os benefícios de um cérebro bilíngue - Mia Nacamulli

Como fazer uma regressão linear no Excel

DATA SCIENCE - Análise exploratória de dados - Emprego - Brasil Indústria de transformação Variação percentual em relação a média no período 2003 a 2016

DATA SCIENCE - Análise exploratória de dados - Campeonato Brasileiro - 2016 - Série A

Dados retirados do site da CBF.

O gráfico considera a média de todos os jogos até a data que este post foi publicado.

Melhor performance de gols : Atlético - MG

Segunda melhor performance de gols - Ponte Preta - SP

A posição atual do campeonato - TOP 3

1o. PALMEIRAS - SP

2o. FLAMENGO - RJ

3o. ATLÉTICO - MG

Curiosidade : O Flamengo, com uma performance negativa em relação a média, está em terceiro lugar. Um gráfico com eixo de tempo esclareceria este aparente paradoxo.

Obs: Não foi possível plotar um gráfico de performance na linha do tempo pois o site não fornece essa informação.

Fonte
http://www.cbf.com.br/competicoes/brasileiro-serie-a/artilharia/2016#.V_bAR0wrKM9

DATASCIENCE - Análise exploratória de dados - Venda de material para construção civil

Índice de volume de vendas de materiais de construção

Brasil

Em verde o índice apurado, em azul a regressão linear.

Cada ponto significa a variação do índice em relação ao ano anterior.

Mesmo que os índices sejam todos negativos, existe uma tendência positiva, pois as vendas estão aumentando.

Os dados podem ser um indicativo de que indústria de construção civil está se recuperando, ainda que lentamente.

Tipo de Índice	Mês	Indice
Índice base fixa (2011=100)	01/02/2016	89,2
Índice base fixa (2011=100)	01/03/2016	96,6
Índice base fixa (2011=100)	01/04/2016	90,9
Índice base fixa (2011=100)	01/05/2016	92,9
Índice base fixa (2011=100)	01/06/2016	94,5
Índice base fixa (2011=100)	01/07/2016	96,1
Índice base fixa com ajuste sazonal (2011=100)	01/02/2016	98,7
Índice base fixa com ajuste sazonal (2011=100)	01/03/2016	98,1
Índice base fixa com ajuste sazonal (2011=100)	01/04/2016	94,4
Índice base fixa com ajuste sazonal (2011=100)	01/05/2016	94,3
Índice base fixa com ajuste sazonal (2011=100)	01/06/2016	95,4
Índice base fixa com ajuste sazonal (2011=100)	01/07/2016	93
Variação mês / mês anterior com ajuste sazonal	01/02/2016	2,6
Variação mês / mês anterior com ajuste sazonal	01/03/2016	-0,6
Variação mês / mês anterior com ajuste sazonal	01/04/2016	-3,8
Variação mês / mês anterior com ajuste sazonal	01/05/2016	-0,1
Variação mês / mês anterior com ajuste sazonal	01/06/2016	1,2
Variação mês / mês anterior com ajuste sazonal	01/07/2016	-2,5
Variação mensal (base: igual mês do ano anterior)	01/02/2016	-11,1
Variação mensal (base: igual mês do ano anterior)	01/03/2016	-14,7
Variação mensal (base: igual mês do ano anterior)	01/04/2016	-13
Variação mensal (base: igual mês do ano anterior)	01/05/2016	-10,6
Variação mensal (base: igual mês do ano anterior)	01/06/2016	-9,6
Variação mensal (base: igual mês do ano anterior)	01/07/2016	-12,6
Variação acumulada no ano (base: igual período do ano anterior)	01/02/2016	-14,8
Variação acumulada no ano (base: igual período do ano anterior)	01/03/2016	-14,8
Variação acumulada no ano (base: igual período do ano anterior)	01/04/2016	-14,3
Variação acumulada no ano (base: igual período do ano anterior)	01/05/2016	-13,6
Variação acumulada no ano (base: igual período do ano anterior)	01/06/2016	-13
Variação acumulada no ano (base: igual período do ano anterior)	01/07/2016	-12,9
Variação acumulada de 12 meses	01/02/2016	-9,5
Variação acumulada de 12 meses	01/03/2016	-10,9
Variação acumulada de 12 meses	01/04/2016	-11,6
Variação acumulada de 12 meses	01/05/2016	-11,6
Variação acumulada de 12 meses	01/06/2016	-12,4
Variação acumulada de 12 meses	01/07/2016	-12,9

Fonte dos dados : IBGE

http://www.sidra.ibge.gov.br/bda/comerc/default.asp?z=t&o=13&i=P

DATA SCIENCE na prática - TAXA DE ESCOLARIZAÇÃO NO BRASIL - O problema do Brasil é a educação?

Você acha que o problema do Brasil é a educação?

Olhe este gráfico é tire suas conclusões.

Fonte : http://seriesestatisticas.ibge.gov.br/series.aspx?no=4&op=0&vcodigo=PD170&t=taxa-escolarizacao-grupos-idade

 Fonte: IBGE, Pesquisa Nacional por Amostra de Domicílios 1992/2007

*Considerações sobre a limitação da abrangência geográfica e temporal das séries com dados da Pesquisa Nacional por Amostra de Domicílios (PNAD).

Tendo em vista os problemas metodológicos na comparação, entre décadas, dos resultados da PNAD (ver PNAD - Notas Técnicas, pp. 23;17 -19), a seguinte particularidade das séries históricas deve ser registrada:

   As séries que apresentam dados absolutos não ultrapassam o período de uma década, mas  cobrem todos os níveis geográficos de divulgação da pesquisa ( Brasil, Grandes Regiões, Unidades da Federação e 9 Regiões Metropolitanas: Belém, Fortaleza, Recife, Salvador, Belo Horizonte, Rio de Janeiro, São Paulo, Curitiba e Porto Alegre). O inverso ocorre nos casos de séries que apresentam apenas dados relativos (percentuais),  que podem cobrir períodos mais longos mas, no entando, em virtude da variabilidade das situações urbano-rural entre décadas, estas séries somente são apresentadas para os níveis geográficos de Brasil e Grandes Regiões ( Regiões Geográficas: Norte, Nordeste, Sudeste, Sul e Centro-Oeste) .

Underworld: Blood Wars Official Trailer 1 (2017) - Kate Beckinsale Movie

SEQUENCE IN SQL

That's the order of the select

1 - WHERE
2 - GROUP
3 - HAVING
4 - SELECT

Há!

WILD CARDS IN SQL SERVER

select productnumber, listprice from sales where productnumber like 'BR-_[0-9][0-9]_-[0-9][0-9]'


BR-_[0-9][0-9]_-[0-9][0-9]
Starts with BR
dash
any character
number, number
any character
dash
number, number

Iron Fist Trailer Breakdown - Marvel Defenders

DELTA CODE CONVERSION

The DELTA code is as follows

DELTA code of 4 is

GAMA CODE -> 110,00 -- 110 occupies 3 bits. 3 in gamma code is 101, therefore 4 in delta code would be

101,00

DELTA code of 5 is

GAMA CODE -> 110,01 - 110 occupies 3 bits. 3 in gamma code is 101, therefore 5 in delta code would be



Explanation of gamma conversion is here
http://netdaniels.blogspot.com.br/2016/06/gamma-code-conversion.html

GAMMA CODE CONVERSION

Hi!

http://nlp.stanford.edu/IR-book/html/htmledition/gamma-codes-1.html

Following the explanation of the link above I figured out how to convert numbers to gamma code.

Ex:

Number 4

UNARY CODE -> 11110

BINARY CODE -> 100

OFFSET -> 00

LENGTH -> 110

GAMA CODE -> 110,00

OFFSET -> IT IS THE BINARY CODE WITHOUT THE FIRST BIT FROM LEFT TO RIGHT. 100 becomes 00.

LENGTH -> NUMBER OF BITS THAT THE OFFSET OCCUPIES, in this case, 00 occupies  2 bits

GAMA CODE IS LENGTH, OFFSET, Therefore 110,00

The Portuguese Language and What Makes it Intriguing

Rihanna's 'Work' Is Not Tropical House

How To: Create a Chorus Effect in Audacity

Ben Howard x Lana Del Rey | "Video Games" (Cover) - A64 [S5.EP1]: SBTV

[Outer limits, Supervelocity, Space Pattern & Beyond] Operation Interste...

Shutdown or Restart Computer on a Schedule: Win Vista/7

General error: 1364 Field 'id' doesn't have a default value

Hi!

The id you defined for your entity is not identity. It must be!

Good luck!

Error: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value

If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.

SQL Query:

INSERT INTO projetos (user_id, nome) VALUES (:c0, :c1)

Transform SELECT INTO HTML / XML / SQL SERVER / td=

Hi!

I have to say this is a little bit too hermetic for me, but it works.

This is an example of how to transform a SELECT into  HTML format.

Notice that it shows how to add color to each cell (td).

This example is priceless.

If you have any doubt, leave a comment.

Good luck!

SET @html = 

cast((

select

      td=NICK,'',

      td=REPLACE(RTRIM(CONVERT(CHAR(15) , CAST(unit AS MONEY) ,1)),'.00',''), '',

      td=RTRIM(CONVERT(CHAR(15) , CAST(sale AS MONEY) ,1)),'',

      td=REPLACE(RTRIM(CONVERT(CHAR(15) , CAST(TICKETS AS MONEY) ,1)),'.00',''), '',

      td=REPLACE(RTRIM(CONVERT(CHAR(15) , CAST(FLUXO AS MONEY) ,1)),'.00',''), '',

      td=PA, '',

      td=TM, '',

      td=CONVER, '',

      cast(case when GOAL_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=GOAL_P, '',

      cast(case when UNIT_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),UNIT_LY_DAY_P), '',

      cast(case when SALE_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),SALE_LY_DAY_P ),'',

      cast(case when TICKETS_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),TICKETS_LY_DAY_P), '',

      cast(case when FLUXO_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),FLUXO_LY_DAY_P), '', 

      cast(case when PA_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),PA_LY_DAY_P), '', 

      cast(case when TM_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,0),TM_LY_DAY_P), '', 

      cast(case when CONVER_LY_DAY_P < 0 then 'red' else 'blue' end as nvarchar(30)) as 'td/@bgcolor',

      td=CONVERT(NUMERIC(11,1),CONVER_LY_DAY_P),''

FROM [table]

WHERE field LIKE '??%'

ORDER BY convert(numeric(11,1),GOAL_P) DESC

FOR XML path('tr'),type) as nvarchar(max))

+'</table>'

IMPORTANT/ BAD, BAD, REALLY BAD **** COURSERA WIPED ALL ALL MY CERTIFICATES AND MY PREVIOUS ACTIVITIES

Do you know COURSERA?

Well let tell you something. Today, I logged in, and all my certificates were gone, for good.

That's the message I wrote to them.


Hi!
All my certificates are gone.
All my activities were erased.
What are you doing?
Do you have any idea of how many hours I dedicated to earn those certificates?
My account was completed wiped out.
When we start a course, there's a code of honor to follow. Are you following any code of honor?
If you are a honorable organization, you will find out what happened.
Even the certificates that were linked to my linked in account were deleted.
What's wrong with you guys?
I have seen people and organizations loosing face, but you are by far the worst example.
I will not write regards in the end of this message, because I just know how to finish this.

Yes, I know, I was a little bit dramatic. But I'm not overreacting. I did spend a lot of hours of studying to get my certificates. My data science certificates are gone, and they pretty hard to achieve.

This is was my biggest disappointments in years concerning to an institution.

This is sad. Really sad.

cakephp 3 installation issue - unexpected T_OBJECT_OPERATOR in config/bootstrap.php on line 107

Hi!

You have just deployed your applicaton and you received this error

unexpected T_OBJECT_OPERATOR
?

Don't worry, it's the version of your PHP.

I changed from 5.3 to 5.5.

Yeah, I have no time keep investigating, so I decided to go to 5.5.

It worked.

Good Luck!

Can't logout on Chrome? Maybe Chrome is not the problem.

Hi!

I was having this issue. Then I found Raffi's answer. Which is perfect.
In my case, only admin was able to logout.
Then he made me understand that I forgot to define that, if you are not admin, you also can logout!

        public function isAuthorized($user)
        {

                $action = $this->request->params['action'];

                if (in_array($action, ['logout']))

                {
                   return true; // If user wants to logout, ok for everyone.
                }
                else
                {
                    // If he or she is not trying to logout, then, if the role of the user is admin, anything goes
                    if (isset($user['role']) && $user['role'] === 'admin')
                    {
                         return true;
                    }                  

                    return false;
                }



                // Default deny
                //return false;
         
        }

Hope it helps!

Good luck!

http://stackoverflow.com/questions/27232679/cakephp-3-users-not-allowed-to-logout

Login, Logout is making you insane? / CakePHP 3.0 / That's how I did.

Hi!

This thing of login, logout is p. in the a.. Well that's how I did mine

        $this->loadComponent('Auth', [
                'authorize' => 'Controller',
                'authenticate' => [
                'Form' => [
                'fields' => [
                'username',
                'password' => 'password'
                ]
                ]
                ],
                'loginAction' => [
                'controller' => 'Users',
                'action' => 'login'
                ],
                'loginRedirect' => [
                                'controller' => 'Users',
                                'action' => 'index'
                            ],
                'logoutRedirect' => [
                                'controller' => 'Users',
                                'action' => 'login'
                            ]                        
                ]);
                // Allow the display action so our pages controller
                // continues to work.
                $this->Auth->allow(['display']);
    }

Hope it helps.

Good Luck!

Does PowerPivot from Microsoft works? Yes!

Hi!

I have been recently working with million of records.
Normal excel worksheets do not support more than 1.000.000 records or lines, as you prefer.
But I still have to work with excel (this is a client compliance).
How did I deal with that?
Using PowerPivot.
It imports 2.600.000 records in less than a minute.
The performance of his pivot table is as well as good.
So, if you are facing the same scenario as I am, PowerPivot can be your solution.

Good luck!

A different way to create temporary table

Hi!

Today somebody teached me a new way to create temporary table and I found it really cool.

This is a way to create a temporary table cloning only the definition of the original table.

SELECT * INTO #TEMP_CLIENT FROM  CLIENT  WHERE 0 = 1

Isn't it cool?

Good luck!
 

Short cut for symbols

Hi!
Have you ever asked yourself how to access those symbols?
So, here it is.
Enjoy it.

Alt + 1= ☺
Alt + 2= ☻
Alt + 3= ♥
Alt + 4= ♦
Alt + 5= ♣
Alt + 6= ♠
Alt + 7= •
Alt + 8= ◘
Alt + 9= ○
Alt + 10= ◙
Alt + 11= ♂
Alt + 12= ♀
Alt + 13= ♪
Alt + 14= ♫
Alt + 15= ☼
Alt + 16= ►
Alt + 17= ◄
Alt + 18= ↕
Alt + 19= ‼
Alt + 20= ¶
Alt + 21= §
Alt + 22= ▬
Alt + 23= ý
Alt + 24= ↑
Alt + 25= ↓
Alt + 26= →
Alt + 27= ←
Alt + 28= ∟
Alt + 29= ↔
Alt + 30= ▲
Alt + 31= ▼
Alt + 32=
Do Alt + 33 até o Alt + 126 são caractéres numéricos e de letras comuns do teclado... continuando
Alt + 127= ⌂
Alt + 128= Ç
Alt + 129= ü
Alt + 131= â
Alt + 132= ä
Alt + 133= à
Alt + 134= å
Alt + 135= ç
Alt + 136= ê
Alt + 137= ë
Alt + 138= è
Alt + 139= ï
Alt + 140= ¥
Alt + 141= ì
Alt + 142= Ä
Alt + 143= Å
Alt + 144= É
Alt + 145= æ
Alt + 146= Æ
Alt + 147= ô
Alt + 148= ö
Alt + 149= ò
Alt + 150= û
Alt + 151= ù
Alt + 152= ÿ
Alt + 153= Ö
Alt + 154= Ü
Alt + 155= ø
Alt + 156= £
Alt + 157= Ø
Alt + 158= ×
Alt + 159= ƒ
Alt + 160= á
Alt + 161= í
Alt + 162= ó
Alt + 163= ú
Alt + 164= ñ
Alt + 165= Ñ
Alt + 166= ª
Alt + 167= º
Alt + 168= ¿
Alt + 169= ®
Alt + 170= ¬
Alt + 171= ½
Alt + 172= ¼
Alt + 173= ¡
Alt + 174= «
Alt + 175= »
Alt + 176= ░
Alt + 177= ▒
Alt + 178= ▓
Alt + 179= │
Alt + 180= ┤
Alt + 181= Á
Alt + 182= Â
Alt + 183= À
Alt + 184= ©
Alt + 185= ╣
Alt + 186= ║
Alt + 187= ╗
Alt + 188= ╝
Alt + 189= ¢
Alt + 190= ¥
Alt + 191= ┐
Alt + 192= └
Alt + 193= ┴
Alt + 194= ┬
Alt + 195= ├
Alt + 196= ─
Alt + 197= ┼
Alt + 198= ã
Alt + 199= Ã
Alt + 200= ╚
Alt + 201= ╔
Alt + 202= ╩
Alt + 203= ╦
Alt + 204= ╠
Alt + 205= ═
Alt + 206= ╬
Alt + 207= ¤
Alt + 208= ð
Alt + 209= Ð
Alt + 210= Ê
Alt + 211= Ë
Alt + 212= È
Alt + 213= ı
Alt + 214= Í
Alt + 215= Î
Alt + 216= Ï
Alt + 217= ┘
Alt + 218= ┌
Alt + 219= █
Alt + 220= ▄
Alt + 221= ¦
Alt + 222= Ì
Alt + 223= ▀
Alt + 224= Ó
Alt + 225= ß
Alt + 226= Ô
Alt + 227= Ò
Alt + 228= õ
Alt + 229= Õ
Alt + 230= µ
Alt + 231= þ
Alt + 232= Þ
Alt + 233= Ú
Alt + 234= Û
Alt + 235= Ù
Alt + 236= ý
Alt + 237= Ý
Alt + 238= ¯
Alt + 239= ´
Alt + 241= ±
Alt + 242= ‗
Alt + 243= ¾
Alt + 244= ¶
Alt + 245= §
Alt + 246= ÷
Alt + 247= ¸
Alt + 248= °
Alt + 249= ¨
Alt + 250= •
Alt + 250= •
Alt + 251= ¹
Alt + 252= ³
Alt + 253= ²
Alt + 254= ■
Alt + 255=
Alt + 256=.

Estrelas:
★
☆
Alt+10017= ✡
Alt+10022= ✦
Alt+10023= ✧
Alt+10025= ✩
Alt+10026= ✪
Alt+10027= ✫
Alt+10028= ✬
Alt+10029= ✭
Alt+10030= ✮
Alt+10031= ✯
Alt+10032= ✰
Alt+10037= ✵
Alt+10038= ✶
Alt+10039= ✷
Alt+10040= ✸
Alt+10041= ✹
Alt+10059= ❋

Xadrez:
Alt+9812= ♔ Rei branco
Alt+9813= ♕ Rainha branca
Alt+9814= ♖ Torre branca
Alt+9815= ♗ Bispo branco
Alt+9816= ♘ Cavalo branco
Alt+9817= ♙ Peão branco
Alt+9818= ♚ Rei negro
Alt+9819= ♛ Rainha negra
Alt+9820= ♜ Torre negra
Alt+9821= ♝ Bispo negro
Alt+9822= ♞ Cavalo negro
Alt+9823= ♟ Peão negro

Signos do Zodíaco:
Alt+9800= ♈ Áries
Alt+9801= ♉ Touro
Alt+9802= ♊ Gemêos
Alt+9803= ♋ Cancer
Alt+9804= ♌ Leão
Alt+9805= ♍ Virgem
Alt+9806= ♎ Libra
Alt+9807= ♏ Escorpião
Alt+9808= ♐ Sagitário
Alt+9809= ♑ Capricórnio
Alt+9810= ♒ Aquário
Alt+9811= ♓ Peixes

Planetas:
Alt+9788= ☼ Sol
Alt+9790= ☾ Lua
Alt+9791= ☿ Mercúrio
Alt+9792= ♀ Vênus
Alt+9793= ♁
Alt+9794= ♂ Marte
Alt+9795= ♃ Júpiter
Alt+9796=♄ saturno
Alt+9797=♅ Urano
Alt+9798=♆ Netuno
Alt+9799=♇ Plutão

Quadrados:
Alt+10063= ❏
Alt+10064= ❐
Alt+10065= ❑
Alt+0066= ❒

Mãos:
Alt+9754= ☚ mão negra apontando a esquerda
Alt+9755= ☛mão negra apontando p/ a direita
Alt+9756= ☜ mão branca apontando a esquerda
Alt+9757= ☝mão apontando p/ o alto
Alt+9758= ☞ mão apontando p/ a direita
Alt+9759= ☟ mão apontando p/ baixo
Alt+9996= ✌ paz e amor
Alt+9997= ✍ assinando

Astrologia e Astronomia:
Alt+9737= ☉ sol
Alt+9740= ☌ conjunção
Alt+9741= ☍ oposição
Alt+9738= ☊ nó ascendente
Alt+9739= ☋ nó descendente
Alt+9729= ☁ nuvem
Alt+9732= ☄ cometa
Alt+9728= ☀ sol preto
Alt+10042=✺ sol preto-2
Alt+9832= ♨ tempo quente
Alt+10061=❍ lua minguando

Setas:
Alt+10174= ➾
Alt+10162= ➲
Alt+10161= ➱
Alt+10159= ➯
Alt+10158= ➮
Alt+10157= ➭
Alt+10156= ➬
Alt+10155= ➫
Alt+10154= ➪
Alt+10153= ➩
Alt+10152= ➨
Alt+10151= ➧
Alt+10150= ➦
Alt+10149= ➥
Alt+10148= ➤
Alt+10147= ➣
Alt+10146= ➢
Alt+10145= ➡
Alt+10144= ➠
Alt+10143= ➟
Alt+10142= ➞
Alt+10141= ➝
Alt+10140= ➜
Alt+10139= ➛
Alt+10138= ➚
Alt+10137= ➙
Alt+10136= ➘
Alt+10132= ➔


Flechas:
Alt+10163= ➳
Alt+10164= ➴
Alt+10165= ➵
Alt+10166= ➶
Alt+10167= ➷
Alt+10168= ➸
Alt+10169= ➹
Alt+10170= ➺
Alt+10171= ➻
Alt+10172= ➼
Alt+10173= ➽

Flores:
Alt+10045= ✽
Alt+10046= ✾
Alt+10047= ✿
Alt+10048= ❀
Alt+10049= ❁
Alt+10051= ❃
Alt+10052= ❄
Alt+10053= ❅
Alt+10054= ❆
Alt+10058= ❊

Cruzes:
Alt+10009= ✙
Alt+10010= ✚
Alt+10011= ✛
Alt+10013= ✝
Alt+10014= ✞
Alt+10015= ✟
Alt+10016= ✠
Alt+10018= ✢
Alt+10019= ✣
Alt+10020= ✤
Alt+10021= ✥
Alt+9580= ╬
Alt+9766= ☦
Alt+9768= ☨
Alt+9769= ☩
Alt+10056=❈
Alt+8889= ⊹

Pontos e traços:
Alt+8756= ∴
Alt+8757= ∵
Alt+8758= ∶
Alt+8759= ∷
Alt+8760= ∸
Alt+8761= ∹
Alt+8762= ∺
Alt+8763= ∻
Alt+8781= ≍
Alt+8782= ≎
Alt+8783= ≏
Alt+8784= ≐
Alt+8785= ≑
Alt+8786= ≒
Alt+8787= ≓
Alt+8788= ≔
Alt+8789= ≕
Alt+8790= ≖

Símbolos variados:
Alt+9990 = ✆
Alt+9742 = ☎
Alt+9743 = ☏
Alt+9773 = ☭
Alt+10085= ❥
Alt+8987 = ⌛
Alt+8986 = ⌚
Alt+9993 = ✉
Alt+9992 = ✈
Alt+9985 = ✁
Alt+9986 = ✂
Alt+9987 = ✃
Alt+9988 = ✄
Alt+9762 = ☢
Alt+9999 = ✏
Alt+9998 = ✎
Alt+9730 = ☂
Alt+9763 = ☣
Alt+9765 = ☥
Alt+9760 = ☠
Alt+9767 = ☧
Alt+10000= ✐
Alt+10001= ✑
Alt+10002= ✒
Alt+10070= ❖
Alt+10075= ❛
Alt+10076= ❜
Alt+10077= ❝
Alt+10078= ❞
Alt+10081= ❡
Alt+10082= ❢
Alt+10083= ❣
Alt+10086= ❦
Alt+10087= ❧
Alt+9731 = ☃
Alt+8754 = ∲
Alt+8755 = ∳
Alt+9770 = ☪
Alt+9771 = ☫
Alt+9708 = ◬
Alt+9774 = ☮
Alt+9772 = ☬
Alt+9775 = ☯
Alt+9784 = ☸
Alt+9764 = ☤
Alt+10055= ❇
Alt+10056= ❈
Alt+10057= ❉
Alt+10050= ❂
Alt+10033= ✱
Alt+10034= ✲
Alt+9785 = ☹
Alt+8984 = ⌘
Alt+9673 = ◉
Alt+8661 = ⇕
Alt+9641 = ▩
Alt+8865 = ⊡
Alt+8864 = ⊠
Alt+8863 = ⊟
Alt+8862 = ⊞
Alt+8861 = ⊝
Alt+8860 = ⊜
Alt+8859 = ⊛
Alt+8858 = ⊚
Alt+8857 = ⊙
Alt+8880 = ⊰
Alt+8881 = ⊱
Alt+8882 = ⊲
Alt+8883 = ⊳
Alt+8887 = ⊷
Alt+8865 = ⊡
Alt+3356 = ജ
Alt+9637 = ▥
Alt+9689 = ◙
Alt+9680 = ◐
Alt+8813 = ≭

Strict (2048): Declaration of App\Controller\UsersController::beforeFilter() should be compatible with App\Controller\AppController::beforeFilter(Cake\Event\Event $event) [APP/Controller\UsersController.php, line 12]

Strict (2048): Declaration of App\Controller\UsersController::beforeFilter() should be compatible with App\Controller\AppController::beforeFilter(Cake\Event\Event $event) [APP/Controller\UsersController.php, line 12]
Warning (4096): Argument 1 passed to App\Controller\UsersController::beforeFilter() must be an instance of App\Controller\Event, instance of Cake\Event\Event given, called in C:\Users\daniel\blog\vendor\cakephp\cakephp\src\Event\EventManager.php on line 385 and defined [APP/Controller\UsersController.php, line 14]

Hi!

If you are just like me studying the tutorial

CakePHP Cookbook Documentation
Release 3.x
Cake Software Foundation
January 18, 2016

You should have been found this problem when you finished the blog example.

Solution


Change this

    public function beforeFilter(Event $event)
    {
        parent::beforeFilter($event);
        // Allow users to register and logout.
        // You should not add the "login" action to allow list. Doing so would
        // cause problems with normal functioning of AuthComponent.
        $this->Auth->allow(['add', 'logout']);
    }

For this

    public function beforeFilter(\Cake\Event\Event $event)
    {
        $this->Auth->allow(['add','logout']);
    }
 
Good luck!

DROPDOWNLIST - You want to show the name, not the id. Me too. That's how I did it.

Hi!

Straight to the point.

        First, I was studying the tutorial. And was working with treelist. This is no good for me. So, I asked myself,  how do make this dropdownlist show the name? The standard answer is, "YOU SHOULD USE VIRTUAL FIELD". And I found it really annoying. So, I found out this solution.

        //You write this in your controller

        $query = $this->Articles->Categories->find('all', array('fields' => array('id', 'name')));
        foreach($query as $row)
        {
            $id = $row['id'];
            $name = $row['name'];
            $categories[$id] = $name;
        }

       //You write this in  your template
     
       echo $this->Form->input('category_id', array('type' => 'select','options'=> $categories));

And you are done! And of story!

Good luck!

PS: I'm new to cakePHP. This was really annoying to find out.

More informations click on the link bellow

http://stackoverflow.com/questions/19920094/cakephp-format-findall-to-list-in-view

Lines of the tutorial are incomplete - Page 90 - CakePHP Cookbook

Hi!

I found this problem when I was studying the tutorial

CakePHP Cookbook Documentation
Release 3.x
Cake Software Foundation
January 18, 2016

<td><?= $category->id ?></td>
<td><?= $category->parent_id ?></td>
<td><?= $category->lft ?></td>
<td><?= $category->rght ?></td>
<td><?= h($category->name) ?></td>
<td><?= h($category->description) ?></td>
<td><?= h($category->created) ?></td>
<td class="actions">
<?= $this->Html->link(__('View'), ['action' => 'view', $category->id]) ?>
<?= $this->Html->link(__('Edit'), ['action' => 'edit', $category->id]) ?>
<?= $this->Form->postLink(__('Delete'), ['action' => 'delete', $category->id], 
<?= $this->Form->postLink(__('Move down'), ['action' => 'moveDown', $category->
<?= $this->Form->postLink(__('Move up'), ['action' => 'moveUp', $category-></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>

Correction

    <?= $this->Html->link(__('View'), ['action' => 'view', $category->id]) ?>
    <?= $this->Html->link(__('Edit'), ['action' => 'edit', $category->id]) ?>
    <?= $this->Form->postLink(__('Delete'), ['action' => 'delete', $category->id]) ?>
    <?= $this->Form->postLink(__('Move down'), ['action' => 'moveDown', $category->id]) ?>
    <?= $this->Form->postLink(__('Move up'), ['action' => 'moveUp', $category->id]) ?>

Good luck!

Error: SQLSTATE[HY000]: General error: 1364 Field 'parent_id' doesn't have a default value

CakePHP Cookbook Documentation
Release 3.x
Cake Software Foundation

January 18, 2016

Page 88

These fields are automatically managed by the TreeBehavior when a category is saved.
Using your web browser, add some new categories using the /yoursite/categories/add controller

action.

Error: SQLSTATE[HY000]: General error: 1364 Field 'parent_id' doesn't have a default value

If you are using SQL keywords as table column names, you can enable identifier quoting for your database connection in config/app.php.

SQL Query:

INSERT INTO categories (lft, rght) VALUES (:c0, :c1)
If you want to customize this error message, create src\Template\Error\pdo_error.ct

SOLUTION

The parent_id was created as not null, make it nullable.

I did it using PHP Admin
I'm using vertrigo (the best wamp I ever found)

Harlock: Space Pirate - The First 10 Minutes

Katakana（カタカナ）4 - タチツテト

Error: Class 'App\Model\Entity\DefaultPasswordHasher' not found

Hi!

use Cake\Auth\DefaultPasswordHasher; <--------------- Maybe you forgot to add this.

protected function _setPassword($value)
{
$hasher = new DefaultPasswordHasher();
return $hasher->hash($value);
}

Good Luck!

VERTRIGO PASSWORD MYSQL

Hi!

Login -> root
password -> vetrigo.

http://sourceforge.net/p/vertrigo/support-requests/1/

PYTHON 2.7 / INSTALL PIP

You have installed PYTHON 2.7, and you need PIP (because Python 2.7 does not have it)

Answer : Clique on the link bellow

http://stackoverflow.com/questions/4750806/how-do-i-install-pip-on-windows/11311788#11311788

- cakephp/cakephp 3.1.7 requires ext-intl * -> the requested PHP extension intl is missing from your system.

Hi!

If you were trying to execute this

C:\Users\daniel>composer create-project --prefer-dist cakephp/app bookmarker

And received this message

 - cakephp/cakephp 3.1.7 requires ext-intl * -> the requested PHP extension intl is missing from your system.

Solution I found

uncomment this entry of your PHP.ini

;extension=php_intl.dll

After this, you're gonna a result similar to this bellow.


C:\Users\daniel>composer create-project --prefer-dist cakephp/app bookmarker
You are running composer with xdebug enabled. This has a major impact on runtime
 performance. See https://getcomposer.org/xdebug
Installing cakephp/app (3.1.2)
  - Installing cakephp/app (3.1.2)
    Loading from cache

Created project in bookmarker
Loading composer repositories with package information
Installing dependencies (including require-dev)
  - Installing aura/installer-default (1.0.0)
    Downloading: 100%

  - Installing cakephp/plugin-installer (0.0.12)
    Downloading: 100%

  - Installing psr/log (1.0.0)
    Downloading: 100%

  - Installing nesbot/carbon (1.13.0)
    Downloading: 100%

  - Installing mobiledetect/mobiledetectlib (2.8.19)
    Downloading: 100%

  - Installing aura/intl (1.1.1)
    Downloading: 100%

  - Installing ircmaxell/password-compat (v1.0.4)
    Downloading: 100%

  - Installing cakephp/cakephp (3.1.7)
    Downloading: 100%

  - Installing symfony/yaml (v3.0.1)
    Downloading: 100%

  - Installing symfony/filesystem (v3.0.1)
    Downloading: 100%

  - Installing symfony/config (v3.0.1)
    Downloading: 100%

  - Installing symfony/polyfill-mbstring (v1.0.1)
    Downloading: 100%

  - Installing symfony/console (v3.0.1)
    Downloading: 100%

  - Installing robmorgan/phinx (v0.5.1)
    Downloading: 100%

  - Installing cakephp/migrations (1.5.2)
    Downloading: 100%

  - Installing jakub-onderka/php-console-color (0.1)
    Downloading: 100%

  - Installing jakub-onderka/php-console-highlighter (v0.3.2)
    Downloading: 100%

  - Installing dnoegel/php-xdg-base-dir (0.1)
    Downloading: 100%

  - Installing nikic/php-parser (v2.0.0)
    Downloading: 100%

  - Installing symfony/var-dumper (v3.0.1)
    Downloading: 100%

  - Installing psy/psysh (v0.6.1)
    Downloading: 100%

  - Installing jdorn/sql-formatter (v1.2.17)
    Downloading: 100%

  - Installing cakephp/debug_kit (3.2.5)
    Downloading: 100%

  - Installing cakephp/bake (1.1.3)
    Downloading: 100%

symfony/console suggests installing symfony/event-dispatcher ()
symfony/console suggests installing symfony/process ()
symfony/var-dumper suggests installing ext-symfony_debug ()
psy/psysh suggests installing ext-pcntl (Enabling the PCNTL extension makes PsyS
H a lot happier :))
psy/psysh suggests installing ext-posix (If you have PCNTL, you'll want the POSI
X extension as well.)
psy/psysh suggests installing ext-readline (Enables support for arrow-key histor
y navigation, and showing and manipulating command history.)
psy/psysh suggests installing ext-pdo-sqlite (The doc command requires SQLite to
 work.)
cakephp/debug_kit suggests installing ext-sqlite (DebugKit needs to store panel
data in a database. SQLite is simple and easy to use.)
Writing lock file
Generating autoload files
> Cake\Composer\Installer\PluginInstaller::postAutoloadDump
> App\Console\Installer::postInstall
Created `config/app.php` file
Set Folder Permissions ? (Default to Y) [Y,n]? Y
Updated Security.salt value in config/app.php

C:\Users\daniel>

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER - IIS - Could not acquire connection - Are you getting insane with this error?

Hi!

Is Integration information server making you lose your mind because of this error?

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

There are many reasons for this.

First

You named your connection with a fancy name. Example IggyAzaleia.10-78-5_12_WTF.
Solution : Connections must have simple names. No points, no dashes. Example Connection01

Second

You are updating a DTSX package, and suddenly you receive this dammned error. The message says that it is impossible to logging.

In this case there some possibilities
        The user you your using is blocked. There were so many errors that the user you are using in the connection string was blocked.
        When you update the DTSX, the connection you have entered loses the password. Fill the connection string again and don't forget the password. It seems that everything is ok (but IIS IS LYING!)

And that is it.

Good luck!

PS: If you have any doubt, post your comment below.

How to see what's in the PATH - Enviroment variables - DOS

Answer
c:\> echo %PATH%

Connection Error [ERR_CONNECTION]: Unable to connect to getcomposer.org

Connection Error [ERR_CONNECTION]: Unable to connect to getcomposer.org

Request to https://getcomposer.org/installer failed with errors:
Failed to open stream: No connection could be made because the target machine actively refused it.

http://stackoverflow.com/questions/24752354/composer-setup-connection-error-err-connection-unable-to-connect-to-getcomp