[jonatat]

Hello guys. Im tryingo todo to read .txt file in anywhere. My code:

PHP Code:

stock GetMatchID()
{
new fp = fopen("addons/amxmodx/configs/gunid.txt"), gettheid[100];
while (!foef(fp));
{
new showmatchid = fgets(fp, gettheid, charsmax(gettheid);
return gettheid;
}
fclose(fp)
} 


But getting error then compiling. Why i'm using stock? I want to show the ID anywhere where i put %s. Example:

PHP Code:

client_printcolor(0, "Gun ID is now: %s", GetMatchID) 


[jonatat]

Ok so i figgured out:

PHP Code:

stock GetMatchID()
{
new szDirectory[ 128 ];
get_configsdir( szDirectory, charsmax( szDirectory ) );
add( szDirectory, charsmax( szDirectory ), "/gameid.txt" );

new size = file_size( szDirectory, 1 ) 

new szLine[ 128 ], iLen;

for ( new i = 0 ; i < size ; i++ )
{
read_file( szDirectory, i, szLine, charsmax( szLine ), iLen );
}
return szLine
} 


But now, i want to insert into database like that:

PHP Code:

public StartGameLIVE()
{
new szQuery[3800];
new map_name[64];

get_mapname(map_name, 63)

formatex(szQuery, 3799, "INSERT INTO `matches` (`match_id`, `map`, `played_at`, `left_score`, `right_score`, `state`, `server`, `left_team_id`, `right_team_id`, `game_id` ) VALUES ( '%s', '%s', NOW(), '0', '0', '0', '85.566.954.58', '1', '1', '3' );", GetMatchID(), map_name); 
SQL_ThreadQuery( g_hTuple, "QuerySetData", szQuery);

return PLUGIN_CONTINUE;
} 


But getting error on that SQL line. Any ideas?

[jimaway]

Originally Posted by jonatat But now, i want to insert into database like that: PHP Code: formatex(szQuery, 3799, "INSERT INTO `matches` ...... %s', '%s', .......' );", GetMatchID(), map_name);  But getting error on that SQL line. Any ideas?

formatex() is expecting a string but GetMatchID() returns an integer

Originally Posted by jonatat But getting error then compiling. Why i'm using stock? I want to show the ID anywhere where i put %s. Example: PHP Code: client_printcolor(0, "Gun ID is now: %s", GetMatchID)

you should store the file contents if you're using it a lot. reading the file to get the same value over and over again is a bad idea

[fysiks]

You should avoid using read_file() as it is not recommended. Also, you should generally never return a string from a function.

What exactly is this data from the file you're trying to read and what does the file look like? I don't think your code is working the way you think it is.

Also, for reading the lines of a file correctly, you should do this:

PHP Code:

new f, szBuffer[100]

f = fopen("file.txt", "rt")

if( f )
{
    while( fgets(f, szBuffer, charsmax(szBuffer)) )
    {
        trim(szBuffer)

        // szBuffer now contains the contents of one
        // line of the file without the newline or
        // carriage return.
    }
    fclose(f)
} 


If you only need to read the first line then you can simply omit the while loop entirely and just call fgets() once.