Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- }else if (isset($_GET['activateRequest'])){
- $Data = explode("/", $user->decrypt($_GET['activateRequest']));
- // $Data[0] = Quietschie ID ( Interessent )
- // $Data[1] = Auktions ID ( tradeshift id )
- // $Data[2] = Schicht ID ( Interessent / damit will er tauschen )
- // Step 1: Schicht ID des Inserat Erstellers besorgen
- $mysqli->where('id', $Data[1]);
- $TradeShiftId = $mysqli->GetOne('tradeshift');
- if ( $mysqli->count > 0 ) // Wenn es die Schicht gibt
- {
- // Step 2: Update "active" Row in Tabelle traderequest
- $Updatedata = Array ( 'active' => 1 );
- $mysqli->where('quietschi_id', $Data[0]);
- $mysqli->where('auction_id', $Data[1]);
- $mysqli->update('traderequest', $Updatedata);
- // Step 3: Update "activetrade" Row in Tabelle tradeshift
- $Updatedata = Array ( 'activetrade' => 1 );
- $mysqli->where('id', $Data[1]);
- $mysqli->update('tradeshift', $Updatedata);
- // Step 4: Update "ontrade" Row in Tabelle zuweisungen
- // Step 4.1 Get traderequest Id
- $mysqli->where('quietschi_id', $Data[0]);
- $mysqli->where('auction_id', $Data[1]);
- $RequestID = $mysqli->GetOne('traderequest');
- // Step 4.2 paste it to ontrade Row
- $Updatedata = Array ( 'ontrade' => $RequestID['id'] );
- $mysqli->where('shift_id', $TradeShiftId['shift_id']);
- $mysqli->where('quietschi_id', $Data[0]);
- $mysqli->update('zuweisungen', $Updatedata);
- // Step 5 Inform Auction Owner that someone wants to trade
- // Step 5.1 Get Quietschie informations
- $MailData = $mysqli->rawQuery('SELECT workshift.name, workshift.start, workshift.end, quietschies.f_name, quietschies.l_name, quietschies.mail FROM workshift INNER JOIN tradeshift ON workshift.id = tradeshift.shift_id INNER JOIN quietschies ON tradeshift.quietschie_id = quietschies.id WHERE tradeshift.id = '.$Data[1].'');
- if ( $mysqli->count > 0 )
- {
- // Get Interessent Schicht Infos
- $mysqli->where('id', $Data[2]);
- $Shift = $mysqli->GetOne('workshift');
- $MailMessage = '
- <strong>Hallo '.$MailData['f_name'].' '.$MailData['l_name'].',</strong>
- <br /><br />
- soeben wurde ein Tausch für deine Auktion der Schicht "'.$MailData['name'].' am '.date('d.m.Y', $MailData['start']).'" angeboten.
- Der Interessent bietet dir folgende Schicht zum tausch an: <br /> <br />';
- $TauschContent = '<h1>Schicht tauschen</h1>
- <div class="InnerUnderline"></div>
- <div class="Success">Der Inserat Ersteller wurde über dein Tauschangebot informiert. Bitte überprüfe regelmäßig deine Emails.</div>';
- }else{
- }
- }
- // Send Trade Info to auctionowner
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement