Page 21 of 27 FirstFirst ... 111920212223 ... LastLast
Results 201 to 210 of 261

Thread: AO - Max security for a connected world

  1. #201
    Senior Member JPnyc's Avatar
    Join Date
    Jan 2005
    Posts
    2,734
    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.

  2. #202
    THE Bastard Sys***** dinowuff's Avatar
    Join Date
    Jun 2003
    Location
    Third planet from the Sun
    Posts
    1,253
    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:5B8:41:56:C5:63:56:88:C0

  3. #203
    THE Bastard Sys***** dinowuff's Avatar
    Join Date
    Jun 2003
    Location
    Third planet from the Sun
    Posts
    1,253
    OK WTF IS UP WITH THE FORMATING OF POSTS - OR LACK THERE OF
    09:F9:11:02:9D:74:E3:5B8:41:56:C5:63:56:88:C0

  4. #204
    Senior Member phernandez's Avatar
    Join Date
    Aug 2003
    Location
    NYC
    Posts
    246
    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?

  5. #205
    Senior Member phernandez's Avatar
    Join Date
    Aug 2003
    Location
    NYC
    Posts
    246
    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

  6. #206
    Senior Member JPnyc's Avatar
    Join Date
    Jan 2005
    Posts
    2,734
    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.

  7. #207
    Senior Member JPnyc's Avatar
    Join Date
    Jan 2005
    Posts
    2,734
    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?

  8. #208
    Senior Member phernandez's Avatar
    Join Date
    Aug 2003
    Location
    NYC
    Posts
    246
    Nevermind, wall o' text, bad joke... Carry on.

  9. #209
    T̙͓̞̣̯ͦͭͅͅȂͧͭͧ̏̈͏̖̖Z̿ ͆̎̄
    Join Date
    Dec 2004
    Posts
    3,171
    Dino's referring to the lack of formatting when you don't allow script ( no script )...

    you have to allow formatting

  10. #210
    Senior Member JPnyc's Avatar
    Join Date
    Jan 2005
    Posts
    2,734
    oh OK. Yeah, all the formatting is done with JavaScript

Similar Threads

  1. Security Policy Model Creation for a Networked World
    By tenzenryu in forum The Security Tutorials Forum
    Replies: 11
    Last Post: November 4th, 2005, 07:10 PM
  2. Apache, PHP, MySQL with basic security settings.
    By nightcat in forum The Security Tutorials Forum
    Replies: 9
    Last Post: May 28th, 2005, 02:47 AM
  3. Basic Unix security tutorial
    By \/IP3R in forum AntiOnline's General Chit Chat
    Replies: 16
    Last Post: March 7th, 2005, 10:25 PM
  4. The weakest security link? You
    By SDK in forum Miscellaneous Security Discussions
    Replies: 4
    Last Post: July 22nd, 2004, 11:05 PM
  5. A Guide to AntiOnline and the world of security.
    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
  •