im confused, so i just run mysql from Xamp by clicking start then i name my database dbotest, right click when connection is made in navicat and click execute sql file and select dbotest from the server folder and it comes back unsuccessful? what do i need to do? thanks for help!
I think NaviCat allways back unsuccessfull for me. After execute sql file, close Navicat and reopen, see the dbotest database, and there should be the tables, or try right click, something about reload or something like that.
Because I use XAMPP with PhPMyAdmin
The error I get everytime
- - - Updated - - -[Err] 1046 - No database selected
[Err] --
-- Base de datos: `dbotest`
--
--
-- Procedimientos
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `AuthLogin`(IN m_szUserID VARCHAR(20), IN m_szUserPW VARCHAR(20), OUT m_dwAccountID INT, OUT m_nResultCode INT)
BEGIN
DECLARE dec_pw VARCHAR(100);
DECLARE dec_status VARCHAR(7);
IF(SELECT EXISTS(SELECT 1 FROM accounts WHERE Username = m_szUserID)) THEN
SELECT AccountID,AccountPW,acc_status INTO m_dwAccountID,dec_pw,dec_status
FROM accounts
WHERE Username = m_szUserID;
IF (dec_pw = m_szUserPW) THEN
SET m_nResultCode = 100;
ELSE
SET m_nResultCode = 107;
END IF;
IF (dec_status = 'block') THEN
SET m_nResultCode = 113;
END IF;
ELSE
SET m_nResultCode = 108;
END IF;
END;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
fixed it :) do we have a translate patch ?
- - - Updated - - -
Nice ;)
@whitespirits123
Good, now even you are in
If you want, you can use the locale emulator (search in internet) so you can see the number on the LP and MP bar.
Cheers
EDIT:
this's the resoult with locale emulator, for who want to see:
Last edited by mazzod; 20-02-16 at 12:38 AM.
God luck in this, maybe one day all work in tw version :D
New updated, Version 1.05 ready.
New Server.ini, Tutorial ( Not done yet ) I recommend touch ESC when U enter on the tutorial, because it isn't finish, added Skills and Mobs.
Screenshots added on main page.
Last edited by Nicolas321; 20-02-16 at 09:26 PM.
@Nicolas321Originally Posted by Nicolas321
thks for the update, when I'm home I'll test!
Cheers
I hope u enjoy the files!!, now I will work in a better fight system, revive system, etc.
I was playing with 2 players, one on Kokkara ( Human ) and other on Majin, killing mobs, and works fine.
If I get boost library x64, I will be able to compile the server with x64 and the server will go a little better.
@Nicolas321
Only one question, did you see if even you, when start all the servers, the cpu goes to 100%?
Not 100%, but 90%, I got CPU, well when I compile with x64 it will go a better, I'm downloading boost library now.
Appreciate the work your doing @Nicolas321 glad to see your work, and it's progression, good luck. *Question* have you incorporated any gm codes at this time or it it blank
I tested the v1.05 and it is good, but maybe exit any possibility that in the future you work in taiwan version?
Hey love it! killed me some mobs ;) would be great to get some GM commands or tools? I think work on the KR like you are as I hear its less buggy? good job cant wait for more updates!
@Nicolas321
from one quick test, I've noticed only one little problem, when you create a new nameck dragon clan the posture on the char selection screen is the same of the warrior, in game all is good (posture/skill/equip/weapon).
I'm testing right now all other thing, but seems all good. Even the calculation of the skill's damage seems already very accurate.
Of course I like the customization that you added on the first tutorial screen (when the movie start)
I'll continue to test the skill things, to see if they're properly recognized.
Cheers
I have work on TW, but I can't keep working because I don't have the Packet Struct, I got items, bags, skills, but I can't spawn mobs, so what can I do? Or Npc, nothing, or even other character.
In other update I will add some GM commands.
- - - Updated - - -
Maybe today I will make another update, like Mob Spawn, more skills, Idk.
Reply With Quote