viewing paste Unknown #15966 | Text

Posted on the
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
//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
 
//======================================================================================================
// - SQL TABLE
/*
CREATE TABLE IF NOT EXISTS `guildpack` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(11) NOT NULL default '0',
  `name` varchar(23) NOT NULL default '',
  `last_ip` varchar(100) NOT NULL default '',
  PRIMARY KEY (`account_id`),
  KEY (`id`)
) ENGINE=MyISAM;
*/
//======================================================================================================
 
map,x,x,x       script  GPack NPC       x,{
 
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
 
                                getitem2 17638,1,1,8,0,0,0,0,0;
                                getitem2 17639,1,1,8,0,0,0,0,0;
                                getitem2 17640,1,1,8,0,0,0,0,0;
                                getitem 17641,1;
                                getitem2 17642,1,1,8,0,0,0,0,0;
                                getitem 2449,1;
                                getitem 17620,5;
                                getitem 12202,20;
                                getitem 12203,20;
                                getitem 12204,20;
                                getitem 12206,20;
                                getitem 12207,20;
                                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===//
 
mapname mapflag nocommand       99
mapname mapflag restricted      6
mapname mapflag nosave  SavePoint
mapname mapflag nomemo
mapname mapflag noreturn
mapname mapflag nobranch
mapname mapflag noloot
mapname mapflag noskill
mapname mapflag novending
mapname mapflag nowarpto        99
Viewed 288 times, submitted by unknown.