Someone just sent me this link : MPA3 + NaughtyBank
 

http://www.naughtybank.com/no_shaving_update.sql

is this custom code? or is this feature available with the new mpa3?

YARGH! Is that what it looks like?

i dunno... it's interesting to say the least :Oh crap

see sig placed for possible long threaded drama

interesting

holy shit!

So what it says "no_shaving"... I think its great they are not shaving. :thumbsup

:1orglaugh

major sig spot lol

maybe thats the update from MPA2 to MPA3
now without shaving lol

wow that dont look right

Everyone says see sig but anyone even know what those code means?

Hmmm... where is Smokey

So, is that code to prevent shaving?

Some of the field names are very interesting... I wonder if the _r in stuff like uniques_r, sales_r, represents "real"???

signups_paid... now that's a doozy :1orglaugh

I'm not a pro with sql by any stretch of imagination, but without knowing MPA database structure and whatever other mods are done to the script, there's probably no way to decipher that..

script looks like removing all the old colums from the old MPA2 interface which used to show all kinds of fake data like signups and signups shown

no drama
still spot sig

:1orglaugh

nice sig:winkwink:

They didn't buy his sig. :winkwink:

Why would the MPA2 database structure have tables prefixed with "mpa3_" ?

i am just saying that all those vars used in this code heavily remind me of the ones used in MPA2 from screenshots ive seen

you guys are freaking out over nothing...

it says NO shaving update :winkwink:

sig..drama..eek

My sig is so cool that I jerk off to it.

Looks to me like it is removing the shaving tables from mpa3.

But then that's just a wild guess, evidence is inconclusive.

why is shaving there in the first place ?

whats the date this file was uploaded you unix gurus?

Wow...fishy to say the least

it was kind of a "tongue in cheek" comment lol , kind of like a im-not-a-murderer insurance.. well if your not a murderer , what would you need the insurance for :)

Hmmm wonder if either side knows about this thread yet? Also any other MPA3 programs have this?

Oh boy, this thread will get interesting.

Why the hell would anyone have something like that on the server? And in a non-php format that would output to a browser no less?

Hey me too....

I woudl liek to hear soe word from ppl in the know...

Anyway, the only thing is seems to be doing is dropping all of the shaving fields from the database that used to be there from mpa2.

alter table "DROP" means to remove the field from the database. And that's all it's doing over and over and over again except for one spot where it changes a field from active_p to active_ft_p and the next section under that adds a few fields.

So, I can't say for 100% certainty without seeing everything else, but it seems to be removing the shaving module that was installed automatically with mpa2.

active_paid, signup_paid and partner_paid were likely the fields that had the amount paid to the affiliate AFTER a certain amount was shaved. Those fields are now non-existant after being dropped.

(And I'm anti mpa... mostly, mpa2... because of that shaving module, so I have no reason to back them up for anything. It's just how I read the code).

:1orglaugh

mmm... definitely interesting

http://www.toplistblog.com/addurl.php Increase your traffic

why is everything in the code mpa3 if it's from the older version?

mpa2 had a shaving module. mpa3 is a new system, but it uses the old system so no data is lost, or links need to be changed.

Hense, the shaving module needs to be removed.

if this shaving module was from the older one... shouldn't it look like this then ?

Possibly, as I said... I haven't seen all of the code or know exactly how it works, which is why I also said that I can't be absolutely certain... just how it looks.

Now, if mpa3 installs and automatically upgrades the prefix of the database from mpa2 to mpa3 and THEN does all the work on it.... then the code might look as it is now.

And as I said before, I'm not trying to defend them... for all I know, this could be just as bad or even worse than how it looks initially. But for all we know, without seeing more, this could simply be a removal system from old to new.

and you wonder why people hate you?

bump for Naughty Bank

Sonofsam, as you most likely know MPA3 has been out now for about 2 years, following MPA2 ? the two programs are completely separate and MPA3 was written new from scratch.

In the time when we upgraded clients from MPA2 to MPA3 we made sure that ANY possible shaving mechanism would be removed and replaced with the opposite ? an anti shaving feature that would allow us for the most part to easily see if a client added code that could mess with the MPA3 code in any way shape or form.

Trax is right in what he is saying. This was a code that we had to add to remove any shaving that was in the mpa2. So when our old customers upgraded we were removing any module like this using this particular script with the inane name of ?no_shaving_update.sql? ? we have written upgrade scripts that were copying the table structure over to mpa3 database as they are. Should we have named is something else to avoid gfy threads like this?

StuardD ? you seem like a smart guy ? you are right on track and that is exactly what that file did. This file was used to remove anything associated with the old mpa2 shave feature. And the file is mostly in older MPA3 versions where this was a necessity to ensure that all upgrades or new installs were squeaky clean, which they all are. Newer versions will not have this file in it to begin with.

Anyone who understands a little SQL would see that this is what this code is doing, and I believe that having a no shaving was something everyone wanted, not the opposite.

Now, if there are still some conspiracy theorists out there that still want more info on this ? come into my office, let?s have you pick out any random MPA3 client and ask for their permission to review their source code with us. Anyone welcome of course.

Shhh... you'll ruin my GFY reputation with such comments :winkwink:

Are your customer allowed to add custom modules? Or is your code as is?

File is 404 now

So what you're basically saying is that your previous version of this software was helping NaughtyBank shave their affiliates, and now you're making sure to stop this malicious practice, which you created in the first place? :1orglaugh

And thats wrong...Why remove it when theres nothing scary about it as just mentioned?

Fiddy...,.