[Include] SQLite Improved - Printable Version

[Include] SQLite Improved - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+---- Forum: Includes (https://sampforum.blast.hk/forumdisplay.php?fid=83)
+---- Thread: [Include] SQLite Improved (/showthread.php?tid=303682)

Pages: 1 2 3 4 5 6

Re: SQLite Improved - Crayder - 25.07.2015

Quote:

Originally Posted by Sioux

Compiler crash when I include "sqlitei". I use zeex patches.

Whats wrong?

Код:

#include 							<a_samp>

#undef MAX_PLAYERS
#define MAX_PLAYERS                                  100
#undef MAX_VEHICLES
#define MAX_VEHICLES                                 500

#include 							<crashdetect>

#define BUD_USE_WHIRLPOOL 														true

#include 							<bud>
#include 							<easydb>
#include 							<rbits	>
#include 							<YSI\y_timers>
#include 							<YSI\y_va>
#include 							<YSI\y_iterate>
#include 							<sscanf2>
#include 							<zcmd>
#include 							<gvar	>
#include 							<streamer>
#include 							<sqlitei>

Is better to uses BUD for users or sqlitei? Tnk you, and sorry for bad english

I don't use the patches, so I'm not sure about the crash. However, I see that you have 3 sqlite libraries. Sqlitei is just to make SQL easy period. BUD is like a save and load basis type of thing, it also makes the whole process easier. Use which one fits your likings (or both). But, EasyDB (by Gammix) is a BUD alternative, you shouldn't be using it with BUD.

Re: SQLite Improved - Crayder - 25.07.2015

Quote:

Originally Posted by Sioux

Compiler crash when I include "sqlitei". I use zeex patches.

Whats wrong?

Код:

#include 							<a_samp>

#undef MAX_PLAYERS
#define MAX_PLAYERS                                  100
#undef MAX_VEHICLES
#define MAX_VEHICLES                                 500

#include 							<crashdetect>

#define BUD_USE_WHIRLPOOL 														true

#include 							<bud>
#include 							<easydb>
#include 							<rbits	>
#include 							<YSI\y_timers>
#include 							<YSI\y_va>
#include 							<YSI\y_iterate>
#include 							<sscanf2>
#include 							<zcmd>
#include 							<gvar	>
#include 							<streamer>
#include 							<sqlitei>

Is better to uses BUD for users or sqlitei? Tnk you, and sorry for bad english

Re: SQLite Improved - Sioux - 25.07.2015

I use BUD for accounts, and easydb for everything else. Now i want to replace easydb with sqlitei.
I compiled same script on Windows 10 and there is no crash, but there is some error ( easydb and sqlitei isnt compatible )

Why on Windows 7crash but on Windows 10 not?

EDIT: (On Windows 10):

Код:

#include 							<a_samp>
#include 							<sqlitei>

First time: OK
Secound time: OK
Third time: Crash

Sometime compiler crash, sometime not

( Sry for bad English )

EDIT 2:

- When i dont use zeex pawn patches compiler dont crash. ( Now i must find Long lines to use that include

)

Re: SQLite Improved - PT - 07.08.2015

Slice why are you using the db_escape_string instead of the new %q ?

Re: SQLite Improved - Slice - 08.08.2015

You mean why did I not update it? The way it is done now has been tested and working fine for years. I see no reason to change it.

Re: SQLite Improved - PT - 08.08.2015

Quote:

Originally Posted by Slice

You mean why did I not update it? The way it is done now has been tested and working fine for years. I see no reason to change it.

Ok thanks for the explain.

When you can add suport for the new function SHA256_PassHash like you have for the whirlpool.

Re: SQLite Improved - Grimlock - 24.05.2016

thanks this include is awesome, REP++

Re: SQLite Improved - Amunra - 25.05.2016

Get some error with new version !!

Quote:

error 017: undefined symbol "db_get_result_mem_handle"

Re: SQLite Improved - Amunra - 26.05.2016

Anyone can Help with my Probs ^^ ?

Re: SQLite Improved - vannesenn - 26.05.2016

db_get_result_mem_handle isn't defined. Update include and SA-MP version. That's a function which doesn't exist.

Re: SQLite Improved - Amunra - 26.05.2016

Quote:

Originally Posted by vannesenn

db_get_result_mem_handle isn't defined. Update include and SA-MP version. That's a function which doesn't exist.

The Version of a_samp include ,right ?

Re: SQLite Improved - justice96 - 26.05.2016

Quote:

Originally Posted by Amunra

The Version of a_samp include ,right ?

Try to update your include and SA-MP version

Re: SQLite Improved - KONTROWKEN - 07.06.2016

Код:

SQLitei Warning: (stmt_bind_value) Parameter index larger than number of parameters

LİNK:

Код:

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

Re: SQLite Improved - PT - 20.10.2016

Anyone knows if it's possible to set a password on SQLite database?

I'm asking because i saw one with but not connect with SAMP.

Re: SQLite Improved - vannesenn - 21.10.2016

Quote:

Originally Posted by PT

Anyone knows if it's possible to set a password on SQLite database?

I'm asking because i saw one with but not connect with SAMP.

I think you can. Once I tried to edit SQLite database from Whatsapp(backup on SD card), it required password/code.

Re: SQLite Improved - PT - 22.10.2016

Quote:

Originally Posted by [HLF]Southclaw

SQLite is not a network accessible database (unless you make it network accessible!) so beyond simple encryption, there is no real built in security (since it's just a simple binary file). If you're exposing SQLite to a network in some way like MySQL has built-in, you'll have to handle security yourself.

Okay but how?

Re: SQLite Improved - PT - 22.10.2016

Yeah but I have 2 problems first machine is windows 2 who is trying acess is connecting a site to the db and change the values like admins etc etc

Re: SQLite Improved - PT - 22.10.2016

Well i'm sure a password solves the problem 100%

No doesn't is sql injection

Re: SQLite Improved - Vin Diesel - 28.01.2017

nice job

Re: SQLite Improved - SecretMax - 15.07.2017

I have a little problem, please help

Quote:

E:\PC\SAMP Cuccok\SAMP Szerver cuccos\MyMod\pawno\include\sqlitei.inc(969) : error 017: undefined symbol "db_get_result_mem_handle"
E:\PC\SAMP Cuccok\SAMP Szerver cuccos\MyMod\pawno\include\sqlitei.inc(97

: error 017: undefined symbol "db_get_result_mem_handle"
E:\PC\SAMP Cuccok\SAMP Szerver cuccos\MyMod\pawno\include\sqlitei.inc(2159) : error 017: undefined symbol "db_get_result_mem_handle"