Brian

I know the +/- part is working as intended, I was just wondering if we could add some code to sum up the time, and if the overall time is negative (effectively reducing the ban), then only allow it if they have permission to use @unban? This would prevent GMs who don't have @unban from using @ban <negative number> to un-ban someone.

BuildBot doesn't want to share yet.

your WAN IP

"I host the server by myself" so that means MySQL Server (and rAthena) are running on your computer. "the host of the Control Pannel is a free website host" that means CeresCP (and your website) will be running on another computer. When your run the MySQL Administrator tool from your computer, it can connect to 'localhost' or 127.0.0.1 or your LAN IP (maybe something like 192.168.*.*) because it's local. When another computer on the Internet connects to your MySQL Server, they need to use your WAN IP, and make sure you check all of these things:

_ _ ___ ____ | || | ( _ ) ___| | || |_ / _ ___ |__ _| (_) |__) | |_| ___/____/

Suggestion: change @ban to only allow negatives if their GM level has privilege to use @unban http://www.eathena.w...er&showbug=5125

483 !

To get the rAthena files, you do a SVN Checkout (read here: SVN#Checkout). Then follow one of the Category:Installation guides to setup rAthena.

So MySQL is on your local computer right? Are you using your WAN IP for "MySQL Server IP" when you install CeresCP? Did you configure your router to forward port 3306 to your computer? Ask your webhost if they allow outgoing connections on port 3306.

For guild name, there is a script command: getguildname mes "Guild name:"; mes getguildname(getcharid(2));

Turn 'cell_novending' ON on the whole prontera map. Then turn cell_novending off on that area to allow vending there. - script prontera_vending -1,{ OnInit: setcell "prontera", 0,0, 400,400, cell_novending,1; setcell "prontera", 146,159, 146,148, cell_novending,0; end; } and this wiki page explains Adding_a_Script

Create a script that uses OnInit to trigger a series of setcell that turn cell_novending ON for that area. *setcell "<map name>",<x1>,<y1>,<x2>,<y2>,<type>,<flag>; Each map cell has several 'flags' that specify the properties of that cell. These include terrain properties (walkability, shootability, presence of water), skills (basilica, land protector, ...) and other (NPC nearby, no vending, ...). Each of these can be 'on' or 'off'. Together they define a cell's behavior. This command lets you alter these flags for all map cells in the specified (x1,y1)-(x2,y2) rectangle. The 'flag' can be 0 or 1 (0:clear flag, 1:set flag). The 'type' defines which flag to modify. Possible options include cell_walkable, cell_shootable, cell_basilica. For a full list, see const.txt. Example: setcell "arena",0,0,300,300,cell_basilica,1; setcell "arena",140,140,160,160,cell_basilica,0; setcell "arena",135,135,165,165,cell_walkable,0; setcell "arena",140,140,160,160,cell_walkable,1; This will add a makeshift ring into the center of the map. The ring will be surrounded by a 5-cell wide 'gap' to prevent interference from outside, and the rest of the map will be marked as 'basilica', preventing observers from casting any offensive skills or fighting among themselves. Note that the wall will not be shown nor known client-side, which may cause movement problems. Another example: OnBarricadeDeploy: setcell "schg_cas05",114,51,125,51,cell_walkable,0; end; OnBarricadeBreak: setcell "schg_cas05",114,51,125,51,cell_walkable,1; end; This could be a part of the WoE:SE script, where attackers are not allowed to proceed until all barricades are destroyed. This script would place and remove a nonwalkable row of cells after the barricade mobs. If you want to disable vending on the whole map, use the novending mapflag prontera mapflag novending

I am not sure if rAthena has plans to re-add this, but if you want to add it yourself, this topic on eAthena explains more: eAthena IRC Module, from r13014.

hi Asharl !!! =]

Share Ratio over 200! =D

/npc/merchants/shops.txt xmas,152,137,5 shop Chef Assistant#xmas 83,7457:-1,577:-1

Did you recently level up to 50? since we are querying SQL, there is a slight delay. The map-server saves guild info every 60 seconds (or whatever you have autosave_time set to).

WHERE `char_id` = ^ this implicitly limits it to only returning 1 row, because char_id are unique, so for 1 char_id you will get 1 name. This example will create a new function that looks up char_id --> name: prontera,155,188,0 script GuildLevel50 910,{ function charid2name; mes "char_id: 150000"; mes "name: " + charid2name(150000); close; function charid2name { if (query_sql("SELECT `name` FROM `char` WHERE `char_id`="+getarg(0), .@name$) == 1) return .@name$; else return "null"; } } What does your ladder script look like? maybe we could write a SQL query to directly fetch the Top 10 names as an array.

prontera,155,188,0 script GuildLevel50 910,{ query_sql "SELECT guild_lv FROM guild WHERE guild_id = "+getcharid(2), .@guild_lv; mes "hi bla"; if (getcharid(2) == 0) { mes "You are not in a guild."; } else if (.@guild_lv < 50) { mes "you cant use this service"; mes "Your guild must be level 50."; } else { warp "bla",0,0; } close; } @Nokia: your example isn't working because .@guild_id isn't set, so it's 0. Then your 'query_sql' looks up the guild_lv for guild_id 0 (which doesn't exist). Try the full script Aleos posted, or the example I posted above.

r15009 PS: you should switch to rAthena =D How to relocate to the SourceForge SVN

Click the ▶ arrow next to Tables. This should expand the list of tables, then you can click or right-click a specific table for more options.

Chrome! Costco or WalMart?

What about the "Gym Pass" system? ../trunk/npc/other/gympass.txt

I am not as pro as the map-server, but I see one error! mes "Do you, "+strcharinfo(0)" accept to join the Good Force?"; missing string concatenation (+ symbol) should be: mes "Do you, "+strcharinfo(0)+" accept to join the Good Force?";

Maybe a better way would be OnPCDieEvent --> randomize their savepoint (if they save on the map "prontera"). OnPCDieEvent: setarray .x[0], 50,60,70,80,90; setarray .y[0], 50,60,70,80,90; if (getsavepoint(0) == "prontera") { set .@i, rand(getarraysize(.x)); savepoint "prontera", .x[.@i], .y[.@i]; } end; With the script llchrisll posted, that will warp them instantly when they die.