Library using MySQL to store and generate books for players
Available in French or Englih ;)
==================> How does it work?
- The player can read or buy books
- Books are filtered by category end ordered by title
- Books are dematerialized : no custom blueprints are needed. Books are created with a base blueprint and modified with the information in the database
- You can have multiple libraries containing different books
- Recently added books are marked with a N (stands for New)
- Books are stored in the db with :
code : (unique & mandatory) used for the book blueprint ans as the book identifier
date : Date when the book has been added
libtag : libraries tags that possess the book multiple tags are separated with a comma ",". To display a book in all libraries, enter "*"
price : Cost of the book in gp
icon : Number of the icon (see notes). Optional
cat : Category name of the book (ex : Monsters, Module, ...)
source : Source of the book (HRP) (Wikipedia, Gemmaline, ...). if ='', will not be shown in the book
author : Writer of the book (RP) (ex : Elminster, Volo, ...). if ='', will not be shown in the book
title : Book's title
text : Book's content, up to 10000 char
==================> Installation
NWN :
- Import Scripts.erf (contains gui_library.nss and library_onused.nss)
- Import [LANGUAGE]/Scripts.erf (contains library_inc.nss)
- Assign 'library_onused' to the OnUsed script of the placeable to click to browse the books (and remember the placeable tag ;))
- Put [LANGUE]/library.xml into the folder documents/nwn2/ui/custom
- If there is already a file named "ingamegui.ini" in documents/nwn2/ui/custom, add the folowing line at the end of [MandatoryGUI] :
SCREEN_LIBRARY=library.xml
else add the "ingamegui.ini" from the svn into documents/nwn2/ui/custom
MySQL :
Using the library require a nwnx4 server and a SQL database & table ;)
To create the needed table, execute this request :
CREATE TABLE `library` (
`code` varchar(45) NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`libtag` varchar(45) default '*',
`price` int(6) default '10',
`icon` int(11) default '229',
`cat` varchar(45) default 'Other',
`source` varchar(45) default '',
`author` varchar(45) default '',
`title` varchar(100) NOT NULL,
`text` varchar(10000) NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Note : You can execute the script in [LANGUAGE]/Books.sql to add some sample books
I added my email address in the README to contact me ;) _________________________ La Colère d'Aurile : Link
Posted by Silver Oak at 2012-07-06 18:01:27 Voted 9.00 on 07/02/12
I would send you a PM, however I speak two languages, English and Bad English. Sorry, I cannot read your site to send you the my exported SQL Library table.
Thank you for the feedback ;)
The reason why there is no sample books in English, is that i didn't take time to find them.
If you have ideas of books to put in the library, just PM me, and i will add them into the repository. _________________________ La Colère d'Aurile : Link
Posted by Silver Oak at 2012-07-02 19:39:36 Voted 9.00 on 07/02/12
This is a fantastic idea and well done. Our players really enjoy taking the time to add to the Library having the option to have their characters add to the library through RP. It would have been nice to have an English version of a sample library. As I am always told if you have a suggest, have a solution, I would be happy to provide one if someone wishes it, or provide one to be added by the creator of this fine work.
You must be Logged In to post comments in this section.
10 - A Masterpiece, Genuinely Groundbreaking 9 - Outstanding, a Must Have 8 - Excellent, Recommended to Anyone 7 - Very Good, Deserves a Look 6 - Good, Qualified Recommendation 5 - Fair, Solid yet Unremarkable 4 - Some Merit, Requires Improvements 3 - Poor Execution, Potential Unrealized 2 - Very Little Appeal 1 - Not Recommended to Anyone
Site
