Suggestion: Bump all of your active trades

Code: Select all

<?php
//                (     (     
//                )\ )  )\ )  
//               (()/( (()/(  
//              (/(_)) /(_)))   
//               |_ _| |_ _|  
//                | |   | |   
//               |___| |___|  
//                            
//            https://diablo2.io
//
//            <>~~~~~~<>~~~~~~<>
//
//         Bump all trades in one go
//
//        By Teebling (Copyright 2021).
//      Protected and registered with DMCA.    

// Start phpBB session management
$user->session_begin();
$auth->acl($user->data);

// Set const now to request UNIX timestamp when script executed
$now = time();

// Set window in which bumps are possible by subtracting six hours from $now
$sixhoursago = ($now - 21600);

// Get the current logged in user's ID (more secure than URL param)
$user_id_real = $user->data['user_id'];

// Query to update all trades with bump stuff in one go, if bumping is possible (out of timespan specified by $sixhoursago )
$sql = "UPDATE phpbb_topics SET topic_last_post_time = '" . $now . "', topic_bumped='1', topic_bumper='" . $user_id_real . "' WHERE forum_id=16 AND sold!=1 AND topic_poster='" . $user_id_real . "' AND topic_last_post_time < '" . $sixhoursago . "'";

?>

Code: Select all

// Get all active trades of a give user
$total_user_trades = "SELECT COUNT(*) FROM phpbb_topics WHERE forum_id = 16 AND sold != 1 AND topic_poster = '" . $user_id_real . "' ";

// Query to update all trades with bump stuff in one go, if bumping is possible (out of timespan specified by $sixhoursago )
$sql = "UPDATE phpbb_topics SET topic_last_post_time = '" . $now . "', topic_bumped='1', topic_bumper='" . $user_id_real . "' WHERE forum_id=16 AND sold!=1 AND topic_poster='" . $user_id_real . "' AND topic_last_post_time < '" . $sixhoursago . "'";

// How many trades have been bumped
$bumped_cnt =  @@ROWCOUNT;

// User receives a message 
>> "You've successfully bumped '" . $bumped_cnt . "' trades out of '" . $total_user_trades. "' total."