| Author |
 Topic  |
|
animedj
Junior Member
USA
190 Posts |
 Posted - 29 October 2000 : 01:34:35
|
New version of the Slash add-on. Basically added and admin interface and started to use a new table FORUM_MODS, for future mods to use as well. *note : this mod uses mod commander.
d/l : http://animedj.com/hacks/slash.zip
So now bugs and fixes are welcome ^^;;
----
Johann Reyes
http://animedj.com
Edited by - animedj on 29 October 2000 01:51:39 |
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 29 October 2000 : 01:02:10
|
hmm, I forgot to rename the button to CREATE, but that's the button that you should hit. Fixed in the code. Thanks!
---
Johann Reyes
http://animedj.com |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 29 October 2000 : 01:41:24
|
<=== deleted ===>
It happens to everyone.. <img src=icon_smile.gif border=0 align=middle>
Glad to see you coding mods again....
Edited by - Richard Kinser on 29 October 2000 01:54:28 |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 29 October 2000 : 01:52:06
|
Thanks richard!!, my mistake..
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 29 October 2000 : 01:59:01
|
When you first run <b>slash_admin.asp</b> it says that the database isn't setup. It says you should see a <b>CREATE</b> button if you have an <b>Access</b> database. Well, I have an Access database but I don't get a <b>CREATE</b> button, but I do get a <b>SUBMIT</b> button. Pressing the <b>SUBMIT</b> button created the table, but it might confuse someone the way it's worded.
Edited by - Richard Kinser on 29 October 2000 01:08:06 |
|
|
|
Rigger82
Junior Member
USA
311 Posts |
Posted - 30 October 2000 : 10:32:51
|
I like what you've done with it. More separate where mine was integrated with the main forum code.
Wonder if we can just rewrite the script to do a little of both... update the existing config table with the three fields rather than creating a new table. Id hate to have to see a ton of new tables for each mod that needed to store data.
I'll keep working on it from my end.
BTW Johann, I tried to sign up for your forum on your site but couldnt complete the registration. It keeps saying that marital status is required even after I filled it in. We should combine our efforts and roll them into each other.
---------------------
Mark Christianson
Gulf War Veteran (82nd Airborne Division)
Owner/Operator of www.paratrooper.net
Rigger@paratrooper.net |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 30 October 2000 : 11:11:15
|
Sorry, I just updated all my site from scratch yesterday and finish installing the new version of the forums today, so I haven't checked if it was working ok for the moment yet. It should be fixed now. And about the new table that I created now, I'm trying to for standars in my case, That's why I created the mod commander, and now a new table for mods. All mods that I'll be creating from this point I'll try to use FORUM_MODS whenever I can. From my point of view, if you don't mess up with the main tables, that an A plus, also for example, I'm thinking of making statistics optional in the mod, if I were to use the config table, I would have to create another table, when with the new MOD table i just have to add a new record.
I'll work in another MOD so you can see my point of view.
---
Johann Reyes
http://animedj.com |
|
|
|
Rigger82
Junior Member
USA
311 Posts |
Posted - 30 October 2000 : 11:22:07
|
No need, I totally understand.. .this way, if you upgrade, you dont have to worry about the mods being blown away with a new or upgraded table in subsequent releases. I will move over into this direction as well.
I was thinking of asking the same thing..
1. If you wish to see stats.
2. What colors, fonts they want for the remote
3. Table width, spacing and padding.
4. Button to "generate" code.
That last one is the kicker... you would make all your preferences, then we could make the page show you a code view complete with the proper db path (which we pull from config table) and add all the font and color choices... then the users could cut and paste the code into any given page. All includes and links would be virtual to avoid problems with location.
The other item is the topic info... if your viewing by latest reply then its confusing to see the ORIGINAL date of the topic. Although getting this info is another trip to the db or a long SQL.
Id like to create a Stored Procedure for each "VIEW" and then try to integrate the admin so the dropdown pulled each SP starting with "slash_". This way, we could speed the process a bit with SPs and also, when you added a new VIEW to the db then it would automatically become available via the admin.
What do you think?
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Sorry, I just updated all my site from scratch yesterday and finish installing the new version of the forums today, so I haven't checked if it was working ok for the moment yet. It should be fixed now. And about the new table that I created now, I'm trying to for standars in my case, That's why I created the mod commander, and now a new table for mods. All mods that I'll be creating from this point I'll try to use FORUM_MODS whenever I can. From my point of view, if you don't mess up with the main tables, that an A plus, also for example, I'm thinking of making statistics optional in the mod, if I were to use the config table, I would have to create another table, when with the new MOD table i just have to add a new record.
I'll work in another MOD so you can see my point of view.
---
Johann Reyes
http://animedj.com
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
---------------------
Mark Christianson
Gulf War Veteran (82nd Airborne Division)
Owner/Operator of www.paratrooper.net
Rigger@paratrooper.net |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 October 2000 : 11:26:09
|
I tend to agree with animedj, it is better from a coding point of view to keep as much of the Mod seperate from the Snitzcode as possible, it makes integration with new code much easier.
I have adopted his mod commander as well, it is a useful tool for keeping track of your mods.
I added acouple of other things to your mod file animedj
mine looks like this, what do you think
File Attachments - name of mod
admin_fileattachment.asp - admin file for mod
false - readme file present
setup_attachment.asp - DB setup script
1.00 - version
Huwr - Author
Doing it this way should make installation of the mods easier for Newbies, All you need to do is issue a mod file, they can then extract the files and just go to the Admin screen to set it up.
I think we should all try and adopt it as a way forward.
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 October 2000 : 11:28:07
|
One question, what is the format of your FORUM_MOD file and what are you actually putting in it ?
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 30 October 2000 : 12:00:37
|
okay, MOD commander has been updated to include the 2 new fields (setup script link and author), the order is a little different Huwr, so it won't mess up with other MODS out at the moment.
And about the FORUM_MODS it works like this. the table is 3 fields (M_NAME, M_CODE, M_VALUE) and for example let's take slash mod.
I want to store the preference of how many posts to show so I'll add the following values in the table:
under M_NAME : slash (mod name)
under M_CODE : slPosts (name of the value)
under M_VALUE : 5 (value)
and I keep adding as many recordsets as my slash mod needs, then to retrieve the values I use in this case dictionary object like this :
with a SQL query I get all the M_CODE and M_VALUE where the M_NAME is slash and the with my dictionary object (objDict) i load up the values :
while not objRec.EOF
objDict.Add objRec.Fields.Item("m_code").Value, objRec.Fields.Item("m_value").Value
objRec.moveNext
wend
slPosts = cint(objDict.Item("slPosts"))
slLength = cint(objDict.Item("slLength"))
slSort = objDict.Item("slSort")
and that's basically it. and I can keep adding values to that table without touch the other tables. I hope that helps.
---
Johann Reyes
http://animedj.com |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 30 October 2000 : 12:19:04
|
yep, see stats it's an easy modification, but the another stuff, it would really be pretty complicated. In my case I would prefer to stay away from that stuff as it is HTML formatting and that something pretty baisc that any webmaster knows at least. About the views and stored procedures it's a good idea, and it can be added, but then it''ll be better to make another version (an SQL version) as it would need a new setup, and really, i don't think many users has access to a SQL server, and it would mean extra code to go throught if it is made in one version altogether.
---
Johann Reyes
http://animedj.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 30 October 2000 : 12:28:56
|
Cool, that ties in pretty nicely with the Table I have been using, should be able to adjust.
Any chance you could send me the latest code, I am just finishing off my file upload stuff, and would like to use the latest Mod commander for the admin.
I think we should try to get everyone who writes Mods to adopt this if they can
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
animedj
Junior Member
USA
190 Posts |
|
|
webshorts
New Member
USA
96 Posts |
Posted - 31 October 2000 : 14:29:53
|
Today is just not my day. I installed everything just as the read me says, I've got the mod commander installed, but anything I update the slash_admin.asp, I still just get 0 posts. It's mot updating my FORUM_MODS table in SQL 7.
You just need to include in your instructions for non-access databases, for them to create the three entries into the FORUM_MOD table.
Daniel Short
Chief Designer,
Web Shorts Site Design
Free DHTML at DHTMLShock.com
JavaScript and DHTML forum, powered by Snitz
Edited by - webshorts on 31 October 2000 14:39:10 |
|
|
|
animedj
Junior Member
USA
190 Posts |
Posted - 31 October 2000 : 14:49:59
|
Sorry webshorts. Bug mistake by my part. Forgot to populate the table with the defult values when it's not an access database. it should be fixed now. Now, if you already created the table you just need to hit the button create and the table would be populated with the new defaults. Sorry, but as I don't have access to an SQL DB i can't really test it against that. It's now fixed in the zip.
---
Johann Reyes
http://animedj.com |
|
|
|
Topic |
|
Topic Locked
