123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 |
- prefix_tips = "§eTips";
- index = 0;
- sgoto(100, "tip_loop");
- msg.string("dev", "§bTipLoop §rloaded.");
- @wait
- wait();
- goto("wait");
- @tip_loop
- //get next tip
- list = getLoopTipps();
- size = list.getSize(list);
- if(size == 0) {
- goto("wait");
- }
- index++;
- if(index >= size) {
- index = 0;
- }
- a = list.getIndex(list, index);
- tipp_value = a[1];
- //loop online players
- online_list = players.toList();
- iter = iterator(online_list);
- while(hasNext(iter)) {
- p = next(iter);
- if(player.getTipLoop(p)) {
- msg(p, text.merge(text.new(string.concat(string.getPrefix(prefix_tips), " ")), string.getInterpretedText(tipp_value)));
- }
- }
- sgoto(12000, "tip_loop");
- goto("wait");
- function getLoopTipps() {
- list = list.new();
- stmt = databank.prepare("SELECT tipp_key, tipp_value FROM tipps WHERE tipp_loop = TRUE");
- result = databank.execute(stmt);
- while(databank.next(result)) {
- a = array.new(2);
- a[0] = databank.getString(result, 1);
- a[1] = databank.getString(result, 2);
- list.add(list, a);
- }
- databank.close(result);
- databank.close(stmt);
- return list;
- }
|