Tuesday, September 15, 2009

Members as Affiliates

I have been asked (several times) how to make it easier for members of the dolphin site to be considered affiliates. Instead of the member needing to sign up as an affiliate, they are one just by joining the site.

The best way is to automatically create the user's affiliate account when they join the site.

First - you have to remove the `aff`` table 'autoincrement' from the `ID`  field.

Then open join.php and find:::


echo _t( '_Join complete' );
echo '
';
echo _t( $sStatusText );


After it paste:::

$sql = "SELECT * FROM Profiles WHERE ID = '".$iMemID."'";
$theUser = db_res( $sql );
$useInfo = mysql_fetch_assoc( $theUser );
$pr_id = $useInfo['ID'];
$pr_Name = $useInfo['NickName'];
$pr_email = $useInfo['Email'];
$pr_Password = $useInfo['Password'];
$pr_DateReg = $useInfo['DateReg'];
$sql = "
INSERT INTO  `aff` (
`ID` ,
`Name` ,
`email` ,
`Password` ,
`Percent` ,
`seed` ,
`RegDate` ,
`Status` 
)
VALUES (
'".$pr_id."',  '".$pr_Name."',  '".$pr_email."',  '".$pr_Password."',  '50',  '0',  '".$pr_DateReg."',  'Active'
);
";
$addAff = db_res( $sql );




Friday, September 4, 2009

Backup Dolphin Automatically using Cpanel

// PHP script to allow periodic cPanel backups automatically, optionally to a remote FTP server.
// This script contains passwords.  KEEP ACCESS TO THIS FILE SECURE! (place it in your home dir, not /www/)

// ********* THE FOLLOWING ITEMS NEED TO BE CONFIGURED *********

// Info required for cPanel access
$cpuser = "username"; // Username used to login to CPanel
$cppass = "password"; // Password used to login to CPanel
$domain = "domain.com"; // Domain name where CPanel is run
$skin = "x"; // Set to cPanel skin you use (script won't work if it doesn't match). Most people run the default x theme

// Info required for FTP host
$ftpuser = "username"; // Username for FTP account
$ftppass = "password"; // Password for FTP account
$ftphost = "ftp.domain.com"; // Full hostname or IP address for FTP host
$ftpmode = "ftp"; // FTP mode ("ftp" for active, "passiveftp" for passive)

// Notification information
$notifyemail = "myemail@domain.com"; // Email address to send results

// Secure or non-secure mode
$secure = 1; // Set to 1 for SSL (requires SSL support), otherwise will use standard HTTP

// Set to 1 to have web page result appear in your cron log
$debug = 1;

// *********** NO CONFIGURATION ITEMS BELOW THIS LINE *********

if ($secure) {
   $url = "ssl://".$domain;
   $port = 2083;
} else {
   $url = $domain;
   $port = 2082;
}

$socket = fsockopen($url,$port);
if (!$socket) { echo "Failed to open socket connection… Bailing out!\n"; exit; }

// Encode authentication string
$authstr = $cpuser.":".$cppass;
$pass = base64_encode($authstr);

$params = "dest=$ftpmode&email=$notifyemail&server=$ftphost&user=$ftpuser&pass=$ftppass&submit=Generate Backup";

// Make POST to cPanel
fputs($socket,"POST /frontend/".$skin."/backup/dofullbackup.html?".$params." HTTP/1.0
");
fputs($socket,"Host: $domain
");
fputs($socket,"Authorization: Basic $pass
");
fputs($socket,"Connection: Close
");
fputs($socket,"
");

// Grab response even if we don't do anything with it.
while (!feof($socket)) {
  $response = fgets($socket,4096);
  if ($debug) echo $response;
}

fclose($socket);

?>