Sunzuki

You could use sql command: "SHOW COLUMNS FROM sometable"

1> ------ Build started new: Project: auto attack, Configuration: Debug Win32 ------ 1> C: Program Files (x86) MSBuild Microsoft.Cpp v4.0 Platforms Win32 Microsoft.Cpp.Win32.Targets (518.5): error MSB8008: The specified Plattformtoolset (v110) is not installed or invalid. Make sure that a supported PlatformToolset value was selected. ========== Rebuild All: 0 successful, error at 1, 0 skipped ========== can someone help me on this? if you need more information ask please. I assume it's the autoatk plugin from http://herc.ws/board/topic/2567-atcommand-autoatk/ since plugin-HPMHooking worked. I tried both but it didn't work. However HPMHooking works 1> ------ Build started new: Project: plugin-HPMHooking, Configuration: Debug Win32 ------ 1> HPMHooking.c 1> Library "plugin-HPMHooking Debug HPMHooking.lib" and object "plugin-HPMHooking Debug HPMHooking.exp" be created. 1> plugin-HPMHooking.vcxproj -> Z: server htdocs website server vcproj-10 .. plugins HPMHooking.dll ========== Rebuild All: 1 successful, skipped error at 0, 0 ========== basically I just selected the hercules projectmap and added autoatk from existing project

no it wouldn't. if it would work it would be .@tempvar$[0] = 1 .@tempvar$[1] = 2 you have to add more variables to the end. query_sql("SELECT * FROM `awesome_table` WHERE `ID`=1", .@ID, .@Name$, .@val1, .@val2, .@val3); .@ID[0] = 1; .@Name$[0] = Hi .@ID[1] = 2; .@Name$[0] = Hello basically you just put the columns (from after select, * = all) in the second part of the query_sql command $ because it is a string not an integer

and @ii and all still works?

when I use sql item db can I delete itemdb.txt?

I don't know for sure but try to remove 'ass' from data/manner.txt

- script OnInit -1,{end;OnInit: bindatcmd "monster2", "AtCommands::OnMonster2", <GM Level>, 99;end;}- script AtCommands -1,{end;OnMonster2: if(getarraysize(.@atcmd_parameters$) == 1) { set .@mobid,.@atcmd_parameters$[0]; monster ""+strcharinfo(3)+"",0,0,""+strmobinfo(1, .@mobid)+"",.@mobid,1; } else if(getarraysize(.@atcmd_parameters$) == 2) { set .@mobid,.@atcmd_parameters$[0]; set .@map$,.@atcmd_parameters$[1]; monster ""+.@map$+"",0,0,""+strmobinfo(1, .@mobid)+"",.@mobid,1; } else if(getarraysize(.@atcmd_parameters$) == 3) { set .@mobid,.@atcmd_parameters$[0]; set .@amount,.@atcmd_parameters$[1]; if(!.@amount) set .@amount,1; set .@map$,.@atcmd_parameters$[2]; monster ""+.@map$+"",0,0,""+strmobinfo(1, .@mobid)+"",.@mobid,.@amount; } else { message strcharinfo(0), "Wrong command format. Possible formats:"; message strcharinfo(0), " - @monster2 <Mob ID> <amount> <map>"; message strcharinfo(0), " - @monster2 <Mob ID> <map>"; message strcharinfo(0), " - @monster2 <Mob ID>"; message strcharinfo(0), "@monster2 failed."; }end;} It could basically work like that, but I'm not good of a coder and I don't know how to check if a monster ID or a map is valid. There will be a console message when someone enters invalid values I assume. Don't forget to change gm level if you use it

I wouldn't do that but what ever - script OnInit -1,{end;OnInit: freeloop(1); while(1) { killmonsterall "prt_maze02"; cleanmap "prt_maze02"; sleep 60*60*4*1000; } end;} maybe OnHour<hour>: event is a better choice

https://github.com/HerculesWS/Hercules/tree/master/npc/mapflag https://raw.githubusercontent.com/HerculesWS/Hercules/master/npc/mapflag/pvp.txt <map> mapflag pvp

suggest cashshop_db.conf - shop dynamicshop -1,501:222new_1-1,45,77,4 script Donation Shop 685,{ set .@currency, 7179; // pods mes "[Donation Shop]"; mes "What do you want to buy?"; next; switch(select("Headgears:Item Boost:etc") { //Headgears case 1: setarray .@items, 1750,1,1766,2; // Usage : <item id>,<price> break; //Item Boost case 2: setarray .@items, 1750,1,1766,2; // Usage : <item id>,<price> break; //etc case 3: setarray .@items, 1750,1,1766,2; // Usage : <item id>,<price> break; } npcshopitem "dynamicshop",0,0; for (set .@i, 0; .@i < getarraysize(.@items); set .@i, .@i + 2 ) npcshopadditem "dynamicshop",.@items[.@i], .@items[.@i+1]; callshop "dynamicshop",1; npcshopattach "dynamicshop"; end;OnBuyItem: for ( set .@j, 0; .@j < getarraysize(.@items); set .@j, .@j + 2 ) { for ( set .@k, 0; .@k < getarraysize(@bought_nameid); set .@k, .@k + 1 ) { if ( @bought_nameid[.@k] == .items[.@j] ) { if ( checkweight( @bought_nameid[.@k], @bought_quantity[.@k] ) ) { if ( countitem(.@currency) < .@items[.@j + 1] ) { mes "You don't have enough " +getitemname(.@currency)+ " to purchase this item."; close; } else { delitem .@currency, .@items[.@j + 1] * @bought_quantity[.@k]; getitem @bought_nameid[.@k], @bought_quantity[.@k]; dispbottom @bought_nameid[.@k]+" "+ .@items[.@j + 1]+" "+ .@currency; end; } } else dispbottom "You cannot carry out more items with you"; end; } } } deletearray @bought_quantity, getarraysize(@bought_quantity); deletearray @bought_nameid, getarraysize(@bought_nameid); end; OnInit: waitingroom "Donation Shop",0; end;}

are you aware of that? // Delay before removing mobs from empty maps (default 5 min = 300 secs)mob_remove_delay: 300000 https://raw.githubusercontent.com/HerculesWS/Hercules/master/conf/battle/monster.conf

so can anyone kindly convert it to a source edit? my hercules doesn't support plugins

after recompile it says im missing msvcr110d.dll on my pc. then the server says: HPM:plugin_load: failed to load 'plugins/autoattack.dll', skipping... I extracted it all into hercules and the file does exist at this path 1> C: Program Files (x86) MSBuild Microsoft.Cpp v4.0 Microsoft.CppBuild.targets (990.5): warning MSB8012: TargetPath (Z: RO Hercules-master vcproj-9 .. plugins plugin-sample.dll) does not correspond to the Output File property value (Z: RO Hercules-master plugins sample.dll) of linker. The project will therefore may not be created properly. Thus, this problem can be resolved, the property values ​​for $ (OutDir), $ (TargetName) and $ (TargetExt) must comply with the in% (Link.OutputFile) specified value.

Can someone convert this? http://rathena.org/board/topic/71297-autoattack/ Index: src/map/atcommand.c===================================================================--- src/map/atcommand.c (revision 17103)+++ src/map/atcommand.c (working copy)@@ -8563,10 +8563,66 @@ } return 0; }+static int buildin_autoattack_sub(struct block_list *bl,va_list ap)+{+ int *target_id=va_arg(ap,int *);+ *target_id = bl->id;+ return 1;+}+void autoattack_motion(struct map_session_data* sd)+{+ int i, target_id;+ for(i=0;i<=9;i++)+ {+ target_id=0;+ map_foreachinarea(buildin_autoattack_sub, sd->bl.m, sd->bl.x-i, sd->bl.y-i, sd->bl.x+i, sd->bl.y+i, BL_MOB, &target_id);+ if(target_id)+ {+ unit_attack(&sd->bl,target_id,1);+ break; + }+ target_id=0;+ }+ if(!target_id)+ {+ unit_walktoxy(&sd->bl,sd->bl.x+(rand()%2==0?-1:1)*(rand()%10),sd->bl.y+(rand()%2==0?-1:1)*(rand()%10),0);+ }+ return;+}+int autoattack_timer(int tid, unsigned int tick, int id, intptr_t data)+{+ struct map_session_data *sd=NULL; + sd=map_id2sd(id);+ if(sd==NULL)+ return 0;+ if(sd->sc.option & OPTION_AUTOATTACK)+ {+ autoattack_motion(sd);+ add_timer(gettick()+2000,autoattack_timer,sd->bl.id,0);+ }+ return 0;+}+ACMD_FUNC(autoattack)+{+ nullpo_retr(-1, sd);+ if (sd->sc.option & OPTION_AUTOATTACK)+ {+ clif_displaymessage(fd, "Auto-attack OFF");+ sd->sc.option &= ~OPTION_AUTOATTACK;+ unit_stop_attack(&sd->bl);+ }else+ {+ clif_displaymessage(fd, "Auto-attack ON");+ sd->sc.option |= OPTION_AUTOATTACK;+ add_timer(gettick()+200,autoattack_timer,sd->bl.id,0);+ }+ clif_changeoption(&sd->bl);+ return 0;+} ACMD_FUNC(accinfo) { char query[NAME_LENGTH];-+ if (!message || !*message || strlen(message) > NAME_LENGTH ) { clif_displaymessage(fd, msg_txt(1365)); // Usage: @accinfo/@accountinfo <account_id/char name> clif_displaymessage(fd, msg_txt(1366)); // You may search partial name by making use of '%' in the search, ex. "@accinfo %Mario%" lists all characters whose name contains "Mario".@@ -8828,6 +8884,7 @@ * Command reference list, place the base of your commands here **/ AtCommandInfo atcommand_base[] = {+ ACMD_DEF(autoattack), ACMD_DEF2("warp", mapmove), ACMD_DEF(where), ACMD_DEF(jumpto),Index: src/map/status.h===================================================================--- src/map/status.h (revision 17103)+++ src/map/status.h (working copy)@@ -1489,6 +1489,7 @@ // compound constants OPTION_DRAGON = OPTION_DRAGON1|OPTION_DRAGON2|OPTION_DRAGON3|OPTION_DRAGON4|OPTION_DRAGON5, OPTION_MASK = ~OPTION_INVISIBLE,+ OPTION_AUTOATTACK = 0x10000000, }; //Defines for the manner system [Skotlex] thanks to you

"unable to find configuration file, please type the configuration filename" the following didn't work: - config.default - config.default.json - configs/config.default - configs/config.default.json - config - default what it is