cutekram

Members
  • Content count

    20
  • Avg. Content Per Day

    0
  • Joined

  • Last visited

Community Reputation

0 Neutral

About cutekram

  • Rank
    Poring

Profile Information

  • Gender
    Male
  • Location
    australia
  1. cutekram

    Utility: [SQL] Mission Board

    I need help pls how to fix this i put this onto my SQL /* DROP TABLE IF EXISTS `mission_board`; CREATE TABLE IF NOT EXISTS `mission_board` ( `id` int(11) unsigned NOT NULL, `title` varchar(30) NOT NULL default '', `desc` varchar(255) NOT NULL default '', `mob_list` varchar(50) NOT NULL default '', `mob_qty` varchar(50) NOT NULL default '', `item_list` varchar(50) NOT NULL default '', `item_qty` varchar(50) NOT NULL default '', `class_limitation` int(11) unsigned NOT NULL default '0', `class_branch` int(11) unsigned NOT NULL default '0', `min_lv` smallint(6) unsigned NOT NULL default '1', `max_lv` smallint(6) unsigned NOT NULL default '99', `repeat` smallint(6) unsigned NOT NULL default '0', `duration` int(11) unsigned NOT NULL default '0', `reward_list` varchar(50) NOT NULL default '', `reward_qty` varchar(50) NOT NULL default '', `base_exp` int(11) unsigned NOT NULL default '0', `job_exp` int(11) unsigned NOT NULL default '0', `zeny` int(11) unsigned NOT NULL default '0', `cash` int(11) unsigned NOT NULL default '0', `aid` int(11) unsigned NOT NULL default '0', `name` varchar(30) NOT NULL default '', `time_update` datetime NOT NULL default '0000-00-00 00:00:00', `npc_id` varchar(255) NOT NULL default '', `redo_delay` smallint(6) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `player_mission`; CREATE TABLE IF NOT EXISTS `player_mission` ( `id` int(11) unsigned NOT NULL, `mission_id` int(11) unsigned NOT NULL, `aid` int(11) unsigned NOT NULL default '0', `cid` int(11) unsigned NOT NULL default '0', `name` varchar(30) NOT NULL default '', `mob_hunt` varchar(50) NOT NULL default '', `expire` int(11) unsigned NOT NULL default '0', `starting` datetime NOT NULL default '0000-00-00 00:00:00', `completion` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; */ then rest is the script but i have this error : DB error - Table 'ragnarok.mission_board' doesnt exist [Debug]: at script.c:16142 - SELECT 'id IN ( SELECT 'id FROM 'mission_board ect ect ect Can someone can help me pls.?
  2. cutekram

    Who's Online Event (random pick of online player)

    Sir how to add time for example i want it to set 4 times a day if i would like to pick 12PM 5PM 9PM it this gonna be like this? OnInit: OnClock1200: OnClock1700: OnClock2100: set .LuckyTime,rand(24); OnMinute00: if( gettime(3) == .LuckyTime ){
  3. cutekram

    Utility: Reach to the Max

    thank you sir FORD more POWER !!!! THANKS
  4. cutekram

    Donation setup

    Could anyone can guide and help me to setup up my Donation in my website. pls??
  5. cutekram

    Utility: Reach to the Max

    @F O R D Thanks and how can i make it announce in yellow color?
  6. cutekram

    Utility: Reach to the Max

    how can i add a announce to people got a reward when they reach to 99 help pls
  7. cutekram

    Request script pls!

    share please:)
  8. cutekram

    Request a Script Rathena.

    can you please help me how to make it like they sell 4 any normal cards then = 1 Card album? how can i change it please help me. Thank you in advance
  9. cutekram

    Need Help changing time on script.

    Thank you so much!!!
  10. in E-Inquiry can you help me how to add into my SQL table step by step. after adding SQL table do i need to recompile?
  11. cutekram

    EL Dragon's Scripts

    how can i check it sir?
  12. Im sorry sir im a bit new. ok sir i will wait for it thank you so much!!
  13. cutekram

    EL Dragon's Scripts

    i have mine actually if i @afk it will automatically like @autotrade it goes logout when i put that script and then it just said @afk then @afk ON but that headgear havent show in the game how is that?
  14. can someone can help me how can i change this into monday to friday exp rate 20x20x time around 19:00 to 21:00 PM please help me thank you //===== EinherjarRO Scripts ================================== //= Floating Rates //===== By: ================================================== //= Stolao //===== Current Version: ===================================== //= 1.07 //===== Compatible With: ===================================== //= rAthena SVN //===== Description: ========================================= //= Floating Rates //===== Uses: ================================================ //= Exp and Item Rates Change Dynaimcally based on Online //= Player count and a configurable variables //===== Comments: ============================================ //= [stolao] //= Optimize] //= In Game Menu / @Command? //===== Additional Comments: ================================= //= 1.00 Origional Make //= 1.01 Removed Unessisary Line //= 1.02 Added Config //= 1.03 Made auto collect base rates //= 1.04 Fixed a bug where would keep increasing every hour //= 1.05 Made Multipliers into an array //= 1.06 Fixed typos //= 1.07 Fixed Set -> setarray //===== Contact Ifo: ========================================= //= [stolao] //= Email: [email protected] //============================================================ - script floating_rate -1,{ OnMinute30: set [email protected], getusers(1); set [email protected], rand(.Random[0],.Random[1]); setbattleflag( "base_exp_rate", .R[0] + ([email protected] + [email protected]) * .ExpMulti[0]); setbattleflag( "job_exp_rate", .R[1] + ([email protected] + [email protected]) * .ExpMulti[1]); setbattleflag( "item_rate_common", .R[2] + ([email protected] + [email protected]) * .ItemMulti[0]); setbattleflag( "item_rate_heal", .R[3] + ([email protected] + [email protected]) * .ItemMulti[1]); setbattleflag( "item_rate_use", .R[4] + ([email protected] + [email protected]) * .ItemMulti[2]); setbattleflag( "item_rate_equip", .R[5] + ([email protected] + [email protected]) * .ItemMulti[3]); atcommand "@reloadmobdb"; Announce "[server]: Rates are now "+getbattleflag("base_exp_rate")/100+""+((getbattleflag("base_exp_rate")%100)?"."+getbattleflag("base_exp_rate")%100:"")+"/"+getbattleflag("job_exp_rate")/100+""+((getbattleflag("job_exp_rate")%100)?"."+getbattleflag("job_exp_rate")%100:"")+"/"+getbattleflag("item_rate_common")/100+""+((getbattleflag("item_rate_common")%100)?"."+getbattleflag("item_rate_common")%100:"")+" !",8; end; OnInit: // Multiplier Per Player and .Random // Each point is .01x Increase in exp rates // [0] = Base Exp // [1] = Job Exp // eg: rand = 75 , getuser = 100, Multi = 3 // rates will be increase by 5.25x setarray .ExpMulti ,3,3; // Multiplier Per Player and .Random // Each point is .01x Increase in exp rates // [0] = Common Items // [1] = Healing Items // [2] = Useable Items // [3] = Equipment Items // eg: rand = 75 , getuser = 100, Multi = 1 // rates will be increase by 1.75x setarray .ItemMulti,1,1,1,1; // The Random Variable Min and Max // [0] = Min // [1] = Max setarray .Random,0,100; end; OnInterIfInitOnce: // Dont Touch // Used to collect the base rates setarray .R, getbattleflag("base_exp_rate"), getbattleflag("job_exp_rate"), getbattleflag("item_rate_common"), getbattleflag("item_rate_heal"), getbattleflag("item_rate_use"), getbattleflag("item_rate_equip"); end; }