Someone just sent me this link : MPA3 + NaughtyBank - GoFuckYourself.com

sonofsam · 04-22-2006, 01:18 PM

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

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

Chio The Pirate · 04-22-2006, 01:19 PM

YARGH! Is that what it looks like?

sonofsam · 04-22-2006, 01:20 PM

Quote:

Originally Posted by Chio The Pirate

YARGH! Is that what it looks like?

i dunno... it's interesting to say the least

MrIzzz · 04-22-2006, 01:21 PM

see sig placed for possible long threaded drama

DateDoc · 04-22-2006, 01:25 PM

interesting

Manowar · 04-22-2006, 01:27 PM

holy shit!

xlogger · 04-22-2006, 01:28 PM

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

polish_aristocrat · 04-22-2006, 01:29 PM

Trax · 04-22-2006, 01:32 PM

major sig spot lol

Trax · 04-22-2006, 01:33 PM

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

xclusive · 04-22-2006, 01:35 PM

wow that dont look right

xlogger · 04-22-2006, 01:35 PM

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

TheSenator · 04-22-2006, 01:36 PM

Hmmm... where is Smokey

TheSenator · 04-22-2006, 01:37 PM

So, is that code to prevent shaving?

fuzebox · 04-22-2006, 01:39 PM

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

Jakke PNG · 04-22-2006, 01:39 PM

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..

Trax · 04-22-2006, 01:45 PM

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

woj · 04-22-2006, 01:49 PM

QuaWee · 04-22-2006, 01:51 PM

Quote:

Originally Posted by TheSenator

So, is that code to prevent shaving?

nice sig

DamageX · 04-22-2006, 01:51 PM

Quote:

Originally Posted by TheSenator

Hmmm... where is Smokey

They didn't buy his sig.

fuzebox · 04-22-2006, 01:54 PM

Quote:

Originally Posted by Trax

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

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

Trax · 04-22-2006, 01:56 PM

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

SmokeyTheBear · 04-22-2006, 02:00 PM

you guys are freaking out over nothing...

it says NO shaving update

xLaborJames · 04-22-2006, 02:05 PM

sig..drama..eek

TheSenator · 04-22-2006, 02:05 PM

Quote:

Originally Posted by QuaWee

nice sig

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

fuzebox · 04-22-2006, 02:10 PM

Quote:

Originally Posted by SmokeyTheBear

you guys are freaking out over nothing...

it says NO shaving update

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

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

Manowar · 04-22-2006, 02:52 PM

Quote:

Originally Posted by SmokeyTheBear

you guys are freaking out over nothing...

it says NO shaving update

why is shaving there in the first place ?

Theo · 04-22-2006, 02:58 PM

whats the date this file was uploaded you unix gurus?

Lace · 04-22-2006, 03:12 PM

Wow...fishy to say the least

SmokeyTheBear · 04-22-2006, 03:24 PM

Quote:

Originally Posted by Manowar

why is shaving there in the first place ?

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

xclusive · 04-22-2006, 03:28 PM

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

Shoehorn! · 04-22-2006, 03:33 PM

Oh boy, this thread will get interesting.

StuartD · 04-22-2006, 03:36 PM

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?

RevSand · 04-22-2006, 03:37 PM

Quote:

Originally Posted by TheSenator

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

Hey me too....

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

StuartD · 04-22-2006, 03:41 PM

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

Anna_O · 04-22-2006, 03:52 PM

Quote:

Originally Posted by woj

Radiate · 04-22-2006, 04:12 PM

mmm... definitely interesting

elitetec · 04-22-2006, 04:16 PM

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

sonofsam · 04-22-2006, 04:31 PM

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

StuartD · 04-22-2006, 04:34 PM

Quote:

Originally Posted by sonofsam

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.

sonofsam · 04-22-2006, 04:37 PM

Quote:

Originally Posted by StuartD

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.

Quote:

ALTER TABLE `mpa3_active_referral_stats` DROP `uniques_r` ,
DROP `signups_r` ;

ALTER TABLE `mpa3_active_stats` DROP `uniques_r` ,
DROP `free_trials_r` ,
DROP `trials_r` ,
DROP `full_price_r` ,
DROP `payout_r` ;

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

Code:

ALTER TABLE `mpa2_active_referral_stats` DROP `uniques_r` ,
DROP `signups_r` ;


ALTER TABLE `mpa2_active_stats` DROP `uniques_r` ,
DROP `free_trials_r` ,
DROP `trials_r` ,
DROP `full_price_r` ,
DROP `payout_r` ;

StuartD · 04-22-2006, 04:43 PM

Quote:

Originally Posted by sonofsam

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

Code:

ALTER TABLE `mpa2_active_referral_stats` DROP `uniques_r` ,
DROP `signups_r` ;


ALTER TABLE `mpa2_active_stats` DROP `uniques_r` ,
DROP `free_trials_r` ,
DROP `trials_r` ,
DROP `full_price_r` ,
DROP `payout_r` ;

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.

Manowar · 04-22-2006, 05:05 PM

Quote:

Originally Posted by elitetec

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

and you wonder why people hate you?

KCat · 04-22-2006, 06:17 PM

bump for Naughty Bank

OY · 04-22-2006, 06:30 PM

Quote:

Originally Posted by sonofsam

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

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

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.

StuartD · 04-22-2006, 08:20 PM

Quote:

Originally Posted by Oystein

StuardD ? you seem like a smart guy ? you are right on track and that is exactly what that file did.

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

TheSenator · 04-22-2006, 08:47 PM

Quote:

Originally Posted by Oystein

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.

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

rowan · 04-22-2006, 08:52 PM

File is 404 now

DamageX · 04-22-2006, 08:54 PM

Quote:

Originally Posted by Oystein

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.

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?

Dirty F · 04-22-2006, 09:01 PM

Quote:

Originally Posted by rowan

File is 404 now

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

Fiddy...,.

04-22-2006, 01:18 PM	#1
sonofsam Too lazy to set a custom title Join Date: Dec 2004 Location: Vancouver Posts: 18,638	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? __________________ I like turtles.

04-22-2006, 01:19 PM	#2
Chio The Pirate Confirmed User Join Date: Oct 2002 Location: YARGH! On me big sailboat with the skull flags * * ICQ: 39-183769 Posts: 946	YARGH! Is that what it looks like? __________________ Need to get a site indexed in a few days? Want thousands of targeted, quality hits to your site? Want to beta test something that will revolutionize the way companies, and individuals advertise online.? Click here to take a look at Bliggo

04-22-2006, 01:21 PM	#4
MrIzzz If u touch it, I will cum Join Date: Sep 2003 Location: long island Posts: 22,923	see sig placed for possible long threaded drama __________________ WHO WANTS TO PLAY GRAB-ASS?

04-22-2006, 01:25 PM	#5
DateDoc Outside looking in. Industry Role: Join Date: Feb 2005 Location: To Hell You Ride Posts: 14,243	interesting __________________

04-22-2006, 01:28 PM	#7
xlogger Confirmed User Join Date: Jul 2004 Location: NY Posts: 9,507	So what it says "no_shaving"... I think its great they are not shaving. __________________ ---------- XLOGGER [REFLECTED] [OH]

04-22-2006, 01:27 PM	#6
Manowar jellyfish Join Date: Dec 2003 Posts: 71,528	holy shit!

04-22-2006, 01:29 PM	#8
polish_aristocrat Too lazy to set a custom title Join Date: Jul 2002 Posts: 40,377	__________________ I don't use ICQ anymore.

04-22-2006, 01:32 PM	#9
Trax [----------------------] Join Date: Aug 2001 Posts: 14,486	major sig spot lol

04-22-2006, 01:33 PM	#10
Trax [----------------------] Join Date: Aug 2001 Posts: 14,486	maybe thats the update from MPA2 to MPA3 now without shaving lol

04-22-2006, 01:35 PM	#11
xclusive Too lazy to set a custom title Join Date: Apr 2004 Location: Buffalo, NY Posts: 35,218	wow that dont look right __________________ I support MediumPimpin.com / Shemp's Outlawtgp.com /

04-22-2006, 01:36 PM	#13
TheSenator Too lazy to set a custom title Industry Role: Join Date: Feb 2003 Location: NJ Posts: 13,336	Hmmm... where is Smokey __________________ ISeekGirls.com since 2005

04-22-2006, 01:37 PM	#14
TheSenator Too lazy to set a custom title Industry Role: Join Date: Feb 2003 Location: NJ Posts: 13,336	So, is that code to prevent shaving? __________________ ISeekGirls.com since 2005

04-22-2006, 01:39 PM	#15
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 22,119	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

04-22-2006, 01:39 PM	#16
Jakke PNG ex-TeenGodFather Industry Role: Join Date: Nov 2001 Location: Suomi Finland Perkele Posts: 20,306	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.. __________________ ..and I'm off.

04-22-2006, 01:45 PM	#17
Trax [----------------------] Join Date: Aug 2001 Posts: 14,486	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

04-22-2006, 01:49 PM	#18
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	__________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

04-22-2006, 01:56 PM	#22
Trax [----------------------] Join Date: Aug 2001 Posts: 14,486	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

04-22-2006, 02:00 PM	#23
SmokeyTheBear ►SouthOfHeaven Join Date: Jun 2004 Location: PlanetEarth MyBoardRank: GerbilMaster My-Penis-Size: extralarge MyWeapon: Computer Posts: 28,609	you guys are freaking out over nothing... it says NO shaving update __________________ hatisblack at yahoo.com

04-22-2006, 02:05 PM	#24
xLaborJames Confirmed User Join Date: Apr 2006 Posts: 564	sig..drama..eek __________________ xLabor.com Your one stop shop for WP Blog Themes, Custom Designs, and Content Insertion. Contact me to discuss all your blogging needs! James AT xlabor.com \| 216 787 969

04-22-2006, 02:58 PM	#28
Theo HAL 9000 Industry Role: Join Date: May 2001 Posts: 34,515	whats the date this file was uploaded you unix gurus?

04-22-2006, 03:12 PM	#29
Lace Too lazy to set a custom title Industry Role: Join Date: Mar 2004 Posts: 16,116	Wow...fishy to say the least __________________ Your Paysite Partner Strength In Numbers! StickyDollars \| RadicalCash \| KennysPennies \| HomegrownCash

04-22-2006, 03:28 PM	#31
xclusive Too lazy to set a custom title Join Date: Apr 2004 Location: Buffalo, NY Posts: 35,218	Hmmm wonder if either side knows about this thread yet? Also any other MPA3 programs have this? __________________ I support MediumPimpin.com / Shemp's Outlawtgp.com /

04-22-2006, 03:33 PM	#32
Shoehorn! Die With Your Boots On Join Date: Oct 2003 Location: Hawaii Posts: 22,872	Oh boy, this thread will get interesting. __________________

04-22-2006, 03:36 PM	#33
StuartD Sofa King Band Join Date: Jul 2002 Location: Outside the box Posts: 29,903	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? __________________ This is me on facebook This is me on twitter

04-22-2006, 03:41 PM	#35
StuartD Sofa King Band Join Date: Jul 2002 Location: Outside the box Posts: 29,903	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). __________________ This is me on facebook This is me on twitter

04-22-2006, 04:12 PM	#37
Radiate Confirmed User Join Date: Dec 2004 Location: the center Posts: 1,454	mmm... definitely interesting __________________ icq 199437756 - contact me if you need a solid hosting solution

04-22-2006, 04:16 PM	#38
elitetec Too lazy to set a custom title Join Date: Sep 2005 Location: New York Posts: 4,944	http://www.toplistblog.com/addurl.php Increase your traffic __________________ Add Your Site To My PR4 Blog Selling Sig ICQ-200636146

04-22-2006, 04:31 PM	#39
sonofsam Too lazy to set a custom title Join Date: Dec 2004 Location: Vancouver Posts: 18,638	why is everything in the code mpa3 if it's from the older version? __________________ I like turtles.

04-22-2006, 06:17 PM	#44
KCat Confirmed User Join Date: Sep 2002 Location: PNW Posts: 2,204	bump for Naughty Bank __________________ ~ 300+ FHGs, 100,000 pics to use plus a rockin' Video of the Day download! ~

04-22-2006, 08:52 PM	#48
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	File is 404 now