SQLite

[Inverness]

*Simmering*

[Crow]

Great new addition. And while we are talking about great new addition, could you please add Lua as a secondary, optional scripting language to Graal? I know this would be time consuming and lots of work/effort, but it would be so much worth it. Torque Engine Script (or whatever it is called) is a pile of poo compared to Lua. Lua is rated the fasted scripting language availabe.

[Inverness]

Originally Posted by Crow

Great new addition. And while we are talking about great new addition, could you please add Lua as a secondary, optional scripting language to Graal? I know this would be time consuming and lots of work/effort, but it would be so much worth it. Torque Engine Script (or whatever it is called) is a pile of poo compared to Lua. Lua is rated the fasted scripting language availabe.

Graal's scripting language was made by Stefan, it has nothing to do with Torque (other than the special GUI control syntax), it is merely compliant with some standard that I forget the name of.

Lua would be an improvement because it is a stable and well developed, and compact language. Of course we can't simply use Lua as it is because with Graal, security needs to be considered so Stefan would have to modify Lua to add security measures before he could use it.

It's too much work at this point.

I'm also obligated to say that I think Stackless Python is a better choice than Lua, but would be harder to modify for Graal-level security I think.

[Crow]

Originally Posted by Inverness

Graal's scripting language was made by Stefan, it has nothing to do with Torque (other than the special GUI control syntax), it is merely compliant with some standard that I forget the name of.

Lua would be an improvement because it is a stable and well developed, and compact language. Of course we can't simply use Lua as it is because with Graal, security needs to be considered so Stefan would have to modify Lua to add security measures before he could use it.

It's too much work at this point.

I'm also obligated to say that I think Stackless Python is a better choice than Lua, but would be harder to modify for Graal-level security I think.

As far as I know, GScript2 is Torque Engine Script with quite a lot of Graal modifications to it. Correct me if I'm wrong though.

[Inverness]

Originally Posted by Crow

As far as I know, GScript2 is Torque Engine Script with quite a lot of Graal modifications to it. Correct me if I'm wrong though.

You are wrong, GScript2 is GScript2, its syntax is just made to conform to a standard.

[LoneAngelIbesu]

Originally Posted by Inverness

You are wrong, GScript2 is GScript2, its syntax is just made to conform to a standard.

Inverness is correct. (http://graal.net/index.php/TorqueScript) GS2 just borrows from its syntax.

And no, SQLite has not been added to Valikorlia... and 2 database backups per day is a bit unnecessary.

[Crow]

I see. Good to know, thanks.

[Inverness]

Originally Posted by LoneAngelIbesu

And no, SQLite has not been added to Valikorlia... and 2 database backups per day is a bit unnecessary.

Backups as a whole seem to be unnecessary to you, since you haven't made any backups yourself . Though, I think once per day is a good interval.

[LoneAngelIbesu]

Originally Posted by Inverness

Backups as a whole seem to be unnecessary to you, since you haven't made any backups yourself . Though, I think once per day is a good interval.

No need to get snippy, Inverness. I don't back anything up because downloading files more than 1mb crashes my RC, 9 times out of 10.

In the rest of the scripting world, the number of times you back up data is proportionate to when the most changes occur (if data is updated weekly, there's no need to make daily backups), and sometimes how likely it is that you will need to restore that data (if you're not concerned with frequent server crashes). The only times Valikorlia has ever needed to restore back ups are when a staff member deletes everything in a hissy fit, and when the NPC server crashes. The first one happens more often than the latter, and the latter is only a problem because we're not using SQLite databases.

If you want to back-up all the information twice a day, or once a day, go ahead. I don't see the need for such paranoia, and am fine with weekly backups.

[Inverness]

Originally Posted by LoneAngelIbesu

No need to get snippy, Inverness. I don't back anything up because downloading files more than 1mb crashes my RC, 9 times out of 10.

Excuses, I sure haven't heard about this problem of yours so I guess you didn't think it important enough to ask about.

Originally Posted by LoneAngelIbesu

If you want to back-up all the information twice a day, or once a day, go ahead. I don't see the need for such paranoia, and am fine with weekly backups.

Whether or not you are fine with weekly backups is irrelevant. You are staff and can easily manipulate your inventory, players can't and it's much easier to back up their inventories every day than to traverse logs to find out how their inventory has changed since the last backup in the event of a problem.

[LoneAngelIbesu]

Originally Posted by Inverness

Excuses, I sure haven't heard about this problem of yours so I guess you didn't think it important enough to ask about.

What can you do about it?

Originally Posted by Inverness

Whether or not you are fine with weekly backups is irrelevant. You are staff and can easily manipulate your inventory, players can't and it's much easier to back up their inventories every day than to traverse logs to find out how their inventory has changed since the last backup in the event of a problem.

The point I made was that the likelihood of that being anything close to common occurrence is little to none. Let me break it down even further: the main reason why the NPC server has crashed is because of errors when using the INI file system.

Like I said, though. If you want back everything up that often, go ahead. I'm sure you could even script something that would do it automatically; some GS2 equivalent to a cron job.

EDIT: Could the new NPC server please be put on Valikorlia, already?

[Admins]

Ok the new npcserver has been uploaded to all machines, need to be restarted manually though.

[Inverness]

Originally Posted by Stefan

Ok the new npcserver has been uploaded to all machines, need to be restarted manually though.

Ok, first, what folder is the database file in? I would like if the one on Valikorlia could be placed somewhere visible to RC so it can be backed up easily. I don't feel too comfortable using it otherwise considering everything could be deleted with little effort.

Second, if the table has a column named "name" or like some other static variable then the row object has two variables named "name" in it, I was thinking that when setting the variables in the row object, if it conflicts with static variables then append an underscore.

[Admins]

The database is databases/main.db
Use "as" for renaming columns of the result. You can also access the result as array, like rows[][]

[Inverness]

Originally Posted by Stefan

The database is databases/main.db
Use "as" for renaming columns of the result. You can also access the result as array, like rows[][]

Ah good, thanks.

Could you perhaps make a function for converting arrays into a format suitable for SQL statements? Basically making it into a large string, using single quotes around strings, and escaping the single quotes in the string. I figure that would be better if not done by script.

And, I'd also like a server option for reporting SQLite errors and such on RC.

This is the equivalent script:

PHP Code:

public function sqlarray(array) {
  temp.out = "";
  temp.sz = array.size();
  
  if (temp.sz < 1)
    return "";
  if (temp.array[0].type() == 0)
    temp.out @= temp.array[0];
  else
    temp.out @= this.sqlescape(temp.array[0]);
  for (temp.i = 1; temp.i < temp.array.size(); temp.i ++) {
    if (temp.array[i].type() == 0)
      temp.out @= "," @ temp.array[i];
    else
      temp.out @= "," @ this.sqlescape(temp.array[i]);
  }
  return temp.out;
}
public function sqlescape(rstr) {
  temp.p = temp.rstr.positions("'");
  if (temp.p.size() > 0)
    for (temp.e = temp.p.size() - 1; temp.e > -1; temp.e --)
      temp.rstr = replacesubstring(temp.rstr, temp.p[temp.e], 1, "''");
  return "'" @ temp.rstr @ "'";
}
// replacesubstring from util_string
public function replacesubstring(string, position, length, newstring) {
  if (temp.position < 0) {
    return;
  }
  return temp.string.substring(0, temp.position) @
         temp.newstring @
         temp.string.substring(temp.position + temp.length, -1);
}