isDatabase - readme

isDatabase - readme

1. Intro

This article describes the isDatabase and its contents. It does not contain instructions for using the database. If you want to use the database, you should have a basic knowledge of at least one of the following:

  • XML (Extensible Markup Language) - XML format and how to read files with the .xml extension,
  • JSON (JavaScript Object Notation) - JSON format and how to read files with the .json extension,
  • CSV (comma-separated values) - CSV format and how to read files with the .csv extension.

Having knowledge of at least one of the above-mentioned formats and the possibilities it offers, you can make use of the database.

2. What is isDatabase

It is nothing more than a collection of several text files containing information about models and shows available in the iStripper store. All basic information about models and shows available at www.istripper.com and in the iStripper application have been gathered in one place to facilitate access to this information for those who need it.

NOTE: The database contains information only about those shows that are available in the store. The database does not contain information about shows that have not yet been made available in the store.

The information contained in the database can be imported into database programs (e.g. Microsoft Access) or spreadsheets (e.g. Microsoft Excel) for filtering, sorting, compilation and building charts (e.g. searching for the cheapest and the most expensive shows, searching for the models with the largest and smallest dimensions etc.). If you are a programmer, you can use the database in your own scripts or applications.

3. Database structure

ZIP file content

The database has been prepared in three universal formats: XML, JSON and CSV. The downloaded archive contains two files in each of these formats, one of which is a collection of information about models (is_models.xml, is_models.json and is_models.csv), while the other is a collection of information about shows (is_cards.xml, is_cards.json and is_cards.csv). Each of the formats contains the same set of information. You don't have to use all formats at the same time. Just choose the one that is most convenient for you.

3.1. XML format

XML files have a simple structure: one root element <models> or <cards> (for is_models.xml and is_cards.xml, respectively), which contains a set of <m> or <c> elements. Model and card information is stored in the attributes of the <m> and <c> elements, as shown below.

is_models.xml
<?xml version="1.0" encoding="UTF-8"?>
<models>
<m id="1" name="Silver" rate="1.92" vital_b="94" vital_w="66" vital_h="94" vital_p="0" height="170" weight="51" city="Lille" country="France" ethn="european" birth="1988" sex="female" totm="0" shows="a0001,a0002,a0003,a0004,d0266" />
<m ... /> <!-- other elements -->
<m ... /> <!-- last element -->
</models>
is_cards.xml
<?xml version="1.0" encoding="UTF-8"?>
<cards>
<c id="a0001" model="1" name="Silver" title="Beauty Queen" coll="iStripper Classic" date="2007-04-03" rate="1.70" sec="0" tags="high heels,lingerie,shaved" clips="32" frames="29025" level="3" photos="38" videos="3" xvids="0" comm="83" votes="1495" r480p="0" r720p="149396" r1080p="0" r3k="0" r4k="0" hair="brown-haired" price="10" />
<c ... /> <!-- other elements -->
<c ... /> <!-- last element -->
</cards>

A detailed description of the attributes and the information they contain can be found later in this article.

3.2. JSON format

JSON files contain one main object with an array of objects. Information about models and cards are saved as object properties. The JSON file structure is shown below.

is_models.json
{
"models": [
{
"id": 1,
"name": "Silver",
"rate": 1.92,
"vitalb": 94,
"vitalw": 66,
"vitalh": 94,
"vitalp": 0,
"height": 170,
"weight": 51,
"city": "Lille",
"country": "France",
"ethn": "european",
"birth": "1988",
"sex": "female",
"totm": "0",
"shows": "a0001,a0002,a0003,a0004,d0266"
},
{ ... }, // other objects
{ ... } // last object
]
}
is_cards.json
{
"cards": [
{
"id": "a0001",
"model": "1",
"name": "Silver",
"title": "Beauty Queen",
"coll": "iStripper Classic",
"date": "2007-04-03",
"rate": 1.70,
"sec": 0,
"tags": "high heels,lingerie,shaved",
"clips": 32,
"frames": 29025,
"level": 3,
"photos": 38,
"videos": 3,
"xvids": 0,
"comm": 83,
"votes": 1495,
"r480p": 0,
"r720p": 149396,
"r1080p": 0,
"r3k": 0,
"r4k": 0,
"hair": "brown-haired",
"price": "10"
},
{ ... }, // other objects
{ ... } // last object
]
}

A detailed description of the properties and the information they contain can be found later in this article.

3.3. CSV format

CSV files contain a header row in which the column header names are saved. This is useful when generating tables. Information on models and cards are separated by commas. The structure of the CSV file is shown below.

is_models.csv
id,name,rate,vitalb,vitalw,vitalh,vitalp,height,weight,city,country,ethn,birth,sex,totm,shows
1,"Silver",1.92,94,66,94,0,170,51,"Lille","France","european","1988","female","0","a0001,a0002,a0003,a0004,d0266"
2,"Carol G",3.57,96.5,66,96.5,0,176,60,"Prague","Czech republic","european","1981","female","0","a0005,a0006,a0007,a0008,a0009,a0010,c0186,c0187,c0189,c0190,d0235,d0248"
... other rows
is_cards.csv
id,model,name,title,coll,date,rate,sec,tags,clips,frames,level,photos,videos,xvids,comm,votes,r480p,r720p,r1080p,r3k,r4k,hair,price
"a0001","1","Silver","Beauty Queen","iStripper Classic","2007-04-03",1.70,0,"high heels,lingerie,shaved",32,29025,3,38,3,0,83,1495,0,149396,0,0,0,"brown-haired","10"
"a0002","1","Silver","Cheeky Girl","iStripper Classic","2007-04-03",1.65,0,"babydoll,high heels,lingerie,shaved",43,40975,3,36,3,0,102,1560,0,206859,0,0,0,"brown-haired","10"
... other rows

A detailed description of the headers and the information they contain can be found later in this article.

4. Database content

Below is a list of fields (attributes / properties / headers). Each field contains a brief description of the information and values it can store.

4.1. is_models files

  • id - model identifier. Takes integer values.
  • name - model's name. Takes string values.
  • rate - model's average rating. The rating is calculated based on the ratings of all shows of a given model, which have already been made available in the store. It takes float numeric values to two decimal places. If the value is unknown, it defaults to 0 (zero).
  • vitalb - model's vital stats (bust) in centimeters (cm). It takes float numeric values to one decimal place. If the value is unknown, it defaults to 0 (zero).
  • vitalw - model's vital stats (waist) in centimeters (cm). It takes float numeric values to one decimal place. If the value is unknown, it defaults to 0 (zero).
  • vitalh - model's vital stats (hips) in centimeters (cm). It takes float numeric values to one decimal place. If the value is unknown, it defaults to 0 (zero).
  • vitalp - the length of the model's birdie, given in centimeters (cm). Only applies to the VirtuaGuy collection. It takes float numeric values to one decimal place. If the value is unknown, it defaults to 0 (zero).
  • height - model's height in centimeters (cm). Takes integer values. If the value is unknown, it defaults to 0 (zero).
  • weight - model's weight in kilograms (kg). Takes integer values. If the value is unknown, it defaults to 0 (zero).
  • city - city where the model comes from. It takes string values. If the value is unknown, it defaults to "Unknown".
  • country - the country where the model comes from. It takes string values. If the value is unknown, it defaults to "Unknown".
  • ethn - ethnicity of the model. It takes string values. If the value is unknown, it defaults to "Unknown".
  • birth - model's year of birth. Based on this information, it is possible to calculate the current age of the model. It takes string values. The year is in four-digit format, e.g. "1990". If the value is unknown, it defaults to "0000".
  • sex - model's gender. It takes one of two string values: "female" or "male".
  • totm - year and month in which the model received the "Talent of the Month" title. It takes string values. The year and month are in the "YYYY-MM" format, e.g. "2019-06". If the value is unknown, it defaults to "0".
  • shows - list of shows of a given model. The list contains card identifiers separated by commas. It takes string values. If the model has no card yet, the field defaults to "0".

4.2. is_cards files

  • id - card identifier in the "x0000" format, where "x" is a letter from the range [a-f], while "0000" is the card number. It takes string values.
  • model - list of model identifiers separated by commas. It takes string values.
  • name - list of model names separated by commas. It takes string values.
  • title - card title. It takes string values.
  • coll - name of the collection the card belongs to. It takes one of the following string values: "iStripper", "iStripper XXX", "iStripper Classic", "iStripper XXX Classic", "Virtuagirl Classic" or "Virtuaguy".
  • date - card release date. Date given in the "YYYY-MM-DD" format. It takes string values.
  • rate - card rating. It takes float numeric values to two decimal places. If the value is unknown, it defaults to 0 (zero).
  • sec - determines if the card is a Special Event Card. It takes one of two numerical values: 0 (zero - the card is not a special event card) or 1 (the card is a special event card).
  • tags - list of tags (categories) separated by commas. It takes string values.
  • clips - the number of clips contained in the show. Includes the number of normal clips and the number of normal interactive clips. Does not include demo clips and interactive demo clips. Takes integer values.
  • frames - duration of the show in frames. Takes integer values.
  • level - hotness level. It takes integer values from the range [2-5], where individual digits indicate a specific level: 2 - topless, 3 - nudity, 4 - full nudity, 5 - explicit (XXX).
  • photos - number of bonus photos. Takes integer values.
  • videos - the number of all bonus video clips. Includes standard clips and XXX clips. Takes integer values. If the value is unknown, it defaults to 0 (zero).
  • xvids - the number of bonus video clips. Includes only XXX clips. Takes integer values. If the value is unknown, it defaults to 0 (zero).
  • comm - number of comments. Takes integer values.
  • votes - number of votes. Takes integer values.
  • r480p - total size of all files in the show in 480p resolution. Given in kilobytes [kB]. Takes integer values. If the value is unknown, it defaults to 0 (zero).
  • r720p - total size of all files in the show in 720p resolution. Given in kilobytes [kB]. Takes integer values. If the value is unknown, it defaults to 0 (zero).
  • r1080p - total size of all files in the show in 1080p resolution. Given in kilobytes [kB]. Takes integer values. If the value is unknown, it defaults to 0 (zero).
  • r3k - total size of all files in the show in 3K resolution. Given in kilobytes [kB]. Takes integer values. If the value is unknown, it defaults to 0 (zero).
  • r4k - total size of all files in the show in 4K resolution. Given in kilobytes [kB]. Takes integer values. If the value is unknown, it defaults to 0 (zero).
  • hair - model's hair color in the given show. It takes one of the following string values: "blond", "brown-haired", "fair" or "red hair".
  • price - base price of the card. Takes integer values. If the value is unknown or the card is a Special Event Card, the field defaults to "-".

Related links

Information:

The isDatabase contains information about iStripper models and their shows, but only those shows that are available in the iStripper store are included in the database. The database does not contain information about shows that are not available in the iStripper store.

All informations contained in the isDatabase are available at www.istripper.com or in the iStripper application or on other services available on the Internet. The isDatabase is a collection of those informations.