Hwan Lv Title Automatic?

02/07/2013 15:13 mayc0n#1
Good morning,

I would like to better understand the system title, HWAN Level.

I used a tutorial to add more titles without replacing existing ones.

Now you must understand, the officer must do the quests lv 95 and 110 to get the titles. And for titles that made ​​using the tutorial? I need to make a custom quest?

It is possible to use the titles automatically by players according to the level? Eg

1 ~ 20: Untitled
21 ~ 40: Title 1
41 ~ 60: 2 Title
61 ~ 80: 3 Title
81 ~ 90: 4 title
95 and 110: Title quests from official
111 ~ 120: Title quest of customized

Is that possible?

Regards
02/07/2013 18:18 Zodiao#2
Yes it is ..
02/07/2013 20:01 mayc0n#3
Quote:
Originally Posted by Sir*EviL View Post
Yes it is ..
So?? --'
02/07/2013 20:37 Veteran1337#4
If you want this, create it...don't wait till somebody will do it for you
Learn SQL ;)
02/08/2013 03:38 mayc0n#5
Quote:
Originally Posted by Veteran1337 View Post
If you want this, create it...don't wait till somebody will do it for you
Learn SQL ;)
Thks... however at no time asked that someone did that to me ...
Just ask some tips on how and where I can be seen to do so. As in the name of this forum, ask to experts, then was what i did ...;)

so...Anyone pls?
02/08/2013 10:56 zikor1337#6
you can simply make it as a php function in your website . If you the char has between lv x and lv y , assign z value to Hwan . Or create a new quest ! There you go !
02/08/2013 12:57 mayc0n#7
Quote:
Originally Posted by zikor1337 View Post
you can simply make it as a php function in your website . If you the char has between lv x and lv y , assign z value to Hwan . Or create a new quest ! There you go !
WoW! Thx bro...I'll try it php function. I wish it automatic, without quest.
02/08/2013 13:36 zikor1337#8
Quote:
Originally Posted by mayc0n View Post
WoW! Thx bro...I'll try it php function. I wish it automatic, without quest.
If you want it automatic, you have to modify the procedures which can be a harder. ;)
02/08/2013 17:15 mayc0n#9
Quote:
Originally Posted by zikor1337 View Post
If you want it automatic, you have to modify the procedures which can be a harder. ;)
Thk again. Could you tell me what procedure I have to edit? For that looked fast, I'm at work and have not found anything related to lv up, the only thing that must lv no parameter related something similar.
02/09/2013 02:26 sarkoplata#10
UPDATE _CHAR SET hwanlevel='5' WHERE CurLevel BETWEEN 20 AND 40
UPDATE _CHAR SET hwanlevel='6' WHERE CurLevel BETWEEN 40 AND 60
UPDATE _CHAR SET hwanlevel='7' WHERE CurLevel BETWEEN 60 AND 80
UPDATE _CHAR SET hwanlevel='8' WHERE CurLevel BETWEEN 80 AND 100

etc...

edit the queries for yourself and execute it every x minutes or seconds...
02/09/2013 02:38 mayc0n#11
Quote:
Originally Posted by sarkoplata View Post
UPDATE _CHAR SET hwanlevel='5' WHERE CurLevel BETWEEN 20 AND 40
UPDATE _CHAR SET hwanlevel='6' WHERE CurLevel BETWEEN 40 AND 60
UPDATE _CHAR SET hwanlevel='7' WHERE CurLevel BETWEEN 60 AND 80
UPDATE _CHAR SET hwanlevel='8' WHERE CurLevel BETWEEN 80 AND 100

etc...

edit the queries for yourself and execute it every x minutes or seconds...
Wow thx bro! i'll try it now, but why i need set it for execute every x minutes? o.õ

regards
02/09/2013 02:52 sarkoplata#12
Quote:
Originally Posted by mayc0n View Post
Wow thx bro! i'll try it now, but why i need set it for execute every x minutes? o.õ

regards
Simple:
When you execute this, all characters between the level gaps will get their rank. But WHEN you execute this. So, for example there are 100 characters in server, you executed this. Everybody gets a rank. After a day, there are 100 more characters and the old 100 got level 99. So; you will have to execute again.
02/09/2013 03:51 mayc0n#13
Quote:
Originally Posted by sarkoplata View Post
Simple:
When you execute this, all characters between the level gaps will get their rank. But WHEN you execute this. So, for example there are 100 characters in server, you executed this. Everybody gets a rank. After a day, there are 100 more characters and the old 100 got level 99. So; you will have to execute again.
Hm Thats true! Thx bro :)