本文整理汇总了Golang中github.com/protosam/hostcontrol/util.Query函数的典型用法代码示例。如果您正苦于以下问题:Golang Query函数的具体用法?Golang Query怎么用?Golang Query使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了Query函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的Golang代码示例。
示例1: FtpEditUser
func FtpEditUser(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "ftpusers")
if !auth {
return "not_authorized"
}
username := util.Query(ctx, "username")
password := util.Query(ctx, "password")
db, _ := util.MySQL()
defer db.Close()
// check if user owns domain
dstmt, _ := db.Prepare("SELECT * FROM `hostcontrol_ftpusers` WHERE `ftpusername`=? and `system_username`=?")
row1, _ := dstmt.Query(username, hcuser.System_username)
defer dstmt.Close()
if !row1.Next() {
return "user_not_found"
}
// set the password
util.Bash("echo " + util.SHSanitize(password) + " | passwd " + util.SHSanitize(username) + " --stdin")
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:25,代码来源:ftp.go
示例2: MailAddUser
func MailAddUser(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "mail")
if !auth {
return "not_authorized"
}
domain := util.Query(ctx, "domain")
if domain == "" {
return "domain_required"
}
username := util.Query(ctx, "username")
if username == "" {
return "username_required"
}
password := util.Query(ctx, "password")
if password == "" {
return "password_required"
}
email_address := username + "@" + domain
db, _ := util.MySQL()
defer db.Close()
// check if user owns domain
dstmt, _ := db.Prepare("SELECT * FROM `hostcontrol`.`mail_domains` WHERE `domain`=? and `system_username`=?")
row1, _ := dstmt.Query(domain, hcuser.System_username)
defer dstmt.Close()
if !row1.Next() {
return "domain_not_found"
}
// make sure email address does not already exist
estmt, _ := db.Prepare("SELECT * FROM `hostcontrol`.`mail_users` WHERE email=? and domain=?")
row2, _ := estmt.Query(email_address, domain)
defer estmt.Close()
if row2.Next() {
return "email_account_exists"
}
xstmt, _ := db.Prepare("INSERT INTO `hostcontrol`.`mail_users` set `email`=?, `password`=ENCRYPT(?), `domain`=?")
_, err := xstmt.Exec(email_address, password, domain)
xstmt.Close()
if err != nil {
return "failed_to_create_domain"
}
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:51,代码来源:mail.go
示例3: file_editor
func file_editor(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "any")
if !auth {
ctx.Redirect("/", 302)
return ""
}
suser, err := user.Lookup(hcuser.System_username)
if err != nil {
return die(ctx, string(err.Error()))
}
selected_object := path.Clean(util.Query(ctx, "path"))
full_object := path.Clean(suser.HomeDir + "/" + selected_object)
// check ownership...
uid, _ := strconv.Atoi(suser.Uid)
gid, _ := strconv.Atoi(suser.Gid)
if !util.ChkPerms(full_object, uid, gid) {
return die(ctx, "You do not have access to object "+full_object)
}
filecontents := util.Query(ctx, "filecontents")
if filecontents != "" {
filecontents = strings.Replace(filecontents, "\r\n", "\n", -1)
ioutil.WriteFile(full_object, []byte(filecontents), 0644)
}
rawcontents, err := ioutil.ReadFile(full_object)
if err != nil {
return die(ctx, string(err.Error()))
}
content := html.EscapeString(string(rawcontents))
var tpl vision.New
tpl.TemplateFile("template/file-editor.tpl")
tpl.Assign("path_up", path.Dir(selected_object))
tpl.Assign("selected_path", selected_object)
tpl.Assign("current_path", full_object)
tpl.Assign("filedata", content)
tpl.Parse("file-editor")
return header(ctx) + tpl.Out() + footer(ctx)
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:48,代码来源:web.filemanager.go
示例4: MailDeleteDomain
func MailDeleteDomain(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "mail")
if !auth {
return "not_authorized"
}
domain := util.Query(ctx, "domain")
if domain == "" {
return "domain_required"
}
db, _ := util.MySQL()
defer db.Close()
xstmt, _ := db.Prepare("DELETE FROM `hostcontrol`.`mail_domains` WHERE `domain`=? AND `system_username`=?")
_, err := xstmt.Exec(domain, hcuser.System_username)
xstmt.Close()
if err != nil {
return "failed_to_delete_domain"
}
os.RemoveAll("/home/vmail/" + domain)
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:29,代码来源:mail.go
示例5: MailAddDomain
func MailAddDomain(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "mail")
if !auth {
return "not_authorized"
}
domain := util.Query(ctx, "domain")
if domain == "" {
return "domain_required"
}
db, _ := util.MySQL()
defer db.Close()
xstmt, _ := db.Prepare("INSERT INTO `hostcontrol`.`mail_domains` set `domain_id`=NULL, `domain`=?, `system_username`=?")
_, err := xstmt.Exec(domain, hcuser.System_username)
xstmt.Close()
if err != nil {
return "failed_to_create_domain"
}
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:27,代码来源:mail.go
示例6: addtoken
func addtoken(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "any")
if !auth {
ctx.Redirect("/", 302)
return ""
}
description := util.Query(ctx, "description")
token := util.MkToken()
db, _ := util.MySQL()
defer db.Close()
xstmt, _ := db.Prepare("INSERT INTO `hostcontrol`.`hostcontrol_user_tokens` set `token`=?, `hostcontrol_id`=?, `description`=?, token_id=null")
_, err := xstmt.Exec(token, hcuser.Hostcontrol_id, description)
xstmt.Close()
if err != nil {
set_error("Failed to create new token.", ctx)
ctx.Redirect("/settings", 302)
return "Failed to create new token."
}
set_error("Created new token.", ctx)
ctx.Redirect("/settings", 302)
return ""
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:28,代码来源:web.settings.go
示例7: DnsDeleteDomain
func DnsDeleteDomain(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "dns")
if !auth {
return "not_authorized"
}
domain := util.Query(ctx, "domain")
if domain == "" {
return "domain_required"
}
db, _ := util.MySQL()
defer db.Close()
xstmt, _ := db.Prepare("DELETE FROM `hostcontrol`.`domains` where `name`=? and `account`=?")
_, err := xstmt.Exec(domain, hcuser.System_username)
xstmt.Close()
if err != nil {
return "failed_to_delete_domain"
}
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:27,代码来源:dns.go
示例8: SqlDatabasesAdd
func SqlDatabasesAdd(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "databases")
if !auth {
return "not_authorized"
}
db_name := util.Query(ctx, "db_name")
if db_name == "" {
return "db_name_required"
}
db, _ := util.MySQL()
defer db.Close()
// stmt, _ := db.Prepare("CREATE USER [email protected]'%' IDENTIFIED BY ?;")
// _, err := stmt.Exec(hcuser.System_username + "_" + username, password)
db_name = util.LastResortSanitize(db_name)
db_name = string(hcuser.System_username + "_" + db_name)
stmt, err := db.Prepare("create database " + db_name + "")
if err != nil {
return "bad_characters_used "
}
_, err = stmt.Exec()
if err != nil {
return "failed_to_create_database"
}
stmt.Close()
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:33,代码来源:sql.databases.go
示例9: databasegrantdelete
func databasegrantdelete(ctx *macaron.Context) string {
status := API("/api/sql/grants/delete", ctx)
db_user := util.Query(ctx, "db_user")
db_name := util.Query(ctx, "db_name")
if status == "success" {
set_error("Removed "+db_user+" from database "+db_name+"!", ctx)
ctx.Redirect("/databases", 302)
return "Removed " + db_user + " from database " + db_name + "!"
}
set_error("Failed to remove "+db_user+" from database "+db_name+"! Error given: "+status, ctx)
ctx.Redirect("/databases", 302)
return "Failed to remove " + db_user + " from database " + db_name + "! Error given: " + status
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:17,代码来源:web.databases.go
示例10: databasegrantadd
func databasegrantadd(ctx *macaron.Context) string {
status := API("/api/sql/grants/add", ctx)
db_user := util.Query(ctx, "db_user")
db_name := util.Query(ctx, "db_name")
if status == "success" {
set_error("Added "+db_user+" to database "+db_name+" successfully!", ctx)
ctx.Redirect("/databases", 302)
return "Added " + db_user + " to database " + db_name + " successfully!"
}
set_error("Failed to add "+db_user+" to database "+db_name+"! Error given: "+status, ctx)
ctx.Redirect("/databases", 302)
return "Failed to add " + db_user + " to database " + db_name + "! Error given: " + status
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:17,代码来源:web.databases.go
示例11: mailadduser
func mailadduser(ctx *macaron.Context) string {
status := API("/api/mail/users/add", ctx)
username := util.Query(ctx, "username")
domain := util.Query(ctx, "domain")
if status == "success" {
set_error("Added "+username+"@"+domain+" successfully!", ctx)
ctx.Redirect("/mail", 302)
return "did it!"
}
set_error("Failed to add user. Error given: "+status, ctx)
ctx.Redirect("/mail", 302)
return "Failed to add user. Error given: " + status
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:17,代码来源:web.mail.go
示例12: MailEditUser
func MailEditUser(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "mail")
if !auth {
return "not_authorized"
}
email_address := util.Query(ctx, "email")
if email_address == "" {
return "email_required"
}
password := util.Query(ctx, "password")
if email_address == "" {
return "password_required"
}
strsplt := strings.Split(email_address, "@")
if len(strsplt) != 2 {
return "invalid_email"
}
//username := strsplt[0]
domain := strsplt[1]
db, _ := util.MySQL()
defer db.Close()
// check if user owns domain
dstmt, _ := db.Prepare("SELECT * FROM `hostcontrol`.`mail_domains` WHERE `domain`=? and `system_username`=?")
row1, _ := dstmt.Query(domain, hcuser.System_username)
defer dstmt.Close()
if !row1.Next() {
return "domain_not_found"
}
// update serial for domain
ustmt, _ := db.Prepare("UPDATE `hostcontrol`.`mail_users` SET `password`=ENCRYPT(?) WHERE `email`=?")
ustmt.Exec(password, email_address)
ustmt.Close()
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:42,代码来源:mail.go
示例13: SqlGrantsDelete
func SqlGrantsDelete(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "databases")
if !auth {
return "not_authorized"
}
db_name := util.Query(ctx, "db_name")
if db_name == "" {
return "db_name_required"
}
username := util.Query(ctx, "db_user")
if username == "" {
return "username_required"
}
dbowner := strings.Split(db_name, "_")[0]
userowner := strings.Split(username, "_")[0]
if dbowner != hcuser.System_username || userowner != hcuser.System_username {
return "failed_not_yours"
}
db, _ := util.MySQL()
defer db.Close()
db_name = util.LastResortSanitize(db_name)
username = util.LastResortSanitize(username)
_, err := db.Exec("REVOKE ALL ON " + db_name + ".* FROM '" + username + "'@'%';")
if err != nil {
return "failed_to_delete_grant"
}
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:39,代码来源:sql.grants.go
示例14: DeleteWebsite
func DeleteWebsite(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "websites")
if !auth {
return "not_authorized"
}
db, err := util.MySQL()
if err != nil {
return string(err.Error())
}
defer db.Close()
vhost_id := util.Query(ctx, "vhost_id")
stmt, _ := db.Prepare("SELECT * from website_vhosts WHERE vhost_id = ? and system_username=?")
rows, _ := stmt.Query(vhost_id, hcuser.System_username)
stmt.Close()
if rows.Next() {
var vhost_id string
var system_username string
var domain string
var documentroot string
var ipaddr string
var ssl_enabled string
var ssl_certificate string
var ssl_key string
var ssl_ca_certificate string
rows.Scan(&vhost_id, &system_username, &domain, &documentroot, &ipaddr, &ssl_enabled, &ssl_certificate, &ssl_key, &ssl_ca_certificate)
os.RemoveAll("/var/log/httpd/" + hcuser.System_username + "/" + domain + "-error_log")
os.RemoveAll("/var/log/httpd/" + hcuser.System_username + "/" + domain + "-access_log")
os.RemoveAll("/var/log/httpd/" + hcuser.System_username + "/" + domain + "-ssl-error_log")
os.RemoveAll("/var/log/httpd/" + hcuser.System_username + "/" + domain + "-ssl-access_log")
os.RemoveAll("/etc/pki/tls/certs/" + domain + ".crt")
os.RemoveAll("/etc/pki/tls/certs/" + domain + ".ca.crt")
os.RemoveAll("/etc/pki/tls/private/" + domain + ".key")
os.RemoveAll("/etc/httpd/vhosts.d/" + domain + ".conf")
os.RemoveAll("/etc/httpd/vhosts.d/" + domain + ".ssl.conf")
stmt, _ = db.Prepare("delete from website_vhosts where vhost_id=?")
stmt.Exec(vhost_id)
stmt.Close()
} else {
return "domain_not_found"
}
util.Bash("systemctl reload httpd")
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:51,代码来源:web.go
示例15: Deleteuser
func Deleteuser(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "sysusers")
if !auth {
return "not_authorized"
}
username := util.Query(ctx, "username")
if username == "" || username == "root" {
return "username_required"
}
db, _ := util.MySQL()
defer db.Close()
// check if user actually owns child
if !util.ChkPaternity(hcuser.System_username, username) {
return "failed_ownership_check"
}
users := make(map[string]map[string]string)
users = util.Getusers(username, users, db)
for _, subuser := range users {
cleanupuserdata(subuser["system_username"], ctx)
// delete the user and homedir
util.Cmd("userdel", []string{subuser["system_username"], "-f", "-r"})
// remove the user
stmt, _ := db.Prepare("delete from hostcontrol_users where system_username=?")
stmt.Exec(subuser["system_username"])
stmt.Close()
}
cleanupuserdata(username, ctx)
// delete the user and homedir
util.Cmd("userdel", []string{username, "-f", "-r"})
// make sure user was delete
_, lookup_err2 := user.Lookup(username)
if lookup_err2 == nil {
return "failed_to_delete_user"
}
// remove the user
stmt, _ := db.Prepare("delete from hostcontrol_users where system_username=?")
stmt.Exec(username)
stmt.Close()
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:51,代码来源:users.go
示例16: updatesettings
func updatesettings(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "any")
if !auth {
ctx.Redirect("/", 302)
return ""
}
password := util.Query(ctx, "password")
new_password := util.Query(ctx, "new_password")
new_password_verify := util.Query(ctx, "new_password_verify")
if password == "" || new_password == "" || new_password_verify == "" {
set_error("Failed to update settings. Error given: missing a password field", ctx)
ctx.Redirect("/settings", 302)
return ""
}
if new_password != new_password_verify {
set_error("Failed to update settings. Error given: new passwords don't match", ctx)
ctx.Redirect("/settings", 302)
return ""
}
if !chklogin(hcuser.System_username, password) {
set_error("Failed to update settings. Error given: current password incorrect", ctx)
ctx.Redirect("/settings", 302)
return ""
}
chpassword(hcuser.System_username, new_password)
set_error("Settings updated successfully.", ctx)
ctx.Redirect("/settings", 302)
return ""
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:36,代码来源:web.settings.go
示例17: SqlUsersEdit
func SqlUsersEdit(ctx *macaron.Context) string {
hcuser, auth := util.Auth(ctx, "databases")
if !auth {
return "not_authorized"
}
username := util.Query(ctx, "db_user")
password := util.Query(ctx, "password")
owner := strings.Split(username, "_")[0]
if username == "" {
return "db_user_required"
}
if password == "" {
return "password_required"
}
if owner != hcuser.System_username {
return "failed_not_yours"
}
db, _ := util.MySQL()
defer db.Close()
db_user := util.LastResortSanitize(username)
password = util.LastResortSanitize(password)
_, err := db.Exec("SET PASSWORD FOR '" + db_user + "' = PASSWORD('" + password + "');")
if err != nil {
return "bad_characters_used "
}
return "success"
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:36,代码来源:sql.users.go
示例18: maildeletedomain
func maildeletedomain(ctx *macaron.Context) string {
status := API("/api/mail/domain/delete", ctx)
domainname := util.Query(ctx, "domain")
if status == "success" {
set_error("Deleted "+domainname+" successfully!", ctx)
ctx.Redirect("/mail", 302)
return "did it!"
}
set_error("Failed to delete domain. Error given: "+status, ctx)
ctx.Redirect("/mail", 302)
return "Failed to delete domain. Error given: " + status
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:16,代码来源:web.mail.go
示例19: mailedituser
func mailedituser(ctx *macaron.Context) string {
status := API("/api/mail/users/edit", ctx)
email := util.Query(ctx, "email")
if status == "success" {
set_error("Updated "+email+" successfully!", ctx)
ctx.Redirect("/mail", 302)
return "did it!"
}
set_error("Failed to update "+email+". Error given: "+status, ctx)
ctx.Redirect("/mail", 302)
return "Failed to update user. Error given: " + status
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:16,代码来源:web.mail.go
示例20: databaseusersedit
func databaseusersedit(ctx *macaron.Context) string {
status := API("/api/sql/users/edit", ctx)
db_user := util.Query(ctx, "db_user")
if status == "success" {
set_error("Modified "+db_user+" successfully!", ctx)
ctx.Redirect("/databases", 302)
return "Modified " + db_user + " successfully!"
}
set_error("Failed to update "+db_user+"! Error given: "+status, ctx)
ctx.Redirect("/databases", 302)
return "Failed to update " + db_user + "! Error given: " + status
}
开发者ID:protosam,项目名称:hostcontrol,代码行数:16,代码来源:web.databases.go
注:本文中的github.com/protosam/hostcontrol/util.Query函数示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论