#!/usr/bin/php -q
<?php
/* PHPList Processed E-mail Counter
* Author: Sterling Hamilton
* Date: 10.08.2008
*
* Use from the command line.
* Example default use: # php PHPListCounter.php
* -> This will count all processed e-mails in the current month for each database.
*/

$strMailAddress = "billing@exyst.com";
$strSubject = "Monthly PHPList Report";
$strMessage = "";

@$cnMain = mysql_connect("localhost", "admin", "MQNIV8OW";
if (!$cnMain) {
die("\033[31mCould not connect\033[0m: ".mysql_error()."\n";
}

$strQuery = "SHOW DATABASES";
$aryDatabases = mysql_query($strQuery);

$strLastMonthEnd = mktime(0, 0, 0, date('m'), 0, date("Y");
$strLastMonthEnd = date('Y-m-d', $strLastMonthEnd);

$aryTemp = explode(" ",$strLastMonthEnd);
$aryDate = explode("-",$aryTemp[0]);

if($aryDate[1] == 12)
{
$strLastMonthEnd = mktime(0, 0, 0, date("m", 0, date("Y" - 1);
$strLastMonthEnd = date('Y-m-d', $strLastMonthEnd);
}

$strLastMonthStart = mktime(0, 0, 0, date('m') - 1, 1, date("Y");
$strLastMonthStart = date('Y-m-d', $strLastMonthStart);

$aryTemp = explode(" ",$strLastMonthStart);
$aryDate = explode("-",$aryTemp[0]);

if($aryDate[1] == 12)
{
$strLastMonthStart = mktime(0, 0, 0, date("m" - 1, 1, date("Y" - 1);
$strLastMonthStart = date('Y-m-d', $strLastMonthStart);
}

$strQuery = "SELECT processed FROM `phplist_message` WHERE embargo BETWEEN '$strLastMonthStart' AND '$strLastMonthEnd'";

while ($rowDB = mysql_fetch_assoc($aryDatabases)) {
$dbCurrent = mysql_select_db($rowDB["Database"],$cnMain);
$intCounter = 0;
$aryCount = mysql_query($strQuery);
if($aryCount)
{
while ($rowCount = mysql_fetch_assoc($aryCount)) {
$intCounter += ($rowCount["processed"] > 0) ? $rowCount["processed"]: 0;
}
if($intCounter > 0) {
$strMessage .= "[$intCounter] E-mails for Database: [".$rowDB["Database"]."]\n";
}
}
}

$strHeader = "From: Automated Script <esupport@exyst.com>\r";

$strMessage = "This is an automated message.\nBelow is a list of all PHPList e-mails that went out for ".date("F",mktime(0,0,0, date("m", 0, date("Y"))."\n\n".$strMessage;

mail($strMailAddress, $strSubject, $strMessage, $strHeader);

mysql_close($cnMain);
?>

!/bin/bash
#
# Example usage:
# echo ${RedF}This text will be red!${Reset}
# echo ${BlueF}{$BoldOn}This will be blue and bold!${BoldOff} - and this is just blue!${Reset}
# echo ${RedB}${BlackF}This has a red background and black font!${Reset}and everything after the reset is normal text!

Colors() {
Escape="\033";

BlackF="${Escape}[30m"; RedF="${Escape}[31m"; GreenF="${Escape}[32m";
YellowF="${Escape}[33m"; BlueF="${Escape}[34m"; Purplef="${Escape}[35m";
CyanF="${Escape}[36m"; WhiteF="${Escape}[37m";

BlackB="${Escape}[40m"; RedB="${Escape}[41m"; GreenB="${Escape}[42m";
YellowB="${Escape}[43m"; BlueB="${Escape}[44m"; PurpleB="${Escape}[45m";
CyanB="${Escape}[46m"; WhiteB="${Escape}[47m";

BoldOn="${Escape}[1m"; BoldOff="${Escape}[22m";
ItalicsOn="${Escape}[3m"; ItalicsOff="${Escape}[23m";
UnderlineOn="${Escape}[4m"; UnderlineOff="${Escape}[24m";
BlinkOn="${Escape}[5m"; BlinkOff="${Escape}[25m";
InvertOn="${Escape}[7m"; InvertOff="${Escape}[27m";

Reset="${Escape}[0m";
}

cd /var/www/vhosts/mysite.com
mkdir data
chown myuser:psaserv data

<Directory /var/www/vhosts/mysite.com/httpdocs/>
php_admin_value open_basedir "/var/www/vhosts/mysite.com/httpdocs:/tmp:/var/www/vhosts/mysite.com/data"
</Directory>

/usr/local/psa/admin/sbin/websrvmng -u --vhost-name=mysite.com

#!/bin/bash

# Login information.
USERNAME=“email address”
PASSWORD=“password”
URL=http://twitter.com/statuses/update.xml

# Check message length.
if [ ! -n “$1” ]; then
echo “Message not long enough”
exit
fi

# Check message length again.
message=”$@”
maxlen=140;
len=`echo $`

if [ $len -gt $maxlen ]; then
echo “Your message was longer than 140 characters…”;
fi

# Post to Twitter.
result=`curl -u $USERNAME:$PASSWORD -d status=”$message” $URL`

user@computername:~$ twitter Your Message Here

RewriteEngine on
RewriteCond %{HTTP_HOST} ^sterlinghamilton.com
RewriteRule (.*) http://www.sterlinghamilton.com/$1 [R=301,L]

RewriteCond %{HTTP_HOST} ^sterlinghamilton.net
RewriteRule (.*) http://www.sterlinghamilton.com/$1 [R=301,L]

RewriteCond %{HTTP_HOST} ^www.sterlinghamilton.net
RewriteRule (.*) http://www.sterlinghamilton.com/$1 [R=301,L]

locate "/payment/cc_basia.php" > BadFiles

#!/bin/sh
echo "enter file name"
read fname exec<$fname
while read line
do
echo "rm $";
rm $
done

sh DeleteFiles.sh
enter file name
BadFiles

grep '.'\ /etc/virtualhosting/mappings/domainmap | awk '{print $1}'

egrep 'Server(Name|Alias)' /var/www/vhosts/*/conf/httpd.include|awk '{print $3}'|grep -v www.*|grep - '^.*\..*\..*$'|sed 's/:80//'|sed 's/:443//'|sort -u

#!/bin/bash

SiteList=`egrep 'Server(Name)' /var/www/vhosts/*/conf/httpd.include|awk '{print $3}'|grep -v www.*|grep -v '^.*\..*\..*$'|sed 's/:80//'|sed 's/:443//'|sort -u`;

for Site in $SiteList
do
Result=`/usr/local/psa/bin/domain -i $Site | grep 'Mail service' | awk '{print $3}'`;
if [ $Result == On ]; then
Command=`/usr/local/psa/bin/domain -u $Site -mail_service false`
echo "Turning Off Mail Service: $Site";
fi
done

#!/bin/bash

# Get the e-mail ready.
Email="esupport@exyst.com";
Subject="Xync: Account(s) Exceeding Quota(s)."
Message="/tmp/message.txt"
# This starts the message fresh.
echo "Summary:" > $Message

# Generate data about all mail boxes.
MailBoxQuotaData=`/opt/zimbra/bin/zmprov gqu localhost`;

# Set counters.
Counter=0;
AccountCounter=0

# Sort through the data.
for Line in $MailBoxQuotaData
do
Counter=`expr $Counter + 1`;
case "$Counter" in
"1" )
Account=$Line
;;
"2" )
Limit=$Line
;;
"3" )
Used=$Line
# If the limit is 0 then it has no limit.
if [ "$Limit" -ne "0" ]; then
# This produces a whole number we can work with.
Percent=$(($Used*100/$Limit))
# Notify us if a limit is over 85%.
if [ "$Percent" -ge "85" ]; then
echo "Account: $Account" >> $Message
echo "Quota Percentage: $Percent" >> $Message
AccountCounter=`expr $AccountCounter + 1`
fi
fi
Counter=0
;;
esac
done

# Send Twitter message.
nice -n 19 /exyst/Twitter.sh "Xync: ${AccountCounter} Accounts Over 85%!"
# Send e=mail.
nice -n 19 /bin/mail -s "$Subject" "$Email" < $Message