[Include] [BETA] BUD - Blazing User DB

[Include] [BETA] BUD - Blazing User DB - 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] [BETA] BUD - Blazing User DB (/showthread.php?tid=187720)

Pages: 1 2 3 4

Re: [BETA] BUD - Blazing User DB - ddnbb - 12.03.2012

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?

Re: [BETA] BUD - Blazing User DB - Niko_boy - 12.03.2012

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

Re: [BETA] BUD - Blazing User DB - Ballu Miaa - 13.03.2012

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

Re: [BETA] BUD - Blazing User DB - Slice - 13.03.2012

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>';

?>

Re: [BETA] BUD - Blazing User DB - QuaTTrO - 15.03.2012

How to change pass using that system ?

I using Whirlpool

Re: [BETA] BUD - Blazing User DB - StrondA_ - 15.03.2012

Very nice, will help many people!

Re: [BETA] BUD - Blazing User DB - new121 - 17.03.2012

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

Re: [BETA] BUD - Blazing User DB - Rock1 - 17.03.2012

Anyone know?

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

Re: [BETA] BUD - Blazing User DB - new121 - 17.03.2012

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

Re: [BETA] BUD - Blazing User DB - Rock - 17.02.2013

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.

Re: [BETA] BUD - Blazing User DB - The King's Bastard - 12.07.2013

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;
}

Re: [BETA] BUD - Blazing User DB - Slice - 12.07.2013

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.

Re: [BETA] BUD - Blazing User DB - The King's Bastard - 12.07.2013

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.

Re: [BETA] BUD - Blazing User DB - Slice - 12.07.2013

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

Re: [BETA] BUD - Blazing User DB - x2gKaos - 04.09.2013

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

Re: [BETA] BUD - Blazing User DB - Slice - 04.09.2013

Quote:

Originally Posted by x2gKaos

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

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

Re: [BETA] BUD - Blazing User DB - x2gKaos - 04.09.2013

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.

Re: [BETA] BUD - Blazing User DB - ToiletDuck - 20.12.2013

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

Re: [BETA] BUD - Blazing User DB - Herfer - 20.12.2013

Man this is very goooooood

Re: [BETA] BUD - Blazing User DB - XStormiest - 03.02.2014

How can i make the password to be case sensitive?