| Author |
 Topic  |
|
animedj
Junior Member
USA
190 Posts |
|
|
Renaud Clarke
Starting Member
United Kingdom
5 Posts |
 Posted - 01 November 2000 : 06:07:21
|
I have downloaded this zip file, but unless I've really missed something?? I don't seem to have a form which works with the backup.asp?
Can you help?
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 November 2000 : 06:36:36
|
There has been changes to the forum code since this Archiver was released.
What version of the forum are you using?
If you are using the latest version then changing the following code may work.
In <b><font color=red>backup.asp</font id=red></b>
On <b><font color=red>line #40</font id=red></b>
replace this code:
<pre id=code><font face=courier size=2 id=code> <% if ChkUser2(Request.cookies("user")("Name"), Request.cookies("user")("Pword")) <> 4 then %></font id=code></pre id=code>
with this code:
<pre id=code><font face=courier size=2 id=code> <% if ChkUser2(strDBNTUserName, Request.Cookies(strCookieURL & "User")("Pword")) <> 4 then %></font id=code></pre id=code>
<b><font color=red>And then on Line # 22 add this code:</font id=red></b>
<pre id=code><font face=courier size=2 id=code> strDBNTUserName = Request.Cookies(strCookieURL & "User")("Name")
strDBNTFUserName = Request.Form("Name")
if strAuthType = "nt" then
strDBNTUserName = Session(strCookieURL & "userID")
strDBNTFUserName = Session(strCookieURL & "userID")
end if</font id=code></pre id=code>
<b><font color=red>Right after this code:</font id=red></b>
<pre id=code><font face=courier size=2 id=code> if not isEmpty(request.form("action")) then
daysOld = DateToStr(DateAdd("d", -(request.form("days")), strForumTimeAdjust))
end if</font id=code></pre id=code>
Edited by - Richard Kinser on 01 November 2000 06:56:49 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 01 November 2000 : 06:56:38
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
2.- that might be a more difficult task,as the TOPICS and REPLIES tables uses autonumber as Topic_ID and Reply_ID. Once deleted from the original table, the only way (correct me if I'm wrong) would be to add them again using an INSERT and taht would completely changes their TOPIC AND REPLY ID. It's not impossible to do this... but it would take a lot of work ^^; for that reason I would just make a mod only if there is a lot of people interested in this, or another idea would be just to make a mod to see the backup DB, that I guess it's the same amount of work either way.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I don't know wether this is possible in Access, but in SQl you can do the following
SET IDENTITY_INSERT forum_topics ON;
INSERT INTO forum_topics (topic_id,.....) VALUES(3, ......)
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 November 2000 : 07:14:38
|
And if you have the Mod Commander installed you can save the following code as <b><font color=red>backup.mod</font id=red></b>
<pre id=code><font face=courier size=2 id=code>Snitz Archiver
..\backup.asp
true
1.00
<a href="mailto:webmaster@animedj.com">animedj</a></font id=code></pre id=code>
(you can just copy and paste the above code into an empty text file and save it as: <b><font color=red>backup.mod</font id=red></b>
You would then place <b>backup.mod</b> and <b>backup.txt</b> into your <b>/forum/mods</b> directory, and the <b>backup.asp</b> and <b>backup_sql.asp</b> would go into your <b>/forum</b> directory.
That way you can just run it from the Mod Commander. |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 01 November 2000 : 10:00:05
|
I'll start to work in a new updated version for the archiver this weekend. So request and modifications are welcome before I'll start the coding.
---
Johann Reyes
http://animedj.com |
|
|
|
blkrogue
New Member
USA
79 Posts |
Posted - 01 November 2000 : 11:01:26
|
Hmmm, still would like to be able to update an entire topic/forum so the structure could be kept intact, but that's just my opinion.
Just would love to be able to transport old topics to a backup database which you can just keep on running as an archive kind off thingie (just like Mike did with the old messages of this forum) .......... but maybe it should just be devided into seperate options :
1. making a copy of your forum_ids
2. moving topics to the backup database, making it operate like a stand alone snitz-forum database which you can just use as the 'read old messages here' archive.
Blkrogue
In the darkness of my soul a sparkling light has appeared |
|
|
|
Renaud Clarke
Starting Member
United Kingdom
5 Posts |
Posted - 01 November 2000 : 11:46:58
|
How do I tell which version I have?
And
If I've got the wrong version how will I update this version?
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 November 2000 : 18:50:05
|
If you look in the readme.txt file that came with Snitz Forums 2000, it will say what the version # is.
If you have v3.1 final or later, the version # is listed in <b>Admin Options</b> --> <b>Main Forum Configuration</b> just look for the line that says <b>Version info</b>. |
|
|
|
Renaud Clarke
Starting Member
United Kingdom
5 Posts |
Posted - 03 November 2000 : 07:43:17
|
I have version 3.1 final. Does this mean I have to upgrade in order to use the Backup.asp?
P.S - I am getting a bit urgent here as I have 20 pages of topics every week. Archiver would be dead handy....
Thanks for your help..
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 November 2000 : 07:55:34
|
| yes, you would need to make the modifications noted above. |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 03 November 2000 : 08:14:13
|
animedj,
I have an idea that may work, not sure haven't tried it.
In the archive DB, make sure the ID field is not an auto field, so when archived the topics etc retain their original ID.
Put a check in topic.asp which checks if the Topic exist, if it doesn't, change the strConnstring and see if it's in the archive, if it is, fetch the data fom the archive.
Obviously, you would have to change it back to post the reply ?
Don't know wether this is feasible or not.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
Renaud Clarke
Starting Member
United Kingdom
5 Posts |
Posted - 04 November 2000 : 10:41:15
|
you know when you think you've done cracked it? well so did I...
sadly the backup.asp gave me this error:
ARCHIVER for Snitz Forums
moving topic and replies from TOPIC ID 3 ...
error '80020009'
Exception occurred.
/forum/inc_functions.asp, line 367
any ideas?
|
|
|
|
Renaud Clarke
Starting Member
United Kingdom
5 Posts |
Posted - 04 November 2000 : 10:42:14
|
p.s. I can provide you with my username and password if you think it would be faster?..
|
|
|
|
nerina
Starting Member
25 Posts |
Posted - 07 November 2000 : 10:28:15
|
I'm very interested in the archiving script that Joahnn has done; I would like to save subjects, topics, replies, forum, date and name of the member.
After that I would try to convert the new backup access.mdb in a text file that everyone could download.
Do you think that it will be possible? (the original dbase is now, after less than one month, 1.5 M and I fear that it shall became so big that people shall have to wait hours in order to read/write in it...)
Thank you very much,
Nerina |
|
|
|
Topic |
|
Topic Locked
