UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Chaging the "max online" number and date

Hello. I was hoping someone might help me.

I wish to change the number shown on the site for the "max online" number along with the date but am having trouble working out how to do that. (The number there now is too large due to some attack on our forums and so I want to reduce it back to what it was which was more realistic).

Can anyone point me in the right direction?

Thank you very much.

The data is stored in the table named cache
max_online field just change to what you want
max_online_timestamp field Not sure what format is used to change the date

Thanks for that,.,... but I need a bit more hand-holding.... how/where do I do that?

okay it is one of the tables in the MYSQL database you setup to use for your forum.
You probably have phpmyadmin as a management tool from your host provider.
Using phpmyadmin open your database select the ubbt_cache table on the left side
I assume you used the default ubbt_ prefix.
Select the browse link at the top left.
Here you see the data.
Select the pencil icon to the left of max_online to edit that value.
change the cache_value number to what you want.
Then select the save option and then the go button.

You would do the same for the date but like I said I don't know what format it is in.

go to your Admin Control Panel, Database Tools, SQL Command


paste that into the textarea and execute it.. that will reset you to 0 and a recalculation will ensue

note: this assumes your table prefix is 'ubbt_' -- change it as appropriate for your forums

Thank you SirDude.

In the same way, how do I change the date to say, 30th November 2008?

Much appreciated.

well, since you set it to 0, it's going to compute to a new date at a point when you have at least ONE person online..

are you saying you want to fix the date to a specific value? if so, why ?

don't you want it to be a true value that counts up from here on out?

:shrug:

but if you really want to force the issue, go to your Admin Control Panel, Database Tools, SQL Command


paste that into the textarea and execute it.. that will set the date to 11/30/2008 (unixtime) and a recalculation will ensue

Thanks

With the above line I got this

Line#: 101
SQL Error: Unknown column 'max_onlinetimestamp' in 'field list'
SQL Error #: 1054
Query: UPDATE ubbt_CACHE SET max_onlinetimestamp=1228003200;

the field name is
max_online_timestamp
not
max_onlinetimestamp

Thanks. Unfortunately I got the same

Line#: 101
SQL Error: Unknown column 'max_online_timestamp' in 'field list'
SQL Error #: 1054
Query: UPDATE ubbt_CACHE SET max_online_timestamp=1228003200;

Any ideas?
thanks

what version of threads you using? max_online_timestamp is what i have for it..

I just looked it is 7.3

Thanks

Anyone any idea?

Thanks

If you still have not resolved this try opening the table as I suggested and set it manually Like I stated before.
Not knowing that version you have maybe it has a slightly different name.

and i STILL don't know why setting a specific date is even desired..

if you set it to ZERO (the amount), then both fields will be recalculated as soon as ONE person logs in.. that will be the NEW high..

:shrug:

agree, why skew actual stats?

OK then I tried

UPDATE ubbt_CACHE SET max_online=0;

and I get this message:

Script: ..../dodbcommand.php
Line#: 101
SQL Error: Unknown column 'max_online' in 'field list'
SQL Error #: 1054
Query: UPDATE ubbt_CACHE SET max_online=0;



Thanks

It's not actually a field name, rather a value:

ah yes, of course...

/me hangs head in shame for SQL syntax gag.... :sniff: