Graal Forums
Page 2 of 6 1 2 3456
Show 40 post(s) from this thread on one page

Graal Forums (https://forums.graalonline.com/forums/index.php)
-   Future Improvements (https://forums.graalonline.com/forums/forumdisplay.php?f=10)
-   -   SQLite (https://forums.graalonline.com/forums/showthread.php?t=84995)

Inverness 04-10-2009 02:30 PM
*Simmering*

Crow 04-10-2009 03:12 PM
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 04-10-2009 03:35 PM
Quote:
Originally Posted by Crow (Post 1482743)
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 04-10-2009 04:58 PM
Quote:
Originally Posted by Inverness (Post 1482744)
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 04-10-2009 05:01 PM
Quote:
Originally Posted by Crow (Post 1482753)
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 04-10-2009 05:07 PM
Quote:
Originally Posted by Inverness (Post 1482754)
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 04-10-2009 06:47 PM
I see. Good to know, thanks.

Inverness 04-11-2009 01:48 AM
Quote:
Originally Posted by LoneAngelIbesu (Post 1482756)
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 04-11-2009 05:10 PM
Quote:
Originally Posted by Inverness (Post 1482837)
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 04-11-2009 05:39 PM
Quote:
Originally Posted by LoneAngelIbesu (Post 1482981)
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.
Quote:
Originally Posted by LoneAngelIbesu (Post 1482981)
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 04-11-2009 05:47 PM
Quote:
Originally Posted by Inverness (Post 1482989)
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?
Quote:
Originally Posted by Inverness (Post 1482989)
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 04-11-2009 08:07 PM
Ok the new npcserver has been uploaded to all machines, need to be restarted manually though.

Inverness 04-11-2009 08:35 PM
Quote:
Originally Posted by Stefan (Post 1483015)
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 04-11-2009 09:50 PM
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 04-12-2009 08:20 AM
Quote:
Originally Posted by Stefan (Post 1483044)
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);
} 


All times are GMT +2. The time now is 04:06 AM.
Page 2 of 6 1 2 3456
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Copyright (C) 1998-2019 Toonslab All Rights Reserved.