Database Problems

[Honey.]

Hello,

I was making a Register/Login System for my script but my database is not accessible by the vcmp server.I tried making Tables using my script but the database is not reached properly and when the server is ON the datbase should get locked as a default but my database doesn't get Locked.I have updated modules and Updated vcmp server client.There was a Bug in the modules where the modules cannot connect to the database but according to Stormeus it was Fixed.I do not know why I still have it.

OFF : How to know someone's FPS?

[thijn]

Post some code and your directory structure.

[Honey.]

I tried to make tables like this :

Code: [Select]

QuerySQL( db, "CREATE TABLE IF NOT EXISTS Account ( Name TEXT, Password TEXT, IP NUMERIC, Level NUMERIC, Cash NUMERIC, Bank NUMERIC, )" );

but the database is not affected.Secondly the database was not locked when I tried to save something in it, which proves that there was no connection between my server and database.

Dir Structure :

[heekz.shadow]

You realise that your script and the database will be downloaded by the client if you store them in "store" folder, right?

[Honey.]

I don't have those files in the store folder.They're outside in the main directory.To Get More specific see this img:

[Honey.]

Bump!

[S.L.C]

There's an issue with your query:

Code: [Select]

CREATE TABLE IF NOT EXISTS Account ( Name TEXT, Password TEXT, IP NUMERIC, Level NUMERIC, Cash NUMERIC, Bank NUMERIC, )Can you see it?

Code: [Select]

Bank NUMERIC, )
There's a comma "," symbol that isn't supposed to be there at the end:

Code: [Select]

CREATE TABLE IF NOT EXISTS Account ( Name TEXT, Password TEXT, IP NUMERIC, Level NUMERIC, Cash NUMERIC, Bank NUMERIC )
EDIT:

But that whole query is wrong and my recommendation is to get rid or it. Try the following example and see if it works:

Code: [Select]

// General global constants
const MAX_NAME_LENGTH = 128;
const MAX_PASSWORD_LENGTH = 128;
const MAX_ADDRESS_LENGTH = 16;

// Global variable holding the database handle
local g_DB = null;

function checkDb(name)
{
// If the database file doesn't exist then try to create one
local fp = file(name, "a");
// Check if the previous action succeeded
if (fp == null)
{
print("Unable to open or create the file: " + name);
// No point in going forward
return false;
}
// Now we know the database file exists and can be opened.
else fp.close();
// Try to open the file as an SQLite database
g_DB = ConnectSQL(name);
// Check if the previous action succeeded
if (g_DB == null)
{
print("Unable to open the SQLite database: " + name);
// No point in going forward
return false;
}
else return true;
}

function onServerStart()
{
if (!checkDb("mydb.db")) return 0;

// Try to create the table
QuerySQL(g_DB, format(@"CREATE TABLE IF NOT EXISTS [Account] (
[Name] VARCHAR(%u)  NOT NULL,
[Password] VARCHAR(%u)  NOT NULL,
[IP] VARCHAR(%u)  NULL,
[Level] NUMERIC DEFAULT '0' NULL,
[Cash] NUMERIC DEFAULT '0' NULL,
[Bank] NUMERIC DEFAULT '0' NULL
);", MAX_NAME_LENGTH, MAX_PASSWORD_LENGTH, MAX_ADDRESS_LENGTH));
}

[Honey.]

Problem Solved, My DB Browser was either outdated or bugged so I installed a new and updated version of it but I still want to know how to get FPS?

[S.L.C]

There's a read only property on the player instance called "FPS". And you can see the player FPS through that variable:

Code: [Select]

function onPlayerJoin(i_player)
{
    print(i_player.FPS);
}


[Honey.]

Thanks  Topic Locked!