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

openElement

> 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
Author
Message
skye View Drop Down
Newbie
Newbie
Avatar

Joined: Jul 29 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: Jul 29 2016 at 6:41pm
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
Skye

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


Joined: May 31 2012
Status: Offline
Points: 5283
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dmit OE Quote  Post ReplyReply Direct Link To This Post Posted: Jul 30 2016 at 9:36am
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.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.078 seconds.