temars-eve-api icon indicating copy to clipboard operation
temars-eve-api copied to clipboard

Jabber Plugin -- Inserting Username into Database

Open drkthunder02 opened this issue 10 years ago • 0 comments

When calling the function to add a user to Jabber the following source is not passing the correct variable. When the function is passing the variable, it only passes the Teamspeak formatted name as the username instead of the Jabber formatted username. I have isolated the function being called, just not the callee of the function. I could not get the function to use the UserService plugin for various reasons, which I think is because jabber isn't located in my /var/www/html directory, but is located elsewhere on the server.

Server Hardware: Dell PowerEdge R610 Ram: 8 GB HD: 500 GB OS: Ubuntu 14.04 LTS (64 bit)

File Location: /Sources/TEA_Jabber_OF.php

function add_user($uname, $pw, $name, $email, $groups) { $secret = $this -> modSettings['tea_jabber_secret']; $groups = implode(",", $groups); $uname = str_replace("'", "", $uname); $uname = str_replace(" ", "", $uname); $name = str_replace("'", "", $name); $name = str_replace(" ", "", $name);

    //$url = $this -> modSettings['tea_jabber_admin_url'].'/plugins/userService/userservice?type=add&secret='.$secret.'&username='.$uname.'&password='.$pw.'&name='.$name.'&email='.$email.'&groups='.$groups;
    //$url = str_replace(" ", "%20", $url);
    //$site = $this -> get_site($url);
    //return;
    $this -> db_connect();
    $check = $this -> select("SELECT username from ofUser WHERE username = '".mysql_real_escape_string($name)."'");
    if(!empty($check))
    {
        return("UserName Exists already");
    }
    $this -> query("INSERT INTO ofUser (username, plainPassword, email, creationDate, modificationDate) VALUES ('".mysql_real_escape_string($name)."', '".mysql_real_escape_string($pw)."', '".mysql_real_escape_string($email)."', ".time().", 0)");
}

To replicate this issue, comment out the lines in the file I have listed above, then add a new user into Jabber. When viewing the database for the Jabber service itself, the username is shown as the Teamspeak username rather than the Jabber username. I can be reached at [email protected] if you have any further questions.

drkthunder02 avatar Oct 16 '15 03:10 drkthunder02