get&use datas from SQlite db |
Post Reply |
Author | |
skye
Newbie Joined: Jul 29 2016 Location: Hungary Status: Offline Points: 3 |
Post Options
Thanks(0)
Posted: Jul 29 2016 at 6:41pm |
Hi there!
I made a website with OE and use the Userspace01 pack (with SQLite db). 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! Skye |
|
Have you ever looked closely a dragon's eye ?
|
|
Dmit OE
Admin Group Joined: May 31 2012 Status: Offline Points: 5283 |
Post Options
Thanks(0)
|
Hi,
To get the connected user's ID, use the value in $_SESSION['oelog01_UserID'] 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. |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |