[Uberguilds]

Display order update, sorting productIDs in vb3_cartplog_products:

if [ $# -ne 2 ]; then
	echo "Usage: $0 <first product ID to swap> <second product ID to swap>"
	echo "Example:  $0 5 10"
	exit 0
fi

echo "Enter MySQL password for user $(whoami): "
stty -echo
read PW
stty echo
echo ""

mysql -u"****DATABASEUSER****" -p"$PW" ****VBULLETINDATABASE**** -e "UPDATE vb3_cartplog_products SET productid=10000 WHERE productid=$1; UPDATE vb3_cartplog_products SET productid=$1 WHERE productid=$2; UPDATE vb3_cartplog_products SET productid=$2 WHERE productid=10000;"

echo "Swap completed, Visit SocialPDX.com."

THEN, run this query.

ALTER TABLE vb3_cartplog_products ORDER BY productid