Docs - Database. · FixCore

fx_changelogs

Here all changes are stored, by date packages.

Column Name	Type	Key	Null	Comment
id	int (10)	Yes	No	Autoincrementable
title	varchar (100)	No
description	text		No
date	int (10)		No

title

Package name, try to make it very short.

description

List of changes.

date

Creation Date. Timestamp must be used

fx_chars_annotations

Here the account entries are saved

Column Name	Type	Key	Null	Comment
id	int (10)	Yes	No	Autoincrementable
idchar	int (10)
annotation	text		No
date	int (10)		No

iduser

Character Guid. It is taken from characters

annotation

Annotation

date

Date of the annotation. Timestamp must be used

fx_country

Here all countries are stored. In the registry you can choose the country of origin and take this table.

Column Name	Type	Null	Default	Comment
id	int (10)	No		Autoincrementable
country_code	varchar (2)	No	’’
country_name	varchar (100)	No	’’

country_code

Unique code of the country.

country_name

Country name

fx_events

Here the custom server events are stored.

Column Name	Type	Key	Null	Comment
id	int (10)	Yes	No	Autoincrementable
title	varchar (100)		No
description	text		No
date_event_start	int (10)		No
date_event_end	int (10)		No
date	int (10)		No

title

Name of the event

description

Description of the event

date_event_start

Start date of the event, you must use timestamp

date_event_end

Final date of the event, you must use timestamp

date

Publication date you must use timestamp

fx_forum_category

Here you will create the forum categories

Column Name	Type	Key	Null	Default	Comment
id	int (10)	Yes	No		Autoincrementable
categoryName	varchar (100)		No

categoryName

Name of the category

fx_forum_comments

Here the comments of the topics are saved

Column Name	Type	Key	Null	Comment
id	int (10)	Yes	No	Autoincrementable
topic	int (10)		No
author	int (10)		No
topic	int (10)		No
commentary	text		No
date	int (10)		No

topic

ID of the topic, it is taken from fx_forum_forums

author

ID of the creator of the comment, it is taken from account

commentary

Commentary

date

Publication date you must use timestamp

fx_forum_forums

Here you create the sections of the forum categories.

Column Name	Type	Key	Null	Default	Comment
id	int (10)	Yes	No		Autoincrementable
name	varchar (100)		No
category	int (10)		No
description	tex		No
icon	varchar (100)		No	icon1.png
type	int (1)		No	1

name

Name of the category

category

ID of the category, it is taken from fx_forum_category

description

A brief description of what the category will be used for

icon

Icon name next to its .jpg or .png extension

You can see the icons available in assets/images/forums/icons

type

Everyone can see the category
Only the STAFF can see the category
Everyone can see the category but only the STAFF can create topics

The STAFF is defined from the account_access

fx_forum_topics

Here all the topics are saved.

Column Name	Type	Key	Null	Default	Comment
id	int (10)	Yes	No		Autoincrementable
forums	int (10)		No
title	varchar (100)		No
author	int (10)		No
date	int (10)		No
content	tex		No
locked	tinyint (1)		No	0
pined	tinyint (1)		No	0
archivar	int (1)		No	0

forums

ID of the category, it is taken from fx_forum_forums

title

Title of the publication

author

ID of the creator of the publication, it is taken from account

date

Publication date you must use timestamp

content

Content of the publication

locked

1 = Blocked, can not comment
0 = You can comment

pined

1 = It will stand out
0 = Normal

fx_news

Here the news is hosted.

Column Name	Type	Key	Null	Default	Comment
id	int (10)	Yes	No		Autoincrementable
title	varchar (100)		No
image	varchar (100)		No	new.jpg	assets/images/news
description	text		No
date	int (10)		No

title

Name of the news

image

Name of the image file together with its extension. Unable to add external urls

description

Description of the news

The images must be lodged in this route assets/images/news

date

Publication date you must use timestamp

fx_news_comments

Here the comments of the news are saved

Column Name	Type	Key	Null	Comment
id	int (10)	Yes	No	Autoincrementable
id_new	int (10)
commentary	text		No
date	int (10)		No
author	int (10)		No

id_new

ID of the news, it is taken from fx_news

commentary

Comment for the news

date

Date of the comment. Timestamp must be used

author

ID of the person who comments. It is taken from fx_users

fx_news_top

Here you will take the highlighted news

It will only take 1 and is ordered from highest to lowest by ID

Column Name	Type	Key	Null	Default	Comment
id	int (10)	Yes	No		Autoincrementable
id_new	int (10)		No

id_new

Id of the news

The id is the same as fx_news

fx_questions

Here secret questions are taken for registration

Column Name	Type	Key	Null	Default	Comment
id	int (10)	Yes	No		Autoincrementable
question	varchar (100)		No

question

The secret question.

fx_ranks

Here you can edit all permissions

Column Name	Type	Key	Null	Default	Comment
id	int (10)		No		Autoincrementable
permission	int (10)		No

ID user.
It can be obtained from account

permission

1 = Can join to AdminPanel

fx_shop

Here everything that will be sold in the store is saved.

Column Name	Type	Key	Null	Comment
id	int (10)	Yes	No	Autoincrementable
title	varchar (100)		No
description	text		No
image	varchar (100)		No	assets/images/shop
price_donate	int (11)
price_vote	int (11)
type	int (11)		No	1-item or 2-query
type_id	int (11)			only if type = 1
type_query	varchar (100)			only if type = 2

title

Product name

description

Product description

image

Name of the image file next to its extension. External URLs are not accepted.

The image must be saved in assets/images/shop

price_donate

Value of the product with the donation currency

price_vote

Value of the product with the voting currency

type

1 = If the product is an item
2 = If the product is a SQL query

type_id

Here you will put the id of the item, it must exist in your world -> item_template

Remember that to use this method you must type 1

type_query

Here you should use the query with SQL syntax. Some shortcuts:
Get account id: { fx_sess_id }
1. Query example: “UPDATE account SET name = ‘newname’ WHERE id = $id”;

fx_shop_top

Here you will take the best items from the store

The system will take maximum 10 products and is ordered from highest to lowest by ID

Column Name	Type	Key	Null	Default	Comment
id	int (10)	Yes	No		Autoincrementable
id_shop	int (11)		No

id_shop

Product Id

It can be obtained from account

fx_slides

Here you will take the best items from the store

The system will take maximum 10 products and is ordered from highest to lowest by ID

Column Name	Type	Key	Null	Default	Comment
id	int (10)	Yes	No		Autoincrementable
title	varchar (100)
image	varchar (100)		No	image.jpg	assets/images/slides
mobile_image	varchar (100)		No	imagemobile.jpg	assets/images/slides

title

Product Id

Title of the Slide, it will appear.

image

Name of the file along with its extension. External URLs are not accepted.

The image must be hosted in: assets/images/slides

mobile_image

Image for small devices. Name of the file along with its extension. External URLs are not accepted.

The image must be hosted in: assets/images/slides

fx_slides

Here you will take the best items from the store

The system will take maximum 10 products and is ordered from highest to lowest by ID

Column Name	Type	Key	Null	Default	Comment
id	int (10)	Yes	No		Autoincrementable
title	varchar (100)
image	varchar (100)		No	image.jpg	assets/images/slides
mobile_image	varchar (100)		No	imagemobile.jpg	assets/images/slides

title

Product Id

Title of the Slide, it will appear.

image

Name of the file along with its extension. External URLs are not accepted.

The image must be hosted in: assets/images/slides

mobile_image

Image for small devices. Name of the file along with its extension. External URLs are not accepted.

The image must be hosted in: assets/images/slides

fx_tags

This is an identical system to #battletag.

The user will be assigned 4 random numbers and will work with his name # numbers

For example: FIXCORE#1234

Column Name	Type	Key	Null	Default	Comment
id	int (10)	Yes	No
tag	varchar (100)		No

ID of the account, is in account

tag

4 Assigned random numbers

fx_users

Here all countries are stored. In the registry you can choose the country of origin and take this table.

Column Name	Type	Key	Null	Default
id	int (10)	Yes	No
name	varchar (100)		No
surname	varchar (100)		No
username	varchar (100)		No
email	varchar (100)		No
question	int (10)		No
answer	varchar (100)		No
year	int (10)		No
month	int (10)		No
day	int (10)		No
date	int (10)		No
profile	varchar (100)		No	default.jpg

ID of the account, is in account.

name

First name - It will be taken from the registry.

surname

Last name - It will be taken from the registry.

username

Username - It will be taken from the registry.

email

Email - It will be taken from the registry.

question

Question - It will be taken from the registry.

They are extracted from fx_questions

answer

Secret answer - It will be taken from the registry.

year

Year of birth - It will be taken from the registry.

month

Month of birth - It will be taken from the registry.

day

Day of birth - It will be taken from the registry.

date

Registration date - It will be taken from the registry.

Timestamp must be used

profile

Name of the image file

It is obtained from assets/images/profiles

fx_users_annotations

Here the account entries are saved

Column Name	Type	Key	Null	Comment
id	int (10)	Yes	No	Autoincrementable
iduser	int (10)
annotation	text		No
date	int (10)		No

iduser

ID of the person. It is taken from account

annotation

Annotation

date

Date of the annotation. Timestamp must be used