Jump to content

Sallycantdance

Members
 View Profile  See their activity

  • Posts

    830

  • Joined

  • Last visited

 Content Type 

Posts posted by Sallycantdance

    Q>Convert PVP Ladder

    in Scripting Support

    Posted

    hello is there anyway to convert this pvp ladder display in website into mvp ladder too  thank you

     

    Quote

                </div> <!-- ./castle-holders -->            

                
                        <?php     
                            // Get Top 10 PvP ladder
                            $sql =  "SELECT pvpladder.char_id AS player_charid, pvpladder.name AS player_name, pvpladder.kills AS player_kills, pvpladder.deaths AS player_deaths, char.class AS job_class, char.base_level AS baseLvl, char.job_level AS jobLvl, char.sex AS gender FROM {$athenaServer->charMapDatabase}.pvpladder ";
                            $sql .= "LEFT JOIN {$athenaServer->charMapDatabase}.char ON pvpladder.char_id = char.char_id ";
                            $sql .= "ORDER BY `kills` DESC LIMIT 10";
                            $sth = $server->connection->getStatement($sql);
                            $sth->execute();
                            $top10list = $sth->fetchAll();                                                    
                        ?>                                
                    
                    <div class="top10-rankings">
                        <h2 class="text-warning item-title" data-aos="fade-left" data-aos-delay="600">Server Rankings</h2>
                            <div class="table-responsive pvp-ladder">
                                <table cellpadding="5" cellspacing="0">
                                    <tr data-aos="fade-left" data-aos-delay="900">
                                        <th width="20%" class="text-center">Rank</th>
                                        <th width="40%">Player Name</th>
                                        <th width="20%" class="text-center">Kills</th>
                                        <th width="20%" class="text-center">Deaths</th>
                                    </tr>
                                    <?php $i = 0; $delayAOS = 300; foreach($top10list as $top10): ?>
                                            <tr data-aos="fade-left" data-aos-delay="<?php echo $delayAOS; ?>">
                                                <td class="text-center"><?php echo $i + 1;?></td>
                                                <td><?php echo htmlspecialchars($top10->player_name);?></td>
                                                <td class="text-center"><?php echo htmlspecialchars($top10->player_kills);?></td>
                                                <td class="text-center"><?php echo htmlspecialchars($top10->player_deaths);?></td>
                                            </tr>
                                    <?php $i++; $delayAOS += 300; ?>
                                    <?php endforeach ?>
                                </table>
                            </div>
                    </div>

            </div> <!-- ./castle-container -->    

    Quote

    heres the mvp_ladder

    /*
    CREATE TABLE `mvpladder` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `char_id` int(11) unsigned NOT NULL default '0',
        `mob_id` INT NOT NULL,
        `kills` INT DEFAULT 0,
          PRIMARY KEY (`id`),
        INDEX (`char_id`),
        INDEX (`mob_id`),
        INDEX (`kills`)
    ) ENGINE=MyISAM AUTO_INCREMENT=1;
    */

     

    H>New EXE

    in Installation Support

    Posted

    8 hours ago, hendra814 said:

    which i'm know to use newer client must unpack the client with themida application.

    Is it no need again, because i search the guide but i didn't found it.

    ow i will try to search themida then try to upacked my client there maybe it can help too thanks for the idea

    H>New EXE

    in Installation Support

    Posted

    10 hours ago, hendra814 said:

    Are new client KRO now no need to unpacked?

    what do you mean sir sorry im very noob in client making , i used froggosclient and trying to make my own exe and errors keep coming up

    Froggo Rö Folder - Everything needed to run the LATEST publicly available client.

    in Client Releases

    Posted · Edited by GM Winter

    hello after i download this client and make my own exe 2022-04-06 Ragexe in "nemo 2023-04--24" i got this following error
    and for what i know its already translated using roenglish-master can someone guide me thank you

     

    Quote

    <?xml version="1.0" encoding="euc-kr" ?>
    <clientinfo>
        <desc>Ragnarok Client Information</desc>
        <servicetype>korea</servicetype>
        <servertype>primary</servertype>
        <connection>
            <display>Smooth: Main Server</display>
                  <address>127.0.0.1</address>
                  <port>6900</port>
                  <version>55</version>
                  <langtype>1</langtype>
            <registrationweb>127.0.0.1</registrationweb>
            <yellow>
                <admin>2000000</admin>
            </yellow>
            <loading>
                <image>Loading00.jpg</image>
                <image>Loading01.jpg</image>
                <image>Loading02.jpg</image>
                <image>Loading03.jpg</image>
                <image>Loading04.jpg</image>            
            </loading>
           </connection>
    </clientinfo>
     

    Quote

    1 Use Tilde for Matk
    2 Chat Flood Allow
    5 Enable Proxy Support
    8 Custom Window Title
    9 Disable 1rag1 type parameters (Recommended)
    10 Disable 4 Letter Character Name Limit
    11 Disable 4 Letter User Name Limit
    12 Disable 4 Letter Password Limit
    13 Disable Ragexe Filename Check (Recommended)
    16 Disable Swear Filter
    17 Enable Official Custom Fonts
    18 Skip Service Selection Screen
    19 Legacy: Enable Title Bar Menu
    20 Extend Chat Box
    21 Extend Chat Room Box
    22 Extend PM Box
    23 Enable /who command (Recommended)
    24 Fix Camera Angles (Recommended)
    28 Increase Headgear ViewID
    31 Increase Zoom Out 75%
    34 Enable /showname (Recommended)
    35 Read Data Folder First
    36 Always read msgstringtable.txt (Recommended)
    38 Remove Gravity Ads (Recommended)
    39 Remove Gravity Logo (Recommended)
    41 Disable Nagle Algorithm (Recommended)
    43 Always Use Email for Char Deletion
    44 Translate Client (Recommended)
    47 Use Ragnarok Icon
    48 Use Plain Text Descriptions (Recommended)
    49 Enable Multiple GRFs (Recommended)
    53 Use Ascii on All LangTypes (Recommended)
    64 @ Bug Fix (Recommended)
    65 Load Custom lua file instead of iteminfo*.lub (Recommended)
    69 Extend Npc Dialog Box
    71 Ignore Resource Errors
    72 Ignore Missing Palette Error
    73 Remove Hourly Announce (Recommended)
    74 Increase Screenshot Quality
    75 Enable Flag Emoticons
    84 Remove Serial Display (Recommended)
    88 Allow space in guild name
    90 Enable DNS Support (Recommended)
    101 Skip Friend list Cheat Check
    102 Skip Guild Member Cheat Check
    105 Hide Nav Button
    106 Hide BG Button
    108 Hide Booking Button
    110 Hide Achievements Button
    114 Change Vending Limit [Experimental]
    213 Disable Help Message on Login (Recommended)
    214 Restore Model Culling
    215 Increase Map Quality
    216 Hide Cash Shop
    219 Always Show Resurrection Button
    222 Show Replay Button
    229 Enable Emblem hover for BG
    230 Always load Korea ExternalSettings lua file (Recommended)
    231 Remove hardcoded address/port (Recommended)
    232 Restore old login packet (Recommended)
    233 Hide SNS Button
    235 Enable guild while in clan
    239 Ignore /account: command line argument
    242 Disable kRO Site Launch
    253 Skip some hidden menu icon buttons
    254 Change Max Items in inventory
    256 Use Default Web Browser In Cashshop
    258 Enable Shortcut All Item
    268 Restore chat focus
    283 Change fade in/out delay
    287 Change character display deletion time
    290 Hide build info in client (Recommended)
    291 Hide packets from peek (Recommended)
    295 Change Max Party Value
    297 Hide keyboard button
    300 Hide inventory button
    301 Hide skills button
    304 Hide options/settings button
    305 Hide tip button
    306 Hide shop button
    307 Hide attendance button
    308 Hide adventurer agency button
    319 Opening To Service Select
    322 Case-Insensitive Storage Search
    326 Disable OTP Login Packet (Recommended)
    333 Change Max Friends Value
    348 Send client flags to server (Recommended)
    351 Translate arrows buttons text from korean to english
    396 Change all load fonts charset
    409 Add close button to game window
    418 Hide reputation button
    432 Disable Game Guard (NProtect) (Recommended)
    436 Disable packets id encryption
    439 Set fixed charset on drawing text messages
     

     

    1.png

    2.png

    3.png

    H>New EXE

    in Installation Support

    Posted

    im using 20220406 version and this error keeps coming up
     

    Quote

    src/config/packet.hpp

    #ifndef PACKETVER
        /// Do NOT edit this line! To set your client version, please do this instead:
        /// In Windows: Add this line in your src\custom\defines_pre.hpp file: #define PACKETVER YYYYMMDD
        /// In Linux: The same as above or run the following command: ./configure --enable-packetver=YYYYMMDD
        #define PACKETVER 20220406
    #endif

    Quote

    login_athena

    // Store passwords as MD5 hashes instead of plain text?
    // NOTE: Will not work with clients that use <passwordencrypt>
    use_MD5_passwords: no

    Quote

    in the diff its also disable
    Force Send Client Hash Packet

    Quote

    Patch

    1 Use Tilde for Matk
    2 Chat Flood Allow
    5 Enable Proxy Support
    8 Custom Window Title
    9 Disable 1rag1 type parameters (Recommended)
    10 Disable 4 Letter Character Name Limit
    11 Disable 4 Letter User Name Limit
    12 Disable 4 Letter Password Limit
    16 Disable Swear Filter
    17 Enable Official Custom Fonts
    19 Legacy: Enable Title Bar Menu
    20 Extend Chat Box
    21 Extend Chat Room Box
    22 Extend PM Box
    23 Enable /who command (Recommended)
    24 Fix Camera Angles (Recommended)
    28 Increase Headgear ViewID
    31 Increase Zoom Out 75%
    34 Enable /showname (Recommended)
    35 Read Data Folder First
    36 Always read msgstringtable.txt (Recommended)
    38 Remove Gravity Ads (Recommended)
    39 Remove Gravity Logo (Recommended)
    41 Disable Nagle Algorithm (Recommended)
    43 Always Use Email for Char Deletion
    44 Translate Client (Recommended)
    47 Use Ragnarok Icon
    48 Use Plain Text Descriptions (Recommended)
    49 Enable Multiple GRFs (Recommended)
    53 Use Ascii on All LangTypes (Recommended)
    64 @ Bug Fix (Recommended)
    65 Load Custom lua file instead of iteminfo*.lub (Recommended)
    69 Extend Npc Dialog Box
    71 Ignore Resource Errors
    72 Ignore Missing Palette Error
    73 Remove Hourly Announce (Recommended)
    74 Increase Screenshot Quality
    75 Enable Flag Emoticons
    84 Remove Serial Display (Recommended)
    88 Allow space in guild name
    90 Enable DNS Support (Recommended)
    101 Skip Friend list Cheat Check
    105 Hide Nav Button
    106 Hide BG Button
    108 Hide Booking Button
    110 Hide Achievements Button
    114 Change Vending Limit [Experimental]
    215 Increase Map Quality
    216 Hide Cash Shop
    219 Always Show Resurrection Button
    222 Show Replay Button
    229 Enable Emblem hover for BG
    230 Always load Korea ExternalSettings lua file (Recommended)
    233 Hide SNS Button
    235 Enable guild while in clan
    239 Ignore /account: command line argument
    253 Skip some hidden menu icon buttons
    254 Change Max Items in inventory
    256 Use Default Web Browser In Cashshop
    258 Enable Shortcut All Item
    268 Restore chat focus
    283 Change fade in/out delay
    287 Change character display deletion time
    290 Hide build info in client (Recommended)
    291 Hide packets from peek (Recommended)
    295 Change Max Party Value
    297 Hide keyboard button
    304 Hide options/settings button
    305 Hide tip button
    307 Hide attendance button
    333 Change Max Friends Value
    409 Add close button to game window
    436 Disable packets id encryption
     



    image.thumb.png.0484919055981c9ce583d2d413ee5453.png

    1.png

    H> Updated Server Side

    in Installation Support

    Posted · Edited by GM Winter

    3 hours ago, Akbare-2nd said:

    for connection problems you just need to attention

    mysql is running properly

    mysql user and password are the same between the server and your mysql

    for login user and server password leave the default for a while

    Quote

    char_conf

    userid: username
    passwd: password
    login_ip: 127.0.0.1
    char_ip: 127.0.0.1
    server_name: New Rathena

    Quote

    map_conf

    userid: username
    passwd: password
    char_ip: 127.0.0.1
    map_ip: 127.0.0.1

    Quote

    inter_conf

    login_server_db: nrathena
    ipban_db_db: nrathena
    char_server_db: nrathena
    map_server_db: nrathena
    log_db_db: nrathena_logs

    Quote

    char_athena

    // Server Communication username and password.
    userid: username
    passwd: password

    map_athena

    // Interserver communication passwords, set in account.txt (or equiv.)
    userid: username
    passwd: password


     

     

    H>Other skill tab

    in Graphics Support

    Posted

    18 hours ago, b1rbert said:

    You're probably missing the entry for a skill in your other tab. 
    image.png.0da2467326a8a54ff2ae1268be21b34a.png

    check this and see if the skill has an entry. if not add that entry.

    Other option is putting a replacement picture to the path the error shows.

    If the error still persists, you might have to add the skill somewhere else.

    Check your Skilltree.db on that class and see which skill it could be and see if it has a skillinfolist entry

    thanks

    H>Guild House Rental

    in Scripting Support

    Posted · Edited by GM Winter

    4 hours ago, Ronald said:

    Hi @GM Winter,

    I have created script. This is just a basic script which I think would answer your request.

     

    So basically, this script requires an item to enter but it doesn't get or delete the item from your user's inventory.

    What you have to do is create an usable item which item script is will give the user a rental etc item meaning the ticket will have a duration on their inventory. 

    I hope it makes sense. 

    prontera,150,150,5	script	Guild Room	123,{
	mes "[Guild Room]";
	mes "Hey, there. Do you want to enter Guild";
	next;
	switch(select("Yes:No")) {
	case 1:
			if (countitem(1234) > 0) {
				mes "[Guild Room]";
				mes "Oh, awesome, I see you have a ticket to enter the Guild Room.";
				mes "Ready? Let's do this.";
				next;
				warp "payon",123,123;
				close;
			}
		else {
			mes "[Guild Room]";
			mes "Dude, you do not have the ticket to enter the Guild Room.";
			mes " ";
			mes "Sorry but you cannot enter.";
			close;
		}
	case 2:
		mes "[Guild Room]";
		mes "Well, come back if you change your mind.";
		close;
	}
}

    Change the 1234 to your etc item ID.

    thank you @Ronald is there anyway i can register a certain guild there to let a specific guild in that room

    [ Solved ] M>Job Changer NPC

    in Scripting Support

    Posted

    2 hours ago, Racaae said:

    Hello. Find this line: 

    if (select(" ~ Change into ^0055FF" + jobname(.@i) + "^000000 class: ~ ^777777" + ((getargcount() > 1) ? "Go back" : "Cancel") + "^000000") == 1) {

    And insert this code below it: 

    	if (BaseJob == Job_Novice || BaseJob == Job_Summoner)
		.@cost = 50000;
	else
		.@cost = 100000;
	if (Zeny < .@cost) {
		mes "[Job Master]";
		mes "Sorry. You don't have enough zeny.";
		mes "You need ^0000FF" + F_InsertComma(.@cost) + "z^000000 to job change.";
		close;
	}
	Zeny -= .@cost;

     

    thank you bro !

    H>Emergency Call

    in Source Support

    Posted · Edited by GM Winter

    3 hours ago, Racaae said:

    Hello. Open file \db\import\skill_db.yml and insert the following: 

    Body:

  - Id: 10013
    Name: GD_EMERGENCYCALL
    Cooldown: 300000
    FixedCastTime: 5000

    Change the value (miliseconds) in Cooldown and/or the Casttime to reduce the time waiting for the skill.

    300000 = 300 seconds = 5 minutes
    5000 = 5 seconds

    Error Sir, what im trying to say is after i enter the guild castle the i want to use ecall already but i cant use it even i didnt use it before the 5mins cd

    1.png

×
×
  • Create New...