[ddnbb]

Quote:

Originally Posted by Slice This uses SQLite, you just need to use the functions and BUD takes care of everything else. You can use PDO or the sqlite3_* functions in PHP to connect to the database (which will be in your "scriptfiles" folder).

You are maker of this script, so im sure you could help me?

[Niko_boy]

ah wonderful peace of work , keep it up , Slice !

[Ballu Miaa]

Quote:

Originally Posted by ddnbb You are maker of this script, so im sure you could help me?

Yeah connecting to php will require your help Slice! Thanks bro

[Slice]

PHP код:

<?php
echo '<pre>';
$db = new SQLite3('/path/to/scriptfiles/database.db');
$result = $db->query('SELECT * FROM users');
while (($row = $result->fetchArray())) {
    print_r($row);
}
echo '</pre>';
?>

[QuaTTrO]

How to change pass using that system ?

I using Whirlpool

[StrondA_]

Very nice, will help many people!

[new121]

Is there any known bugs with this? I love this system though

[Rock1]

Anyone know?

http://forum.sa-mp.com/showthread.ph...47#post1733647

[new121]

http://pastebin.com/QqGsdykm

Why wont this give my player his money on login? I looked at the database and I have 5000 dollars but when I login i get 0

[Rock]

Quote:

Originally Posted by Retardedwolf Awesome. can't wait for the 'more powerful version'.

Me too.
Also I've done a really helpful tutorial for ALL of it's functions, despite old ones.

See HERE or in my signature.

[The King's Bastard]

Why aren't you creating an index for the uid and name?

pawn Код:

private BUD::CreateDatabase() {
    if (!BUD::GetDB())
        return false;
    
    db_query(g_dbKeptAlive, "CREATE TABLE users (" DEFAULT_COLUMNS ")");
    db_query(g_dbKeptAlive, "CREATE INDEX uid_idx ON users (uid)");
    db_query(g_dbKeptAlive, "CREATE INDEX name_idx ON users (name)");
    
    return true;
}

[Slice]

Quote:

Originally Posted by The King's Bastard Why aren't you creating an index for the uid and name? pawn Код: private BUD::CreateDatabase() {     if (!BUD::GetDB())         return false;         db_query(g_dbKeptAlive, "CREATE TABLE users (" DEFAULT_COLUMNS ")");     db_query(g_dbKeptAlive, "CREATE INDEX uid_idx ON users (uid)");     db_query(g_dbKeptAlive, "CREATE INDEX name_idx ON users (name)");         return true; }

I didn't have much database knowledge when I made this. I'll add that when I get home.

[The King's Bastard]

Indices should increase performance. The index on name should increase performance when searching for the uid and the index on uid should increase performance when getting data for a specific uid.

//EDiT: The index on uid might be redundant as it is a primary key. I'm sure but it's possible that SQLite creates indices on primary keys by default.

[Slice]

Yes uid is a primary key so that's all good, but I should've added an index on name.

[x2gKaos]

I keep getting pawno\include\Bud.inc(5) : fatal error 100: cannot read from file: "&lt;a_samp&gt;" Compiled fine before I added #include <bud>

[Slice]

Quote:

Originally Posted by x2gKaos I keep getting pawno\include\Bud.inc(5) : fatal error 100: cannot read from file: "&lt;a_samp&gt;" Compiled fine before I added #include <bud>

Just download the include file again. You probably messed something up when uploading/downloading it.

[x2gKaos]

Quote:

Originally Posted by Slice Just download the include file again. You probably messed something up when uploading/downloading it.

Yupp, Thank you! Awesome include btw. Thanks for releasing it.

[ToiletDuck]

Thanks Slice, i might start using this instead the OLD Saving system such as OnPlayerLogin,OnPlayerStatsUpdate.

[Herfer]

Man this is very goooooood

[XStormiest]

How can i make the password to be case sensitive?