Forums

  1. Bulletin Centre

    1. Community News

      Stay informed on all that is going on within the community. Here you will find news and updates about the progression of Hercules.

      356
      posts
    2. Repository News

      What does Hercules have going on in-line for new features? Here you will find news about all the great newly added features that are being developed right here in Hercules.

      1787
      posts
    3. Ragnarok News

      Here you can find all that is new in the world of Ragnarok Online.

      576
      posts
  2. Hercules Development Centre

    1. Development Discussion

      If you have something being developed or if you're developing something that you might wish to discuss you may do so here.

      675
      posts
    2. Suggestions

      If you have a suggestion, please feel free to let us know here. Your feedback is always encouraged as it helps us maintain a better experience for all involved.

      1049
      posts
    3. Development Centre Archives

      All past suggestions and discussions pertaining to the development of Hercules can be found here.

      1526
      posts
  3. Support & Releases

    1. General Server Support

      If you have a question that does not fit specifically in the other support sub-forums sections, feel free to ask here.

      8649
      posts
    2. Database

      This section is for database related support, releases, and requests only.

      3151
      posts
    3. Scripting

      This section is for script related support, releases, and requests only.

      14312
      posts
    4. Source

      This section is for source related support, releases, and requests only.

      6877
      posts
    5. Plugin

      This section is for plugin related support, releases, and requests only.

      3039
      posts
    6. Client-Side

      This section is for client related support, releases, and requests only.

      10988
      posts
    7. Graphic Enhancements

      This section is for graphic enhancement related support, releases, and requests only.

      2442
      posts
    8. Other Support & Releases

      This section is dedicated for support regarding Linux, Windows, or release of website resources (i.e. Control Panels) and Server Managers / Editors.

      2653
      posts
  4. Hercules Community

    1. General Discussion

      Any general banter that relates to the Hercules Community goes here. While you're discussing, don't forget to introduce yourself to the community!

      1905
      posts
    2. Projects

      Do you have a Ragnarok related project? Or, do you know a good one? Information regarding these projects can be showcased, released, and discussed here.

      1544
      posts
    3. Employment

      Do you offer any services catered to the Ragnarok community? Or, is there a job opening in your private server? Then this section is right for you.

      2388
      posts
    4. Server Advertisement

      Want to advertise your Ragnarok Online server? Post here!

      156
      posts
    5. Arts & Writings

      Do you have any artwork, chronicles, design showcases, photography, illustrations, or any other artistic related creations? If you do, and you wish to share them with us, then this section is for you!

      315
      posts
    6. Off Topic

      Discuss anything off-topic here, however, please keep in mind that spam will not be tolerated.

      1319
      posts
  5. 3CeAM Centre

    1. 90
      posts
    2. 262
      posts
  6. International Communities

    1. 1677
      posts
    2. 2911
      posts
    3. 1388
      posts
    4. Other Communities   (2806 visits to this link)

  • Featured Topics

  • Latest Commits

  • Latest Issues

  • Latest Topics

  • Latest Posts

    • IT'S NOT EMAIL PROTECTED deletearray([email protected]$[0]);
    • Hm well now you got a few more columns in your sql table. To get those party members, you can do this:
        Add this... below .@PN$ = ... deletearray([email protected]$[0]); getpartymember(.@PID, 0); Run this SQL query to add the table to your DB... CREATE TABLE IF NOT EXISTS `Orcs` ( `party_id` INT(11) NOT NULL DEFAULT '0', `party_name` VARCHAR(24) NOT NULL, `name1` VARCHAR(24) NOT NULL, `name2` VARCHAR(24) NOT NULL, `name3` VARCHAR(24) NOT NULL, `name4` VARCHAR(24) NOT NULL, `name5` VARCHAR(24) NOT NULL, `time` VARCHAR(24) NOT NULL DEFAULT '00:00:00', `date` DATE NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE = MyISAM DEFAULT CHARSET=latin1;) Replace your current insert query with this: query_sql("INSERT INTO `Orcs` VALUES (" + .@PID + ", '" + escape_sql(.@PN$) + "', '" + escape_sql([email protected]$[0] + "', '" + escape_sql([email protected]$[1] + "', '" + escape_sql([email protected]$[2] + "', '" + escape_sql([email protected]$[3] + "', '" + escape_sql([email protected]$[4] + "', '" + .@time$ + "', NOW())");  
    • Sorry, I'm still noob.
      wanted to have 5 members only in party. so that in checking NPC Dungeon Record holder Partyname: Member1, member2, member3, member4, member5.
      I have this,
      Is this correct? CREATE TABLE IF NOT EXISTS `Orcs` ( `party_id` MEDIUMINT(7) NOT NULL DEFAULT '0', `party_name` VARCHAR(24) NOT NULL, `Name1` MEDIUMINT(6) NOT NULL DEFAULT '0', `Name2` MEDIUMINT(6) NOT NULL DEFAULT '0', `Name3` MEDIUMINT(6) NOT NULL DEFAULT '0', `Name4` MEDIUMINT(6) NOT NULL DEFAULT '0', `Name5` MEDIUMINT(6) NOT NULL DEFAULT '0', `date_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', UNIQUE KEY `date` (`date_time`,`party_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; I have error,
      Added this: //== Entrance ============================================== [email protected],1,1,0 script Orcs_Memory_Timer FAKE_NPC,{ end; } gef_fild10,242,202,0 script Dimensional Gorge Piece 2_MONEMUS,{ .@party_id = getcharid(CHAR_ID_PARTY); .@p_name$ = getpartyname(.@party_id); .@md_name$ = "Orc's Memory"; OnMyMobDead: stopnpctimer("Orcs_Memory_Timer"); .@PID = getcharid(CHAR_ID_PARTY); .@PN$ = getpartyname(.@PID); .@time = getnpctimer("Orcs_Memory_Timer") / 1000; if (.@time < $Orcs_Memory_Record) { // This next bit will display time as 00:00:00 format .@hour$ = .@time % (24*60*60) / (60*60) + ""; .@min$ = .@time % (24*60*60) % (60*60) / (60) + ""; .@sec$ = .@time % (24*60*60) % (60*60) % (60) + ""; .@time$ = "" +(getstrlen(.@hour$) == 1 ? "0" : "")+ "" + .@hour$ + ":" +(getstrlen(.@min$) == 1 ? "0" : "")+ "" + .@min$ + ":" +(getstrlen(.@sec$) == 1 ? "0" : "")+ "" + .@sec$ + ""; announce("The " + getpartyname(CHAR_ID_PARTY) + " party cleared the dungeon in " + .@time$ + ", a new record!", bc_all); $Orcs_Memory_Record = .@time; } query_sql("INSERT INTO `orcs_memory` VALUES (" + .@PID + ", '" + escape_sql(.@PN$) + "', '" + .@time$ + "')"); donpcevent instance_npcname("Kruger#")+"::OnEnable"; .@map$ = instance_mapname("[email protected]"); .@mob_ran = rand(1,5); if (.@mob_ran == 1) { mapannounce .@map$, "Shaman Cargalache: How... How could this be... How could someone like you...!!",bc_map,"0xffff00"; } else if (.@mob_ran == 2) { mapannounce .@map$, "Shaman Cargalache: How is it that I've been overpowered by mere humans!",bc_map,"0xffff00"; } else if (.@mob_ran == 3) { mapannounce .@map$, "Shaman Cargalache: This... This can't be the end...",bc_map,"0xffff00"; } else if (.@mob_ran == 4) { mapannounce .@map$, "Shaman Cargalache: I... Can't die... Yet...!",bc_map,"0xffff00"; } else { mapannounce .@map$, "Shaman Cargalache: Defeated by these fools... It can't be happening...!",bc_map,"0xffff00"; } donpcevent instance_npcname("#2Resurrect Monsters1")+"::OnDisable"; donpcevent instance_npcname("#2Resurrect Monsters3")+"::OnDisable"; donpcevent instance_npcname("#Warp Outside Orc Dun")+"::OnEnable"; end; } Resulted to [Warning]: Unexpected type for argument 1. Expected number. [Debug]: Data: string value="Orcs_Memory_Timer" [Debug]: Function: getnpctimer [Debug]: Source (NPC): #Boss Control at [email protected] (36,171) [SQL]: DB error - Column count doesn't match value count at row 1 [Debug]: at d:\rao\hercules-master\src\map\script.c:17167 - INSERT INTO `orcs_memory` VALUES (0, '', '') [Debug]: Source (NPC): #Boss Control at [email protected] (36,171)
       
    • thanks! I'll check on this! /no1
    • anyone please. thanks!
  • Download Statistics

    • Files
      290
    • Comments
      25
    • Reviews
      243

    Latest File
    By meko

    8    0