-
Posts
10 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Posts posted by koneko33
-
-
i have this custom card on my server how can i make it stack only for 3 cards
44457,Hydra_Card_Star,Hydra Card Star,6,20,,10,,,,,,,,769,,,,,{ bonus2 bAddRace,RC_DemiHuman,10; bonus2 bAddRace,RC_PLAYER_HUMAN,10; bonus2 bSubRace,RC_DemiHuman,10; bonus2 bSubRace,RC_Player_Human,10; },{},{}; -
-
-
On 1/4/2013 at 12:06 AM, Capuche said:
100% sure... +10... need 1 TCG Card per refine... players can choose equipment.
prt_in,57,55,5 script lkjhgf 63,{ //- setarray .@safe[0], 10, 10, 10, 10, 10, 10; setarray .@TicketID, 7227; //- mes "[blacksmith]"; mes "I'm the Blacksmith."; mes "I can refine all kinds of weapons, armor and equipment, so let me"; mes "know what you want me to refine."; next; setarray .@position$[1], "^0000ffHead^000000","^0000ffBody^000000","^FF0000Left hand^000000","^FF0000Right hand^000000","^0000ffRobe^000000","^0000ffShoes^000000","Accessory 1","Accessory 2","^0000ffHead 2^000000","^0000ffHead 3^000000"; for( set .@i, 1; .@i <= getarraysize(.@position$); set .@i, .@i+1 ) { if( getequipisequiped(.@i) ) set .@menu$, .@menu$ + .@position$[.@i] + "-" + "[" + getequipname(.@i) + "]"; set .@menu$, .@menu$+ ":"; } set .@part, select( .@menu$ ); if( !getequipisequiped(.@part) ) { mes "[blacksmith]"; mes "You're not wearing"; mes "anything there that"; mes "I can refine."; emotion 6; close; } //Check if the item is refinable... if( !getequipisenableref(.@part) ) { mes "[blacksmith]"; mes "I don't think I can"; mes "refine this item at all..."; close; } //Check if the item is identified... (Don't know why this is in here... but kept it anyway) if( !getequipisidentify(.@part) ) { mes "[blacksmith]"; mes "You can't refine this"; mes "if you haven't appraised"; mes "it first. Make sure your"; mes "stuff is identified before"; mes "I can refine it."; close; } //Check to see if the items is already +10 if( getequiprefinerycnt(.@part) >= 10 ) { mes "[blacksmith]"; mes "I can't refine this"; mes "any more. This is as"; mes "refined as it gets!"; close; } set .@refineitemid, getequipid(.@part); // save id of the item set .@wp, getequipweaponlv(.@part); if( ( .@mRn = select( "+10, please.", "I've changed my mind..." )-1 ) > 0 ) { next; mes "[blacksmith]"; mes "You said so... So be it."; close; } .@rcnt = .@safe[.@wp] - getequiprefinerycnt(.@part); set .@refinerycnt, getequiprefinerycnt(.@part); //save refinery count mes "[blacksmith]"; mes "To refine this I need"; mes "^FF0000"+.@rcnt+" "+getitemname( .@TicketID )+"^000000"; mes "Do you really wish to continue?"; next; if( select( "Yes:No" ) == 2 ) { mes "[blacksmith]"; mes "Yeah..."; mes "There's no need to"; mes "rush. Take your time."; close; } if( countitem(.@TicketID) < .@rcnt ) { mes "[blacksmith]"; mes "You don't seem to have"; mes "enough ^000000"+getitemname( .@TicketID )+"^000000..."; mes "Go get some more. I'll be"; mes "here all day if you need me."; close; } if(getequipisequiped(.@part) == 0) { // hacker has removed the item (not changed, why?) mes "[blacksmith]"; mes "Look here... you don't have any Items on..."; close; } if(getequiprefinerycnt(.@part) != .@refinerycnt || getequipid(.@part) != .@refineitemid) { // hacker has changed the item mes "[blacksmith]"; emotion e_an; mes "Wait a second..."; mes "Do you think I'm stupid?!"; mes "You switched the item while I wasn't looking! Get out of here!"; close; } mes "[blacksmith]"; delitem .@TicketID, .@rcnt; for( .@i = 0; .@i < .@rcnt; .@i++ ) successrefitem .@part; emotion e_heh; if( !(.@win = rand(2)) ) { mes "[blacksmith]"; mes "Perfect!"; mes "Heh heh!"; mes "Once again,"; mes "flawless work"; mes "from the master~"; } else if( .@win == 1 ) { mes "[blacksmith]"; mes "Success...!"; mes "Yet again, my amazing"; mes "talent truly dazzles"; mes "and shines today."; } else { mes "[blacksmith]"; mes "Heh heh!"; mes "I'm all done."; mes "No doubt, my work is"; mes "to your satisfaction."; mes "Sheer, utter perfection~"; } close; }
how do i fix this
-
solve thank you
On 11/19/2023 at 9:13 PM, Winterfox said:You need to alter the char table and add the pvpreward colum. The sql is even inside the script you posted.
ALTER TABLE `char` ADD `pvpreward` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `fame`;
-
-
//===== rAthena Script ======================================= //= PvP Top 10 Ladder Weekly Reward prontera,166,188,3 script PVP REWARD 88,{ .@cid = getcharid(0); query_sql( "SELECT `pvpreward` FROM `char` WHERE `char_id` = "+.@cid[.@i]+" LIMIT 1",.@pvpreward ); query_sql( "UPDATE `char` SET `pvpreward` = 0 WHERE `char_id` = "+.@cid[.@i]+" LIMIT 1" ); set .PVP_Reward, 7227; set .TOP_1_PLAYER, 7227; set .TOP_2_PLAYER, 7227; // ITEM LISTED PRIZE switch ( .@pvpreward ) { case 1: getitem .TOP_1_PLAYER,50; break; case 2: getitem .TOP_2_PLAYER,45; break; case 3: getitem .PVP_Reward,40; break; case 4: getitem .PVP_Reward,30; break; case 5: getitem .PVP_Reward,20; break; case 6: getitem .PVP_Reward,10; break; case 7: getitem .PVP_Reward,5; break; case 8: getitem .PVP_Reward,5; break; case 9: getitem .PVP_Reward,5; break; case 10: getitem .PVP_Reward,5; break; default: mes "[PVP Gate Keeper]"; mes "You're not top pvp for this week. or you already claimed the rewards."; mes "The Reward Item is <ITEM>RTC<INFO>"+ .TOP_1_PLAYER +"</INFO></ITEM>."; mes "The Reward giving days"; mes "Start Claiming: ^0000FFSun12:00 Noon^000000"; mes "End Claiming: ^0000FFMon 12:00 Noon^000000"; close; } mes "[PVP Gate Keeper]"; mes "Congratulation "+ strcharinfo(0) +""; mes "You gained reward as top "+.@pvpreward+" PVP."; close; OnInit: // INITIATE THE LIMIT OF LADDER LISTED PRIZE .limit = 10; waitingroom "[PVP Reward]",0; end; //DATE TIME ASSIGN OnSun1200: // ************************************************************** // FIRST EMISTRY SCRIPT // ************************************************************** for ( .@i = 3; .@i > 0; .@i-- ){ announce "Top "+ .limit +" PVP Rewards will be given in "+.@i+" minutes, please login your characters to get the auto assigned rewards.",bc_all; sleep 60000; } //ITEM NAME ANNOUNCE ON THE DAY OF CLAIMING PRIZE // item id reward for top 10 pvp setarray .@itemid,50058,50006,50006,50006,50006,50006,50006,50006,50006,50006; // item quantity reward for top 10 pvp setarray .@itemid_qty,1,7,7,7,5,5,5,2,2,2; .@itemid_size = getarraysize( .@itemid ); query_sql ("SELECT c.`account_id`,c.`char_id` FROM `pvpladder` pvp INNER JOIN `char` c ON c.`char_id` = pvp.`char_id` WHERE pvp.`kills` > 0 ORDER BY pvp.`kills` DESC,pvp.`deaths` LIMIT "+.@itemid_size ,.@aid,.@cid ); .@cid_size = getarraysize( .@cid ); for ( .@i = 0; .@i < .@cid_size; .@i++ ) if ( .@aid[.@i] && isloggedin( .@aid[.@i],.@cid[.@i] ) ) { attachrid( .@aid[.@i] ); announce "Top "+( .@i+1 )+" PVP Rewards - "+strcharinfo(0)+" obtained "+.@itemid_qty[.@i]+"x "+getitemname( .@itemid[.@i] ),bc_all; } detachrid; query_sql( "SELECT `char_id` FROM `pvpladder` WHERE `kills` > 0 ORDER BY `kills` DESC,`deaths` LIMIT "+.limit,.@cid ); .@cid_size = getarraysize( .@cid ); for ( .@i = 0; .@i < .@cid_size; .@i++ ) query_sql("UPDATE `char` SET `pvpreward` = "+( .@i+1 )+" WHERE `char_id` = "+.@cid[.@i]+" LIMIT 1"); announce "Top 1 PVP Reward - "+.@cid_size+" players is selected as winner.",bc_all; //AUTO TRUNCATE DB announce "PVP Ladder Will Reset in Monday 12PM +8GMT. Claim your prize immediately",bc_all; end; } /* ALTER TABLE `char` ADD `pvpreward` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `fame`; //*/ - script PVPRESETLADDER#disable1 -1,{ //OnInit: OnMon1800: query_sql( "TRUNCATE `pvpladder`" ); announce "PVP Ladder completely reset.",bc_all; end; }
Card Stacking
in Script Requests
Posted
bump