summaryrefslogtreecommitdiff
path: root/npc/functions
diff options
context:
space:
mode:
Diffstat (limited to 'npc/functions')
-rw-r--r--npc/functions/scoreboards.txt42
1 files changed, 36 insertions, 6 deletions
diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt
index a095e97af..66389fdf3 100644
--- a/npc/functions/scoreboards.txt
+++ b/npc/functions/scoreboards.txt
@@ -16,7 +16,7 @@ function script ScoreboardsReload {
.@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='UDTRANK' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 10", $@udt_name$, $@udt_value);
.@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='AFKING' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 10", $@afk_name$, $@afk_value);
.@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='HONOR' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 10", $@hof_name$, $@hof_value);
- .@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='ACADEMIC_RANK' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 10", $@hoa_name$, $@hoa_value);
+ .@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='ACADEMIC_RANK' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 30", $@hoa_name$, $@hoa_value);
.@nb = query_sql("SELECT c.name, i.value FROM `mapreg` AS i, `char` AS c WHERE i.varname='$REFERRAL_IDS' AND i.index=c.account_id ORDER BY i.value DESC LIMIT 20", $@hor_name$, $@hor_value);
// Seasonal Scoreboards
@@ -314,7 +314,15 @@ function script HallOfAurora {
function script HallOfAcademic {
mes "";
- mes l("##BHall Of Academics: TOP10##b");
+ mes l("##BHall Of Academics: TOP30##b");
+ if (playerattached()) {
+ .@v=array_entries(ACADEMIC_VOUCH);
+ .@mv=(ACADEMIC_RANK >= ACADEMIC_DOCTOR ? 3 : 2);
+ .@mv=(ACADEMIC_RANK >= ACADEMIC_BACHELOR ? .@mv : 1);
+ mesc l("Your current scholar rank: %s (%d/%d vouches)",
+ academicrank(), .@v, .@mv);
+ }
+ mes "";
mesf("1. %s (%s)", $@hoa_name$[0], academicrank($@hoa_value[0]));
mesf("2. %s (%s)", $@hoa_name$[1], academicrank($@hoa_value[1]));
mesf("3. %s (%s)", $@hoa_name$[2], academicrank($@hoa_value[2]));
@@ -325,6 +333,28 @@ function script HallOfAcademic {
mesf("8. %s (%s)", $@hoa_name$[7], academicrank($@hoa_value[7]));
mesf("9. %s (%s)", $@hoa_name$[8], academicrank($@hoa_value[8]));
mesf("10. %s (%s)", $@hoa_name$[9], academicrank($@hoa_value[9]));
+ next;
+ mesf("11. %s (%s)", $@hoa_name$[10], academicrank($@hoa_value[10]));
+ mesf("12. %s (%s)", $@hoa_name$[11], academicrank($@hoa_value[11]));
+ mesf("13. %s (%s)", $@hoa_name$[12], academicrank($@hoa_value[12]));
+ mesf("14. %s (%s)", $@hoa_name$[13], academicrank($@hoa_value[13]));
+ mesf("15. %s (%s)", $@hoa_name$[14], academicrank($@hoa_value[14]));
+ mesf("16. %s (%s)", $@hoa_name$[15], academicrank($@hoa_value[15]));
+ mesf("17. %s (%s)", $@hoa_name$[16], academicrank($@hoa_value[16]));
+ mesf("18. %s (%s)", $@hoa_name$[17], academicrank($@hoa_value[17]));
+ mesf("19. %s (%s)", $@hoa_name$[18], academicrank($@hoa_value[18]));
+ mesf("20. %s (%s)", $@hoa_name$[19], academicrank($@hoa_value[19]));
+ next;
+ mesf("21. %s (%s)", $@hoa_name$[20], academicrank($@hoa_value[20]));
+ mesf("22. %s (%s)", $@hoa_name$[21], academicrank($@hoa_value[21]));
+ mesf("23. %s (%s)", $@hoa_name$[22], academicrank($@hoa_value[22]));
+ mesf("24. %s (%s)", $@hoa_name$[23], academicrank($@hoa_value[23]));
+ mesf("25. %s (%s)", $@hoa_name$[24], academicrank($@hoa_value[24]));
+ mesf("26. %s (%s)", $@hoa_name$[25], academicrank($@hoa_value[25]));
+ mesf("27. %s (%s)", $@hoa_name$[26], academicrank($@hoa_value[26]));
+ mesf("28. %s (%s)", $@hoa_name$[27], academicrank($@hoa_value[27]));
+ mesf("29. %s (%s)", $@hoa_name$[28], academicrank($@hoa_value[28]));
+ mesf("30. %s (%s)", $@hoa_name$[29], academicrank($@hoa_value[29]));
return;
}
@@ -572,15 +602,15 @@ function script HallOf2020 {
//mesc l("Scheduled: September 9th");
mes "";
mes l(".:: International Coffee Day ::.");
- mesc l("Scheduled: October 1st");
- //mes l("No victor appliable.");
+ //mesc l("Scheduled: October 1st");
+ mes l("No victor appliable.");
mes "";
mes l(".:: Hasan Scorpion Killing Challenge 2020 ::.");
mesc l("September 22nd - December 20th");
mes "";
mes l(".:: Thanksgiving 2020 ::.");
- mesc l("November 1st - November 30th");
- //mes l("No victor appliable.");
+ //mesc l("November 1st - November 30th");
+ mes l("No victor appliable.");
mes "";
mes l(".:: Christmas 2020 ::.");
mesc l("Scheduled: December 19th - January 2nd");