public function INSERT($username, $password)
{
if (mssql_num_rows(mssql_query("SELECT * FROM [user] WHERE username='******'")) == 0) {
$insertQuery = "INSERT INTO\r\n\t\t\t\t[dbo].[user]\r\n\t\t\t\t(\r\n\t\t\t\t\tusername,\r\n\t\t\t\t\tpassword,\r\n\t\t\t\t\tinsert_userID,\r\n\t\t\t\t\tinsert_datetime\r\n\t\t\t\t)VALUES(\r\n\t\t\t\t\t'" . convert::fromUTF($name) . "',\r\n\t\t\t\t\t'{$password}',\r\n\t\t\t\t\t'" . $_COOKIE['id'] . "',\r\n\t\t\t\t\t'" . date('Y-d-m H:i:s', time()) . "'\r\n\t\t\t\t)";
mssql_query($insertQuery);
} else {
echo "username is taken";
}
}
public function UPDATE($id, $name, $login, $password, $owner)
{
$updateQuery = "UPDATE \r\n\t\t\t\t[dbo].[registrator]\r\n\t\t\tSET \r\n\t\t\t\tname = '" . convert::fromUTF($name) . "',\r\n\t\t\t\tupdate_userID \t= '" . $_COOKIE['id'] . "',\r\n\t\t\t\tupdate_datetime = '" . date('m-d-Y H:i:s', time()) . "',\r\n\t\t\t\tlogin = '******',\r\n\t\t\t\tpassword = '******',\r\n\t\t\t\towner = '{$owner}'\r\n\t\t\tWHERE \r\n\t\t\t\tid={$id}\r\n\t\t\t;";
mssql_query($updateQuery);
}
public function UPDATE($id, $name)
{
$updateQuery = "UPDATE \r\n\t\t\t\t[dbo].[manager]\r\n\t\t\tSET \r\n\t\t\t\tname \t\t\t= '" . convert::fromUTF($name) . "',\r\n\t\t\t\tupdate_userID \t= '" . $_COOKIE['id'] . "',\r\n\t\t\t\tupdate_datetime = '" . date('m-d-Y H:i:s', time()) . "'\r\n\t\t\tWHERE \r\n\t\t\t\tid={$id}\r\n\t\t\t;";
mssql_query($updateQuery);
}
public function UPDATE($id, $name, $adminPanelLink, $login, $password, $emailID, $ip, $phpMyAdminLink, $NS1, $NS2, $NS3, $NS4)
{
echo $updateQuery = "UPDATE \r\n\t\t\t\t[dbo].[hosting]\r\n\t\t\tSET \r\n\t\t\t\tname \t\t\t= '" . convert::fromUTF($name) . "',\r\n\t\t\t\tupdate_userID \t= '" . $_COOKIE['id'] . "',\r\n\t\t\t\tupdate_datetime = '" . date('m-d-Y H:i:s', time()) . "',\r\n\t\t\t\t\r\n\t\t\t\tadminPanelLink = '{$adminPanelLink}',\r\n\t\t\t\tlogin = '******', password = '******', emailID = {$emailID},\r\n\t\t\t\tip = '{$ip}', phpMyAdminLink = '{$phpMyAdminLink}',\r\n\t\t\t\tNS1 = '{$NS1}', NS2 = '{$NS2}', NS3 = '{$NS3}', NS4 = '{$NS4}'\r\n\t\t\tWHERE \r\n\t\t\t\tid={$id}\r\n\t\t\t;";
mssql_query($updateQuery);
}
public function UPDATE($id, $name, $hostingID, $managerID, $registratorID)
{
$updateQuery = "UPDATE \r\n\t\t\t\t[dbo].[site]\r\n\t\t\tSET \r\n\t\t\t\tname \t\t\t= '" . convert::fromUTF($name) . "',\r\n\t\t\t\thostingID\t\t= {$hostingID},\r\n\t\t\t\tmanagerID\t\t= {$managerID},\r\n\t\t\t\tregistratorID\t= {$registratorID},\r\n\t\t\t\tupdate_userID \t= '" . $_COOKIE['id'] . "',\r\n\t\t\t\tupdate_datetime = '" . date('m-d-Y H:i:s', time()) . "'\r\n\t\t\tWHERE \r\n\t\t\t\tid={$id}\r\n\t\t\t;";
mssql_query($updateQuery);
}
public function UPDATE($id, $name, $description, $deadlineDate, $giver_userID, $doer_userID, $priorityID, $statusID, $siteID)
{
$updateQuery = "UPDATE \r\n\t\t\t\t[dbo].[task]\r\n\t\t\tSET \r\n\t\t\t\tname \t\t\t= '" . convert::fromUTF($name) . "',\r\n\t\t\t\tdescription\t\t= '" . convert::fromUTF($description) . "', \r\n\t\t\t\tdeadlineDate\t= '" . str_replace("T", " ", $deadlineDate) . "', \r\n\t\t\t\tgiver_userID\t= {$giver_userID},\r\n\t\t\t\tdoer_userID\t\t= {$doer_userID},\r\n\t\t\t\tpriorityID\t\t= '{$priorityID}', \r\n\t\t\t\tstatusID\t\t= '{$statusID}', \r\n\t\t\t\tsiteID\t\t\t= {$siteID},\r\n\t\t\t\tupdate_userID \t= '" . $_COOKIE['id'] . "',\r\n\t\t\t\tupdate_datetime = '" . date('m-d-Y H:i:s', time()) . "'\r\n\t\t\tWHERE \r\n\t\t\t\tid={$id}\r\n\t\t\t;";
mssql_query($updateQuery);
}
