💡CHANGELOG

Update Notes

GKSPHONE

GKSPHONE V1.6.9 UPDATE (28.07.2023)

Files Changed:

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.

Last updated