[DumB] UWC3 1.6.1-RC1 - SQL only

obe · Post by **obe** » Mon Oct 10, 2005 10:38 am

Over at the dumb community we've got 4 27 or 32 player uwc3 servers, and I've been updating uwc3 to fix some bugs, change some skills etc

The final result is:

The following changes have been made since uwc3 1.0.0-RC6j:
-----------------------------------------------------------

Added Server Max Level + Low Level Redirection system

Rewrite of the XP saving routines (SGR)

Added Psychostats support by outputting UWC3 skill deaths to the main log. All UWC3 skills have different outputs to WC3x.

Made max level 40 & Added new rank for lvl38 and above (World Destroyer)

Made Cloak of Invisibility and the Invisibility skill stack to make u more invisible (added defines for this in uwc3_defs.inc)

Reduced evasion effectiveness to a maximum of 18%

Increased the respawn protection godmode length to 4 seconds. (added defines for this in uwc3_defs.inc)

Made equipment regen/anhk no longer respawn para, as it led quickly to whole server running round with em.

Fixed Pheonix bug
Fixed Vamp Aura hp bug
Fixed Ultimate Freezetime bug
Fixed Underdog XP bug
Fixed Ability/Resist bug

Replaced Locust Swarm with Siphon Ammo
Replaced Flash of Light with Dispell Hex (works like mend/repair, has bind wcdispell)

[BETA] Added console command setskillset and included .fla/.swf for Ultimate Skillset Configurator.

Using the shockwave (drag and drop it into a web browser, or put it into a html page, and upload it to your webserver) file u can pick a skill set, and have a line of text to paste with the command. This then resets ur skills at the start of the next round, and applies the new skills. There are a lot of checks to make sure this cant be abused Smile If u cant apply the skill it tells you so, and leaves skill points to be added.

its running on amxx1.6 on all our servers, and the only problem we've noticed is that occasionally ppl get "BANNED" by amxx, yet they actually arent, and can rejoin immediately :s

this version is for sql only i'm afraid..

let me know here, or on our forums re: any bugs in the changes we've made

Our Forums

Post by **Geesu** » Mon Oct 10, 2005 10:47 am

"The selected Attachment does not exist anymore"

If you'd like to post the file I can give you access to post in releases ? Or post it here and I'll move the post.

Also, could you provide the source?

obe · Post by **obe** » Mon Oct 10, 2005 10:49 am

hehe.. its edited.. my CL said "it had no configs" to me as i was writing this post

its all good to go afaik.. unless u want the zip making to u just extract it to amxmodx folder?

Post by **Geesu** » Mon Oct 10, 2005 11:15 am

OK I edited your post and moved it, hope thats ok

redsplat · Post by **redsplat** » Fri Oct 21, 2005 8:59 am

what map should i puut uwc3 in

Post by **Geesu** » Fri Oct 21, 2005 9:12 am

?? what do u mean?

NerPissad · Post by **NerPissad** » Wed Nov 02, 2005 6:06 am

I get that i dont have garrison.spr but i downloaded it and put it in sprites.. Whats wrong? please help

upp3r · Post by **upp3r** » Wed Dec 28, 2005 3:46 am

hello there, i have a very strange problem, im using this mod, i use mysql. so when i open my game, set map and there a have it - xp:270 lvl 40?:D wtf?:D
this always happen when i change map. when i run first man there is no problem, levels are ok and so on, but just then when i change map - boom, there u have it 40 lvl, and script doesnt care how much u have xp:/

lickity · Post by **lickity** » Thu Jan 26, 2006 11:39 am

how do i go about hooking up my sql to work for this plugin?

S4in7 · Post by **S4in7** » Mon Jan 30, 2006 3:36 am

how can i convert my vault.ini into a mysql-database? or are there any plans to implement vault.ini in this release?

saintk · Post by **saintk** » Mon Jan 30, 2006 2:22 pm

Please use the documentation on the official release on how to install. No vault.ini release planned sorry, ive seen some vault to sql tools, just cant remember were sorry

Werewolf · Post by **Werewolf** » Mon Feb 06, 2006 1:59 pm

redsplat wrote:what map should i puut uwc3 in

Err... Mapp in swedish folder in english... And it is the configs folder.

TooL · Post by **TooL** » Mon Feb 06, 2006 11:26 pm

Just to throw it out there - any plans to offer a SQLite solution to this MOD anytime soon?

saintk · Post by **saintk** » Tue Feb 07, 2006 3:41 pm

Not from our side.

lickity · Post by **lickity** » Sat Feb 18, 2006 10:05 pm

what tables do i add?

lickity · Post by **lickity** » Sat Feb 18, 2006 11:16 pm

saintk wrote:Please use the documentation on the official release on how to install. No vault.ini release planned sorry, ive seen some vault to sql tools, just cant remember were sorry

cant find it on the uwc3 site now...

lickity · Post by **lickity** » Sun Feb 19, 2006 7:31 am

http://download.yousendit.com/8BE1514B65A55652
thats a temp link to the version with the /drop menu if someone can compile that and look at the lines that have errors and the 2 inc files, utilitys and skills.inc and if you could add your helm code in there geesu <3

saintk · Post by **saintk** » Mon Feb 27, 2006 5:52 am

We're releasing a new uwc3 build this week, its in full testing on our servers now.

Nothing much changed, just some minor bug fixes.
One new feature added: XP rewards can be set higher for users trough admin flags (15/30/45/60/75% extra xp earnings per xp earning event)

Post by **Marticus** » Tue Feb 28, 2006 8:17 am

I feel lost in a forest of infinite uwc3 versions.

Post by **Geesu** » Tue Feb 28, 2006 8:28 am

Marticus wrote:I feel lost in a forest of infinite uwc3 versions.

Agreed

DarkJP2 · Post by **DarkJP2** » Tue Feb 28, 2006 8:35 am

why are there that much versions anyway?
where there that much private versions that are goint to be realeased?

saintk · Post by **saintk** » Tue Feb 28, 2006 10:23 am

we just made a dumb-edit from uwc3 to adjust it to our needs. Apperantly there was alot of intrest in it, so we decided to release it to the public.

mathim · Post by **mathim** » Tue Feb 28, 2006 3:18 pm

Haha ... there are more Questions here then in the Tech support forum

csmaverick1989 · Post by **csmaverick1989** » Wed Mar 01, 2006 9:02 pm

Can u explain this in lame-mens terms i have no clue on how to put this on serevr and i cant find any documentation plz tell me!

taheri6 · Post by **taheri6** » Wed Mar 01, 2006 10:37 pm

Hi, I keep getting the following for users in my server using this release

[UWC3] Error Retrieving Your Skills SQL Data: [ Unknown column 'skill31' in 'field list'

and a lot of people do not get their xp saved on round change.

saintk · Post by **saintk** » Thu Mar 02, 2006 6:44 am

We're pushing the new release a bit ahead due to some last minute new implementations (uwc3 teambalancer, dropskill)

taheri6 · Post by **taheri6** » Sat Mar 04, 2006 6:37 pm

Ok i fixed my problem - when uwc3 plugin made the tables it created them incorrectly.

for examit SHOULD BE

CREATE TABLE `uwc3_skills2` (
`name` varchar(32) NOT NULL default '',
`steamid` varchar(32) NOT NULL default '',
`nset` tinyint(4) NOT NULL default '0',
`skill11` smallint(6) default NULL,
`skill12` smallint(6) default NULL,
`skill13` smallint(6) default NULL,
`skill14` smallint(6) default NULL,
`skill15` smallint(6) default NULL,
`skill16` smallint(6) default NULL,
`skill17` smallint(6) default NULL,
`skill18` smallint(6) default NULL,
`skill19` smallint(6) default NULL,
`skill20` smallint(6) default NULL,
PRIMARY KEY (`steamid`,`nset`)
) TYPE=MyISAM;

intead the skills were 1-10

Then , table 3 should go from 21-30 and so on - but they were all 1-10.

So I recreated the tables and restarted the server and now it saves and loads properly.

Just thought i would share in case this helps some one else.

taheri6 · Post by **taheri6** » Sat Mar 04, 2006 6:38 pm

Full code

CREATE TABLE `uwc3_skills1` (
`name` varchar(32) NOT NULL default '',
`steamid` varchar(32) NOT NULL default '',
`nset` tinyint(4) NOT NULL default '0',
`skill1` smallint(6) default NULL,
`skill2` smallint(6) default NULL,
`skill3` smallint(6) default NULL,
`skill4` smallint(6) default NULL,
`skill5` smallint(6) default NULL,
`skill6` smallint(6) default NULL,
`skill7` smallint(6) default NULL,
`skill8` smallint(6) default NULL,
`skill9` smallint(6) default NULL,
`skill10` smallint(6) default NULL,
PRIMARY KEY (`steamid`,`nset`)
) TYPE=MyISAM;

CREATE TABLE `uwc3_skills2` (
`name` varchar(32) NOT NULL default '',
`steamid` varchar(32) NOT NULL default '',
`nset` tinyint(4) NOT NULL default '0',
`skill11` smallint(6) default NULL,
`skill12` smallint(6) default NULL,
`skill13` smallint(6) default NULL,
`skill14` smallint(6) default NULL,
`skill15` smallint(6) default NULL,
`skill16` smallint(6) default NULL,
`skill17` smallint(6) default NULL,
`skill18` smallint(6) default NULL,
`skill19` smallint(6) default NULL,
`skill20` smallint(6) default NULL,
PRIMARY KEY (`steamid`,`nset`)
) TYPE=MyISAM;

CREATE TABLE `uwc3_skills3` (
`name` varchar(32) NOT NULL default '',
`steamid` varchar(32) NOT NULL default '',
`nset` tinyint(4) NOT NULL default '0',
`skill31` smallint(6) default NULL,
`skill32` smallint(6) default NULL,
`skill33` smallint(6) default NULL,
`skill34` smallint(6) default NULL,
`skill35` smallint(6) default NULL,
`skill36` smallint(6) default NULL,
`skill37` smallint(6) default NULL,
`skill38` smallint(6) default NULL,
`skill39` smallint(6) default NULL,
`skill40` smallint(6) default NULL,
PRIMARY KEY (`steamid`,`nset`)
) TYPE=MyISAM;

CREATE TABLE `uwc3_skills4` (
`name` varchar(32) NOT NULL default '',
`steamid` varchar(32) NOT NULL default '',
`nset` tinyint(4) NOT NULL default '0',
`skill41` smallint(6) default NULL,
`skill42` smallint(6) default NULL,
`skill43` smallint(6) default NULL,
`skill44` smallint(6) default NULL,
`skill45` smallint(6) default NULL,
`skill46` smallint(6) default NULL,
`skill47` smallint(6) default NULL,
`skill48` smallint(6) default NULL,
`skill49` smallint(6) default NULL,
`skill50` smallint(6) default NULL,
PRIMARY KEY (`steamid`,`nset`)
) TYPE=MyISAM;

lantz69 · Post by **lantz69** » Sun Mar 05, 2006 5:12 am

Dont the [DUMB] version only use 1 table for all data ?
I'm pretty sure that is the case.

Post by **Marticus** » Mon Mar 06, 2006 5:39 pm

egads... team balancer?!? I hope it is a separate plugin. uwc3 is bloated enough as it is.

saintk · Post by **saintk** » Tue Mar 07, 2006 2:09 am

Its not the kinda teambalancer u'd expect

And im pretty sure this aint also the team balancer u'd run on a non uwc3 server.

And besides that, we still code uwc3 for dumb servers only. We release the versions cause people seem to like it.

Rhine · Post by **Rhine** » Wed Mar 15, 2006 8:35 am

I got 2 questions.

1.Where do i put all the files?
2.Do i need warcraft tft or something for uwc3?

Rhine · Post by **Rhine** » Wed Mar 15, 2006 8:39 am

I forgot one question....

Is Sql installed on amxx 1.6?

opion · Post by **opion** » Wed Mar 15, 2006 11:10 am

No , you have to get a sql database to save it , when u're using sql

Rhine · Post by **Rhine** » Sat Mar 18, 2006 3:03 am

Where Can i get sql?

Post by **Marticus** » Sat Mar 18, 2006 9:55 am

google it, mysql is a good place to start

Post by **Marticus** » Sat Mar 18, 2006 9:55 am

Can we lock announcement threads so that people wil use the help/bug report forum?