Raised This Month: $12 Target: $400
 3% 

Player Status in DB


Post New Thread Reply   
 
Thread Tools Display Modes
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 01-31-2021 , 20:25   Re: Player Status in DB
Reply With Quote #131

Updated:
2021.02.01. v1.10
  • Added: amx_psd_serverid
  • Added: database cvars (amx_psd_sql_host/user/pass/db)
  • Modify: Insert Query has Threaded.
  • Fixed: player name escape.
__________________
GitHub
SteamWishlist

六四天安門事件

Last edited by +ARUKARI-; 01-31-2021 at 20:26.
+ARUKARI- is offline
.ajax.
New Member
Join Date: May 2021
Old 05-05-2021 , 16:25   Re: Player Status in DB
Reply With Quote #132

Hello Guys, I'm a beginner in programming and I developed a solution from this incredible SMA developed by + ARUKARI-.

I made the return within the counter strike using php and the motd system by player auth_id.

So I got the result of a "statistics plugin".

The image is posted below, if anyone is interested let me know.

(for now the background image is ugly and poorly edited, but that will be changed).

.ajax. is offline
theuser
Member
Join Date: Jul 2020
Old 07-30-2021 , 13:55   Re: Player Status in DB
Reply With Quote #133

Plugin uses an unknown function (name "geoip_code2_ex") - check your modules.ini.

The plugin is compiled but gives this error when the server is run
theuser is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 07-31-2021 , 06:38   Re: Player Status in DB
Reply With Quote #134

Quote:
Originally Posted by theuser View Post
Plugin uses an unknown function (name "geoip_code2_ex") - check your modules.ini.

The plugin is compiled but gives this error when the server is run
Check amxx module.
Isn't the GeoIP module "bad load"?
__________________
GitHub
SteamWishlist

六四天安門事件
+ARUKARI- is offline
amirwolf
Senior Member
Join Date: Feb 2019
Location: Iran
Old 08-02-2021 , 15:52   Re: Player Status in DB
Reply With Quote #135

Hi, I have this error
PHP Code:
L 08/03/2021 00:14:39: [AMXXPlugin "psd.amxx" failed to loadPlugin uses an unknown function (name "geoip_code2_ex") - check your modules.ini
HTML Code:
] amxx modules
Currently loaded modules:
      name                    version     author               status     
 [ 1] MySQL                   1.9.0.5281  AMX Mod X Dev Team   running    
 [ 2] Fun                     1.9.0.5281  AMX Mod X Dev Team   running    
 [ 3] Engine                  1.9.0.5281  AMX Mod X Dev Team   running    
 [ 4] FakeMeta                1.9.0.5281  AMX Mod X Dev Team   running    
 [ 5] GeoIP                   1.9.0.5281  AMX Mod X Dev Team   running    
 [ 6] CStrike                 1.9.0.5281  AMX Mod X Dev Team   running    
 [ 7] CSX                     1.9.0.5281  AMX Mod X Dev Team   running    
 [ 8] Ham Sandwich            1.9.0.5281  AMX Mod X Dev Team   running    
 [ 9] Sockets                 1.9.0.5281  AMX Mod X Dev Team   running    
9 modules, 9 correct

] meta list
Currently loaded plugins:
      description      stat pend  file              vers      src  load  unlod
 [ 1] AMX Mod X        RUN   -    amxmodx_mm.dll    v1.9.0.5  ini  Start ANY  
 [ 2] MySQL            RUN   -    mysql_amxx.dll    v1.9.0.5  pl1  ANY   ANY  
 [ 3] Fun              RUN   -    fun_amxx.dll      v1.9.0.5  pl1  ANY   ANY  
 [ 4] Engine           RUN   -    engine_amxx.dll   v1.9.0.5  pl1  ANY   ANY  
 [ 5] FakeMeta         RUN   -    fakemeta_amxx.dl  v1.9.0.5  pl1  ANY   ANY  
 [ 6] GeoIP            RUN   -    geoip_amxx.dll    v1.9.0.5  pl1  ANY   ANY  
 [ 7] CStrike          RUN   -    cstrike_amxx.dll  v1.9.0.5  pl1  ANY   ANY  
 [ 8] CSX              RUN   -    csx_amxx.dll      v1.9.0.5  pl1  ANY   ANY  
 [ 9] Ham Sandwich     RUN   -    hamsandwich_amxx  v1.9.0.5  pl1  ANY   ANY  
9 plugins, 9 running

] amxx plugins
Currently loaded plugins:
       name                    version     author            file             status   
 [  1] Admin Base              1.9.0.5281  AMXX Dev Team     admin.amxx       running  
 [  2] Admin Commands          1.9.0.5281  AMXX Dev Team     admincmd.amxx    running  
 [  3] Admin Help              1.9.0.5281  AMXX Dev Team     adminhelp.amxx   running  
 [  4] Slots Reservation       1.9.0.5281  AMXX Dev Team     adminslots.amxx  running  
 [  5] Multi-Lingual System    1.9.0.5281  AMXX Dev Team     multilingual.am  running  
 [  6] Menus Front-End         1.9.0.5281  AMXX Dev Team     menufront.amxx   running  
 [  7] Commands Menu           1.9.0.5281  AMXX Dev Team     cmdmenu.amxx     running  
 [  8] Players Menu            1.9.0.5281  AMXX Dev Team     plmenu.amxx      running  
 [  9] Maps Menu               1.9.0.5281  AMXX Dev Team     mapsmenu.amxx    running  
 [ 10] Plugin Menu             1.9.0.5281  AMXX Dev Team     pluginmenu.amxx  running  
 [ 11] Admin Chat              1.9.0.5281  AMXX Dev Team     adminchat.amxx   running  
 [ 12] Anti Flood              1.9.0.5281  AMXX Dev Team     antiflood.amxx   running  
 [ 13] Scrolling Message       1.9.0.5281  AMXX Dev Team     scrollmsg.amxx   running  
 [ 14] Info. Messages          1.9.0.5281  AMXX Dev Team     imessage.amxx    running  
 [ 15] Admin Votes             1.9.0.5281  AMXX Dev Team     adminvote.amxx   running  
 [ 16] NextMap                 1.9.0.5281  AMXX Dev Team     nextmap.amxx     running  
 [ 17] Nextmap Chooser         1.9.0.5281  AMXX Dev Team     mapchooser.amxx  running  
 [ 18] TimeLeft                1.9.0.5281  AMXX Dev Team     timeleft.amxx    running  
 [ 19] Pause Plugins           1.9.0.5281  AMXX Dev Team     pausecfg.amxx    running  
 [ 20] Stats Configuration     1.9.0.5281  AMXX Dev Team     statscfg.amxx    running  
 [ 21] StatsX                  1.9.0.5281  AMXX Dev Team     statsx.amxx      running  
 [ 22] unknown                 unknown     unknown           psd.amxx         bad load 
( 22) Load fails: Plugin uses an unknown function (name "geoip_code2_ex") - check your modules.ini
22 plugins, 21 running
I do not know what the problem is
__________________

Last edited by amirwolf; 08-02-2021 at 15:57.
amirwolf is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 08-02-2021 , 20:11   Re: Player Status in DB
Reply With Quote #136

Make sure that GeoLite-2-Country.mmdb exists in amxmodx/data and that it is readable.
__________________
GitHub
SteamWishlist

六四天安門事件
+ARUKARI- is offline
amirwolf
Senior Member
Join Date: Feb 2019
Location: Iran
Old 08-03-2021 , 14:17   Re: Player Status in DB
Reply With Quote #137

Quote:
Originally Posted by +ARUKARI- View Post
Make sure that GeoLite-2-Country.mmdb exists in amxmodx/data and that it is readable.
Thank you, the error was fixed
I have a php error now
HTML Code:
Fatal error: Uncaught InvalidArgumentException: The file "/usr/local/share/GeoIP/GeoLite2-City.mmdb" does not exist or is not readable. in C:\xampp\htdocs\csx_stats\vendor\maxmind-db\reader\src\MaxMind\Db\Reader.php:83 Stack trace: #0 C:\xampp\htdocs\csx_stats\vendor\geoip2\geoip2\src\Database\Reader.php(56): MaxMind\Db\Reader->__construct('/usr/local/shar...') #1 C:\xampp\htdocs\csx_stats\includes\page_main.inc(83): GeoIp2\Database\Reader->__construct('/usr/local/shar...') #2 C:\xampp\htdocs\csx_stats\index.php(9): PageMain->__construct() #3 C:\xampp\htdocs\csx_stats\index.php(64): Index->__construct() #4 {main} thrown in C:\xampp\htdocs\csx_stats\vendor\maxmind-db\reader\src\MaxMind\Db\Reader.php on line 83
__________________
amirwolf is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 08-03-2021 , 20:17   Re: Player Status in DB
Reply With Quote #138

https://github.com/AoiKagase/Amxx-PS...e_main.inc#L83
Rewrite the path here. ([your directory]/cstrike/addons/amxmodx/data/GeoLite2-City.mmdb)

GeoLite-2-*.mmdb needs to be kept up to date.
If you are using Linux, use the "geoipupdate" command.
This is usually stored in "/usr/local/share/GeoIP/GeoLite-2-*.mmdb", so you can use the
It is recommended to synchronize the files by putting a symbolic link to "amxmodx/data/".
__________________
GitHub
SteamWishlist

六四天安門事件
+ARUKARI- is offline
amirwolf
Senior Member
Join Date: Feb 2019
Location: Iran
Old 08-04-2021 , 02:48   Re: Player Status in DB
Reply With Quote #139

Quote:
Originally Posted by +ARUKARI- View Post
https://github.com/AoiKagase/Amxx-PS...e_main.inc#L83
Rewrite the path here. ([your directory]/cstrike/addons/amxmodx/data/GeoLite2-City.mmdb)

GeoLite-2-*.mmdb needs to be kept up to date.
If you are using Linux, use the "geoipupdate" command.
This is usually stored in "/usr/local/share/GeoIP/GeoLite-2-*.mmdb", so you can use the
It is recommended to synchronize the files by putting a symbolic link to "amxmodx/data/".
The problem was solved, thank you
__________________
amirwolf is offline
Natsheh
Veteran Member
Join Date: Sep 2012
Old 08-26-2021 , 10:26   Re: Player Status in DB
Reply With Quote #140

Caution the plugin is not immuned against MySql Injections attacks, you better add this protection against client names.
__________________
@Jailbreak Main Mod v2.7.0 100%
@User Tag Prefix 100% done !
@Mystery Box 100% done !
@VIP System 100% done !

Natsheh is offline
Send a message via MSN to Natsheh Send a message via Skype™ to Natsheh
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:51.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode