Leaderboard

This topic is about unreleased features. The achievement system is already available in a pull request(https://github.com/rathena/rathena/pull/2044) and will probably be merged to master soon. *pokes @Aleos* There will be other goals as well so if the goal has been reached you can donate towards the next one next week. Thanks for your support!

Over the last few months there has been a significant drop in donations (4 donations since March), so some of our staff have been paying our monthly running costs as well as developing awesomeness for your servers. So, in an effort to keep our forums running on great hardware and to finally (hopefully) give us the opportunity to send some of the donation funds to our wonderful developers, they have come up with an idea; Development Donation Goals will allow them to release new features while helping to keep our forums running, and eventually lead to them getting some well-deserved cash for their efforts to support you all, which they've been doing for free for many many years with little to no recognition. The concept is simple. On the Donations page along with the normal "Donate to rAthena" button there will now be "Development Goals" for specific features. I'll also add this to the right-hand module area on the board index. Once the target has been met, the devs will release that particular feature. None of our developers have ever been a fan of individual devs selling features or code that would benefit the entire community, as that's not the aim of an open-source project, so I'm supporting them fully with this decision. Every little helps! P.S. You can also use your account credit towards donation goals by sending me a PM and describing how much of your credit you would like applying to which donation goal. Credit donations are converted at a ratio of 2:1.

Lets come back and release something this week...

Even though I just tinker around on a private server by myself from time to time, I still support this project and the efforts of the team here. Tossed a few bucks into the pool and will happily do so again in the future as life allows. Cheers.

You can create a custom texture that uses a reduced size of an existing texture to give a similar effect. Not sure how it would look but you could give it a shot. Regards, ~Azura Skyy

I only showed you where the error was, you need to go in and remove the back tick from the beginning of the second query_sql line.

The packet already being merge on rA repo.

if( BaseLevel > 10 ){ mes "only players with below ten kevel can use my services!"; close; }

Hello everyone, I went through most of the SQL files and noticed how atrocious the syntax was and decided to clean it up a bit. Shouldn't have any affect on the actual execution (especially since MySQL supports this new format). As most of up know, the current syntax is this for all the sql files: REPLACE INTO `mob_db_re` VALUES (1018,'CREAMY','Creamy','Creamy',23,378,1,144,162,1,61,62,28,20,16,1,1,0,1,20,10,12,0,4,24,0x181,150,1136,720,840,0,0,0,0,0,0,0,924,9000,2322,10,518,150,602,100,2207,2,712,500,692,100,0,0,0,0,4040,1); Ill be changing the mob,item and mob skill db's to this: REPLACE INTO `mob_db_re` (a,b,c,d,e,f,g,h,i,j,k) VALUES (a,b,c,d,e,f,g,h,i,j,k), (a,b,c,d,e,f,g,h,i,j,k); It should work unless there is something I don't know about. Also Ill be adding a lot of whitespace so they all line up nicely in rows and columns in case anyone wants to do some serious editing. Its tedious but it should help everyone out in the long run. Mob_db_re: 3% complete <- This is a total lie (its more like 1% lol) Mob_db2_re: 0% Item_db_re: 0% Item_db2_re: 0% mob_skill_db_re: 0% mob_skill_db2_re:0%

a new technique has been found in this topic, by abusing SQL table to save the kills so this will effectively break the limit of player data storage, rendering it unlimited /* create table last_pvp_kill ( id int(11) unsigned primary key auto_increment, killercid int(11) unsigned not null, killedcid int(11) unsigned not null, count smallint(6) unsigned, key (killercid), key (killedcid) ) engine = innodb; */ - script jfhdksfjhsk -1,{ OnClock0000: query_sql "truncate last_pvp_kill;"; end; OnPCKillEvent: if ( killedrid == getcharid(3) ) end; if ( query_sql( "select count from last_pvp_kill where killercid = "+( .@killercid = getcharid(0) )+" and killedcid = "+( .@killedcid = getcharid( 0, rid2name( killedrid ) ) ), .@count ) ) { // check if the user is in the list if ( .@count == .max_skull ) { dispbottom "you have reach the max amount of skull for that player today"; end; } query_sql "update last_pvp_kill set count = count +1 where killercid = "+ .@killercid +" and killedcid = "+ .@killedcid; } else query_sql "insert into last_pvp_kill values ( null, "+ .@killercid +", "+ .@killedcid +", 1 )"; // insert into table getitem2 7420, 1,1,0,0, 254, 0, .@killedcid % ( 1 << 16 ), .@killedcid >> 16; end; OnInit: .max_skull = 3; end; }