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

Climb


Post New Thread Reply   
 
Thread Tools Display Modes
cameron0620
Junior Member
Join Date: Nov 2007
Old 11-09-2007 , 12:48   Re: Climb
Reply With Quote #111

recompiled with the new includes and the problem is fixed.. tested and working 100% with amxmodx 1.8 and sqlite.

only other problem i can see is that you can't read the boost help when you type /boost because you can't scroll the page in half life window
cameron0620 is offline
dekken
Veteran Member
Join Date: Jul 2007
Old 01-16-2008 , 15:21   Re: Climb
Reply With Quote #112

Huge bump..but i had to
Code:
[Climb] DB Registration Error: Please notify a server admin.
Whats the Problem?
and what DB? i dont know how to Fix this error..anyone?

Log:
L 01/16/2008 - 22:08:06: [climb.amxx] Climb: Couldn't connect to database: Can't connect to MySQL server on '127.0.0.1' (111)
L 01/16/2008 - 22:084: [climb.amxx] Climb: Couldn't connect to database: Can't connect to MySQL server on '127.0.0.1' (111)
L 01/16/2008 - 22:08:44: [climb.amxx] Climb: Couldn't connect to database: Can't connect to MySQL server on '127.0.0.1' (111)
dekken is offline
drunkenbusdriver
Member
Join Date: May 2006
Old 01-26-2008 , 15:01   Re: Climb
Reply With Quote #113

Is there a way to disable superjump and double jump? It messes with the stats.
drunkenbusdriver is offline
ian.cammarata
Member
Join Date: May 2007
Location: U.S.
Old 01-27-2008 , 03:21   Re: Climb
Reply With Quote #114

Quote:
Originally Posted by drunkenbusdriver View Post
Is there a way to disable superjump and double jump? It messes with the stats.
Read the manual.

climb_boost <1|0> : Enables|Disables boosting.
__________________
ian.cammarata is offline
Min2liz
AlliedModders Donor
Join Date: Feb 2008
Location: Street
Old 02-23-2008 , 19:21   Re: Climb
Reply With Quote #115

hi, first sorry for bad En skills
Ok, first of all, thanks for really great plugin, but I have some errors/problems with this plugin. I enable Top15 in mysql and than climber finish map script add him to mysql DB, but only 1, if other player finish map too, previous user overwrite :/ My old cvars:

Quote:
p_climb = register_cvar( "climb", "1", FCVAR_SERVER )
p_auto = register_cvar( "climb_auto", "1" )
p_boost = register_cvar( "climb_boost", "0" )
p_cpprice = register_cvar( "climb_cpprice", "0" )
p_startmoney = register_cvar( "climb_startmoney", "1337" )
register_cvar( "climb_save", "1" )
register_cvar( "climb_db_type", "mysql" )
register_cvar( "climb_db_host", "127.0.0.1" )
register_cvar( "climb_db_user", "climb" )
register_cvar( "climb_db_pass", "climb", FCVAR_PROTECTED )
register_cvar( "climb_db_name", "climb" )
register_cvar( "climb_db_prefix", "climb_" )
register_cvar( "climb_db_serverid", "" )
register_cvar( "climb_db_exists", "0" )
So, found something like 'climb_db_exists' and set to 1

So I change climb_db_exists to 1 recompile and TRUNCATE all tables. After that change map, and trying with friends, and than I climb first everything was ok, me added to DB, but than friends finish maps rewrite last who finished user, not time, nothing but only user :/ Sorry for noob questions, but who can help with this?

EDIT:

I tryed to add inserver.cfg climb_db_exists 1 and again same, me add to DB, one friend no, and another get this error:
Quote:
L 02/24/2008 - 024:52: [climb.amxx] Climb: Query failed: Duplicate entry 'STEAM_ID_LAN' for key 2

Last edited by Min2liz; 02-23-2008 at 19:38.
Min2liz is offline
ian.cammarata
Member
Join Date: May 2007
Location: U.S.
Old 02-23-2008 , 19:51   Re: Climb
Reply With Quote #116

Quote:
Originally Posted by Min2liz View Post
hi, first sorry for bad En skills
Don't worry about it, I don't mind.

Quote:
Originally Posted by Min2liz View Post
... I have some errors/problems with this plugin. I enable Top15 in mysql and than climber finish map script add him to mysql DB, but only 1, if other player finish map too, previous user overwrite :/
What version of the plugin are you using? Are you running the latest version of AMXX? And might as well let me know what version of MySQL you're using also.
__________________
ian.cammarata is offline
Min2liz
AlliedModders Donor
Join Date: Feb 2008
Location: Street
Old 02-24-2008 , 04:37   Re: Climb
Reply With Quote #117

MySQL version: 5.0.45-community-nt
Plugin really dont know what version: I found in first line under comment this: Climb v2.0a4 and in 272 line this: #define VERSION "a3.6.19 Oct 08 04:41 MST"
amxx version: 1.8.0
And I running server on Windows

EDIT:

I download Climb nightly 2a3.6.19, and same. Set these cvars:

Quote:
register_cvar( "climb_save", "1" )
register_cvar( "climb_db_type", "mysql" )
register_cvar( "climb_db_host", "localhost" )
register_cvar( "climb_db_user", "climb" )
register_cvar( "climb_db_pass", "climb", FCVAR_PROTECTED )
register_cvar( "climb_db_name", "climb" )
register_cvar( "climb_db_prefix", "climb_" )
register_cvar( "climb_db_serverid", "" )
register_cvar( "climb_db_exists", "1" )
If in Db there is no records, first record add normal, but if me try to climb map again, I get this error:

Quote:
[climb.amxx] Climb: Query failed: Duplicate entry '1-kz_jumprun' for key 2
About amxx scripting i dont know anything, but I think that yuo get/set scores by Steam ID? Then one friend finish map with Steam there was no errors and record him to DB. I dont have Steam so in steam_id me and my friends who dont have Steam write this: STEAM_ID_LAN Maybe thats why Db always rewrite.

Last edited by Min2liz; 02-24-2008 at 15:11.
Min2liz is offline
ian.cammarata
Member
Join Date: May 2007
Location: U.S.
Old 02-24-2008 , 15:14   Re: Climb
Reply With Quote #118

Hmmm... everything looks good there. I posted a newer build on the first page of this thread, load that up and see if the problem goes away.
__________________
ian.cammarata is offline
Min2liz
AlliedModders Donor
Join Date: Feb 2008
Location: Street
Old 02-24-2008 , 15:54   Re: Climb
Reply With Quote #119

Same

Quote:
[climb.amxx] Climb: Query failed: Duplicate entry 'STEAM_ID_LAN' for key 2
I execute querys from sql.txt
Quote:
drop index scores_usermap_idx on climb_scores;
update climb_scores set wpns=7 where wpns=1;
update climb_scores set wpns=0 where wpns=6;
alter table climb_scores drop column fin_cnt;
After that (I was recorded to MySQL DB previuos than finish climb) and added again me, but that friends finish map, get error that i write on top about Duplicate :/

I can give yuo ftp acc if yuo can look :/
Min2liz is offline
jee-er
New Member
Join Date: Jun 2006
Old 02-26-2008 , 09:41   Re: Climb
Reply With Quote #120

Hello ian,

When got your plugin fully working! And thats great, the only thing what isnt working is top and best. When I typ that command, it says page dont load and the server is shut down.

What to do?


edit:

I just updatred the plugin to the last version, and now I get he message:

[Climb] DB Write Error: Could not update your score. Please notify a server admin

But I got all good, and mysql @ modules is enable. Also remote sql is enable @ hosting.

edit2

We found out its saving only the first entry, and the plun does not overwrite a better time!

Last edited by jee-er; 02-26-2008 at 18:28.
jee-er 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 18:35.


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