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

Player Status in DB


Post New Thread Reply   
 
Thread Tools Display Modes
BOYSplayCS
BANNED
Join Date: Apr 2008
Location: Gainesville, FL
Old 04-21-2008 , 06:40   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #11

This plugin is good but I have experienced a personal bug, this might be client side but i'm not sure.

Once in a while at random my "kills" and "deaths" will be misspelled.

Kills will turn into klls or kils. And deaths will turn into deaaths.

I have no idea why, it does this at random. but not alot.

Good plugin otherwise. I don't expect you to fix this bug because it seems to be a personal server issue.
BOYSplayCS is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-21-2008 , 07:02   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #12

Quote:
Originally Posted by BOYSplayCS View Post
Once in a while at random my "kills" and "deaths" will be misspelled.
Is it on homepage(PHP)?
sorry i'm not sure too..
__________________
GitHub
SteamWishlist

六四天安門事件
+ARUKARI- is offline
BOYSplayCS
BANNED
Join Date: Apr 2008
Location: Gainesville, FL
Old 04-21-2008 , 07:05   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #13

It might be, not really sure.
It's all good, it's a good plugin and it rarely does the misspelling.

Nothing to worry about
BOYSplayCS is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-21-2008 , 07:12   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #14

Quote:
Originally Posted by BOYSplayCS View Post
It might be, not really sure.
It's all good, it's a good plugin and it rarely does the misspelling.

Nothing to worry about
Thank you for a rare report,and use this plugin.
__________________
GitHub
SteamWishlist

六四天安門事件
+ARUKARI- is offline
Orangutanz
Veteran Member
Join Date: Apr 2006
Old 04-21-2008 , 09:05   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #15

Approved.

Suggestion:
Remove public in front of the following functions:
sql_disconnect()
init_database()
init_insert()

public is only required when you are referencing the function from set_task/register_event etc or if its a forward prototype from an include file.
__________________
|<-- Retired from everything Small/Pawn related -->|
You know when you've been Rango'd
Orangutanz is offline
DeuX
Member
Join Date: Apr 2008
Old 04-21-2008 , 12:06   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #16

Yeees, is it all, but goes however, connection does not take place, that for a delirium?

For me stands:

AppServ 2.5.8 (Win32 Platform)

* MySQL Root Password Reset
* Apache 2.2.4
* PHP 5.2.1
* MySQL 5.0.27
* phpMyAdmin-2.9.2

Server Mod:

AmxModX 1.80...


This in sql.cfg:

amx_sql_host "127.0.0.1"
amx_sql_user "root"
amx_sql_pass "mypass"
amx_sql_db "nakenstats"

This in script:

g_dbhost = register_cvar("amx_sql_host","127.0.0.1")
g_dbuser = register_cvar("amx_sql_user","root")
g_dbpass = register_cvar("amx_sql_pass","mypass")
g_dbname = register_cvar("amx_sql_db","nakenstats")
g_tbname = register_cvar("psd_tbname","statustable")



I write tuning in the file of sql.cfg, write tuning in a script, even separately in
amxx.cfg did this tuning, goes however!
And that is yet needed?
In the script of PHP is tuning also needed?
Or I am dull, or that, explain in an example as it is necessary to be done, already
tried everything!

Whew sheet of my plugins on a server:

;;;
; To enable a module, remove the semi-colon (;) in front of its name.
; If it's not here, simply add it its name, one per line.
; You don't need to write the _amxx part or the file extension.
;;;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time. Use ;;
;; amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;

mysql
sqlite

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;
;; Put third party modules below here. ;;
;; You can just list their names, without the _amxx ;;
;; or file extension. ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;



;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;
;; These modules will be auto-detected and loaded ;;
;; as needed. You do not need to enable them here ;;
;; unless you have problems. ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;

fun
engine
fakemeta
geoip
sockets
regex
nvault
cstrike
csx

============================================= ==========

; AMX Mod X plugins

; Admin Base - Always one has to be activated
admin.amxx ; admin base (required for any admin-related)
;admin_sql.amxx ; admin base - SQL version (comment admin.amxx)

; Basic
admincmd.amxx ; basic admin console commands
adminhelp.amxx ; help command for admin console commands
adminslots.amxx ; slot reservation
multilingual.amxx ; Multi-Lingual management

; Menus
menufront.amxx ; front-end for admin menus
cmdmenu.amxx ; command menu (speech, settings)
plmenu.amxx ; players menu (kick, ban, client cmds.)
telemenu.amxx ; teleport menu (Fun Module required!)
mapsmenu.amxx ; maps menu (vote, changelevel)

; Chat / Messages
adminchat.amxx ; console chat commands
antiflood.amxx ; prevent clients from chat-flooding the server
scrollmsg.amxx ; displays a scrolling message
imessage.amxx ; displays information messages
adminvote.amxx ; vote commands

; Map related
nextmap.amxx ; displays next map in mapcycle
mapchooser.amxx ; allows to vote for next map
timeleft.amxx ; displays time left on map

; Configuration
pausecfg.amxx ; allows to pause and unpause some plugins
statscfg.amxx ; allows to manage stats plugins via menu and commands

; Counter-Strike
restmenu.amxx ; restrict weapons menu
statsx.amxx ; stats on death or round end (CSX Module required!)
miscstats.amxx ; bunch of events announcement for Counter-Strike
stats_logging.amxx ; weapons stats logging (CSX Module required!)

; Enable to use AMX Mod plugins
;amxmod_compat.amxx ; AMX Mod backwards compatibility layer

; Custom - Add 3rd party plugins here

war3ft.amxx debug
psd_002.amxx
DeuX is offline
+ARUKARI-
AlliedModders Donor
Join Date: Jul 2004
Location: Japan
Old 04-21-2008 , 12:31   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #17

try module settings

Code:
mysql //PSD,WAR3FT
;sqlite //....

fun //WAR3FT
engine //WAR3FT
fakemeta //WAR3FT
;geoip //Not use
;sockets //Not use
;regex //Not use
nvault //WAR3FT
cstrike //PSD,WAR3FT
csx  //PSD,WAR3FT
__________________
GitHub
SteamWishlist

六四天安門事件
+ARUKARI- is offline
DeuX
Member
Join Date: Apr 2008
Old 04-21-2008 , 13:07   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #18

I understand nothing, but works however!
What can a problem be in?
I already tried everything!
The update version of War3FT RC10 works even for me, AmxBans V 5.0..., and this plugin does not want, does
not connect and all!
That to do?
DeuX is offline
BOYSplayCS
BANNED
Join Date: Apr 2008
Location: Gainesville, FL
Old 04-21-2008 , 19:20   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #19

DeuX, stop typing in all bold text. It is not allowed here on the AMXx forums. Type in regular text. No caps, no bold.

Thanks.
BOYSplayCS is offline
Ambrosia
Senior Member
Join Date: Mar 2008
Old 04-21-2008 , 20:16   Re: Player Status in DB (sqlstats Lite)
Reply With Quote #20

I'm intrested in this, but have no idea where to start.

Fun 1.8.0.3660 AMX Mod X Dev Team running
CStrike 1.8.0.3660 AMX Mod X Dev Team running
CSX 1.8.0.3660 AMX Mod X Dev Team running
Ham Sandwich 1.8.0.3660 AMX Mod X Dev Team running
Engine 1.8.0.3660 AMX Mod X Dev Team running
FakeMeta 1.8.0.3660 AMX Mod X Dev Team running

http://ambrsosia-realm.net (running on InvisionFree board)

I guess i'll have to read the sql.cfg setup
This is what's in my sql.cfg file

amx_sql_host "127.0.0.1"
amx_sql_user "root"
amx_sql_pass ""
amx_sql_db "amx"
amx_sql_table "admins"
amx_sql_type "mysql"

Last edited by Ambrosia; 04-21-2008 at 20:20. Reason: more
Ambrosia is offline
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 15:38.


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