# CHANGELOG

## **GKSPHONE v1**

{% tabs %}
{% tab title="V1.6.9" %}

## **GKSPHONE V1.6.9 UPDATE (28.07.2023)**

**Files Changed:**&#x20;

* [ ] All Files
* [x] Specific Files
* [x] SQL Change

**QBCore - File changes**

{% code overflow="wrap" lineNumbers="true" %}

```markup
gksphone/client/client.lua
gksphone/client/client2.lua
gksphone/client/clientAPI.lua
gksphone/client/twitter.lua 
gksphone/html/css
gksphone/html/js
gksphone/html/index.html
gksphone/html/static/config/
gksphone/html/static/img/camera/ 
gksphone/html/static/img/icon/ 
gksphone/locales/
gksphone/server/server.lua
gksphone/server/server2.lua
gksphone/server/twitter.lua
gksphone/server/serverAPI/bank.lua
gksphone/server/serverAPI/billing.lua
gksphone/server/serverAPI/serverAPI.lua 
gksphone/config.lua
gksphone/fxmanifest.lua
```

{% endcode %}

**ESX - File changes**

{% code overflow="wrap" lineNumbers="true" %}

```
gksphone/charge/prop.lua
gksphone/client/bank.lua
gksphone/client/client.lua
gksphone/client/client2.lua
gksphone/client/clientAPI.lua
gksphone/client/twitter.lua
gksphone/client/instagram.lua
gksphone/client/yellow.lua
gksphone/html/css
gksphone/html/js
gksphone/html/index.html
gksphone/html/static/config/
gksphone/html/static/img/camera/ 
gksphone/html/static/img/icon/ 
gksphone/locales/
gksphone/server/server.lua
gksphone/server/twitter.lua
gksphone/server/serverAPI/bank.lua
gksphone/server/serverAPI/billing.lua
gksphone/server/serverAPI/serverAPI.lua
gksphone/config.lua
gksphone/fxmanifest.lua
```

{% endcode %}

**SQL**

{% code overflow="wrap" fullWidth="true" %}

```sql
CREATE TABLE `gksphone_twt_users` (
	`user_id` INT(11) NOT NULL AUTO_INCREMENT,
	`identifier` LONGTEXT NOT NULL COLLATE 'utf8_general_ci',
	`username` VARCHAR(255) NOT NULL COLLATE 'utf8_general_ci',
	`password` VARCHAR(255) NOT NULL COLLATE 'utf8_general_ci',
	`displayname` VARCHAR(255) NOT NULL COLLATE 'utf8_general_ci',
	`avatar` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`banner` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`is_verified` INT(11) NOT NULL DEFAULT '0',
	`verifedbuytime` TIMESTAMP NULL DEFAULT current_timestamp(),
	`banned` INT(11) NOT NULL DEFAULT '0',
	`created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	PRIMARY KEY (`user_id`) USING BTREE,
	UNIQUE INDEX `unique_username` (`username`) USING BTREE
) COLLATE='utf8_general_ci';

CREATE TABLE `gksphone_twt_posts` (
	`post_id` INT(11) NOT NULL AUTO_INCREMENT,
	`identifier` LONGTEXT NOT NULL COLLATE 'utf8_general_ci',
	`user_id` INT(11) NULL DEFAULT NULL,
	`content` LONGTEXT NOT NULL COLLATE 'utf8_general_ci',
	`media` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`poll_options` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`end_date` TIMESTAMP NULL DEFAULT NULL,
	`comment` INT(11) NOT NULL DEFAULT '0',
	`commentid` INT(11) NOT NULL DEFAULT '0',
	`pinned` INT(11) NOT NULL DEFAULT '0',
	`created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	PRIMARY KEY (`post_id`) USING BTREE,
	INDEX `user_id` (`user_id`) USING BTREE,
	CONSTRAINT `gksphone_twt_posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `gksphone_twt_users` (`user_id`) ON UPDATE RESTRICT ON DELETE RESTRICT,
	CONSTRAINT `poll_options` CHECK (json_valid(`poll_options`))
) COLLATE='utf8_general_ci';

CREATE TABLE `gksphone_twt_likepost` (
	`like_id` INT(11) NOT NULL AUTO_INCREMENT,
	`postid` INT(11) NOT NULL,
	`userid` INT(11) NOT NULL,
	`created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	PRIMARY KEY (`like_id`) USING BTREE,
	INDEX `userid` (`userid`) USING BTREE,
	INDEX `postid` (`postid`) USING BTREE,
	CONSTRAINT `FK_gksphone_twt_likepost_gksphone_twt_posts` FOREIGN KEY (`postid`) REFERENCES `gksphone_twt_posts` (`post_id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
	CONSTRAINT `FK_gksphone_twt_likepost_gksphone_twt_users` FOREIGN KEY (`userid`) REFERENCES `gksphone_twt_users` (`user_id`) ON UPDATE NO ACTION ON DELETE NO ACTION
) COLLATE='utf8_general_ci';


CREATE TABLE `gksphone_twt_retweet` (
	`retwettsid` INT(11) NOT NULL AUTO_INCREMENT,
	`postid` INT(11) NOT NULL,
	`userid` INT(11) NOT NULL,
	`created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	PRIMARY KEY (`retwettsid`) USING BTREE,
	INDEX `userid` (`userid`) USING BTREE,
	INDEX `postid` (`postid`) USING BTREE,
	CONSTRAINT `FK_gksphone_twt_retweet_gksphone_twt_posts` FOREIGN KEY (`postid`) REFERENCES `gksphone_twt_posts` (`post_id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
	CONSTRAINT `FK_gksphone_twt_retweet_gksphone_twt_users` FOREIGN KEY (`userid`) REFERENCES `gksphone_twt_users` (`user_id`) ON UPDATE NO ACTION ON DELETE NO ACTION
) COLLATE='utf8_general_ci';

CREATE TABLE `gksphone_twt_hastags` (
	`hastag_id` INT(11) NOT NULL AUTO_INCREMENT,
	`hastag` VARCHAR(250) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
	`postid` INT(11) NOT NULL,
	`created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	PRIMARY KEY (`hastag_id`) USING BTREE,
	INDEX `postid` (`postid`) USING BTREE,
	CONSTRAINT `FK_gksphone_twt_hastags_gksphone_twt_posts` FOREIGN KEY (`postid`) REFERENCES `gksphone_twt_posts` (`post_id`) ON UPDATE NO ACTION ON DELETE NO ACTION
) COLLATE='utf8_general_ci';

CREATE TABLE `gksphone_twt_followers` (
	`follow_id` INT(11) NOT NULL AUTO_INCREMENT,
	`userid` INT(11) NOT NULL,
	`followid` INT(11) NOT NULL,
	`created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	PRIMARY KEY (`follow_id`) USING BTREE,
	INDEX `userid` (`userid`) USING BTREE,
	INDEX `FK_gksphone_twt_follower_gksphone_twt_users` (`followid`) USING BTREE,
	CONSTRAINT `FK_gksphone_twt_follower_gksphone_twt_users` FOREIGN KEY (`followid`) REFERENCES `gksphone_twt_users` (`user_id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
	CONSTRAINT `FK_gksphone_twt_followers_gksphone_twt_users` FOREIGN KEY (`userid`) REFERENCES `gksphone_twt_users` (`user_id`) ON UPDATE NO ACTION ON DELETE NO ACTION
) COLLATE='utf8_general_ci';
```

{% endcode %}

**Changelog:**

{% hint style="success" %}
**Add**

* Squawk's design has completely changed, and the application has been completely renewed.
* The image attachment limit for your posts has been increased to 4.
* Poll feature has been added (max. 4 choices).
* Voice Post feature has been added.
* Video Post feature has been added.
* Follow system has been added.
* Hashtag system has been added.
* Trends system has been added.
* Post search system has been added.
* User mention feature has been added to posts.
* New notifications have been added; now you can directly go to the post related to the notification from your notification page.
* Post pinning feature has been added.
* Repost feature has been added.
* An additional post page has been created for the Comment feature.
* In your profile, posts, likes, and reposts are now shown in 3 separate sections.
* Verified Account system has been introduced (Get a blue tick with a customizable subscription fee). (Set day period and price in config.lua)
* Yellow tick has been added for businesses and other accounts (can only be granted by admins via command).
* Account banning feature has been added (/bantwitter true/false username).
* Now, on your homepage feed, you can choose to see posts from everyone or only from the users you follow.
* Added support for bcs-housing.
* Added Portuguese (PT) language support.
* Added Dutch (NL) language support.
* Added Polish (PL) language support.
* Tipping through Bussines will now come from the company's funds.
* In Bussines application, salaries of employees will now only be visible to authorized personnel.
* ESX billing server-side integration has been added for Billing.
* Twitter webhook design has been updated.
* Support for ox\_target has been added, and support for qtarget from ESX has been removed.
  {% endhint %}

{% hint style="warning" %}
**Fix**

* Fixed the issue with zedge ringtones.
* Disabled server-side weather control.
* Moved ox\_inventory client-side control to the correct file.
* Fixed the NumberChange export issue in ESX.
* Fixed the JobDispatch export issue in QB.
* News app Sidebar will now automatically close after making a selection.
* The emoji on the phone was causing space issues and centered, now moved to the left side of the phone.
* The emoji panel will now automatically close when you drag the mouse away after selecting an emoji.
* NSFW detector has been turned off.
* Fixed the issue where owned car data in ESX was corrupted, causing cars not to appear at the valet.
* Fixed the error that appeared in the server console when messages were deleted in ESX.
* Fixed the issue where the airdrop didn't close in the contacts when turned off via config.json.
* Unnecessary images in the image files have been cleaned up.
  {% endhint %}

{% embed url="<https://youtu.be/3-pXV79fg6Q>" %}

<figure><img src="https://media.discordapp.net/attachments/887233742303809536/1134313929619800195/deneme.png?width=1440&#x26;height=638" alt="" width="563"><figcaption><p>Squawk(Twitter) APP</p></figcaption></figure>
{% endtab %}

{% tab title="V1.6.8" %}

## **GKSPHONE V1.6.8 UPDATE (01.06.2023)**

**Files Changed:**&#x20;

* [x] All Files
* [ ] Specific Files
* [x] SQL Change

**QBCORE - SQL**

{% code overflow="wrap" %}

```sql
//QBCORE
ALTER TABLE `gksphone_twitter_tweets` ADD COLUMN `isNSFW` TINYINT(4) NOT NULL DEFAULT '0';
```

{% endcode %}

**ESX - SQL**

{% code overflow="wrap" fullWidth="true" %}

```sql
//ESX
CREATE TABLE `gksphone_invoices` (
    `id` INT(10) NOT NULL AUTO_INCREMENT,
    `citizenid` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
    `amount` INT(11) NOT NULL DEFAULT '0',
    `society` TINYTEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci',
    `sender` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
    `sendercitizenid` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
    `label` VARCHAR(250) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `citizenid` (`citizenid`) USING BTREE
)
COLLATE='utf8_general_ci';

ALTER TABLE `gksphone_twitter_tweets` ADD COLUMN `isNSFW` TINYINT(4) NOT NULL DEFAULT '0';
```

{% endcode %}

**Changelog:**

{% hint style="success" %}
**Add**

* Business App redesigned,
* Added create bill feature from Business App (you can create invoice with ID, Contacts and Airdrop options),
* We have our own billing system in the business app, you don't need any billing script anymore,
* It can now be seen whether employees are active in the game in the Business application in ESX,
* Business App logo color changed,
* Contacts App redesigned,
* Standard user avatar changed,
* Added your own number card (You can now see your number at the top of the app and share it with airdrop),
* Live Stream App Donate Added, (When you donate, it appears on the broadcast screen and when the amount you set is exceeded, a congratulatory gif appears),
* Added Live Stream App Viewer Count (only viewers can see it),
* Added ban option for Live Stream App chat (When the viewer leaves the broadcast and rejoins, the ban will be lifted),
* You can now delete your own listing in the Car Seller app,
* Added a red mark to distinguish your own postings in Car Seller app,
* Added NSFW image detection system for Squawk, if an image contains nsfw elements it will be displayed with blur and warning text (You can only see the image when you click on the image, this system is currently a beta feature),
* Added detailed information of users as logs for SnapGram, Advertising and Squawk (ConfigAPI.lua),
* Added command to turn SnapGram, Advertising and Squawk posting off and on,
* Now squawk, snapgram, advertising etc. You will not receive notifications from these applications while browsing in applications such as,
* Size limit has been added to photos in Squawk and Advertising posts. This limit is set as 10 mb by default, you can edit it in config.json, (it was done to prevent images like 50-60 mb and ping values to increase),
* Added sharing feature to Note application (Make sure that note titles aren't the same),
* If the webhook is missing in the camera application, now a warning has been added to the camera,
* Added export option for phone number change,
* Added select multiple contacts to all Airdrop feature,)
* Timeout system has been added against dupe attempts by slowing down/disconnecting the internet connection (In some applications, those who want to dupe are blocked),
* /phonenumberchange source(player id) newnumber (Added change number command),
* Music and PlayTube applications have been arranged for the subscription system and tbx-id has been moved to the configAPI.lua file in case of dumping,
* Fixed a problem in bank reflections of transactions while trading Stock Market coin,
* Added ps-dispatch support for qb-core. (<https://github.com/Project-Sloth/ps-dispatch>)
  {% endhint %}

{% hint style="warning" %}
**Fix**

* Export has been added to prevent the character from moving while typing in the input field for Custom App (download again from github for custom app)
* Fixed issue where SendNuiMessage function not working in Custom App (download updated versionfrom github (This compatibility is compatible as of gksphone v1.6.8))
* The problems with the signal system have been fixed (When the phone is in an area where the phone is not receiving anymore, the phone returns to the home page and open call are canceled),
* Fixed an issue that prevented images from being displayed full-screen in the News app,
* Fixed the issue of the car being dupe when spammed in valet (Added a notification when you call bring a car)
* Helicopters, boats, planes can no longer be brought in valet application
* Fixed the issue of notifications from some apps when the phone wasn't in your inventory,
* Fixed an issue with Instagram notifications,
* Fixed the offensiveness of the valet npcs that brought your vehicle,
* Unnecessary codes cleared,
* Fixed the issue of earning extra money in Crypto app,
* The problem has been fixed when adjusting the level of the officers on the ESX side in the Bussines app,
* Fixed issue with font-awesome.
  {% endhint %}

{% embed url="<https://youtu.be/wgPZaYU24es>" fullWidth="true" %}

<figure><img src="https://cdn.discordapp.com/attachments/809832993094631424/1113860835689893968/livestreamhepsi2.png" alt="" width="563"><figcaption><p>LiveStream APP</p></figcaption></figure>

<figure><img src="https://cdn.discordapp.com/attachments/809832993094631424/1113860836654600252/businesshepsi.png" alt="" width="563"><figcaption><p>Bussiness APP</p></figcaption></figure>

<figure><img src="https://cdn.discordapp.com/attachments/809832993094631424/1113860837938057256/contactshepsi.png" alt="" width="563"><figcaption><p>Contacts APP</p></figcaption></figure>
{% endtab %}

{% tab title="V1.6.7" %}

### GKSPHONE V1.6.7 UPDATE (10.04.2023)

**Changelog:**

{% hint style="success" %}
**Add**

* Mail application redesigned,
* Note application redesigned,
* Added the feature of adding pictures to the Note application,
* Names and logos of applications bearing the real brand name have been changed due to copyright,
  {% endhint %}

{% hint style="warning" %}
**Fix**

* FPS optimized for Facetime and LiveStream App,
* The infrastructure system for Facetime and LiveStream has been changed (the old infrastructure will be closed after 1 week),
* The freezing problem in the LiveStream application has been resolved,
* Watching or broadcasting the LiveStream app now reduces battery power,
* Triggers blocked from running when Internet connection lost,
* Fixed an issue with Twitter Blue tick display,
* Fixed an issue with bank commission preview in ESX.
  {% endhint %}

<figure><img src="https://media.discordapp.net/attachments/809832993094631424/1095051122332409946/noteupdate.png?width=1193&#x26;height=671" alt="" width="375"><figcaption><p>Note APP</p></figcaption></figure>

<figure><img src="https://cdn.discordapp.com/attachments/809832993094631424/1095051122999316600/mailupdate.png" alt="" width="375"><figcaption><p>Mail APP</p></figcaption></figure>
{% endtab %}
{% endtabs %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.gkshop.org/changelog.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
