Jump to content


  • Content Count

  • Avg. Content Per Day

  • Joined

  • Last visited

Community Reputation

0 Neutral

About driver

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. #edit. @Haruka Mayumi Before closing the topic. Just one more question, please. Using your model, I did the WOT Player Ranking, but I have a question about that. My idea is when the player breaks the chest he will get +1 breakpoint in the player ranking And his guild will also get +1 point in the guild ranking. The +1 breakpoint in the Player Ranking is ok. My question is, how can I use the sql table 'count' both to add points for players and to add points for the guild? And what changes should I make in the ranking? Please. case 1: next; mes @npcR$; // Players Ranking WOT if(!([email protected] = query_sql("SELECT B.`name`,B.`guild_id`,A.`count` FROM `wot_ladder` AS A LEFT JOIN `char` AS B ON A.`char_id` = B.`char_id` ORDER BY `count` DESC LIMIT 10", [email protected]$,[email protected],[email protected]))) { mes "No data found."; close; } for ( [email protected] = 0; [email protected] < [email protected]; [email protected]++ ) { mes ([email protected]+1) +". "+ [email protected]$[[email protected]] +" ~ "+(getguildname([email protected][[email protected]]) == "null" ? "None":getguildname([email protected][[email protected]]))+" ~ "+ [email protected][[email protected]] +" breaks."; } close; case 2: next; mes @npcR$; // Guild Ranking WOT query_sql "SELECT `guild_id`, `count` FROM `wot_ladder` WHERE '"+getcharid(2)+"' AND `count` > '0' ORDER BY `count` DESC LIMIT 10",[email protected]$,[email protected]; for (set [email protected],0; [email protected] < getarraysize([email protected]$); set [email protected], [email protected] + 1) mes ([email protected]+1)+"º^000000 - ^228B22"[email protected]$[[email protected]]+"^000000 - ^00B2EE"[email protected][[email protected]]+"^000000"; break; } And, how to add + 1 Point Ranking Guild announce "[War of Treasure]: The ["+strcharinfo(0)+"] from the ["+getguildname([email protected]_id)+"] guild destroyed a chest!",8; // Breaker Point only for those who destroyed the chest. (Ranking Player) query_sql("INSERT INTO `wot_ladder` SET `char_id` = '"+getcharid(0)+"', `count` = '1' ON DUPLICATE KEY UPDATE `count` = `count`+1"); Please. Thank you very much. And I'm sorry. It is very complicated for me.
  2. Sorry, I didn't quite understand what you meant ... I don't think I posted the full code, right? In the ranking, I would like to add the guild to which the player belongs. Code:
  3. Masters, I want to add the player's guild after the player's name in the ranking. I have two classifications in different scripts. But both show only Position | Player | Points I would like this. example: Position| Player | Guild | Points I have no idea what code should be added to 'query_sql' or how to set it in the script. Please, if anyone can help me with this I would be very grateful. Ranking Empbreaker: mes "Top 10 Emperium Breaker"; if(!([email protected] = query_sql("SELECT `char_id`, `count` FROM `breaker_ladder` ORDER BY `count` DESC LIMIT 10", [email protected], [email protected]))) { mes "No data found."; close; } for ( [email protected] = 0; [email protected] < [email protected]; [email protected]++ ) { query_sql("SELECT `name` FROM `char` WHERE `char_id` = '"[email protected][[email protected]]+"'",[email protected]$); mes ([email protected]+1) +". "+ [email protected]$ +" ~ "+ [email protected][[email protected]] +" breaks."; } close; and Ranking WoT: mes "Position | Player | Points"; query_sql "SELECT `name`, `baus` FROM `char` WHERE '"+getcharid(0)+"' AND `baus` > '0' ORDER BY `baus` DESC LIMIT 10",[email protected]$,[email protected]; for (set [email protected],0; [email protected] < getarraysize([email protected]$); set [email protected], [email protected] + 1) mes ([email protected]+1)+"º^000000 | ^228B22"[email protected]$[[email protected]]+"^000000 | ^00B2EE"[email protected][[email protected]]+"^000000"; break; } close; Thank you very much.
  4. driver

    On-Off event

    Thank you so much! Problem solved.
  5. driver

    On-Off event

    Sorry, how do I do?
  6. driver

    On-Off event

    Thanks for your explanation Mr @Poring King! I made some changes to the script. I can start the event through the 'Manager' menu and also turn it off. But when I hang up, the event closes the portal, but it continues to announce saying that there are x minutes left to start ... Even with it turned off. How can I fix this?
  7. driver

    On-Off event

    Thank you very much sir, but it seems to be wrong, the menu does not appear. I've tried in several ways, but I can't understand ... If I Replace OnInit: with OnEndEvent: npc cannot verify whether the event is open or closed. If I add callsub; or goto; the event turns on / off but even turned off the portal closes but the script still insists on announcing the event with the portal closed. I really want to learn, I think I don't know how to call variables or understand differences. I'll leave the script below, please, if someone fixes the script I can understand the error and learn more about it. Thank you for being patient with me and sorry for my amateurism.
  8. driver

    On-Off event

    I have added: case 2: if(!$evento) { mes "Event canceled successfully."; close2; callsub Onendevent; end; } mes "The event has already been canceled."; close; and in the end Onendevent: if($evento) announce "Canceled Lucky Event!",bc_all; killmonster .Map$,"All"; set .Event,0; end; } The portal closes, but the npc continues to announce '' 4 minutes for the event .. "
  9. driver

    On-Off event

    Hey, guys, how are you? Before, I would like to wish everyone a great Christmas! Guys, I'm starting to organize my scripts. I am still a layman on the subject. But I have a doubt ... I would like to add the Cancel Event option in the GM script menu. I tried in a few ways, but the event just cancels the entry, but it still works. I wanted an example of variable for this script, please. Script: https://pastebin.com/WB6hRAm4 To connect works well. case 1: if(!$evento){ mes "Event started successfully."; close2; callsub evento_start; end; } mes "The event has already started."; close; But to hang up does not work. Even if I call '$event, 0;' Could someone give me a hint for this script? in: case 2: *TURN OFF - EXAMPLE* } mes "The event has already been turned off"; close; } Thank you!
  10. thanks buddy, but it's not the version I'm looking for. I need the version with the sandals and white socks ...
  11. Could someone send me the sprite of the akatsuki suit? I have two sprite though: Sprite 1: It's perfect, but it has no white socks. Sprite 2: Has white socks but is totally misaligned and defective. Image: https://i.ibb.co/w0Wyx7j/screen-Titan-003.jpg I wish someone could send me the sprite with socks and no blemishes. please.. Many thanks, and excuse my English ...
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.