[urgent] Most Ever Online: how i change or reset it?

[MentaL]

so how do i edit it then i just want to edit the figure to say 100 or even delete it, which table is it in ? thanks.

[Andreas]

Originally Posted by KirbyDE

For vB2 it should be this record:

[SQL]
SELECT * FROM template WHERE title='maxloggedin';
[/SQL]

[assassingod]

Try this:
[sql]
UPDATE template SET template = '' WHERE templateid = '485';
[/sql]

It deletes the current record and date.

[MentaL]

thanks worked!

[assassingod]

Np.

[Brad]

Really? I though this was just a SELECT and would not modifiy anything ...

You are correct a SELECT only pulls data, there is no way to modify it with a select query.

In this case you must run a UPDATE to reset this, because there is no admin option to do so.

[Andreas]

Originally Posted by Brad.loo

You are correct a SELECT only pulls data, there is no way to modify it with a select query.

In this case you must run a UPDATE to reset this, because there is no admin option to do so.

I know that a SELECT only pulls the data

As he didn't say which value he wanted to have this was just meant to be used in phpMyAdmin. It would select the record so he would only have to click edit afterwards ...

[MentaL]

Originally Posted by KirbyDE

I know that a SELECT only pulls the data

As he didn't say which value he wanted to have this was just meant to be used in phpMyAdmin. It would select the record so he would only have to click edit afterwards ...

which i did and thanks