#OPLeak | www.indembassy.org.tr By GrenXPaRTa

http://www.indembassy.org.tr/
web server operating system: Windows 8.1 or 2012 R2
web application technology: ASP.NET, Microsoft IIS 8.5
back-end DBMS: MySQL >= 5.0.0
available databases [3]:
[*] information_schema
[*] jadon_eoiturkey
[*] test

Database: jadon_eoiturkey
Table: cgiturkey_events_category
[10 columns]
+------------+------------+
| Column     | Type       |
+------------+------------+
| categoryid | bigint(20) |
| createdate | date       |
| detail     | text       |
| detail_ol  | text       |
| heading    | text       |
| heading_ol | text       |
| imgName    | text       |
| modifydate | date       |
| numbering  | int(11)    |
| status     | text       |
+------------+------------+

Database: jadon_eoiturkey
Table: turkey_admin
[3 columns]
+-----------+-------------+
| Column    | Type        |
+-----------+-------------+
| admin     | varchar(20) |
| logintype | varchar(50) |
| password  | varchar(20) |
+-----------+-------------+

Database: jadon_eoiturkey
Table: turkey_embassy_staff
[13 columns]
+----------------+--------------+
| Column         | Type         |
+----------------+--------------+
| createdate     | date         |
| designation    | varchar(100) |
| designation_it | varchar(200) |
| detail         | text         |
| detail_it      | text         |
| email          | varchar(50)  |
| fax            | varchar(100) |
| imgName        | varchar(200) |
| modifydate     | date         |
| name           | varchar(150) |
| name_it        | varchar(200) |
| phone          | varchar(50)  |
| staffid        | bigint(20)   |
+----------------+--------------+

Database: jadon_eoiturkey
Table: turkey_guide
[8 columns]
+-----------------+--------------+
| Column          | Type         |
+-----------------+--------------+
| year            | int(4)       |
| catalogFileName | varchar(250) |
| createdate      | date         |
| detail          | text         |
| guidecategory   | int(11)      |
| guidedate       | date         |
| guideid         | bigint(20)   |
| heading         | text         |
+-----------------+--------------+

Database: jadon_eoiturkey
Table: turkey_holidays
[5 columns]
+-------------+-------------+
| Column      | Type        |
+-------------+-------------+
| createdate  | date        |
| detail      | text        |
| holidaydate | date        |
| holidayid   | int(11)     |
| holidayname | varchar(50) |
+-------------+-------------+

Database: jadon_eoiturkey
Table: turkey_usefullink_product
[7 columns]
+-------------------+------------+
| Column            | Type       |
+-------------------+------------+
| createdate        | date       |
| departmentlink    | text       |
| departmentname    | text       |
| departmentname_it | text       |
| linkcategoryid    | bigint(20) |
| linkproductid     | bigint(20) |
| modifydate        | date       |
+-------------------+------------+

Database: jadon_eoiturkey
Table: cgiturkey_feedback
[17 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| adalvic    | text    |
| address    | text    |
| city       | text    |
| country    | text    |
| createdate | date    |
| detail     | text    |
| email      | text    |
| feedbackid | int(11) |
| heading    | text    |
| message    | text    |
| name       | text    |
| phone      | text    |
| price      | text    |
| qty        | text    |
| quantity   | text    |
| service    | text    |
| state      | text    |
+------------+---------+

Database: jadon_eoiturkey
Table: cgiturkey_news_category
[12 columns]
+------------------+------------+
| Column           | Type       |
+------------------+------------+
| categoryid       | bigint(20) |
| createdate       | date       |
| detail           | text       |
| detail_ol        | text       |
| heading          | text       |
| heading_ol       | text       |
| imgName          | text       |
| meta_description | text       |
| meta_keyword     | text       |
| meta_title       | text       |
| modifydate       | date       |
| numbering        | bigint(20) |
+------------------+------------+

Database: jadon_eoiturkey
Table: cgiturkey_events
[10 columns]
+------------+------------+
| Column     | Type       |
+------------+------------+
| categoryid | bigint(20) |
| createdate | date       |
| detail     | text       |
| detail_ol  | text       |
| eventsid   | int(11)    |
| heading    | text       |
| heading_ol | text       |
| imgName    | text       |
| numbering  | int(11)    |
| status     | text       |
+------------+------------+

Database: jadon_eoiturkey
Table: turkey_usefullink_category
[4 columns]
+----------------+------------+
| Column         | Type       |
+----------------+------------+
| createdate     | date       |
| heading        | text       |
| linkcategoryid | bigint(20) |
| modifydate     | date       |
+----------------+------------+

Database: jadon_eoiturkey
Table: cgiturkey_still_photo
[13 columns]
+--------------+------------+
| Column       | Type       |
+--------------+------------+
| categoryid   | bigint(20) |
| createdate   | date       |
| detail       | text       |
| detail_ol    | text       |
| gallery_type | text       |
| heading      | text       |
| heading_ol   | text       |
| imgName      | text       |
| modifydate   | date       |
| name         | text       |
| numbering    | int(11)    |
| priority     | text       |
| stillid      | int(11)    |
+--------------+------------+

Database: jadon_eoiturkey
Table: turkey_staticpage
[12 columns]
+------------------+--------------+
| Column           | Type         |
+------------------+--------------+
| catalogFileName  | varchar(250) |
| catalogFileName2 | varchar(250) |
| createdate       | date         |
| detail           | longtext     |
| detail_it        | longtext     |
| heading          | text         |
| heading_it       | text         |
| imgName          | varchar(250) |
| imgName2         | varchar(250) |
| staticpage       | text         |
| staticpageid     | bigint(20)   |
| status           | text         |
+------------------+--------------+

Database: jadon_eoiturkey
Table: turkey_business_query
[11 columns]
+--------------+--------------+
| Column       | Type         |
+--------------+--------------+
| address      | text         |
| createdate   | datetime     |
| detail       | text         |
| email        | varchar(100) |
| id           | bigint(20)   |
| mobile       | varchar(15)  |
| name         | varchar(80)  |
| occupation   | varchar(200) |
| organization | varchar(200) |
| phone        | varchar(60)  |
| type         | varchar(20)  |
+--------------+--------------+

Database: jadon_eoiturkey
Table: turkey_csv_file
[3 columns]
+------------+------------------+
| Column     | Type             |
+------------+------------------+
| createdate | date             |
| fileName   | varchar(80)      |
| id         | int(10) unsigned |
+------------+------------------+

Database: jadon_eoiturkey
Table: turkey_passport_detail
[15 columns]
+---------------+-------------+
| Column        | Type        |
+---------------+-------------+
| applicantname | text        |
| applicanttype | varchar(50) |
| createdate    | date        |
| dateofbirth   | date        |
| expiry_date   | date        |
| fathername    | text        |
| fees          | bigint(50)  |
| fileno        | varchar(50) |
| issuing_date  | date        |
| itam          | varchar(50) |
| modifydate    | date        |
| oldppt        | varchar(50) |
| passportid    | int(11)     |
| ppt           | varchar(50) |
| reciptno      | varchar(50) |
+---------------+-------------+

Database: jadon_eoiturkey
Table: turkey_passport_detail_final
[17 columns]
+---------------+---------------------+
| Column        | Type                |
+---------------+---------------------+
| date          | date                |
| applicanttype | varchar(50)         |
| createdate    | date                |
| dob           | date                |
| doe           | date                |
| doi           | date                |
| father        | varchar(150)        |
| fees          | varchar(100)        |
| fileid        | varchar(50)         |
| fileno        | varchar(100)        |
| id            | bigint(20) unsigned |
| itam          | varchar(50)         |
| modifydate    | date                |
| name          | varchar(150)        |
| oldppt        | varchar(100)        |
| ppt           | varchar(50)         |
| snum          | varchar(10)         |
+---------------+---------------------+

Database: jadon_eoiturkey
Table: turkey_home_news
[7 columns]
+-----------------+--------------+
| Column          | Type         |
+-----------------+--------------+
| year            | int(4)       |
| catalogFileName | varchar(250) |
| createdate      | date         |
| detail          | text         |
| heading         | text         |
| newsdate        | date         |
| newsid          | bigint(20)   |
+-----------------+--------------+

Database: jadon_eoiturkey
Table: turkey_passport_detail_test
[14 columns]
+---------------+--------------+
| Column        | Type         |
+---------------+--------------+
| date          | varchar(10)  |
| applicanttype | varchar(50)  |
| dob           | varchar(10)  |
| doe           | varchar(10)  |
| doi           | varchar(10)  |
| father        | varchar(150) |
| fees          | varchar(100) |
| fileid        | varchar(50)  |
| fileno        | varchar(100) |
| itam          | varchar(50)  |
| name          | varchar(150) |
| oldppt        | varchar(100) |
| ppt           | varchar(50)  |
| snum          | varchar(10)  |
+---------------+--------------+

Database: jadon_eoiturkey
Table: turkey_reg_ind_national
[10 columns]
+----------------+------------------+
| Column         | Type             |
+----------------+------------------+
| address        | text             |
| createdate     | date             |
| date_of_expiry | date             |
| date_of_issue  | date             |
| email          | varchar(80)      |
| id             | int(10) unsigned |
| name           | varchar(200)     |
| passportNo     | varchar(50)      |
| profession     | varchar(50)      |
| telephone      | varchar(50)      |
+----------------+------------------+

Database: jadon_eoiturkey
Table: cgiturkey_gallery_category
[9 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| categoryid | int(11) |
| createdate | date    |
| detail     | text    |
| detail_ol  | text    |
| heading    | text    |
| heading_ol | text    |
| imgName    | text    |
| modifydate | date    |
| numbering  | int(11) |
+------------+---------+

Database: jadon_eoiturkey
Table: cgiturkey_banner
[7 columns]
+------------+---------+
| Column     | Type    |
+------------+---------+
| bannerid   | int(11) |
| createdate | date    |
| heading    | text    |
| heading_ol | text    |
| imgName    | text    |
| modifydate | date    |
| numbering  | int(11) |
+------------+---------+

Database: jadon_eoiturkey
Table: cgiturkey_news
[15 columns]
+------------------+------------+
| Column           | Type       |
+------------------+------------+
| categoryid       | bigint(20) |
| createdate       | date       |
| detail           | text       |
| detail_ol        | text       |
| fileUpload       | text       |
| heading          | text       |
| heading_ol       | text       |
| imgName          | text       |
| meta_description | text       |
| meta_keyword     | text       |
| meta_title       | text       |
| newsid           | int(11)    |
| numbering        | int(11)    |
| url              | text       |
| vid_link         | text       |
+------------------+------------+

Database: jadon_eoiturkey
Table: turkey_news
[7 columns]
+-----------------+--------------+
| Column          | Type         |
+-----------------+--------------+
| year            | int(4)       |
| catalogFileName | varchar(250) |
| createdate      | date         |
| detail          | text         |
| heading         | text         |
| newsdate        | date         |
| newsid          | bigint(20)   |
+-----------------+--------------+