| --- Log opened Sun Jul 21 00:00:03 2013 |
| 00:04 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 00:08 | | ErikMesoy [Erik@A08927.B4421D.F502DB.788E78] has joined #code |
| 00:09 | | ErikMesoy|sleep [Erik@A08927.B4421D.FE7332.704AA5] has quit [Ping timeout: 121 seconds] |
| 00:17 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 00:18 | | mode/#code [+o himi] by ChanServ |
| 00:22 | | Vorntastic [Vorn@Nightstar-221158c7.sd.cox.net] has quit [Connection reset by peer] |
| 00:22 | | Vorntastic [Vorn@Nightstar-221158c7.sd.cox.net] has joined #code |
| 00:22 | <&ToxicFrog> | Vorntastic: vstruct 1.1.4 released |
| 00:24 | < Vorntastic> | Woot |
| 00:25 | | Derakon is now known as Derakon[AFK] |
| 00:26 | < Vorntastic> | What's new? |
| 00:27 | < Vorntastic> | Oh, right, CHANGES |
| 00:27 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 00:27 | <&ToxicFrog> | Also the releases page on github |
| 00:40 | < [R]> | I'm planning to store a character sheet into a DB. Obviously having each trait as its own column is the easiest to querry. But having ~50 columns seems like a mess. Am I just being weird here? |
| 00:40 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 00:41 | | mode/#code [+o himi] by ChanServ |
| 00:42 | <&ToxicFrog> | [R]: to me this sounds like you should have a separate table of traits FKd by character id |
| 00:42 | <&ToxicFrog> | But it's been a while since I did database design theory |
| 00:42 | < Vorntastic> | What system? |
| 00:42 | < [R]> | Exalted |
| 00:43 | < Vorntastic> | *checks* |
| 00:43 | < [R]> | Actually, fuck it. I'll just KV store this |
| 00:44 | < [R]> | Since I'll want to do shit like check to see if the traits are within range, and KV means I can check that with a simple query. |
| 00:44 | < Vorntastic> | Ok, yes. Kv store, likely the ks are ids in a different table... |
| 00:45 | < [R]> | Well it'd be more: (id, trait, value) |
| 00:45 | < [R]> | Where `id` is the character_id |
| 00:46 | < Vorntastic> | Trait_id, not trait, for most things. |
| 00:46 | < [R]> | Eh, I'll just Enum trait. |
| 00:46 | < [R]> | IIRC Enum is the one I want |
| 00:47 | < Vorntastic> | Also, checking, the charsheet I see has 5 dots and a box, what's the box for |
| 00:47 | < [R]> | I'd have to see the same sheet |
| 00:48 | < [R]> | Is this like a checkbox beside the traitname or dots? If so that's probably fav/unfav marking. |
| 00:48 | < [R]> | Hmm |
| 00:48 | < Vorntastic> | http://mrgone.rocksolidshells.com/exalted.html 4 page sheet is what I picked |
| 00:49 | < [R]> | (character_id, trait, value, xp_spent, favored) |
| 00:49 | < Vorntastic> | This looks vmuch like a bunch of tables even where there are static names like abilities |
| 00:50 | < [R]> | Explain? |
| 00:50 | < Vorntastic> | If I was on something other than a phone I'd work you up some schema... |
| 00:51 | < [R]> | Ah |
| 00:51 | < [R]> | I actually have a JSON character sheet, if you want to see what kind of data would get stored. |
| 00:51 | < Vorntastic> | But like, attributes is a table, (char_id, attr_id, score) |
| 00:52 | < [R]> | (Hand-crafted, so it's actually readable) |
| 00:52 | < [R]> | Attributes can be favored too (depending on the Exalt type) |
| 00:53 | < Vorntastic> | And then attr_id I'd make into a thing I can, um, get localized strings for? |
| 00:53 | < Vorntastic> | Maybe not that highfalutin |
| 00:54 | < [R]> | I don't think that's the DB's perview. |
| 00:54 | < Vorntastic> | But decidedly don't store the names in the volatiles. |
| 00:55 | < [R]> | Yeah, no. I'll be using an enum or similar there. |
| 00:56 | < Vorntastic> | I'm not up enough on db design to know the right words here. |
| 00:56 | < [R]> | When will you be on a real terminal? |
| 00:56 | < [R]> | (I can wait) |
| 00:58 | < Vorntastic> | Later. Unsure when; my evil twin is in town for comic-con. |
| 00:59 | < [R]> | Alright |
| 01:00 | < RichyB> | You have an evil twin? *jealous* |
| 01:02 | | ErikMesoy [Erik@A08927.B4421D.F502DB.788E78] has quit [Ping timeout: 121 seconds] |
| 01:02 | | ErikMesoy [Erik@Nightstar-0fb48670.80-203-17.nextgentel.com] has joined #code |
| 01:04 | | Derakon[AFK] is now known as Derakon |
| 01:05 | | You're now known as TheWatcher[T-2] |
| 01:06 | | Vornlicious [Vorn@Nightstar-766abc0e.sub-70-211-7.myvzw.com] has joined #code |
| 01:08 | | You're now known as TheWatcher[zZzZ] |
| 01:09 | | Vorntastic [Vorn@Nightstar-221158c7.sd.cox.net] has quit [Ping timeout: 121 seconds] |
| 01:31 | | VirusJTG_ [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
| 01:31 | | Turaiel is now known as Turaiel[Offline] |
| 01:32 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [Ping timeout: 121 seconds] |
| 01:42 | | Karono [Karono@Nightstar-a97724cd.optusnet.com.au] has joined #code |
| 01:50 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 01:52 | | RichyB [RichyB@D553D1.68E9F7.02BB7C.3AF784] has quit [[NS] Quit: Gone.] |
| 01:55 | | RichyB [RichyB@D553D1.68E9F7.02BB7C.3AF784] has joined #code |
| 02:03 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 02:04 | | mode/#code [+o himi] by ChanServ |
| 02:12 | | Turaiel[Offline] is now known as Turaiel |
| 02:47 | | VirusJTG_ [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [[NS] Quit: Program Shutting down] |
| 03:12 | | Orthia [orthianz@3CF3A5.E1CD01.B089B9.1E14D1] has quit [Ping timeout: 121 seconds] |
| 03:46 | | Kindamoody[zZz] is now known as Kindamoody |
| 03:49 | | Vornlicious is now known as VornGhoti |
| 04:54 | | celticminstrel [celticminst@Nightstar-3d915c28.dsl.bell.ca] has quit [[NS] Quit: KABOOM! It seems that I have exploded. Please wait while I reinstall the universe.] |
| 04:55 | | celticminstrel [celticminst@Nightstar-3d915c28.dsl.bell.ca] has joined #code |
| 04:55 | | mode/#code [+o celticminstrel] by ChanServ |
| 05:38 | | VornGhoti [Vorn@Nightstar-766abc0e.sub-70-211-7.myvzw.com] has quit [Ping timeout: 121 seconds] |
| 05:42 | | Vorntastic [Vorn@Nightstar-766abc0e.sub-70-211-7.myvzw.com] has joined #code |
| 05:44 | | ktemkin[work] is now known as ktemkin[avol] |
| 05:46 | | Derakon is now known as Derakon[AFK] |
| 05:58 | | Karono [Karono@Nightstar-a97724cd.optusnet.com.au] has quit [Ping timeout: 121 seconds] |
| 06:19 | | AverageJoe [evil1@Nightstar-4b668a07.ph.cox.net] has joined #code |
| 06:57 | | Kindamoody is now known as Kindamoody|out |
| 07:04 | | Vorntastic [Vorn@Nightstar-766abc0e.sub-70-211-7.myvzw.com] has quit [Ping timeout: 121 seconds] |
| 07:05 | | Vorntastic [Vorn@Nightstar-766abc0e.sub-70-211-7.myvzw.com] has joined #code |
| 07:11 | | abudhabi [abudhabi@Nightstar-043c750c.adsl.inetia.pl] has quit [Operation timed out] |
| 07:12 | | Karono [Karono@Nightstar-a97724cd.optusnet.com.au] has joined #code |
| 07:23 | | kevindraws13_ [NSwebIRC@Nightstar-692fde55.fios.verizon.net] has joined #code |
| 07:23 | | kevindraws13_ [NSwebIRC@Nightstar-692fde55.fios.verizon.net] has left #code [""] |
| 07:27 | | celticminstrel [celticminst@Nightstar-3d915c28.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 07:38 | | abudhabi [abudhabi@Nightstar-d410a3f0.adsl.inetia.pl] has joined #code |
| 07:55 | | Vornlicious [Vorn@Nightstar-221158c7.sd.cox.net] has joined #code |
| 07:59 | | Vorntastic [Vorn@Nightstar-766abc0e.sub-70-211-7.myvzw.com] has quit [Ping timeout: 121 seconds] |
| 08:08 | | Turaiel is now known as Turaiel[Offline] |
| 09:22 | | Vornlicious [Vorn@Nightstar-221158c7.sd.cox.net] has quit [[NS] Quit: Bye] |
| 09:22 | | Vorntastic [Vorn@Nightstar-221158c7.sd.cox.net] has joined #code |
| 09:24 | | AverageJoe [evil1@Nightstar-4b668a07.ph.cox.net] has quit [[NS] Quit: Leaving] |
| 09:41 | | AverageJoe [evil1@Nightstar-4b668a07.ph.cox.net] has joined #code |
| 09:41 | | AverageJoe [evil1@Nightstar-4b668a07.ph.cox.net] has quit [Client closed the connection] |
| 09:56 | | Vorntastic [Vorn@Nightstar-221158c7.sd.cox.net] has quit [Ping timeout: 121 seconds] |
| 09:58 | | Vorntastic [Vorn@Nightstar-f6acfcc2.sub-70-211-3.myvzw.com] has joined #code |
| 09:58 | | Vornlicious [Vorn@Nightstar-221158c7.sd.cox.net] has joined #code |
| 10:00 | | Orthia [orthianz@3CF3A5.E1CD01.B089B9.1E14D1] has joined #code |
| 10:00 | | mode/#code [+o Orthia] by ChanServ |
| 10:01 | | Vorntastic [Vorn@Nightstar-f6acfcc2.sub-70-211-3.myvzw.com] has quit [Operation timed out] |
| 10:33 | | You're now known as TheWatcher |
| 11:29 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 11:37 | | Karono [Karono@Nightstar-a97724cd.optusnet.com.au] has quit [Ping timeout: 121 seconds] |
| 11:42 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
| 11:42 | | mode/#code [+o himi] by ChanServ |
| 11:48 | | Karono [Karono@Nightstar-0e4527e4.optusnet.com.au] has joined #code |
| 12:03 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
| 12:14 | | Vorntastic [Vorn@Nightstar-f6acfcc2.sub-70-211-3.myvzw.com] has joined #code |
| 12:17 | | Vornlicious [Vorn@Nightstar-221158c7.sd.cox.net] has quit [Ping timeout: 121 seconds] |
| 12:27 | | Karono [Karono@Nightstar-0e4527e4.optusnet.com.au] has quit [Ping timeout: 121 seconds] |
| 12:44 | | * TheWatcher sighs |
| 12:45 | <@TheWatcher> | So, it appears that the dark engine replaces all script instances attached to an object in game when you add a metaproperty to the object. This is irritating. |
| 12:54 | | Serah [Z@Nightstar-b920a19c.cust.comxnet.dk] has joined #code |
| 13:15 | | Karono [Karono@Nightstar-0e4527e4.optusnet.com.au] has joined #code |
| 13:24 | < Vorntastic> | Metaproperty? |
| 13:32 | <@TheWatcher> | They're collections of properties that can be added to/removed from objects at runtime to change their behaviour or appearance |
| 13:39 | < Vorntastic> | So, like, "give this guy a hat and fancy boots and make him turn quicker at the end of his patrol route" would be a meta property for a royal guard? |
| 13:39 | <@TheWatcher> | Potentially that sort of thing, yes. |
| 13:50 | < Azash> | I imagine he means more programming-related properties like "make this dog a member of the royal guard faction" |
| 14:00 | | Karono [Karono@Nightstar-0e4527e4.optusnet.com.au] has quit [Client closed the connection] |
| 14:01 | | Karono [Karono@Nightstar-0e4527e4.optusnet.com.au] has joined #code |
| 14:06 | | Vorntastic [Vorn@Nightstar-f6acfcc2.sub-70-211-3.myvzw.com] has quit [[NS] Quit: Bye] |
| 14:06 | | Pandemic [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
| 14:06 | | mode/#code [+o Pandemic] by ChanServ |
| 14:40 | | VirusHome [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
| 14:41 | | Pandemic [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [NickServ (GHOST command used by VirusHome)] |
| 14:41 | | VirusHome is now known as Pandemic |
| 14:41 | | mode/#code [+o Pandemic] by ChanServ |
| 14:50 | | Serah [Z@Nightstar-b920a19c.cust.comxnet.dk] has quit [Ping timeout: 121 seconds] |
| 14:51 | | Karono [Karono@Nightstar-0e4527e4.optusnet.com.au] has quit [Ping timeout: 121 seconds] |
| 15:09 | | Kindamoody|out is now known as Kindamoody |
| 15:11 | | celticminstrel [celticminst@Nightstar-3d915c28.dsl.bell.ca] has joined #code |
| 15:11 | | mode/#code [+o celticminstrel] by ChanServ |
| 15:22 | | Kindamoody is now known as Kindamoody|out |
| 15:34 | | Grue [Grue@Nightstar-1b3d4f66.hfc.comcastbusiness.net] has joined #code |
| 15:35 | < Grue> | If you use ubuntuforums.org, your password for that site has been harvested in encrypted form and is at risk, change it immediately: http://ubuntuforums.org/announce.html |
| 15:35 | < Grue> | Of course you can't change it at this moment, but make sure you do! |
| 15:37 | < Grue> | We now return you to your regularly scheduled hilarity.... |
| 15:38 | | Grue [Grue@Nightstar-1b3d4f66.hfc.comcastbusiness.net] has left #code ["Reality is a variable!"] |
| 15:43 | | * ToxicFrog successfully patches a SCO EAFS filesystem image to be mountable on linux |
| 16:07 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 16:17 | | Turaiel[Offline] is now known as Turaiel |
| 17:38 | | Derakon[AFK] is now known as Derakon |
| 18:24 | < Azash> | "encrypted form" |
| 18:25 | < Azash> | I bet it involves MD5 somewhere |
| 18:26 | | ktemkin[avol] is now known as ktemkin[work] |
| 18:27 | <@Tamber> | Azash, you have far too much faith. |
| 18:27 | <@Tamber> | It'll be rot13. |
| 19:25 | | Kindamoody|out is now known as Kindamoody |
| 20:19 | <@froztbyte> | Basic Auth |
| 20:19 | <@froztbyte> | hidden behind some <form> entries |
| 20:34 | | Kindamoody is now known as Kindamoody[zZz] |
| 22:44 | | ErikMesoy is now known as ErikMesoy|sleep |
| 22:59 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [[NS] Quit: Program Shutting down] |
| 23:04 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
| 23:13 | < Azash> | http://i.imgur.com/M1KU6MO.jpg |
| 23:27 | | * Tamber ponders. |
| 23:30 | <@Tamber> | I think my calculations are screwed up, somewhere. At least, I *hope* they are, because the other option is rather more worrying. Apparently, at 3600 RPM, I have a piston travelling at 128 kilometers per second. This would end... badly. |
| 23:33 | | Derakon is now known as Derakon[AFK] |
| 23:37 | | Vorntastic [Vorn@Nightstar-221158c7.sd.cox.net] has joined #code |
| 23:41 | < [R]> | Yeah, seems off |
| 23:41 | < [R]> | Vorntastic: hey, up for DB chat? |
| 23:41 | < Vorntastic> | Sure, some |
| 23:42 | < [R]> | <Vorntastic> And then attr_id I'd make into a thing I can, um, get localized strings for? |
| 23:42 | < [R]> | <Vorntastic> Maybe not that highfalutin |
| 23:42 | < [R]> | <[R]> I don't think that's the DB's perview. |
| 23:42 | < [R]> | <Vorntastic> But decidedly don't store the names in the volatiles. |
| 23:42 | < [R]> | <[R]> Yeah, no. I'll be using an enum or similar there. |
| 23:42 | | * Tamber decides to flail off to bed, in case the solution becomes obvious after some sleep |
| 23:42 | < [R]> | So... "volatiles" |
| 23:43 | < Vorntastic> | When I say volatiles I guess what I really mean is data write-accessible by users instead of just by admins |
| 23:43 | < [R]> | Ah |
| 23:44 | < [R]> | Well, that's why I keep suggesting it's an ENUM (or the other near-equiv thing; I haven't done SQL in years); it'll be limited to a strict list of allowed options. |
| 23:45 | < [R]> | Then I can UNIQUE the trait-name and the character-id together, so each character has at most one of each trait. |
| 23:45 | < [R]> | That alleviates your concern there, or am I misunderstanding it? |
| 23:46 | < Vorntastic> | That there is exactly the goal. |
| 23:46 | < Vorntastic> | Though also placing the actual printed name separately is a good plan. |
| 23:47 | < [R]> | ? |
| 23:47 | < Vorntastic> | Like, you don't want, um |
| 23:47 | | Serah [Z@Nightstar-b920a19c.cust.comxnet.dk] has joined #code |
| 23:48 | < Vorntastic> | You don't want attr_id to be stored as "strength" for instance. |
| 23:49 | < [R]> | Actually, with an ENUM that's fine. Data-wise it'll be stored as an INT. The DB converts it when the rows go in/out. |
| 23:49 | | Reiv [NSwebIRC@Nightstar-95746c1f.kinect.net.nz] has joined #code |
| 23:50 | | mode/#code [+o Reiv] by ChanServ |
| 23:52 | < [R]> | I think you want me to store the names in a reference table though. |
| 23:52 | < [R]> | I'm not sure why I'd want to do that. |
| 23:54 | < [R]> | http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/ <-- reading this though... I could add a column which says which kind of trait each trait is (as they have different point-buy and advancement-costs. |
| 23:55 | < Vorntastic> | Key data in general should be Meaningless |
| 23:56 | < Vorntastic> | You don't want to get yourself in a situation where you could potentially have a typo in key data and can't change it. |
| 23:57 | <@Namegduf> | MediaWiki uses the user's username as the key in many, many places. |
| 23:57 | < [R]> | Hmm |
| 23:57 | <@Namegduf> | This makes the Renameuser extension a very Fun one. |
| 23:57 | < [R]> | How would I be inserting with this though. |
| 23:58 | < [R]> | O.o |
| 23:58 | <@Namegduf> | It has the ability to split the work into deferred tasks as it slowly restores consistency. |
| 23:58 | <@Namegduf> | If the number of edit history entries it needs to rewrite is high enough. |
| --- Log closed Mon Jul 22 00:00:18 2013 |