<!-- 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>