Cydh

example your new table has char_id and zeny field, so .. FROM .. JOIN `new_table` ON `char`.`char_id` = `new_table`.`char_id` WHERE ... but, u also need to edit the update query, need to add new query to update the new_table "UPDATE `new_table` SET `zeny` = %d WHERE `char_id` = %d", char_id, zeny something like that

then on that query, u still need call zeny field JOIN from other table

seems better you make/request for custom source, seems rA won't get involved with custom which isn't exist in official.

that means u didn't success patch it. if u're in newer rAthena, u don't need that patch, rAthena implemented it already

I think, if your question is is this possible, the answer it's must be possible.

doc/item_db.txt#L39 Implemented: Shadow Equipment System

@Aleos @kido, and u're 1010, what a binery. [spoiler=hmm]http://prntscr.com/38cd1g

there are many search engines, even the Google itself, it has "version", and for current version, idk yet how does it work now. also, I mention and well, finally, everything that I wanted to say are wrote already, the rest is admins decision.

nice guide, I knew this and just wait someone to make the guide. xD btw, there is a bit mistake there, in db\const.txt, it doesn't like "=" after SI_<name>, it needs a tab. [spoiler=in your guide]

Just wait and see. Because this thread just kinda not like suggestion, but just more like "why don't u do this? let's go and hurry!" since I wrote this not as a person who doesn't know about SEO.

SELECT `c`.`name`, var1 = `g`.`value`, var2 = ( SELECT `g2`.`value` FROM `global_reg_value` AS g2 WHERE `g2`.`str` = 'PvPKillsNew' AND `g2`.`char_id` = `c`.`char_id` ) FROM `global_reg_value` AS g JOIN `char` AS c ON `g`.`char_id` = `c`.`char_id` WHERE `g`.`str` = 'PvPKDA1' AND `var2` > 50 ORDER BY `var1` DESC LIMIT 50

SELECT `c`.`name`, `g`.`value` FROM `global_reg_value` AS g JOIN `char` AS c ON `g`.`char_id` = `c`.`char_id` AND `g`.`str` = 'PvPKDA1' AND `g`.`value` > 50 ORDER BY `g`.`value` DESC LIMIT 50

read the skill_db.txt format please. db/re/skill_db.txt#L44

src/map/map.h#L43 change the #define MAX_EVENTQUEUE 2then recompile your server

actually there was staff discussion about multi-language support for scripting stuff, that it seems just marked as "started" with goes nowhere. xD

I think u can make a script that using OnPCKillEvent, strcharinfo(), and getnameditem(); but if u want to edit the src, u can change tha map_addflooritem to pc_additem(sd,&item_tmp,1,LOG_TYPE_OTHER);*not tested*

before, there was RENEWAL_EDP config, so u can turn on/off Renewal EDP even it's on Renewal. but not, it seems if you're in Renewal, you "has been forced" to use Renewal EDP. if you want play with EDP damage calculation, it's on src/map/battle.c#L3891

src/map/skill.c | 1 + 1 file changed, 1 insertion(+) diff --git a/src/map/skill.c b/src/map/skill.c index ad08fb3..23db870 100755 --- a/src/map/skill.c +++ b/src/map/skill.c @@ -15595,6 +15595,7 @@ void skill_weaponrefine (struct map_session_data *sd, int idx) pc_unequipitem(sd,idx,3); } clif_delitem(sd,idx,1,3); + clif_additem(sd,idx,1,0); clif_upgrademessage(sd->fd, 0, item->nameid); clif_inventorylist(sd); clif_refine(sd->fd,0,idx,item->refine);

Well, first before I go any further, are admins know about Meta Tags that applied on rAthena Board? Because I just see rAthena board isn't concerning about meta tags everywhere and other SEO stuffs. If the Admins plan isn't concerning about SEO for rAthena Board, that's mean don't need to read more a piece of words from me. 1. rAthena Board main page Try check the source pages, let's find the meta tag for description and keywords. What are you guys got? "Array". What the...? Suggestion: The main page, I bet even a free or cheap CMS at least has config to set the web description. So, you can write it, or, I know @Akkarin and I think some higher ups are good in HTML, you can just edit it manually. 2. Topic Just try the same method like above, what's the result? Same "Array"? And then, I wonder the 'tag' that provide when user make a new topic, it can be generated becomes meta keywords for each topic. Suggestion: If user don't put tag on topic, rAthena management can point someone (moderator? board admin? community admin?) to just put tag for it. 3. Wiki Now, move to Wiki, well, I'm totally newbie on Wiki stuff, I just know how to editing stuff. The question is totally same, "Are wiki has config to defined the page's meta description and keywords?" or "Can contributor edit/add/remove those meta tags for each page?" Why? Try visit random rAthena's Wiki, let's see the source, Anyone good meta description and meta keywords? I tried, and got nothing. Suggestion: Hmm, maybe just same like above. 4. HTML Headings This is a weird one, try back on main page, and see, how many h1, h2, and h3 did you found? I got these - Main page - Topic page Suggestion: - For main page: put h1 for Web Title, h2 for web description h3 for category list - For topic, make h1 for topic title. 5. robots.txt rAthena board has the sitemap.xml* itself, but someone told me, better to "tell" the robots.txt the sitemap.xml* that it needs to crawl. the robots.txt doesn't have something like this. http://rathena.org/board/sitemap.xml 6. microformats I think we can make each topic is "authorized" by the poster's profile on Google+ Suggestion: I think for this board, not really a important stuff. 7. Google Webmaster And then, put the rAthena on Google Webmaster. What is it? I think almost everyone know and yeah, I heard there is staff here that minion of Google? But, is "it" alive? Don't ask me, even Google doesn't know. I bet IPB must be have SEO pack for their product. Why don't admin plays with SEO for better search result? If any question, why I discuss this issue, I just want rAthena is easy-to-find on search engine, so user that maybe has problem can easily search the question and find the answer. I've planned to make shared-knowledge about encounter issues about rAthena in FAQ page, so just for simply and familiar issues can be found easily, isn't easier the supporters or someone to support in each support board category? (I think I already make the suggestion/discussion topic about this idea, but I forget where is it). It will be pain to search if want to make something like this but no idea (or hard to find) the source page or issues. NOTE: - I never have my IPB (so rAthena or other who have it, can try the SEO stuffs for your better Board). - The SSs are from SEOquake Page Diagnosis (Chrome Extension, Firefox also has one)

how about? - script PCCALCEVENT -1,{ OnPCStatCalcEvent: if (checkoption(0x20) && (Class == Job_Lord_Knight || Class == Job_Paladin)) { dispbottom "here"; bonus bSpeedAddRate,5; } end; }

new item with bonus to remove required item. like, a card with bonus desc "This item remove xxxx item from all skills that requires xxxx item" ? bonus bNoRequireItem,<itemid>; here u go, bNoRequireItem-rA.diff If you interest to donate instead pay for it. feel free to contact me. Released on: bSkillNoRequire, bSkillNoRequireItem, bNoRequireAmmo

possible. Edit: not tested. pvp_damage_adjustments-rA.diff

there is message after it? what did u mean "see nothing"? no item picture, so u need proper client files https://github.com/ROClientSide/Translation

1 download = 1 pray