Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- // sausagecash.com
- // class.php
- define('FATAL', E_USER_ERROR);
- define('ERROR', E_USER_WARNING);
- define('WARNING', E_USER_NOTICE);
- $errors = new errors(1);
- class User {
- function check_login($username,$password) {
- if(mysql_num_rows(mysql_query("SELECT username,password FROM users WHERE username='".mysql_real_escape_string($username)."' AND password='".mysql_real_escape_string($password)."'"))>0) {
- return true;
- } else {
- trigger_error("Login Error. Could not validate username and/or password", ERROR);
- return false;
- }
- }
- function checkUsername($username) {
- if(mysql_num_rows(mysql_query("SELECT username FROM users WHERE username='".mysql_real_escape_string($username)."'"))>0) {
- return "<img src='/unavailable.jpg'>";
- } else { return "<img src='/available.gif'>"; }
- }
- function getValue($username,$item) {
- if($result=mysql_query("SELECT ".$item." FROM users WHERE username='".$username."'")) {
- $x=mysql_fetch_row($result); return $x[0];
- } else {
- trigger_error("Error grabbing member column value", WARNING);
- return false;
- }
- }
- function reset_pw($email) {
- if(mysql_num_rows(mysql_query("SELECT email FROM users WHERE email='".mysql_real_escape_string($email)."'"))>0) {
- $characters = "abcdefghijklmnopqrstuvwxyz1234567890";
- $newpw="";
- for($i=0;$i<=rand(8,12);$i++) {
- shuffle($characters); $newpw .= $characters[0];
- }
- if(mysql_query("UPDATE users SET password='".$newpw."' WHERE email='".mysql_real_escape_string($email)."'")) { return true; } else { trigger_error("Error updating password", ERROR); }
- } else { trigger_error("Error finding email address", ERROR); return false; }
- }
- function create_user($username,$password,$email,$realname,$taxid,$phone,$nickname,$paytype,$payinfo) {
- if(mysql_query("INSERT INTO users (username,password,email,realname,taxid,phone,nickname,paytype,payinfo) VALUES ('".$username."','".$password."','".$email."','".$realname."','".$taxid."','".$phone."','".$nickname."','".$paytype."','".$payinfo."')")) { return true; } else { trigger_error("Error adding user to database", WARNING); }
- }
- function delete_user($user_id) {
- if(mysql_query("DELETE FROM users WHERE id='".$user_id."'")) { return true; } else { trigger_error("Error deleting user from database", WARNING); return false; }
- }
- function modify_user($username,$password,$email,$realname,$taxid,$phone,$nickname,$paytype,$payinfo) {
- if(mysql_query("UPDATE users SET password='".mysql_real_escape_string($password)."', email='".mysql_real_escape_string($email)."', realname='".mysql_real_escape_string($realname)."', taxid='".mysql_real_escape_string($taxid)."', phone='".mysql_real_escape_string($phone)."', nickname='".mysql_real_escape_string($nickname)."', paytype='".mysql_real_escape_string($paytype)."', payinfo='".mysql_real_escape_string($payinfo)."' WHERE username='".$username."'")) { return true; } else { trigger_error("Error modifying user", WARNING); }
- }
- }
- class News {
- function create_story($title,$story) {
- if(mysql_query("INSERT INTO news (title,article) VALUES ('".$title."','".$story."')")) { return true; } else { trigger_error("Error adding news story", ERROR); return false; }
- }
- function displayArticles($howmany) {
- if($result=mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT ".$howmany)) {
- while($x=mysql_fetch_array($result)) {
- echo "<p class='news'><b>".$x["title"]."</b><Br>".$x["article"]."</p>";
- }
- } else {
- trigger_error("Error reading news items from database", ERROR);
- return false;
- }
- }
- }
- class Leads {
- function click($user_id,$ip,$type) {
- switch($type) {
- case CLICK:
- if(!mysql_num_rows(mysql_query("SELECT * FROM leads WHERE ipaddr='".$ip."'"))>0) {
- if(mysql_query("INSERT INTO leads (username,month,day,year,ipaddr,type) VALUES ('".$user_id."',".date("n").",".date("j").",".date("Y").",'".$ip."','CLICK')")) { return true; } else { trigger_error("Error inserting click into database", WARNING); }
- } else { return true; }
- exit;
- case LEAD:
- if(mysql_query("UPDATE leads SET type='LEAD' WHERE ipaddr='".$ip."' AND username='".$user_id."' LIMIT 1")) { return true; } else { trigger_error("Error updating click to lead", WARNING); }
- exit;
- }
- }
- function divide ($numerator, $denominator) {
- if ($numerator == 0 || $denominator==0)
- return (round(0,4)*100);
- else
- return (round(($numerator/$denominator)));
- }
- function displayMonth($user_id,$month,$year) {
- if($result=mysql_query("SELECT day FROM leads WHERE username='".$user_id."' AND month='".$month."' AND year='".$year."' ORDER BY day DESC LIMIT 1")) {
- echo "<table><tr><td class='header'>Date</td><td class='header'>Uniques</td><td class='header'>Sales</td><td class=header>Ratio</td><td class=header>Payout</td></tr>";
- $x=mysql_fetch_row($result);
- if($month==date("n") && $year==date("Y")) { $theend=date("j"); } else { $theend=$x[0]; }
- $totalratio1=0;
- $totalratio2=0;
- for($i=1;$i<=$theend;$i++) {
- $leadcount = mysql_num_rows(mysql_query("SELECT * FROM leads WHERE username='".$user_id."' AND month='".$month."' AND year='".$year."' AND day='".$i."' AND type='LEAD'"));
- $clickcount = mysql_num_rows(mysql_query("SELECT * FROM leads WHERE username='".$user_id."' AND month='".$month."' AND year='".$year."' AND day='".$i."'"));
- echo "<tr><td>".$month."/".$i."/".$year."</td><td>".$clickcount."</td><td>".$leadcount."</td><td>";
- if($this->divide($clickcount,$leadcount)>1) { echo "1:".$this->divide($clickcount,$leadcount); } else { echo "0:".$this->divide($clickcount,$leadcount); }
- $totalratio1+=$leadcount; $totalratio2+=$clickcount;
- echo "</td><td>$".(20*$leadcount)."</td></tr>";
- }
- echo "<tr><td align=left><b>Total</b></td><td>".$totalratio2."</td><td>".$totalratio1."</td><td>";
- if($this->divide($totalratio2,$totalratio1)>1) { echo "1:".$this->divide($totalratio2,$totalratio1); } else { echo "0:".$this->divide($totalratio2,$totalratio1); }
- echo "</td><td>$".(20*mysql_num_rows(mysql_query("SELECT * FROM leads WHERE username='".$user_id."' AND month='".$month."' AND year='".$year."' AND type='LEAD'")))."</td></tr></table>";
- } else { trigger_error("Error fetching tracking information from database", WARNING); return false; }
- }
- function RevenueToday($user_id) {
- return (20*mysql_num_rows(mysql_query("SELECT * FROM leads WHERE username='".$user_id."' AND month='".date("n")."' AND year='".date("Y")."' AND day='".date("j")."' AND type='LEAD'")));
- }
- }
- class Payouts {
- function displayList($username) {
- $result=mysql_query("SELECT * FROM payouts WHERE username='".$username."'");
- echo "<table><tr><td class='header'>Period</td><td class='header'>Amount</td><td class='header'>Status</td></tr>";
- while($x=mysql_fetch_array($result)) {
- echo "<tr><td>".$x["period"]."</td><td>".$x["amount"]."</td><td>".$x["status"]."</td></tr>";
- }
- echo "</table>";
- }
- }
- class errors {
- var $debug_level = 0;
- function errors($debug_level = 0)
- {
- $this->debug_level = $debug_level;
- set_error_handler(array($this, 'handle_error'));
- }
- function handle_error($type, $string, $file, $line, $vars)
- {
- switch ($type)
- {
- case FATAL:
- switch ($this->debug_level)
- {
- default:
- case 0:
- echo 'Error: '.$string.' in '.$file.' on line'. $line.'<br />';
- print_r($var);
- exit;
- case 1:
- echo 'There has been an error. Sorry for the inconvenience.';
- exit;
- }
- case ERROR:
- echo '<pre><b>ERROR</b> ['.$type.'] '.$string.'<br />'."</pre>\n";
- break;
- case WARNING:
- echo '<pre><b>WARNING</b> ['.$type.'] '.$string.'<br />'."</pre>\n";
- break;
- }
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement