jTynne
-
Content Count
249 -
Joined
-
Last visited
-
Days Won
10
Posts posted by jTynne
-
-
You did something wrong, then.
Place the first bit of code right above:
/** * Fills the reference of available commands in atcommand DBMap **/
The second bit of code, further down in the file, like so:ACMD_DEF(channel), ACMD_DEF(fontcolor), ACMD_DEF(searchstore), ACMD_DEF(costume), ACMD_DEF(afk),
Works fine for me when placed in the correct location. /wah -
/*==========================================* @afk by Rad, built on by Tubby * same as autotrade, but works without vending*------------------------------------------*/int atcommand_afk(const int fd, struct map_session_data* sd, const char* command, const char* message){nullpo_retr(-1, sd);if( map[sd->bl.m].flag.autotrade == battle_config.autotrade_mapflag ){if (!message || !*message) {chat_createpcchat(sd, "(@afk) Away", "", 1, 1);trade_tradeack(sd,4);sd->state.autotrade = 1;if( battle_config.at_timeout ){int timeout = atoi(message);status_change_start(&sd->bl, SC_AUTOTRADE, 10000, 0, 0, 0, 0, ((timeout > 0) ? min(timeout,battle_config.at_timeout) : battle_config.at_timeout) * 60000, 0);}clif_authfail_fd(fd, 15);}if((strlen(message) < 0)||(strlen(message) > 36)) {chat_createpcchat(sd, "(@afk) Away", "", 1, 1);trade_tradeack(sd,4);sd->state.autotrade = 1;if( battle_config.at_timeout ){int timeout = atoi(message);status_change_start(&sd->bl, SC_AUTOTRADE, 10000, 0, 0, 0, 0, ((timeout > 0) ? min(timeout,battle_config.at_timeout) : battle_config.at_timeout) * 60000, 0);}clif_authfail_fd(fd, 15);}chat_createpcchat(sd, message, "", 1, 1);trade_tradeack(sd,4);sd->state.autotrade = 1;if( battle_config.at_timeout ){int timeout = atoi(message);status_change_start(&sd->bl, SC_AUTOTRADE, 10000, 0, 0, 0, 0, ((timeout > 0) ? min(timeout,battle_config.at_timeout) : battle_config.at_timeout) * 60000, 0);}clif_authfail_fd(fd, 15);} elseclif_displaymessage(fd, "AFK is not allowed on this map.");return 0;}And also addACMD_DEF(afk),
Into src/map/atcommand.cThere's some plugin version floating around that I've not been able to get working.
-
Update your item database friend.
-
This release is for Hercules, and is essentially a "work in progress", however, I wanted to give this to Hercules to inspire users to not only make use of this, but to complete it, make it better, and find use for it.
What's Included?
This release has the display name table, resname table, description table, and SQL inserts for all current headgears listed in the Hercules database for headgears that equip to either the "top" "mid" or "low" slots. I've NOT included headgears that equip to multiple locations in this release simply because it's 2am and I'm tired at the time I'm releasing this.
What you need to do in order to get this to work on YOUR server.
1. Import the SQL inserts via phpMyAdmin or an equivalent. If you don't know how to do that, ask here and hopefully someone will answer your question if I'm not around to answer it. Then, go in-game and @reloaditemdb.
2. Copy/paste each of the resname/displayname/desctable entries into YOUR clientside files with those same names. Open your game client and voila.
Notes:
1. A LOT of these are blank sprited. Why? Because I didn't think to import the resname table I had from kRO when I made these for v1.0. I'll redo that later when I feel like it. (Or, you can if you're not lazy!)
2. You'll see a LOT of "repeated" headgears; I simply pulled the data from the SQL database to generate these files. You can add/delete items at your discretion.
3. This uses ID's 30,000 to roughly 31,000. If you have items in that range, well I guess you're SOL. #sorrynotsorry
4. This is for clients prior to the nifty LUA crap that includes all the client-side data into one file. If you want to convert these to be used for that, feel free, but I won't be doing it myself until I update my own client that I use to a 2013 client. If you want this to happen sooner than later, pressure Sirius_White into getting 2013 clients working with Harmony. #deadsrs
The intention of this release is as stated before, to inspire individuals to CREATE and expand upon this system. I've not included an NPC to distribute these headgears. If you want to do that, feel free.
Here's basic code to sell every headgear for 50 Cash Points; You'll need to place them on a map of your choice, however:
jtynne01,42,51,4 cashshop Costume Headgears#1 91,30000:50,30001:50,30002:50,30003:50,30004:50,30005:50,30006:50,30007:50,30008:50,30009:50,30010:50,30011:50,30012:50,30013:50,30014:50,30015:50,30016:50,30017:50,30018:50,30019:50,30020:50,30021:50,30022:50,30023:50,30024:50,30025:50,30026:50,30027:50,30028:50,30029:50,30030:50,30031:50,30032:50,30033:50,30034:50,30035:50,30036:50,30037:50,30038:50,30039:50,30040:50,30041:50,30042:50,30043:50,30044:50,30045:50,30046:50,30047:50,30048:50,30049:50,30050:50,30051:50,30052:50,30053:50,30054:50,30055:50,30056:50,30057:50,30058:50,30059:50,30064:50,30065:50,30066:50,30067:50,30068:50,30069:50,30070:50,30071:50,30072:50,30073:50,30074:50,30075:50,30076:50,30077:50,30078:50,30079:50,30080:50,30081:50,30082:50,30083:50,30084:50,30085:50,30086:50,30087:50,30088:50,30089:50,30091:50,30092:50,30093:50,30094:50,30095:50,30096:50,30097:50,30098:50,30099:50,30109:50,30110:50,30111:50,30112:50,30113:50jtynne01,43,51,4 cashshop Costume Headgears#2 91,30114:50,30115:50,30116:50,30117:50,30118:50,30119:50,30120:50,30121:50,30122:50,30123:50,30124:50,30125:50,30126:50,30127:50,30128:50,30129:50,30130:50,30131:50,30132:50,30133:50,30134:50,30135:50,30136:50,30137:50,30138:50,30139:50,30140:50,30141:50,30142:50,30143:50,30144:50,30145:50,30146:50,30147:50,30148:50,30149:50,30150:50,30151:50,30152:50,30153:50,30154:50,30155:50,30156:50,30157:50,30158:50,30159:50,30160:50,30161:50,30162:50,30163:50,30164:50,30165:50,30166:50,30167:50,30168:50,30169:50,30170:50,30171:50,30172:50,30173:50,30174:50,30175:50,30176:50,30177:50,30178:50,30179:50,30180:50,30181:50,30182:50,30183:50,30184:50,30185:50,30186:50,30187:50,30188:50,30189:50,30190:50,30191:50,30192:50,30193:50,30194:50,30195:50,30196:50,30197:50,30198:50,30199:50,30200:50,30201:50,30202:50,30203:50,30204:50,30205:50,30206:50,30207:50,30208:50,30209:50,30210:50,30211:50,30212:50,30213:50jtynne01,44,51,4 cashshop Costume Headgears#3 91,30214:50,30215:50,30216:50,30217:50,30218:50,30219:50,30220:50,30221:50,30222:50,30223:50,30224:50,30225:50,30226:50,30227:50,30228:50,30229:50,30230:50,30231:50,30232:50,30233:50,30234:50,30235:50,30236:50,30237:50,30238:50,30239:50,30240:50,30241:50,30242:50,30243:50,30244:50,30245:50,30246:50,30247:50,30248:50,30249:50,30250:50,30251:50,30252:50,30253:50,30254:50,30255:50,30256:50,30257:50,30258:50,30259:50,30260:50,30261:50,30262:50,30263:50,30264:50,30265:50,30266:50,30267:50,30268:50,30269:50,30270:50,30271:50,30272:50,30273:50,30274:50,30275:50,30276:50,30277:50,30278:50,30279:50,30280:50,30281:50,30282:50,30283:50,30284:50,30285:50,30286:50,30287:50,30288:50,30289:50,30290:50,30291:50,30292:50,30293:50,30294:50,30295:50,30296:50,30297:50,30298:50,30299:50,30300:50,30301:50,30302:50,30303:50,30304:50,30305:50,30306:50,30307:50,30308:50,30309:50,30310:50,30311:50,30312:50,30313:50jtynne01,45,51,4 cashshop Costume Headgears#4 91,30314:50,30315:50,30316:50,30317:50,30318:50,30319:50,30320:50,30321:50,30322:50,30323:50,30324:50,30325:50,30326:50,30327:50,30328:50,30329:50,30330:50,30331:50,30332:50,30333:50,30334:50,30335:50,30336:50,30337:50,30338:50,30339:50,30340:50,30341:50,30342:50,30343:50,30344:50,30345:50,30346:50,30347:50,30348:50,30349:50,30350:50,30351:50,30352:50,30353:50,30354:50,30355:50,30356:50,30357:50,30358:50,30359:50,30360:50,30361:50,30362:50,30363:50,30364:50,30365:50,30366:50,30367:50,30368:50,30369:50,30370:50,30371:50,30372:50,30373:50,30374:50,30375:50,30376:50,30377:50,30378:50,30379:50,30380:50,30381:50,30382:50,30383:50,30384:50,30385:50,30386:50,30387:50,30388:50,30389:50,30390:50,30391:50,30392:50,30393:50,30394:50,30395:50,30396:50,30397:50,30398:50,30399:50,30400:50,30401:50,30402:50,30403:50,30404:50,30405:50,30406:50,30407:50,30408:50,30409:50,30410:50,30411:50,30412:50,30413:50jtynne01,46,51,4 cashshop Costume Headgears#5 91,30414:50,30415:50,30416:50,30417:50,30418:50,30419:50,30420:50,30421:50,30422:50,30423:50,30424:50,30425:50,30426:50,30427:50,30428:50,30429:50,30430:50,30431:50,30432:50,30433:50,30434:50,30435:50,30436:50,30437:50,30438:50,30439:50,30440:50,30441:50,30442:50,30443:50,30444:50,30445:50,30446:50,30447:50,30448:50,30449:50,30450:50,30451:50,30452:50,30453:50,30454:50,30455:50,30456:50,30457:50,30458:50,30459:50,30460:50,30461:50,30462:50,30463:50,30464:50,30465:50,30466:50,30467:50,30468:50,30469:50,30470:50,30471:50,30472:50,30473:50,30474:50,30475:50,30476:50,30477:50,30478:50,30479:50,30480:50,30481:50,30482:50,30483:50,30484:50,30485:50,30486:50,30487:50,30488:50,30489:50,30490:50,30491:50,30492:50,30493:50,30494:50,30495:50,30496:50,30497:50,30498:50,30499:50,30500:50,30501:50,30502:50,30503:50,30504:50,30505:50,30506:50,30507:50,30508:50,30509:50,30510:50,30511:50,30512:50,30513:50jtynne01,47,51,4 cashshop Costume Headgears#6 91,30514:50,30515:50,30516:50,30517:50,30518:50,30519:50,30520:50,30521:50,30522:50,30523:50,30524:50,30525:50,30526:50,30527:50,30528:50,30529:50,30530:50,30531:50,30532:50,30533:50,30534:50,30535:50,30536:50,30537:50,30538:50,30539:50,30540:50,30541:50,30542:50,30543:50,30544:50,30545:50,30546:50,30547:50,30548:50,30549:50,30550:50,30551:50,30552:50,30553:50,30554:50,30555:50,30556:50,30557:50,30558:50,30559:50,30560:50,30561:50,30562:50,30563:50,30564:50,30565:50,30566:50,30567:50,30568:50,30569:50,30570:50,30571:50,30572:50,30573:50,30574:50,30575:50,30576:50,30577:50,30578:50,30579:50,30580:50,30581:50,30582:50,30583:50,30584:50,30585:50,30586:50,30587:50,30588:50,30589:50,30590:50,30591:50,30592:50,30593:50,30594:50,30595:50,30596:50,30597:50,30598:50,30599:50,30600:50,30601:50,30602:50,30603:50,30604:50,30605:50,30606:50,30607:50,30608:50,30609:50,30610:50,30611:50,30612:50,30613:50jtynne01,48,51,4 cashshop Costume Headgears#7 91,30614:50,30615:50,30616:50,30617:50,30618:50,30619:50,30620:50,30621:50,30622:50,30623:50,30624:50,30625:50,30626:50,30627:50,30628:50,30629:50,30630:50,30631:50,30632:50,30633:50,30634:50,30635:50,30636:50,30637:50,30638:50,30639:50,30640:50,30641:50,30642:50,30643:50,30644:50,30645:50,30646:50,30647:50,30648:50,30649:50,30650:50,30651:50,30652:50,30653:50,30654:50,30655:50,30656:50,30688:50,30689:50,30690:50,30691:50,30692:50,30693:50,30694:50,30695:50,30696:50,30697:50,30698:50,30699:50,30700:50,30701:50,30702:50,30703:50,30704:50,30705:50,30706:50,30707:50,30708:50,30709:50,30710:50,30711:50,30712:50,30713:50,30714:50,30715:50,30716:50,30717:50,30718:50,30719:50,30720:50,30721:50,30722:50,30723:50,30724:50,30725:50,30726:50,30727:50,30728:50,30729:50,30730:50,30731:50,30732:50,30733:50,30734:50,30735:50,30736:50,30737:50,30738:50,30739:50,30740:50,30741:50,30742:50,30743:50,30744:50jtynne01,49,51,4 cashshop Costume Headgears#8 91,30745:50,30746:50,30747:50,30748:50,30749:50,30751:50,30752:50,30753:50,30754:50,30755:50,30756:50,30757:50,30758:50,30759:50,30760:50,30762:50,30763:50,30764:50,30765:50,30768:50,30769:50,30770:50,30771:50,30774:50,30775:50,30781:50,30784:50,30786:50,30789:50,30790:50,30802:50,30803:50,30804:50,30806:50,30807:50,30810:50,30811:50,30812:50,30813:50,30814:50,30819:50,30822:50,30839:50,30845:50,30858:50,30897:50,30898:50,30899:50,30900:50,30901:50,30902:50,30903:50,30904:50,30905:50,30906:50,30907:50,30908:50,30909:50,30910:50,30911:50,30912:50,30913:50,30914:50,30915:50,30916:50,30917:50,30918:50,30919:50,30920:50,30921:50,30922:50,30923:50,30924:50,30925:50,30926:50,30927:50,30928:50,30929:50,30930:50,30931:50,30932:50,30933:50,30934:50,30935:50,30936:50,30937:50,30938:50,30939:50,30940:50,30941:50,30942:50,30943:50,30944:50,30945:50,30948:50,30949:50,30950:50,30951:50,30952:50,30953:50,30954:50,30955:50,30956:50,30957:50,30958:50,30959:50,30960:50,30961:50,30962:50,30963:50,30965:50,30966:50,30967:50,30968:50,30969:50,30970:50,30976:50
If you find this useful, please +1 this post, go to my profile here on Hercules and rate me five stars.Questions? Post 'em here! Enjoy~
-
Figured it out, XD Excel works wonders sometimes. Sorry. XD
-
Hello friends!
I'm wanting to create a costume package release here on Hercules for all official headgears. I already have an idea of how I'd like to generate the client-side files, but what I'm having difficulty with is taking the ASCII from the idnum2resnametable.txt and placing it within an SQL database (to later be extracted to generate the client-side files).
Originally I thought I'd be able to simply do a quick macro with the text editor I use to create sql inserts to insert the ASCII name found in the .txt file into a database table, to then use php/sql to extract this "resname" field to generate new inserts for use client-side.
If anyone could help, I'd be most appreciative, as this is the only foreseeable issue I'm having in generating this release for public release. I basically just need instructions on how to take the data from the idnum2resnametable.txt and import it into a new field in the item_db_re sql table, to later be extracted in a generation script.
Thank you in advance!
-
Very nice! Thank you for the release KeyWorld!
-
sc_start4 sc_spirit, 900000, 5, .@spirit,0,0;
It should be SC_SOULLINK instead of sc_spirit.
-
I second that notion @ OnNplay; I've made use of this since.. gosh, at least 2010? /heh
-
Welcome!
-
There was a command similar to this I used years ago on eA that basically checked the IP of everyone on the map the command was used on, and would tell you if there were duplicates, the player names with duplicate IP addresses, and their coordinates/other class details.
Another awesome addition to this would be @samemac for those running Hercules
Even further, simply a script command that could do this? I'd eat this up if it's ever released/written for Herc.
-
Can't seem to get custom additions to the Old_Card_Album to load in-game.
-
I've added "afk" to the /conf/plugins.conf, added the afk.c to src/plugins/, recompiled and started the server, and when used in-game, says the command doesn't exist. Am I missing something..?
-
Happy Birthday bb! <3
-
Sanity check would be fabulous. +1 at Yommy's suggestion. I like where this is going. It'd be nice to use a single tool to update client-side files rather than tabbing back and forth.
-
Having problems putting skill points into -anything- after this commit.
-
I uploaded them last week sometime after they were released in their original format/filenames to: http://www.casualro.com/gm/jtynne/kRO/ Totally forgot, sorry! ;;
-
Delicious!
-
That's how they're stored, and that's their storage method @ Xgear, it's strange. @_@; They're storing as the same value despite resembling nothing like a mac address, though, so I suppose it's fine? @_@;
-
It did! Thank you! I have it working now as I'd like, however, I do have a new issue.
For some reason, last_ip and last_mac are storing as a large number instead of a string when I use,
query_sql ("SELECT `last_mac` FROM `login` WHERE `account_id` = '"+getcharid(3)+"'", @mac$);
The @mac$ variable outputs like, 392859820935823. Not sure why that is..?
-
As the title suggests, I need a bit of code that will stop a script if the invoking character's "last_mac" column from login table.. using Harmony.. has two or more clients on the same map.
Currently, I have it set up that when a player enters the event map, it inserts their MAC address into a database named "woe_records", and then continues on to another bit of code which awards participation points every 30 seconds they're on the event map.
What I need is for said script to stop running if there are two or more players on the current map who share the same MAC adress.
Below is the current script:
aldeg_cas02,1,1,1 script aldeg_cas02#timer -1,{OnPCLoadMapEvent:getmapxy (.@map$, .@x, .@y, 0); if(agitcheck() > 0 && .@map$ == "aldeg_cas02" && gettime(4) == 0) {dispbottom "[WoE] Welcome to the War of Emperium. You will gain participation points for every 30 seconds you're on the map based on the number of players also in the castle. Good luck!";attachnpctimer;initnpctimer;}end; OnTimer30000:getmapxy (.@map$, .@x, .@y, 0); if(.@map$ != "aldeg_cas02") {detachnpctimer;stopnpctimer;end;}if(agitcheck() > 0 && .@map$ == "aldeg_cas02" && gettime(4) == 0) {detachnpctimer;set $aldeg_particip,getmapusers("aldeg_cas02")/2;set #woe_particip,#woe_particip+$aldeg_particip;stopnpctimer;dispbottom "[WoE] You've earned "+$aldeg_particip+" WoE participation points for being on the map for 30 seconds! You now have "+#woe_particip+" participation points.";attachnpctimer;initnpctimer;end;}} aldeg_cas02 mapflag loadevent -
Have the effects of these been released anywhere yet?
-
Hi2u sexy man.
-
battle.c: In function âbattle_calc_misc_attackâ:battle.c:3586: error: expected â)â before â_int64âbattle.c:3586: warning: right shift count >= width of typemake[1]: *** [obj_sql/battle.o] Error 1make[1]: Leaving directory `/home/Hercules/src/map'make: *** [map_sql] Error 2Won't compile for me now XD
Setting up a proxy server in Europe/Asia to reduce latency for US-based RO server.
in General Server Support
Posted
Hi!
I've had several friends with large-scale servers tell me that they make usage of a second server hosted in the UK they use to pipe traffic through for a lower latency for their overseas community, as their main "host" server is located in the US. I'd heard many years ago of others doing such a thing as well, but I don't know where to begin with this at all.
Any assistance or guiddance in the right direction would be absolutely fantastic, as I feel this is a way those of us with large international playerbases can truly help reduce latency for them, when we host our servers in the Americas.
Thanks in advance!