Sanasol

already in my todo

Some updates for latest week. To avoid downvotes for each "competitor" server by other servers admins, now possible to make only one downvote per 12hr. Upvotes still available for any servers amount every 12hr :3 Filters collapsed by default Added Thai language (Google translated )

Hi, Pleased to present work of my life last 4 days. Decide to remake my old server list, which were used by nobody actually I believe that it's next-gen top in comparison with other like xtremetop100 and etc. https://top.dsro.ru So actually almost nothing special. Player side: Search servers with any set of parameters(max lvl, stat, etc). Like or Dislike servers once per 12 hrs And ofc V4P Admin side: Add your server(s) Upload few banners Download and install FluxCP addon (hercules, rathena, eathena supported). Why DSRO/top.dsro.ru Just my very old domain, like it Sorting Sorting algo is one of most interesting parts(at least for me). Since we have up and down votes, we need something more than just sorting by total votes. Server rank calculated with algo that called: Lower bound of Wilson score confidence interval for a Bernoulli parameter Max rank is about 95(%). FluxCP Addon You can easily install addon to any of FluxCP version. Then you need just put your server ID in config file(/dsro/config/addon.php). And configure reward type and amount(#CASHPOINTS or FluxCP internal credits) And most interesting part - players will not leave your site even. Addon makes integration through iframe. So players voting inside your site and get reward instantly. Notice: player get reward only in case positive vote So you reach end of post, thank you. I'm still working on it and will try to make it better. And i believe that you will use it for your own servers and help me distribute it over players Feedback is very welcome. Skype: sanasol2008 Telegram: @Sanasol (https://telegram.me/Sanasol) Email: [email protected] Hope it will help find some players for your server

1. I think this can be done by simple script OnNPCKillEvent:if (killedrid == MOB ID && !loyaMOB ID){ if(killed_mobs_MOB ID < 100) { set killed_mobs_MOB ID,killed_mobs_MOB ID+1; } else { set loyaMOB ID,1; }}end; 2. I will think about this, but it too depends on your script, how you will code it also i want do one variable for all 'loyaltys', using bitmask. Good day Sir @@Sanasol ​ I know this is quite an old post of yours Sir.. but I must say that this is so nice.. I really hope that if you have your spare time that maybe you can improve this project of yours. Let just say an idea that when you reach the acquired amount or value that Sir @evilpunker state.. then a Monster that you gain its Loyalty will truly help to fight other monster for you. . some kind of a Pet or Homunculus that helps fight in battle. hehehe.. just a fun idea though.. May you have a great week wherever you are. It should be something like AI for homunc or mob AI on server, but homunc. mostly controlled by client. So i dont know how it can be done.

no you wiil need get other addon version.

Yommy have addon for web site? I have no information about it. I thought that's what this is: I assumed you and Yommy both had your own source, standalone, and fluxcp plugin. Maybe I am just misunderstanding. =( EDIT: They all point to different repos on GitHub. yes, you get confused I have my variant of source code for server. And fluxcp addon which work with my sources. Yommy coded other variant of source, which work different but doing same function. Then i modified my fluxcp addon for compatibility with Yommy sources. So, yommy's src easier to install coz plugin. Thats why i strongly commend install it(yommy's plugin) and install my fluxcp addon(if you need it on site ofc) I hope now its clear, coz english not my native

Yommy have addon for web site? I have no information about it.

just different src. yommy's src plugin for herc my src for herc/rathena. and not as plugin better use yommy plugin(easier) and my addon for site it also support yommy's src Yommy src versions: Standalone or FluxCP

nope, i havent

1. I think this can be done by simple script OnNPCKillEvent:if (killedrid == MOB ID && !loyaMOB ID){ if(killed_mobs_MOB ID < 100) { set killed_mobs_MOB ID,killed_mobs_MOB ID+1; } else { set loyaMOB ID,1; }}end; 2. I will think about this, but it too depends on your script, how you will code it also i want do one variable for all 'loyaltys', using bitmask.

here many variants. easy quest bypsasing when many aggressive monsters can kick your ass, easy mvp kill and other And of course loyalty should be set only after doing some actions(quests). Something like Kill 10 players and Orc Warrior will be your friend

Have you ever wanted to be friends with aggressive monsters? Now its possible /oops This mod adds little check for aggressive monsters, they will not attack you if you have certain status(char variable). But they will attack if you start first. Source and demo script: GitHub How to: If you want set some monster loyal to character just set loyalty var to 1 For example: set loya1785,1; // Where 1785 is monster id -> Atroce in this case Atroce will ignore you until you start hit it. Then you can back it to normal state by set 0 set loya1785,0; // Where 1785 is monster id -> Atroce In this case atroce will attack you as usual

solved sql_logs: yes

void log_woe_kill(struct map_session_data *ssd, struct map_session_data *tsd, int skill){ ShowDebug("var ssd: %dn", ssd->status.char_id); ShowDebug("var tsd: %dn", tsd->status.char_id); ShowDebug("var map: %sn", map->list[tsd->bl.m].name); ShowDebug("var skill: %dn", skill); if (SQL_ERROR == SQL->Query(logs->mysql_handle, "INSERT DELAYED INTO `char_woe_kills` (`time`,`killer_id`,`killed_id`,`map`,`skill`) VALUES (NOW(), '%d', '%d', '%s', '%d')", ssd->status.char_id, tsd->status.char_id, map->list[tsd->bl.m].name, skill)) { ShowDebug("oh god its errorn"); Sql_ShowDebug(logs->mysql_handle); return; }} void log_woe_kill(struct map_session_data *ssd, struct map_session_data *tsd, int skill){ ShowDebug("var ssd: %dn", ssd->status.char_id); ShowDebug("var tsd: %dn", tsd->status.char_id); ShowDebug("var map: %sn", map->list[tsd->bl.m].name); ShowDebug("var skill: %dn", skill); SqlStmt* stmt; stmt = SQL->StmtMalloc(logs->mysql_handle); if (SQL_SUCCESS != SQL->StmtPrepare(stmt, "INSERT DELAYED INTO `char_woe_kills` (`time`,`killer_id`,`killed_id`,`map`,`skill`) VALUES (NOW(), '%d', '%d', '%s', '%d')", ssd->status.char_id, tsd->status.char_id, map->list[tsd->bl.m].name, skill) || SQL_SUCCESS != SQL->StmtExecute(stmt)) { ShowDebug("oh god its errorn"); SqlStmt_ShowDebug(stmt); SQL->StmtFree(stmt); return; } SQL->StmtFree(stmt);} both versions same error... any ideas how resolve this? [Debug]: var ssd: 150000 [Debug]: var tsd: 150001 [Debug]: var map: prtg_cas01 [Debug]: var skill: 84 [Debug]: oh god its error [Debug]: at log.c:185 - self is NULL [Debug]: var ssd: 150001 [Debug]: var tsd: 150000 [Debug]: var map: prtg_cas01 [Debug]: var skill: 490 [Debug]: oh god its error [Debug]: at log.c:185 - self is NULL

http://rathena.org/board/topic/86685-critical-updateweb-vending-database-standalone-and-fluxcp-addon/