Sign in to follow this  
leiizko

Release 1.2 - MySQL support is here!

Recommended Posts

This will most likely be the final release outside of bug fixes.

- Added MySQL support, all player, trueskill and mapstat data will be saved on a database. Trueskill and mapstat table name can be changed for cross server support. For advanced admins there is a "vip" and "vipexp" columns making automation of vips possible. VIP must be set to 1, vipexp is the DATETIME of vip status expiring. Once expired, VIP will automaticly change to 0 on player connection to the cod4 server.

 

- MySQL and Trueskill are now fully optional. Server will no longer crash if you don't load the plugins.

 

- Added option to disable wallbang ingame. Should do wonders to destroy campers who just shoot at walls with LMG.

 

- General bugfixes.

 

NOTE: This version requires the very latest commit on the cod4x github page. Spectating stuff in mod will not work until it is fixed in cod4x server code. It may be best for non-advanced admins to wait until stable mainstream release.

 

Available on GitHub.

  • Thanks 3

Share this post


Link to post
Share on other sites

Hi

First, thank you for the hardwork and sharing for the community,
I've been trying to make ti work since last version but it had too many bugs, every time someone was spectating and the game ended it crashed and other stuff as lag.

I've tried to fix some stuff by myself but I'm not very expert on the script and how cod4 works based on that.
Well besides that now I wanted to try this new version but as soon as I started it it crashed down for 

Error: bad token '#': (file 'maps/mp/gametypes/_globallogic.gsx', line 1174)
#if isSyscallDefined TS_Rate
*

I thought was some kinda of comment due the structure and I removed,  but then I saw it repeating many times so Don't know what is it for and how to make it work, hope you could help me.

Thank you again

Share this post


Link to post
Share on other sites

I thought  it might be related with that, though I downloaded the latest version v17.5.3
but at first run it start "to update it"  with a previous versionas I see it.


It is needed to be compiled? what is on the branch instead of the release?

Edited by Alexandraa
add question

Share this post


Link to post
Share on other sites

can someone please upload a windows version of the mysql plugin

I cannot compile it.

Edited by wkuzma

Share this post


Link to post
Share on other sites
16 minutes ago, wkuzma said:

can someone please upload a windows version of the mysql plugin

I cannot compile it.

It is already compiled check it out on the bin folder, on the git branch.

Share this post


Link to post
Share on other sites
3 hours ago, Alexandraa said:

I thought  it might be related with that, though I downloaded the latest version v17.5.3
but at first run it start "to update it"  with a previous versionas I see it.


It is needed to be compiled? what is on the branch instead of the release?

sadly a very unstable version. is crashing regularly on a well filled server. 

Share this post


Link to post
Share on other sites
6 minutes ago, dpj said:

sadly a very unstable version. is crashing regularly on a well filled server. 

Yes, finally I managed to make it work, and a simple "status" command, send a huge server side lag to all players inside.
Though new experience seems to work fine, Just noticed some lag between the final killcam and the scoreboard or the credits text

Share this post


Link to post
Share on other sites

i have a more fatal experience :) servers that regularly hit over 30 players crash about every 24 hours for me with segfaults

Share this post


Link to post
Share on other sites
5 hours ago, Alexandraa said:

It is already compiled check it out on the bin folder, on the git branch.

I missed it being named libcod4x_mysql.dll

thanks I got it now.

 

Edited by wkuzma

Share this post


Link to post
Share on other sites

how to fix it?
Error: 
******* script compile error *******
Error: bad token '#': (file 'maps/mp/gametypes/_globallogic.gsx', line 1174)
#if isSyscallDefined TS_Rate
*

Share this post


Link to post
Share on other sites
59 minutes ago, d1zzy said:

how to fix it?
Error: 
******* script compile error *******
Error: bad token '#': (file 'maps/mp/gametypes/_globallogic.gsx', line 1174)
#if isSyscallDefined TS_Rate
*

that will only work with the latest build from github master branch

Share this post


Link to post
Share on other sites
2 hours ago, dpj said:

that will only work with the latest build from github master branch

Is that going to be a part of the auto update for running servers or do we have to use the one you talk about?

also is the windows server on the main page of cod4x.me the same as the latest build from gothub?

Edited by wkuzma

Share this post


Link to post
Share on other sites
1 hour ago, wkuzma said:

Is that going to be a part of the auto update for running servers or do we have to use the one you talk about?

also is the windows server on the main page of cod4x.me the same as the latest build from gothub?

at some point it will go into the auto update, but that will take time. mind our last released version was around may.
no, the windows AND linux server download on the website are our current release version and are much older builds than there are on github

Share this post


Link to post
Share on other sites
1 minute ago, dpj said:

at some point it will go into the auto update, but that will take time. mind our last released version was around may.
no, the windows AND linux server download on the website are our current release version and are much older builds than there are on github

thanks it was very helpful

Share this post


Link to post
Share on other sites
9 hours ago, dpj said:

that will only work with the latest build from github master branch

Can you give me link for latest build?

I install this version (v17.5.3) and run server but at start autoupdating works and downloads something

Share this post


Link to post
Share on other sites

If you got 17.5 but different checksum than official build autoupdate will gonna try to get you back to the official one... So you need to put 17.6 into sources to bypass it

Share this post


Link to post
Share on other sites

If anyone is already running this I would advise you to disable mysql functionality as the plugin in current state is broken and will crash the server.

Share this post


Link to post
Share on other sites
24 minutes ago, leiizko said:

If anyone is already running this I would advise you to disable mysql functionality as the plugin in current state is broken and will crash the server.

this mod dont work sabotage )))

Share this post


Link to post
Share on other sites

Warning: Scr_AddFunction: isstring already defined
Ahhh sorry my bad)

Edited by d1zzy

Share this post


Link to post
Share on other sites
On 10/14/2017 at 7:45 PM, d1zzy said:

how to fix it?
Error: 
******* script compile error *******
Error: bad token '#': (file 'maps/mp/gametypes/_globallogic.gsx', line 1174)
#if isSyscallDefined TS_Rate
*

How do you fix this error? I also got this error with new cod4x version :(

Share this post


Link to post
Share on other sites

I dont know. All speak install the latest version of cod4x on the server and there will be no this error but it didn't help me.

And as a result I stoped to use cod4 new experience. With the cod4x latest version there was more problems:(


 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this