ECD amount check

[KAKAN]

i saved ecd in database in db the ecd are updating but not in game you have to rejoin the server for updating

simply update your variable. Show me how you update it in-game. Add the same function to your Inc, Dec ECD function(s).

[Nihongo^]

i saved ecd in database in db the ecd are updating but not in game you have to rejoin the server for updating

simply update your variable. Show me how you update it in-game. Add the same function to your Inc, Dec ECD function(s).

Variable mean in database ?

btw here;'s my function that show the ECD

Code Select Expand

show <- CreateTextdraw("Vice Coins | " + GetSQLColumnData( QuerySQL( db, "SELECT VC FROM Account WHERE Name='" + player.Name + "'" ), 0 ) +  "",10,-30,Colors[ rand() % Colors.len() ]);

[KAKAN]

You manually need to delete and re-create it.

[Nihongo^]

You manually need to delete and re-create it.

recreate the table ??

[KAKAN]

You manually need to delete and re-create it.

recreate the table ??

no, the textdraw.
Here's an example:-

Code Select Expand

data <- array( 100 );
function onPlayerJoin( player ){
local ddraw = CreateTextdraw("Vice Coins | " + GetSQLColumnData( QuerySQL( db, "SELECT VC FROM Account WHERE Name='" + player.Name + "'" ), 0 ) +  "",10,-30,Colors[ rand() % Colors.len() ]);
data[ player.ID ] = ddraw; //Using arrays, you can store a lot more!
}

function IncECD( player, amount ){
//Your code.
//newecd is no of ECDs the player is having currently( increased one )
data[ player.ID ].Delete();
data[ player.ID ] = CreateTextdraw("Vice Coins | " + newecd +  "",10 ,-30,Colors[ rand() % Colors.len() ]);
}

[Nihongo^]

Thanks kakan this example help a lot
problem solved Thanks Again