AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Approved Plugins (https://forums.alliedmods.net/forumdisplay.php?f=8)
-   -   Climb (https://forums.alliedmods.net/showthread.php?t=56826)

buzzumfrog 08-02-2007 18:28

Re: Climb
 
Oh I'm sorry. I thought this was Allied Toddlers. I was looking for a famous Cammarata toddler rub down.

masa 08-08-2007 17:30

Re: Climb
 
Hello Climbers ^^

I have a lil problem. with this plugin!
The sql connection doesnt work!

The seetings on the server ar correct! ( can connect whit the same settings from console to the db)
There still the same lines in the console
Code:

L 08/08/2007 - 23:05:12: [climb.amxx] Climb: Couldn't connect to database.
L 08/08/2007 - 23:05:12: [climb.amxx] Climb: Couldn't connect to database.
L 08/08/2007 - 23:05:12: [climb.amxx] Climb: Couldn't connect to database.
L 08/08/2007 - 23:05:12: [climb.amxx] Climb: Couldn't connect to database.

I get no output if the plugin is running in degugMode???
/cstrike/addons/amxmodx/logs is empty
Code:

Currently loaded plugins:
      name                    version  author            file            status
 [  1] AmxBans Admin Base      1.76d    AMXX Dev Team    admin_amxbans.a  running
 [  2] AMXBans                5.0      YoMama/Lux & lan  amxbans.amxx    running
 [  3] Admin Commands          1.76d    AMXX Dev Team    admincmd.amxx    running
 [  4] Slots Reservation      1.76d    AMXX Dev Team    adminslots.amxx  running
 [  5] Multi-Lingual System    1.76d    AMXX Dev Team    multilingual.am  running
 [  6] Menus Front-End        1.76d    AMXX Dev Team    menufront.amxx  running
 [  7] Players Menu            1.76d    AMXX Dev Team    plmenu.amxx      running
 [  8] Maps Menu              1.76d    AMXX Dev Team    mapsmenu.amxx    running
 [  9] Admin Chat              1.76d    AMXX Dev Team    adminchat.amxx  running
 [ 10] Anti Flood              1.76d    AMXX Dev Team    antiflood.amxx  running
 [ 11] Scrolling Message      1.76d    AMXX Dev Team    scrollmsg.amxx  running
 [ 12] Admin Votes            1.76d    AMXX Dev Team    adminvote.amxx  running
 [ 13] NextMap                1.76d    AMXX Dev Team    nextmap.amxx    running
 [ 14] Nextmap Chooser        1.76d    AMXX Dev Team    mapchooser.amxx  running
 [ 15] TimeLeft                1.76d    AMXX Dev Team    timeleft.amxx    running
 [ 16] Climb                  a3.4.16  Ian Cammarata    climb.amxx      debug

The last version 2.0a3.4.16 didnt solved the problem. ( version 2_0_a3 is the same)

the CS-Server has a connection to the DB (sql.cfg, amxbans it works!)
this c-vars are in the server.cfg
Code:


climb 1
climb_save 1
climb_boost 1
climb_start_respawn 1
climb_db_host localhost # climb_db_host 127.0.0.1 # the same!
climb_db_type mysql
climb_db_user USER
climb_db_pass userPW
climb_db_name dbName
climb_webmod 0
climb_stats_path "addons/amxmodx/configs/commands/html"
climb_stats_url "http://xxxxxx"

more info
Code:

meta list
Currently loaded plugins:
      description      stat pend  file              vers      src  load  unlod
 [ 1] AMX Mod X        RUN  -    amxmodx_mm_i386.  v1.76d    ini  ANY  ANY
 [ 2] MySQL            RUN  -    mysql_amxx_i386.  v1.76b    pl1  ANY  ANY
 [ 3] CStrike          RUN  -    cstrike_amxx_i38  v1.76    pl1  ANY  ANY
 [ 4] Fun              RUN  -    fun_amxx_i386.so  v1.76    pl1  ANY  ANY
 [ 5] Engine          RUN  -    engine_amxx_i386  v1.76    pl1  ANY  ANY
 [ 6] FakeMeta        RUN  -    fakemeta_amxx_i3  v1.76d    pl1  ANY  ANY
6 plugins, 6 running

I dont understand it, if i change the logindata to the same like the amxbans it doesnt work to, but amxbans get the connection why ???

pls help

masa 08-08-2007 17:37

Re: Climb
 
maybe the mysql.sock problem ???

But the plugin is using mysql_amx, and it works for other plugins!

Im confused :-(

ian.cammarata 08-08-2007 20:06

Re: Climb
 
Quote:

Originally Posted by masa (Post 514713)
I have a lil problem. with this plugin!
The sql connection doesnt work!

The seetings on the server ar correct! ( can connect whit the same settings from console to the db)
There still the same lines in the console
Code:

L 08/08/2007 - 23:05:12: [climb.amxx] Climb: Couldn't connect to database.
L 08/08/2007 - 23:05:12: [climb.amxx] Climb: Couldn't connect to database.
L 08/08/2007 - 23:05:12: [climb.amxx] Climb: Couldn't connect to database.
L 08/08/2007 - 23:05:12: [climb.amxx] Climb: Couldn't connect to database.

I get no output if the plugin is running in degugMode???
/cstrike/addons/amxmodx/logs is empty

The only thing I can think of off the top of my head is to check and see if the the Schema (Database / table container) with the name dbName has been created, because the plugin doesn't actually do that itself.

lassiter 08-08-2007 23:13

Re: Climb
 
I get this when I finish the map.
[Climb] DB Registration Error: Please notify a server admin.

when I type register it says unknown command.
I am still working on the db.

also what does sct in the scoreboard stand for?

ian.cammarata 08-09-2007 01:44

Re: Climb
 
Quote:

Originally Posted by lassiter (Post 514990)
I get this when I finish the map.
[Climb] DB Registration Error: Please notify a server admin.

when I type register it says unknown command.
I am still working on the db.

also what does sct in the scoreboard stand for?

sct is scout, means they used it while their timer was running.

If you're using the nightly build on my site, the registration commands are disabled. Also if you are using a database from the 2.0a3 release, the registration bug in that version can screw up the database and keep registration from working with the nightly build. Try clearing all the records in the users table that have a password value of 'shared', and if that doesn't work, you might need to truncate the whole database for it to function correctly again.

If you're using SQLite you can modify your database with this utility:
http://sourceforge.net/projects/sqlitebrowser/

masa 08-09-2007 10:31

Re: Climb
 
Quote:

Originally Posted by ian.cammarata (Post 514851)
The only thing I can think of off the top of my head is to check and see if the the Schema (Database / table container) with the name dbName has been created, because the plugin doesn't actually do that itself.

Its real mystical, yesterday the db was empty no tables inside!
But today i checked the db and the db-tables are there, and it seems to work.
The plugin created them!

I finished a map the stats were stored!

After server restart no connection to the db?

any idea?

masa 08-09-2007 10:53

Re: Climb
 
the plugin itself created this tables in the db:

Code:

CREATE TABLE `climb_players` (
  `user_id` int(11) NOT NULL auto_increment,
  `steam_id` char(25) default NULL,
  `password` char(6) default NULL,
  `user_name` varchar(20) default NULL,
  `alias` varchar(32) default NULL,
  `email` varchar(50) default NULL,
  `cflags` int(11) default NULL,
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `steam_id` (`steam_id`),
  UNIQUE KEY `user_name` (`user_name`),
  UNIQUE KEY `alias` (`alias`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `climb_scores`
--

CREATE TABLE `climb_scores` (
  `score_id` int(11) NOT NULL auto_increment,
  `score` int(11) default NULL,
  `server_ip` char(15) default NULL,
  `user_id` int(11) default NULL,
  `map_name` varchar(32) default NULL,
  `fin_time` int(11) default NULL,
  `cps` int(11) default NULL,
  `gcs` int(11) default NULL,
  `fin_cnt` int(11) default NULL,
  `boosts` int(11) default NULL,
  `wpns` int(11) default NULL,
  `server_time_stamp` int(11) default NULL,
  PRIMARY KEY  (`score_id`),
  UNIQUE KEY `scores_usermap_idx` (`user_id`,`map_name`),
  KEY `scores_score` (`score`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `climb_sessions`
--

CREATE TABLE `climb_sessions` (
  `steam_id` char(25) NOT NULL,
  `user_id` int(11) default NULL,
  PRIMARY KEY  (`steam_id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


ColdBlood 08-09-2007 13:21

Re: Climb
 
hey idk what the problem is but. when more then one person joins the server it says
"too many cts"
and only allows 1 person to join the game and play

masa 08-09-2007 13:41

Re: Climb
 
Quote:

Originally Posted by ColdBlood (Post 515329)
hey idk what the problem is but. when more then one person joins the server it says
"too many cts"
and only allows 1 person to join the game and play

try disable "mp_autoteambalance"
put this in your server.cfg At the end
Code:

mp_autoteambalance 0


All times are GMT -4. The time now is 09:37.

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