SphereCommunity
In-Game Diary - Printable Version

+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: Script Help (/Forum-Script-Help)
+--- Thread: In-Game Diary (/Thread-In-Game-Diary)



In-Game Diary - Gil Amarth - 02-02-2014 09:04 AM

I´m thinking to introduce a in-game diary in my server. The idea would be to type .diary, and display a gump where the player can write notes and thoughs.

My question is, what do you think is best way to store the string data?. I don´t use SQL database, so the system would be stored only with the default Sphere variable types.

I´m thinking about TAGs, but it would be A LOT of TAGs, any suggestion please?


RE: In-Game Diary - Extreme - 02-02-2014 11:18 AM

List?


RE: In-Game Diary - XuN - 02-02-2014 06:19 PM

At first place I have to say if you are not using SQL for this because you don't have any SQL server, the new SQLite plugin added few time ago works without one, the sphere itself handle it.

If you are not likely to use it... it would be a lot of TAGs or LISTs to store, but better to use LISTs.


RE: In-Game Diary - Gil Amarth - 02-05-2014 05:46 AM

Really?

The reason to not use SQL is a but of lazyness to learn something complex.
In the Sphere wiki there is no articles about SQL, do you know any web page that could be used like a tutorial?

Or some post that explains how to setup a SQLite plugin for Sphere?


RE: In-Game Diary - XuN - 02-05-2014 06:24 AM

Download my add dialog (SQlite) script from downloads to get a quick start example, and for deep learning check the official docs: https://www.sqlite.org/lang.html


RE: In-Game Diary - Gil Amarth - 02-06-2014 02:16 AM

Thanks a lot!