[Video: https://www.youtube.com/watch?v=HFKHwu73fOE]

GeoLite (SQLite)



It is based on the free product GeoLite2 by MaxMind.



I was updating the country database every month for MySQL and decided to update the GeoIp databases by Whitetiger's include as many people requested. It turned out I was unable to, the way the databases were structured. I converted my version to SQLite and started comparing the two includes with geolite.inc being victorious. But this was to be expected with not only the good database structure and the use of indexes but also the appropriate queries to avoid range scans. Even though latest database provide more data than last year, it did not affect the performance in any way.



The past days, I managed to import Autonomous System (AS) and City databases with the original databases having big flows.

• Certain organizations in Autonomous System list did have many unique identifiers (ASN - Autonomous System Number) registered to IANA. All duplicates were removed and kept only their initial ASN.
  
  
• Certain ip ranges in City database:
  
  • did not provide a city name. Country name was used in replacement.
    
    
  • did not provide a city name, nor a country name. Continent name was used in replacement.
    
    
  
  

• Antarctica, Asia and Europe have time zone set as :00
  
  
• Cities with country name as replacement have central standard time set mostly, with few exceptions. Some examples are:
  
  • United States is set to have UTC -05:00 (Washington, DC) whereas Central Standard Time is in Chicago (-06:00)
    
    
  • Russia is set to Moscow Standard Time (:00)
    
    
  
  

• GetIpAutonomousSystem(const geolite_ip[], geolite_dest[], geolite_len = sizeof (geolite_dest))
  
  • Stores the Autonomous System organization (ISP is an Autonomous System) according to given IP, passed by reference.
    
    
  • Returns 1 on success (database file exists in scriptfiles folder) or 0 on failure.
    
    
  
  
• GetIpCountry(const geolite_ip[], geolite_dest[], geolite_len = sizeof (geolite_dest))
  
  • Stores the Country name according to given IP, passed by reference.
    
    
  • Returns 1 on success (database file exists in scriptfiles folder) or 0 on failure.
    
    
  
  
• GetIpCity(const geolite_ip[], geolite_dest[], geolite_len = sizeof (geolite_dest))
  
  • Stores the City name according to given IP, passed by reference.
    
    
  • Returns 1 on success (database file exists in scriptfiles folder) or 0 on failure.
    
    
  
  
• GetIpUTC(const geolite_ip[], geolite_dest[], geolite_len = sizeof (geolite_dest))
  
  • Stores the UTC offset according to given IP, passed by reference.
    
    
  • Returns 1 on success (database file exists in scriptfiles folder) or 0 on failure.
    
    
  
  
• IsIpProxy(const geolite_ip[])
  
  • Requires country database.
    
    
  • Returns 1 if the given ip is public proxy otherwise 0. It will also return 0 if database file does not exist in scriptfiles folder.
    
    
  
  

• GetPlayerAutonomousSystem(playerid, geolite_dest[], geolite_len = sizeof (geolite_dest))
  
  • Stores the Autonomous System organization (ISP is an Autonomous System) according to given player's IP, passed by reference.
    
    
  • Returns 1 on success (database file exists in scriptfiles folder and player is connected) or 0 on failure.
    
    
  
  
• GetPlayerCountry(playerid, geolite_dest[], geolite_len = sizeof (geolite_dest))
  
  • Stores the Country name according to given player's IP, passed by reference.
    
    
  • Returns 1 on success (database file exists in scriptfiles folder and player is connected) or 0 on failure.
    
    
  
  
• GetPlayerCity(playerid, geolite_dest[], geolite_len = sizeof (geolite_dest))
  
  • Stores the City name according to given player's IP, passed by reference.
    
    
  • Returns 1 on success (database file exists in scriptfiles folder and player is connected) or 0 on failure.
    
    
  
  
• GetPlayerUTC(playerid, geolite_dest[], geolite_len = sizeof (geolite_dest))
  
  • Stores the UTC offset according to given player's IP, passed by reference.
    
    
  • Returns 1 on success (database file exists in scriptfiles folder and player is connected) or 0 on failure.
    
    
  
  
• IsPlayerUsingProxy(playerid)
  
  • Requires country database.
    
    
  • Returns 1 if the ip of the given player is public proxy otherwise 0. It will also return 0 if database file does not exist in scriptfiles folder.
    
    
  
  

• MaxMind - GeoLite2
  
  
• Alex "Y_Less" Cole - sscanf
  
  
• Andy Skelton - ordering by `ip_to` (avoidance of range scan)
  
  
• Nikolay Bachiyski - ordering by `ip_to` (avoidance of range scan)
  
  
• Mark Robson - highest `ip_from` which is less than or equal to the given IP (avoidance of next country returned due to gaps)
  
  

After long time I started working with my gamemode and tried to compile my gamemode "sampctl package build".
After that it updated dependencies and indirection.inc was added, but it gives ...dependencies\indirection\indirection.inc:940 (error) undefined symbol "Indirection_OnGameModeInit".
What may cause the problem and how should it be fixed?

Disculpen, ?Alguno tiene el .zip del server 0.3.DL para windows? En la p?gina oficial de SAMP ya no existe, y la necesito, porfavor. (

Hi friends! Long-ish time, no see :(



I have terrible internet now so SA-MP is probably one of few online games I can play in the limited time I have to play games lol



I want to find a new server to play and be a part of. I'm a bit out of the loop these days, so I'm not sure what's still popular, what's still good, etc.



Please leave your suggestions below, but ONLY if they meet the criteria that I list below. This is not an opportunity to advertise servers that aren't relevant to the thread!



What I'm looking for in a server:



- Active, regular players. Server has a decent number of players online 24/7



- Main language is English, staff are fluent in English and easy to communicate with (it's fine if players speak other languages in game!)



- GOOD STAFF. I guess I'm looking for a server that isn't super strict. No power-trippy 14 year old bullshit anymore. I'm a grown-ass adult now and want to play with other grown-ass adults (maybe I'm in the wrong place? lmao)



- ACTIVE DEVELOPMENT. Dev team that actively works on improving the server, implementing suggestions and bug fixes etc.



- THINGS TO WORK TOWARDS. I like games where I can spend time grinding for results. Achievements, missions, ranks, jobs - that sort of thing. Things I can do by myself when no friends are online.



- THINGS TO DO WITH FRIENDS. I also want to be able to play with friends. Group activities etc



That's pretty much it, I think.



I enjoy things like owning houses etc but it's not a deal-breaker if the server doesn't have those features.



I've never really played RP servers but I'm willing to try low-level ones for now, if they are good.



Happy to play round-based servers like Sumo etc too.



Basically I just want to have a good time with and without friends, and be a part of a good community again :)



So show me what's out there please! ?

busco programador para un servidor samp pasarme discord y hablamos

Maaaaaaan, it will be dope if you can update a pawn script without GMX or closing and opening omp server.

Maybe u confused bout this, but basically just look at this.



[Video: https://www.youtube.com/watch?v=WzE0yqwbdgU]



Well, it's hard to explain the concepts, but the basics is same like "html live server vscode" ?when you press CTRL S, the live server host will automatically reload your html file and give you results without pressing F5 or manually opening .html file

I tried to ways, 1 was by using tool to instert link to an image and second one I dragged directly from imgur site.

Post removes image and replace it with text "undefined" or shows link to imgur instead of inserting it.