Author |
Topic |
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 18 February 2001 : 21:11:45
|
Drop down page selector isnt working.
Also, I was not able to delete individual posts out of the archive.
The mass delete functions work fine.
I like the new
http://www.dunzellsden.com/forum/ |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 18 February 2001 : 21:15:06
|
I'm debating with myself whether to put in a single delete function...
You archive topics because you want to keep them, but they are taking up space, you delete a couple months of archived topics because they are reeeeeeeeeeeeaaally old and no one reads them anymore... but why single delete? I would figure if you didnt want a topic in the forum, you'd delete it not archive it.
I'm still debating with myself, I probably will, unless Huwr beats me to it. I'm just curious as to what reasoning is.
---- Da_Stimulator Snitz Forums Dev Team Member http://stimmy.cfm-resources.com/forum - my testing forums. |
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 18 February 2001 : 21:21:52
|
I agree, the only reason I mentioned the single delete was that the delete and edit icon is there in each topic for the archive.
I figured if its there it was for a reason.
http://www.dunzellsden.com/forum/ |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 February 2001 : 21:25:37
|
to fix the drop down issue temporarily, change the
call paging2() to call paging()
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 18 February 2001 : 22:51:11
|
Oh ok, I hadnt realized I left the icons there. my apologies, I though I'd removed them.
---- Da_Stimulator Snitz Forums Dev Team Member http://stimmy.cfm-resources.com/forum - my testing forums. |
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
Therion93
Junior Member
USA
263 Posts |
Posted - 20 February 2001 : 00:23:51
|
Is the zip file current? Just curious before I download.
Therion93 Because Legends Never Die! - Kiss-Forever.Net Mysteries & Magic - Mysteria Magicka |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 February 2001 : 04:34:29
|
yes it is the current version
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 20 February 2001 : 15:54:39
|
Got a Question... Not being a Coder and stuff figured I'd ask.
How hard or how difficult would it to be for this mod to archive to a different database? I'm just wondering if it could do so that it would take the load off the main db and shrink in down in size.
No sure if possible but figured I'd ask.
Rick
Test Site www.eastpasco.com Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 20 February 2001 : 16:01:47
|
it would not be difficult, but it would make the viewing of them more difficult,, since it would involve different connections for the two db's.
Also under SQL this would be irrelevant since you are normally only given one db, and it is not the size of the db that affects performance, but the number of records in the table you are selecting.
Since most people will generally be reading the non archived tables, you should see a definate performance improvement depending how many records you have.
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 21 February 2001 : 18:04:04
|
found a small bug in the archiving. it is not deleting all the replies correctly, and causing duplicates in the archive table if you run another archive.
I think I have fixed it, but will post the code when I have finished testing it. Just thought I would let everyone know.
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 22 February 2001 : 19:02:30
|
quote:
Archiving now fully working. If you are using an access DB with the Jet 4 drivers, then you will also have a compact DB option in admin_forums. I have also included a tweaked version of animedj's down.asp, since you need to shut down the forum to do a compact on it.
Have tested and works OK.
The compacting stuff could do with a few little tweaks, but it is functional enough to use succesfully. It first checks to see if it can make a copy of your db, if this fails then the compacting is not allowed.
Compacting is fairly quick a 65Mb DB took only a few minutes.
Huwr did some updates. Re-Downloading is NOT necassary, unless you have VERY large database, all thats added is database compacting.
------- Da_Stimulator Snitz Forums Dev Team Member Snitz Test Center Need a Mod? |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 22 February 2001 : 19:29:39
|
forgot one thing right at the very top if inc_top just below the
line starting Dim mLev you need to insert
if Application("down") then if not Instr(request.servervariables("script_name"),"admin_") > 0 then Response.redirect("down.asp") end if end if
------- Da_Stimulator Snitz Forums Dev Team Member Snitz Test Center Need a Mod? |
|
|
Topic |
|