Jump to content
UBot Underground

Recommended Posts

SQLite Database Tutorial

Features:

  • Creates Database
  • Select/Change Database
  • Creates Projects Table
  • Creates new project
  • Displays tables
  • Deletes tables
  • Creates profiles table
  • Creates any table
  • Adds E-mail and password to profiles table
  • Assigns random proxies to all accounts or per profile
  • Over 15 commands and functions

SQLite Queries used:

  1. CREATE TABLE IF NOT EXISTS
  2. PRIMARY KEY AUTOINCREMENT
  3. INSERT INTO
  4. SELECT
  5. SELECT FROM
  6. DROP TABLE
  7. DELETE FROM
  8. FOREIGN KEY
  9. ALTER TABLE
  10. UPDATE
  11. ADD COLUMN
  12. COUNT

This is a training bot that is capable of making real databases. It is designed to be user friendly and intuitive. It is heavily commented and all you have to do is press buttons, if necessary fill in the blanks.

 

Plugins used:

  • SQLite Plugin: NOT included, you must buy this from the developer and any support for it is from the developer. I am not affiliated in any way with this plugin. I just learnt how to use this one first.
  • File Management: Free
  • String Management: Free
  • Date/Time Manipulation: Free

 

There is a resource tab that has buttons that will take you to these threads and other resources.

 

Best thing about it…it’s FREE...

Wait…wuh?

 

Well, If you care to donate PM me and I will give you Paypal info to send donations to.

For those who don’t or can’t donate at least hit the like button.

 

Coded in Ubot 4, untested in Ubot 5. I assume it could work in 5.

 

Anyone interested in joining the "SQLite Help" Skype Group,

just add me to Skype or shoot me a message "add me to SQLite group" to seoproranker and I will add you ASAP

aka Traffik Copper

 

Thank You and Enjoy,

TC

 

updated to

SQLite-DB-Tutorial-3-7-2014

also changed "current database function" the file path should be Database not Databases

in fact where ever the file path is "Databases" should be "Database" but I think I got them now in 3-7-2014 version.

 

added drop table and when you create table te first colomn will now say "yourtablename_ID" instead of Project_ID in 3-7-2014-2

SQLite-DB-Tutorial-3-7-2014-2.ubot

  • Like 16
Link to post
Share on other sites

Glad you like it guys,

 

For those that already downloaded. I forgot to add the custom command "Database folder exist" to create database button node.

 Under the custom commands drag the "Database Folder Exist" into the create DB button and after the first "set" and before "sqlite create database" nodes.

 

TC

 

also noticed the Current Db function in the file path is Databases and should be Database, sorry guys

 

In addition to the custom command database folder exist need to drag APP DATA folder exist and put it before database folder exist.

 

Or just download latest

Link to post
Share on other sites

ok I found another one.

 

In functions tab under commands

 

In the "define Select Database" first set node in get files function "Databases" needs to be "Database" I will upload new.

 

Thanks everyone especially the Donors!! you will be rewarded :)

 

TC

Link to post
Share on other sites

anyone is welcome to join the SQLite Help group just throw this in address bar

 

skype:?chat&blob=14QONkmIm02UnfvP9qkl5ltcyonh4j0iQW2hJTJY28HxXOPYXi2UZA

 

or there is button in Resource tab

 

TC

SQLite-DB-Tutorial-3-7-2014-2.ubot

Link to post
Share on other sites

@jamestar if you put it the message area of skype then press enter then click on the link or put it in the address bar of you browser like a URL then enter it should give you pop up or take you to the group.

 

There is a button in latest update to press inn resource tab for the Skype group as well.

 

If all else fails add me to skype and I will add you to the group my  Sk-ype  name is seoproranker and lemme know that it's for SQLite so I can add you to the correct group.

Link to post
Share on other sites
  • 1 year later...

Question regarding the code in the bot. I noticed that in the Delete Project Table section, there are two commands, 'Drop Table Projects' and DELETE FROM Tables WHERE TableName='Projects''.

 

What's the reason for the second command?

 

Frank

Link to post
Share on other sites

DELETE TABLE

deletes a record/records/all records

with out deleting the table

 

DROP TABLE

removes the whole existence of the table

 

 

 

"DELETE FROM Tables WHERE TableName='Projects'' is an example of how to delete a record from a table

 

Does that answer tour question?

Link to post
Share on other sites

Thanks mate, so 'Drop Table' by itself won't do the whole job? Is there a administrative table where this entry is removed by the 'delete table'?

 

Thanks!

 

Frank

Link to post
Share on other sites

DELETE TABLE: does not do  the whole job.

 

if you open a .txt file with content and delete the content then save the empty file.

 

DROP TABLE:

 

if you delete the file itself

 

 

Yes, there is a master table that sqlite uses to keep track of stuffs.

It holds the "Tables" table. This is created when you create the DB.

 

There is an add on for Firefox called SQlite Manager, you can test queries and much more. It is wonderful.

 

You can see the master table too.

Link to post
Share on other sites

I will be doing something similar with U5's Python someday.

 

You can play with it now.

 

 https://docs.python.org/2/library/sqlite3.html

 

That is the proper version of python syntax to use the example codes.

 

ironpython uses 2.7 python.

 

As you can you will see it is more robust than the PAID PLUGIN.

 

Regards,

CD(Nick)

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...