The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Database fields
Hiya
Anyone know what the database table names are and what the fields are? Anyone have a list of this anywhere? I just want to know which field contains the true/false value for the board being on/offline. Thanks Adam |
#2
|
|||
|
|||
That is stored in 2 tables: setting & datastore
|
#3
|
|||
|
|||
basically, there is a "setting" table that store "officially" the settings you set on the adminCP... but in the essence, these settings are stored in the cache called "datastore", so they are loaded quicly at the startup of the process... they can also be stored in the datastore_file if you decide to store them in file... (complicated part)...
even if you edit the "setting" table with your proper detail, the board will continue to read the datastore element only, so you have to enter your admincp and save a setting to make the update. |
#4
|
|||
|
|||
I'm new to PHP, so how would I update the datastore database? Does anyone have a little example of updating a table?
And do you know what the field name for the Turn On/Off setting would be? Thanks Adam |
#5
|
|||
|
|||
|
#6
|
|||
|
|||
Hi
After lots of trial and error, I finally hacked together some code that turned the board off/on. Looking at the link you sent me, the code looks a lot cleaner then the one I put together last night. But all i'm just getting an error: Parse error: parse error, unexpected T_STRING in myfile.php on line 3 This is the code I'm now trying to use, if you want a laugh the code I hacked together is below that. PHP Code:
PHP Code:
|
#7
|
|||
|
|||
Is that the full myfile.php?
PS Why do you use sprintf() to assign a variable? |
#8
|
|||
|
|||
Yup, thats the full file at the moment.
The reason I use sprintf() is becuase it seemed to work last night on the code I use. I'm not a PHP developer and this is the first time I've ever had to use PHP. I'm a Coldfusion and Actionscript 2 developer... so this is all foreign to me at the moment. So any help is grantful!! |
#9
|
|||
|
|||
Could you please copy&paste the full error message, as i don't see a line 3 in your code.
|
#10
|
|||
|
|||
This is line 3:
$query1 = sprintf("UPDATE datastore SET data=REPLACE(data,'"bbactive";i:0;','"bbactive";i: 1;') WHERE title='options'"); PHP Code:
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|