| Author |
 Topic  |
|
|
Dan Martin
Average Member
USA
528 Posts |
 Posted - 13 August 2001 : 20:44:28
|
Admin: View Database
Author: Dan Martin
Ease of Installation (1-Hard, 10-Easy): 2
Download: http://www.councilofgrey.com/mods/adminDBmod.zip
DEMO: Sorry, screen shots are going to have to be good enough for this one(note, the pictures are erased in spots on purpose to hide data):
http://www.councilofgrey.com/temp/dbmod.jpg
http://www.councilofgrey.com/temp/dbmod2.jpg
This MOD is an additional admin page that allows admins to look at your entire forum database or perform ad-hoc SQL queries on your forum database. If you are unfamiliar with SQL, you can still use this MOD to look at your database.
This MOD doesn't care what is in your database. It will work no matter how many tables or fields you have added (the fields and tables are not coded into the ASP). This mod is for anyone who wants to avoid downloading the forum database just to troubleshoot.
Why this MOD is a beta:
-Only tested on Snitz 3.3. I cannot guarantee that it will work on other versions of Snitz. I beleive it will, but I don't know for sure
-Only tested with MS Access. I don't think it will work with any other databases. Again, I really don't know for sure.
To install:
Copy admin_database.asp to /forum, or your main forum directory.
On your admin_home.asp, Appx line 88
After this:
<LI><a href="admin_mod_dbsetup.asp">MOD Setup</a></LI>
Add this:
<LI><a href="admin_database.asp">View Forum Database</a></LI>
If you try this with other databases, or in Snitz versions other than 3.3, please post how it turns out. If you notice any bugs please post. If you just like it, please post. If you don't like it, please don't post. Oh heck, post anyway.
Thanks,
Dan |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 13 August 2001 : 21:15:11
|
hey dan, have you ever seen TableEditor? It is a must have for remote database support. I use this thing all the time on my snitz database:
http://www.2enetworx.com/dev/projects/tableeditor.asp
this is in no way to shoot down your hard work......
Dayve |
 |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 13 August 2001 : 21:18:35
|
I use TableEditor all the time to view the data and even make changes. That is such a great tool and with options to add, delete, modify fields, tables run queries and works with any database and so on.
Share A Square at forumSquare
GauravBhabu
There is only one miracle...That is LIFE! |
|
|
|
Dan Martin
Average Member
USA
528 Posts |
Posted - 13 August 2001 : 22:05:21
|
No, that's the first I've ever heard of it.
Edited by - Dan Martin on 13 August 2001 22:43:43 |
|
|
|
Dan Martin
Average Member
USA
528 Posts |
Posted - 15 August 2001 : 10:50:15
|
I have downloaded and used TableEditor. It is very nice and has more functionality than I probably will ever have time to add to this mod.
However, I still think there is benefit to the above mod.
For 1, it is linked into the forum. It shares its security and navigation features.
For 2, it is much easier for most people to set up. TableEditor requires some work and development experience to set up. It took me a while to figure out how to get it to work, and I think I'm more advanced in this area than alot of people.
Well, I've pleaded my case. I'll shut up now.
-Dan |
|
|
|
tilttek
Junior Member
Canada
333 Posts |
Posted - 15 August 2001 : 12:15:25
|
quote:
I have downloaded and used TableEditor. It is very nice and has more functionality than I probably will ever have time to add to this mod.
However, I still think there is benefit to the above mod.
For 1, it is linked into the forum. It shares its security and navigation features.
For 2, it is much easier for most people to set up. TableEditor requires some work and development experience to set up. It took me a while to figure out how to get it to work, and I think I'm more advanced in this area than alot of people.
Well, I've pleaded my case. I'll shut up now.
-Dan
Did someting VERY similar...
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=6791
Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 15 August 2001 : 19:36:20
|
Table Editor ROCKS! I've used, tested and ran this on Access and SQL all day..
quote:
hey dan, have you ever seen TableEditor? It is a must have for remote database support. I use this thing all the time on my snitz database:
http://www.2enetworx.com/dev/projects/tableeditor.asp
this is in no way to shoot down your hard work......
Dayve
Test Site:
http://www.eastpasco.com running on Huw's Code 3.3.09 SQL 2000 |
|
|
|
Dan Martin
Average Member
USA
528 Posts |
Posted - 16 August 2001 : 15:27:12
|
Any admins that could create a "TableEditor Rocks!" topic and move these messages there?
-Dan |
|
|
|
liqu1d
Starting Member
Greece
47 Posts |
Posted - 16 August 2001 : 17:36:34
|
Hi
where can I find table editor?
liqu1d magic |
|
|
|
Spoon
Average Member
Ireland
507 Posts |
Posted - 16 August 2001 : 17:46:29
|
quote:
Hi
where can I find table editor?
liqu1d magic
http://www.2enetworx.com/dev/projects/tableeditor.asp
Regards - Spoon
Begineer? Need help installing the forums? - www.aslickpage.com/snitz_help.html
www.ASlickPage.com - Private Messaging |
|
|
| |
Topic |
|
Topic Locked
