-
March 18th, 2008, 08:46 PM
#201
If it requires an alteration to the database, it won't happen. If an additional rating, beyond that of reputation, is added, the value of it will need to be kept somewhere. That means adding a field to a table, that won't happen.
We are not about to repeat the mistakes that led up to this bloodbath of an upgrade, nor are we about to run outdated software for five years again. It was the alterations to the old database that caused every upgrade script to fail, and why this upgrade, just the actual live database dump and import itself, took 48 straight hours as well as weeks of preparation prior to that.
I've alerted the editors to the question, that's the best I can do. I'm sure they'll be along to answer shortly.
-
March 18th, 2008, 09:56 PM
#202
Actually JP you don't have to modify existing tables. You would have to add tables; however, upgrades would not be an issue. Lets say that the current DB has a table tblRepPoints that has UserID FieldID and RepCount Now your view selects from tblRepPoints among all the other tables Add a second table called tblAORepPoints Same fields and names as the default but add any needed fields needed for calculating Rep Strength. Write a sp that syncs data between both rep tables and does what ever math needed to determine how many points should be given. say a tut forum is 10 and a GCC forum is 2 if rep added to post in forum 10 then fully approve = 10; fully disagree = -10 if rep added to post in forum 2 then fully approve = 0; fully disagree = 0 pseudocode at its worst but you get the picture. Trick is what ever value is derived THAT value is inserted into the original tblRepPoints table. So when the upgrade comes along the only thing that has to be checked is if there is any change to the tblRepPoints table. If so modify the sp_AORep to incorporate the new table changes. And if you forget. No biggie. You'll have pissed off users that say their reps are off, but that can be fixed. If you want, I'll write a prof of concept. , but you'll have to use your test/dev system to test.
09:F9:11:02:9D:74:E3:5B 8:41:56:C5:63:56:88:C0
-
March 18th, 2008, 09:56 PM
#203
OK WTF IS UP WITH THE FORMATING OF POSTS - OR LACK THERE OF
09:F9:11:02:9D:74:E3:5B 8:41:56:C5:63:56:88:C0
-
March 18th, 2008, 10:12 PM
#204
To address the tutorials.
$50 is an incentive versus free; most forums don't even offer that. The vetting process is to make sure we spotlight quality, well-written tutorials here and on EIT. Given the activity on this site, chances are that a submitting a good tutorial will end up being featured.
We appreciate the constructive criticism, but could JP be right? Is it really the lack of tweaks or widgets that's holding the community back?
-
March 18th, 2008, 10:18 PM
#205
Originally Posted by dinowuff
OK WTF IS UP WITH THE FORMATING OF POSTS - OR LACK THERE OF
I'll grant you that one, I just posted fine. Thanks for your input above, now if we can get it in a format we can read
-
March 18th, 2008, 10:55 PM
#206
Originally Posted by dinowuff
Actually JP you don't have to modify existing tables. You would have to add tables; however, upgrades would not be an issue. Lets say that the current DB has a table tblRepPoints that has UserID FieldID and RepCount Now your view selects from tblRepPoints among all the other tables Add a second table called tblAORepPoints Same fields and names as the default but add any needed fields needed for calculating Rep Strength. Write a sp that syncs data between both rep tables and does what ever math needed to determine how many points should be given. say a tut forum is 10 and a GCC forum is 2 if rep added to post in forum 10 then fully approve = 10; fully disagree = -10 if rep added to post in forum 2 then fully approve = 0; fully disagree = 0 pseudocode at its worst but you get the picture. Trick is what ever value is derived THAT value is inserted into the original tblRepPoints table. So when the upgrade comes along the only thing that has to be checked is if there is any change to the tblRepPoints table. If so modify the sp_AORep to incorporate the new table changes. And if you forget. No biggie. You'll have pissed off users that say their reps are off, but that can be fixed. If you want, I'll write a prof of concept. , but you'll have to use your test/dev system to test.
There's no way we'd ever get approval or developer time for something this trivial. If it involves altering the DB in any way, it ain't happening. And let's not pretend it's not trivial, it is. It's all about accolades, just like rep pts are. It's not like it would be difficult to know who wrote what tutes.
-
March 18th, 2008, 10:55 PM
#207
Originally Posted by phernandez
To address the tutorials.
$50 is an incentive versus free; most forums don't even offer that. The vetting process is to make sure we spotlight quality, well-written tutorials here and on EIT. Given the activity on this site, chances are that a submitting a good tutorial will end up being featured.
We appreciate the constructive criticism, but could JP be right? Is it really the lack of tweaks or widgets that's holding the community back?
I don't understand. What formatting is missing?
-
March 18th, 2008, 10:58 PM
#208
Nevermind, wall o' text, bad joke... Carry on.
-
March 18th, 2008, 11:26 PM
#209
Dino's referring to the lack of formatting when you don't allow script ( no script )...
you have to allow formatting
-
March 19th, 2008, 01:47 AM
#210
oh OK. Yeah, all the formatting is done with JavaScript
Similar Threads
-
By tenzenryu in forum The Security Tutorials Forum
Replies: 11
Last Post: November 4th, 2005, 07:10 PM
-
By nightcat in forum The Security Tutorials Forum
Replies: 9
Last Post: May 28th, 2005, 02:47 AM
-
By \/IP3R in forum AntiOnline's General Chit Chat
Replies: 16
Last Post: March 7th, 2005, 10:25 PM
-
By SDK in forum Miscellaneous Security Discussions
Replies: 4
Last Post: July 22nd, 2004, 11:05 PM
-
By Ennis in forum AntiOnline's General Chit Chat
Replies: 5
Last Post: December 27th, 2003, 05:28 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|