In response to Yut Put
Yut Put wrote:
http://www.byond.com/games/YutPut/LEGEND

I'm so glad this project could be brought back to life.
Experimenting with a reference-based item database. The idea is to have the player hold a container that only contains player-specific flags and variables (such as amount, trade restrictions, etc.) and have it reference a SQLite database to retrieve all other relevant information such as name, icon, description, stats, etc. I see advantages of being able to apply changes on a live server and putting it into effect without taking a server down.

This is what I currently have so far:
var/database/EquipDatabase

proc
InitializeEquipDatabase()
if(!fexists("Game Data/Equip Database.db"))
EquipDatabase = new/database("Game Data/Equip Database.db")

//Test output
world << "Successfully created Equip Database.db file."
/////////////

var/database/query/q = new

q.Add("CREATE TABLE EquipInfo(RefID UNIQUE, Name, Description, Icon)")
q.Execute(EquipDatabase)

q.Add("CREATE TABLE EquipStats(RefID UNIQUE, Category, EquipType, DamageType, DamageCalc, AttackMultiplier, MagicMultiplier, ATK, MAG, DEF, MDEF, ACC, EVA)")
q.Execute(EquipDatabase)

q.Add("CREATE TABLE EquipEffects(RefID, EffectID, Type, Name, Description, Icon)")
q.Execute(EquipDatabase)
else EquipDatabase = new/database("Game Data/Equip Database.db")

database/proc
AddRow(Table, RefID, list/Data)
var/Columns, Values
for(var/D in Data)
Columns += "[D]"
Values += "NULL"

if(D != Data[Data.len])
Columns += ", "
Values += ", "

var/database/query/q = new

q.Add("INSERT INTO [Table] (RefID, [Columns]) VALUES (?, [Values])", RefID)
q.Execute(src)

EditData(Table, RefID, Data)

EditData(Table, RefID, list/Data)
var/database/query/q = new

for(var/D in Data)
q.Add("UPDATE [Table] SET [D] = ? WHERE RefID = \"[RefID]\" AND [D] IS NULL", Data[D])
q.Execute(src)

QueryRow(Table, RefID, list/Cells)
var/Columns

if(Cells)
for(var/D in Cells)
Columns += "[D]"
if(D != Cells[Cells.len]) Columns += ", "
else Columns = "*"

var/database/query/q = new

q.Add("SELECT [Columns] FROM [Table] WHERE RefID = \"[RefID]\"")
q.Execute(src)

while(q.NextRow())
var/list/RowData = q.GetRowData()

//Just a test output to see if the table cells are actually getting read.
var/Desc = "\[[RefID]] "

for(var/D in RowData)
if(D == "RefID") continue
Desc += "[D]: [RowData[D]]"
if(D != RowData[RowData.len]) Desc += ", "

world << Desc
//////////////////


This also can be used for containers that change due to events to quests within the game. Say I have a container with a Quest flag and two item references:
Equip/Excalibur
RefID = "QUEST001"
Quest = 1

EquipDatabase.AddRow("EquipInfo", "QUEST001", list("Name" = "Excalipur", "Description" = "A fake."))
EquipDatabase.AddRow("EquipInfo", "QUEST002", list("Name" = "Excalibur", "Description" = "A real."))

The container will be a completely different item when its RefID gets changed to "QUEST002".
In response to Lummox JR
Lummox JR wrote:
Yut Put wrote:
http://www.byond.com/games/YutPut/LEGEND

I'm so glad this project could be brought back to life.

CHOO CHOO

just gonna say it's getting WAY MORE than brought to life. complete remaster and gameplay overhaul using all the knowledge i've accumulated over three RPGs between when I made E:L and now. More news will come soon
Woot looking forward to this
In response to Yut Put
Multiplayer?
yes

goes to 15 minutes
Haven't been on BYOND in a minute. What happened to Severed World?
In response to Oral123
Oral123 wrote:
Haven't been on BYOND in a minute. What happened to Severed World?

https://steamcommunity.com/sharedfiles/ filedetails/?id=444784534

i believe its being made in vylocity now
In response to Bl4ck Adam
Bl4ck Adam wrote:
Oral123 wrote:
Haven't been on BYOND in a minute. What happened to Severed World?

https://steamcommunity.com/sharedfiles/ filedetails/?id=444784534

i believe its being made in vylocity now

https://www.facebook.com/severedworldmmorpg/posts/ 1083394675103378
Messing around with pathfinding and turn-based gameplay for a weekjam.

Refined the Goddess of Fire Concept. Hopefully I can use it as Banner someday. Funny how my previous programmer went AWOL. Does this happen a lot?

Are you paying your programmer? IF not, yes, that will happen a lot since it's a volunteer position. If so, oh well, find someone else.

Cool art though. Well I guess it's hot, but w/e.
In response to A2J2TIWARI
A2J2TIWARI wrote:
Refined the Goddess of Fire Concept. Hopefully I can use it as Banner someday. Funny how my previous programmer went AWOL. Does this happen a lot?


Her boobs are much older than her face and what you would normally expect for a "hot" chick. ;P
looks too lame to be banner material


Can't actually use the guns yet, and there's some weirdness with images in MP, but it's getting there.

EDIT: You can use the guns now.

Man that's pretty, Zuhayr.

For your pathfinding, what method are you using? I found I could make A* relatively performant in softcode by using heaps and associative lists judiciously.
In response to Lummox JR
Lummox JR wrote:
For your pathfinding, what method are you using?

It looks well-suited to Dijkstra, so maybe http://www.byond.com/developer/Theodis/Pathfinder ?

Of course I'd be happy to shamelessly plug http://www.byond.com/developer/Kuraudo/libpathfinder as well. :V
Page: 1 2 3 ... 333 334 335 336 337 ... 348 349 350

Login to reply.