var shell = require('shelljs');
var mysql = require('mysql');
var request = require("request");




var mysqlInfo;
mysqlInfo = {
	host     : 'localhost',
	user     : '*****',
	password : '*********',
	database : '*********',
	charset  : 'utf8_general_ci'
};
var mysqlConnection = mysql.createConnection(mysqlInfo);

setTimeout(checkOffers,600000);


function checkOffers(){

mysqlConnection.query('SELECT * FROM `ordertoproceed` WHERE `status`=\'2\'', function(err, row, fields) {
	if(err) {
				return;
			}
	detected = false;
	if(detected == true) {
				return;
			}

	detected = true;
	for(var i=0; i < row.length; i++) {
		var realid = row[i].realid;
		var email = row[i].realemail;
		var activity = row[i].activity;
		var domain = row[i].domain;
		var folder = randomInt(15003, 321545623434);

		shell.cd('root/nodejs')
		shell.virtualhost create domain folder
		shell.bash test.sh

		mysqlConnection.query('UPDATE `ordertoproceed` SET `status`=\'5\' WHERE `realid`=\''+realid+'\'', function(err, row, fields) {});
	}




}
}

function randomInt (low, high) {
    return Math.floor(Math.random() * (high - low) + low);
}