Panny

Thanks Brian, tried your script however the NPC loads but it isnt clickable. What may cause this?

I dont want it to show the ID so would it be this? prontera,150,83,4 script Event Names 814{ set .@sql = query( "SELECT `name` FROM `event` ",.@name$ ); mes "[Event Names]" for(set .@i = 0; .@i < .@sql; .@i++ ) mes "Name : "+.@name$[.@i]; close; }

Hello, i have a SQL table called event and in there is fields called id and name. How do i implament it into an NPC so it shows all the names stored in the 'event' database? Also maybe in Alphabetical Order?. Example; Name 1 Name 2 Name 3 etc

Okay wasn't getting any response in the DB section so maybe i need to place it here in this section. I want to create a monster that only receive 1 damage per hit. So I've gone for mode 64 as its a plant but it wont take magic attacks, keeping saying missed, when i change the mode it takes magic attacks fine. How would i do it so it also receives magic damage but also at 1 per hit?

hmmm ?? Bump!!

Hey so i want to create a monster that only recieve 1 damage per hit. So ive gone for mode 64 as its a plant but it wont take magic attacks, keeping saying missed, when i change the mode it takes magic attacks fine. How would i do it so it also recieves magic damage but also at 1 per hit? Bump ?? Bump! This not possible?

Hey guys, I've now fully converted from eAthena to rAthena but there are a few small issues i can not seem to resolve. @autotrade wont work, says you can not do it on the map. FIXED Mobs dont have HP with there name even though i have the setting enabled. I have a goldroom and since the convert, players can no longer cast magic on my goldroom mobs. it works but just keeps missing. How would i go by fixing these issues? Thank you.

How do i make the cooldown go from 1 week to 48 hours ?

Thanks guys, that all sorted but now im having an issue with my custom maps. Its not letting me warp to them and this is the info from putty. I have added my maps to the map_index.txt in the db folder and also the maps_athena.conf in the conf folder. Any suggestions? Doesn't it read from map_cache.dat anymore? i have a custom Prontera City that's not letting me walk in certain places , normally i just update the map_cache.dat file and it works fine. NEVER MIND, FIGURED IT OUT Im having a few other problems now, how do i fix these?

Can someone tell me the steps for this ? Also is there a setting to totally disable the renewal stuff, i don't mind the mobs, items, maps, NPC's i just don't want to use the 3rd jobs (just wont add them to job changer and disable the QUEST NPC's) but i mean like the stats, drops, skills, item effects etc i want all pre-renewal.

Im using eAthena :/ any ways to do this on that system?

I am sorry for posting again here but im having a problem with the script when starting the server via putty. parse_callfunc: expected ')' to close argument list 46 : { 47 : 48 : //-------------------------------------------------- 49 : 50 : if(BaseLevel < 50) goto L_DENIED; * 51 : if ( query_sql( "SELECT 1 FROM itemperIP WHERE last_ip = '"+ getcharip'(') +"'", .@dummy ) ) goto error; Any ideas where i need to put the missing ) Regards,

perfect, thank you ever so much.

Because the NPC loads every 6 hours and players tend to login 2/3/4 accounts, there is a 10 second timer on the NPC to collect items, so adding the IP will stop them from using the NPC on more than 1 account then once collected it clears it ready for the NPC again 6 hours later.

so it would be?? query_sql "DELETE FROM itemperip WHERE last_ip=( '"+ getcharip() +"' )"; Im new to this sorry if it looks so bad haha query_sql "insert into itemperip values ( '"+ getcharip() +"' )"; dispbottom "here is your item"; getitem 501,1; query_sql "DELETE FROM itemperip WHERE last_ip= ( '"+ getcharip() +"' )"; EDIT for above ... Im only asking a question and for a little help, why be so bitchy about it?