Php application and website: Parser/CronJobs/Mysql

A website which has a php parser . The file is called by an external entity and then parsing is done. A lot of automated processes and reporting, few cron jobs, extensive security and clean coding. ## Deliverables Suggested Database Structure Message Sent Service(text); From(number); To(number); Date; Time; Message Received (text); Message Sent(text);; ID(Automatic); Medium(Boolean : Web/Non-Web); Credit Recipient (text); User First Name(text);; Last Name(text);; Primary Mobile Number(number); City(text);; Country(text);; Date of Birth; Gender(text);; Messages Sent in last 20 minutes(number): Advertising Preference (bool: Yes/No); Promotional Offers (bool: Yes/No); Account under block (Boolean); Message Sender Preference (bool: Unregistered/Registered); Message Time Preference from (time); Message Time Preference to (time) ; Message time preference (Boolean) ; Secondary mobile number(number); Userid(auto gen number); Alias Primary mobile number; Userid; Alias 1(number), Upto 5 alias possible Message Outbox Service; From; To; Date; Time; Message Received; Message Scheduled Time; Message Scheduled Date; ID(Automatic); Medium(Boolean : Web/Non-Web); Credit Recipient Block User id originator; userids blocked (numbers, csv) Cron Job 20 min Scheduler’s Last run time 20 minute attack shield’s last run time 24 hr system 1 check’s last run time 24 hr system 2 check’s last run time Credit Service; From; To; Date; Time; Message Received; Message Sent; Credit Received (number); Credit given out (number) Global Settings Override message time preferences (bool, default 0) Override advertising and promotional constraints (bool, default 0) System 1 check frequency (number) System 2 check frequency (number) Error Message Service; From; To; Date; Time; Message Received; Error Reason (text) Service Service Name; Transfer credit % to recipient (%); Credit per unit (number) Process: 1.) A php file is called with 3 parameters $content = $_REQUEST["content"]; $sender = $_REQUEST["sender"]; $inNumber = $_REQUEST["inNumber"]; 2.) Check if user has sent more than 100 message in last 20 minutes, if yes, check for sql injection and place error message in database if all clear; if no continue 3-) Content is of form Lazme (from alias number) (to alias number) (message) Check if from alias number has the attached mobile number as “inNumber?? If no, check for sql injection and place error message in database if all clear; if yes continue 4.) Check what service it is If first bracket is not alias number then is it a service, If no, check for sql injection and place error message in database if all clear; if yes continue 5.) Now if message is not sql injection parse Lazme (number 1) (number 2) (Message) to Lazme(number2) Message Based on user scheduling preferences either send it directly by calling [login to view URL] (which will input it into sent database) or put it in outbox with appropriate scheduled time (based on both sender and sendee). Sender 2 (clone of send 1) is called every 20 minutes..if time has elapsed, send it via post http Alias numbers are 4-6 digit numbers generated randomly and not having 7 as first digit. User get a number upon registration. Files Functionality Home Register Lost Password Where we are (htm) Send Message Create Alias Terms & Conditions (htm) About Us Advertisers Contact us Admin home page User account home page Block number Unlock number from block Inbox Sent Messages Advertising preferences Add Alias Change Primary Alias Change Mobile number Add secondary mobile Add Credit (paypal) Remove alias Message Preferences Reporting Admin global preferences, see and modify Admin new service start Admin user account report Report Credit by service, date from, date to; top 5% senders; Top 5% recipients Message report consolidated Test run report Do a test run All text in website should be sourced via parameters and all text being written in one file and assigned to parameters. Helps when site may be translated. Alias are 4-6 digit numbers generated by us which don’t start with 7 or 0 and are provided after registration. ## Platform Linux, Mysql, Php