Multiple Databases??

This is the place for general discussion about Warcraft3 XP, including install help.

Moderator: Forum Moderator

Post Reply
Gunny
Peon
Posts: 36
Joined: Mon Dec 05, 2005 6:24 pm
Location: Magnolia, Texas
Contact:

Multiple Databases??

Post by Gunny » Sat Feb 11, 2006 11:15 am

Is it possible to have War3XP to connect to 2 different databases?
I use amxbans which is on my main server box and I now had a second server box that I have my War3XP server running on.

I want to have the XP saved local on the same box as the war3XP server and I also want to have it connect to the server that my Amxbans is running on.

I know WarFT will do this, it has the options in it.
-john

User avatar
ferret
Lead Warcraft 3 XP Developer
Posts: 422
Joined: Wed Jul 06, 2005 8:20 am
Location: Atlanta, GA
Contact:

Post by ferret » Sat Feb 11, 2006 10:37 pm

The WC3XP plugin will only connect to one database. It doesn't care or know about what your amxbans plugin is doing. Each maintains its own mysql connection.
-< www.gamehavoc.com >-

Lazarus Long: And I know you didn't because the Server Files are version 2.2.6 and the file you posted is version 2.2.5, so do as I told you above and don't ever lie to me again or help is gone!

User avatar
L0neW0lf
Peon
Posts: 17
Joined: Tue Mar 21, 2006 2:11 pm

Shouldnt be a problem

Post by L0neW0lf » Sun Apr 23, 2006 4:59 pm

Your XP database connection can be set in 1 cfg file, and the one for amxbans in another, thats how i do it on my UWC3 server.......

Gunny
Peon
Posts: 36
Joined: Mon Dec 05, 2005 6:24 pm
Location: Magnolia, Texas
Contact:

Re: Shouldnt be a problem

Post by Gunny » Thu Apr 27, 2006 9:18 am

L0neW0lf wrote:Your XP database connection can be set in 1 cfg file, and the one for amxbans in another, thats how i do it on my UWC3 server.......
Thanks for your input, However, If it was in the cfg I would not have asked.

UWC3 and Ft both have this option in the cfg War3XP does not.
-john

User avatar
ferret
Lead Warcraft 3 XP Developer
Posts: 422
Joined: Wed Jul 06, 2005 8:20 am
Location: Atlanta, GA
Contact:

Post by ferret » Thu Apr 27, 2006 10:40 am

By default, it looks for and loads the default AMXX mysql.cfg

You can open the SMA and change it to whatever file you want.
-< www.gamehavoc.com >-

Lazarus Long: And I know you didn't because the Server Files are version 2.2.6 and the file you posted is version 2.2.5, so do as I told you above and don't ever lie to me again or help is gone!

Gunny
Peon
Posts: 36
Joined: Mon Dec 05, 2005 6:24 pm
Location: Magnolia, Texas
Contact:

Post by Gunny » Thu Apr 27, 2006 12:34 pm

ferret wrote:By default, it looks for and loads the default AMXX mysql.cfg

You can open the SMA and change it to whatever file you want.
That is what I ended up doing.

How can I modify the "/playerskills" layout? Font size and layout in general.
-john

User avatar
ferret
Lead Warcraft 3 XP Developer
Posts: 422
Joined: Wed Jul 06, 2005 8:20 am
Location: Atlanta, GA
Contact:

Post by ferret » Thu Apr 27, 2006 2:54 pm

Hrms. Its basicly all HTML.

Open the SMA and search for "public player_skills(id,saychat){"

This is the start of the function for that display. Its a crappy function that needs rewritten but I haven't had time to change it, kinda a "if not broke don't fix" situation.

You'll see this line multiple times:
format(temp,1023,"%s - %s %d%s%s%s%s<br>",name,racename[1],p_level[playerid],skill1,skill2,skill3,skill4)

The part you'll want to change is "%s - %s %d%s%s%s%s<br>" ... You'll note a <br> at the end. I'd suggest trying "<span style=\"whatever\">%s - %s %d%s%s%s%s</span><br />"
-< www.gamehavoc.com >-

Lazarus Long: And I know you didn't because the Server Files are version 2.2.6 and the file you posted is version 2.2.5, so do as I told you above and don't ever lie to me again or help is gone!

Post Reply