About GlobalVariable

[Milos]

I created a function to add all users registered on my server in a global variable. But my question is: Is there a data limit for it?
If I have 5000 accounts, this variable will hold all?

Code Select Expand

Users <- [];

function LoadAccounts()
{
local q = QuerySQL( db, "SELECT * FROM Accounts" );
while ( GetSQLColumnData( q, 0 ) )
{
Users.push( GetSQLColumnData( q, 0 ) );
GetSQLNextRow( q );
}
FreeSQLQuery( q );
}

[maxorator]

Yes, unless you run out of memory. That shouldn't happen unless you store many millions of rows in there though.

[.]

Not at all. Assuming all members take about 1024 bytes of memory each (and I doubt they do) you'd still, eat only 5MB of memory. so I'd say that you're pretty safe. Memory leaks on the other hand, resulted from unreleased statements and other unmanaged data, will eventually make your server have a slow and painful death depending on how much you leak and for how long.

[KAKAN]

I use the same way for storing bans and all, not for accounts though.
You can use a table and store the data of all joined players.
I find this way to be more useful

Code Select Expand

Accounts <- {
list = [],

function Load(){
 local q = QuerySQL( db, "SELECT * FROM Accounts" );
 while ( GetSQLColumnData( q, 0 ) )
 {
  Users.push( GetSQLColumnData( q, 0 ) );
  GetSQLNextRow( q );
 }
 FreeSQLQuery( q );
}
}
And to use it:

Code Select Expand

Accounts.Load();Good luck!

[Milos]

I use the same way for storing bans and all, not for accounts though.
You can use a table and store the data of all joined players.
I find this way to be more useful

Code Select Expand

Accounts <- {
list = [],

function Load(){
 local q = QuerySQL( db, "SELECT * FROM Accounts" );
 while ( GetSQLColumnData( q, 0 ) )
 {
  Users.push( GetSQLColumnData( q, 0 ) );
  GetSQLNextRow( q );
 }
 FreeSQLQuery( q );
}
}
And to use it:

Code Select Expand

Accounts.Load();Good luck!

I liked it, thank you for sharing