Graal Forums - looking up db flags

Graal Forums (https://forums.graalonline.com/forums/index.php)

- NPC Scripting (https://forums.graalonline.com/forums/forumdisplay.php?f=8)

- - looking up db flags (https://forums.graalonline.com/forums/showthread.php?t=134259414)

looking up db flags

This is probably more of a logic question. I have a wnpc that needs to look up the flags on a db npc. The thing is Im not sure how to.

The flags in the dbnpc are set up as category_playeraccountname_itemname,
and I need to first use a trigger to lookup and see if the selected category in a gui is the same as the first part of the flag only, then use the account name and item name somewhere else in the wnpc. I have the category selection and gui and all that done, but just not sure how to even go about doing this.
e.g. someone selects the category weapons, so it searches the flags in dbnpc for the first part of the flag name weapons, then puts up who owns it, and the actual name of the weapon.
weapons_sssssssssss_sword={other stuff here i need to pull up eventually too}

hope this makes sense.

I'm still a little confused what specifically your attempting to do here.
But as for accessing information stored in a dbnpc, I recommend making public functions in the dbnpc and calling them to get what you need.

PHP Code:


		
			
public function getInfo(category, account, item){

  return this.items.(@category).(@account).(@item);

}

public function getCategories(){

  clearemptyvars();

  return this.items.getdynamicvarnames();

}

Something like that...

I think the first part of what you did will help.

Basically the var is
category_accountname_itemname={itemimg,itemprice,i temposteddate,itemexpiresdate}

so something like:
weapons_sssssssssss_sword={sword2.png,10,06042010, 06052010}

but in the gui, they select a category first, then it pops up:
item name item image seller(accountname) end date

just dont know how to search the dbnpc to first pull up category, then post the stuff right above here according to each category selected.

That database is going to get really clogged.

Use periods instead of underscores.

PHP Code:


		
			
temp.acc = "cbk1994";
temp.category = "weapons";
temp.item = "super_sword";

temp.itemVars = MyDatabase.(@ category).(@ acc).(@ item);
echo(itemVars);

Oh, I see a little better now. Your making an auction house dealy?

I follow the recommendation, use .'s instead of _'s
I don't like how you have the string stored, but if I were forced to, I might search the categories like this. Untested, but i've done things like this in the past.

PHP Code:


		
			
public function getCategoryListing(temp.category){

  clearemptyvars();

  temp.list = {};

  for (temp.acnt: this.item.(@temp.category).getdynamicvarnames() ){

    for (temp.item: this.item.(@temp.category).(@temp.acnt).getdynamicvarnames() ){

      temp.v = this.item.(@temp.category).(@temp.acnt).(@temp.item);

      temp.list.add({ temp.item, temp.v[0], temp.acnt, temp.v[3] });

    }

  }

  return temp.list;

}

My logic is kind of shot on this, so i'll just ask. whats a better way to store this? Need to keep in mind that one account could have a ton of things in the auction house.

Quote:

Originally Posted by sssssssssss (Post 1580424)

My logic is kind of shot on this, so i'll just ask. whats a better way to store this? Need to keep in mind that one account could have a ton of things in the auction house.

I'd probably use SQL. Otherwise text files, but those can be very limiting depending on how you're going to get the data.

Zodiac's Player Shops use a DB-NPC for all it's data storage, however we only store the item name and price, but if you plan on adding any specific search related features you'll definitely want to go with an SQL-based system to store you data in.

In your case though, you should be able to get away with DB-NPC basic flag storage without a hitch, SQL will most likely complicate things for you.

Quote:

Originally Posted by adam (Post 1580416)

PHP Code:


		
			
public function getCategoryListing(temp.category){

  clearemptyvars();

  temp.list = {};

  for (temp.acnt: this.item.(@temp.category).getdynamicvarnames() ){

    for (temp.item: this.item.(@temp.category).(@temp.acnt).getdynamicvarnames() ){

      temp.v = this.item.(@temp.category).(@temp.acnt).(@temp.item);

      temp.list.add({ temp.item, temp.v[0], temp.acnt, temp.v[3] });

    }

  }

  return temp.list;

}

could you explain this? I'd rather learn, so I dont have to post so many threads for help. Im really not sure what too many of this does, just by looking at it, and not too sure on how to use it. Im guessing its a function that goes in the dbnpc script, and I call it to show up the items for the category selected, but if an explanation line by line is possible with comments or something, that would be great. :)

Quote:

Originally Posted by sssssssssss (Post 1580497)

PHP Code:


		
			
public function getCategoryListing(temp.category){
  clearemptyvars(); // Removes any empty variables in the npc, for example: it would remove 'this.var1= ' if it existed for some reason (usually pointing to an empty object when that happens).
  temp.list = {}; // Create an array outside of for-loop scope so it can be used inside of the for-loop and also outside of it (for the return value).
  // This first for loop will loop through all variables starting with this.item.(temp.category).* where temp.category is the parameter passed in the function and * is anything. For example: if temp.category="pie" then it would loop through all variables starting with 'this.item.pie.' I will explain getdynamicvarnames() below.
  for (temp.acnt: this.item.(@temp.category).getdynamicvarnames() ) {
  // This for loop will loop through similarly to the one above, using the value that was found from 'this.item.(@temp.category).getdynamicvarnames()' to look for deeper variables.
    for (temp.item: this.item.(@temp.category).(@temp.acnt).getdynamicvarnames() ){
      // temp.v is equivalent to 'this.item.(@temp.category).(@temp.acnt).(@temp.item)' in order to shorten it because it will be used several times for temp.list.add().
      temp.v = this.item.(@temp.category).(@temp.acnt).(@temp.item);
      // Add values to the list in their respective order.
      temp.list.add({ temp.item, temp.v[0], temp.acnt, temp.v[3] });
    }
  }

  return temp.list;
}

var.getdynamicvarnames() returns a list of all variables that exist starting with 'var.' This can be used in several ways, for example, to return all client.variables, you could do:

PHP Code:


		
			
//#CLIENTSIDE
function onCreated() {
  for (temp.i: client.getDynamicVarNames()) {
    echo("client." @ temp.i @ " = " @ client.( @ temp.i));
  }
}

Personally, I don't think you should follow the suggestion given above because it seems needlessly complicated unless you fully understand what is going on within the code.

I do understand that, I've done it before, just been about 8months since i touched gs2. If there is a better way, like I said, I'd love to learn. I just need explanations and examples. wiki doesnt seem to give too many answers on sql or this. If anyone feels like completely explaining an alternative that is better, I would love that. I really want to learn, not just be told.

PHP Code:


		
			
function onCreated() {

  this.db = findnpc("DB_Auction");

}

function onActionServerSide() {

  if (params[0] == "getItemsCat") {

    temp.listz = this.db.getCategoryListing(params[1]);

    echo(temp.listz);

    triggerClient("weapon", this.name, "setList", this.db.getCategoryListing(params[1]), params[1]);

  }

}

//#CLIENTSIDE

function onActionClientSide() {

  if (params[0] == "setList") {

    player.chat = params[2];

  }

}

temp.listz never echoes on the serverside, and player.chat doesnt say anything on the clientside. This is what is in the npc.

PHP Code:


		
			
public function getCategoryListing(temp.category){ 

  clearemptyvars(); 

  temp.list = {}; 

  for (temp.acnt: this.item.(@temp.category).getdynamicvarnames() ){ 

    for (temp.item: this.item.(@temp.category).(@temp.acnt).getdynamicvarnames() ){ 

      temp.v = this.item.(@temp.category).(@temp.acnt).(@temp.item); 

      temp.list.add({ temp.item, temp.v[0], temp.acnt, temp.v[3] }); 

    } 

  } 

  return temp.list; 

}

this is the flags in the npc:

PHP Code:


		
			
this.item.Weapons.sssssssssss.Sword={sword2.png,0,0,0}

Weapons.sssssssssss.Sword={sword2.png,0,0,0}

(also tried just this.Weapons.sssssss.......)

Its not doing anything :/ this.db is to the correct db name too.

Try "DB_Auction.getCategoryListing(params[1]);" You can use dbnpc names directly. Also add an echo or 3 to the dbnpc script to make sure it's called, and your sending the right params and things.

Also, echo("List: " @ temp.listz) so it shows up even if the list is empty. And why are you calling the db function twice in a row?

tried an echo for:

PHP Code:


		
			
echo(this.item.(@temp.category).getdynamicvarnames());

echo(temp.v);

echo(temp.list);

none of those did anything in the dbnpc. but if i put:

PHP Code:


		
			
echo("hello");

it works, so its not that its not getting sent or anything.

Try putting this flag:

item.Weapons.sssssssssss.Sword=sword2.png,0,0,0

it did everything but the last two 0's in the flag, so i changed it to 0,1,2
and it just echos "Sword,sword2.png,sssssssssss,2",

Quote:

Originally Posted by sssssssssss (Post 1580706)

it did everything but the last two 0's in the flag, so i changed it to 0,1,2
and it just echos "Sword,sword2.png,sssssssssss,2",

For now that doesnt matter.
Different question, i have this script in the dbnpc as well.

PHP Code:


		
			
public function getItemImage(temp.selection) {

  temp.az = this.(@temp.selection)[0];

  echo(temp.az);

  return this.(@temp.selection)[0];

}

the temp.selection = something like item.Weapons.sssssssssss.Sword.

Its not putting up values for the array of the flag in the dbnpc, what am i doing wrong now?

Nevermind, got it. Was needing to set that . stuff up in the dbnpc, not in the wnpc. :)