Raised This Month: $12 Target: $400
 3% 

Warcraft 3 Frozen Throne (AND traditional War3)


Post New Thread Closed Thread   
 
Thread Tools Display Modes
DoubleTap
Veteran Member
Join Date: Mar 2004
Location: Harker Heights, TX
Old 03-31-2004 , 23:48  
#91

BINGO
__________________
DoubleTap is offline
Send a message via ICQ to DoubleTap
Bikini
Junior Member
Join Date: Mar 2004
Location: Waterloo
Old 03-31-2004 , 23:49  
#92

bingo what? Now i install it on my server? If so where do you put the war3FT.cfg?
__________________
AMXX RockS!
Bikini is offline
Send a message via AIM to Bikini Send a message via MSN to Bikini
DoubleTap
Veteran Member
Join Date: Mar 2004
Location: Harker Heights, TX
Old 04-01-2004 , 00:00  
#93

I am going to call it a night... but that may be an unfixed issue (admiitedly I am not gonna look, too tired)... if you read other posts you'll see it's looking maybe in an AMX folder still... it would take 10 seconds if so to make a fake amx folder and load it from there until it's fixed... but it may already be... do a "find" in the .sma and see where it's pointing...

According to PD, it SHOULD be in the AMXX folder... but it didn't work for me there... so "find" to verify in the .sma or put in AMXX folder (and maybe a copy in a fake AMX folder) and hope for the best...

Vic/DT

Out for the night...
__________________
DoubleTap is offline
Send a message via ICQ to DoubleTap
JoeLowE
Member
Join Date: Mar 2004
Old 04-01-2004 , 01:05  
#94

Quote:
Originally Posted by JoeLowE
I have a cz wc3 server...
I got bad load on warcraft3FT.amx......

[ 24] unknown unknown unknown warcraft3FT.amx bad load
I got it working now.....
But now I cant have XP working....
Every time it change map it change "mp_savexp 1" to "mp_savexp 0"...

PLZ help
JoeLowE is offline
BigBaller
Veteran Member
Join Date: Mar 2004
Location: Everett, WA
Old 04-01-2004 , 01:09  
#95

Quote:
Originally Posted by JoeLowE
Quote:
Originally Posted by JoeLowE
I have a cz wc3 server...
I got bad load on warcraft3FT.amx......

[ 24] unknown unknown unknown warcraft3FT.amx bad load
I got it working now.....
But now I cant have XP working....
Every time it change map it change "mp_savexp 1" to "mp_savexp 0"...

PLZ help
Did you define mp_savexp 1 in a server.cfg or amxx.cfg ??
__________________

BigBaller is offline
JoeLowE
Member
Join Date: Mar 2004
Old 04-01-2004 , 02:15  
#96

Yes in server.cfg.....should I put it in amxx.cfg to
JoeLowE is offline
Nexus
Junior Member
Join Date: Mar 2004
Old 04-01-2004 , 04:08  
#97

can someone add mysql ip and name login....plz
Nexus is offline
eightn
Junior Member
Join Date: Apr 2004
Location: Russia/Moscow
Old 04-01-2004 , 08:45  
#98

Pimp daddy, whether it is possible to add (official) support of recording/reading to/from mysql based on IP addresses?

Especially it is made elementary, it is necessary to make insignificant corrections of all in three places:

line ~5477
Code:
public write_xp_to_file(id){

<.....>

	if (get_cvar_num("sv_mysql")){
		new mquery[1024], ip[32]
		get_user_name(id,playername,31)
		get_user_authid(id,playerid,31)
		get_user_ip(id,ip,31) 		
		if(get_cvar_num("FT_saveby")==1)		// Save by IP address
			format(mquery, 1023, "REPLACE INTO `%s` SET playerid='%s',playername='%s',xp='%d',race='%d',skill1='%d',skill2='%d',skill3='%d',skill4='%d'",mysqltablename,ip,playername,playerxp[id], p_skills[id][0],p_skills[id][1],p_skills[id][2],p_skills[id][3],p_skills[id][4])
		else									// save by stream id
			format(mquery, 1023, "REPLACE INTO `%s` SET playerid='%s',playername='%s',xp='%d',race='%d',skill1='%d',skill2='%d',skill3='%d',skill4='%d'",mysqltablename,playerid,playername,playerxp[id], p_skills[id][0],p_skills[id][1],p_skills[id][2],p_skills[id][3],p_skills[id][4])
		mysql_query(mysql,mquery)
		mysql_check_error()
	}


<.......>

public get_xp_from_file(id,returnrace){

<.....>

	if (get_cvar_num("sv_mysql")){
		if (returnrace)
		{
		    if(get_cvar_num("FT_saveby")==1)		// Save by IP address
				format(mquery, 1023, "SELECT * FROM `%s` WHERE playerid='%s'",mysqltablename,ip)
			else									// save by stream id
				format(mquery, 1023, "SELECT * FROM `%s` WHERE playerid='%s'",mysqltablename,playerid)

			mysql_query(mysql,mquery)
			mysql_check_error()

<.......>


		else
		{
		    if(get_cvar_num("FT_saveby")==1)		// Save by IP address
				format(mquery, 1023, "SELECT * FROM `%s` WHERE playerid='%s' AND race='%d'",mysqltablename,ip,p_skills[id][0])
			else									// save by stream id
				format(mquery, 1023, "SELECT * FROM `%s` WHERE playerid='%s' AND race='%d'",mysqltablename,playerid,p_skills[id][0])
			mysql_query(mysql,mquery)
			mysql_check_error()

I have changed, all wonderfully works (a server 1.6 stands in a network where are used both local (10.x.x.), and public IP addresses.


At me one more question on a file war3FT.cfg
Where (in what directory) it should, what war3 mod it would start?

I tried to put it in amxx/configs, but the file is not started automatically, it was necessary to add it to start (exec) from amxx.cfg
[/code]
__________________
wbr, Evgeniy
eightn is offline
Geesu
Veteran Member
Join Date: Mar 2004
Location: Cincinnati, OH
Old 04-01-2004 , 09:03  
#99

Quote:
Originally Posted by PhantomX
Hey I've been messing around with this on my LAN server and I noticed that XP increases for winning even when sv_warcraft3 is set to 0. I was looking through the code, and I think the prob may be that the "win" functions didn't check the warcraft3 variable. I'm still new at AMX Mod X and coding plugins and stuff so I'm not sure. I also noticed that in the set_mysql function it still looks in "addons/amx/" instead of "addons/amxx" for the mysql config. That might help with the mysql probs, but again I'm still not exactly sure what I'm doing.
You are correct about the win round issue, but not about the mysql. I need to just take that link out because FT doesn't use the default mysql variables. It uses the variables in war3ft.cfg.


DO NOT PUT VARIABLES IN YOUR SERVER.CFG, even though you can just don't do it. Look in the war3ft.cfg file which should be in this folder:
amxx/custom/warcraft3FT/

Customize the plugin in this file (ie: mp_savexp, sv_mysql, etc...)

Also, this mod does not read the default amx mysql information, it uses the FT_ variables, look in the war3ft.cfg file for these.

MySQL module MUST be running even if you are not using it.
__________________
Need war3ft help? DO NOT PM ME... Check the forums
Geesu is offline
Send a message via AIM to Geesu Send a message via MSN to Geesu
Knuckle$
Member
Join Date: Mar 2004
Location: Mid-West
Old 04-01-2004 , 15:21  
#100

Yes for those of you who don't know what he was saying about the mysql stuff it should be in the war3FT.cfg and here is what it should say:

FT_mysql_host "127.0.0.1"
FT_mysql_user "root"
FT_mysql_pass ""
FT_mysql_db "amx"

Unfortunately everyone who does this plugin assumes people know to do that. It took me about a week to figure out that was my problem when I first tried to get war3 working. That should be added to the setup since most people have no idea. I can't even tell you how many server ops have asked me why theirs won't work and most times this is the reason.

Anyway, has this been re-written to fix the "where do the .cfgs go" problem?
__________________
Dr_Knuckle$
Knuckle$ is offline
Closed Thread


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 18:31.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode