The DataBase Does Not Save ???

[ahmedzead]

Hi , My problem is the DataBase does not save any details of accounts and im already created tables Can any one Help???

[!]

Wow the same problem happens with me too and developers told me this is a built-in bug means you can't save a database since 04rel release.

Follow these steps which was given to me by Stormeus.

• Reinstall your window.
• Than install a fresh vcmp server.
• And then try to use your script again.

If these steps don't solve your problem contact me in pm.

[Mohamed Boubekri]

@zeus Hm I think the problem for Table @ahmedzead post your table here.

[Xmair]

Wow the same problem happens with me too and developers told me this is a built-in bug means you can't save a database since 04rel release.

Follow these steps which was given to me by Stormeus.

• Reinstall your window.
• Than install a fresh vcmp server.
• And then try to use your script again.

If these steps don't solve your problem contact me in pm.

then*
also you forgot the step where you smash your head into your monitor in order for the script to work

[ahmedzead]

Where is the bug in this Function

Code Select Expand

function Register( player, password, dbGlobal, time ){
  ::QuerySQL( dbGlobal, "INSERT INTO Accounts VALUES('" + player.Name + "', '" + player.Name.tolower() + "', '" + ::SHA256( password ) + "', 0, 0, 0, 0, 1, '" + player.IP + "')" );
Level = 1;
LastUsedIP = player.IP;
Logged = true;
::MessagePlayer( msg.S + "Successfully registered , Don't use this password in other servers.", player );

[!]

Where is the bug in this Code

Where is the code?

[umar4911]

Where is the bug in this Code

Code Select Expand

function Register( player, password, dbGlobal, time ){
  ::QuerySQL( dbGlobal, "INSERT INTO Accounts VALUES('" + player.Name + "', '" + player.Name.tolower() + "', '" + ::SHA256( password ) + "', 0, 0, 0, 0, 1, '" + player.IP + "')" );
Level = 1;
LastUsedIP = player.IP;
Logged = true;
::MessagePlayer( msg.S + "Successfully registered , Don't use this password in other servers.", player );

The problem is simple. The query is not complete. You send the data but in which column the data should be added.

Code Select Expand

QuerySQL(dbGlobal, "INSERT INTO Accounts (Name, LowerName, Password) VALUES ('"+player.Name+"', '"+player.Name.tolower()+"', '"+SHA256( password)+"') ");This is an example to understand

[Xmair]

Where is the bug in this Code

Code Select Expand

function Register( player, password, dbGlobal, time ){
  ::QuerySQL( dbGlobal, "INSERT INTO Accounts VALUES('" + player.Name + "', '" + player.Name.tolower() + "', '" + ::SHA256( password ) + "', 0, 0, 0, 0, 1, '" + player.IP + "')" );
Level = 1;
LastUsedIP = player.IP;
Logged = true;
::MessagePlayer( msg.S + "Successfully registered , Don't use this password in other servers.", player );

The problem is simple. The query is not complete. You send the data but in which column the data should be added.

Code Select Expand

QuerySQL(dbGlobal, "INSERT INTO Accounts (Name, LowerName, Password) VALUES ('"+player.Name+"', '"+player.Name.tolower()+"', '"+SHA256( password)+"') ");This is an example to understand

Not essential.