SELECT u.id AS userId, d.id AS deviceId FROM users u, devices d WHERE u.admin=1 UNION SELECT ud.users_id AS userId, ud.devices_id AS deviceId FROM users_devices ud INNER JOIN users u ON ud.users_id=u.id WHERE u.admin=0 AND u.readOnly=0
TRACCAR GPSGATE UPDATE
UPDATE users SET hashedPassword = :hashedPassword, salt = :salt WHERE id = :id UPDATE users SET name = :name, email = :email, admin = :admin, map = :map, distanceUnit = :distanceUnit, speedUnit = :speedUnit, latitude = :latitude, longitude = :longitude, zoom = :zoom, twelveHourFormat = :twelveHourFormat WHERE id = :id INSERT INTO users (name, email, hashedPassword, salt, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat) VALUES name, :email, :hashedPassword, :salt, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat) SELECT id, login AS name, email, readOnly AS readonly, admin FROM users SELECT * FROM users WHERE email = :email UPDATE server SET registration = :registration, readonly = :readonly, map = :map, bingKey = :bingKey, mapUrl = :mapUrl, distanceUnit = :distanceUnit, speedUnit = :speedUnit, latitude = :latitude, longitude = :longitude, zoom = :zoom, twelveHourFormat = :twelveHourFormat WHERE id = :id Jdbc:h2:C:\Program Files (x86)\Traccar\data\databaseĬ:\Program Files (x86)\Traccar\data\changelog-master.xml Hi i have edited the xml config file in my gps tracking software called traccar, after that service unable to start.Ĭ:\Program Files (x86)\Traccar\traccar-web.warĬ:\Program Files (x86)\Traccar\logs\tracker-server.log
0 kommentar(er)
