Run Query?

[Brad]

This is the query:

[sql]INSERT INTO datastore (title, data) VALUES ('todaymaxonline', 'a:2:{s:14:\"todaymaxonline\";i:1;s:18:\"todaymaxo nlinedate\";i:1070000000;}')[/sql]

Note that if you use table prefixes, you will have to make sure the table name is correct (in this case 'datastore' is our table name). So if my table prefix is vb3_, then the query would need to be changed to:

[sql]INSERT INTO vb3_datastore (title, data) VALUES ('todaymaxonline', 'a:2:{s:14:\"todaymaxonline\";i:1;s:18:\"todaymaxo nlinedate\";i:1070000000;}')[/sql]

Don't know your table prefix or if you are even using one? You can find out what it is by looking at config.php at this line:

PHP Code:

// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = 'vb3_'; 


[Tipi]

This is what I found in config.php:

PHP Code:

// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = ''; 


So I guess I'm not using table prefix, then.

*hurries back to run query*

Thanks Brad.loo!

[Brad]

Originally Posted by Tipi

This is what I found in config.php:

PHP Code:

// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = ''; 


So I guess I'm not using table prefix, then.

*hurries back to run query*

Thanks Brad.loo!

Correct, the query should run fine without modification

[Tipi]

Almost doen, only have one more thing to do.

******************************
NOW CREATE THE FOLLOWING PHRASES:
******************************
last_online_at_x / Last online at {1}
******************************
active_users_today / Number of Active Users Today
******************************
most_users_ever / Most users ever online on a day was {1} on {2}.
******************************
already_visited_today / The following members have already visited the forums today
******************************

Where do i create theese phrases?

And one more thing, the PHPfile, onlinetoday.php, where does that go? :ermm:

[Colin F]

I assume the onlinetoday.php file should go in the root directory of your forum.

You can add phrases by going to your:

Admin CP > Languages & Phrases > Phrase Manager > Add New Phrase

[Brad]

Most likely onlinetoday.php would be uploaded to the forum directory, or the same directory that your showthread.php file is in.

You add phrases via your admin cp, in the navigation frame find 'Languages & Phrases', click on 'Phrase Manager'.

A new page will open up, at the bottom there should be a button labled 'add phrase', click it.

This will bring you to the a new screen, add the phrases like this:

Varname: last_online_at_x
Text: Last online at {1}

[Tipi]

Ah, of course! *blush* But the phrases comes up as Not allowed, 'cause it's duplicates. Example: There is already a phrase named 'last_online_at_x'. You may not create duplicate names.

[Brad]

That means it is already added to the database, did you run some sort of installer script with that hack?

Try adding the rest of the phrases by hand, if they all return that error then just skip that step of the instructions.

[Tipi]

Wooha! I did it! Thank you so much for all help! :banana: