[ngocson389]

data is'nt save to database , help me plss

https://www.youtube.com/watch?v=mRsF_Dr8HVM&feature=youtu.be

[!]

Quote from ngocson389 on June 5th, 2016, 06:01 AM

data is'nt save to database , help me plss

@ngocson389

Add this in Function OnScriptLoad;

Code: [Select]

//Add here...
//function onScriptLoad()
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Accounts ( Name VARCHAR(255), Password VARCHAR(255), Cash INT, Bank INT, Kills INT, Deaths INT, Level INT, LastActive INT, LastUsedIP VARCHAR(255), DateRegistered INT)" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Bans ( NameLower VARCHAR(255), UID VARCHAR(255), Reason VARCHAR(255))"  );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Gotoloc ( Name VARCHAR(32), x INT, y INT, z INT, Creator VARCHAR(32))"  );


[ngocson389]

Quote from zeus on June 6th, 2016, 09:35 AM

Quote from ngocson389 on June 5th, 2016, 06:01 AM

data is'nt save to database , help me plss

@ngocson389

Add this in Function OnScriptLoad;

Code: [Select]

//Add here...
//function onScriptLoad()
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Accounts ( Name VARCHAR(255), Password VARCHAR(255), Cash INT, Bank INT, Kills INT, Deaths INT, Level INT, LastActive INT, LastUsedIP VARCHAR(255), DateRegistered INT)" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Bans ( NameLower VARCHAR(255), UID VARCHAR(255), Reason VARCHAR(255))"  );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Gotoloc ( Name VARCHAR(32), x INT, y INT, z INT, Creator VARCHAR(32))"  );


It's work :D Tks u for help...

[SomeoneRandom]

My Database is not working. Data does not save when I register. I manually entered my name and password once in database and played the game my IP was saved. But it does not save user automatically. Link:::----  https://www.mediafire.com/file/6j6ev8ly32ij4ma/database.db  .
Please fix.

[Eva]

Quote from zeus on June 6th, 2016, 09:35 AM

Quote from ngocson389 on June 5th, 2016, 06:01 AM

data is'nt save to database , help me plss

@ngocson389

Add this in Function OnScriptLoad;

Code: [Select]

//Add here...
//function onScriptLoad()
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Accounts ( Name VARCHAR(255), Password VARCHAR(255), Cash INT, Bank INT, Kills INT, Deaths INT, Level INT, LastActive INT, LastUsedIP VARCHAR(255), DateRegistered INT)" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Bans ( NameLower VARCHAR(255), UID VARCHAR(255), Reason VARCHAR(255))"  );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Gotoloc ( Name VARCHAR(32), x INT, y INT, z INT, Creator VARCHAR(32))"  );


[SomeoneRandom]

I have created tables in database. You can see in the file

[luchgox]

wtf

[KrOoB_]

Good job

[ahmedzead]

Bro I Created The Tables But when i register it doesnt save any thing to database help me ?????

[Mohamed]

@ahmedzead Hm The Problem I Think For Cash.
Add Money System From http://forum.vc-mp.org/?topic=1380.0
And Add That Line OnplayerJoin

Code: [Select]

player.Cash = pstats[ player.ID ].Cash;

And Add THat Line For Onscriptload

Code: [Select]

pstats <- array( GetMaxPlayers(), null );

Test It And Tell Me If Its Work or No.

[=RK=MarineForce]

Table error

Plese you can Give me With Save This Him script

[adeelpak]

Dear All

any good person would please tell me that how can i install it on my own pc.

we have 12 pcs in network and we would like to play on our own server.

I have download blank server but i dont know how to download or install this script into it.

It would be appreciated, if someone make an archive of whole script with server.exe ??

[DizzasTeR]

You just have to download a released gamemode from the Script showroom. Read instructions how to set it up. Basically its including/changing the Script parameter in the .cfg file.

:edit: Didn't even realize this was off topic

[=RK=MarineForce]

Plese :

Agian release HIM WITH All Tables And Function ETC. Fixed