Inizializzazione conclusa!
Connessione twitter:
object(TwitterOAuth)#1 (13) {
["http_code"]=>
NULL
["url"]=>
NULL
["host"]=>
string(26) "https://api.twitter.com/1/"
["timeout"]=>
int(30)
["connecttimeout"]=>
int(30)
["ssl_verifypeer"]=>
bool(false)
["format"]=>
string(4) "json"
["decode_json"]=>
bool(true)
["http_info"]=>
NULL
["useragent"]=>
string(25) "TwitterOAuth v0.2.0-beta2"
["sha1_method"]=>
object(OAuthSignatureMethod_HMAC_SHA1)#2 (0) {
}
["consumer"]=>
object(OAuthConsumer)#3 (3) {
["key"]=>
string(19) "HGc7utwP7JMAxP3S5sg"
["secret"]=>
string(43) "siDBLUxv4sM6LjBdUBsF48FUuace16w758bPILyrNN8"
["callback_url"]=>
NULL
}
["token"]=>
object(OAuthConsumer)#4 (3) {
["key"]=>
string(50) "203460865-0xx3xI7EsfxA2oXRk78PjpbJa1caOsizICf1V5pH"
["secret"]=>
string(39) "bSB0POyk2UKSQLHcMnqjILMjuq5UP1z9g0xsoJs"
["callback_url"]=>
NULL
}
}
Content twitter:
object(stdClass)#5 (1) {
["errors"]=>
array(1) {
[0]=>
object(stdClass)#6 (2) {
["message"]=>
string(119) "The Twitter REST API v1 is no longer active. Please migrate to API v1.1. https://dev.twitter.com/docs/api/1.1/overview."
["code"]=>
int(64)
}
}
}
Started daily post process on 17/05/2014-15:00
Now connecting to the DB...
Properly connected to the DB...
Session DB: agorkcom
Query per flag da resettare: UPDATE rockdayz.events SET
TwitterPubStatus='0'
WHERE (substring(DataEvento,5,4)<>'0517'
AND TwitterPubStatus<>'0')
Query per eventi da pubblicate: SELECT
eve.ID as ID,
eve.DataCreazione as DataCreazione,
eve.UserIDAutore as UserIDAutore,
eve.DataEvento as DataEvento,
eve.TipoData as TipoData,
eve.DescrizioneEvento as DescrizioneEvento,
eve.UrlEvento as UrlEvento,
eve.UrlImmagine as UrlImmagine,
eve.VideoID as VideoID,
eve.GenereID as GenereID,
eve.TwitterReference as TwitterReference,
eve.TwitterPubStatus as TwitterPubStatus,
lkt.LikesCount as LikesCount,
gen.Descrizione as NomeGenere,
ana.Cognome as Cognome,
ana.Nome as Nome,
ana.NomeAvatar as NomeAvatar,
comm.NomeInChiaro as NomeInChiaro
FROM rockdayz.events as eve
LEFT JOIN (SELECT ID as LikeID, Count(*) as LikesCount FROM rockdayz.likes as lks GROUP BY lks.ID) as lkt
ON lkt.LikeID=eve.ID
LEFT JOIN genre as gen
ON eve.GenereID=gen.ID
LEFT JOIN agorkcom.anagrafica as ana
ON (eve.UserIDAutore=ana.UserID AND ana.CodiceCommunity='Hr05qsI35R')
LEFT JOIN agorkcom.community as comm
ON (comm.CodiceCommunity='Hr05qsI35R')
WHERE ( substring(eve.DataEvento,5,4)='0517'
AND eve.TwitterPubStatus='0'
AND eve.Cancellato='N'
AND eve.TipoData='1'
AND eve.Convalidato = '1')
ORDER BY eve.DataEvento
DESC LIMIT 0,1
Eventi trovati: 1
Message to be twitted:Video:Bill Bruford was born 17 May 1949 in Sevenoaks, England. He was drummer of Yes and he had a brief stin... http://www.rockdayz.com/agork/sites/rockdayz/presentation/p100a/rd_showevent.php?id=1088&utm_source=Twitter&utm_medium=SocialMedia&utm_campaign=TwEvents
Access token: 203460865-0xx3xI7EsfxA2oXRk78PjpbJa1caOsizICf1V5pH
Access secret: bSB0POyk2UKSQLHcMnqjILMjuq5UP1z9g0xsoJs
Now trying to tweet it...
Query per flag da settare pubblicato: UPDATE rockdayz.events SET
TwitterPubStatus='1'
WHERE ID='1088'
Print processing completed!