+
−% GETUSERID gets the user ID number corresponding to the given user name.
+
−%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
+
−%
+
−% DESCRIPTION: GETUSERID gets the user ID number corresponding to the
+
−%              user name that connected to the MySQL database.
+
−%
+
−% CALL:        userid = getUserID(conn)
+
−%
+
−% VERSION:     $Id: getUserID.m,v 1.3 2010/01/22 12:46:08 ingo Exp $
+
−%
+
−% HISTORY:     24-05-2007 M Hewitson
+
−%                 Creation
+
−%
+
−%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
+
−
+
−function [userid,dbuser] = getUserID(conn, username)
+
−
+
−  error('### Obsolete as of LTPDA version 2.2. Replaced my the utils class jmysql (utils.jmysql.%s)', mfilename());
+
−
+
−  userid = [];
+
−  try
+
−    q    = sprintf('select id from users where username="%s"', conn.Username);
+
−    curs = exec(conn, q);
+
−    curs = fetch(curs);
+
−    userid = curs.Data{1};
+
−    close(curs);
+
−  catch curs
+
−    warning('!!! Unable to retrieve user ID. [Server returned: %s]', curs.message);
+
−  end
+
−
+
−end
+
−