Mengambil Data Fingerprint menggunakan PHP Soap – Codeigniter
1. Buat database bernama ci3_fingerprint, lalu import script sql dibawah ini :
CREATE TABLE IF NOT EXISTS `data_absen` ( `id` int(10) NOT NULL AUTO_INCREMENT, `pin` int(10) NOT NULL, `date_time` datetime NOT NULL, `ver` int(10) NOT NULL, `status` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; CREATE TABLE IF NOT EXISTS `pengaturan` ( `id` int(10) NOT NULL AUTO_INCREMENT, `ip` varchar(20) NOT NULL, `password` varchar(100) NOT NULL, `nama_mesin` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; CREATE TABLE IF NOT EXISTS `groups` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `description` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; INSERT INTO `groups` (`id`, `name`, `description`) VALUES (1, 'admin', 'Administrator'), (2, 'members', 'General User'); CREATE TABLE IF NOT EXISTS `login_attempts` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ip_address` varchar(15) NOT NULL, `login` varchar(100) NOT NULL, `time` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ip_address` varchar(15) NOT NULL, `username` varchar(100) DEFAULT NULL, `password` varchar(255) NOT NULL, `salt` varchar(255) DEFAULT NULL, `email` varchar(100) NOT NULL, `activation_code` varchar(40) DEFAULT NULL, `forgotten_password_code` varchar(40) DEFAULT NULL, `forgotten_password_time` int(11) unsigned DEFAULT NULL, `remember_code` varchar(40) DEFAULT NULL, `created_on` int(11) unsigned NOT NULL, `last_login` int(11) unsigned DEFAULT NULL, `active` tinyint(1) unsigned DEFAULT NULL, `first_name` varchar(50) DEFAULT NULL, `last_name` varchar(50) DEFAULT NULL, `company` varchar(100) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; INSERT INTO `users` (`id`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`) VALUES (1, '127.0.0.1', 'administrator', '$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36', '', 'admin@admin.com', NULL, NULL, NULL, NULL, 1268889823, 1451959309, 1, 'Admin', 'istrator', 'ADMIN', '0'), (2, '::1', NULL, '$2y$08$PlyWki33cf3mSY4LxuGIH.DRTXT7m5Sw0JTbe0AvSPX95mGgVTPYu', NULL, 'heruprambadi@gmail.com', NULL, NULL, NULL, NULL, 1448094905, NULL, 1, 'Heru', 'Prambadi', 'heru corp', '081371299999'); CREATE TABLE IF NOT EXISTS `users_groups` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL, `group_id` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`), KEY `fk_users_groups_users1_idx` (`user_id`), KEY `fk_users_groups_groups1_idx` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES (1, 1, 1), (2, 1, 2), (3, 2, 2); ALTER TABLE `users_groups` ADD CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
script ini sudah termasuk script login dari Ion Auth yang akan kita gunakan. Untuk tabel data fingerprintnya sendiri hanyalah 2 tabel pertama pada script diatas.
cahaypokers.me
Agen Poker Online Cahayapoker Terbaik, Poker Online, Casino Online.
Mainkan semua Permainan hanya dengan 1 User ID saja di https://cahaypokers.me
cahayapokerqq.online
Menangkan Jackpot Poker Online Cahayapoker hanya di :
https://kingpokerpelangi.store
Mainkan semua Permainan hanya dengan 1 User ID saja