Inserting Into Database
Inserting information into a database for Brian's Xbox IP Resolver is very easy. Creating a database will allow you send that database to the scripts developer to be merged to the main database or you can share the database online for others to use or contribute too.
Inserting information into a database is easy just start the script up and choose the second option which should be "3" then the script will ask if you want to insert information manually or by using a iplog.txt file. The iplog.txt file is generated by ApparitionNET Studio. I have plans of adding support for others ways for information to be inserted into the database. If you are inserting information manually you will be asked to enter the following information:
- Gamertag*
- IP Address*
- XUID
- Machine ID
Note: The XUID and machine ID (MID) inputs can be left blank if unknown.
When inserting into a database using a iplog.txt file the script will open the iplog.txt file to read and create a new formatted file with the contents of that file. This new file will be named something like "new_iplog.txt" unless changed in config.py. By creating this new formatted file it allows the script to be able to use and read the data in the file to be used later when adding it to a database. When adding the file contents to a database the script will add the file contents to a list then insert that list into the selected database automatically for you. Be sure the iplog.txt is inside the scripts folder or it will throw a error.
Using The Script | Inserting Manually
>>> python main.py
>>> 1. Search Database
>>> 2. Create Database
>>> 3. Insert Into Database
>>> 4. Edit Database
>>> 5. View Database
>>> 6. Merge Two Databases
>>> 7. Delete Database
>>>
>>> Please pick a option above by entering the number: 3
>>>
>>> Insert data manually or with the iplog.txt file (manually/iplog): manually
>>>
>>> - backup.db
>>> - database.db
>>> - old.db
>>> - example.db
>>>
>>> Database Name (without .db): example
>>>
>>> Gamertag: TestGamertag123
>>> IP Address: 10.0.0.1
>>> XUID: 000901F0138D1241
>>> Machine ID: FA00F49BFED244BB
>>>
>>> Successfully added information to example.db.
Using The Script | Inserting From IP Log File Example
>>> python main.py
>>> 1. Search Database
>>> 2. Create Database
>>> 3. Insert Into Database
>>> 4. Edit Database
>>> 5. View Database
>>> 6. Merge Two Databases
>>> 7. Delete Database
>>>
>>> Please pick a option above by entering the number: 3
>>>
>>> Insert data manually or with the iplog.txt file (manually/iplog): iplog
>>>
>>> - backup.db
>>> - database.db
>>> - old.db
>>> - example.db
>>>
>>> Database Name (without .db): example
>>>
>>> Which program is the ip log file from?
>>> - ApparitionNET Studios
>>> Program: ApparitionNET
>>>
>>> Opening iplog.txt to read and create the new formatted file.
>>> Creating the new formatted file named new_iplog.txt.
>>> Successfully created the new formatted file.
>>> Adding the items from new_iplog.txt to a list.
>>> Inserting the information from that list to test.db.
>>> Successfully inserted information into database.
Editing A Database
Edit a database that was made for Brian's Xbox IP Resolver is a very easy thing to do. Edit a database will edit records in that database this includes a gamertags, xuids, and machine IDs. You will need to know the ID of the entry in order to edit it. The editing database part of the script isn't finsished so take caution when editing anything.
Editing information that is stored in the database is easy just start the script up and choose the fourth option which should be "4" then the script will ask you to select the database you want to edit then the script will ask if you want to edit multiple columns at the same time or edit one column at a time. If you choose multiple columns you will be asked enter the new gamertag, ip address, xuid, and machine id. These can not be left blank.
Note: as of right now the script only supports editing of multiple columns not one at a time.
Using The Script | Editing Multiple Columns Example
>>> python main.py
>>> 1. Search Database
>>> 2. Create Database
>>> 3. Insert Into Database
>>> 4. Edit Database
>>> 5. View Database
>>> 6. Merge Two Databases
>>> 7. Delete Database
>>>
>>> Please pick a option above by entering the number: 4
>>>
>>> - backup.db
>>> - database.db
>>> - old.db
>>> - example.db
>>>
>>> Database Name (without .db): example
>>> Would you like to update multiple columns at the same time? (y/n): y
>>> Please enter the ID of the row you would like to update: 1
>>>
>>> New Gamertag: TestGamertag123
>>> New IP Address: 10.0.0.1
>>> New XUID: 000901F0138D1241
>>> New Machine ID: FA00F49BFED244BB
>>>
>>> Successfully edited the database record.
Viewing A Database
Viewing a database that was made for Brian's Xbox IP Resolver is a very easy thing to do. Viewing a database will show you all the results that are in that database this includes a ID, gamertags, xuids, and machine IDs. Viewing a database may be useful to see everything inside but you can also make note of a ID for a entry and use that ID to then edit that entry if you wanted to by using the edit database option.
Viewing information that is stored in the database is easy just start the script up and choose the fifth option which should be "5" then the script will ask you to select the database you want to view then after picking a database the script will show all entrys that are in the database this inculdes:
- IDs
- Gamertags
- IP Addresses
- XUIDs
- Machine IDs
Using The Script | Example
>>> python main.py
>>> 1. Search Database
>>> 2. Create Database
>>> 3. Insert Into Database
>>> 4. Edit Database
>>> 5. View Database
>>> 6. Merge Two Databases
>>> 7. Delete Database
>>>
>>> Please pick a option above by entering the number: 5
>>>
>>> - backup.db
>>> - database.db
>>> - old.db
>>> - example.db
>>>
>>> Database Name (without .db): example
>>>
>>> ID: 1
>>> Gamertag: TestGamertag123
>>> IP Address: 10.0.0.1
>>> XUID: 000901F0138D1241
>>> Machine ID: FA00F49BFED244BB
>>>
>>> ID: 2
>>> Gamertag: TestUser
>>> IP Address: 127.0.0.1
>>> XUID: 000608F03B1D1236
>>> Machine ID: FA0000000404FD3W
>>>
>>> ID: 3
>>> Gamertag: AnotherGamertag
>>> IP Address: 127.0.0.1
>>> XUID: 000201F0278S6221
>>> Machine ID: FA0000000404BE7E
Merge Two Database
Do you have two multiple database and would like to merge them together? Well now you can! Merging two database that was made for Brian's Xbox IP Resolver is a very easy thing to do. You can only merge two databases together at one time but you can keep reparting the process as needed.
Merging two database together is easy just start the script up and choose the sixth option which should be "6" then the script will ask you to select the database you want to merge into then you will be asked to select the database you want to merge into the selected database.
Using The Script | Example
>>> python main.py
>>> 1. Search Database
>>> 2. Create Database
>>> 3. Insert Into Database
>>> 4. Edit Database
>>> 5. View Database
>>> 6. Merge Two Databases
>>> 7. Delete Database
>>>
>>> Please pick a option above by entering the number: 6
>>>
>>> Please pick a database you would like to merage to from the list below.
>>> - backup.db
>>> - database.db
>>> - old.db
>>> - example.db
>>>
>>> Database Name (without .db): example
>>> Which database would you like to merge into example.db (without .db): old
>>> Successfully merged old.db into example.db.
Delete A Database
No longer need a database? You can always delete it manually yourself but I have went ahead and included a option in the script to do it for you. You have to be 100% sure you want to delete the database because once its gone, its gone. Take caution when using this action because it can not be undone.
Deleting a database is easy just start the script up and choose the seventh option which should be "7" then the script will ask you to select the database you want to delete and then will ask you if you are sure you want to delete the database and if you answer "yes" or "y" the script will go ahead and delete the database.
Using The Script | Example
>>> python main.py
>>> 1. Search Database
>>> 2. Create Database
>>> 3. Insert Into Database
>>> 4. Edit Database
>>> 5. View Database
>>> 6. Merge Two Databases
>>> 7. Delete Database
>>>
>>> Please pick a option above by entering the number: 7
>>>
>>> Please pick a database you would like to merage to from the list below.
>>> - backup.db
>>> - database.db
>>> - old.db
>>> - example.db
>>>
>>> Database Name (without .db): example
>>> Are you sure you want to delete test.db? This can not be undone! (y/n): y
>>> Successfully deleted the database.