Patskie

switch( select( "Prize 1","Prize 2","Prize 3","Prize 4","Prize 5","Prize 6","Prize 7","Prize 8","Prize 9","Prize 10","Prize 11","Prize 12","Prize 13","Prize 14","Prize 15","Prize 16","Prize 17","Prize 18","Prize 19","Prize 20","Prize 21","Prize 22","Prize 23","Prize 24" ) ) { Case 1: getitem 7073,1; break; Case 2: getitem 7074,1; break; Case 3: getitem 7075,1; break; Case 4: getitem 7076,1; break; Case 5: getitem 7077,1; break; Case 6: getitem 7078,1; break; Case 7: getitem 7079,1; break; Case 8: getitem 7081,1; break; Case 9: getitem 7080,1; break; Case 10: getitem 7081,1; break; Case 11: getitem 7082,1; break; Case 12: getitem 7083,1; break; Case 13: getitem 7084,1; break; Case 14: getitem 7085,1; break; Case 15: getitem 7086,1; break; Case 16: getitem 7087,1; break; Case 17: getitem 7088,1; break; Case 18: getitem 7089,1; break; Case 19: getitem 7090,1; break; Case 20: getitem 7091,1; break; Case 21: getitem 7092,1; break; Case 22: getitem 7837,1; break; Case 23: getitem 7831,1; break; Case 24: getitem 7832,1; break; default: break;

Try : payon,150,150,0 script Sample 100,{ percentheal -100, 0; warp "prontera",150,150; end; }

Try - script Sample -1,{ OnPCBaseLvUpEvent: if ( BaseLevel != 90 || Gave ) end; getitem 731,1; // item that gives the minus drop rate set Gave, 1; end; }

Primary key should be unique. In your case you are duplicating a data in a column which is considered a primary key

Edited the last post. Set your map you wish to be in pvp mode during night. I guess no command will make all maps go into pvp on unless you specify them one by one.

Only inventory? or also includes items in storage, mail, auction and so on.

Ang besides if player update his name through sql and exceeds 23 characters it will be deleted.

Try - script Sample -1,{ OnPCLoginEvent: if ( getgmlevel() ) end; atcommand "@kick " +strcharinfo(0); end; }

http://rathena.org/wiki/SVN_Checkout

Nice

- script Sample -1,{ setarray .map$[0], "prontera", "payon", "morroc"; set .size, getarraysize(.map$); if ( isnight() ) { for ( set .@i, 0; .@i < .size; set .@i, .@i + 1 ) pvpon .map$[.@i]; } else { for ( set .@i, 0; .@i < .size; set .@i, .@i + 1 ) pvpoff .map$[.@i]; } end; }

When player log in, this event will be triggered. It will display your current cash and kafra points. OnPCLoginEvent: dispbottom "You currently have " +#CASHPOINTS+ " cash points"; dispbottom "You currently have " +#KAFRAPOINTS+ " kafra points"; end; When you use @checkpoints, this event will be triggered. It will display your current cash and kafra points. OnCheck: dispbottom "You currently have " +#CASHPOINTS+ " cash points"; dispbottom "You currently have " +#KAFRAPOINTS+ " kafra points"; end;

You didn't told that the check will be triggered when a certain player log in. Anyway edit the last post

@checkpoints command // @checkpoints - script Sample -1,{ OnInit: bindatcmd("checkpoints", strnpcinfo(3)+ "::OnCheck"); end; OnPCLoginEvent: dispbottom "You currently have " +#CASHPOINTS+ " cash points"; dispbottom "You currently have " +#KAFRAPOINTS+ " kafra points"; end; OnCheck: dispbottom "You currently have " +#CASHPOINTS+ " cash points"; dispbottom "You currently have " +#KAFRAPOINTS+ " kafra points"; end; }

Lol i am thinking of that too. but too lazy to edit hahaha

Try : // Extract name with title explode(.@name$, strcharinfo(0), " "); set .@real_name$, .@name$[1]; query_sql "UPDATE `char` SET `name` = '" + escape_sql(.@real_name$) + "' WHERE `char_id` = '" + getcharid(0) + "'"; end;

Like this? prontera,150,150,0 script Sample 100,{ .@check = ( countitem(501) ? 1 : 0 ); if ( .@check ) select("1:2:3:4"); else end; }

Try - script Sample -1,{ OnPCLoginEvent: if (getequipid(EQI_ARMOR) != 2302) end; unequip EQI_ARMOR; end; OnPCLogoutEvent: if (getequipid(EQI_ARMOR) != 2302) end; unequip EQI_ARMOR; end; }

I think : Sending money from western union online will need also your credit or debit card to pay. So i guess your player cannot use paypal because he or she doesn't have a credit or debit card and if that is the case then really it's the same thing. He cannot send money from western union through online and if that is the case then you cannot make an online payment method via western union on your flux control panel.

Either no guild or no castle owner of prtg_cas01 or woe is starting. When this is true then the script will end. if ( !getcharid(2) || !@gid || agitcheck() || agitcheck2() ) end;

Reference : http://rathena.org/wiki/Getusers getusers(0);

Maybe you can show error if any? 1. prontera,150,150,0<TAB>script<TAB>Sample<TAB>100,{ 2. The guild master can get the item in a chance of 30% Anyway this works fine on my test server.

oh sorry i forgot to ask..how can i use this points that im receiving? You can use it to purchase items. You can use this and set the currency value to #CASHPOINTS.