[Loinal]

PHP код:

    new NumPlayers, Msg[128];
    
    mysql_query("SELECT ID FROM players");
    mysql_store_result();
    NumPlayers = mysql_num_rows();
    mysql_free_result();
    format(Msg, sizeof(Msg), "{00FF50}%s has registered at xMs {FF0000}[Total Registered Players: %i]",GetName(playerid), NumPlayers);
    SendClientMessageToAll(playerid,Msg); 


Logs:

Код:

[11:04:43] [debug] Run time error 19: "File or function is not found"
[11:04:43] [debug]  mysql_store_result
[11:04:43] [debug]  mysql_num_rows
[11:04:43] [debug]  mysql_free_result
[11:04:43] [debug] Run time error 19: "File or function is not found"
[11:04:43] [debug]  mysql_store_result
[11:04:43] [debug]  mysql_num_rows
[11:04:43] [debug]  mysql_free_result
[11:04:43] Script[gamemodes/xms.amx]: Run time error 19: "File or function is not found"
[11:04:43] Number of vehicle models: 0

[Donboo]

Check the version of your MySQL.

[Lordzy]

Your code looks like it requires older version of BlueG's MySQL plugin but I wouldn't suggest you to use that. This code is as per the latest version:

pawn Код:

new
    num_Players,
    msg_String[128],
    Cache:result
;
    result = mysql_query(connectionHandle, "SELECT COUNT(*) FROM `players`");
    //Better to count the number of rows than the number of results.
    num_Players = cache_get_value_index_int(0, 0);
    cache_delete(result);
    //format stuffs.

[Loinal]

Quote:

Originally Posted by Lordzy Your code looks like it requires older version of BlueG's MySQL plugin but I wouldn't suggest you to use that. This code is as per the latest version: pawn Код: new     num_Players,     msg_String[128],     Cache:result ;     result = mysql_query(connectionHandle, "SELECT COUNT(*) FROM `players`");     //Better to count the number of rows than the number of results.     num_Players = cache_get_value_index_int(0, 0);     cache_delete(result);     //format stuffs.

Код:

D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2232) : error 017: undefined symbol "connectionHandle"
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2232) : warning 213: tag mismatch
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2234) : error 017: undefined symbol "cache_get_value_index_int"
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2237) : error 029: invalid expression, assumed zero
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2237 -- 2238) : error 029: invalid expression, assumed zero
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2238) : warning 215: expression has no effect
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase

4 Errors.

[Yaa]

Quote:

Originally Posted by Loinal Код: D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2232) : error 017: undefined symbol "connectionHandle" D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2232) : warning 213: tag mismatch D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2234) : error 017: undefined symbol "cache_get_value_index_int" D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2237) : error 029: invalid expression, assumed zero D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2237 -- 2238) : error 029: invalid expression, assumed zero D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2238) : warning 215: expression has no effect Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 4 Errors.

use lastest version go in ****** and write ''MySQL Plugin BlueG Lastest" download it put in ur plugins blbablbblabla and recomplie ur gm

[Loinal]

Quote:

Originally Posted by Yaa use lastest version go in ****** and write ''MySQL Plugin BlueG Lastest" download it put in ur plugins blbablbblabla and recomplie ur gm

Код:

D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2232) : error 017: undefined symbol "connectionHandle"
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2232) : warning 213: tag mismatch
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2234) : warning 202: number of arguments does not match definition
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2237) : error 029: invalid expression, assumed zero
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2237 -- 2238) : error 029: invalid expression, assumed zero
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2238) : warning 215: expression has no effect
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


3 Errors.

[Loinal]

Fixed but

This

PHP код:

D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2232) : error 035: argument type mismatch (argument 1)
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2232) : warning 213: tag mismatch
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2234) : warning 202: number of arguments does not match definition
Pawn compiler 3.2.3664              Copyright (c) 1997-2006, ITB CompuPhase


1 Error. 


Lines:

Код:

    result = mysql_query(mysql, "SELECT COUNT(*) FROM `players`");

    num_Players = cache_get_value_index_int(0, 0);

[Konstantinos]

"mysql" variable should have MySQL: tag.

In R40+ the value is passed by reference:

pawn Код:

cache_get_value_int(0, 0, num_Players);

But.. what you can do is execute the query once when the server starts and assign to a global variable the number of registered users. Every time a new player registers, increase the variable and format your text.

[Loinal]

Last thing:

PHP код:

result = mysql_query(mysql, "SELECT COUNT(*) FROM `players`"); 


errors:

D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2230) : error 035: argument type mismatch (argument 1)
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(2230) : warning 213: tag mismatch
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


1 Error.

[BiosMarcel]

"result" needs to have a Cache tag and "mysql" needs the MySQL tag. Did u even read want Konstantinos wrote