first need to modify this page.
#####
<?php
mysql_connect("localhost","root", “pass3");
mysql_select_db("st_db");
$msg = "";
$mac_status = "";
if(isset($_GET['user']))
{
$pQuery = "select * from users where mac = '$_GET[user]'";
$rec = mysql_query($pQuery);
if(mysql_num_rows($rec) > 0)
{
$row = mysql_fetch_object($rec);
//$mac_status = $row->status;
$msg = $row->status;
}
else
$msg = "2";
}
?>
<?php
echo $msg;
?>
####
In modified page add following:
the page will still return the value as above but in addition
post to DB following info:
User ID , value, Timestamp , IP address
====================
then 2 reports:
1- search parameter for user = user or wild card
or search by value, ip address, and date from to, to
2- in whmcs on user summary page will like a report labeled “View Auths” , under user profile products/services there is a custom column named xuser id , basically using xuser id as the user parameter, first look at user table in a database under column xuser will find this use xuser,then there is a column tarrif_plan and status will display these three fields on top (xuser=“display xuser”, Status “value from status column usually nothing, 0, or 1) and tariff id what ever that is) then from the db that above log was inserted into from there show for date last 1 month, display result from this new db, as either a popup or new window.
also will need another button on the summary page that says “send message”
this can be a popup also will use xuser id, and take this id and lookup gcm id from table, as the user parameter and this new page will have a small section for entering message, and submit button. this uses gcm for sending message i can provide gcm code.
Hi there - My name is Khorshed. I've read your brief and can see that you’d like to make some changes in your WhmCS page and add some new features. I can help you get this done. I have several years of experience designing and developing website and already developed many websites. I would love to discuss with you further about taking this project on. Thanks
Dear Sir/Madam,
It’s a great pleasure me to bid on your project. I am a 8 years experienced web Developer / Software Engineer.. I hold two master degrees for Computer Science and GIS. Please see my profile I have enough experiences and gained lot of job experiences working in various world recognized institutions.
I am maintaining nearly 100% on time job completion rate with 5 star rating in freelancer.com customer reviews. And also I have passed the necessary skill examinations in freelancer.com which are related to complete your project.
Please accept my bid if u are satisfy with my proposal.
Thank you for giving opportunity to bid on your project…!
I am good in PHP website and I want to do very nice work with you. I have good command over PHP and web designing for web and mobile application.
let me know if you have any query for your website or need to make new website.
Thanks