can someone tell me how to do this?

[Frankie]

okay:

we have a database that stores all bank accounts and the money in them.
I want to make something so I can loop through the flags in the database and get all ones that are greater than a certain amount.

for example

if I said /npc checkbanks 500000
it would tell me all the accounts in the database that had 500,000 or more.

tig did it for us a while ago so I know it's possible. I just don't know how to approach this.

I can do the obvious:
for (pl: allplayers)
{
echo(pl SPC "has" SPC DB_Bank.("acc_" @ pl)[0]);
}

but that would only give me the ones that are online. I need to see offline ones too.

[Chompy]

PHP Code:

function onCreated() {
  with(findnpc("DB_Bank")) {
    for(temp.pl : getstringkeys("this.acc_")) {
      temp.a = makevar("this.acc_" @ pl);

      echo("Player "@ pl @" has "@ a[0] @" money!");
    }
  }
} 


This should echo all the players and what they have in rc (Those who have a this.acc_<account> variable in the database)

Now, how can we use this to find for example, those who have more then 50,000?

PHP Code:

function onCreated() {
  temp.check = 50000; // What to check for
  temp.p = 0;

  with(findnpc("DB_Bank")) {
    for(temp.pl : this.getstringkeys("this.acc_")) {
      temp.a = makevar("this.acc_"@ pl);
      if (a[0] >= check) {
        p.add(pl);
      }
    }
  }
  /*
    All the players who have 50,000 or more would be listed in the
    array 'p'
  */
} 


Hope this helps

PS: I made these scripts on the go, so I don't know if they work properly or not

[cbk1994]

Originally Posted by Chompy

PHP Code:

function onCreated() {
  with(findnpc("DB_Bank")) {
    for(temp.pl : this.getstringkeys("this.acc_")) {
      temp.a = makevar("this.acc_" @ pl);

      echo("Player "@ pl @" has "@ a[0] @" money!");
    }
  }
} 


This should echo all the players and what they have in rc (Those who have a this.acc_<account> variable in the database)

Now, how can we use this to find for example, those who have more then 50,000?

PHP Code:

function onCreated() {
  temp.check = 50000; // What to check for
  temp.p = 0;

  with(findnpc("DB_Bank")) {
    for(temp.pl : this.getstringkeys("this.acc_")) {
      temp.a = makevar("this.acc_"@ pl);
      if (a[0] >= check) {
        p.add(pl);
      }
    }
  }
  /*
    All the players who have 50,000 or more would be listed in the
    array 'p'
  */
} 


Hope this helps

PS: I made these scripts on the go, so I don't know if they work properly or not

Those look like how I'd do it, though what's the difference between getstringkeys() and getdynamicvarnames()?

[DustyPorViva]

getstringkeys() will get the variables that start with whatever parameter you provide. getdynamicvarnames() simply gets a list of all dynamic variables.

[cbk1994]

Originally Posted by DustyPorViva

getstringkeys() will get the variables that start with whatever parameter you provide. getdynamicvarnames() simply gets a list of all dynamic variables.

Oh, okay. I would have gone like this:

PHP Code:

temp.x = blah.getdynamicvarnames();
for ( temp.foo : temp.x )
{
  if ( temp.foo.starts( "LOL" ) )
  {
    //whatev
  }
} 


[Chompy]

Originally Posted by cbkbud

Oh, okay. I would have gone like this:

PHP Code:

temp.x = blah.getdynamicvarnames();
for ( temp.foo : temp.x )
{
  if ( temp.foo.starts( "LOL" ) )
  {
    //whatev
  }
} 


A loop using getstringkeys() will run less then using getdynamicvarnames() since you specify the prefix to look for, instead of checking every member of getdynamicvarnames() if they start with the prefix

[Tigairius]

I have a question, why was it deleted in the first place, Frankie? o_o

[cbk1994]

Originally Posted by Tigairius

I have a question, why was it deleted in the first place, Frankie? o_o

It wasn't; this is just a drill

Just like when we were outside for 5 hours at school today for a bomb threat, and they were like "LOL IT WAS JUST DRILL .. DONT MIND HAZMAT, BOMB SQUAD, FIRE TRUCKS ETC"

[zokemon]

this.blah.foo.bar

getstringkeys("this.blah") would give you "foo.bar" while this.blah.getdynamicvarnames() would give you just "foo".

[Chompy]

Originally Posted by zokemon

this.blah.foo.bar

getstringkeys("this.blah") would give you "foo.bar" while this.blah.getdynamicvarnames() would give you just "foo".

Actually, getstringkeys("this.blah") would give you "" and doing getstringkeys("this.blah.") would give you "foo" ;o

[zokemon]

Originally Posted by Chompy

Actually, getstringkeys("this.blah") would give you "" and doing getstringkeys("this.blah.") would give you "foo" ;o

Ehh? getstringkeys gives you the var names starting with the parameter, at least last I checked I'm pretty sure it did. I may be going off what I read on these forums though; I often get what I've done my self and what I read mixed up :P.

[Chompy]

Originally Posted by zokemon

Ehh? getstringkeys gives you the var names starting with the parameter, at least last I checked I'm pretty sure it did. I may be going off what I read on these forums though; I often get what I've done my self and what I read mixed up :P.

I tested it before I posted that post, so I dunno :o

[[email protected]]

didn't i do this for era like three years ago?
anyway, here's a better script probably. change the loop at the bottom and it'll give you the top richest players etc

PHP Code:

function onCreated() {
  for (temp.i: getstringkeys("this.acc_")) 
    temp.accs.add({i, this.("acc_" @ i)[0]});
    
  for (i: accs) {
    temp.e.add(i[0]);
    temp.e[temp.c].sortvalue = i[1];
    temp.c++;
  }
  e.sortbyvalue("sortvalue", "float", false);
  
  echo("Richest 5 Players:");
  for (i = 0; i < 5; i++) 
    echo(e[i] @ ":-" SPC this.("acc_" @ e[i])[0]);
} 


[Frankie]

thank you.
"sidney" yours works well.

[[email protected]]

it's not a problem he he