How to create table ?

[nowofresh]

Hey,

How Can table with categories

Users

-ID

-X

-Y

-Z

-Username

-Nick

I don't know how to use MTA-MySQL functions to do this.

Can u write for me, example script ?

[nowofresh]

Anyone know ?

[Timic]

There are 'MySQL' functions https://wiki.multitheftauto.com/wiki/Mysql

[proracer]

Ok a very simple one.

function startSQLOnStart() 
executeSQLCreateTable("Users", "Serial STRING") 
executeSQLCreateTable("EveryIDName", "ID INT") 
executeSQLCreateTable("XPosName", "XPos INT") 
executeSQLCreateTable("YPosName", "YPos INT") 
executeSQLCreateTable("ZPosName", "Zpos INT") 
end 
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), startSQLOnStart) 

When you create table you can save things into it.

[eAi]

That looks completely wrong.

[proracer]

Than I'm sorry.

(and what is wrong)

[eAi]

You're creating 5 tables - he wants one table with 7 columns.

[proracer]

Ahhh... I'm totally sorry man

[12p]

I'm not an expert in SQL, I just started to use it >.<

But this could work:

executeSQLCreateTable("TheTableName", "player TEXT, playerid INTEGER, posX INTEGER, posY INTEGER, posZ INTEGER") 

You can do anything you want with that table using the following functions:

executeSQLUpdate 
executeSQLInsert 
executeSQLSelect 
executeSQLQuery 

Click on every function name to visit wiki documentation and learn.

[proracer]

Yes and you can add column by this function:

exports.scoreboard:addScoreboardColumn(") 

(I think) ^^

[12p]

Your [lua] tag is FAIL lol.

Scoreboard could be used to show the player stats to all, but there is very low width to make columns huh.