Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Release]Protocol MySQL Connection.

Junior Spellweaver
Joined
Sep 17, 2012
Messages
115
Reaction score
7
nope no luck bro.my mysql user is root password is game.
i tried changing password in table.xml
after necros helped using TV the current error was gone
but in terminal alot of lines started popping up giving errors something like java.exception.
i couldnt get the screenshot coz i restored my centos back to what it was before.
Make new user on mysql with this details:
User: root
Password: root

And see if it works then. If not i will make repack tonight! :)
 
Newbie Spellweaver
Joined
Nov 10, 2013
Messages
81
Reaction score
27
with this release you can delete mssql from your pc and run boi woi with only mysql
no i wont i still need mssql for personal fun :)

and thanks for this post

but now i have to make a dailyzen program to work with mysql ...
and now i have to get used with mysql ...
 
Newbie Spellweaver
Joined
Apr 14, 2014
Messages
36
Reaction score
8
One thing I noticed, The users table has passwd2 column the registration code above is using passwd.

This is also missing.

Code:
-- ----------------------------
-- Table structure for ucp
-- ----------------------------
DROP TABLE IF EXISTS `ucp`;
CREATE TABLE `ucp` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` char(16) NOT NULL,
  `lastaccess` decimal(20,0) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
Experienced Elementalist
Joined
Oct 20, 2008
Messages
237
Reaction score
39
One thing I noticed, The users table has passwd2 column the registration code above is using passwd.

This is also missing.

Code:
-- ----------------------------
-- Table structure for ucp
-- ----------------------------
DROP TABLE IF EXISTS `ucp`;
CREATE TABLE `ucp` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` char(16) NOT NULL,
  `lastaccess` decimal(20,0) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

and why do wee need ucp ( which is probably left by someone using it for his website ) ? :)
 
Junior Spellweaver
Joined
Sep 5, 2012
Messages
121
Reaction score
87
all needed tables is on

table.xml

from there you can create all tables needed if missing any
 
Newbie Spellweaver
Joined
Sep 6, 2013
Messages
57
Reaction score
0
hey bro, i use ur build and make pach from this files but have err:
REMOVED

do u know why?
TYWM for pach)
 
Junior Spellweaver
Joined
Sep 17, 2012
Messages
115
Reaction score
7
this error comes very rarely for me.
let us know the solution as well if u find it
hey bro, i use ur build and make pach from this files but have err:
REMOVED

do u know why?
TYWM for pach)
 
Junior Spellweaver
Joined
Sep 5, 2012
Messages
121
Reaction score
87
maybe change the gacd port to another one will fix this
on gacd at linux and config the manager server gacd port
 
Banned
Banned
Joined
Apr 16, 2011
Messages
274
Reaction score
14
necro what repack i could used ?.i used your repack but Manager Server not load.help me
 
Initiate Mage
Joined
Dec 10, 2014
Messages
3
Reaction score
0
Tired of mssql? yes i know.


let me know if you had any problem on installation, ill help you. =)


Hi Necrentos, sorry in advance if i'm asking you, but i really dont understand what to do >.>


[I've been working night and day until i managed to configure a server! And finally yesterday i made it :)
Despite i succeeded, i wasnt able to make master-monster acc-pw work... neither to create a new login -.- ]


So, today ive found both your mysql protocol and your app to make accounts :)
My problems are two basically...

1- I didnt understand what to do ,when u said "give permission 0777"
2- I cant connect with your app.. even tho i checked also in the files and my data are correct :(


Please give me a suggestion or your help if you can, im looking forward to your reply :'( .. >.>


help meeeee.PNG - [Release]Protocol MySQL Connection. - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Junior Spellweaver
Joined
Sep 17, 2012
Messages
115
Reaction score
7
Hi Necrentos, sorry in advance if i'm asking you, but i really dont understand what to do >.>


[I've been working night and day until i managed to configure a server! And finally yesterday i made it :)
Despite i succeeded, i wasnt able to make master-monster acc-pw work... neither to create a new login -.- ]


So, today ive found both your mysql protocol and your app to make accounts :)
My problems are two basically...

1- I didnt understand what to do ,when u said "give permission 0777"
2- I cant connect with your app.. even tho i checked also in the files and my data are correct :(


Please give me a suggestion or your help if you can, im looking forward to your reply :'( .. >.>


View attachment 149276
To make user in mysql in terminal for giving access to windows mysql
mysql --user=root --pass=root
CREATE USER 'host'@'192.168.2.3' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES ON *.* TO 'host'@'192.168.2.3' WITH GRANT OPTION;

now enter in this app
username = root
password = root
u'll then connect
and btw if u using mysql only version u dont have any premade account so master/monster will not work coz there are 0 accounts in mysql database
 
Initiate Mage
Joined
Dec 10, 2014
Messages
3
Reaction score
0
To make user in mysql ...

Hi..!
Thank you very much for the fast reply! I forgot to update my reply :p
Everything its fixed, and someone helped megetting rid of mssql xD
I also understood many other things, but i suppose this kind of stuff is understandable only by 2 ways, either studying programming or having tons of practice with someone that can help u :p


Atm my prob is just one : Today my map / mobs were bugged o_O But i suppose its client-related, as i backed up all the slk n edits i made! o_O




Question of the year... having those pet releases of woi... (Files in dds,pwm3,m4f) Does it work, if i replace one pets folder in Data/Char/Pet and also the pet.slk? :O I cant really see it it worked.. cause as i said my boi is bugged right now!



Tyvm <3



[The attached image shows one of my pets on a p.server im playing. But also on my serv its the same, not only the pets,even the mobs!]
 

Attachments

You must be registered for see attachments list
Back
Top