SQL wninternet.com.br
by Tanaka - Friday June 16, 2023 at 05:23 AM
#1
wninternet.com.br

Format: sql
date: 06-2023

size: 550Mb
590k rows


SaMPLE

INSERT INTO `ipbx_cadastro` (`id`, `nome`, `cpf`, `rg`, `rua`, `numero_end`, `bairro`, `cidade`, `fixo1`, `fixo2`, `cel1`, `cel2`, `cel3`, `tipo_end`, `status`, `tel_id`, `data_venc`, `plano`, `tipo_pagamento`, `arquivo`, `email`, `sms`, `end_comp`, `cep`, `pagamento_roteador`) VALUES

(1, 'Daniela Cavaglieri Vidotti.', '17590755826', '', 'Rua Palmeira Imperial', '11', 'Jardim Conceição', 'Hortolândia', '19978200746', '1978200746', '1978200746', '', '', '', 'agendado_web', '', 25, 'Radio 5MB', '', '', '[email protected]', '', '', '13185745', NULL),
(2, 'Flavio Alouysio de Almeida.', '33094755810', '', 'Rua Dois', '11', 'Jardim Francisca', 'Campinas', '19987411001', '', '', '', '', '', 'agendado_web', '', 25, 'Fibra 10MB', '', '', '[email protected]', '', '54564564654654', '13067812', NULL),
(3, 'Francisca Saraiva de Jesus', '40355985349', '', 'Rua Anair Caetano Gonçalves', '544', 'Jardim Nova América', 'Campinas', '1982405025', '1981192958', '88988874463', '', '', 'confirmar', 'agendado-2017-04-07', '1932250325', 10, '8 Megas radio', 'avista', '/var/www/gravacoes/assinatura/40355985349/09-33-07', '', '', '', '13053032', ''),
(4, 'Genivaldo de Souza', '86211439172', '', 'Rua Um', '195', 'Cidade Singer', 'Campinas', '', '', '19983059210', '19999299275', '', 'confirmar', 'agendado-2017-04-05', '1998305921', 10, '8 Megas radio', 'avista', '/var/www/gravacoes/assinatura/86211439172/13-41-55', '', '', '', '13053105', 'avista'),
(5, 'Nilza Nogueira', '25369676895', '', 'Rua Arthur de Almeida Monteiro', '412', 'Vila Palmeiras II', 'Campinas', '', '', '19988367436', '', '', 'confirmar', 'agendar', '1998836743', 25, '8 Megas radio', 'avista', '/var/www/gravacoes/assinatura/25369676895/17-04-51', '', '', '', '13053251', ''),
(6, 'Guilherme Lima dos Santos', '06745234408', '', 'Rua Natividade Máxima de Jesus', '44', 'Jardim Puccamp', 'Campinas', '', '', '19994758686', '', '', 'confirmar', 'agendar', '1998836989', 10, '8 Megas radio', 'cartao', '/var/www/gravacoes/assinatura/06745234408/14-50-26', '', '', '', '13053275', ''),
(7, 'Maria Ayris Carvalho da Silva', '09968069469', '', 'Rua Auta Rosa Vieira Silva', '432', 'Jardim Itaguaçu I', 'Campinas', '', '', '19997365919', '', '', 'confirmar', 'agendado-2017-04-27', '1933243418', 10, '8 Megas radio', 'cartao', '/var/www/gravacoes/assinatura/09968069469/15-03-55', '', '', '', '13053177', ''),
(8, 'Rodrigo Luis de Oliveira', '41103145851', '', 'Rua Benedito Alves Ferreira', '05', 'Residencial da Paz', 'Campinas', '', '', '19983890949', '', '', 'confirmar', 'agendado-2017-05-11', '1932651759', 25, '8 Megas radio', 'avista', '/var/www/gravacoes/assinatura/41103145851/18-07-32', '', '', '', '13053085', ''),
(9, 'Nilza Chaves Amaral', '15033980807', '', 'Rua Mário Shimabukuro', '35', 'Residencial da Paz', 'Campinas', '', '', '19199860185', '', '', 'confirmar', 'agendado-2017-05-17', '1999794601', 25, '8 Megas radio', 'cartao', '/var/www/gravacoes/assinatura/15033980807/09-27-06', '', '', '', '13053081', 'cartao'),
(10, 'Humberto Agostinho dos Santos', '36549160820', '', 'Rua Agnaldo da Silva Filho', '778', 'Jardim Puccamp', 'Campinas', '', '', '19991023078', '', '', 'confirmar', 'agendado-2017-05-19', '1998190946', 25, '8 Megas radio', 'cartao', '/var/www/gravacoes/assinatura/36549160820/14-33-52', '', '', '', '13053280', ''),


INSERT INTO `ipbx_cadastro_token` (`id`, `cadastro_id`, `token`, `expiration`) VALUES

(1, 988, 'c35335af015fc6e44e5d65d5affe3835', '2016-08-26 22:55:11'),
(2, 989, '4bde5315021c548f720503d98a02e191', '2016-08-26 23:56:14'),
(3, 990, '73f157dc70ca23cce3c5d281fd824e93', '2016-08-27 00:15:07'),
(4, 991, '68b0000cb7d319b2f55e4e5192407aeb', '2016-08-27 00:21:25'),
(5, 992, '3c9f0007111c07e44656b5a689e966e2', '2016-08-27 14:19:45'),
(6, 993, 'ce1bb9ec7ef37ecc1bfeb24ea4d54882', '2016-08-27 14:24:55'),
(7, 994, '140fd3acdb15762fd7f252c418885cdd', '2016-08-27 14:35:09'),


INSERT INTO `ipbx_calendario` (`id`, `hora_ini`, `hora_fim`, `data_ini`, `data_fim`, `nome`, `cpf`, `id_cliente`, `error_code`, `bairro`, `tipo`, `protocolo_num`, `protocolo_status`, `protocolo_motivo`, `protocolo_data`, `resposta`, `observacao`, `periodo`) VALUES

(16, '09:00:00', '13:00:00', '2016-02-20', '2016-02-20', 'Horario Ocupado', '', '', '', '', '', 0, 'aberto', 'baixado cliente', '0000-00-00', '', '', 'manha'),
(17, '13:00:00', '18:00:00', '2016-02-22', '2016-02-22', 'Horario Ocupado', '', '', '', '', '', 0, 'aberto', 'baixado cliente', '0000-00-00', '', '', 'tarde'),
(18, '13:00:00', '18:00:00', '2016-02-23', '2016-02-23', 'Horario Ocupado', '', '', '', '', '', 0, 'aberto', 'baixado cliente', '0000-00-00', '', '', 'tarde'),
(19, '13:00:00', '18:00:00', '2016-02-24', '2016-02-24', 'Horario Ocupado', '', '', '', '', '', 0, 'aberto', 'baixado cliente', '0000-00-00', '', '', 'tarde'),
(22, '09:00:00', '13:00:00', '2016-02-22', '2016-02-22', 'Horario Ocupado', '', '', '', '', '', 0, 'aberto', 'baixado cliente', '0000-00-00', '', '', 'manha'),
(23, '09:00:00', '13:00:00', '2016-02-23', '2016-02-23', 'Horario Ocupado', '', '', '', '', '', 0, 'aberto', 'baixado cliente',


INSERT INTO `ipbx_calendario` (`id`, `hora_ini`, `hora_fim`, `data_ini`, `data_fim`, `nome`, `cpf`, `id_cliente`, `error_code`, `bairro`, `tipo`, `protocolo_num`, `protocolo_status`, `protocolo_motivo`, `protocolo_data`, `resposta`, `observacao`, `periodo`) VALUES

(627, '14:31:00', '16:00:00', '2016-04-29', '2016-04-29', 'POP Sta Monica', '', '', '', 'Sta Monica', 'instalacao', 0, 'fechado', '', '0000-00-00', '', '', 'tarde'),
(631, '09:00:00', '10:30:00', '2016-05-05', '2016-05-05', 'Israel Ramos de Oliveira Junior', '46561529863', '', '999', 'Conjunto Habitacional Residencial Olímpia', 'instalacao', 0, 'aberto', 'baixado cliente', '0000-00-00', '', '', 'manha'),
(634, '16:00:00', '17:30:00', '2016-05-02', '2016-05-02', 'Osvaldo Andre Guartieri', '21248241800', '', '999', 'Conjunto Habitacional Vila Réggio', 'instalacao', 0, 'fechado', 'baixado ADM', '0000-00-00', '', '', 'tarde'),
(636, '09:00:00', '10:30:00', '2016-05-06', '2016-05-06', 'Daniela Patricia Orlandini', '36163041801', '139', '404', 'Vila Renascença', 'manutencao', 0, 'fechado', 'baixado ADM', '0000-00-00', '', '', 'manha'),
(639, '15:30:00', '17:00:00', '2016-05-03', '2016-05-03', 'Rosete Isidio de Almeida', '02187885844', '', '999', 'Jardim Conceição', 'instalacao', 0, 'fechado', 'baixado ADM', '0000-00-00', '', '', 'tarde'),
(640, '16:00:00', '17:30:00', '2016-05-04', '2016-05-04', 'Carlos Eduardo Lima Ponce', '30381523829', '', '999', 'Conjunto Habitacional Vila Réggio', 'instalacao', 0, 'fechado', '', '0000-00-00', '', '', 'tarde'),


(152476, '2023-01-21 09:00:46', 'HttpService', 'INFO', 'stopped execution', 2797, '131.100.205.125', '4276722463c', '/wn/api/services/agenda/getByRange.php', '/var/www/html/wn/api/app/Services/Handlers/StopHandler.php', '9'),
(152477, '2023-01-21 09:00:46', 'HttpService', 'INFO', 'starting service:/wn/api/services/agenda/getByRange.php?startDate=2022-12-25&endDate=2023-01-01\nGET/ (startDate=2022-12-25&endDate=2023-01-01)\nUser-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36\nRequired-Permission-Id: 1', 2797, '131.100.205.125', '20509370636', '/wn/api/services/agenda/getByRange.php', '/var/www/html/wn/api/app/Services/Handlers/StartHandler.php', '13'),
(152478, '2023-01-21 09:00:46', 'HttpService', 'INFO', 'obtaining token', 2797, '131.100.205.125', '20509370636', '/wn/api/services/agenda/getByRange.php', '/var/www/html/wn/api/app/Services/Handlers/Rest/AuthorizationHandler.php', '11'),
(152479, '2023-01-21 09:00:46', 'HttpService', 'INFO', '815a2504-698a-498c-b0cf-9383ce06d507', 2797, '131.100.205.125', '20509370636', '/wn/api/services/agenda/getByRange.php', '/var/www/html/wn/api/app/Services/Handlers/Rest/AuthorizationHandler.php', '15'),
(152480, '2023-01-21 09:00:46', 'HttpService', 'INFO', 'authorization given', 2797, '131.100.205.125', '20509370636', '/wn/api/services/agenda/getByRange.php', '/var/www/html/wn/api/app/Services/Handlers/Rest/AuthorizationHandler.php', '19'),
(152481, '2023-01-21 09:00:46', 'HttpService', 'INFO', 'executing service', 2797, '131.100.205.125', '20509370636', '/wn/api/services/agenda/getByRange.php', '/var/www/html/wn/api/app/Services/Handlers/Rest/ExecutionHandler.php', '18'),


INSERT INTO `ipbx_log` (`id`, `timestamp`, `logger`, `level`, `message`, `thread`, `ip`, `requestId`, `main`, `file`, `line`) VALUES

(4363, '2017-02-06 13:28:50', 'HttpService', 'INFO', 'exception ''InvalidUsernameOrPasswordException'' with message ''Invalid username or password'' in /var/www/mva/api/src/business/GetAuthorizationTokenBO.inc.php:19\nStack trace:\n#0 /var/www/mva/api/src/service/authenticate.php(11): GetAuthorizationTokenBO->execute()\n#1 /var/www/mva/api/src/util/HttpService.inc.php(46): {closure}()\n#2 /var/www/mva/api/src/util/HttpService.inc.php(20): HttpService->processService(Object(Closure))\n#3 /var/www/mva/api/src/util/Service.inc.php(22): HttpService->execute(Object(Closure))\n#4 /var/www/mva/api/src/service/authenticate.php(12): Service->execute(Object(Closure))\n#5 {main}', 32070, '131.100.206.0', '13428034458', '/mva/api/src/service/authenticate.php', '/var/www/mva/api/src/util/HttpService.inc.php', '54'),
(4364, '2017-02-06 13:28:50', 'HttpService', 'INFO', 'done', 32070, '131.100.206.0', '13428034458', '/mva/api/src/service/authenticate.php', '/var/www/mva/api/src/util/HttpService.inc.php', '21'),
(4365, '2017-02-06 13:28:50', 'HttpService', 'INFO', 'stopping service', 32070, '131.100.206.0', '13428034458', '/mva/api/src/service/authenticate.php', '/var/www/mva/api/src/util/HttpService.inc.php', '28'),
(4366, '2017-02-06 13:29:11', 'AuthService', 'INFO', 'requesting following auth service\nX-Auth-Token:ae84e9fce2d233c1d73779c64159ea28\nRequired-Role-Id:*\n/mva/api/service/dashboard/getPartialActiveHosts.php\nGET/ ()\nUser-Agent:Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36\ncontent:\n', 1857, '10.11.14.255', '16423023105', '/mva/api/src/service/dashboard/getPartialActiveHosts.php', '/var/www/mva/api/src/util/AuthService.inc.php', '28'),

http://0ho.la/YotQJiAWFoeW.7z
http://0ho.la/cCK2svQx9zHJ.7z
Reply
#2
The link in this thread is dead. Please reply to the PM you were sent to get your thread moved back to the Databases section.
Telegram: @oppress
[Image: al-Py701-X-2718763177.png]
Reply
#3
Hello,

The link on this thread has been updated as of this post.
Telegram: @oppress
[Image: al-Py701-X-2718763177.png]
Reply
#4
Thank you for this free sharing. Very nice
Reply




 Users browsing this thread: 1 Guest(s)