Leaderboard

Subtitles, where to get them V2 - Tutorial Most used sites for subtitles : [Hidden Content] and [Hidden Content]. They support most languages, and is your best bet on finding subtitles if they are released. However feel free to read the bottom line and tip me if you know of something else Lets make this the best subtitle thread on here! Anime English subs Japanese subs Multi-Language [Hidden Content] [Hidden Content] [Hidden Content] [Hidden Content] Subtitles Search Engines [Hidden Content]en/search [Hidden Content] [Hidden Content] [Hidden Content] [Hidden Content] [Hidden Content] [Hidden Content] [Hidden Content] TV show subtitles [Hidden Content] [Hidden Content] [Hidden Content] DivX/HDTV/DVD Specific site [Hidden Content] [Hidden Content] [Hidden Content] Subtitles 4 Specific Countrys (Arabic) (Bulgarian) (Dutch) (Dutch) (Finnish Subtitle forum) (German) (Swedish) (Swedish) (Chinese) (russian) (Greek) (Japanese) Few More Sources: [Hidden Content] [Hidden Content] [Hidden Content] (For all YIFY releases) [Hidden Content] [Hidden Content] [Hidden Content] - subtitle search engine [Hidden Content] - Subtitles for Bollywood movies [Hidden Content] - Greek Subtitles [Hidden Content] - Dutch Subtitles [Hidden Content] - French Subtitles I've sorted out the bad(non working) links, and i plan on adding more! however, if you find anything that's missing, or something you want added, PM me and il add it to this Subtitle list!

MySQL Export Table to CSV Summary: in this tutorial, you will learn various techniques of how to export a MySQL table to a CSV file. The CSV stands for comma separated values. You often use the CSV file format to exchange data between applications such as Microsoft Excel, Open Office, Google Docs, etc. It will be useful to have data from MySQL database in CSV file format because you can analyze and format the data in the way you want. MySQL provides an easy way to export the query’s result into a CSV file that resides in the database server. Before exporting data, you must ensure that: The MySQL server’s process has the write access to the target folder that contains the target CSV file. The target CSV file must not exist. The following query selects cancelled orders from the orders table: SELECT orderNumber, status, orderDate, requiredDate, comments FROM orders WHERE status = 'Cancelled'; To export this result set into a CSV file, you add some clauses to the query above as follows: SELECT orderNumber, status, orderDate, requiredDate, comments FROM orders WHERE status = 'Cancelled' INTO OUTFILE 'C:/tmp/cancelled_orders.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n'; The statement created a CSV file named cancelled_orders.csv in the C:\tmp folder that contains the result set. The CSV file contains lines of rows in the result set. Each line is terminated by a sequence of carriage return and a line feed character specified by the LINES TERMINATED BY '\r\n' clause. Each line contains values of each column of the row in the result set. Each value is enclosed by double quotation marks indicated by FIELDS ENCLOSED BY '”' clause. This prevents the value that may contain a comma (,) will be interpreted as the field separator. When enclosing the values by the double quotation marks, the commas inside the value are not recognized as the field separators. Exporting data to a CSV file whose filename contains timestamp You often need to export data into a CSV file whose name contains timestamp at which the file is created. To do so, you need to use the MySQL prepared statement. The following commands export the whole orders table into a CSV file with timestamp as a part of the file name. SET @TS = DATE_FORMAT(NOW(),'_%Y_%m_%d_%H_%i_%s'); SET @FOLDER = 'c:/tmp/'; SET @PREFIX = 'orders'; SET @EXT = '.csv'; SET @CMD = CONCAT("SELECT * FROM orders INTO OUTFILE '",@FOLDER,@PREFIX,@TS,@EXT, "' FIELDS ENCLOSED BY '\"' TERMINATED BY ';' ESCAPED BY '\"'", " LINES TERMINATED BY '\r\n';"); PREPARE statement FROM @CMD; EXECUTE statement; Let’s examine the commands above in more detail. First, we constructed a query with current timestamp as a part of the file name. Second, we prepared the statement for execution by using PREPARE statement FROM command. Third, we executed the statement by using the EXECUTE command. You can wrap the command by an event and schedule the event run periodically if needed. Exporting data with column headings It would be convenient if the CSV file contains the first line as the column headings so that the file is more understandable. To add the column headings, you need to use the UNION statement as follows: (SELECT 'Order Number','Order Date','Status') UNION (SELECT orderNumber,orderDate, status FROM orders INTO OUTFILE 'C:/tmp/orders.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n'); As the query showed, you need to include the column heading of every column. Handling NULL values In case the values in the result set contain NULL values, the target file will contain "N instead of NULL. To fix this issue, you need to replace the NULL value by another value e.g., not applicable ( N/A ) by using the IFNULL function as the following query: SELECT orderNumber, orderDate, IFNULL(shippedDate, 'N/A') FROM orders INTO OUTFILE 'C:/tmp/orders2.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n'; We replaced NULL values in the shippedDate column by the N/A strings. The CSV file shows N/A instead of NULL values. Exporting data to CSV file using MySQL Workbench In case you don’t have access to the database server to get the exported CSV file, you can use MySQL Workbench to export the result set of a query to a CSV file in your local computer as follows: First, execute a query get its result set. Second, from the result panel, click “export recordset to an external file”. The result set is also known as a recordset. Third, a new dialog displays. It asks you for a filename and file format. Enter the file name, choose CSV as the file format and click Save button. [Hidden Content] The CSV file exported by MySQL Workbench supports column headings, NULL values and other great features.

How to set up Bookmark RSS Feed in utorrent - Tutorial Make sure you have nothing in your bookmarks to start with unless you want to download them Click RSS Button Then select Bookmarked Torrents Scroll down and make sure it is on Download link Then click Get RSS Link Now open utorrent then right click Feeds selecting Add RSS Feed.... Then copy and paste your Bookmark Rss Feed here Selecting the Automatically download all items Now hit Ok Now when you add a bookmark onsite and your feed updates in your client it will automatically download it

This tutorial works for almost any site thanks m8

Seedbox From Scratch - Tutorial The Seedbox From Scratch Script Current version = 2.1.9 Last stable version = 2.1.8 This is a script I've being working for some time now. I decided to share it here because it has some good things to add: A multi-user enviroment, you'll have scripts to add and delete users. Linux Quota, to control how much space every user can use in your box. Installed software ruTorrent 3.4 + official plugins rTorrent 0.9.2 or 0.9.3 (you can choose, downgrade and upgrade at any time) Deluge 1.3.5 or 0.9.3 (you can choose, downgrade and upgrade at any time) libTorrrent 0.13.2 or 0.12.9 mktorrent Fail2ban - to avoid apache and ssh exploits. Fail2ban bans IPs that show malicious signs -- too many password failures, seeking for exploits, etc. Apache (SSL) OpenVPN PHP 5 and PHP-FPM (FastCGI to increase performance) Linux Quota SSH Server (for SSH terminal and sFTP connections) vsftpd (Very Secure FTP Deamon) IRSSI Webmin (use it to manage your users quota) sabnzbd: [Hidden Content] Rapidleech ([Hidden Content]) Main ruTorrent plugins autotoolscpuload, diskspace, erasedata, extratio, extsearch, feeds, filedrop, filemanager, geoip, history, logoff, mediainfo, mediastream, rss, scheduler, screenshots, theme, trafic and unpack Additional ruTorrent plugins Autodl-IRSSI (with an updated list of trackers) A modified version of Diskpace to support quota (by me) Filemanager (modified to handle rar, zip, unzip, tar and bzip) Fileupload Fileshare Plugin ([Hidden Content]) MediaStream (to watch your videos right from your seedbox) Logoff Theme: Oblivion Before installation You need to have a "blank" server installation, if you have a Kimsufi, just do a "reinstall" on it, using Ubuntu Server 12.04. After that access your box using a SSH client, like PuTTY. Warnings If you don't know Linux ENOUGH: DO NOT install this script on a non OVH Host. It is doable, but you'll have to know Linux to solve some problems. DO NOT use capital letters, all your usernames should be written in lowercase. DO NOT upgrade anything in your box, ask in the thread before even thinking about it. DO NOT try to reconfigure packages using other tutorials. How to install Just copy and paste those commands on your terminal: wget -N [Hidden Content] time bash ~/seedbox-from-scratch.sh You must be logged as root to run this installation or use sudo on it. Commands After installing you will have access to the following commands to be used directly in terminal createSeedboxUser deleteSeedboxUser changeUserPassword installRapidleech installOpenVPN installSABnzbd installWebmin installDeluge updategitRepository removeWebmin upgradeRTorrent installRTorrent restartSeedbox While executing them, if sudo is needed, they will ask for a password. Services To access services installed on your new server point your browser to the following address: [Hidden Content] IP or Server Name>/seedboxInfo.php OpenVPN To use your VPN you will need a VPN client compatible with OpenVPN, necessary files to configure your connection are in this link in your box: [Hidden Content] IP or Server Name>/rutorrent/vpn.zip` and use it in any OpenVPN client. Supported and tested servers Ubuntu Server 12.10.0 - 64bit (on VM environment) Ubuntu Server 12.04.x - 64bit (on VM environment) Ubuntu Server 12.04.x - 32bit (OVH's Kimsufi 2G and 16G - Precise) Ubuntu Server 12.04.x - 64bit (OVH's Kimsufi 2G and 16G - Precise) Debian 6.0.6 - 32 and 64bit (OVH's Kimsufi 2G - Squeeze) Debian 6.0.6 - 32 and 64bit (on VM environment) Quota Quota is disabled by default in your box. To enable and use it, you'll have to open Webmin, using the address you can find in one of the tables box above this. After you sucessfully logged on Webmin, enable it by clicking System => Disk and Network Filesystems => /home => Use Quotas? => Select "Only User" => Save Now you'll have to configure quota for each user, doing System => Disk Quotas => /home => => Configure the "Soft kilobyte limit" => Update As soon as you save it, your seedbox will also update the available space to all your users. Changelog Take a look at seedbox-from-scratch.sh, it's all there.

How to Port Forward - The quickest way - Tutorial This guide is the easiest way by far to forward your port whether you've done this before or are a beginner. First off let's see if you need your port open. Go to this site and enter your port you use for your torrent client. Is your port open This is the perfect way of finding out if your port is open, if it says it is, then it is. You don't need to worry about forwarding your port so your problem relates to something else. If it doesn't say your port is open then you should continue with this guide. Check this link to see the Supported Routers/Modems which is updated regularly. [Hidden Content] As you can see there is a wide range of modems available and don't worry if you don't see yours, which won't happen often as you can add a custom router. (1) First you need to visit [Hidden Content] (2) Have a read if you want, then click on Majorgeeks.com (3) Now you will see download location, click on download@MajorGeeks (4) Once installed, open the program up. (5) You should have two screens up. One called "Simple Port Forwarding" and the other is called "Check List" (6) Don't worry if you only have the screen "Simple Port Forwarding up" - Just click on tools, then click getting started. (7) You will see that you now have the "Check List" screen. (8) Follow the 5 Abc steps below which you can see in your "Check List" (a) Update router list (b) Select Your router and set login information © Choose your ports you need to open (d) Update the router (e) Test the ports work This guide from start to finish will take 5 minutes tops, with the outcome your port being forwarded, thats how easy it is. Last edited 6 years ago by

[useful] 100 Run Commands [PROBABLY works for only WINDOWS 7/8/8.1/10 EARLY Version... Start->Run->Type Command Here Enjoy :] Accessibility Controls access.cpl Add Hardware Wizard hdwwiz.cpl Add/Remove Programs appwiz.cpl Administrative Tools control admintools Automatic Updates wuaucpl.cpl Bluetooth Transfer Wizard fsquirt Calculator calc Certificate Manager certmgr.msc Character Map charmap Check Disk Utility chkdsk Clipboard Viewer clipbrd Command Prompt cmd Component Services dcomcnfg Computer Management compmgmt.msc Date and Time Properties timedate.cpl DDE Shares ddeshare Device Manager devmgmt.msc Direct X Control Panel (If Installed)* directx.cpl Direct X Troubleshooter dxdiag Disk Cleanup Utility cleanmgr Disk Defragment dfrg.msc Disk Management diskmgmt.msc Disk Partition Manager diskpart Display Properties control desktop Display Properties desk.cpl Display Properties (w/Appearance Tab Preselected) control color Dr. Watson System Troubleshooting Utility drwtsn32 Driver Verifier Utility verifier Event Viewer eventvwr.msc File Signature Verification Tool sigverif Findfast findfast.cpl Folders Properties control folders Fonts control fonts Fonts Folder fonts Free Cell Card Game freecell Game Controllers joy.cpl Group Policy Editor (XP Prof) gpedit.msc Hearts Card Game mshearts Iexpress Wizard iexpress Indexing Service ciadv.msc Internet Properties inetcpl.cpl IP Configuration (Display Connection Configuration) ipconfig /all IP Configuration (Display DNS Cache Contents) ipconfig /displaydns IP Configuration (Delete DNS Cache Contents) ipconfig /flushdns IP Configuration (Release All Connections) ipconfig /release IP Configuration (Renew All Connections) ipconfig /renew IP Configuration (Refreshes DHCP & Re-Registers DNS) ipconfig /registerdns IP Configuration (Display DHCP Class ID) ipconfig /showclassid IP Configuration (Modifies DHCP Class ID) ipconfig /setclassid Java Control Panel (If Installed) jpicpl32.cpl Java Control Panel (If Installed) javaws Keyboard Properties control keyboard Local Security Settings secpol.msc Local Users and Groups lusrmgr.msc Logs You Out Of Windows logoff Microsoft Chat winchat Minesweeper Game winmine Mouse Properties control mouse Mouse Properties main.cpl Network Connections control netconnections Network Connections ncpa.cpl Network Setup Wizard netsetup.cpl Notepad notepad Nview Desktop Manager (If Installed) nvtuicpl.cpl Object Packager packager ODBC Data Source Administrator odbccp32.cpl On Screen Keyboard osk Opens AC3 Filter (If Installed) ac3filter.cpl Password Properties password.cpl Performance Monitor perfmon.msc Performance Monitor perfmon Phone and Modem Options telephon.cpl Power Configuration powercfg.cpl Printers and Faxes control printers Printers Folder printers Private Character Editor eudcedit Quicktime (If Installed) QuickTime.cpl Regional Settings intl.cpl Registry Editor regedit Registry Editor regedit32 Remote Desktop mstsc Removable Storage ntmsmgr.msc Removable Storage Operator Requests ntmsoprq.msc Resultant Set of Policy (XP Prof) rsop.msc Scanners and Cameras sticpl.cpl Scheduled Tasks control schedtasks Security Center wscui.cpl Services services.msc Shared Folders fsmgmt.msc Shuts Down Windows shutdown Sounds and Audio mmsys.cpl Spider Solitare Card Game spider SQL Client Configuration cliconfg System Configuration Editor sysedit System Configuration Utility msconfig System File Checker Utility (Scan Immediately) sfc /scannow System File Checker Utility (Scan Once At Next Boot) sfc /scanonce System File Checker Utility (Scan On Every Boot) sfc /scanboot System File Checker Utility (Return to Default Setting) sfc /revert System File Checker Utility (Purge File Cache) sfc /purgecache System File Checker Utility (Set Cache Size to size x) sfc /cachesize=x System Properties sysdm.cpl Task Manager taskmgr Telnet Client telnet User Account Management nusrmgr.cpl Utility Manager utilman Windows Firewall firewall.cpl Windows Magnifier magnify Windows Management Infrastructure wmimgmt.msc Windows System Security Tool syskey Windows Update Launches wupdmgr Windows XP Tour Wizard tourstart Wordpad write Hope this helped a bit

[Tut] There are few ways HOW TO GET XXX PASSES of you favrt sites not only you can search list of password from google but you can find lot of xxx password site too if you fail to find working one using way2 then use way1 set up a google alert so you might be the first few person who get the latest updat password that listed on google i get a brazzers working password sent to my gmail just by using way1 way1 (everyone should know this as this was taken from pornbb sticky) With this tutorial you'll learn how to obtain porno password via Google Alert!! Thing needed: Gmail Account 1. Go to [Hidden Content], it might ask you to sign in, do so with your gmail info. 2. Where it says "Create a Google Alert", under "Search terms" type something like @www.xxxsite.com/members/. Under "Type" choose "News and Web". As "How Often" choose as it happens and click create alert. 3. You're done, as soon as a link is released publicaly or posted on a website it should send you the alert. 4.Patience, an e-mail will arrive......... (it's random,I posted alarm towards 5:00 pm to receive a e-mail towards 2:54am) 5.example of what you can receive (in French, with "www.clubcarmen.com") way2 or just search from google just add a *:*@ in front the site link u want to search example: members.meatmembers.com/ change to *:*@members.meatmembers.com/ use the option at google site choose 24 hour or past week to find the latest pass way3 hack urself which are more harder u may have heard accessdiver b4 here is the guide in this forum on how to use it I HAVE MY OWN GUIDE NAMED :"Step by step Easy guide of CRACKING" there r still alot of way to hack which i dun know ! way4 trade your password with other,you will be able to get a good quality site by trading i get a few rk password by trading last time ,but pls dont trade password here as it not allowed way5 (this is more on how to find site that give xxx password) search on google for toplist or directory for xxx paassword search on blogsearch.google.com for xxx password blog way6 this i not too clear if anyone have more info might want to share with us,i heard mIRC is the best place to request for password but you need to know the way and the channel way7 (with a little luck) sign up as a affiliate webmaster of that pornsite most pornsite will have affiliate system to look for webmaster to promote their site by throg commission and alot of site will provide a few picture or video for you to use to promote their site especially those picture site so you can download and use as your own enjoyment and more over use up as a affiliate is free ,just try to look around mostly ''affiliate'' sign up page will be at the bottom page but if you really like the site i will recommend buy their membership to support you fav site way8 i notice [Hidden Content] can also search for paswordword and it more easy than way2 w/o the *:*@ trick and you may just eneter the site name w/o the member entry url example rk.com instead of members.rk.com

How To Find Password Dumps With Google Dork With this little trick, you can find other peoples' account usernames : passwords for many websites. Go to pastebin.com or google.com and search this code. " Program: Url/ Host: Login: Password: Computer: Date: Ip: " Program: Url/Host: Login: Password: Computer: Date: Ip: Program: Url/Host: [Hidden Content] Login: Password: Computer: Date: IP: The results should come up with lots of passwords and account information for sites like Facebook, Gmail etc... Get An Account For Any Website! Go to [Hidden Content] In the url/search bar, copy and paste all of the following. Program: Url/Host: Login: Password: Computer: Date: IP: Now lets say you want an account for facebook. so after the Url/Host you would write in the facebook website address, just like this: Program: Url/Host: [Hidden Content] Login: Password: Computer: Date: IP: Searching for TO GET THE USERNAME AND PASSWORD OF ANY WEBSITE Here is d solution: Go to [Hidden Content] In the url/search bar, copy and paste all of the following. Program: Url/Host: Login: Password: Computer: Date: IP: Now lets say you want an account for facebook. so after the Url/Host you would write in the facebook website address, just like this: Program: Url/Host: [Hidden Content]/ Login: Password: Computer: Date: IP: Searching for this will show you dumps on the internet. A dump is when someone takes all the accounts that they have hacked, and places them on a website so everyone can gain access to them. You can use this to obtain accounts for any website, but the accounts won’t work all the time, because people may have already changed the login details, depending on how old the dump is. You will not find logins for every website. For example, if you search for facebook accounts, you are bound to find a lot of them, but if you search for a website that isn’t popular at all, or doesn’t have many users, you probably will not find any dumps. Hope this Helped.

Most common reason for stats not updating The user is cheating. (a.k.a. "Summary Ban") The server is overloaded and unresponsive. Just try to keep the session open until the server responds again. (Flooding the server with consecutive manual updates is not recommended.) How does NAT/ICS change the picture? This is a very particular case in that all computers in the LAN will appear to the outside world as having the same IP. We must distinguish between two cases: 1. You are the single user in the LAN You should use the same account in all the computers. Note also that in the ICS case it is preferable to run the BT client on the ICS gateway. Clients running on the other computers will be unconnectable (their ports will be listed as "---", as explained elsewhere in the FAQ) unless you specify the appropriate services in your ICS configuration (a good explanation of how to do this for Windows XP can be foundhere). In the NAT case you should configure different ranges for clients on different computers and create appropriate NAT rules in the router. (Details vary widely from router to router and are outside the scope of this FAQ. Check your router documentation and/or support forum.) 2. There are multiple users in the LAN At present there is no way of making this setup always work properly. Each torrent will be associated with the user who last accessed the site from within the LAN before the torrent was started. Unless there is cooperation between the users mixing of statistics is possible. (User A accesses the site, downloads a .torrent file, but does not start the torrent immediately. Meanwhile, user B accesses the site. User A then starts the torrent. The torrent will count towards user B's statistics, not user A's.) It is your LAN, the responsibility is yours. Do not ask us to ban other users with the same IP, we will not do that. (Why should we ban him instead of you?) Best practices If a torrent you are currently leeching/seeding is not listed on your profile, just wait or force a manual update. Make sure you exit your client properly, so that the tracker receives "event=completed". If the tracker is down, do not stop seeding. As long as the tracker is back up before you exit the client the stats should update properly. May I use any bittorrent client? Yes. The tracker now updates the stats correctly for all bittorrent clients. However, we still recommend that you avoid the following clients: BitTorrent++ Nova Torrent TorrentStorm These clients do not report correctly to the tracker when canceling/finishing a torrent session. If you use them then a few MB may not be counted towards the stats near the end, and torrents may still be listed in your profile for some time after you have closed the client. Also, clients in alpha or beta version should be avoided. Why is a torrent I'm leeching/seeding listed several times in my profile? If for some reason (e.g. pc crash, or frozen client) your client exits improperly and you restart it, it will have a new peer_id, so it will show as a new torrent. The old one will never receive a "event=completed" or "event=stopped" and will be listed until some tracker timeout. Just ignore it, it will eventually go away. I've finished or cancelled a torrent. Why is it still listed in my profile? Some clients, notably TorrentStorm and Nova Torrent, do not report properly to the tracker when canceling or finishing a torrent. In that case the tracker will keep waiting for some message - and thus listing the torrent as seeding or leeching - until some timeout occurs. Just ignore it, it will eventually go away. Why do I sometimes see torrents I'm not leeching in my profile!? When a torrent is first started, the tracker uses the IP to identify the user. Therefore the torrent will become associated with the user who last accessed the site from that IP. If you share your IP in some way (you are behind NAT/ICS, or using a proxy), and some of the persons you share it with are also users, you may occasionally see their torrents listed in your profile. (If they start a torrent session from that IP and you were the last one to visit the site the torrent will be associated with you). Note that now torrents listed in your profile will always count towards your total stats.