Warcraft 3 MODs

DesasterUK

probiers mal mit hlds_run statt hlds_amd
hatte da bei mir auch schon des öfteren Probleme mit

--- Edit ---
blind bin ich auch noch
hast ja mit run gestartet ^^

DesasterUK

Sorry.
Didn't look at the link Yami told you.
So my post has been edited

DesasterUK

Schalte mal das MYSQL-Modul aus.

Du speicherst ja in SQLite.
Ich hatte mal ein ähnliches Problem mit einem anderen Plugin, als ich beide Module aktiv hatte.

DesasterUK

Und bitte installier dir die STEAM-Version anstelle der NON-STEAM.

And make sure u are running STEAM instead of NON-STEAM-Version!!!!!

NON-STEAM is not supported!!!!!

DesasterUK

Try to comment out the SQLite-Module in your moduels.ini
As i can see u want to save ur XP to MYSQL. so SQLite there is no need to run SQLite.

DesasterUK

I noticed something similiar when i updated to 3.0 Beta ???
It converted the players to the new DB-Structure but on the stats it only displays players that starts playing after updating.

Maybe u have the same problem and never realised it.

DesasterUK

Just take a look at RC3 and the newest version.
In RC3 the mole does what u want it to do.
Maybe u can figure out the code that has been changed for the mole thing.

DesasterUK

it seems u haven't set the following entries in your /amxmodx/data/lang/war3x.txt correctly (i think they are missing)

MENU_PLAYEROPTIONS_1 = Show Race Icons
MENU_PLAYEROPTIONS_2 = Show Health Icons
MENU_PLAYEROPTIONS_3 = Show Dispell Icons
MENU_PLAYEROPTIONS_4 = Auto-Cast on Teammates
MENU ...

DesasterUK

I noticed the same problem.
The RC7B1 converts the data to the new db but only new players are tracked to the stats system.

DesasterUK

Now i see what the information_schema is for, i think.

Everytime you create/drop a db/table the mysql saves some information data to it.
So u can simply check what kind of dbs and tables are manage by mysql.
But it's a Mysql5.x feature (i know i allready said this above)

Now the problem:
Mysql4.x ...

DesasterUK

Correct me if i'm wrong.
The information_schema thing is a new feature in the newest MYSQL-versions.
I found the information_schema first in the manual of mysql5.0.

Ppl using mysql4.x or older don't have this feature.
That seems to be the problem.

Your method to convert the data in RC7B1 works ...

DesasterUK

Senne.
Try with this version first.
Tried it on my test-server and it converts my old data to the new structure.
After that u should be able to update to RC8

DesasterUK

Have u made any updates/changes to your server?
amxx update or something else?

maybe there is the problem.
not sure, but i think war3ft 2.3.2 is developed for amxx 1.71
otherway your meta list shows v2.2.5 for war3ft

DesasterUK

Geesu wrote:Ahhhh it may not be working because information_schema is in another table... I'm not sure how the permissions would be changed to fix this :/

Josh?
This table/database is never been created.
So why should i change the permissions for a db that doesn't exist?

DesasterUK

Here is my error message

[WAR3FT] MySQL X database connection successful
L 08/09/2007 - 13:00:39: [war3ft.amxx] [MYSQLX] Error in querying database, location: 12
L 08/09/2007 - 13:00:39: [MYSQLX] Error in querying database, location: 12
L 08/09/2007 - 13:00:39: [war3ft.amxx] [MYSQLX] Message ...

DesasterUK

I'm allways getting an error, the the war3ft couldn't query a database called information_schema.

I took a look in my phpmyadmin and realized there is no db called like this.
Now i took a look to the war3ft plugin.

In db/mysqlx.inl i found:

// Check to see if the table even exists!
new szDB ...

DesasterUK

Das war glaube ich auch schon vorher so.
Wenn ihr mal in die Console schaut nach einem Suicide-Bomber, seht ihr, dass derjenige, der dadurch drauf gegangen ist einen suicide erlitten hat.
Es kommt die selbe Nachricht, als wenn man "kill" ausführt. (suicide with world, wenn mich nicht alles täuscht ...

DesasterUK

What u see in your logs is no error.
Thats part of the conversion from 2.3.2 db-scheme to the 3.0 db-scheme.

U will get this only the first time u start your server with 3.0.
It checks if u have all tables created for 3.0.
If not, it will create it and put all data into the new db-scheme.

The ...

DesasterUK

viewtopic.php?t=2919

DesasterUK

this is topic is all off topic, cause non-steam is not supported

DesasterUK

take a look at the snd-list.cfg
there are some examples how to add new sounds.

best way is to create a new directory in the sounds directory of your server

e.g.
/sound/chat

open the snd-list.cfg and add a line like this

hello; chat/hello.wav

when u now type hello in the server chat it will ...

DesasterUK

never played halo 2

maybe the way serpent wards are given
each level u skill invisibility u will get one load of 5 seconds to be invisible
in critical situations u can use ur ability

this will take out the camping humans, i think.
and it would be better for teamplay

DesasterUK

seems u haven't uploaded the sounds in the correct directory

btw... this files are just the sounds played when someone connects to the server or leave it.

take a look in the amxx forums.
there should be the file-pack including the sounds u are missing if u can't find them

DesasterUK

Open ur plugins.ini
In the third party section u have to load wc3 first
and sank_sounds has to loaded after wc3

Here is my plugins.ini and it works fine

; AMX Mod X plugins

; Admin Base - Always one has to be activated
;admin.amxx ; admin base (required for any admin-related)
;admin_sql.amxx ...

DesasterUK

sounds interessting.
i got this timeouts, too.
But i thought it is because off the shared maps folder i created for my server.
I created a shared folder for my servers, where i can put all maps in.
Since then i got these timeouts on mapchange, but the server will change to the correct map, so there ...

DesasterUK

@headbuster:
He can't use the statistics website until he is saving the XP to a mysql database.
He is running wc3ft in short term mode, so the plugin hasn't created the needed tables in the database.

Yami is on the right way to help him.

DesasterUK

ok...
made some tests

( (victim level - attacker level) / 10 ) + 1

set all xpgivebylevel to 10 (in savexp)
will set up a test server for my clan
min xp = 3(?) when level 10 kills level 0 with standard rifle
max xp = 120 when level 0 kills level 10 with knife

i think this should be balanced.
maybe ...

DesasterUK

Try this one

DesasterUK

Can u send me the link to the homepage where u downloaded it?
It seems u have downloaded it for another cs version than 1.6
Maybe u got the CSS or CS 1.5 version of this map

DesasterUK

omg
its time to go to bed.
if u kill someone one level above u will get 30%

:wallbash:

btw: if u try to open all smileys u will get a hacking attempt

DesasterUK

Normaly there should be a maps folder inside ur cstrike folder.
In there u can find all maps as bsp-files.
simply delete these files.

To "install" new maps u only need to copy all files that belong to the map u want in the correct folders (most maps are downloadable in zip-files wich contains a ...

DesasterUK

Maybe something like this

new Float:xpkillmultiplier = 0.0;
if ( p_data[iAttacker][P_LEVEL] < p_data[iVictim][P_LEVEL] )
{
xpkillmultiplier = ( p_data[iVictim][P_LEVEL] - p_data[iAttacker][P_LEVEL] ) * 0.3;
}
else if ( p_data[iVictim][P_LEVEL] < p_data[iAttacker][P_LEVEL ...

DesasterUK

Then u should create the folder

But only the fy_iceworld.bsp won't work cause de_vegas.wad is needed since cs 1.6, cause de_vegas is no longer a standard map, but is needed for iceworld.

try googling for de_vegas.wad
there are many sites where u can download it.

DesasterUK

fy_iceworld contains some files

there should be:
de_vegas.wad
fy_iceworld.txt
fy_iceworld.bsp

u have to place the bsp and txt files to your servers cstrike/maps folder
and the wad file has to be directly in the cstrike folder

DesasterUK

Some time ago i made a sug about something like a campmeter for humans, that they will be more visible if they camp more than a specified time.

My new sug is to make the invis as an ability

e.g.
If u use ur ability (invis) u will be invis for a specified time (10 seconds) and u will only be able ...

DesasterUK

Maybe just multiply it with a constant of 0.1 and multiply with the difference of the levels

Otherway u could build in a cvar so everyone can choose there own multiplier to find out the best settings for there server

If i find time to do i will try it on my own and let u know about if it works.

DesasterUK

Is it possible, that the XP given to you on every kill is depending on your level and the enemies level?

e.g.
You are level 8 and kill someone on level 2 u will get less XP, than you are level 2 and kill someone on level 8.

DesasterUK

Thx Yami

DesasterUK

I'm not sure, but didn't rc6 convert the old db structure from rc5 to the new one?

Just try RC6 to convert the db and after that update to RC7.

I'm sure one of the betas can convert it by itself (one of the RC6 ones).

DesasterUK

Thats correct Yami and this post can be closed

Its just a help request how to save XP in mysql/sqlite.

DesasterUK

Kannst du nicht.
Kann nur ein Admin oder Moderator.
Aber passt schon.

DesasterUK

Schau mal in deine war3ft.cfg

da findest du die folgenden einträge

// SQL Database Information

wc3_sql_dbhost "localhost" // Host Name
wc3_sql_dbuser "root" // User Name
wc3_sql_dbpass "" // Password
wc3_sql_dbname "" // Database Name

normalerweise sollte es reichen, wenn du bei wc3_sql_dbname ...

DesasterUK

Es gibt einige Anbieter von kostenlosen Datenbanken.
Allerdings hast du dort den Nachteil, dass die Rechner ein ganzes Stück voneinander entfernt stehen, so dass auch die Ping und Reaktionszeiten recht hoch sind.

Das kann wiederum dazu führen, dass der Gameserver die Verbindung zur Datenbank ...

DesasterUK

Hi there.

First i will try to explain what i need and what i've done.

I wanted the Chameleon-race only for Admins/Users with a special admin flag.

I implemented a function to get a new flag only for enabling the race.
So far there are no problems.

Build in some code, that non-admin-users can't ...

DesasterUK

// SQL configuration
FT_sql_host "mysql4.websitesource.net:3306" // Host Name
FT_sql_user "Achille_AGS" // User Name
FT_sql_pass "*removed*" // Password
FT_sql_db "Achille_WAR" // Database Name

but he tries to save in a mysql database.
so it won't run that way.

DesasterUK

you need to run the mysql module (modules.ini)
wc3ft 2.3.2 doesn't support sqlite (afaik)

DesasterUK

the plugin u are running is forcing that special skin for the players so wc3ft can't override it

had the same problem some weeks ago, cause i wanted the admins to pick some special skins

the only way to fix it, is to re-code the skin-plugin to check if the player is mole, i think.

DesasterUK

constants.inl

#define EXPLOSION_RANGE 300

u have to recompile the plugin after changing this value

DesasterUK

as far as i know zbot is a hacked version of the csbot used in condition zero.
so its part of valve software that had been hacked/cracked.
so u are violating the valve licensment if run it

DesasterUK

@kp_downarrow:
I tried it, before i post it in the forums, cause i had the same problem.

But take care on the note at the end "it doesn't work with csdm"

Without csdm it should work for RC5

Warcraft 3 MODs

Search found 133 matches

[MYSQLX] information_schema.tables

[SUG] Human invisibility as ability

[SUG] XPs given on every Kill

Autoselect race (need help for coding)