[Roger Devil]

Hi,
theres a new Version in my new Forum, which now is an extension of the original clanmatch-plugin. Please visit my new forum at www.siekhe-trophy.de/forum under MySQL Extension for Clanmatch-Plugin

after several weeks of development i am proud to announce the ClanMatch-Plugin with Support of MySQL.
Features :

• - Supports MySQL Database-Server V4.x
  - PHP-Scripts for administration of a complete LAN
  - Viewing Live-Status from all active Matches
  - Viewing Scores of finished matches
  - Player Scores for each Team and each Match with Kills, Deaths, HS, TK
  - All functionality from original ClanMatch-Plugin is also inculded. Means you can also use it without MySQL and PHP
  - Admins can administer the servers, all other users can view the status
  

How to setup a LAN with MySQL and PHP :

• - Add the Teams via Team-Page by specifying the full name and a short name. The shortname is displayed during the match
  - Add all maps that will be played on the lan
  - add all servers that you have. Each server gets a specific number, which is needed for finding the right matches.
  - setup the matches for your servers. The match will shown up, when the first players connect and the match is loaded
  - use cancel, force, restart to adminster the matches.
  - look at the finished matches to see the results

Misc:

• - Feel free to change the PHP-Scripts to your liking. They are kept simple, i amnot a professional Web-Designer.
  - Please leave the copyright on the pages !!!!.
  - If you have an excellent PHP-Script, please post it here.
  - Installation instructions are inside in readme.txt

As the attachment-size is limited to 1MB i have to divide it in 2 downloads.
The differences is the clanmatchplugin_s .dll / .so that's loaded by the CS-Source dedicated servers.


[Announcement]
MySQL-Support will be an extension to the existing clan-match-plugin.
The advantages are :
- Better to control for me
- Better for you, as you can downlaod the newest clan-match-plugin with the newest features.
- More fexibility and even better transparency for me as coder


[update]2005/07/04 1.0.0.27
- cvar cmp_match_recdir "" to copy the SRCTV-Demos to the directory specified
- cvar cmp_match_warmup2 "1" 0 -> Disable warmup between 1. half and 2. half
- fixed bug with match sometimes ended after 1. half
- set the messages during warmup to be more responsive
- set the warmup-timer message on a 30s base
- fixed bug with admin.txt not allowing comment in the same line : STEAM_0:0:1223 // Player 1
- fixed cmp_match_pause and /pause not working
- new say-command /status to show the current status of the match
changed files :
clanmatchplgin_s.dll
clanmatchplugin_s_i486.so
settings.cfg
readme.txt


update 2005/10/16 1.0.0.26b
- fixed inactive or kniferound not shown on web-page
- fixed crash which could appear after starting a match
- add say command /status to show the current status of a match
changed files :
clanmatchplgin_s.dll
clanmatchplugin_s_i486.so

update 2005/10/06 1.0.0.26a
- Fixed crash in dedicated server
- Updated rdevil.css not containing all styles
- Updated index.html changed home.html to home.php
If you already downloaded 1.0.0.26 , you only have to extract the following files :

• phpCMP/include/funtions.inc.php
  phpCMP/home.php
  phpCMP/rdevil.css
  phpCMP/index.html

And make sure table cmp_rcon is empty or run install.php again

[imported_Redmist]

The index.html should contain 'home.php' instead of 'home.html'

[Roger Devil]

Originally Posted by Redmist The index.html should contain 'home.php' instead of 'home.html'

You are right, and i also forgot to insert the corrected stylesheet.
Here it is :

[imported_Redmist]

OK, the username & dbname are the wrong way around in the MySQL.txt file.

Also when creating a match, SRCDS.EXE crashes with the following.

EVERYONE CAN BUY!
Master server communication disabled.
Missing shutdown function for Sys_InitAuthentication() : Sys_ShutdownAuthenticat
ion()
Missing shutdown function for Decal_Init() : Decal_Shutdown()
Missing shutdown function for InitStudioRender() : ShutdownStudioRender()
Missing shutdown function for StaticPropMgr()->Init() : StaticPropMgr()->Shutdow
n()
Missing shutdown function for modelloader->Init() : modelloader->Shutdown()
Missing shutdown function for InitMaterialSystem() : ShutdownMaterialSystem()
Missing shutdown function for hltv.Init( bDedicated ) : hltv.Shutdown()
Missing shutdown function for g_Log.Init() : g_Log.Shutdown()
Missing shutdown function for master->Init( &sv ) : master->Shutdown()
Missing shutdown function for sv.Init( bDedicated ) : sv.Shutdown()
Missing shutdown function for g_GameEventManager.Init() : g_GameEventManager.Shu
tdown()
Missing shutdown function for NET_Init( bDedicated ) : NET_Shutdown()
Missing shutdown function for Key_Init() : Key_Shutdown()
Missing shutdown function for Filter_Init() : Filter_Shutdown()
Missing shutdown function for saverestore->Init() : saverestore->Shutdown()
Missing shutdown function for COM_Init() : COM_Shutdown()
Missing shutdown function for V_Init() : V_Shutdown()
Missing shutdown function for cv->Init() : cv->Shutdown()
Missing shutdown function for Cmd_Init() : Cmd_Shutdown()
Missing shutdown function for Cbuf_Init() : Cbuf_Shutdown()
Missing shutdown function for Con_Init() : Con_Shutdown()
Missing shutdown function for Memory_Init() : Memory_Shutdown()
Missing shutdown function for Host_Init( s_bIsDedicated ) : Host_Shutdown()
Missing shutdown function for Sys_LoadPhysicsDLL() : Sys_UnloadPhysicsDLL()
Missing shutdown function for Sys_InitMemory() : Sys_ShutdownMemory()
Missing shutdown function for Sys_Init() : Sys_Shutdown()
Missing shutdown function for LoadMaterialSystemInterface() : UnloadMaterialSyst
emInterface()
Missing shutdown function for Shader_InitDedicated() : Shader_Shutdown()
Missing shutdown function for COM_InitFilesystem() : COM_ShutdownFileSystem()
Missing shutdown function for FileSystem_Init(g_AppSystemFactory) : FileSystem_S
hutdown()

[Roger Devil]

Can you tell me what Operating-System you use, i gues linux ???
Im currently installing all stuff under Fedora and will test it also under linux.

[imported_Redmist]

I am using WinXP - Running EasyPHP 1.7 which is sort of an all in one Apache 1.3, MySQL 4, php 4 package. SRC DS is running on the same PC for testing.

[Roger Devil]

Found the bug, please try the new version and thanks for your help.

Small issue found myself: To get the match active and displayed on main-page players must join. Negative Sideeffect is also, that the servername did not change, as the match is not loaded.
Will change this soon...

[imported_Redmist]

OK, the server isn't crashing now but the warmup doesn't seem to be starting. If I start a match from the web page and then go into the server, there's no warmup in progress. i.e. if I type 'ready' nothing happens but if I type cmp_match in the server console it says 'Match already in progress' It still shows 'no match' on the web page though...

[Roger Devil]

You're right, another problem, has something to do with that small issue i found.
Will fix this as soon as possible.
What will work is, if you create a match and players are already connected, the match should be correctly loaded.

[Roger Devil]

Originally Posted by Redmist OK, the server isn't crashing now but the warmup doesn't seem to be starting. If I start a match from the web page and then go into the server, there's no warmup in progress. i.e. if I type 'ready' nothing happens but if I type cmp_match in the server console it says 'Match already in progress' It still shows 'no match' on the web page though...

I tested the scenario again, now i must say you're wrong.
All works fine, the warmup will start when players are connected for both sides.
If you are alone on your server nothing will happen, thats right.
I only would suggest to give a message to the players, that the match is inactive and is waiting for both teams to join.