Page 1 of 1

[DumB] UWC3 1.6.1-RC1 - SQL only

Posted: Mon Oct 10, 2005 10:38 am
by obe
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

Posted: Mon Oct 10, 2005 10:47 am
by Geesu
"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?

Posted: Mon Oct 10, 2005 10:49 am
by obe
hehe.. its edited.. my CL said "it had no configs" to me as i was writing this post :D

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

Posted: Mon Oct 10, 2005 11:15 am
by Geesu
OK I edited your post and moved it, hope thats ok

Posted: Fri Oct 21, 2005 8:59 am
by redsplat
what map should i puut uwc3 in :?: :?

Posted: Fri Oct 21, 2005 9:12 am
by Geesu
?? what do u mean?

Posted: Wed Nov 02, 2005 6:06 am
by NerPissad
I get that i dont have garrison.spr but i downloaded it and put it in sprites.. Whats wrong? please help

Posted: Wed Dec 28, 2005 3:46 am
by upp3r
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:/

Posted: Thu Jan 26, 2006 11:39 am
by lickity
how do i go about hooking up my sql to work for this plugin?

Posted: Mon Jan 30, 2006 3:36 am
by S4in7
how can i convert my vault.ini into a mysql-database? or are there any plans to implement vault.ini in this release?

Posted: Mon Jan 30, 2006 2:22 pm
by saintk
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

Posted: Mon Feb 06, 2006 1:59 pm
by Werewolf
redsplat wrote:what map should i puut uwc3 in :?: :?
Err... Mapp in swedish folder in english... And it is the configs folder.

Posted: Mon Feb 06, 2006 11:26 pm
by TooL
Just to throw it out there - any plans to offer a SQLite solution to this MOD anytime soon?

Posted: Tue Feb 07, 2006 3:41 pm
by saintk
Not from our side.

Posted: Sat Feb 18, 2006 10:05 pm
by lickity
what tables do i add?

Posted: Sat Feb 18, 2006 11:16 pm
by lickity
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...

Posted: Sun Feb 19, 2006 7:31 am
by lickity
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

Posted: Mon Feb 27, 2006 5:52 am
by saintk
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)

Posted: Tue Feb 28, 2006 8:17 am
by Marticus
I feel lost in a forest of infinite uwc3 versions.

Posted: Tue Feb 28, 2006 8:28 am
by Geesu
Marticus wrote:I feel lost in a forest of infinite uwc3 versions.
Agreed

Posted: Tue Feb 28, 2006 8:35 am
by DarkJP2
why are there that much versions anyway?
where there that much private versions that are goint to be realeased?

Posted: Tue Feb 28, 2006 10:23 am
by saintk
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.

Posted: Tue Feb 28, 2006 3:18 pm
by mathim
Haha ... there are more Questions here then in the Tech support forum :D

Posted: Wed Mar 01, 2006 9:02 pm
by csmaverick1989
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!

Posted: Wed Mar 01, 2006 10:37 pm
by taheri6
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.

Posted: Thu Mar 02, 2006 6:44 am
by saintk
We're pushing the new release a bit ahead due to some last minute new implementations (uwc3 teambalancer, dropskill)

Posted: Sat Mar 04, 2006 6:37 pm
by taheri6
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.

Posted: Sat Mar 04, 2006 6:38 pm
by taheri6
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;

Posted: Sun Mar 05, 2006 5:12 am
by lantz69
Dont the [DUMB] version only use 1 table for all data ?
I'm pretty sure that is the case.

Posted: Mon Mar 06, 2006 5:39 pm
by Marticus
egads... team balancer?!? I hope it is a separate plugin. uwc3 is bloated enough as it is.

Posted: Tue Mar 07, 2006 2:09 am
by saintk
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.

Posted: Wed Mar 15, 2006 8:35 am
by Rhine
I got 2 questions.

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

Posted: Wed Mar 15, 2006 8:39 am
by Rhine
I forgot one question....

Is Sql installed on amxx 1.6?

Posted: Wed Mar 15, 2006 11:10 am
by opion
No , you have to get a sql database to save it , when u're using sql

Posted: Sat Mar 18, 2006 3:03 am
by Rhine
Where Can i get sql?

Posted: Sat Mar 18, 2006 9:55 am
by Marticus
google it, mysql is a good place to start

Posted: Sat Mar 18, 2006 9:55 am
by Marticus
Can we lock announcement threads so that people wil use the help/bug report forum?