Search Results
Databases were updated for July 2020: https://github.com/George480/geolite/releases/tag/v21.0
Province database will be uploaded tomorrow because it takes too long.
EDIT: I was unable to get the pro...
10,931
Databases were updated for June 2020: https://github.com/George480/geolite/releases/tag/v20.0
Update geolite.inc: https://raw.githubusercontent.com/Ge...er/geolite.inc
Added new database maxmind_prov...
10,931
Was database opened correctly? You can enable:
pawn Code:
db_logging 1
option in server.cfg
907
logs\plugins for R40+ or mysql_log.txt/mysql_log.html for R33+
Note `mysql_log` should not be set to none.
2,110
Quote:
Originally Posted by TomasByoka
link dont' work
https://pastebin.com/raw/83dYkMp0
8,345
Check mysql logs. If host is Linux, table names must be exact same because it is case-sensitive.
2,110
Quote:
Originally Posted by JR_Junior
All files is on the correct place and I've tried getting info like this way too... but nothing, no errors, but no data too.
Database files in corre...
10,931
`maxmind_country.db` and `maxmind_city.db` must be located in scriptfiles folder otherwise the functions will return 0.
pawn Code:
GetPlayerCountry(playerid, PlayerInfo[playerid][GeoCountry], MAX_CO...
10,931
Code:
cache_get_field_content_int(0, registered, mysql);
pawn Code:
native cache_get_field_content_int(row, const field_name[], connectionHandle = 1);
It expects a column name to search for but `reg...
1,527
`email` is not an integer.
pawn Code:
//native cache_get_row(row, field_idx, destination[], connectionHandle = 1, max_len = sizeof(destination));cache_get_row(0, 15, PlayerInfo[playerid][Email], dbH...
602
Wrong plugin version, load the latest: https://github.com/pBlueG/SA-MP-MySQL/releases
726
Depends how you include the files, it can complain about files with same name (includes core.pwn only once and ignores other files with same name).
pawn Code:
#include "core\player/player.pwn"
Quot...
1,120
Do you sort `top_kills` array? Can you post the code?
1,394
For YSI 5:
pawn Code:
#include <YSI_Coding\y_hooks>
I use \ for path name and / for file name
pawn Code:
#include "modules\server/database.pwn"#include "modules\server/log.pwn"#include "modul...
1,120
Trying to fetch data that is not integer.
1,398
If it is not shown at all, the formatting should not be the problem. You can try set textdraw string and re-show it.
1,394
Comment the last parts you changed if you remember until it responds (will compile or show errors/warnings). Then start un-commenting parts of code until you find the source of the problem.
795
Quote:
Originally Posted by Vy
The problem is that if I connect and then someone connects, that someone doesn't show up but I do. Even if the other one is id 0 and I'm 1.
What do you me...
1,394
When you execute another query (non-threaded) inside the callback, the cache is reset. You will have to re-apply it.
pawn Code:
new rows = cache_num_rows();if(rows){ new Cache: cache_id = cache_...
1,137
Might be an issue with how you display the data? Post full mysql logs and code.
1,137