BullGuard Antivirus Sale - 60% Off with openElement !
Forum openElement Homepage
Forum Home Forum Home >


> Dynamic OE - Databases, etc
  New Posts New Posts RSS Feed - get&use datas from SQlite db
  FAQ FAQ  Forum Search   Register Register  Login Login

get&use datas from SQlite db

 Post Reply Post Reply
skye View Drop Down

Joined: 29 Juil 2016
Location: Hungary
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote skye Quote  Post ReplyReply Direct Link To This Post Topic: get&use datas from SQlite db
    Posted: 29 Juil 2016 at 19:41
Hi there!

I made a website with OE and use the Userspace01 pack (with SQLite db). Tongue
The website's idea is to control users with restricted access by topics not with access levels.
I modified database by sqlitebrowser and append six plus TEXT type field (for like boolean type) for these topics control.

My problem is the following:
- firstly how could I check and get the actual logged in user's oeid (without pack70) from oe_logv1_users table ?
- secondly how could I write and connect a DB field state with pack60 state (I use on every page to show user's login state) ?
- and finally how could I modify pack80 to should control this new method ?

Thanks a lot! Thumbs Up

Have you ever looked closely a dragon's eye ?
Back to Top
Dmit OE View Drop Down
Admin Group
Admin Group

Joined: 31 Mai 2012
Status: Offline
Points: 5281
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dmit OE Quote  Post ReplyReply Direct Link To This Post Posted: 30 Juil 2016 at 10:36

To get the connected user's ID, use the value in


You can then write your own queries to read or modify data. I don't know what you want to do exactly, so I can't help you further.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10.11
Copyright ©2001-2012 Web Wiz Ltd.

This page was generated in 0,031 seconds.