Jump to content

Snaehild

Members
  • Posts

    57
  • Joined

  • Last visited

Profile Information

  • Gender
    Male
  • Location
    Philippines
  • Github: Snaehild

Recent Profile Visitors

1,045 profile views

Snaehild's Achievements

  1. Perfect. Thank you Emistry. P.S. I'm your fan
  2. Hi @Emistry Thank you for the help, I was able to complete the script somehow, but i'm getting a debug error [Warning]: script:query_sql: Too many columns, discarding last 1 columns. [Debug]: Source (NPC): Tournament at gm_room (77,47) It seems to be the checkExist if statement if( query_sql( "SELECT `team_name` FROM `tournament` WHERE `team_name` = '"+escape_sql( [email protected]_name$ )+"'" ) ){ gm_room,77,47,5 script Tournament 757,{ query_sql( "SELECT * FROM `tournament` WHERE `char_id`='"+escape_sql( getcharid(0) )+"'",[email protected]_id$,[email protected]_id$,[email protected]_id$,[email protected]_name$,[email protected]_name$,.amount$,[email protected]$ ); goto checkExist; checkExist: if( query_sql( "SELECT `team_name` FROM `tournament` WHERE `team_name` = '"+escape_sql( [email protected]_name$ )+"'" ) ){ goto boundAddress; } else { goto addMember; } boundAddress: mes "This character is already registered to the team:"; mes "^FF0000"[email protected]_name$+""; mes "You can't change your wallet address at this time."; close; checkTotal: mes "Do you want "; query_sql( "SELECT COUNT(1) FROM `tournament` WHERE `team_name` = '"+escape_sql([email protected]_reg$)+"' GROUP BY `team_name",[email protected] ); mes "Total Member: " + [email protected]; if ([email protected] >= 3) { goto moreThanThree; } else { query_sql "INSERT INTO `tournament` VALUES ( '', '" + [email protected]_id$ + "', '" + getcharid(0) + "', '" + strcharinfo(0) + "', '" + [email protected]_reg$ + "', '1' , NOW() )"; close; } moreThanThree: mes "There are already 3 members of that team."; close; addMember: mes "Enter your team name"; input [email protected]_reg$; goto checkTotal; close; }
  3. Hi, I'm trying to write a script where players can register for a tournament of up to 3 members per team and saves in the database. But I got stuck in the counting part. I tried using this: gm_room,76,56,5 script Tournament 757,{ mes "Team Name"; input [email protected]_name; next; mes "test"; for( set [email protected],0; [email protected] < 1; set [email protected],[email protected] + 1 ){ query_sql( "SELECT SUM(`amount`) FROM `tournament` WHERE `team_name`='"[email protected]_name+"'",[email protected] ); set [email protected],[email protected] + ( [email protected] ); } mes "Found "[email protected]+" x "[email protected]+ ""; query_sql "INSERT INTO `tournament` VALUES ( '', '" + [email protected] + "', '" + getcharid(0) + "', '" + strcharinfo(0) + "', '" + [email protected]_name + "', '1' , NOW() )"; close; end; }
  4. This is an awesome tool. Do you have an ETA for the mob_db.txt support?
  5. Thanks for this! [Warning]: vend loot = 674 Edit: Fixed the issue earlier, just to make sure; Is this warning normal?
  6. Hi @L1nkZ, Awesome patcher. I've been using this for a while now. Do you have any idea what could be causing this? This happens to a quite few of my players
  7. Hi @Poring King Thanks for this awesome script. Any idea what could be causing this? [Error]: WFIFOSET: Maximum write buffer size for client connection 4 exceeded, most likely caused by packet 0x08c8 (len=34, ip=127.0.0.1). [Error]: WFIFOSET: Maximum write buffer size for client connection 4 exceeded, most likely caused by packet 0x0acc (len=18, ip=127.0.0.1). [Error]: WFIFOSET: Maximum write buffer size for client connection 4 exceeded, most likely caused by packet 0x0acc (len=18, ip=127.0.0.1). [Error]: WFIFOSET: Maximum write buffer size for client connection 4 exceeded, most likely caused by packet 0x00b6 (len=6, ip=127.0.0.1). [Error]: WFIFOSET: Maximum write buffer size for client connection 4 exceeded, most likely caused by packet 0x00b6 (len=6, ip=127.0.0.1).
  8. [Error]: script error on npc/custom/roservers/Illusion Moonlight.c line 96 parse_line: expect command, missing function name or calling undeclared function 91 : close; 92 : } 93 : 94 : OnInit: 95 : questinfo 7776,QTYPE_QUEST2; * 96 : 's'etquestinfo_level 7776,100,175; 97 : end; 98 : } 99 : payon,167,229,3 script Elder Jagyeom#illusion_moonlight 4_M_HUOLDARMY,{ 100 : if(BaseLevel < 100){ 101 : mes "[ Jagyeom ]"; [Error]: script error on npc/custom/roservers/Illusion Moonlight.c line 307 parse_line: expect command, missing function name or calling undeclared function 302 : } 303 : 304 : 305 : OnInit: 306 : questinfo 7777,QTYPE_QUEST; * 307 : 's'etquestinfo_req 7777,7776,1; 308 : end; 309 : } 310 : payon_in03,33,95,3 script Muyeon#moonlight_in 4_F_TAEKWON,{ 311 : if(illusion_moonlight < 2){ 312 : mes "[ Muyeon ]"; [Error]: script error on npc/custom/roservers/Illusion Moonlight.c line 317 parse_line: expect command, missing function name or calling undeclared function 312 : mes "[ Muyeon ]"; 313 : mes "If you're looking for the teacher, she's in the other room."; 314 : close; 315 : } 316 : if(illusion_moonlight == 2){ * 317 : 'p'cblockall getcharid(3),1; 318 : sleep2 2000; 319 : npctalk "Whatever you say, I'm not doing it anymore.","Muyeon#moonlight_in",bc_self; 320 : sleep2 2000; 321 : npctalk "This is the third time I had nightmares. I can't take it anymore!","Muyeon#moonlight_in",bc_self; 322 : sleep2 2000; [Error]: script error on npc/custom/roservers/Illusion Moonlight.c line 692 parse_line: expect command, missing function name or calling undeclared function 687 : end; 688 : } 689 : 690 : OnInit: 691 : questinfo 7781,QTYPE_QUEST; * 692 : 's'etquestinfo_req 7781,7780,1; 693 : end; 694 : } 695 : pay_d03_i,140,46,0 script Shimmering Portal#illusion_moonlight_2 4_ENERGY_BLUE,{ 696 : mes "I can go back to the ruined village.","What should I do?"; 697 : next;
  9. By default, it should inherit id: 5 name: "VIP" inherit: ( "Player" ) /* can do everything Players can */
  10. It's around 16.2 I believe. https://github.com/rathena/rathena/projects/4
  11. Hi, Any idea about these errors on the webservice? This is taken from this PR: https://github.com/rathena/rathena/pull/5731 [Warning]: Request with AID 2000022 and token 4e38fe3eba3a6ac5 unverified [Info]: 99.231.191.2 400 [Error]: [GuildID: 4 / World: "ROServer"] Not found in table [Info]: 49.150.58.7 404
  12. hi @Froost Any idea about this error?
  13. Hi @Fhaarnius Thank you for the response. I was able to make it work by importing older SQL files from the repo But there's still an error on MVP rankings I'm using the SQL files from 10b5965d1dae1defa4ae50c79824babc0e07335e which worked both for my mob & items db. I'm not sure if it's related to this. Error: PDOException Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ragnarok.monsters' doesn't exist File: E:\xampp\htdocs\flux\lib\Flux\Connection\Statement.php:50 File Line Function/Method E:\xampp\htdocs\flux\lib\Flux\Connection\Statement.php 50 PDOStatement::execute() E:\xampp\htdocs\flux\themes\th1\main\rightbar.php 166 Flux_Connection_Statement::execute() E:\xampp\htdocs\flux\themes\th1\footer.php 5 include() E:\xampp\htdocs\flux\lib\Flux\Template.php 403 include() E:\xampp\htdocs\flux\lib\Flux\Dispatcher.php 170 Flux_Template::render() E:\xampp\htdocs\flux\index.php 169 Flux_Dispatcher::dispatch() Exception Trace As String #0 E:\xampp\htdocs\flux\lib\Flux\Connection\Statement.php(50): PDOStatement->execute(NULL) #1 E:\xampp\htdocs\flux\themes\th1\main\rightbar.php(166): Flux_Connection_Statement->execute() #2 E:\xampp\htdocs\flux\themes\th1\footer.php(5): include('E:\\xampp\\htdocs...') #3 E:\xampp\htdocs\flux\lib\Flux\Template.php(403): include('E:\\xampp\\htdocs...') #4 E:\xampp\htdocs\flux\lib\Flux\Dispatcher.php(170): Flux_Template->render() #5 E:\xampp\htdocs\flux\index.php(169): Flux_Dispatcher->dispatch(Array) #6 {main}
×
×
  • Create New...

Important Information

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