Blockchain MySql Implementation - Bitcoin Stack Exchange

Sobre Tibia, gold farmers y un caso de ayuda y éxito PT2. Son muy buenos consejos de cómo comenzar a programar profesionalmente

Una vez más, reconocimiento al autor original de los post International-Unit-8

I have gotten so many replies and messages since my last post in this thread, that I can't answer them all individually. Previous topic:

It has been shared on multiple subreddits so I have no idea where to even post this. But I'd like to come up with a follow-up thread with some more information. The internet is the most powerful tool that mankind has ever invented. You have the ability to reach thousands, millions and even billions of people with just a computer and some internet access.

If you're on this subreddit, chances are you're already playing Tibia and you already have a computer and internet access. It doesn't need to be the best internet, but as long as websites will load (eventually) you are good to go.

In this topic I will go more in-depth on web development and software engineering. If you have a very slow internet connection, you may want to look into web development instead of software development. An application/software is much heavier (larger file size) than a website. And most developer jobs require that you send and download files, back and forth, between you and your company's server. So if you feel like your internet is too slow to send a lot of files - do not worry! There are plenty of jobs.

First, I will go through some more details on how to learn web development and software development. After that, I will list a few other kinds of jobs that you can do remotely. These types of jobs can be done from anywhere in the world as long as you have internet access.

Part 1: Some languages you should learn

What is web development? Well, it can be a lot of things. You perhaps make websites for shops/restaurants/hair dressers/dentists, or you work for a big company and work on their web application, like Outlook, Discord or Spotify (which can all be accessed via a browser: their web app). You can also work with design and user experience, instead of programming. Being a web developer can mean so many different things, it's impossible to name them all. But most web developers are just developers: they program. They make websites, and they either sell the websites to companies (as a consultant) or you work full/part-time for a company.

I can not provide in-depth information about every single thing, but I can give you some pointers. The very basics any web developer should know is this:

HTML (HyperText Markup Language) - it's what almost all websites use as a foundation. This is not a programming language, but it is a markup language. If you want to build websites, you pretty much have to know this language. Don't worry though, it is easy. Not so much to learn. You can learn all about it in a few weeks.

CSS (Cascading Style Sheets) - it's what will add colors and shapes to your website. If you want to focus more on design (also known as front end development) then this is where you want to gain a lot of knowledge.

Python - A very simple language to learn. This language is very often the first programming language that developers start using. You can use it for a lot of things. This language is used in the back of a lot of websites. Google has been using Python for years and still is. It's great for web scraping and making web requests. If you want a language to practice your algorithms, then this language is awesome.

PHP - This used to be a very popular language, but not so much these days. However, it is very good to know how this works because it's very simple to learn and also very functional in some cases. If you want to transmit or withdraw information from a database to your website, then this (in combination with SQL) is a great way to do so. Whenever you make a login system or a contact form, the data must be sent somehow to a recipient or a database. PHP will help you do that. It is a server-side language, which means it will run in the back of the website.

SQL - To be able to communicate with databases (for example: save data, update data, or insert data) you can use different languages for that. But SQL is probably the most widely used language for this. It is basically just a bunch of commands that you tell your website or app to do. If you have a web shop for example, you will need a database to store all your product information in. You can for example use MySQL as your database and then use the SQL language to extract data from your database and publish it as a list of products on your website.

JavaScript - Perhaps the most powerful language at the moment. Anyone who is good at JavaScript will be able to learn most other modern programming languages. In recent years, the demand for good JavaScript developers has skyrocketed. It's because more applications are becoming web based, and JavaScript is probably among the most useful languages to use. You can use it for so many things. Previously JavaScript was only being run on the client side of the website (that means in the user's browser). But in recent years, there has been massive development of this language and you are now able to build servers, connect to databases and do very powerful web applications using just this language. A great tutorial for JavaScript was made by Tony Alicea: This video is "just" 3.5 hours, but it's the intro. There is a much longer version of it, and you can download it for free if you search for it. Just find it as a torrent and watch it. It's probably the best tutorial I have seen for JavaScript.

C# - It's pronounced as "C Sharp". This language has been dominating the software engineering market for decades at this point. Everyone loves it. It's relatively easy to learn and you can build a lot of stuff in C#. It's very much like JavaScript, but focuses more on application development rather than website development. I would however try to avoid learning this language if you have very slow internet, since you will most likely be sending a ton of files back and forth. But if application (computer & phone) is your thing, then this language is great. There are so many tutorials on this, but there is 1 channel on YouTube which teaches a lot of the basics in C# (and many other languages) and that channel is called ProgrammingKnowledge. Sure, his C# videos may be old now but most of it is still relevant and useful. You will learn a lot by watching his videos. It's always good to start from the beginning and then when you're familiar with that, you can learn more about the recent updates in C#.

Java - This is pretty much 90% identical to C# as I wrote above. Widely used, relatively easy to learn the basics and there's plenty of jobs. If you like making android apps, this language is for you.

Part 2: Technologies and useful tools

To become a web developer you will need a few tools. You need a text editor, a FTP client, a SSH client and some other things. Also a good browser.

Text editor: Visual Studio Code, Atom, Sublime Text, Brackets - There are many different text editors but at the moment, I highly recommend Visual Studio Code. It has so many built-in features it's honestly the only thing you may need.Don't forget to install Notepad++ as well - this very basic editor is so handy when you just quickly need to edit some files.

File archiving: WinRar, 7-Zip - You need some way of archiving projects and send it to your customer or employer. These are basic tools anyone should use. I personally use Winrar.

FTP (File Transfer Protocol): FileZilla - This tool will allow you to connect to your website's file manager and upload your files to it. There are many tools for connecting to an FTP server but this is the most popular one, it's simple and it works great.

VPS (Virtual Private Server): Amazon Web Services, Google Cloud - If you want to practice building web applications or want to host your own website as a fun project, it's great to use a VPS for that. Both Amazon and Google offers 365 days of free VPS usage. All you need is a credit card. However, they will not charge you, as long as you stay below the free tier limit. A VPS is basically a remote computer that you can connect to. I highly recommend that, if you have a slow internet connection. Those VPS-servers (by Amazon and Google) usually have 500mbit/s internet speed, which is faster than most countries in the world. You simply connect to them via Remote Desktop, or by SSH. Depending on what type of server you are using (Windows or Linux).

SSH (Secure Shell): Solar-PuTTY, PuTTY - If you for example have a web server where you store applications and files, a great way to connect to it is by using SSH. PuTTY is pretty much the standard when it comes to SSH clients. But I really love the version created by SolarWinds. When you download that one, do not enter your personal details. Their sales people will call you and haunt you! Haha.

File Searching: Agent Ransack - When you have many files and try to locate a specific document or file, you may want to use something like Agent Ransack. Much faster than the traditional search feature in Windows and it is much more accurate.

IDE / Code Editor: Visual Studio - Great tool to use when you want to create applications in C# for example. Do not confuse this with Visual Studio Code. These are two very different tools. This tool (Visual Studio) is more designed for Windows applications. Not just websites. I only recommend getting it if you plan to make programs for Windows.

Web host & domain: NameCheap, Epik, SiteGround - If you develop websites on your own, or maybe want to create a portfolio website, you will need a domain name and web hosting. I have personally used all of these 3 and they are very cheap. NameCheap has some of the cheapest domains and great web hosting for a low price. Their support is also great. Same with SiteGround. And if you want to buy a domain anonymously (with Bitcoin for example), then you can use Epik. Low prices and great customer service on all these 3 websites.

Web Server: XAMPP, Nginx - If you plan to practice PHP, you will need to have a web server on your local computer. If you have Windows, I would highly recommend installing XAMPP (Apache). It is very easy to use for beginners. If you're on Linux, I would recommend Nginx. Also check our PhpMyAdmin if you want to quickly setup a MySQL database locally.Bonus tip: If you use Visual Studio Code to create websites in HTML, CSS and JavaScript: then install the extension "live server" and you can run your applications on a live server without setting it up yourself. Tutorial:

Web Browser: Mozilla Firefox, Microsoft Edge Insider, Google Chrome - You need one of the latest web browsers to create websites these days. Since I prefer privacy over functionality, I've always loved Firefox. But recently, Microsoft has been improving its new version of Edge a lot (based on Chromium) and it's also very popular. If you want all your personal details to be saved and have good tools for web development, then use Google Chrome. Don't forget to utilize the built-in developer tools. You can access it in any of these browsers by pressing F12.

Other things you may want to look into:

Web services, SSL certificates, Search Engine Optimization, Databases, API, Algorithms, Data Structures

Part 3: Learning platforms

If you want to learn in-depth about algorithms, data structures and more. Then you can take a look at the curriculum of the top-tier universities of USA. Such as: UC Berkeley, Harvard and MIT. These courses are very hard and are specifically for people who want to become experts in software engineering. You can enroll some of them for free, like the one on Harvard. And by having a such diploma (which costs $90 extra) can get you a lot of job opportunities. You can enroll those courses if you want, but it can have a fee. But just take a look at what they are studying and try do their exercises, that is 100% free. Get the knowledge. It's mostly on video too! These course below are the very same courses that many of the engineers at Facebook, Google, Amazon, Apple, Netflix, Uber, AirBnb, Twitter, LinkedIn, Microsoft, etc. has taken. It's what majority of people in Silicon Valley studied. And it's among the best classes that you can take. These course are held by some of the world's best professors in IT.

UC Berkeley: CS 61a & CS 61b:

Video playlist here:


Harvard University: CS50 (free enrollment --- 90$ to get a certificate).

MIT (Massachusetts Institute of Technology): 6.006

Held by Erik Demaine. One of the best - if not THE best - professor at MIT. Just look at this resume. It's almost 50 pages long!

Part 4: Finding jobs

Facebook groups for web developers, freelancing, remote work, etc.

Portfolio / Code Sharing / Source Control:

Part 5: Other types of jobs you can work with (remotely) - with/without coding experience

SEO (Search Engine Optimization)

Translations (Spanish/Portuguese, etc.)

Affiliate Marketing (look into - and use Facebook Ads to promote products)

Design (web design, photo design, etc.)

Copywriting (write sales letters for companies)

Database manager (monitor and administrate a company's database)

YouTube - make YouTube videos to gain views. Views = Money.

Dropshipping (use for example) and sell products in a webshop. Benefit with dropshipping is that you don't personally store the products.

Customer support

more...? Banking, economics, etc.

You can find information about all of the things I have mentioned by using YouTube or Google search.

Hope it helps.

And I hope that in 1 year, there will be at least some new web developers in Brazil, Venezuela and other countries in South America.
submitted by jesuskater to memezuela [link] [comments]

I got pwned: a cautionary tale

As background, I've been playing with a Digital Ocean instance for the past few months - getting DNS and Let's Encrypt set up, setting up nginx as a reverse proxy, and now setting up nextcloud.
Last week, I was pretty pleased with myself. I installed the Calendar plug-in and started syncing my calendar - independently of Google! Today I started getting from 500 errors popping up on my phone. I didn't think much of it - I figured something was weird with nextcloud, I had overlooked something, and I could figure it out when I got home. Unfortunately, I just found this in my database.
centos:~/src/nextcloud-config$ mysql -h -P 3306 -u nextcloud -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 10 Server version: 10.4.8-MariaDB-1:10.4.8+maria~bionic binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | nextcloud | +--------------------+ 2 rows in set (0.00 sec) MariaDB [(none)]> USE nextcloud; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [nextcloud]> SHOW TABLES; +---------------------+ | Tables_in_nextcloud | +---------------------+ | WARNING | +---------------------+ 1 row in set (0.00 sec) MariaDB [nextcloud]> SELECT * FROM WARNING; +----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------+------------------+ | id | warning | Bitcoin_Address | Email | +----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------+------------------+ | 1 | To recover your lost Database and avoid leaking it: Send us 0.06 Bitcoin (BTC) to our Bitcoin address ieUD and contact us by Email with your Server IP or Domain name and a Proof of Payment. If you are unsure if we have your data, contact us and we will send you a proof. Your Database is downloaded and backed up on our servers. Backups that we have right now: nextcloud . If we dont receive your payment in the next 10 Days, we will make your database public or use them otherwise. | ieUD | [email protected] | +----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------+------------------+ 1 row in set (0.01 sec) 
I have no intention of paying the ransom. 1) They have a few calendar events and some example documents from me. 2) Even if I pay, there's no guarantee they would send me a copy of the data.
All things equal, I feel lucky this happened so soon ... I only lost like 3 calendar events, all of which I can recreate from memory. I guess I need to back up and re-evaluate my security assumptions (notably to make backups early).
In the hopes of detecting the root cause, here is my (redacted) nginx access.log from today: Naturally my judgment is in question, ha ha, but I did see a few suspicious-looking entries (some suspicious-looking stuff in there (, some calls to /login and /wp-admin, some requests that look like binary data...). If anyone could help me understand how my server was compromised, it would be much appreciated.
Thanks all ... remember that weird shit like "entire Internet scanner" exists ... :-(
edit: Thank you all so much. Based on the ideas from the comments, the prevailing hypothesis about the root cause is:
- no firewall was active, either through the host admin panel (Digital Ocean) or in Linux itself
- In the course of troubleshooting, I had exposed port 3306 on my database container to anyone with access to my droplet, i.e. the whole Internet (via DNS). My intention was to expose the port only to other processes on my droplet, but I unintentionally exposed it publicly.
- I had an extremely weak root password
- With the "masscan" port-scanning tool, the vulnerability was detected by an attacker quite quickly, like within a week of me having this configuration active. Then a simple dictionary attack would have let them into root in my mariadb container.
Well ... knowledge is half the battle. Thanks again everyone ... I hope this thread will help a future lost soul who finds themselves in a similar circumstance.
submitted by silvertoothpaste to NextCloud [link] [comments]

PHP Script Casino Management System Online Casino Full Feature

[ Removed by reddit in response to a copyright notice. ]
submitted by Champion01 to u/Champion01 [link] [comments]

Can someone give me accurate current blockchain size?

Size of bitcoin directory...
Both with and without -txindex, if possible, please.
Just doing some comparison and calculations for a blog post.
Thank you.
submitted by jcoinner to Bitcoin [link] [comments]

So glad I'm done with university

Fuck me in the ass with a lemon-soaked cactus, college and university were bullshit.
Let's start with my time in community college, which started with me fighting for months with the stupid bastards over whether or not I counted as an in-state student after having lived in said state for over a year with adequate documentation backing up my claim. I was, after several lengthy phone conversations, informed when I did a daily checkup on how badly they were deciding to fuck me at that very moment to a lady telling me I was in-state...and acting like I should already know that. Despite the cunts never having told me in any fucking medium; I don't think there was ever any confirmation in any form of correspondance. I was given completely wrong guidance on at least one occasion as to what I required to get my Associate's degree, with the stupid asswipe thinking I was in the Arts program when it clearly stated on all my records that I was Arts & Sciences, a completely separate path.
Fast-forward to my getting out of that armpit of a community college and into university, where they immediately defaulted me to the business major (and their advisors) despite my never saying I was a business major. A quick form, thank the fucking sun, fixed that bullshit and got me majoring in an actual degree that's worth a shit: computer science. Because I'm not a complete idiot that thinks a liberal arts degree will get me anywhere other than Walmart or suicidal enough to pursue a degree in a hard science like physics.
Oh my fucking god.
I have never in my life heard of a school managing such a good reputation while being so fucking poorly managed. That's not even counting the fact that my advisor (the real one, not the bullshit default they gave me) was easily the shittiest human being in the CS department; a particularly dumb bint that could barely write coherent English sentences (despite being so obviously from New Jersey I'm surprised she wasn't orange), went on the defensive for the smallest fucking thing, and was so shit at her fucking job (teaching mid-level programming topics) that the students had to collaborate just to fix the bugs in her shit.
The email server frequently lost fucking emails or allowed one fucking Mensa graduate to mass-mail literally every student and faculty member at once, starting a chain email where every mentally subnormal shitstain on and off campus started treating it like some kind of party of ignoramuses and nearly brought the fragile piece of garbage email servers to their knees.
Actually, while I'm at it, let's get into the CS department. It had a serious problem with Linux cunts. I'm not talking regular Linux users that just preferred a different OS; those guys are alright. No, I'm talking the insufferably smug skidmarks that harp on and on and fucking on about their free software and their different fucking distributions and kernels and shit. Acting like desktop Linux is totes poised for a victory over that proprietary nonsense, despite the fact its completely fractured nature means that it'll always have a completely inconsequential desktop market share, dooming it forever to niche uses and servers. Thinking that using a command-line interface made them "cool" and that it was "so much faster than a GUI."
This wasn't in 1992, mind you; this was 2018. A regular-ass GUI takes up no more resources or computing power than what those goofy fucks had in their dumbass smart watches. The same dozy cunts that sniggered when I used my Windows laptop. Yeah, laugh all ya want, but at least when I go to download device drivers, I don't have to go to Crazy Eddie's Discount Basement-Made Driver Emporium and Bitcoin Mine because my ultra niche distribution of Linux is barely supported.
Oh, did I mention I went to a liberal arts university? One that actually had the gall to claim I needed "human experience" credits to graduate. As if tolerating the rest of the complete bullshit the uni was throwing at me, not to mention the arrogant cunt students, didn't somehow count as a "human experience." That insisted I take a bunch of dumbass classes like anthropology and (ADVANCED!) literary criticism because what a computer science major, a person that's going to spend most of their lives either in a cube or sitting in their home office half-naked because he can't be arsed to put on pants really needs is to know about the Tootsi-Frootsi tribe of West Africa or how to apply an existentialist lens to Frankenstein.
That's not to let the CS curriculum off the hook, either. Oh fuck no, there was some serious bullshit there, too.
I'm sorry, but in what fucking world do I live in where I'm gonna need to know about how to develop an operating system? In what possible light is understanding the incredibly boring, arcane nonsense that are finite automata at all fucking useful when I'm designing a web API for Gerber baby food or unfucking some asshole's stored procedure in the company's MySQL database? Almost all the mid-level classes were a complete waste of my fucking time because most of them were nothing but fucking theory. Oh, and a database class that worked with fucking JavaScript, for some utterly insane fucking reason.
University was fucking bullshit and I'm so happy I'm done with it. If those dumb pricks decide in their infinite wisdom to fill my mailbox with shit begging for money, I'm half-tempted ot send them print outs of dicks with flesh-eating disease. Bullshit motherfuckers.
submitted by RavynousHunter to Rants [link] [comments]

0x00.txt - the write-up/guide from the FinFisher hack

Here is the write-up/guide from the FinFisher hack, which is excellent reading - it is also mirrored here. Hopefully we will get the Hacking Team one soon.
 _ _ _ ____ _ _ | | | | __ _ ___| | __ | __ ) __ _ ___| | _| | | |_| |/ _` |/ __| |/ / | _ \ / _` |/ __| |/ / | | _ | (_| | (__| < | |_) | (_| | (__| <|_| |_| |_|\__,_|\___|_|\_\ |____/ \__,_|\___|_|\_(_) A DIY Guide for those without the patience to wait for whistleblowers 
--1-- Introduction
I'm not writing this to brag about what an 31337 h4x0r I am and what m4d sk1llz it took to 0wn Gamma. I'm writing this to demystify hacking, to show how simple it is, and to hopefully inform and inspire you to go out and hack shit. If you have no experience with programming or hacking, some of the text below might look like a foreign language. Check the resources section at the end to help you get started. And trust me, once you've learned the basics you'll realize this really is easier than filing a FOIA request.
-- 2 -- Staying Safe
This is illegal, so you'll need to take same basic precautions:
  1. Make a hidden encrypted volume with Truecrypt 7.1a
  2. Inside the encrypted volume install Whonix
  3. (Optional) While just having everything go over Tor thanks to Whonix is probably sufficient, it's better to not use an internet connection connected to your name or address. A cantenna, aircrack, and reaver can come in handy here.
As long as you follow common sense like never do anything hacking related outside of Whonix, never do any of your normal computer usage inside Whonix, never mention any information about your real life when talking with other hackers, and never brag about your illegal hacking exploits to friends in real life, then you can pretty much do whatever you want with no fear of being v&.
NOTE: I do NOT recommend actually hacking directly over Tor. While Tor is usable for some things like web browsing, when it comes to using hacking tools like nmap, sqlmap, and nikto that are making thousands of requests, they will run very slowly over Tor. Not to mention that you'll want a public IP address to receive connect back shells. I recommend using servers you've hacked or a VPS paid with bitcoin to hack from. That way only the low bandwidth text interface between you and the server is over Tor. All the commands you're running will have a nice fast connection to your target.
-- 3 -- Mapping out the target
Basically I just repeatedly use, whois lookups on IP addresses and domain names, and reverse whois lookups to find all IP address space and domain names associated with an organization.
For an example let's take Blackwater. We start out knowing their homepage is at Running -dns we find the subdomains: 
Now we do whois lookups and find the homepage of is hosted on Amazon Web Service, while the other IPs are in the range:
NetRange: - CIDR: CustName: Blackwater USA Address: 850 Puddin Ridge Rd 
Doing a whois lookup on reveals it's also registered to the same address, so we'll use that as a string to search with for the reverse whois lookups. As far as I know all the actual reverse whois lookup services cost money, so I just cheat with google:
"850 Puddin Ridge Rd" inurl:ip-address-lookup "850 Puddin Ridge Rd" inurl:domaintools 
Now run -range on the IP ranges you find to lookup dns names, and -dns on the domain names to find subdomains and IP addresses. Do more whois lookups and repeat the process until you've found everything.
Also just google the organization and browse around its websites. For example on we find links to a careers portal, an online store, and an employee resources page, so now we have some more: 
If you repeat the whois lookups and such you'll find seems to not be hosted or maintained by Blackwater, so scratch that off the list of interesting IPs/domains.
In the case of FinFisher what led me to the vulnerable was simply a whois lookup of which found it registered to the name "FinFisher GmbH". Googling for:
"FinFisher GmbH" inurl:domaintools 
finds, which redirects to now you've got some idea how I map out a target.
This is actually one of the most important parts, as the larger the attack surface that you are able to map out, the easier it will be to find a hole somewhere in it.
-- 4 -- Scanning & Exploiting
Scan all the IP ranges you found with nmap to find all services running. Aside from a standard port scan, scanning for SNMP is underrated.
Now for each service you find running:
  1. Is it exposing something it shouldn't? Sometimes companies will have services running that require no authentication and just assume it's safe because the url or IP to access it isn't public. Maybe fierce found a git subdomain and you can go to git.companyname.come/gitweb/ and browse their source code.
  2. Is it horribly misconfigured? Maybe they have an ftp server that allows anonymous read or write access to an important directory. Maybe they have a database server with a blank admin password (lol stratfor). Maybe their embedded devices (VOIP boxes, IP Cameras, routers etc) are using the manufacturer's default password.
  3. Is it running an old version of software vulnerable to a public exploit?
Webservers deserve their own category. For any webservers, including ones nmap will often find running on nonstandard ports, I usually:
  1. Browse them. Especially on subdomains that fierce finds which aren't intended for public viewing like or you'll often find interesting stuff just by looking at them.
  2. Run nikto. This will check for things like webserve.svn/, webservebackup/, webservephpinfo.php, and a few thousand other common mistakes and misconfigurations.
  3. Identify what software is being used on the website. WhatWeb is useful
  4. Depending on what software the website is running, use more specific tools like wpscan, CMS-Explorer, and Joomscan.
First try that against all services to see if any have a misconfiguration, publicly known vulnerability, or other easy way in. If not, it's time to move on to finding a new vulnerability:
5) Custom coded web apps are more fertile ground for bugs than large widely used projects, so try those first. I use ZAP, and some combination of its automated tests along with manually poking around with the help of its intercepting proxy.
6) For the non-custom software they're running, get a copy to look at. If it's free software you can just download it. If it's proprietary you can usually pirate it. If it's proprietary and obscure enough that you can't pirate it you can buy it (lame) or find other sites running the same software using google, find one that's easier to hack, and get a copy from them.
For the process was:
At this point I can see the news stories that journalists will write to drum up views: "In a sophisticated, multi-step attack, hackers first compromised a web design firm in order to acquire confidential data that would aid them in attacking Gamma Group..."
But it's really quite easy, done almost on autopilot once you get the hang of it. It took all of a couple minutes to:
Looking through the source code they might as well have named it Damn Vulnerable Web App v2. It's got sqli, LFI, file upload checks done client side in javascript, and if you're unauthenticated the admin page just sends you back to the login page with a Location header, but you can have your intercepting proxy filter the Location header out and access it just fine.
Heading back over to the finsupport site, the admin /BackOffice/ page returns 403 Forbidden, and I'm having some issues with the LFI, so I switch to using the sqli (it's nice to have a dozen options to choose from). The other sites by the web designer all had an injectable print.php, so some quick requests to: and 1=1 and 2=1 
reveal that finsupport also has print.php and it is injectable. And it's database admin! For MySQL this means you can read and write files. It turns out the site has magicquotes enabled, so I can't use INTO OUTFILE to write files. But I can use a short script that uses sqlmap --file-read to get the php source for a URL, and a normal web request to get the HTML, and then finds files included or required in the php source, and finds php files linked in the HTML, to recursively download the source to the whole site.
Looking through the source, I see customers can attach a file to their support tickets, and there's no check on the file extension. So I pick a username and password out of the customer database, create a support request with a php shell attached, and I'm in!
-- 5 -- (fail at) Escalating
< got r00t? >
 \ ^__^ \ (oo)\_______ (__)\ )\/\ ||----w | || || ^^^^^^^^^^^^^^^^ 
Root over 50% of linux servers you encounter in the wild with two easy scripts, Linux_Exploit_Suggester, and unix-privesc-check.
finsupport was running the latest version of Debian with no local root exploits, but unix-privesc-check returned:
WARNING: /etc/cron.hourly/mgmtlicensestatus is run by cron as root. The user www-data can write to /etc/cron.hourly/mgmtlicensestatus WARNING: /etc/cron.hourly/webalizer is run by cron as root. The user www-data 
can write to /etc/cron.hourly/webalizer
so I add to /etc/cron.hourly/webalizer:
chown root:root /path/to/my_setuid_shell chmod 04755 /path/to/my_setuid_shell 
wait an hour, and ....nothing. Turns out that while the cron process is running it doesn't seem to be actually running cron jobs. Looking in the webalizer directory shows it didn't update stats the previous month. Apparently after updating the timezone cron will sometimes run at the wrong time or sometimes not run at all and you need to restart cron after changing the timezone.
ls -l /etc/localtime shows the timezone got updated June 6, the same time webalizer stopped recording stats, so that's probably the issue. At any rate, the only thing this server does is host the website, so I already have access to everything interesting on it. Root wouldn't get much of anything new, so I move on to the rest of the network.
-- 6 -- Pivoting
The next step is to look around the local network of the box you hacked. This is pretty much the same as the first Scanning & Exploiting step, except that from behind the firewall many more interesting services will be exposed. A tarball containing a statically linked copy of nmap and all its scripts that you can upload and run on any box is very useful for this. The various nfs-* and especially smb-* scripts nmap has will be extremely useful.
The only interesting thing I could get on finsupport's local network was another webserver serving up a folder called 'qateam' containing their mobile malware.
-- 7 -- Have Fun
Once you're in their networks, the real fun starts. Just use your imagination. While I titled this a guide for wannabe whistleblowers, there's no reason to limit yourself to leaking documents. My original plan was to:
  1. Hack Gamma and obtain a copy of the FinSpy server software
  2. Find vulnerabilities in FinSpy server.
  3. Scan the internet for, and hack, all FinSpy C&C servers.
  4. Identify the groups running them.
  5. Use the C&C server to upload and run a program on all targets telling them who was spying on them.
  6. Use the C&C server to uninstall FinFisher on all targets.
  7. Join the former C&C servers into a botnet to DDoS Gamma Group.
It was only after failing to fully hack Gamma and ending up with some interesting documents but no copy of the FinSpy server software that I had to make due with the far less lulzy backup plan of leaking their stuff while mocking them on twitter.
Point your GPUs at and crack the password already so I can move on to step 2!
-- 8 -- Other Methods
The general method I outlined above of scan, find vulnerabilities, and exploit is just one way to hack, probably better suited to those with a background in programming. There's no one right way, and any method that works is as good as any other. The other main ways that I'll state without going into detail are:
1) Exploits in web browers, java, flash, or microsoft office, combined with emailing employees with a convincing message to get them to open the link or attachment, or hacking a web site frequented by the employees and adding the browsejava/flash exploit to that.
This is the method used by most of the government hacking groups, but you don't need to be a government with millions to spend on 0day research or subscriptions to FinSploit or VUPEN to pull it off. You can get a quality russian exploit kit for a couple thousand, and rent access to one for much less. There's also metasploit browser autopwn, but you'll probably have better luck with no exploits and a fake flash updater prompt.
2) Taking advantage of the fact that people are nice, trusting, and helpful 95% of the time.
The infosec industry invented a term to make this sound like some sort of science: "Social Engineering". This is probably the way to go if you don't know too much about computers, and it really is all it takes to be a successful hacker.
-- 9 -- Resources
  • The Web Application Hacker's Handbook
  • Hacking: The Art of Exploitation
  • The Database Hacker's Handbook
  • The Art of Software Security Assessment
  • A Bug Hunter's Diary
  • Underground: Tales of Hacking, Madness, and Obsession on the Electronic Frontier
  • TCP/IP Illustrated
Aside from the hacking specific stuff almost anything useful to a system administrator for setting up and administering networks will also be useful for exploring them. This includes familiarity with the windows command prompt and unix shell, basic scripting skills, knowledge of ldap, kerberos, active directory, networking, etc.
-- 10 -- Outro
You'll notice some of this sounds exactly like what Gamma is doing. Hacking is a tool. It's not selling hacking tools that makes Gamma evil. It's who their customers are targeting and with what purpose that makes them evil. That's not to say that tools are inherently neutral. Hacking is an offensive tool. In the same way that guerrilla warfare makes it harder to occupy a country, whenever it's cheaper to attack than to defend it's harder to maintain illegitimate authority and inequality. So I wrote this to try to make hacking easier and more accessible. And I wanted to show that the Gamma Group hack really was nothing fancy, just standard sqli, and that you do have the ability to go out and take similar action.
Solidarity to everyone in Gaza, Israeli conscientious-objectors, Chelsea Manning, Jeremy Hammond, Peter Sunde, anakata, and all other imprisoned hackers, dissidents, and criminals!
submitted by m1croc0d3 to HowToHack [link] [comments]

What entity manages .com, .net, .gov, .us, .cn domains?

For the longest time I still have not a clue how this works. I am not sure if this is the right subreddit or something like networking
This is all I understand so far about the web (or internet?), computers, and electronics in general (its super long just skip to bold part if you need to)
Okay, but who manages the .info, .com, .net, .cn, .rs, and .gov top level domains?
There's obviously some domains that are specific to countries, and are most likely managed by that countries' government entity. E.G (.us for usa? .ws for russia, .cn for china) but aren't nearly as popular as the .net and .com domains.
.Org and .gov are US? government regulated top level domains to my knowledge, where .org is mostly nonprofit. U.S.A uses .gov domains for its government organizations
So I understand that some countries government manages that domain. But what about public top level domains, like .com, .info, .net, .ca?
Who manages the database for those? Who gives authority to godaddy for those domains for rent? Who mediates copyright conflicts for those domains? (E.G. say my name is Mike Cro Soft, and I wanted to rent a domain called mikecrosoft, but get DMCA'd / copyrighted by
Like, what are the big organizations mediating internet protocols and legislation on a global scale?
Who or what has access to the biggest picture of the web, and its workings and backend?
sorry for the long wall of text, I've been missing some vital information on how the web? (or is it internet?) works
disclaimer: I don't take CS classes and did not major in computer science. So I might be really off in what i understand about the internet as a whole. Most of this is just what I learned from browsing reddit and youtube
Apologies in advance if i butchered a bunch of terms and how things work. I just wrote things as they randomly came to me
submitted by Rubick555 to AskComputerScience [link] [comments]

Day 6 of Ulbricht trial – selected quotes

Full transcript here: https://dl.dropboxusercontent.com24900303/1-14-cr-00068-2015-01-22.pdf
Thanks MagicalTux!
MR. HOWARD: Ms. Rosen, can we just zoom into this area right here.
Q. And where was the file located, Mr. Kiernan?
A. Yes. All these files are located under
Q. And what kind of files were contained in that folder?
A. Database files.
Q. What is a database?
A. A database is a collection of records or information that you want to organize and keep in a nice forum. So a digital way to do it is a database. You store it in the database like a phone book, per se, or your contact list on your phones. Those are all databases. It just makes it easier so you can search for people, search for things, phone numbers, where you live -- where someone else lives, and you could do combos. You can query the database to get all the people that you know that live in New York City but also work at a company here; and the object of it is just to make it a lot easier to find data on your hard drives.
Q. Did you look at the contents of the database?
A. I did.
Q. And what did the database appear to contain?
A. It contained some entries of drugs and items like that.
Q. And could we go to Government's Exhibit 225B, please. If we can scroll down a little bit. This is a conversation that you -- you didn't read it. Mr. Howard read it yesterday, right? This is something you got off the laptop, right --
A. Correct, yes.
Q. -- you got off the drive that was given to you? The highlight version reads -- and this is -- just to put this back in context, this is Dread Pirate Roberts and this is on a TorChat, right?
A. These are from the TorChats, yes.
Q. And Dread Pirate Roberts is responding to someone working for him that the person is concerned about being arrested, right, about law enforcement? And Dread Pirate Roberts responds "There is nothing on your laptop for them to use, if you obscure your bitcoins properly, there's there is no way for them to trace them back to me. Realistically, the only way for them to prove anything would be for them to watch you log in and do your work," right? That's Dread Pirate Roberts, right?
A. That's what it says.
Q. And that's January of 2013, right?
A. Yes.
Q. So if we could go further. Again Dread Pirate Roberts: "Sure, someone could stand behind you without you realizing it," right? Yes?
A. Yes.
Q. So Dread Pirate Roberts understood full well the dangers of having his back to anyone who could sneak up behind him, right?
MR. HOWARD: Objection; speculation.
THE COURT: Sustained.
Q. You testified yesterday, right, that the argument dispute that was contrived to distract Mr. Ulbricht was, in fact, behind him, right, and he turned around?
A. Yes.
Q. So if we go back to 228 -- I'm sorry -- 128H, Mr. Ulbricht really couldn't be sitting in that spot where that person was against the window because the other two people would have to be behind him, right?
A. That's where I remember him.
Q. But you told the government twice in preparation for this case that he had his back to you looking out the window?
A. It's here. It's in this document here.
Q. You deny that you said that?
A. Yeah, I mean. I don't deny I said it, but it's here in the document. If that's what that is, then, yes, I said that.
Q. Isn't it a fundamental part of security not to keep your PG -- your private PGP key available on your computer in a manner that can be viewed by anyone on that computer?
A. No. You have to -- the key has to be somewhere. If you set it up on your computer, that's where you would keep your key. The idea behind it is to store it in a safe location, like an encrypted, again.
Q. And you put it in a file that says "Key," is that a good way to disguise it?
MR. HOWARD: Objection.
THE COURT: Sustained.
Q. But you wouldn't put it in a file -- would you as a person trying to be secure put it in a file with the name "Key" on it?
MR. HOWARD: Objection.
THE COURT: Sustained.
Q. Do you instruct people on how to disguise PGP keys on their computer?
A. I don't --
Q. Have you been instructed? Is there training on that?
A. Is there training on that? No, there is no training on where to keep your PGP key. It is your secret key. So if I was doing it, I would have an encrypted laptop and keep my key there, and when I turned off my laptop the key would be safe.
Q. And you would put it in a file called "key"?
MR. HOWARD: Objection.
THE COURT: Sustained.
Q. Do you see what's downloading there is the Colbert Report, right?
A. Yes.
Q. It is not complete at that point, right?
A. It doesn't look to be.
Q. It only looks like about 8-and-a-quarter megabytes of 197 megabytes, right?
A. Yes.
Q. So that takes some time, correct?
A. Yeah. Depending on connection speeds and things like that, but yeah.
Q. So you have to have an open port to the Internet on your computer to operate BitTorrent, correct?
A. You do. The protocol is required that a port or a connection spot is open.
THE COURT: That is not relevant. Whether the FBI allows BitTorrent on their computers is not relevant to whether or not the particular computer here -- you've got to establish that it was running BitTorrent. If you want to explore whether or not, if you've got a good faith basis to believe -- a good faith basis to believe that the files were placed on this computer, Mr. Ulbricht's computer, through the use of the BitTorrent program, then go after that. But I am not going to let you go into the practices of the FBI.
MR. DRATEL: It is the practice -- it is a fundamental question of security. This is a completely insecure system for someone who --
THE COURT: That is not this case. Thank you.
And then he explained to me very panicked that someone who knew about his involvement had posted to his Facebook wall something along the lines of I'm sure the authorities would be very interested in your drug-running site. And he told me that he, you know, deleted that post, unfriended the person. And at that point I told him you've got to shut the site down. This is all they need. Once they see this, they can get a warrant and it's over. This is not worth going to prison over. And he told me that he couldn't shut down the site because he had already sold it to someone else.
... OR DID HE?
Page 59 of 1,096. December 9, 2011:
vj: IRL - is there anyone with a clue at all? Girlfriend, boyfriend, bunny you talk to, online buddy's who you've know for years? Gramma, priest, rabbi, stripper?
myself: unfortunately yes. There are two, but they think I sold the site and got out and they are quite convinced of it.
vj: good for that - when do they think you've sold?
myself: about a month ago
vj: and do they now notice the demands on your time? These the kinda people you'll know forever, or would a move work someday?
myself: no, I live no where near them anymore. One I'll prob never speak to again, and the other I'll drift away from.
Continuing from the same chat on page 314 of 1,096 on January 15, 2012:
vj: Have you even seen The Princess Bride?
myself: growing up my parents had the last half of spaceballs and the last 3/4 of the Princess Bride and all of Romancing the Stone. that pretty much sums up my personality.
Do you have any other favourite fragments?
submitted by vytah to Buttcoin [link] [comments]

Run-down on the bot / where I am at currently in development

Hey everyone DuncanKeyes here (Sudo on StorjTalk).
I'm going to outline some details about the bot and development of it.
Currently, the bot is running on a dedicated server hosted by Kimsufi. The server is the KS-2 dedicated server.
The specifications of the server are:
Model CPU Cores/Threads Freq. RAM Disk Network
KS-2 Atom™ D425 1c/ 2t 1.8 GHz+ 4 GB 1 TB 100Mbps
I feel like this is fine to start off with, but if we do need more power to run the bot, I will look into upgrading to a more powerful server.
The server is running on Ubuntu Server 14.04 "Trusty Tahr" LTS (64bits)
It is using MySQL for the database that the bot uses.
The bot software is ALTcointip bot found here, running with Pifkoin which is a Bitcoin API module that provides a Python API for Bitcoin mining and research.
The bot is running on a dedicated user account without root privileges.
All passwords, such as the ones for the MySQL database and for the bot account Storjtipbot have 100 character passwords with a combination of upper and lowercase letters, numbers, capitalisation and special characters.
Example password:
These passwords were generated using Lastpass and are stored in my Lastpass Vault. I am looking to change these passwords once I get the initial beta release of the bot out to be generated in KeyPassX.
As of this post, I have configured Counterpartyd and I am just finishing setting up Bitcoind which is required for Counterpartyd to run, I am currently downloading the blockchain which is 25GB or so, but I have downloaded around 3/4 of it.
Once the blockchain is downloaded, I will move to setting up Insight which is a bitcoin blockchain API for web wallets that bitcoind cannot currently provide.
After that, I begin actually setting up the bot. This includes creating the MySQL database and installing and running ALTcoin tip bot. This step is the easiest thanks to ALTcoin tip bot's source code being released.
Once I have got the bot up and running, I will be commencing small scale testing on the features provided by ALTcointip bot (such as registering an account, sending and receiving payments, depositing and withdrawing).
I do hope for this bot to become active over the next few days, just need to wait on that pesky blockchain to download :)
submitted by Storjtipbot to Storjtipbot [link] [comments]

[Table] IamA porn site owner. AMA!

Verified? (This bot cannot verify AMAs just yet)
Date: 2013-08-19
Link to submission (Has self-text)
Questions Answers
Hello. Interesting AMA. Do you make enough to live comfortably? Yes. I grossed just shy of $300,000 last year. I drive a Mercedes and live in a luxury apartment in an expensive area of the country.
Does your family know? Not really. My only concern is with legality and VISA/MC's "BRAM" violations, since they could blacklist me and prevent me from ever accepting credit cards again.
Can I have a free pass? ;-) My sister knows, but my mother doesn't. The rest of my family has passed away or never existed.
Hah. Would if I could, but my site sells clips individually. There are no subscriptions... yet. :)
What does your mother think you do? I went self employed a year ago, but I have another website (which doesn't do as well) that I can point people to. As long as they don't examine it too much they probably wouldn't notice the lack of activity.
Awesome. What is the site name? :-) Lemonparty. ;)
(note: I'm kidding, of course.)
You say what you grossed but what's your margin? And would you accept outside investment? Net profit margins on clips are between 20% and 30%. Tribute margins between 10% and 20%.
Can you elaborate on not having any ethical concerns? What measures do you have in place to make sure the performers in your videos have good working conditions, aren't being coerced or manipulated into performing, aren't victims of human trafficking, etc.? I have no measures in place to prevent those, really. It's more policing them after-the-fact.
The only thing really in place is the ability to report a video, which then flags it for the review of an admin. If the video looks like it could be illegal, we take it offline until the studio can provide proof the video is legal.
According to the DMCA, content platforms cannot be held liable for the content posted by the user to a reasonable extent.
What I meant is I don't have moral concerns about the content of my site. A lot of it is pretty revolting, but it's not my job to judge or deny anyone for their fetish, as long as its within the bounds of the law.
Dad? Grandpas.
I wonder if that site has any serious profit. Everyone knows it. I doubt it... accidental ad clicks, maybe. The thing about advertising is it works best when you sell it to people in your market. I would assume that not many people go, dicks-in-hand, to lemonparty. But if its one thing owning a site like mine has taught me, its to not make assumptions about what materials people look for while "firing the surgeon general".
So by my math you're making around $75k/yr. if you're grossing 300k--surely a comfortable life, but by no means the lap (or crotch, in this case) of luxury. That sounds about right. Maybe less. Sometimes I'll work web contracts to supplement my income. It also helps remind me why I much prefer working for myself. :)
How often do you get a completely inappropriate video that you have to reject? Not too often, but there's some pretty harsh stuff on the site. I really try to look at it objectively. Some of the stuff makes me cringe and is hard to watch. Dudes getting kicked in the balls, for example.
Edit: Willingly, I might add.
Yay, a foremen fan! NICE! I was wondering if anyone was gonna get that reference.
Do you ever visit other porn sites to get off? Or do you stick to your own? I never get hard on my own supply.
Pretty much, the content on my own site isn't for me. We have some very attractive women on the site, but there isn't much traditional porn on the platform.
What's one weird trick that will help me last longer and/or increase the size of my dick? From personal experience? More foreplay.
If you've ever been given blueballs and afterwards pulled out your wang, you'd be surprised at how much bigger it can get. Freaked myself out once after a heavy petting session that wasn't advancing.
How was that username not taken? No idea.
Why did you make this AMA anonymous when you could have used this as a marketing campaign? I'm not really looking to profit off of this. I've read a bunch of awesome AMAs and figured I could contribute and answer some peoples curiosity. When I tell people in person they always have a hundred questions for me.
How long have you been in the industry? Besides, I find it difficult to believe anyone could be into some of the things on my site. I doubt it would boost sales.
Do you still find porn appealing or is it all pretty run-of-the-mill now? About 3 years.
I'm not turned on by many of the videos on my own site, so it hasn't changed porn for me much at all. I stick to beeg and motherless, personally.
Where do you think the future of porn on the internet is headed? The same direction the rest of the web industry is heading. HTML5 / Javascript MVC frameworks. High scalability platforms. The only advantage is there's a serious shortage of talented developers in the adult industry, so those of us who do know these technologies have an upper hand.
all the sites like Redtube/youporn etc... all giving away porn for free has to make a big dent into your profits? We do find our studios' clips on some of these sites. Sometimes a DMCA notice works, sometimes not. However, since the bulk of my customers are into financial domination, they prefer to pay for the clips. We also make a good amount of money from "tributes", which are simply cash donations. Not sure of the legality of tributes, but they're an industry staple.
What is this "financial domination" stuff? Sounds real kinky! I searched for it on a competitors video site but couldn't find anything.. It is indeed a real thing. I've come to learn about some pretty crazy fetishes people have.
FinDom (financial domination) Fart porn / flatulence Hiccups Giantess (look this one up. you won't believe it.)
What is financial domination? "A real thing" isn't really an answer and doesn't really help. Pls describe in further detail. Financial domination is a fetish where men, who are usually in powerful corporate positions, want to give up control. They're usually in charge, but this lets them not be. Sometimes it's via video chat, sometimes its just a video they purchase, but every time it has to do with being called names, told they're not good enough or just worthless "pay piggies". The girls will demand the men give them money, and they do. Usually there's not even any nudity unless its the man getting naked. I've seen some crazy shit with FinDom. Guys with broomsticks up their asses and womens clothes on... whatever the girl wants to do to humiliate the guy.
Sometimes they let the girls control their computer remotely with access to go through their email, send themselves money, etc, while they just watch with their dick in their hand.
It's odd and I don't understand it, but again, I'm not here to judge. I'm here to make money.
One studio I know demanded a man buy her a brand new BMW M3 convertible, and he did. He gave her $10k in cash per month until it was paid off. That's an $80k car.
I wish I was a hot girl... They make pills for that.
That's really crazy, you're basically just giving money away to someone you don't know at all.. It is interesting, but it exists, so I don't question it too much.
I'm looking for porn including a walrus with a tooth brush and their trainer. Do you have anything? EDIT: Of course THIS has to be my highest rated comment... Will an elephant seal and a tourist work? Also, do you care if the tooth brush is motorized?
That depends does the elephant seal have control of the motorized tooth brush? Checking...
What is your technical background? Are you a programmer? Do you manage the tech of the website yourself or is it 'outsourced'? I've been programming full time for professional corporations and agencies for 15 years now. I do manage the tech myself, but I make heavy use of Amazon web services.
Is it legal to post that kind of content on AWS ? It's not not-legal.
Who moves more content than porn sites? AWS would be missing out on a large large profit if they didn't allow adult content.
I'm curious, how much did you make programming before you had this site? My last gig I made $135k. Before that, $120k.
How big was it? We'll just say he's not the king anymore. ;)
Does anyone ever actually click those share buttons? Share to... what? Facebook?
reddit, and google plus, etc. I wouldn't know. I don't have them on our site.
You mentioned good integration with Twitter earlier. That's for marketing? Like you have a twitter account for the site? I have a twitter account for the site, but the twitter integration I spoke of is a feature that lets studios connect their twitter account and have it auto-post a link when their video goes live.
Do you produce original content or do you buy content and resell it? Neither. We grant studios the access to upload their own clips and add their own meta data, set the price, etc. They get a majority % of the sale.
What's the average net profit of a typical clip, from a popular performer(s)? A couple of dollars. Most girls sell clips around $10, and of that they get to keep apx $6 - $7. Our net income for the clips are around 25%-40%. We give better rates to the better performing studios, to keep them interested and using our platform.
Me and my roommate have been toying around with the idea of starting a pron site, I have around 30k saved up, Would that be enough to start a redtube-ish website? Also whats the most expensive part of building a porn site? I.E. Licences , hosting, hardware, Hiring someone to build the website. Nice! Good luck with it. It's a challenging industry. Things that would take 20 minutes on a normal business can take days in the adult industry. (finding a payment processor, for example)
A redtube-style site would be quite a challenge, financially, I think. Policing it could also be pretty difficult.
The most expensive part, for me since I did all of my own design and programming, was getting VISA/MC approval for a high risk account. VISA has a $1000 annual fee and MC has a $500 annual fee, at least through my payment processor. Fees are also ass-rapingly high.
You can make use of Amazon Web Services to lower costs substantially.
How much would you guess it would cost to design and program a video hosting website? Also how hard was it in the beginning to get studios to sell their clips on your site? If I calculated it in hours spent on it myself, looking at around 3 months, so we'll say 500 hours. I charge $65/h if I ever take on freelance clients, so looking at about $32000 for someone at my rate. I'm expensive because of my extensive experience, so you can probably get it done for less.
751 studios 19,138 videos Apx 5000 visits per day - A good number of which are sent directly from the studios to purchase on the site or send a tribute.
Can you give us a rough description of your architecture? What OS/Web servelanguage do you use... Do you use a CDN to serve up the videos or do you host them yourself? And what bits of AWS do you use? How many EC2 instances? The site itself runs on a single server, a VM actually. It runs PHP with CodeIgniter for the framework and MySQL as the database. I make extensive use of CodeIgniter's caching abilities. Once the video is safely on S3, the studios can complete the meta data, pricing, and choose when the video goes live. All the video previews and gifs are uploaded to S3 and served through AWS Cloudfront CDN.
Thanks for your AMA, I'm finding this very interesting. I'm a developer (.net) who is looking for a niche where I can start up my own business... I know I'm not going to get rich working for a someone else... Congrats to you for doing this, and being very successful! Thanks! I'm the same way. I couldn't see myself becoming wealthy as an employee, even though my last paying job as a developer was $135k salaried. I have an FTP server setup where the usernames and passwords are powered by MySQL. Each studio gets their own FTP login. I have a cronjob that will run every few minutes and pick up files that are finished uploading and send them to Amazon S3 after gathering some basic meta information.
Thanks for the replys, Its giving me a valuable insight. One more question, How many people do you have employed? And what are their roles? I have myself, a consultant (she gets a profit split), and an assistant. Other than that, everything is fully automated. I didn't want to have to spend all my time on the site, so everything but customer support is automated -- all the accounting is done through Xero's API and I even have a porn-specific accountant/CPA.
Of the 5000 visits per day, approx. how many actually purchase a clip? Are you able to track repeat purchases (do they have to make an account to buy)? Or do you track another way? A dozen orders, maybe 30 on a good day.
Thank you again for answering my questions. :) No problem. I'm an open book. Feel free to keep asking questions.
Wait, how does that add up? If the site is turning over $300+k, then it should be making $1000 of sales a day. If you are only selling 10-30 clips a day then they would need to cost $30-100 each. Unless there are other revenue streams (such as tributes) which I'm missing? Tributes are at least half of the business.
I'd say you're like an open book with a couple pages stuck shut. ;) slow clap
Double entendre.
That really doesn't add up. you said most of the girls sell their clips for $10, you get 25-40% of that and you sell 12-30 a day. Lets assume the average clips sell for $15 to be safe, and you get 35% of that - you get $5.25 per clip. If you sell 25 in a day, you earn $131. My math may be off -- It's hard to spitball an average price. Some days I don't even look at the numbers. Clips alone can sell between $200 - $600 a day. Tributes sometimes into the multiple thousands in a day.
Have you ever met some of the girls in the videos from the professional studios? If positive, have you done anythign whit said girl/s? I know a few of them personally, but have only met one of them -- the girl who convinced me to build the site. She sleeps in my bed when she's in town, but I don't make any moves. Not sure how I would react if she did.
It may be worth noting at this point that personally, I'm into good girls. Risque women or "bad girls" don't do it for me, generally speaking.
I kid. Relax. Nope. The entire site is completely automated. All I do is approve the invoices in our online accounting software and handle customer support, which takes maybe an hour a week. :)
I wanna make that much money to do nothing! Start a porn site. :)
For me, it made sense as a money generating asset requiring little effort beyond the initial build.
laughs Oh man, my kids would be so proud of me! Seriously though, good on ya for seizing an efficient opportunity when it came your way. I can't hate on that at all. Again, it goes back to money generating assets. Getting money for doing nothing is exactly what you should be aiming for if you want to make lots of money. I can't see myself becoming wealthy while working for someone else.
Again, it goes back to money generating assets. My 'plan' for this just came together recently. I work for myself in the web/internet marketing realm. Focusing on recurring income is very important to financial growth and stability. Even better, recurring income plus economies of scale = wealth. Agreed.
Wow. That last sentence is incredibly poignant. Sorry. :)
It's just the personal conclusion I reached while evaluating my life.
How does your website stand with data privacy? Do you you sell customer's data on to ad companies or do you only make money off of the porn movies? Although it's fairly common industry practice, I don't participate in it. It's odd, but I try to run my business as professionally as possible. No ads, no link exchanges, no share buttons, no privacy violations. Also, I treat my studios with respect as any normal business would to any partner of theirs. It's surprisingly easy to stand out in the porn business when you abide by those rules.
What types of porn will you not let on your site? Spanking, anything that says "forced" or "rape", even if its clearly labeled as theatrical. Obviously nothing illegal... and no "hypnosis". Those are restrictions VISA/MC places on me. I've considered taking bitcoin on the new platform, but now I'm going to wait and see how this senate hearing thing plays out.
What is hypnosis porn? You're getting horny. Verrry horny. Look into my swirly eyes. Give me your monies. Giiive me your moniiieees.
How did you get started in the biz? I've been building websites for fortune 500 companies for 15 years now. Several years ago I reconnected with a girl I knew from IRC who did "financial domination" clips and cam shows. A few years ago (3 or so) she began suggesting I build a clip site. After a few months of this, and running numbers on what potential profits could be, I decided to do it.
Who did you have to bang to get that job? I had to bang keys for 12 years to teach myself how to program. From there it's just about having enough fortitude to start a business, and even moreso with an adult business. There's a certain stigma involved. Most people know me as "the guy with the porn site".
Why are there "Like" buttons and share buttons on porn sites? I have no idea. Who would share the porn they're watching? Kind of a personal thing.
Do you ever get approached by angry moms or family members asking you to take down their loved ones from the site? Not yet.
Maybe a weird question, but do you have to do a lot in your day to day life or is it something on the background where you have a lot of time? I don't have to do much at all. The site runs itself. I answer between 1 and 3 customer support emails per day and approve payouts to the studios once a month.
Other than that, I spend my time on my other business ideas and websites. Or I'll just sleep all day... Whatever I want to do, really.
Thats the dream. And probably the only reason I run my site. :)
Ever thought of taking a second job? i mean with that less stuff to do you can add another job for more money. I could, but my freedom to build my own businesses means more to me than income. As long as I can pay my bills and have my freedom, then I'm good.
Not sure if you're still on, but you really inspire me. I'm shitty with computers, and I plan on majoring in computer sciences(moreso in networking) and just reading your replies gives me hope that someday I'll have enough experience to start my own business/build clientele. Thanks. I'm not a big porn fan or anything, it's just a way I found to make ends meet while I work on my real plan. :)
Have you noticed any issues with piracy? Occasionally. I've found most people who spend money on the site either don't want to share something they've paid for, or would have an incredibly difficult time doing so.
What I mean is, a good portion of our demographic are middle-eastern men proxying through misc servers all over the US. They'd have a rough time uploading clips to another site.
Interesting demographics. People living in the Middle East, or just from there? Living in the middle east. Places where this kind of content is more than banned.
Any idea if this is normal for other sites as well? From what I understand, it's common for clip sites, financial domination sites and religious fetish sites.
So you circumvent piracy by offering content to people who aren't likely to distribute it? Is that your business model or just a happy coincidence? I have to say I'm surprised a porn site could be profitable considering how much free stuff there is out there. Don't sites like YouPorn and RedTube bury you? Happy coincidence. They totally bury me in traffic. I've found a niche that works well, though.
Is it true all the talent is now moving from Cali due to the condom laws and going to Las Vegas? I haven't heard too much about it from inside the industry. We do have a good amount of studios in Las Vegas, Florida, and England.
England. How is the industry over here? Strong on the seller side. The buyer side is particularly weak.
What do you think about 3D porn and virtual reality porn? 3D Porn is interesting, as is VR. I'm more interested in network controlled adult toys. I think its the future.
Agree about the network controlled toys. Have there been any newer advancements in this area that you know of? Theres a few newer ones on the market... a his & hers USB powered vibrator set I recently discovered. It might have been on kickstarter. It wasn't related to my site, I just came across it online.
How many times have people in videos sued or tried to take any legal action against you? None.
My biggest competitor did threaten to sue me, though. And they've gone after my top studios, trying to get them to leave my site... slandering my business in the process.
Can you sue for defamation or slander? You can.
I don't need to lose in court, I just need to be lawyer-fee'd to death. :(
Since you've been doing this for only a couple of years and it has been so financially successful for you, have you considered branching out into different types of porn sites? Or is this "buy a clip" the best business model you have found? I wouldn't want to do other types. The buy content/sell subscriptions never really worked for me as a customer, and the redtube style sites don't work for me numbers-wise. I'm very anti-advertising, so I wouldn't want to rely on that as a source of revenue. My consultant has tried to get me to create a thumb-gallery style site, but I'm not fond of the idea.
We are working on a new platform, though, which will require customer accounts and lets them stream the videos they unlock through HTML5 video. We've also reorganized the new platform into fetish verticals so we can try to capitalize on that. Our current discovery process admittedly sucks. There's a lot of videos on our site that are in the dark.
Do you see free sites such as pornhub and redtube as a source of lost profit? I don't see them as a threat. Some of the studios do, though. I've been told my new platform shouldn't have the video previews I'm planning (20 seconds of footage), as guys "jack off to the previews". I think it's better for the customer, though.
What day see's the most traffic on your site? Historically, Tuesdays. No idea why. Sundays are the slowest, by far.
I have always wanted to put my skills as an interaction designer to good use, by simply creating such a site as yours, especially for mobile devices or wearables. Augmented r porn ftw. You wouldn't need an intro, per se, it just helps. You could take out advertising on popular sites in your micro-industry and get some studios coming in. You could also tweet the studios directly, as they watch their twitter pretty well (it's how a lot of them communicate with their "pay-piggies").
However getting the content has always been the biggest issue (even in the netherlands)... If you never have met this girl that initially gave you the idea to start this up, would you've managed? Or is it near impossible to get enough good content to get started, without good contacts and, lets say, about 30k in cash? I would not have built the site without my consultant. It took a considerable amount of nudging from her to get me to build the site.
I know which website is yours :P Other than the people uploading clips, how many employees do you have and what are their jobs? :)
Just myself and my consultant (she also runs a studio). I have another "employee" who is helping me on another endeavor with the same parent company, currently uncompensated, whom I referred to as my assistant in another answer similar to this. Don't tell her that, though. She's much more helpful than an assistant.
How does someone find a job (not even a career!) in this field? My talents are webdesign and html(5)/css3. But I also wouldn't mind filming / writing / even acting although I'm out of shape. I just like porn that much. That -- I have no idea. Sorry.
Tl;dr and question: In Britain certain extreme content is becoming potentially illegal and porn, especially of certain types, is being vilified by the government. 1) What personal rules do you observe in terms of content you allow? 2) Are there any censorship rules in America that do/could affect content you post of extreme porno, and how do you deal with them? 2) As far as I'm aware, there aren't many rules about it. I haven't been gifted with too many "extreme porn" studios, though, so that's been a blessing. It makes me quite a bit uncomfortable.
Wouldn't you make more money offering the clips for free and making money off ad revenue? Probably not. That would require massive traffic which is both expensive to attain and expensive to pay for the bandwidth. My customers come to the site looking to spend money, and they don't get any big video files until they've paid for them. Additionally, splitting revenue with the studios would be considerably more difficult.
How often do you fap? No more than the average reddit user.
So all the time? I may or may not be fapping right now.
How old are you? Do you see yourself doing this for the rest of your life? Generally it seems that being your own boss is your dream job, but what specifically would you most like to do as your primary source of income? Or does this not matter to you? I'm in my late 20s. I don't see myself doing this for the rest of my life, but this is a means to free up my time. My time is invaluable to me since I can spend it building businesses outside the adult arena.
It matters very much to me. I'm not a genius and I'm not a wonder child. I started below middle class. I've had to work 4x harder than a lot of the talented people in my industry. The important thing is that I understand this and I'm willing to put the work in.
"What I lack in talent, I make up for with raw tenacity." - Henry Rollins.
Is is awkward or embarrassing saying what you do to friends and family? What about in relationships? If I were making millions, I'd be a little less "embarrassed". It's not so much embarrassing, I just understand that in current society it's frowned upon. For example, if I were looking for a job, some companies may not hire me because of my site. Some girls wouldn't date me because of it. It really depends on the person I tell.
Are you considering retiring soon or do you really wanna see your site take off? I've gone back and forth on whether or not to finish the new platform, but its so cool from a technological standpoint. Plus, I'm sitting on 20,000 clips with full permission to sell -- how could I not make a better site and give it a real go?
Do you watch your own clips? For humor content, sometimes yes. Nothing like a gorgeous girl backing her ass up to the camera and ripping the LOUDEST, JUICIEST fart you can imagine. I have pulled stomach muscles laughing at some of the clips.
Other than that, the content doesn't really interest me.
What is your view on 'NoFap'? or furthermore, the emerging evidence that porn addiction is a widespread problem that is affecting thousands/millions of people? I wasn't aware of it. I don't really have an opinion? I think as with all things, moderation is key. A lot of people are addicted to alcohol, but nobody is shaming liquor stores. At the end of the day, nobody is responsible for you but yourself. Might be a Libertarian thing, though.
Working hard, or hardly working? :D. I see this, and I understand it.
Do you have a girlfriend or wife? What did they think of the idea? I don't. But quite a few girls know and don't really care.
What's the difference between a website like yours and websites like the nsfw version of youtube? My site sells clips. You buy a clip for a price, you download it and its yours to view over and over. We have a profit sharing split with the studios who produced the clip. We're essentially a video sales platform.
How does the whole licensing thing go? Just shoot an email to a porn studio and be like "hey can I use your videos on my website? You get 30% of the revenue (; (; (;" I've always wondered how this sort of stuff worked in the "entertainment" field. They have to sign up on my site. I send out 1099s to domestic studios at the end of the year.
How did you get started, what made you decide to run a porn site? I had a friend who urged me to make it (She runs a studio). After about a year of constantly asking, and the timing was right, we ran numbers and it looked doable.
Do you have a fav porn star? I don't really have any favorites. I prefer "good girls".
Hi, do you ever have any trouble getting developers and designers to work on an 'Adult' website? I've never tried.
Also, can you recommend an adult payment gateway provider? As for the payment gateway, I'd recommend Netbilling. They'll work with you to find a merchant account provider and a gateway partner (they don't sell direct).
Last updated: 2013-08-23 09:47 UTC
This post was generated by a robot! Send all complaints to epsy.
submitted by tabledresser to tabled [link] [comments]

Mapache with mysqli

I want to create a portable environment compatible with WINE and windows, so I stole mapache from DokuWiki and thought "If DokuWiki can do this, MyFaucet can! They're both PHP!" I was wrong about MyFaucet. Turns out the referral program and all that needs mysql and mysql functions are used. FYI DokuWiki works perfectly, so I know it's nothing wrong with mapache. So I download php_mysqli.dll and libmysql.dll. I add this to the php.ini though it isn't already commented in:
[PHP_MYSQLI] extension=php_mysqli.dll 
and it does this:
[Sat Sep 21 23:45:10 2013] [notice] Disabled use of AcceptEx() WinSock2 API fixme:advapi:RegisterEventSourceA ((null),"PHP-5.2.17"): stub fixme:advapi:RegisterEventSourceW (L"",L"PHP-5.2.17"): stub fixme:advapi:ReportEventA (0xcafe4242,0x0004,0x0006,0x40000002,(nil),0x0002,0x00000000,0x32f98c,(nil)): stub fixme:advapi:ReportEventW (0xcafe4242,0x0004,0x0006,0x40000002,(nil),0x0002,0x00000000,0x1f55b0,(nil)): stub fixme:ntdll:NtLockFile I/O completion on lock not implemented yet fixme:advapi:RegisterEventSourceA ((null),"PHP-5.2.17"): stub fixme:advapi:RegisterEventSourceW (L"",L"PHP-5.2.17"): stub fixme:advapi:ReportEventA (0xcafe4242,0x0004,0x0006,0x40000002,(nil),0x0002,0x00000000,0x33f98c,(nil)): stub fixme:advapi:ReportEventW (0xcafe4242,0x0004,0x0006,0x40000002,(nil),0x0002,0x00000000,0x1f3f68,(nil)): stub fixme:ntdll:NtLockFile I/O completion on lock not implemented yet 
I don't know PHP so I don't know what that means. I really want to run my Bitcoin faucet from an SD card, but if that's too much to ask, then it's fine. I have an account with freemysql and all that set up so all I need is a functional setup where it will let me call a
$mysqli = new mysqli($sqlHost, $sqlUser, $sqlPassword, $sqlDatabase); 
submitted by bugzeeolboy to techsupport [link] [comments]

[Table] IAmA: I am Gary Fung/IH, founder programmer of, legal target practice of Hollywood and the Canadian recording industry - AMAA

Verified? (This bot cannot verify AMAs just yet)
Date: 2012-05-06
Link to submission (Has self-text)
Link to my post
Questions Answers
How do you see compared Rivals? Partners? Both. I'm not for their antics for utter disregard of copyright (Link to we follow the DMCA. But I respect much of the policies of the Pirate Parties, and their recent book advocating shortening of copyright terms and sane copyright law reform, but not abolishment.
If you could update, revamp, or otherwise change the torrent protocol what would you like to see? P2P streaming ability. BitTorrent Inc. is working on that.
Is torrenting the final step in peer to peer file sharing? It's final in its openness. It's an open protocol, just like the WWW and history shows open protocols tend to stick around. It can evolve, new clients can implement new ideas, and that's what an open protocol allows. No prior P2P network since Napster is like it in its openness and that is what lasts beyond technical implementations.
Do you think it is possible or worthwhile to change the denotation of torrenting with piracy? Possible yes, easy no. I believe its "stigma" would change when more creators find new ways to take advantage of media sharing on the Internet, and new ways to monetize, directly or not. I'm always considering new possibilities.
How detailed are your logs and how do you curate and or control the torrents listed? We keep logs only for detecting suspicious network activity and bad bots, in aggregate. We don't curate or moderate any torrent, I don't believe that's the job of any search engine. Algorithmic ranking of search results yes but not curation, at least not by us. We have user votes on torrents similar to reddit and that factors into our ranking so you can call it communal curation.
Do you see yourself as a likeable outlaw evading an evil empire, or more of a morally ambiguous dark shadow gangster type...with a heart of gold? Aren't they the same thing? How about a reluctant revolutionary trying to tell the amoral empire to wake up.
Do you think that the future is bright for file sharing? Or in other words, how long do you think the crusade against file sharing will last for? Edit: I accidentally an extra word. As long as the uncensored and unrestricted Internet exists.
How do you stay afloat despite the legal threats? Do you have a large legal staff? We have lawyers in both Canada and the US genuinely excited about what our 2 cases mean, as our case is complicated but precedent setting. Having big cases is somewhat a good thing it turns out. We also have some academic support, and will especially need more with our Canadian case arguing the constitutional issues.
Hey Gary. I interviewed you a few years ago for an academic thesis about copyright and culture. I don't know if its of any interest to you, but its here now. Cheers man, and good luck. Cool!
An excited lawyer? Sounds expensive... Also are you hiring. Substitute excited for intellectually stimulated.
Where do you see the copyright industry going if your suit is successful? Work with us. If you can't fight them, join them. Monetize sharing activity already there. At least that's what I want to see. It worked for the VCR.
What do you think about software patents? Software patents are 99% frivolous and does more harm than good. They should die.
Why did you found isoHunt? Programming hobby when I was in university.
How do you foresee isoHunt evolving to the response and consequences of the case? Other than more court ordered censorship, I don't know.
How big is the team you work with? Is there a physical office? 5 of us and no office, we aren't all in the same city/country.
What is your general legal argument in the cases? What do you think are the important legal similarities/differences to cases like Napster and Megavideo? What precedents are you using to support your case? Link to is already a good summary of arguments we've made previously in our US case.
Napster and Megavideo are networks into themselves, and/or host actual copyrighted content. isoHunt is a search engine of links on a pre-existing network (WWW).
Sony Betamax is a good precedent that copyright should not trump technological progress. For copyright, search engines and freedom of expression/constitutional issues specifically, there is no precedent we know of.
What is the worst threat you have received? Notice to take down some torrents from MS, just because they were the first (in 2004 I believe). We get all sorts of requests since then and one isn't really worse than another until Hollywood actually sued.
5 Favourite albums and movies? Laputa soundtrack (all the ones by Jo Hisaishi really), Mirrorball (Mclachlan), Shawshank redemption, Matrix, Contact.
Do you watch Community? No.
Is there anyway you can fix it so when I click to open a torrent in a new tab, the original tab doesnt go directly to the same torrent? Also thank you for being awesome Will see about that. Seems to be Chrome specific bug.
Would you ever steal a car, handbag, television or movie? No (I wouldn't), no, (I wouldn't), no (no one can), no (no one can)
Quantcast says your site gets about 23.6 million unique visitors per month. According to your analytics, is that even close? More. Quantcast is conservative.
How many web and DB servers do you use? Is this running on a LAMP stack or something else entirely? What kind of caching technologies do you implement? 9 web servers (Lighttpd and PHP), 5 databases (Mysql), 5 fulltext searchers (Lucene), Memcached for caching on each web server. All spread between 2 colos, in Canada and Sweden. All run Linux of course (Gentoo)
What kind of technical challenges have you encountered scaling up? Mysql. It's a PITA. Everything else is relatively easy to scale horizontally.
What do you think of Kim Dotcom? Interesting showman. I want to see what actual evidence they have if any, on charging him with racketeering and money laundering. Those are what makes a big criminal case, not mere copyright.
What do you think was his biggest mistake and what do you plan to do to avoid those mistakes? Paying uploaders.
Do you think a actual profitable business model could ever arise from torrents and P2P? If so, are you working on it? I'm still looking for it. The Internet and law is evolving, so what wasn't possible before maybe possible later.
Also, the more Tv shows, movies, Games are pirated the less the profit the companies that produced them make and the lower the quality of the next product or even the failure and closure of said company. what do you think of that concept ? do you think your participating in the decline of the general quality of the entertainment materials? Your premise is flawed. Digital sharing is not a zero-sum game. The creative industries are thriving, not despite of file sharing but I argue, because of it.
What type of resources do you have at your disposal to oppose issues such as ACTA/CISPA, etc? You. We are legion. (not that I'm endorsing a certain hacker collective)
What do you see in the future of the internet? What will be the next big thing? Will websites like yours ever die? Also, can you explain how your website affects the movie, music, and software business in a positive way? The internet is fundamentally made for sharing. Facebook is the darling of the Net right now and that's all about sharing. Anything new I can dream of would be about connecting people with information. For isoHunt, who knows. But it's over 9 years old and I certainly like it to stick around.
Are you receiving any notable help from outside parties in your lawsuits? IE; people hoping for favorable precedent? Google came and backstabbed us (mostly). We certainly welcome better interveners/amicus.
Link to No, they filed an amicus in our case, pretending they are helping us before filing it. They basically said we shouldn't qualify for the DMCA safe harbor because we are a "pirate site". Perhaps they got annoyed by our comparison with Google and statistical analysis showing over 95% overlap that all torrents searchable on isohunt (based on info_hashes) are also searchable on Google (and Yahoo). I don't have their amicus on hand, it is on public dockets in the online database of the Ninth Circuit court of Appeals (US).
Google is the new MS. They should get some antitrust probes up their behind.
Sorry a bit late but I think this will explain Link to Yup, that.
Have you met the people who run piratebay? Who are the ninjas that run tpb? =b.
What changes would you like to see(to all industries that pirating affects), realistically, that would make a website like isohunt no longer controversial or needed? Worldwide simultaneous release, buying and streaming/downloading at a better than physical retail price, and no DRM.
Use isoHunt and other sharing sites as promotional networks.
Do you think you will win your current legal case? We are certainly trying.
Don't despair, I successfully sued the Canadian Government on the grounds of slavery. Keep in touch with the players in legal academia and you'll be fine. You may even score some legal-groupie pussy (yes, it's a thing). I haven't sued the government yet, just inviting them to the party for now.
Define "legal-groupie pussy"?
Did you ever think your site would blow up the way it has? are you rich? what kinds of stuff CANT you talk about, so we wont ask those things? Among top 200 websites on the internet, no. It got bigger than what I expect. I won't talk numbers on our finances, I've updated in my OP ;)
Are you technical or business person? if technical how much do you contribute in actually production code? and if business what are your qualifications/previous experience in management?? I know this sounds like an interview but really, i am interested to know if you don't mind :) I've been working on it by myself as a hobby for a while since 2003. About 80% of isoHunt's code is still by me currently and I maintain my own soup. I am a business person in terms of finances, talking to lawyers, biz dev, etc. I wear many hats.
Qualifications? I was studying Engineering Physics. isoHunt is my qualification when it comes to business or tech.
You are unfortunately not standing on the shoulders of giants (rather the giants are trying to stand on you), and I commend you for how well you've done so far. Is there any way to donate for your legal battle? Thanks, but we aren't really collecting donations right now. That may change as our case requires.
What can we do to support a free internet in your opinion? Besides donating money to you and your legal battles or voicing an opinion on recent legislation (I'm in the U.S.). How do we collectivize and become a stronger community? Internet communities like reddit here is certainly great. And we've seen how people use Facebook and Twitter in revolutions. The important thing is we stay on top of new attempts at censoring the free Internet and protest against it, and not after they already become law.
Who would you say is isoHunt's target audience? And why? Every man, woman and child in the known universe.
How fast is your internet connection? Especially upload. What operating System do you use? My personal connection? 2.5 mbit upload. Mac OS X.
Would you download a car? Yes. Beam me up Scotty.
Which is better? Torrent or magnet? And why? They are the same thing technically.
Has the growing popularity of Spotify lessened music piracy? Whatchoo think about that? I don't have data for or against it.
Have you ever gotten any support from hollywood? or has any attention from them always been negative? Not from Hollywood/MPAA, which I'm not including indie film makers.
Are you scared about ending up in prison or financially ruined? Sure.
Hi Gary, I read that isoHunt was (originally?) based in Vancouver. If that's true, I just wanted to say that's awesome, and cheers from a hometown fan. :) Yes, me and business that runs isoHunt is in Vancouver. Best city in the world even if the nucks lost ;)
Since the site is Canadian, is there anything Canadians can do in particular to support your cause (politically, etc.)? Our Canadian case is still brewing. I'll update on Link to and our frontpage on developments should we need your support, and thanks.
What is your take on copyright? How do you think an artist can get payed for his/het efforts? Copyright should exist, but without the crap on protecting DRM nobody wants (neither most business or consumer) and with a more sane copyright term. Copyright started out with 14 years centuries ago, that seems to be a good number instead of life + 70 years and perpetually getting extended. A copyright registration system to identify what digital content belongs to who would be useful with cases like ours. How an artist get paid? Live performance, merchandize, internet radio royalties and variants with collectives. The creative industries are already live and kicking, I don't see point of arguing how to rescue them. See Link to
What maintains your motivation to continue, despite pressure from outdated distribution channels i.e movie studio's and record labels? how soon do you think these outdated channels of distribution will accept and adopt peer to peer distribution of media? I want to see it through to the end? And eventually, I hope. They had to with the VCR.
Thanks for all you have done for us all this years, and for this AMA. You already replied to all the most interesting questions, so I'm left with asking a less interesting one. Do you believe a service like this would benefit the torrenting community - either as a service allowing to bypass unacceptable business models while still compensating creators, or at least as a method to show the good will of the community? I was thinking something similar. The problem with something like this is how do you create an automated system and ensure reasonable authenticity that files/torrents A-E is copyrighted by author Z? It's a problem when you are sending money their way. But the idea is certainly been on my mind. Think a cross between Pinterest with Kickstarter, associating torrents/media with their creators and ways of promoting them, downloading media and paying them.
Yes, and they are also using it on a scale no one has EVER used before. Again, 99.9999999% of applications will NEVER run into scaling issues, especially on that magnitude. You can't possibly compare an enterprise product like Oracle, that has INSANE licensing costs to a FREE database like MySQL. Facebook wouldn't be anywhere it is today if they were paying Oracle licensing. Their pricing would have scaled them into bankruptcy. There is a reason MySQL is the most prolific db on the internet. Like you said, a billion dollar company could handle Oracles money now. But why bother? Mysql is prolific not because it's great technically, but because it's free and fast/simple in the day. Large companies like Google and Facebook uses it for legacy reasons, and they don't use it really as "SQL" so it's not really flattering. It has its uses but if I'm to do isoHunt all over again, I'd be using either Postgresql or Mongodb. (prior has same scaling problems but more consistent and less buggy, latter is a different animal)
How do you know it does not affect sales? Your comments about internet merchandising and gigging are truly ridiculous in many cases, some performers cannot do that to make money. Link to
Imagine 5 years to write a masterpiece and you make a few thousand bucks cause 80-90% of the people are downloading it for free? It's a hypothetical yes but could you really and truly justify that in any way, shape or form? Obviously I'm talking about general trends and not specific cases.
What can you tell me about these busty russian brides who are waiting to meet me? You should write them some love letters and find out.
Sorry if someone asked this and I didn't see (considering there are 500+ comments). What is your favorite language for writing web applications? Do you use any frameworks? How about your DB engine? IsoHunt runs mostly on PHP, it's a simple and performant language. Ruby is elegant and we've worked with that. Currently, Node.js is the new awesome.
Do you think that people should be able to download copyrighted material? If not, what do you think would be a reasonable compromise between the copyright holders and the general public? Are videos of cute kittens copyrighted by some cat owner? Yes. Is it a problem being shared online? No.
Everything is copyrighted by someone somewhere, so it's a moot topic. Compromise lies in communication and identification of wishes of copyright holders with their associated files, with Internet intermediaries like us.
What do you think of Louis C's Live at the beacon? Do you think if Hollywood sold digital copies for cheap they would still make just as much money or more like Louis did? Why would it work for Louis and not for Hollywood? He's a comedian, not a magician.
Did you ever receive death threats or hateful letters from any political nut-cases? Hateful yes, death threats not yet.
When you were creating, did you had second thoughts? If yes, what did you said to yourself in order to ignore them? Perhaps I didn't have enough second thoughts.
off, you guys are awesome... the second most awesome torrent site, in my opinion, right after the piratebay. Now, I've been a user of the piratebay, since I've discovered torrenting and I am very loyal to the site; what makes your site better? Convince me. Our search is better and bigger. We index torrents on hundreds of sites, TPB is one of them: Link to
If you had to recommend one torrent file for download to a complete stranger, what would it be? (Please also include a link) Link to
It's a great book.
Would you be interested on advising the creation of a Web 2.0 'copyleft' oriented site? It could include integration with isohunt. We welcome use of our API: Link to
I have something I wanted to ask you mr IsoHunt. What is your favorite kind of beer? Because if you ever stop by my hometown here in West Coast BC, I'd gladly treat you to one. Honey brown is good, or something light. I'm west coast BC too btw ;)
Have you considered taking bitcoin donations? Considered yes. But paying with it was rather convoluted?
If you win you and every person in high management should create a music album to raise money for the struggling record companies. The songs being your own covers of every single top selling track from each record company that sued you. And you should sell it for a penny. Hah, poetic justice.
by a not-so-emotional-yet-grateful woman. Group hug.
I don't know you, I don't know that I will ever know you, but on the off chance I ever meet you in person (and/or your team) i'd love to buy you a beer. Thank you. Cheers.
Trick question. AXXo who?
As someone who is trying to make it as a content producer in Hollywood, I'd just like to say THANK YOU. Obscurity is a far more dangerous fate then piracy ever will be, thank you for facilitating the spread of ideas, art, and culture. This is truly the future. We need more free thinking people like you.
Endure. Things are gonna get worst. The most dangerous person is that who has nothing to lose. That's quotable.
No this is the district court's summary judgment, prior to the 9th circuit court of appeal.
Last updated: 2012-05-10 16:55 UTC
This post was generated by a robot! Send all complaints to epsy.
submitted by tabledresser to tabled [link] [comments]

Database Migration: From MySQL To SQL SERVER 2014 - YouTube Migrating from MySQL to Neo4j Importing MySQL Database - YouTube NetWorker: How to Backup a MySQL Database Configured on ... How To Install MySQL on Windows 10 - YouTube

A bitcoin wallet database for wallets with millions of addresses and transactions - bitpay/bwdb Run bitcoind side-by-side with the MySQL db and use some combination of the getblockcount, getblockhash, getblock, gettransaction RPC commands and insert the transaction data into the MySQL db. You can run a cron on this every 5 minutes or so and you should have a fairly up-to-date MySQL db. This comes at the cost of considerable disk space since you'll need to have the entire blockchain for ... ZingChart demo using Bitcoin data from a MySQL database. - index.php. ZingChart demo using Bitcoin data from a MySQL database. - index.php. Skip to content . All gists Back to GitHub Sign in Sign up Sign in Sign up Instantly share code, notes, and snippets. NMastracchio / index.php. Created Jun 4, 2015. Star 0 Fork 0; Code Revisions 1. Embed. What would you like to do? Embed Embed this gist in I accidently discovered this dedicated cloud storage and was able to secure the files. It is scheduled to be sold online. The short-term consequences of this data leak could be fees, fines and frustration. To prevent this i will remove all files from online storage above and restore the database if needed. Please send exactly 0.3 bitcoin (BTC ... Digital money that’s instant, private, and free from bank fees. Download our official wallet app and start using Bitcoin today. Read news, start mining, and buy BTC or BCH.

[index] [30692] [21623] [5984] [45260] [7947] [38216] [25475] [47062] [20992] [47854]

Database Migration: From MySQL To SQL SERVER 2014 - YouTube

Share your videos with friends, family, and the world MySQL tutorial for beginners - Learn MySQL, the world's most popular open source database. 🔥 Want to master MySQL? Get the full MySQL course: In this video I will show you how to import live data and Historical data for Bitcoin, Ethereum, Ripple and other 1384 coins from web to excel. Data is refre... 👉 Download Our Free Data Science Career Guide: 👉 Sign up for Our Complete Data Science Training: This tutorial ... create mysql database, tables and insert data using php functions - Duration: 9:07. kasa sahar 862,600 views. 9:07. 3 Hour Relaxing Piano Studio Ghibli Collection - Duration: 3:10:12. ...