[DumB] UWC3 1.6.1-RC1 - SQL only

Come here for announcements and downloads

Moderator: Forum Moderator

Locked
obe
UWC3 Developer
Posts: 3
Joined: Fri Sep 30, 2005 4:38 pm
Location: Theres no place like 127.0.0.1

[DumB] UWC3 1.6.1-RC1 - SQL only

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
Attachments
dumb_uwc3_161.zip
(161.13 KiB) Downloaded 78903 times
Last edited by obe on Mon Oct 10, 2005 10:48 am, edited 2 times in total.

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

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?
No Support via PM

obe
UWC3 Developer
Posts: 3
Joined: Fri Sep 30, 2005 4:38 pm
Location: Theres no place like 127.0.0.1

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 :D

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

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

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

OK I edited your post and moved it, hope thats ok
No Support via PM

redsplat
Peon
Posts: 1
Joined: Fri Oct 21, 2005 8:54 am
Location: sweden

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

what map should i puut uwc3 in :?: :?
Hmm?

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

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

?? what do u mean?
No Support via PM

NerPissad
Peon
Posts: 1
Joined: Wed Nov 02, 2005 5:36 am
Location: Sweden

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
Peon
Posts: 1
Joined: Wed Nov 09, 2005 12:17 pm

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:/

User avatar
lickity
Militia
Posts: 54
Joined: Thu Jan 05, 2006 8:05 pm

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

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

S4in7
Peon
Posts: 22
Joined: Thu Jan 05, 2006 2:01 pm

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
Footman
Posts: 125
Joined: Wed Oct 05, 2005 7:30 am

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

User avatar
Werewolf
Peon
Posts: 21
Joined: Sat Feb 04, 2006 1:13 pm
Location: Sweden

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.

User avatar
TooL
Peon
Posts: 31
Joined: Wed Jan 04, 2006 2:47 pm
Contact:

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?
260servers.net - BF2142 Pimp Shack =RANKED=
Also featuring War3x SAVED XP | 209.40.101.127:27015
Image

saintk
Footman
Posts: 125
Joined: Wed Oct 05, 2005 7:30 am

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

Not from our side.

User avatar
lickity
Militia
Posts: 54
Joined: Thu Jan 05, 2006 8:05 pm

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

what tables do i add?
Image

User avatar
lickity
Militia
Posts: 54
Joined: Thu Jan 05, 2006 8:05 pm

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...

User avatar
lickity
Militia
Posts: 54
Joined: Thu Jan 05, 2006 8:05 pm

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
Footman
Posts: 125
Joined: Wed Oct 05, 2005 7:30 am

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)

Marticus
Lead UWC3 Developer
Posts: 281
Joined: Sat Jul 16, 2005 10:47 am

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

I feel lost in a forest of infinite uwc3 versions.

User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:

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

Marticus wrote:I feel lost in a forest of infinite uwc3 versions.
Agreed
No Support via PM

DarkJP2
Rifleman
Posts: 163
Joined: Tue Jul 26, 2005 3:18 pm
Location: Swiss

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
Footman
Posts: 125
Joined: Wed Oct 05, 2005 7:30 am

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
Peon
Posts: 9
Joined: Mon Feb 27, 2006 9:06 am

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

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

csmaverick1989
Peon
Posts: 2
Joined: Wed Mar 01, 2006 8:58 pm

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!

User avatar
taheri6
Militia
Posts: 57
Joined: Wed Mar 01, 2006 10:34 pm
Location: Washington
Contact:

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.
need more help or custom code? Try http://uwc3mod.com

I am no longer monitoring this site or posts, so I will not be answering here, sorry.

UWC3 Deathmatch - 205.134.225.222:27015
Gun Game Deathmatch - 209.160.44.131:27015

saintk
Footman
Posts: 125
Joined: Wed Oct 05, 2005 7:30 am

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)

User avatar
taheri6
Militia
Posts: 57
Joined: Wed Mar 01, 2006 10:34 pm
Location: Washington
Contact:

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.

User avatar
taheri6
Militia
Posts: 57
Joined: Wed Mar 01, 2006 10:34 pm
Location: Washington
Contact:

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;
need more help or custom code? Try http://uwc3mod.com

I am no longer monitoring this site or posts, so I will not be answering here, sorry.

UWC3 Deathmatch - 205.134.225.222:27015
Gun Game Deathmatch - 209.160.44.131:27015

lantz69
Peon
Posts: 24
Joined: Tue Oct 25, 2005 2:46 pm
Location: Sweden, Skåne

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.
Using: Amxmodx 1.76, cstrike
http://lantznet.se/hlm/
Image

Marticus
Lead UWC3 Developer
Posts: 281
Joined: Sat Jul 16, 2005 10:47 am

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
Footman
Posts: 125
Joined: Wed Oct 05, 2005 7:30 am

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
Peon
Posts: 14
Joined: Mon Mar 13, 2006 8:52 am

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
Peon
Posts: 14
Joined: Mon Mar 13, 2006 8:52 am

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

I forgot one question....

Is Sql installed on amxx 1.6?

User avatar
opion
Peon
Posts: 34
Joined: Fri Nov 11, 2005 8:07 am
Location: Belgium

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
Peon
Posts: 14
Joined: Mon Mar 13, 2006 8:52 am

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

Where Can i get sql?

Marticus
Lead UWC3 Developer
Posts: 281
Joined: Sat Jul 16, 2005 10:47 am

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

google it, mysql is a good place to start

Marticus
Lead UWC3 Developer
Posts: 281
Joined: Sat Jul 16, 2005 10:47 am

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?

Locked