Zugg Software :: View topic

Apprentice Joined: 11 Sep 2005 Posts: 124

How do I go about:
1.Determining wether or not a database is FULLY loaded
2.Determining whether or not any %query's are in progress

Tried running a while loop on the contents of a known result to query, but the database doesnt seem to load while a query is in progress.

Posted: Thu Dec 15, 2005 6:57 pm

I don't think it's possible to do it directly you can kludge it though? For example, if you issue a #DBSAVE after every #DBLOAD , or do

Apprentice Joined: 11 Sep 2005 Posts: 124

yeah, Its a speed issue up to 10*3 parallel requests, tried to cut it down abit by storing the record# from the 1st query for each item, but I still have problems with those running in parallel.

The inital wait in the trigger was necessary to get it not to set all the Target varables to the same (wrong) passage from @canuse_servant, all %db/%query calls work correct if executed as the only call.

Current Code:
alias: passage_use
#var canuse_servant ""
#forall @index_%1 {#if %db( @%-1, {%i})<=@servant_level {#additem canuse_servant {%i}} {#NOOP}}

Trigger:
(%d)~)(%s)~[(*)~](%s)~[(*)~](%s)~[(*)~]
Value:
#WAIT 1500
passage_use %5
#var Target_Trim_%1_Short_Desc {%trim( %3)}
#var Target_Trim_%1_Target_Area {%trim( %7)}
#addkey Target_%1 Record -1
#var queryinprog 0
#while %db( @Target_%1, Record)=-1 {
#if @queryinprog=1 {#NOOP} {
#addkey Target_%1 Record %if( %query( ((&Short_Desc=@Target_Trim_%1_Short_Desc)&(&Area_Name=@Target_Trim_%1_Target_Area)), Mobiles_AotC)="", -1, %query( ((&Short_Desc=@Target_Trim_%1_Short_Desc)&(&Area_Name=@Target_Trim_%1_Target_Area)), Mobiles_AotC))
#var queryinprog 1
}
}
#var queryinprog 0
#addkey Target_%1 Passage_Use {%item( @canuse_servant, %numitems( @canuse_servant))}
#addkey Target_%1 Number {%1}
#addkey Target_%1 Short_Desc {%3}
#addkey Target_%1 Passage_Group {%5}
#addkey Target_%1 Target_Area {%7}
#addkey Target_%1 Long_Desc {%db( %db( @Target_%1, Record),Long_Desc)}
#addkey Target_%1 Name {%db( %db( @Target_%1, Record), Name)}
#additem currentlongdescs_descs {%db( @Target_%1, Long_Desc)}
#addkey serv_namesbydesc {%db( @Target_%1, Long_Desc)} {%db( @Target_%1, Name)}
#if %ismember( %5, @passage_group_have)>0 {#additem can_do_target_list {%1}} {#noop}

Parsing this

____________________________________________________________________________

Servant Duty List
----------------------------------------------------------------------------
Name Group Area

1) [A cackling witch ] [Courage ] [Cargan Ruins ]
2) [a centipede ] [Compassion ] [Moria ]
3) [a flying squirrel ] [Compassion ] [Gerighelm ]
4) [hobgoblin flunky ] [Compassion ] [Crystalmir Lake ]
5) [a wood elf ranger ] [Confession ] [Myre Forests ]
6) [A githyanki guardian ] [Compassion ] [Astral Plane ]
7) [the fanatic cultist ] [Compassion ] [Divided Souls ]
8) [the zombie gnome ] [Blessings ] [Gnome Village ]
9) [sleeping barbarian ] [Exhortation ] [Arctic Wasteland ]
10) [a chanting troll ] [Death ] [Troll Den ]
____________________________________________________________________________

Apprentice Joined: 11 Sep 2005 Posts: 124

Example of a Target Varable that It should be able to Generate <NOT FOR THE example data I gave you that its trying to parse, from an earlier one I did by hand, for reference>

#showdb @Target_1

Number: 1
Name: dolphin
Passage_Use: 1 Corinthians 6:19
Short_Desc: a dolphin
Passage_Group: Devotion
Target_Area: Candyland
Long_Desc: A dolphin is here swimming around in this clear blue water.
Record: 2484mo

Apprentice Joined: 11 Sep 2005 Posts: 124

initially I had a trigger off of Servant Duty List to #DBCLOSE;#DBOPEN mo, and then #alarm +100 #DBCLOSE
Running 3 seperate Databases on this Character, so I need to ensure the right one is open before parsing.

Magician Joined: 23 Nov 2004 Posts: 364

anyway to check if database is already open? like #if (%database...) {#NOOP} {#DBOPEN name}