AO - Max security for a connected world

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.

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.

OK WTF IS UP WITH THE FORMATING OF POSTS - OR LACK THERE OF

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?

Quote:

---

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 :)

Quote:

---

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.

Quote:

---

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?

Nevermind, wall o' text, bad joke... Carry on.

Dino's referring to the lack of formatting when you don't allow script ( no script )...

you have to allow formatting :D

oh OK. Yeah, all the formatting is done with JavaScript