Raised This Month: $ Target: $400
 0% 

Frequent Fragger Program (slot reservations deluxe) Ver 4.7


Post New Thread Reply   
 
Thread Tools Display Modes
slurpycof
Senior Member
Join Date: Nov 2004
Old 08-31-2006 , 22:49   Re: Frequent Fragger Program (slot reservations deluxe) Ver 4.7
Reply With Quote #71

I have not been able to find any reason for your name problem. I have seen the lack of a name sometimes and that one has me baffled also. What other plugins are you running?
slurpycof is offline
TheRising
Member
Join Date: Mar 2005
Location: Frankfurt Germany
Old 09-25-2006 , 08:02   Re: Frequent Fragger Program (slot reservations deluxe) Ver 4.7
Reply With Quote #72

Hi,

I've kicked the same name id's from my sql database and till now it didn't happen again. Could it be caused by a big lag or the fixed SQL error in 1.76? I had sometimes a bug that freezed the server for 5-15s.

But I've seen another error. I didn't catch the error message with debug enabled right now, but till I get one I will leave debug on now.

[MySQL] Invalid DBI handle 0
[AMXX] Run time error 10 (plugin "freqfragrogv4.7.amxx") (native "dbi_query") - debug not enabled!

1 or 2 days and I can give you the debug message I think.

With best regards
TheRising
__________________

Running Plugins & Settings || Server Homepage + Customstuff || HLSW
WebSVN || Anon SVN || German Hompage Take a look at the Pluginlinklist

Last edited by TheRising; 09-25-2006 at 08:38.
TheRising is offline
Send a message via ICQ to TheRising
TheRising
Member
Join Date: Mar 2005
Location: Frankfurt Germany
Old 09-28-2006 , 20:21   Re: Frequent Fragger Program (slot reservations deluxe) Ver 4.7
Reply With Quote #73

Finally I got one

L 09/28/2006 - 06:40:50: Start of error session.
L 09/28/2006 - 06:40:50: Info (map "de_dust2") (logfile "error_092806.log")
L 09/28/2006 - 06:40:50: [MySQL] Invalid DBI handle 0
L 09/28/2006 - 06:40:50: [AMXX] Displaying debug trace (plugin "freqfragrogv4.7.amxx")
L 09/28/2006 - 06:40:50: [AMXX] Run time error 10: native error (native "dbi_query")
L 09/28/2006 - 06:40:50: [AMXX] [0] freqfragrogv4.7.sma::client_authorized (line 276)

Porting to SQLX would be fine too
__________________

Running Plugins & Settings || Server Homepage + Customstuff || HLSW
WebSVN || Anon SVN || German Hompage Take a look at the Pluginlinklist
TheRising is offline
Send a message via ICQ to TheRising
sluggo
Member
Join Date: May 2006
Old 09-29-2006 , 12:46   Re: Frequent Fragger Program (slot reservations deluxe) Ver 4.7
Reply With Quote #74

I have tried myselfe but can't get it to work.
My problem is that "addons\amxmodx\configs\sql.cfg" is used by amxbans by several servers and I want to have this, freqfragger, installed on all servers but with their own database on the local machine.
And yes I could use nvault but then it's so much harder to get it to .php or search who have the most playing time/server.

If someone could show me, or if it is added to the plugin, how to use its own sql.cfg... For example "freqfragg.cfg" maybe it could be optional, so it looks if "freqfragg.cfg" exists and if not it uses "sql.cfg".

Other than that, great plugin!
sluggo is offline
slurpycof
Senior Member
Join Date: Nov 2004
Old 10-06-2006 , 20:00   Re: Frequent Fragger Program (slot reservations deluxe) Ver 4.7
Reply With Quote #75

here you go sluggo. Replace the first part in the sma with the 2nd part. make sure you set the values in the 2nd part to your settings that you want to do. It will just be hard coded into the plugin.

Code:
#if defined USING_SQL     public sql_init() {         new host[64], username[32], password[32], dbname[32], error[256]         get_cvar_string("amx_sql_host",host,63)         get_cvar_string("amx_sql_user",username,31)         get_cvar_string("amx_sql_pass",password,31)         get_cvar_string("amx_sql_db",dbname,31)         new Sql:mysql = dbi_connect("localhost", "dvander", "pass", "dbase")         dbc = dbi_connect(host,username,password,dbname,error,255)         if (dbc == SQL_FAILED)         log_amx("[AMXX] SQL Connection Failed = %s", error)         else         {             dbi_query(dbc,"CREATE TABLE IF NOT EXISTS `freqfragger` (`lastname` VARCHAR(32) NOT NULL,`steamid` VARCHAR(32) NOT NULL,`connecttime` INT NOT NULL,`totalkills` INT NOT NULL,`totaldeaths` INT NOT NULL,`date` TIMESTAMP, PRIMARY KEY(`steamid`))")         }     } #endif

Code:
#if defined USING_SQL     public sql_init() {         dbc = dbi_connect("yourhost", "yourusername", "yourpass", "yourdbname")         if (dbc == SQL_FAILED)         log_amx("[AMXX] SQL Connection Failed")         else         {             dbi_query(dbc,"CREATE TABLE IF NOT EXISTS `freqfragger` (`lastname` VARCHAR(32) NOT NULL,`steamid` VARCHAR(32) NOT NULL,`connecttime` INT NOT NULL,`totalkills` INT NOT NULL,`totaldeaths` INT NOT NULL,`date` TIMESTAMP, PRIMARY KEY(`steamid`))")         }     } #endif
slurpycof is offline
sluggo
Member
Join Date: May 2006
Old 10-07-2006 , 07:29   Re: Frequent Fragger Program (slot reservations deluxe) Ver 4.7
Reply With Quote #76

Oooh, thank's dude
I'll try it right away, if this works i will kiss you... hmmm, maybe not but thanks :p
sluggo is offline
HuntTheShunt
Junior Member
Join Date: Oct 2005
Old 10-27-2006 , 15:16   Re: Frequent Fragger Program (slot reservations deluxe) Ver 4.7
Reply With Quote #77

How do I read freqFrag.vault files.
Is there a viewer like WinCSX?

Thanks.
HuntTheShunt is offline
qsush
Member
Join Date: Apr 2006
Location: Germany
Old 01-07-2007 , 19:28   Re: Frequent Fragger Program (slot reservations deluxe) Ver 4.7
Reply With Quote #78

i have a problem with it...

i have a 12 slot server, where 1 slot is reserved...
now when 11 people are on the server, and someone who has enough online time connects, the 11th player got kicked.
why donīt the new player can use the 12th slot, and the 11th player stay on the Server?

here are my settings:

amx_reservation "1"
amx_reservedslots "1"
amx_hidereserved "0"
amx_ffphistory "14"
amx_ffpminimum "360"
amx_ffpkdtrack "1"
amx_redirectnew "0"
amx_redirectingame "0"
amx_ffpdbmaintenance "0:0"
amx_ffpdecay "1"
__________________

qsush is offline
Send a message via ICQ to qsush Send a message via AIM to qsush Send a message via MSN to qsush Send a message via Yahoo to qsush
poncho1
Junior Member
Join Date: Dec 2004
Old 01-21-2007 , 16:35   Re: Frequent Fragger Program (slot reservations deluxe) Ver 4.7
Reply With Quote #79

need some help, i installed the plugin on game sever but its not creating the tables in the mysql db i setup for it. let me know what info u need to maybe determine what maybe the problem and ill post it.

thanks
poncho1 is offline
mats
Senior Member
Join Date: Jan 2005
Old 02-14-2007 , 10:51   Re: Frequent Fragger Program (slot reservations deluxe) Ver 4.7
Reply With Quote #80

i want to use it with nvault but when i install it on my server (and disable adminslots) de server crach everytime i change the map,
my startmap is de_dust, when ik want to change to a other map the server crach and restart on de dust again.
__________________
mats is offline
Reply



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 10:20.


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