Total War DM

Started by Debian, Sep 17, 2015, 05:43 AM

Previous topic - Next topic

ngocson389


!

Quote from: ngocson389 on Jun 05, 2016, 05:01 AMdata is'nt save to database , help me plss

@ngocson389

Add this in Function OnScriptLoad;

//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))"  );

Discord: zeus#5155

ngocson389

#32
Quote from: zeus on Jun 06, 2016, 08:35 AM
Quote from: ngocson389 on Jun 05, 2016, 05:01 AMdata is'nt save to database , help me plss

@ngocson389

Add this in Function OnScriptLoad;

//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 Jun 06, 2016, 08:35 AM
Quote from: ngocson389 on Jun 05, 2016, 05:01 AMdata is'nt save to database , help me plss

@ngocson389

Add this in Function OnScriptLoad;

//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

Strength does not come from wining.Your struggles develop your strengths.

KrOoB_

#37
Good job

KrOoB_

Quote from: Eva on Apr 15, 2017, 08:55 PM
Quote from: zeus on Jun 06, 2016, 08:35 AM
Quote from: ngocson389 on Jun 05, 2016, 05:01 AMdata is'nt save to database , help me plss
Okey i did it thanks

@ngocson389

Add this in Function OnScriptLoad;

//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))"  );

ahmedzead

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

Mohamed Boubekri

@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
player.Cash = pstats[ player.ID ].Cash;And Add THat Line For Onscriptload pstats <- array( GetMaxPlayers(), null );Test It And Tell Me If Its Work or No.
| What now ? | Not yet ! |
Morrocan:- [ 🇲🇦 ].

=RK=MarineForce

Table error

Plese you can Give me With Save This Him script
Try to UnderStand ME!

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
Try to UnderStand ME!