[ImTouchk]

Hello everybody, when I'm starting my server, but anyway I used the MYSQL in EasyDB says that's working SQLLite. Okay, I'm fine with this, whatever if I will can use my User Control Panel or no, but the problem is. If is SQLLite, I don't saw anything about a database in localhost/phpmyadmin {xampp}, but an empity file works on scriptfiles, it seems like a database. It's without an extension, a blank file in fact, maybe. This maybe is because I don't defined #define with database/host/username etc.? I will take down something usefull about my script. Thanks alot!

Code:

   	DB::Init("main-rp database");
	DB::VerifyTable("Utilizatori", "ID", false,
						"Nume", STRING,
						"Parola", STRING,
						"IP", STRING,
						"Kills", INTEGER,
						"Deaths", INTEGER,
						"Cash", INTEGER,
						"Developer", INTEGER,
						"Admin", INTEGER,
      "Tester", INTEGER,
						"Lider", STRING,
						"Rank", STRING,
						"Factiune", STRING,
						"Viata", FLOAT);

If you want something details, leave a reply. THANKS!

[Nero_3D]

Well sqlite and mysql both support the sql syntax, the biggest difference is probably that sqlite is local and mysql is online

Check this site for a more deeper comparison - http://www.sqlite.org/whentouse.html
sqlite - "Situations Where SQLite Works Well"
mysql (just a bit down) - "Situations Where A Client/Server RDBMS May Work Better"

To open sqlite files you need a programm or plugin for your browser, examples
- DB Browser for SQLite
- SQLite Manager

[Gammix]

https://sampforum.blast.hk/showthread.php?tid=612595

It states how you should use DB::Init and CONNECTION_TYPE_MYSQL when choosing between SQLite or MySQL.

[ImTouchk]

Quote:

Originally Posted by Nero_3D Well sqlite and mysql both support the sql syntax, the biggest difference is probably that sqlite is local and mysql is online Check this site for a more deeper comparison - http://www.sqlite.org/whentouse.html sqlite - "Situations Where SQLite Works Well" mysql (just a bit down) - "Situations Where A Client/Server RDBMS May Work Better" To open sqlite files you need a programm or plugin for your browser, examples - DB Browser for SQLite - SQLite Manager

Quote:

Originally Posted by Gammix https://sampforum.blast.hk/showthread.php?tid=612595 It states how you should use DB::Init and CONNECTION_TYPE_MYSQL when choosing between SQLite or MySQL.

Okay. If I would use SQLite I will can use an UCP? But that's not the idea. When I'm starting samp-server.exe i've got v++ error(if i'm not sure), but the server runs okay. I want to use MYSQL, but EASYDB says on console that I'm using SQLLite. I want to transfer back to MYSQL if UCP doesn't works. How I can resolve it? The database doesn't show anything in notepad++ when I'm editing it for checking for mine account, and every after restart the server wipe's. What I need to do? Because I want to finish soon the gamemode because I had to make the UCP.
Thanks anticipate!

[ImTouchk]

bump?

[ImTouchk]

BUMP

[Crayder]

Read the rules Sonny.

No bumps allowed within 24 hours of the last post.

[ImTouchk]

Quote:

Originally Posted by Crayder Read the rules Sonny. No bumps allowed within 24 hours of the last post.

I don't knowed that. Anyway, I wasn't helped by somebody and...

[ImTouchk]

bump
anyone helps me please?
i want to transfer SQLLite to MySQL because here doesn't saves data but i've got
api-ms-win-crt-runtime-l1-1-0.dll missing error but i have 2013(or 2015, not sure) visual c++
how I can get out of this?

[Nero_3D]

If you want to transfer as sql file to mysql or vice versa use a sql / msql manager, nearly all have an import / export feature

Also I am not sure but did you do that?

Quote:

Originally Posted by easydb.inc In order to use MySQL version of this, add "#define CONNECTION_TYPE_MYSQL" before including <easydb>.