[erickvan]

Hello guys. I need to read file from .txt. In .txt i have text like "H434". I need to print that "H434" text and update mysql by that text. So i try do like that:

PHP Code:

public UpdateMysql()
{
new szQuery[3800];
new szDirectory[128];
get_configsdir( szDirectory, charsmax( szDirectory ) )
add( szDirectory, charsmax( szDirectory ), "/text.txt" )

new size = file_size( szDirectory, 1 )  

new readMatchID[28], iLen

for ( new i = 0 ; i < size ; i++ ) 
{ 
read_file( szDirectory, i, readMatchID, charsmax( readMatchID ), iLen )
}
formatex(szQuery, 3799, "UPDATE `matches` SET (`left_score` = '%s', `right_score` = '%s', `updated_at` = NOW()) WHERE (match_id = '%s');", score1, score2, readMatchID);  
SQL_ThreadQuery( g_hTuple, "QuerySetData", szQuery);
} 


Bu getting error: Run time error 3: stack error
Line error:

PHP Code:

new readMatchID[28], iLen 


Any help?

[Shadows Adi]

PHP Code:

new szQuery[3800] 


Declare this variable globally or reduce it's size if you want to use it locally.

[lexzor]

Originally Posted by Shadows Adi Declare this variable globally or reduce it's size if you want to use it locally.

Don't use a higher size than 2000.

Check my topic for more informations: https://forums.alliedmods.net/showthread.php?t=332390