SQL Query Analyzer Form (Add-ons)

Purchase $12.00

Do you want to have your own SQL query analyzer inside your .Net applications?? With SQL Query Analyzer Form you add this functionality to your systems, so you (as an admin or super user) can have acces to Databases from your own Application anywhere inside your company without having to install the respective tools to do that.

SQL Query Analyzer Form just looks for stored connection strings in your configuration file and loads them to the list, and after you have selected a ConnectionStgringName you will see all DB objects on the left, so can you use it as usually.

Features:

• Edit or create new Stored Procedures with this tool.


• Change the Font Color of the query textbox


• Drag and drop a table name from the left to your query


• Select, Insert, Delete and Update operations


• v2.0 now supports Oracle Database Connections


• v2.1 Added C# version for both (SQL Server & Oracle)

Requirements:

• .Net Framework 2.0 +


• Save your connection strings in .config file


• Need to add System.Configuration reference to your project (if you already didn’t)


• Add Oracle.DataAccess.dll reference to your project (DLL provided with files)


• Download and install Oracle ODAC components to use with Oracle Databases

Installation:

• After decompressing the downloaded zip file, you will have 3 files, copy these files into your VB.Net project, in the folder among your other windows forms.


• From the Solution Explorer, add the files to your project so it can compile.


• Add 2 references named before.


• That’s it!

-Download ODAC [Oracle Data Access Component] from this link to install required providers to work with Oracle (.Net, OleDB)
http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html

Configuration file example code:

Do you have any questions??
Please contact me: gacosta120382@hotmail.com

PHProtect - Captcha and PHP security (Add-ons)

Purchase $4.00

PHProtect is a tool to allow you to easily insert captcha’s to prevent spam and database flooding and prevent common PHP attacks.

Key functions

1. Easily include captchas


2. Time delay on captcha to prevent bruteforce attacks


3. Automatically sanitise all GET, POST, COOKIE and REQUEST requests with just 2 lines of code


4. Stop XSS attacks


5. Stop SQL injections

Captcha

PHProtect allows you to include captcha in your exiting forms with just a few lines of code, allowing you to easily stop spam and prevent flooding.
If the user submits a form with a captcha in too quickly (in less than 2 seconds), this will delay loading of the script by 2 seconds. This will prevent brute force attacks, meaning it can take up to 461 days to crack a single captcha.
The captchas are easy to understand and only contain 5 letters and is not case sensitive.
The captcha is obscured by adding lines to the image and by a non-standard font for letters, making Optical Character Recognition attacks very hard.

String Sanitisation

Using just 2 lines of code you can sanitise all PHP inputs (GET, POST, COOKIE and REQUEST variables). This function can be used to sanitise SQL inputs and XSS attacks alike.
The script includes a function to allow you to sanitise individual variables also.

Specte Search Engine (Search)

Purchase $14.00

This framework is a semantic search engine framework. Specte search engine devoloped as web search engine for finding web pages on the internet just like Google, Yahoo, Bing. Before explaining the search logic, you have to understand what is semantic search. You can find a lot of knowledge about semantic web. This framework created based on PHP 5.4 and MySQL 5.5.31-30.3. And also frame work using Wordnet for semantic analysis.

Semantic Web & Semantic Search

Semantic search is basicly not a search system based processing the text format. Text processing is the second stage of the search. The system using semantic search for semantic parsing, distinguish synonyms, offering to user the other search query which is related the user’s search query and so on. By using this query analysis the logic of engine expands the keyword pool and scores the keywords by relation of main query. Also Specte search engine framework uses the semantic search for sort the results with more efficient and properly. We will tell more about semantic search at the manual.

The second imported thing is processing huge database(including hundreds of thousands web pages) and order by the semantic analysis process results. This sorting process not so complicated but it has many factor such as web page’s keyword, description, page title, URL matches with users query, popularity of page.

Specte search engine has two types of the search; Web search and Image search. Let us first explain web search logic of Specte.

1. Web Search

When you enter a search phrase of Specte’s search bar. System brings to you results from five major search engine these are AOL, Bing, Yahoo, Blekko and Excite. So that you can compare the result of these engines. If you want to have a look the result from Specte’s own database simply click to “Search at Specte’s Database” on top-center of the page.

On searchplus.php the engine will search on it’s own database. Specte will show you twenty results by listed relevancy. Each results begin the title of page, just below the URL of result is located, and finally the descripton or a summary of page is located. The background adjusted so as to not tire your eyes and also your monitor consumes less energy owing to gray color of background.

At the bottom of page you will see related search keywords(If the engine finds) which are related words with your search phrase and you can search it by clicking them. For example when you searched “Google” you will see some keywords as in the picture below:

As you can see Specte Search Engine with all of these aspects stands out from the similars. In addition now, let us explain image search logic of Specte.

2. Image Search

The image search process of the Specte completely simulating Google’s image search logic. When you looked the image search you won’t see so many differences beetwen Google’s image search. For now the image search database only is a small prototype for seeing how it works. And for now this image search logic only answers to phrases related with “World of Warcraft Game”. Because all images in the pool of Specte Image database basically related with this game.

When you having this item you will get so much information about search on the internet. Thanks for reading.

Ultimate database import/export (CSV-XLS(x)-MySQL) (Database Abstractions)

Purchase $12.00

This application makes your work easy and effortless when it comes to data import/export to/from MySQL database.

Feed CSV or XLS (Excel) files to your MySQL database within seconds.

Purchasing this product you can easily convert:

- CSV to MySQL
- XLS to MySQL
- MySQL to CSV
- MySQL to XLS

Tailor the process to your needs:
- define the delimiter when uploading CSV and XLS files
- no change necessary if your CSV and XLS file has header
- choose your own delimiter when generating CSV files
- easy configuration: database parameters and timezone easily defined in config.php
The default language of this application is English. Language localisation can be easily done with changing the texts and labels collected in en.php.

This product uses PHPExcel class. The product price only includes the files and functions developed to create the converter. Third party sourcecode and classes are not included. PHPExcel is a free class, that can be downloaded here: http://phpexcel.codeplex.com/

MySQL Backup Pro Class (Database Abstractions)

Purchase $10.00

MySQL Backup Pro Class

• 
  backup your MySQL database as
  SQL
  ,
  CSV
  or
  XML
  ;
  


• 
  upload backup to
  FTP
  server;
  


• 
  send backup as
  email
  attachment;
  


• 
  upload to
  Google Drive
  ,
  Dropbox
  ,
  Box
  ,
  SkyDrive
  and other cloud using
  WebDAV
  ;
  


• 
  send to server using
  PUTS HTTP;
  


• Can pack as ZIP archive;


• 
  support
  MySQL, MySQLi and PDO
  driver;
  


• use CRON to automate backup your data;


• easy installation on any server;


• examples of both functions are included;


• 
  fully documented.
  

Examples

FILE

Save backup on server as file

Backup::init($params)->as_sql()->save($path);


MAIL

Send backup as attachment on email

Backup::init($params)->as_sql()->mail('your_emal@mail.com');


FTP

Upload backup to FTP server

Backup::init($params)->as_sql()->ftp($ftp_params);


HTTP

Upload backup to HTTP server using method PUTS

Backup::init($params)->as_sql()->http($http_params);


WebDAV (Cloud)

Upload backup to cloud using WebDAV

Backup::init($params)->as_sql()->webdav($webdav_params);


For more examlpes please read description.

Changelog

Version 1.3

• Minor bug fixes

Version 1.2

• Add ZIP method

Version 1.1

• Add PDO driver

Version 1.0

• Released