Security Issues

This topic is locked

Security Issues	5/31/2005 12:46:28 PM
PHPRunner General questions
pplaut author Hi AlL Interested Parties <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1476&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' /> I am working on a licensing scheme which would help us protect our applictions when we distribute them. The theory is such to have an open license database which would accept queries from licensees. This would correspond to a licensee database with the distributed application. When the user launches the application, the application would query the two tables and make sure they match up. If the licesne info was removed from the application, the application would not function very well. The idea here is to make it not worth the effort, not to create a bullet proof security system for our applications, keeping in mind we are distrubuting scripts. Peer


	pplaut author 5/31/2005
	This is a script of the database security table. I think the two would have to match up. The license table which is distributed could not have additional records added to it. This file could also have additional items outside the scope of phprunner. A lot of the CRUD for this app could be generated by PHPRunner but there would obviously need some hand coding to be realized. DROP TABLE IF EXISTS `mos_tsg_license`; CREATE TABLE `mos_tsg_license` ( `email_address` varchar(45) NOT NULL default '', `lic_first_name` varchar(45) NOT NULL default '', `lic_last_name` varchar(45) NOT NULL default '', `lic_city` varchar(45) NOT NULL default '', `lic_reg_number` varchar(45) NOT NULL default '', `lic_reg_key` varchar(45) NOT NULL default '', PRIMARY KEY (`email_address`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='License Verification';