[FilterScript] Simple Music Database (SQLite)

[FilterScript] Simple Music Database (SQLite) - 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)
+--- Thread: [FilterScript] Simple Music Database (SQLite) (/showthread.php?tid=383445)

Simple Music Database (SQLite) - Youarex - 07.10.2012

Introduction

With this little filterscript you can create big music database, easily add, remove or update songs in game, navigate through pages in playlist and search for specific songs, using every criteria at once. I don't know what else to write, but I had to learn SQLite to make this for you.

(updated 2012-10-12)
http://pastebin.mozilla.org/1865387
http://www.solidfiles.com/d/090a17ea06/

(updated 2012-10-14)
http://www.solidfiles.com/d/440ddfbdb7/

You'll also need SQLite include:

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

Commands

Код:

/music <params>
- opens music dialog if no params are given

        Params:

        stop
        - stops audio stream for player

        search <keywords>
        - finds songs for a given keywords
        - opens search dialog if no params are given

        request <song>
        - writes player's request to "requests.txt" file
        - opens request dialog if no params are given 

        Rcon commands:

        add
        - adds new song in database
        - opens step by step dialog

        delete <songid>
        - removes song from database
        - opens search dialog if no params are given

        update <songid>
        - updates song in database
        - opens search dialog if no params are given

Screenshots

Note: removed most of the songs, since links were dead.

Credits

Код:

    Made by Youarex

    Slice for SQLite
    SA-MP Team

Re: Dynamic MP3 Database (SQLite) - Mr.Faqahat - 07.10.2012

O_o Nice but where is download link ?

Re: Dynamic MP3 Database (SQLite) - Ballu Miaa - 07.10.2012

EDIT: Blind shit. Ma bad lol

Good work

Re: Dynamic MP3 Database (SQLite) - Youarex - 07.10.2012

Quote:

Originally Posted by Mr.Faqahat

O_o Nice but where is download link ?

Quote:

Originally Posted by Ballu Miaa

Waiting for the Download link lol.

You only need to read the description first!

Re: Dynamic MP3 Database (SQLite) - Simplyfrag - 07.10.2012

can you upload it some were else i cant seem to ever download it from that link?

Re: Dynamic MP3 Database (SQLite) - Mr.Mercer - 07.10.2012

nice..

Re: Dynamic MP3 Database (SQLite) - Edvin - 07.10.2012

Very very nice release man

Re: Dynamic MP3 Database (SQLite) - alanhutch - 07.10.2012

Awesome! Rep+!

Re : Dynamic MP3 Database (SQLite) - Witnec - 08.10.2012

Код:

C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(67) : error 017: undefined symbol "CreatePlayerTextDraw"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(67) : warning 213: tag mismatch
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(68) : error 017: undefined symbol "PlayerTextDrawBackgroundColor"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(69) : error 017: undefined symbol "PlayerTextDrawFont"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(70) : error 017: undefined symbol "PlayerTextDrawLetterSize"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(71) : error 017: undefined symbol "PlayerTextDrawColor"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(72) : error 017: undefined symbol "PlayerTextDrawUseBox"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(73) : error 017: undefined symbol "PlayerTextDrawBoxColor"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(74) : error 017: undefined symbol "PlayerTextDrawTextSize"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(76) : error 017: undefined symbol "CreatePlayerTextDraw"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(76) : warning 213: tag mismatch
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(77) : error 017: undefined symbol "PlayerTextDrawSetSelectable"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(78) : error 017: undefined symbol "PlayerTextDrawBackgroundColor"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(79) : error 017: undefined symbol "PlayerTextDrawFont"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(80) : error 017: undefined symbol "PlayerTextDrawLetterSize"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(81) : error 017: undefined symbol "PlayerTextDrawColor"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(82) : error 017: undefined symbol "PlayerTextDrawUseBox"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(83) : error 017: undefined symbol "PlayerTextDrawBoxColor"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(84) : error 017: undefined symbol "PlayerTextDrawTextSize"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(85) : error 017: undefined symbol "PlayerTextDrawSetOutline"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(86) : error 017: undefined symbol "PlayerTextDrawSetProportional"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(87) : error 017: undefined symbol "PlayerTextDrawSetShadow"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(89) : error 017: undefined symbol "CreatePlayerTextDraw"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(89) : warning 213: tag mismatch
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(90) : error 017: undefined symbol "PlayerTextDrawSetSelectable"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(91) : error 017: undefined symbol "PlayerTextDrawBackgroundColor"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(92) : error 017: undefined symbol "PlayerTextDrawFont"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(93) : error 017: undefined symbol "PlayerTextDrawUseBox"
C:\DOCUME~1\Admin\Bureau\QServeur\SARP\FILTER~1\mp3db.pwn(94) : error 017: undefined symbol "PlayerTextDrawBoxColor"

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


26 Errors.

Is my prob from an include?

Re: Re : Dynamic MP3 Database (SQLite) - Youarex - 08.10.2012

Quote:

Originally Posted by Witnec

Код:

Bunch of Errors.

Is my prob from an include?

Update your SA-MP server and client.