Lua Help with script Vip_Time Modern AAC REP + + +

[Fagnerboff]

Could someone edit this script to add vip_time and not Premdays?

if(check_name($buy_name))
   {
    foreach($SQL->query('SELECT * FROM players WHERE name = "'.$buy_name.'"') as $buy_player)
    foreach($SQL->query('SELECT * FROM accounts WHERE id = "'.$buy_player["account_id"].'"') as $buy_account)
    $buy_player_account = $buy_account['name'];
    if($buy_player_account != "")
   {
if($_SESSION['viewed_confirmation_page'] == 'yes')
   {
if ($_POST['buy_confirmed'] == 'yes'){
if($buy_offer['offer_type'] == 'pacc')
   {
    $player_premdays = $buy_account['premdays']; //$buy_player_account->getCustomField('premdays');
    $player_lastlogin = $buy_account['lastday']; //$buy_player_account->getCustomField('lastday');
    $save_transaction = 'INSERT INTO z_shop_history_pacc (id, to_name, to_account, from_nick, from_account, price, pacc_days, trans_state, trans_start, trans_real) VALUES (NULL, \''.$buy_player["name"].'\', \''.$buy_account["id"].'\', \''.$buy_from.'\',  \''.$loggedAccId.'\', \''.$buy_offer['points'].'\', \''.$buy_offer['count1'].'\', \'realized\', \''.time().'\', \''.time().'\');';
    $SQL->query($save_transaction);
    $newPremDays=$player_premdays + $buy_offer['count1'];
    $premiumPoints = $premiumPoints - $buy_offer['points'];
    $SQL->query("UPDATE accounts SET premdays='".$newPremDays."', premium_points='".$premiumPoints."' WHERE name='".$buy_player_account."';");
if($player_premdays == 0)
   {
    $buy_player_account->setCustomField('lastday', time());
   }
echo '<h2>PACC added!</h2><b>'.$buy_offer['count1'].' days</b> of Premium Account have been added to the account of <b>'.$buy_player["name"].'</b>.<br /> <b>'.$buy_offer['points'].' premium points</b> have been deducted from your account.<br />You now have <b>'.$premiumPoints.' premium points</b>.<br /><a href="/index.php/p/v/shop">GO TO MAIN SHOP SITE</a>';
   }

 

[Piltrafa]

Like example:

if(check_name($buy_name))
{
foreach($SQL->query('SELECT * FROM players WHERE name = "'.$buy_name.'"') as $buy_player)
foreach($SQL->query('SELECT * FROM accounts WHERE id = "'.$buy_player["account_id"].'"') as $buy_account)
$buy_player_account = $buy_account['name'];
if($buy_player_account != "")
{
if($_SESSION['viewed_confirmation_page'] == 'yes')
{
if ($_POST['buy_confirmed'] == 'yes'){
if($buy_offer['offer_type'] == 'pacc')
{
$player_premdays = $buy_account['vipdays']; //$buy_player_account->getCustomField('vipdays');
$player_lastlogin = $buy_account['lastday']; //$buy_player_account->getCustomField('lastday');
$save_transaction = 'INSERT INTO z_shop_history_pacc (id, to_name, to_account, from_nick, from_account, price, vip_days, trans_state, trans_start, trans_real) VALUES (NULL, \''.$buy_player["name"].'\', \''.$buy_account["id"].'\', \''.$buy_from.'\', \''.$loggedAccId.'\', \''.$buy_offer['points'].'\', \''.$buy_offer['count1'].'\', \'realized\', \''.time().'\', \''.time().'\');';
$SQL->query($save_transaction);
$newVipDays=$player_vipdays + $buy_offer['count1'];
$premiumPoints = $premiumPoints - $buy_offer['points'];
$SQL->query("UPDATE accounts SET vipdays='".$newVipDays."', premium_points='".$premiumPoints."' WHERE name='".$buy_player_account."';");
if($player_vipdays == 0)
{
$buy_player_account->setCustomField('lastday', time());
}
echo '<h2>VIP added!</h2><b>'.$buy_offer['count1'].' days</b> of Vip Account have been added to the account of <b>'.$buy_player["name"].'</b>.<br /> <b>'.$buy_offer['points'].' premium points</b> have been deducted from your account.<br />You now have <b>'.$premiumPoints.' premium points</b>.<br /><a href="/index.php/p/v/shop">GO TO MAIN SHOP SITE</a>';
}

Try, and say me if works fine.

 

[_Arthur]

Like example:


Try, and say me if works fine.

That won't work..

 

[Fagnerboff]

Originally Posted by Vitich
Like example:


Try, and say me if works fine.

It did not work
Gave the following error.

Glad you're trying to help.
While others appear only to criticize.

 

[Fagnerboff]

upppp.

 

[Piltrafa]

whats vip system are you using? maybe it give me more ideas to help you.

 

[Fagnerboff]

whats vip system are you using? maybe it give me more ideas to help you.

Mock Vip System

 

[Piltrafa]

Its got table in accounts like - vipdays?

 

[Fagnerboff]

Sua tabela tem nas contas como - vipdays?

yes