Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- `stocks`.`stID` = UNIQUE stock id
- `stock_purch`.`st_p_uID`, = players id that purchased the stocks
- `stock_purch`.`st_p_id`, = the stock id that was purchased (stocks.stID)
- `stock_purch`.`st_p_qty`, = the quantity OF stocks purchased
- `stock_purch`.`st_p_worth`, = the cumulative total OF money spent ON that particular stock
- `stock_locations`.`stLocPrice`, = the price OF the stock FOR that city
- `stock_locations`.`stLocId` = the location that stock will be displayed WITH (stLocPrice)
- FROM
- `users`
- LEFT JOIN
- `stock_purch`
- ON
- `stock_purch`.`st_p_uID` = `users`.`id`
- LEFT JOIN
- `stocks`
- ON
- `stocks`.`stID` = `stock_purch`.`st_p_id`
- LEFT JOIN
- `stock_locations`
- ON
- `stock_locations`.`stLocId` = `stock_purch`.`st_p_id`
- WHERE
- `stock_purch`.`st_p_id` = `stock_locations`.`stockID` AND `stock_purch`.`st_p_uID` = ? AND `stock_locations`.`stLocId` = ?", $userId, CurrentPlayerLocation());
Advertisement
Add Comment
Please, Sign In to add comment