Jump to content

Legacy

Members
  • Posts

    21
  • Joined

  • Last visited

1 Follower

Profile Information

  • Gender
    Male
  • Location
    Philippine

Recent Profile Visitors

2,105 profile views

Legacy's Achievements

Poring

Poring (1/15)

0

Reputation

  1. Legacy

    CentOS7

    Hello rAthena! It's been awhile since my last post here in rathena. I guess its almost 7 years xd and many things change. Can someone teach me how to set up the server in centos 7? I already bought 5$ droplet on Digital Ocean however I don't know to set it up. "Why didn't you try to search here since its too many guide?" - I tried it but its so hard for me to take all of it. I'm using Windows Server before right now I want to study Linux as Server Host. I don't have plan to start a server as of now I'm still studying making scripts.
  2. Is there a way how I can make a SQL for that?
  3. Im using this script jTynne Personal Scavenger Script http://jtynne.com/rAthena/scripts/examples/personalscavenger.txt I encounter this problem How to solve this? [SQL]: DB error - INSERT command denied to user 'ragnarok'@'ADRIAN-PC' for table 'scavenger' [Debug]: at d:\rathenaclean\src\map\script.c:14605 - insert into `game_data`.`scavenger` (`char_id`,`score`,`completed`,`failed`,`alltimescore`,`alltimecompleted`,`alltimefailed`) VALUES ('150004', '0', '0', '0', '0', '0', '0') [Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346) [SQL]: DB error - SELECT command denied to user 'ragnarok'@'ADRIAN-PC' for table 'scavenger' [Debug]: at d:\rathenaclean\src\map\script.c:14605 - select game_data.scavenger.score AS score , game_data.char.name AS charname FROM game_data.scavenger, game_data.char WHERE game_data.scavenger.char_id = game_data.char.char_id ORDER BY game_data.scavenger.score DESC LIMIT 10 [Debug]: Source (NPC): Scavenger Rankings at quiz_02 (366,346) [SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist [Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `score` = `score` + '1' WHERE `char_id` = '150004' [SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist [Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346) [SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist [Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `alltimescore` = `alltimescore` + '1' WHERE `char_id` = '150004' [SQL]: DB error - Table 'ragnarok.scavenger' doesn't exist [Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346) [Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `completed` = `completed` + '1' WHERE `char_id` = '150004' [Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346) [Debug]: at d:\rathenaclean\src\map\script.c:14605 - UPDATE `scavenger` SET `alltimecompleted` = `alltimecompleted` + '1' WHERE `char_id` = '150004' [Debug]: Source (NPC): Personal Scavenger at quiz_02 (360,346) [SQL]: DB error - SELECT command denied to user 'ragnarok'@'BLOODLINE-PC' for table 'scavenger' [Debug]: at d:\rathenaclean\src\map\script.c:14605 - select game_data.scavenger.score AS score , game_data.char.name AS charname FROM game_data.scavenger, game_data.char WHERE game_data.scavenger.char_id = game_data.char.char_id ORDER BY game_data.scavenger.score DESC LIMIT 10 [Debug]: Source (NPC): Scavenger Rankings at quiz_02 (366,346)
  4. 1>------ Build started: Project: map-server_sql, Configuration: Debug Win32 ------ 1> skill.c 1>d:\rathenaclean\src\map\skill.c(496): error C2065: 'skillid' : undeclared identifier 1>d:\rathenaclean\src\map\skill.c(496): error C2065: 'skillid' : undeclared identifier 1>d:\rathenaclean\src\map\skill.c(496): error C2065: 'skillid' : undeclared identifier ========== Build: 0 succeeded, 1 failed, 2 up-to-date, 0 skipped ========== How to fix this??
  5. ok sir darristan tnx for responding even you are come from malaysia tnx again
  6. Tama po ang IP I use default IP dhil test server lang ) wala naman pong error na ngaganap :< I know now the problem its my Port in clientinfo.xml tnx for fast replying ) [[solve]]
  7. bakit po ung diff ko ay nag fafail to connect to server :< 2012-04-10 RagRE.exe hindi na po sya naka Read First Data Folder....
  8. baket po ung dye ko pag dating sa 4 - rest nagigigng ibat ibat kulay
  9. //========================================= - shop dyn_shop8 -1,50150 //========================================= ra_temsky,57,145,4 script Donation Armor Shop#8 966,{ mes Your Donation Coupon--[+countitem(.Cost)+]; close2; callshop dyn_shop+.a,1; npcshopattach dyn_shop+.a; end; OnInit set .a,strnpcinfo(2); //========================================= set .Cost,7179; //========================================= setarray .buy_id[0],2383,2344,2346,2348,2350,2367,2381,2377,2382,2378,2379,2376,2380; setarray .buy_co[0],20,6,6,6,6,6,6,12,12,12,12,12,12; //========================================= npcshopitem dyn_shop8,.buy_id[0],.buy_co[0]; for(set .ik,1;.ikgetarraysize(.buy_id);set .ik,.ik+1){ npcshopadditem dyn_shop+.a,.buy_id[.ik],.buy_co[.ik]; } end; OnBuyItem getinventorylist; if(@bought_quantity[@i] = 0){ goto OnEnrd; end; } for(set @i,0;@igetarraysize(@bought_nameid);set @i,@i+1){ KeyWorld set [email protected], getiteminfo( @bought_nameid[[email protected]], 2 ); if ( [email protected] == 4 [email protected] == 5 [email protected] == 7 [email protected] == 8 ) set [email protected], [email protected] + 1; else { for( set [email protected],0; [email protected]@inventorylist_count; set [email protected], [email protected]+1 ) if ( @inventorylist_id[[email protected]] == @bought_nameid[[email protected]] ) break; if ( [email protected] == @inventorylist_count ) set [email protected], [email protected]+1 ; } for(set @i2,0;@i2getarraysize(.buy_id);set @i2,@i2+1){ if(@bought_nameid[@i]==.buy_id[@i2]){ set @gh,@gh+.buy_co[@i2]@bought_quantity[@i]; set @wh,@wh+getiteminfo(@bought_nameid[@i],6)@bought_quantity[@i]; } } } if ( [email protected] + @inventorylist_count 100 ) { announce [D-Shop] Can't hold more than 100 items.,bc_self; goto OnEnrd; } if(countitem(.Cost)@gh){ announce You do not have enough Reunited Donation Ticket.,bc_self; announce Contact ADMIN and try to donate.,bc_self; goto OnEnrd; end; }else{ if(@wh(MaxWeight-Weight)){ announce [D-Shop]Too heavy,bc_self; goto OnEnrd; end; }else{ delitem .Cost,@gh; for(set @i,0;@igetarraysize(@bought_nameid);set @i,@i+1){ getitem @bought_nameid[@i],@bought_quantity[@i]; } } } OnEnrd set @gh,0; set @wh,0; set @i,0; set @i2,0; deletearray @bought_quantity,getarraysize(@bought_quantity); deletearray @bought_nameid,getarraysize(@bought_nameid); end; } try this
×
×
  • Create New...

Important Information

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