guild pack giver

[darking123]

guys i want to add something to my guild pack script

we know that this scripts only records na IP address of the player;;

i want that also there account will be reported also the account that is desame with the IP of the other account

thank you

//Script Name: Guild Package NPC Giver
//Developer: ShogS
//Description:  This NPC will Give a Package for each Guild Member take Note: this NPC will record each player IP address to avoid abuse on players side by getting 2 Package in 1 IP
//Version: 1.0
//Some Explanation: Do not forget to set the items to a not tradeable Sample: 17638,91,99 = Can not be droped,sell,trade


quiz_01,317,215,5 script GPack NPC 897,{

set .@frnd2$,strcharinfo(0);
if(##Gpack == 1) goto L_AG;
mes "Hello There it seems you are belong to a Guild";
mes "On our Server Let me Give you A Present for Joining and";
mes "Playing On Our Server We Hope You will enjoy this Present";
next;
mes "These present are not tradable and not dropable";
next;
switch(select("Yes:No")) {
case 1:

query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@lip$); // recruits ip address
query_sql("SELECT last_ip FROM `guildpack`", .@flip$); // recruiter ip address and information
if ( .@lip$ == .@flip$ ) {
mes "^616D7EIt seems you and your Guild Mates are from IP Address: ^ff0000" + .@flip$ + "^000000. Sorry, but its not allowed.";
close;
}
query_sql("INSERT INTO `guildpack` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + .@lip$ + "')");

//THIS PART WERE all items they will get

getitem 13895,1;
set ##Gpack, 1;
warp "prontera",157,157;
close;

case 2:
mes "^616D7ENevermind~, You can come back again!";
close;
}end;

L_AG:
mes "^616D7EYou Already Given a Package";
close;

}

//==JUST RENAME or PLACE the Map Name here===//

quiz_01 mapflag nocommand 99
quiz_01 mapflag restricted 6
quiz_01 mapflag nosave SavePoint
quiz_01 mapflag nomemo
quiz_01 mapflag noreturn
quiz_01 mapflag nobranch
quiz_01 mapflag noloot
quiz_01 mapflag noskill
quiz_01 mapflag novending
quiz_01 mapflag nowarpto 99

[Mootie]

You should use mac addresses if you have harmony.....for the ip restriction will not work everyone can use vpn/hotspotshield to proxy their ip's

[darking123]

so i am requesting for not only recording there ip but also there accounts that got the gpack

[Fai T.Flowright]

You should use mac addresses if you have harmony.....for the ip restriction will not work everyone can use vpn/hotspotshield to proxy their ip's

yes i agreed with u mootie, but 1 more problem if using mac address some other user might be had same mac addresses its really rare but this phenomenan encountered by me last year not only on ro but also other games

[darking123]

You should use mac addresses if you have harmony.....for the ip restriction will not work everyone can use vpn/hotspotshield to proxy their ip's

yes i agreed with u mootie, but 1 more problem if using mac address some other user might be had same mac addresses its really rare but this phenomenan encountered by me last year not only on ro but also other games

ohh..so i am requesting for not only recording there ip but also there accounts that got the gpack

[Mootie]

so i am requesting for not only recording there ip but also there accounts that got the gpack

easy to make alot of accounts anyway to able to trace them properly is mac addresses lol

[darking123]

ow..i do not have harmony or any kind of gameguard

[Mootie]

Well that's the advantage of having gameguard you can do possible things.....well i hope someone helps you with this anyway.

[nanakiwurtz]

If you searched the forum, there's a script that will give the prize only to guild leader, and it'll be the guild leader's task to divide and share the prize equally to their members.

[AnnieRuru]

    query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@lip$);
   query_sql("SELECT last_ip FROM `guildpack`", .@flip$); // WTF is this line ?? select 1st line only ?
   if ( .@lip$ == .@flip$ ) {
       mes "^616D7EIt seems you and your Guild Mates are from IP Address: ^ff0000" + .@flip$ + "^000000. Sorry, but its not allowed.";
       close;
   }
   query_sql("INSERT INTO `guildpack` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + .@lip$ + "')");

I think this part is wrong

it should be

    if ( query_sql( "select 1 from guildpack where last_ip = "+ getcharip(), .@dummy ) ) {
       mes "^616D7EIt seems you and your Guild Mates are from IP Address: ^ff0000" + .@flip$ + "^000000. Sorry, but its not allowed.";
       close;
   }
   query_sql("INSERT INTO `guildpack` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + getcharip() + "')");

@Mootie

hard to tell, I can also go play in CC and claim the item, and go back home to claim another item

since the mac_address is dynamic to your hardware setting,

if you use different computer + different IP, you can bypass this also

@nanakiwurtz

mes "These present are not tradable and not dropable";

you went off-topic

[nanakiwurtz]

I mean, why not use another script than this kind of script that logs users IP address, because if they played in a public internet cafe, there's always will be a problem like this.

[AnnieRuru]

I mean, why not use another script than this kind of script that logs users IP address, because if they played in a public internet cafe, there's always will be a problem like this.

lol, there's no known way to counter the players for bypassing item giver script

I always refuse for private server giving out newbie items, it always create problems

I prefer starter kit only comes with donations ( pay to rent the item for x days )

well, at least this is what I've learned after working on quite a few servers

guild leader's task to divide and share the prize equally to their members.

I can also create a guild on my own and create more accounts/characters to join the guild until meet the members requirement lol

[ShogS]

@glemor123 I'll update you soon about this request.

Edited January 16, 2013 by ShogS

[Emistry]

i believe using

Cant Trade
Cant Transfer
Cant Vending
Cant Mail
Cant Drop

would be an ideal solutions for you if and only if these items are only obtainable through your guild pack and no other way for it...

IP / Mac address are easy manipulated by players if they know how ...stated by annie above..

[darking123]

we know that the script i posted above only records IP address and it is easy to bypass..just wait for your ip address to reset in 24 hours then boom your account again can be able to get the gpack..i want that accounts that got the gpack would be recorded also..

another request is when the ip address is recorded and the current account...i want that all accounts that have same ip address with the first account that took the gpack would be recorded and cannot get anymore gpack..

so to shorten this up i want Accounts to be recorded also not only ip

[AnnieRuru]

if(##Gpack == 1) goto L_AG;
....
set ##Gpack, 1;
.....
L_AG:
mes "^616D7EYou Already Given a Package";
close;

seriously ... its already in the script ...

[darking123]

if(##Gpack == 1) goto L_AG;
....
set ##Gpack, 1;
.....
L_AG:
mes "^616D7EYou Already Given a Package";
close;

seriously ... its already in the script ...

oic thank you

[paragon008]

is it 1 time use only? i want to make it usable every woe..how to refresh the ip/account?

[fallen0519]

May I asked where is the sql executed script? Hmm.... or it's auto execute to the sql database.