71.out and website issues

Please report Bugs and Problems here

Moderator: FSAirlines Staff

Locked
JJacobs

71.out and website issues

Post by JJacobs » Tue Jun 06, 2006 8:03 pm

there are some db issues of a bunch of times where a lot of text shows up
UPDATE FlyNET_Logs Set Status='2' WHERE ID='4132';
UPDATE FlyNET_Routes SET State='0' WHERE ID='5135';
UPDATE FlyNET_Aircrafts SET Status='0' WHERE ID='1367';
UPDATE FlyNET_Pilots SET Location='YSSY' WHERE ID='71';
UPDATE FlyNET_Aircrafts SET Location='YSSY' WHERE ID='1367';
UPDATE FlyNET_Aircrafts SET Fuel='7228' WHERE ID='1367';
UPDATE FlyNET_Pilots SET Budget='131343' WHERE ID='71';
UPDATE FlyNET_VirtualAirlines SET Budget='179339951' WHERE ID='329';
DELETE FROM FlyNET_Accounts_VA WHERE VA_ID='329' AND Value='115628500' AND Reason='Flight revenue' AND TS='1149620280';
INSERT INTO FlyNET_Accounts_VA (VA_ID, Value, Reason, TS) VALUES ('329', '115628500', 'Flight revenue', '1149620280');
UPDATE FlyNET_VirtualAirlines SET Reputation='120.00' WHERE ID='329';
UPDATE FlyNET_Aircrafts SET Value='215078596', StateEng1='97.763000', StateEng2='97.763000', StateEng3='0.000000', StateEng4='0.000000', StateGear='97.763000', StateHull='97.763000' WHERE ID='1367';
DELETE FROM FlyNET_Reports WHERE TS='1149620280' AND Pilot_ID='71';
INSERT INTO FlyNET_Reports (AC_Type, AC_ID, PIC, PID, VA, Dep, Pln_Arr, Arr, Deptime, Arrtime, TS, Rating, Ratingreasons, Distance, PAX, Ticket, Crew, Salary, Fuelprice, Fuel_Bought, Fuel_Used, Profit, Pilot_ID, VA_ID, Number, FlightState, Version, Simrate, Hours, Multiplier, Bonus, Cargo, Cargo_kg, FlightType) VALUES ('B773','1367','Jerry Jacobs','COA102','Constitution Airlines','KLAX','YSSY','YSSY','609','1848','1149620280','100','','6520','376','701','1880','25695','1.18','108203','132772','231257','71','329','LONG100','On Block','v0.5.8b','1','12.650000','500', '42825', '109987', '41400', '0');

Locked