VIP Scripts

[ZelosAvalon]

i need a script for two items:

8036,Ticket Vip 15,Ticket Vip 15,0,50,,0,,,,,0xFFFFFFFF,7,2,,,,,,{ ????? },{},{} 15 days vips

8037,Ticket Vip 30,Ticket Vip 30,0,50,,0,,,,,0xFFFFFFFF,7,2,,,,,,{ ????? },{},{} 30 days vips

the item is consumable, and when someone use, will get time vip

and i need a script similar to that message "mtod" that appears whenever someone logs in, but this appears, the time vip that you possess, and the time remaining for your vip expires.

my sql vip table is located in: FROM `login` `vencimentoVip`

SELECT `ID` FROM `login` `account_id` `vencimentoVip` i need to configure query_sql to show, vip time when the char login.

and when i change it by item ticket vip or on website will show too!

Edited January 26, 2013 by ZelosAvalon

[Brian]

Here's one VIP Rental script: vip_rental.txt

It can be used in an item script or npc script:

{ callfunc "F_VIPstart", <ticks>; }

ticks = how long their VIP will last, in seconds

- 1 day = 86400

- 7 days = 604800

- 14 days = 1209600

etc.

Examples:

8036,Ticket_VIP_15,Ticket Vip (15 days),2,2,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc "F_VIPstart", 1296000; },{},{}
8037,Ticket_VIP_30,Ticket Vip (30 days),2,2,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc "F_VIPstart", 2592000; },{},{}

[ZelosAvalon]

Here's one VIP Rental script: vip_rental.txt

It can be used in an item script or npc script:

{ callfunc "F_VIPstart", <ticks>; }

ticks = how long their VIP will last, in seconds

- 1 day = 86400

- 7 days = 604800

- 14 days = 1209600

etc.

Examples:

8036,Ticket_VIP_15,Ticket Vip (15 days),2,2,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc "F_VIPstart", 1296000; },{},{}
8037,Ticket_VIP_30,Ticket Vip (30 days),2,2,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc "F_VIPstart", 2592000; },{},{}

ty man working , but if a player use the vip ticket 15 days and later use vip ticket 30 days, they don't add up, he loses the 15 days VIP, and won vip 30 days, instead of staying with 45 days vip.

you know how i can fix it ?

//========================================
//==Abaixo o controle dos dias vip
//========================================


- script vip -1,{

OnPCLoginEvent:
query_sql "SELECT `vencimentoVip` FROM `login` WHERE `account_id` = '"+ getcharid(3) +"'", .@vencimentoVip;
{
dispbottom "[VIP Control]: viptime "+.@vencimentoVip+".";
end;
}

}

//=========================================

my sql :

message when i log :

i need to show when i log : date vip will expire example :

Here's one VIP Rental script: vip_rental.txt

It can be used in an item script or npc script:

{ callfunc "F_VIPstart", <ticks>; }

ticks = how long their VIP will last, in seconds

- 1 day = 86400

- 7 days = 604800

- 14 days = 1209600

etc.

Examples:

8036,Ticket_VIP_15,Ticket Vip (15 days),2,2,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc "F_VIPstart", 1296000; },{},{}
8037,Ticket_VIP_30,Ticket Vip (30 days),2,2,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc "F_VIPstart", 2592000; },{},{}

ty man working , but if a player use the vip ticket 15 days and later use vip ticket 30 days, they don't add up, he loses the 15 days VIP, and won vip 30 days, instead of staying with 45 days vip.

you know how i can fix it ?

//========================================
//==Abaixo o controle dos dias vip
//========================================


- script vip -1,{

OnPCLoginEvent:
query_sql "SELECT `vencimentoVip` FROM `login` WHERE `account_id` = '"+ getcharid(3) +"'", .@vencimentoVip;
{
dispbottom "[VIP Control]: viptime "+.@vencimentoVip+".";
end;
}

}

//=========================================

my sql :

message when i log :

i need to show when i log : date vip will expire example :

Edited January 26, 2013 by ZelosAvalon

[Brian]

i need to show when i log : date vip will expire

Here you go:

-	script	vip_timeleft	-1,{
OnPCLoginEvent:
query_sql "SELECT UNIX_TIMESTAMP(`vencimentoVip`) FROM login WHERE account_id="+playerattached(), .@vencimentoVip;
if (.@vencimentoVip) {
	dispbottom "[Controle VIP] : expires in " + callfunc("Time2Str", .@vencimentoVip);
}
end;
}

ty man working , but if a player use the vip ticket 15 days and later use vip ticket 30 days, they don't add up, he loses the 15 days VIP, and won vip 30 days, instead of staying with 45 days vip.

you know how i can fix it ?

I fixed my script so if the player already has a VIP Rental, any new rentals will stack.

http://code.google.com/p/athena-scripts/source/detail?r=23

Edited January 30, 2013 by Brian

[ZelosAvalon]

-	script	vip_timeleft	-1,{
OnPCLoginEvent:
query_sql "SELECT UNIX_TIMESTAMP(`vencimentoVip`) FROM login WHERE account_id="+playerattached(), .@vencimentoVip;
if (.@vencimentoVip) {
	dispbottom "[Controle VIP] : expires in " + callfunc("Time2Str", .@vencimentoVip);
}
end;
}

dont work =(

ty man working , but if a player use the vip ticket 15 days and later use vip ticket 30 days, they don't add up, he loses the 15 days VIP, and won vip 30 days, instead of staying with 45 days vip.

you know how i can fix it ?

I fixed my script so if the player already has a VIP Rental, any new rentals will stack.

http://code.google.c...rce/detail?r=23

dont work too with this items :

8036,Ticket_VIP_15,Ticket Vip (15 days),2,2,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc "F_VIPstart", 1296000; },{},{}
8037,Ticket_VIP_30,Ticket Vip (30 days),2,2,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc "F_VIPstart", 2592000; },{},{}

Edited January 31, 2013 by ZelosAvalon

[Brian]

hmm maybe I misunderstood your SQL structure.

The expire time is stored in `login`.`vencimentoVip` as a datetime?

Try this instead:

-	script	vip_timeleft	-1,{
OnPCLoginEvent:
query_sql "SELECT TIMESTAMPDIFF(SECOND, NOW(),`vencimentoVip`) FROM login WHERE account_id="+playerattached(), .@seconds;
if (.@seconds > 0) {
	dispbottom "[Controle VIP] : expires in " + callfunc("Time2Str", gettimetick(2)+.@seconds);
}
end;
}

---

I edited my script and it works for me now. vip_rental.txt

Edited January 31, 2013 by Brian