tiploop.txt 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. prefix_tips = "§eTips";
  2. index = 0;
  3. sgoto(100, "tip_loop");
  4. msg.string("dev", "§bTipLoop §rloaded.");
  5. @wait
  6. wait();
  7. goto("wait");
  8. @tip_loop
  9. //get next tip
  10. list = getLoopTipps();
  11. size = list.getSize(list);
  12. if(size == 0) {
  13. goto("wait");
  14. }
  15. index++;
  16. if(index >= size) {
  17. index = 0;
  18. }
  19. a = list.getIndex(list, index);
  20. tipp_value = a[1];
  21. //loop online players
  22. online_list = players.toList();
  23. iter = iterator(online_list);
  24. while(hasNext(iter)) {
  25. p = next(iter);
  26. if(player.getTipLoop(p)) {
  27. msg(p, text.merge(text.new(string.concat(string.getPrefix(prefix_tips), " ")), string.getInterpretedText(tipp_value)));
  28. }
  29. }
  30. sgoto(12000, "tip_loop");
  31. goto("wait");
  32. function getLoopTipps() {
  33. list = list.new();
  34. stmt = databank.prepare("SELECT tipp_key, tipp_value FROM tipps WHERE tipp_loop = TRUE");
  35. result = databank.execute(stmt);
  36. while(databank.next(result)) {
  37. a = array.new(2);
  38. a[0] = databank.getString(result, 1);
  39. a[1] = databank.getString(result, 2);
  40. list.add(list, a);
  41. }
  42. databank.close(result);
  43. databank.close(stmt);
  44. return list;
  45. }