<!-- MHonArc v2.4.4 --> <!--X-Subject: Modeling spells/skills as collections of affects --> <!--X-From-R13: E001U[GNabin.jevtug.rqh --> <!--X-Date: Tue, 09 Sep 1997 13:18:07 +0000 --> <!--X-Message-Id: 01INFMA3YZYA8Y5YKN#nova,wright.edu --> <!--X-Content-Type: text/plain --> <!--X-Head-End--> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <html> <head> <title>MUD-Dev message, Modeling spells/skills as collections of affects</title> <!-- meta name="robots" content="noindex,nofollow" --> <link rev="made" href="mailto:S001GMU#nova,wright.edu"> </head> <body background="/backgrounds/paperback.gif" bgcolor="#ffffff" text="#000000" link="#0000FF" alink="#FF0000" vlink="#006000"> <font size="+4" color="#804040"> <strong><em>MUD-Dev<br>mailing list archive</em></strong> </font> <br> [ <a href="../">Other Periods</a> | <a href="../../">Other mailing lists</a> | <a href="/search.php3">Search</a> ] <br clear=all><hr> <!--X-Body-Begin--> <!--X-User-Header--> <!--X-User-Header-End--> <!--X-TopPNI--> Date: [ <a href="msg01167.html">Previous</a> | <a href="msg01169.html">Next</a> ] Thread: [ <a href="msg01078.html">Previous</a> | <a href="msg00926.html">Next</a> ] Index: [ <A HREF="author.html#01168">Author</A> | <A HREF="#01168">Date</A> | <A HREF="thread.html#01168">Thread</A> ] <!--X-TopPNI-End--> <!--X-MsgBody--> <!--X-Subject-Header-Begin--> <H1>Modeling spells/skills as collections of affects</H1> <HR> <!--X-Subject-Header-End--> <!--X-Head-of-Message--> <UL> <LI><em>To</em>: <A HREF="mailto:mud-dev#null,net">mud-dev#null,net</A></LI> <LI><em>Subject</em>: Modeling spells/skills as collections of affects</LI> <LI><em>From</em>: <A HREF="mailto:S001GMU#nova,wright.edu">S001GMU#nova,wright.edu</A></LI> <LI><em>Date</em>: Tue, 09 Sep 1997 09:16:43 -0500 (EST)</LI> </UL> <!--X-Head-of-Message-End--> <!--X-Head-Body-Sep-Begin--> <HR> <!--X-Head-Body-Sep-End--> <!--X-Body-of-Message--> <PRE> sorry for the delayed response... RL reared its ugly head for a while and I didn't have a chance to get back to this until now. :) Date: Thu, 04 Sep 1997 01:14:50 +0000 (PST8PDT) From: Miroslav Silovic <silovic#mare,zesoi.fer.hr> >Caliban Tiresias Darklock <caliban#darklock,com> writes: > >> S001GMU#nova,wright.edu wrote: >> > >> > Spell >> > construction would consist of building the query (would definately want some >> > interface here so that ppl don't have to learn SQL to create spells on the >> > MUD!), >> >> WAIT! WAIT! The language of magic! This is a GREAT idea! > >Check mage2mage system (somebody posted the URL here not long ago, or >I could email if you request). They specced out the costs for each >executed statement in the language. And I also loved the fact that to >create a permanent magical item, you have to bind a demon into it, and >to summon a demon, you have to sacrifice a living, sentient >creature... I'll have to look into that... someone posted it here, I believe, but I have yet to read it. RL again..ugh. :P >> Translate all the SQL syntax into pseudo-Latin words, give your database >> fields odd names, and make people type in the queries in this strange >> fictional language. That would be so cool. > >Umm, I don't think this would work all that well. How do you say >'sphere of 50' radius around the orc' in SQL? That depends entirely on how you have your world stored in memory. Diku-style rooms don't use 50' Radii spells, etc. Assuming you use a "real" coord system, you could do a query like so (forgive the psuedo-SQL-code. I'm not up on my SQL): get target orc's coords, modify all creatures whose ((coords - orc's coords) < 50'). I believe that's really not all that complicated in SQL. Depending on the way you have you info indexed, that can be quite an efficient search too. > For that matter, while I >like the idea of using an existing database code in a MUD server, I >think that interpretation of SQL is completely unnecessary, and far >too inefficient. Aye, that may be. For now, I'm gonna stick with it, though. When I start to run into speed problems, and the efficiency of the SQL conversion is the problem, I'll look into removing it. :) -Greg </PRE> <!--X-Body-of-Message-End--> <!--X-MsgBody-End--> <!--X-Follow-Ups--> <HR> <!--X-Follow-Ups-End--> <!--X-References--> <!--X-References-End--> <!--X-BotPNI--> <UL> <LI>Prev by Date: <STRONG><A HREF="msg01167.html">Re: [MUD-Dev] Alignment</A></STRONG> </LI> <LI>Next by Date: <STRONG><A HREF="msg01169.html">Re: [MUD-Dev] MUD Design Fundamentals (Was: Looking for</A></STRONG> </LI> <LI>Prev by thread: <STRONG><A HREF="msg01078.html">Modeling spells/skills as collections of affects</A></STRONG> </LI> <LI>Next by thread: <STRONG><A HREF="msg00926.html">[MUD-Dev] Hard Sci-fi muds was Character evolution</A></STRONG> </LI> <LI>Index(es): <UL> <LI><A HREF="index.html#01168"><STRONG>Date</STRONG></A></LI> <LI><A HREF="thread.html#01168"><STRONG>Thread</STRONG></A></LI> </UL> </LI> </UL> <!--X-BotPNI-End--> <!--X-User-Footer--> <!--X-User-Footer-End--> <ul><li>Thread context: <BLOCKQUOTE><UL> <LI><STRONG>Re: [MUD-Dev] Modeling spells/skills as collections of affects</STRONG>, <EM>(continued)</EM> <ul compact> <ul compact> <LI><strong><A NAME="01049" HREF="msg01049.html">Re: [MUD-Dev] Modeling spells/skills as collections of affects</A></strong>, Caliban Tiresias Darklock <a href="mailto:caliban#darklock,com">caliban#darklock,com</a>, Wed 03 Sep 1997, 17:03 GMT <UL> <LI><strong><A NAME="01070" HREF="msg01070.html">Re: [MUD-Dev] Modeling spells/skills as collections of affects</A></strong>, Miroslav Silovic <a href="mailto:silovic#mare,zesoi.fer.hr">silovic#mare,zesoi.fer.hr</a>, Thu 04 Sep 1997, 08:11 GMT </LI> <LI><strong><A NAME="01071" HREF="msg01071.html">Re: [MUD-Dev] Modeling spells/skills as collections of affects</A></strong>, Miroslav Silovic <a href="mailto:silovic#mare,zesoi.fer.hr">silovic#mare,zesoi.fer.hr</a>, Thu 04 Sep 1997, 08:13 GMT </LI> </UL> </LI> </ul> <LI><strong><A NAME="01078" HREF="msg01078.html">Modeling spells/skills as collections of affects</A></strong>, S001GMU <a href="mailto:S001GMU#nova,wright.edu">S001GMU#nova,wright.edu</a>, Thu 04 Sep 1997, 12:50 GMT </LI> <LI><strong><A NAME="01168" HREF="msg01168.html">Modeling spells/skills as collections of affects</A></strong>, S001GMU <a href="mailto:S001GMU#nova,wright.edu">S001GMU#nova,wright.edu</a>, Tue 09 Sep 1997, 13:18 GMT </LI> </ul> </LI> <LI><strong><A NAME="00926" HREF="msg00926.html">[MUD-Dev] Hard Sci-fi muds was Character evolution</A></strong>, Brian Price <a href="mailto:blprice#bedford,net">blprice#bedford,net</a>, Mon 01 Sep 1997, 01:34 GMT <UL> <LI><strong><A NAME="00930" HREF="msg00930.html">Re: [MUD-Dev] Hard Sci-fi muds was Character evolution</A></strong>, Jeff Kesselman <a href="mailto:jeffk#tenetwork,com">jeffk#tenetwork,com</a>, Mon 01 Sep 1997, 03:14 GMT </LI> <LI><strong><A NAME="01012" HREF="msg01012.html">Re: [MUD-Dev] Hard Sci-fi muds was Character evolution</A></strong>, Shawn Halpenny <a href="mailto:malachai#iname,com">malachai#iname,com</a>, Tue 02 Sep 1997, 16:12 GMT </LI> </UL> <UL> <li><Possible follow-up(s)><br> <LI><strong><A NAME="00929" HREF="msg00929.html">Re: [MUD-Dev] Hard Sci-fi Muds was Character Evolution</A></strong>, Brian Price <a href="mailto:blprice#bedford,net">blprice#bedford,net</a>, Mon 01 Sep 1997, 02:48 GMT </LI> </UL> </LI> </UL></BLOCKQUOTE> </ul> <hr> <center> [ <a href="../">Other Periods</a> | <a href="../../">Other mailing lists</a> | <a href="/search.php3">Search</a> ] </center> <hr> </body> </html>