| Author |
|
MrGibbage
Super User
Joined: October 23 2006
Location: United States
Online Status: Offline
Posts: 513
|
| Posted: May 29 2012 at 18:42 | IP Logged
|
|
|
Is there a way I could get all global variables and their current values? I am
thinking about doing this from an app connecting to the PowerHome Socket server.
Probably a direct sql statement??? And while we are at it, how about getting a list
of all macros?
__________________
Skip
|
| Back to Top |
|
| |
JaredM
Newbie
Joined: November 04 2007
Online Status: Offline
Posts: 36
|
| Posted: May 30 2012 at 00:05 | IP Logged
|
|
|
Try this. It'll give you back CRLF-separated rows with TAB-separated columns. There are a few other delimiter optons too...1=commas, 2=XML, 3=HTML.
Code:
| ph_sql(0, "SELECT id, value FROM global_variables") |
|
|
Also
Code:
| ph_sql(0, "SELECT id, key_desc FROM macroheader") |
|
|
|
| Back to Top |
|
| |
MrGibbage
Super User
Joined: October 23 2006
Location: United States
Online Status: Offline
Posts: 513
|
| Posted: May 30 2012 at 05:55 | IP Logged
|
|
|
That should do it. Thanks :)
__________________
Skip
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome Programming
Topic: Get ALL global variables
