Archived copy of warcraft-source.com, the Warcraft: Source (WCS) forum (2007–2011), rebuilt from the Internet Archive by wc3mods.net. This page was captured on 2010-05-06 (original capture). Home · Forum · All archived topics · Downloads

Author Topic: How to setup MySql to work with WCS?  (Read 218 times)

Offline pedrotorresfilho

  • Level 0 Beginner
  • Posts: 2
  • <3 WCS :)
How to setup MySql to work with WCS?
« on: February 21, 2010, 12:09:51 PM »
Have 2 questions:

1. is a bug, think in Es_tools 0.420. Can't fix it, if someone have a glue on it,  please, tell me.

Here's the bug:
[WCS] Disabling mani console spam ...
Unknown command "est_AntiBufferOverun"

2. How to setup MySql to work with WCS? There is a string to create necessary tables and everything if existing a MySql database?

Thanks in advance,

Pedro Torres
IT Lawyer


Online Muse

  • Level 7 Expert
  • *****
  • Posts: 212
  • The lord of drunken bears, 102 lvl.
Re: How to setup MySql to work with WCS?
« Reply #1 on: February 21, 2010, 04:00:08 PM »

1. is a bug, think in Es_tools 0.420. Can't fix it, if someone have a glue on it,  please, tell me.

Here's the bug:
[WCS] Disabling mani console spam ...
Unknown command "est_AntiBufferOverun"

Bug not in EST.
Find that in "es_wcs":
Code: [Select]
es_xdelayed 6 est_AntiBufferOverun 1Correct:
Code: [Select]
es_delayed 6 est_AntiBufferOverun 1

Лет'с толк ин личку ин рашен.
Who`ll dare to face me?

Offline CA.Berettonawak

  • Le renomm� m�connu...
  • Watchdogs
  • Level 7 Expert
  • *****
  • Posts: 3061
  • Big Berettonawak is watching you...
    • Coding-Alliance.Com : A bunch of coders? Why not a bunch of players? :P
Re: How to setup MySql to work with WCS?
« Reply #2 on: February 22, 2010, 01:17:10 PM »
Wrong. It won't change anything.

And WCS cannot work with Mysql.
Quote from: N0life
Beret, keep yourself focusing on 1 project. Be sure to memorize that down since it sounds good.

Quote from: myself
i love tuna juice :D

Quote from: Pietro
=CA= Pietro: back
=CA= Pietro: sorry, was downstair sharing my chocolate with my cat
=CA= Pietro: you should see his face when he ate it xD

Quote from: myself
=CA= Berettonawak: just because you don't have hope doesn't mean we're doomed


Offline necavi

  • Level 1 Trained Beginner
  • *
  • Posts: 32
  • Wcsx Codeveloper
Re: How to setup MySql to work with WCS?
« Reply #3 on: April 29, 2010, 09:15:41 PM »
How odd, we have perfectly a functional MySQL database for both our racefiles and our storedxp and all :P
« Last Edit: May 02, 2010, 10:40:04 PM by necavi »

Offline CA.Berettonawak

  • Le renomm� m�connu...
  • Watchdogs
  • Level 7 Expert
  • *****
  • Posts: 3061
  • Big Berettonawak is watching you...
    • Coding-Alliance.Com : A bunch of coders? Why not a bunch of players? :P
Re: How to setup MySql to work with WCS?
« Reply #4 on: May 02, 2010, 07:46:27 PM »
How odd, we have perfectly a functional SQL database for both our racefiles and our storedxp and all :P

Sqlite, maybe? :P
Quote from: N0life
Beret, keep yourself focusing on 1 project. Be sure to memorize that down since it sounds good.

Quote from: myself
i love tuna juice :D

Quote from: Pietro
=CA= Pietro: back
=CA= Pietro: sorry, was downstair sharing my chocolate with my cat
=CA= Pietro: you should see his face when he ate it xD

Quote from: myself
=CA= Berettonawak: just because you don't have hope doesn't mean we're doomed


Offline necavi

  • Level 1 Trained Beginner
  • *
  • Posts: 32
  • Wcsx Codeveloper
Re: How to setup MySql to work with WCS?
« Reply #5 on: May 02, 2010, 08:34:34 PM »
MySQL :P

Offline Stinkyfax

  • I <3 WCS
  • Level 7 Expert
  • *****
  • Posts: 1909
    • WarCraft III Custom races and more Server
Re: How to setup MySql to work with WCS?
« Reply #6 on: May 02, 2010, 08:36:36 PM »
How odd, we have perfectly a functional SQL database for both our racefiles and our storedxp and all :P

person asks how to set up mysql server and you reply him next:
"I've got custom wcs with working mysql but screw you, do whatever you want i won't help you here" What's the point of your reply if not this?



Offline necavi

  • Level 1 Trained Beginner
  • *
  • Posts: 32
  • Wcsx Codeveloper
Re: How to setup MySql to work with WCS?
« Reply #7 on: May 02, 2010, 08:39:03 PM »
That was merely to state that it is possible, instead of having this hope-destroyer:
Quote
And WCS cannot work with Mysql.


Offline CA.Berettonawak

  • Le renomm� m�connu...
  • Watchdogs
  • Level 7 Expert
  • *****
  • Posts: 3061
  • Big Berettonawak is watching you...
    • Coding-Alliance.Com : A bunch of coders? Why not a bunch of players? :P
Re: How to setup MySql to work with WCS?
« Reply #8 on: May 03, 2010, 05:14:34 PM »
Hum well, it technically could be possible using python but never in shell :P
And even still, what's the point of using mysql in python? it's much slower than sqlite, even though it can be threaded :/
I used to work with mysql, but it's just almost impossible to make an rpg (like wcs) with MYsql; answer times are slow, and server can just be off for some reason :/ so now i use sqlite :P

what module did your bro use to use mysql? :P
Quote from: N0life
Beret, keep yourself focusing on 1 project. Be sure to memorize that down since it sounds good.

Quote from: myself
i love tuna juice :D

Quote from: Pietro
=CA= Pietro: back
=CA= Pietro: sorry, was downstair sharing my chocolate with my cat
=CA= Pietro: you should see his face when he ate it xD

Quote from: myself
=CA= Berettonawak: just because you don't have hope doesn't mean we're doomed


Offline necavi

  • Level 1 Trained Beginner
  • *
  • Posts: 32
  • Wcsx Codeveloper
Re: How to setup MySql to work with WCS?
« Reply #9 on: May 03, 2010, 05:58:34 PM »
My brother built it in python, and even if it were slightly slower (its not, its much faster, partially because the MySQL functions are coded in python) it offers so much more to it, especially with a local MySQL server. The possibilities become endless when using a MySQL database, while an SQlite database is far too limited and inefficient for more than a few hundred races/userbase.