awesomazingxed Posted December 16, 2014 Group: Members Topic Count: 51 Topics Per Day: 0.01 Content Count: 95 Reputation: 1 Joined: 10/24/14 Last Seen: August 7, 2015 Share Posted December 16, 2014 Can anyone help me here. Thanks in advance // ALTER TABLE `guild` ADD `storage_restriction` INT( 11 ) NOT NULL DEFAULT '0' - script Gstorage -1,{ .@char_id = getcharid(0); .@guild_id = getcharid(2); if( !.@guild_id ){ mes "You dont have any guild."; }else{ query_sql( "SELECT `storage_restriction` FROM `guild` WHERE `guild_id` = '"+.@guild_id+"'",.@restriction ); query_sql( "SELECT `position` FROM `guild_member` WHERE `char_id` = '"+.@char_id+"'",.@position ); switch( select( "Access Guild Storage",( .@position )?"":"Edit Restriction" ) ){ Case 1: if( .@restriction && .@restriction & ( 2 << .@position ) ){ mes "Your position cant access this Storage.."; }else{ mes "Storage opened."; guildopenstorage(); } break; Case 2: query_sql( "SELECT `position`,`name` FROM `guild_position` WHERE `guild_id` = '"+.@guild_id+"'",.@guild_position,.@guild_position_name$ ); do{ .@menu$ = ""; .@i = 1; while( .@i < .guild_max_position ){ .@menu$ = .@menu$ + (( .@restriction & ( 2 << .@i) )?"^FF0000[Disabled]":"^EE55FF[Enabled]" )+" "+.@guild_position_name$[.@i] +"^000000" +":"; .@i++; } mes "Select a Position"; mes "^FF0000RED - Disable Access^000000"; .@i = select( .@menu$+":Done" ); if( .@i <= .guild_max_position ){ .@bitvalue = ( 2 << .@i ); if( .@restriction & .@bitvalue ){ .@restriction -= .@bitvalue; mes "Position : ^0055FF"+.@guild_position_name$[.@i]+"^000000 granted Storage Access."; }else{ mes "Position : ^0055FF"+.@guild_position_name$[.@i]+"^000000 disabled Storage Access."; .@restriction += .@bitvalue; } next; } }while( select( "Continue Edit","Finished Edit" ) == 1 ); query_sql( "UPDATE `guild` SET `storage_restriction` = '"+.@restriction+"' WHERE `guild_id` = '"+.@guild_id+"'" ); mes "Guild Storage Restriction updated."; default: break; } } close; OnInit: .guild_max_position = 20; end; } Quote Link to comment Share on other sites More sharing options...
Radian Posted December 16, 2014 Group: Members Topic Count: 162 Topics Per Day: 0.04 Content Count: 1546 Reputation: 192 Joined: 07/23/14 Last Seen: June 24, 2024 Share Posted December 16, 2014 What emulator are you using ?? Quote Link to comment Share on other sites More sharing options...
awesomazingxed Posted December 16, 2014 Group: Members Topic Count: 51 Topics Per Day: 0.01 Content Count: 95 Reputation: 1 Joined: 10/24/14 Last Seen: August 7, 2015 Author Share Posted December 16, 2014 What emulator are you using ?? Eathena Quote Link to comment Share on other sites More sharing options...
Radian Posted December 16, 2014 Group: Members Topic Count: 162 Topics Per Day: 0.04 Content Count: 1546 Reputation: 192 Joined: 07/23/14 Last Seen: June 24, 2024 Share Posted December 16, 2014 Try this one. not tested. // ALTER TABLE `guild` ADD `storage_restriction` INT( 11 ) NOT NULL DEFAULT '0' - script Gstorage -1,{ set .@char_id = getcharid(0); set .@guild_id = getcharid(2); if( !.@guild_id ){ mes "You dont have any guild."; }else{ query_sql( "SELECT `storage_restriction` FROM `guild` WHERE `guild_id` = '"+.@guild_id+"'",.@restriction ); query_sql( "SELECT `position` FROM `guild_member` WHERE `char_id` = '"+.@char_id+"'",.@position ); switch( select( "Access Guild Storage",( .@position )?"":"Edit Restriction" ) ){ Case 1: if( .@restriction && .@restriction & ( 2 << .@position ) ){ mes "Your position cant access this Storage.."; }else{ mes "Storage opened."; guildopenstorage(); } break; Case 2: query_sql( "SELECT `position`,`name` FROM `guild_position` WHERE `guild_id` = '"+.@guild_id+"'",.@guild_position,.@guild_position_name$ ); do{ .@menu$ = ""; .@i = 1; while( .@i < .guild_max_position ){ .@menu$ = .@menu$ + (( .@restriction & ( 2 << .@i) )?"^FF0000[Disabled]":"^EE55FF[Enabled]" )+" "+.@guild_position_name$[.@i] +"^000000" +":"; .@i++; } mes "Select a Position"; mes "^FF0000RED - Disable Access^000000"; .@i = select( .@menu$+":Done" ); if( .@i <= .guild_max_position ){ .@bitvalue = ( 2 << .@i ); if( .@restriction & .@bitvalue ){ .@restriction -= .@bitvalue; mes "Position : ^0055FF"+.@guild_position_name$[.@i]+"^000000 granted Storage Access."; }else{ mes "Position : ^0055FF"+.@guild_position_name$[.@i]+"^000000 disabled Storage Access."; .@restriction += .@bitvalue; } next; } }while( select( "Continue Edit","Finished Edit" ) == 1 ); query_sql( "UPDATE `guild` SET `storage_restriction` = '"+.@restriction+"' WHERE `guild_id` = '"+.@guild_id+"'" ); mes "Guild Storage Restriction updated."; default: break; } } close; OnInit: .guild_max_position = 20; end; } @TC Why not upgrade your emulator to the latest like rAthena? Quote Link to comment Share on other sites More sharing options...
awesomazingxed Posted December 18, 2014 Group: Members Topic Count: 51 Topics Per Day: 0.01 Content Count: 95 Reputation: 1 Joined: 10/24/14 Last Seen: August 7, 2015 Author Share Posted December 18, 2014 still not working~ Quote Link to comment Share on other sites More sharing options...
Emistry Posted December 18, 2014 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2370 Joined: 10/28/11 Last Seen: Sunday at 05:32 PM Share Posted December 18, 2014 The conversion can be done by refer this http://rathena.org/board/topic/78263-scripting-faqtipstricks/?p=267219 eathena doesnt support direct variable assigning. must use set Quote Link to comment Share on other sites More sharing options...
Question
awesomazingxed
Can anyone help me here. Thanks in advance
// ALTER TABLE `guild` ADD `storage_restriction` INT( 11 ) NOT NULL DEFAULT '0' - script Gstorage -1,{ .@char_id = getcharid(0); .@guild_id = getcharid(2); if( !.@guild_id ){ mes "You dont have any guild."; }else{ query_sql( "SELECT `storage_restriction` FROM `guild` WHERE `guild_id` = '"+.@guild_id+"'",.@restriction ); query_sql( "SELECT `position` FROM `guild_member` WHERE `char_id` = '"+.@char_id+"'",.@position ); switch( select( "Access Guild Storage",( .@position )?"":"Edit Restriction" ) ){ Case 1: if( .@restriction && .@restriction & ( 2 << .@position ) ){ mes "Your position cant access this Storage.."; }else{ mes "Storage opened."; guildopenstorage(); } break; Case 2: query_sql( "SELECT `position`,`name` FROM `guild_position` WHERE `guild_id` = '"+.@guild_id+"'",.@guild_position,.@guild_position_name$ ); do{ .@menu$ = ""; .@i = 1; while( .@i < .guild_max_position ){ .@menu$ = .@menu$ + (( .@restriction & ( 2 << .@i) )?"^FF0000[Disabled]":"^EE55FF[Enabled]" )+" "+.@guild_position_name$[.@i] +"^000000" +":"; .@i++; } mes "Select a Position"; mes "^FF0000RED - Disable Access^000000"; .@i = select( .@menu$+":Done" ); if( .@i <= .guild_max_position ){ .@bitvalue = ( 2 << .@i ); if( .@restriction & .@bitvalue ){ .@restriction -= .@bitvalue; mes "Position : ^0055FF"+.@guild_position_name$[.@i]+"^000000 granted Storage Access."; }else{ mes "Position : ^0055FF"+.@guild_position_name$[.@i]+"^000000 disabled Storage Access."; .@restriction += .@bitvalue; } next; } }while( select( "Continue Edit","Finished Edit" ) == 1 ); query_sql( "UPDATE `guild` SET `storage_restriction` = '"+.@restriction+"' WHERE `guild_id` = '"+.@guild_id+"'" ); mes "Guild Storage Restriction updated."; default: break; } } close; OnInit: .guild_max_position = 20; end; }Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.