💡CHANGELOG

Update Notes

GKSPHONE v1

V1.6.9

GKSPHONE V1.6.9 UPDATE (28.07.2023)

Files Changed:

• All Files

• Specific Files

• SQL Change

QBCore - File changes

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

ESX - File changes

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

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';

Changelog:

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.

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.

Squawk(Twitter) APP

V1.6.8

V1.6.7