Snitz Forums 2000 - Active users record was set lower ?

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: MOD Implementation

Active users record was set lower ?

New Topic

Printer Friendly

Author

Topic

volkerc
Junior Member

Germany
159 Posts

Posted - 09 January 2013 : 10:49:42

Hi everybody,

I'm kinda without words. The active users record was set to a lower figure (way lower) without doing anything to the software. Any ideas how to fix this and get the old record back? Why did this happen?

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 09 January 2013 : 13:38:32

You can't get it back, but you can change it either through direct edit of the database value or through a quick dbs script.

Snitz 3.4 Readme | Like the support? Support Snitz too

Carefree
Advanced Member

Philippines
4222 Posts

Posted - 09 January 2013 : 13:46:32

That's the value of the "intAURecord" variable read from the "config_new" table. It would be easy to write a routine to modify it, but not sure why someone would have done so.

Here's how you'd do it, just change the first value in red to the quantity it used to have. Change the next value to the date when the record was set, using the format: YYYYMMDDHHMMSS. Then save the file in the forum folder with whatever name you'd like (e.g., "reset_au.asp") and run it.


<!--#INCLUDE FILE="config.asp" -->
<!--#INCLUDE FILE="inc_header.asp" -->
<%
intAURec=0
strAUDt="20130110085300"
my_Conn.Execute("UPDATE " & strTablePrefix & "CONFIG_NEW SET C_VALUE='" & intAURec & "' WHERE C_VARIABLE = 'intAURecord'")
my_Conn.Execute("UPDATE " & strTablePrefix & "CONFIG_NEW SET C_VALUE='" & strAUDt & "' WHERE C_VARIABLE = 'strAURecordDate'")
Response.Write	"<center>Updated!  Don't forget to remove this file....</center>" & vbNewLine & _
	"      <meta http-equiv=""Refresh"" content=""4; URL=""default.asp"">" & vbNewLine
WriteFooter
%>

Edited by - Carefree on 09 January 2013 20:01:59

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 09 January 2013 : 14:18:23

and then remove the file after you have run it

MVC .net dev/test site | MVC .net running on Raspberry Pi

volkerc
Junior Member

Germany
159 Posts

Posted - 09 January 2013 : 15:50:04

thanks all for the quick response guys. but which file do i need to dig into to change it? cause it changed the record and the date! ? and isn't it supposed to store the highest record and only overwrite it once the record is higher? could it be cause of the year change?

volkerc
Junior Member

Germany
159 Posts

Posted - 09 January 2013 : 18:10:16

in what file is the record and date stored?

Carefree
Advanced Member

Philippines
4222 Posts

Posted - 09 January 2013 : 20:06:25

quote:
which file do i need to dig into to change it?

You don't have to "dig into" any files in order to change it. Read my response above, follow the directions, the problem will be fixed.

quote:
...cause it changed the record and the date!

You didn't mention the date before, so I modified my reply above to fix that too.

quote:
...isn't it supposed to store the highest record and only overwrite it once the record is higher?

That is how it's supposed to work; only being changed upon a new record being set.

quote:
could it be cause of the year change?

quote:
in what file is the record and date stored?

Again, read my response above. It's not stored in any "file", it's stored in a table in the database.

Edited by - Carefree on 09 January 2013 20:07:36

volkerc
Junior Member

Germany
159 Posts

Posted - 10 January 2013 : 02:41:20

Thank you carefree.

However, before you edited your response, I copied and pasted it, and loaded a file to the forum as you said, but nothing had changed. So I must be doing something wrong.

Carefree
Advanced Member

Philippines
4222 Posts

Posted - 10 January 2013 : 04:29:28

If it isn't an internal web site, post a link for us to see. The software I wrote will work, 100%.

volkerc
Junior Member

Germany
159 Posts

Posted - 10 January 2013 : 06:05:56

I'm not questioning your software.

Like I said, I might habe made a mistake. I named the file reset_au.asp
and loaded it through the ftp to the forum. I had changed the record to the number before, but nothing happened. Does it have to be a separate file or should I add what you wrote to an existing file?

Carefree
Advanced Member

Philippines
4222 Posts

Posted - 10 January 2013 : 07:32:30

No, it shouldn't be added to another file. You won't SEE anything happen in the first version, but it will work. Check your active user record number, it should be corrected ... UNLESS your case is like that one from earlier this week when the forum data wasn't being displayed at all.

volkerc
Junior Member

Germany
159 Posts

Posted - 10 January 2013 : 12:32:27

I have copied the above, added it as a new file to the software, let it just sit there, no changes. nothing seems to happen.

Carefree
Advanced Member

Philippines
4222 Posts

Posted - 10 January 2013 : 16:17:20

OK - you saved the file? Then you just have to run it in the address bar. If your site address is "http://mysite.com/forum", you should type "http://mysite.com/forum/reset_au.asp" and hit enter. This is not very difficult.

volkerc
Junior Member

Germany
159 Posts

Posted - 10 January 2013 : 16:42:35

DOH! Didn't run it. Now I did. The don't forget to remove this file came up, but no immediate change to the record.

volkerc
Junior Member

Germany
159 Posts

Posted - 10 January 2013 : 18:36:08

It updated now! :-) Thanks so much Carefree! My hero!

Carefree
Advanced Member

Philippines
4222 Posts

Posted - 10 January 2013 : 18:44:54

You're welcome, glad we could help. Don't forget to remove that file from your forum directory if you haven't already done so.

Topic

New Topic

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.31 seconds.