[Include] SQLite Improved
#81

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.
Reply
#82

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 (not saying you can't (not sure if you can), but it shouldn't be done).
Reply
#83

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 )
Reply
#84

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

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.
Reply
#86

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.
Reply
#87

thanks this include is awesome, REP++
Reply
#88

Get some error with new version !!
Quote:

error 017: undefined symbol "db_get_result_mem_handle"

Reply
#89

Anyone can Help with my Probs ^^ ?
Reply
#90

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

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 ?
Reply
#92

Quote:
Originally Posted by Amunra
Посмотреть сообщение
The Version of a_samp include ,right ?
Try to update your include and SA-MP version
Reply
#93

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


LİNK:
Reply
#94

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.
Reply
#95

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.
Reply
#96

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?
Reply
#97

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
Reply
#98

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

No doesn't is sql injection
Reply
#99

nice job
Reply

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"

Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)