radio_active Posted December 7, 2008 Posted December 7, 2008 I have been thinking that i would like to completely change the mailbox function. Basically when a user deletes there mail i dont want it removed from the SQL, i just want it hidden from there mailbox. I havnt looked into it as of yet but i think this would be very useful! Any ideas? Quote
radio_active Posted December 7, 2008 Author Posted December 7, 2008 Re: Changing a mailbox feature O yeah, that way all messages can still be read in the View Mails function and if users delete there mail its still readable because if you delete your mail with an advertising link in it, staff cannot see the mail. Quote
POG1 Posted December 7, 2008 Posted December 7, 2008 Re: Changing a mailbox feature an additional field in the mailbox table. Change all appropriate fields to something like this... WHERE `state` = '1' Have the default value to 1 and when the user goes to "delete" their mail it changes the value to 0. A better idea would be to log the mails in a separate table... Quote
radio_active Posted December 7, 2008 Author Posted December 7, 2008 Re: Changing a mailbox feature Hmmm yeah that second idea sounds nice and easy! Quote
Dylan Posted December 7, 2008 Posted December 7, 2008 Re: Changing a mailbox feature why don't you just send deleted mail to another useless table like 'dmessages' and add a new mailbox log to your staff 'deleted messages logs' or something its 5 a.m I don't have much idea. I'll post on this later. sorry didnt see that pog posted the same concept. Quote
radio_active Posted December 7, 2008 Author Posted December 7, 2008 Re: Changing a mailbox feature No i think Pogs 2nd idea is better, that why i just the game stats off the new mail table and i can frequently drop the mail table used by the users. Quote
HITMAN 17 Posted December 7, 2008 Posted December 7, 2008 Re: Changing a mailbox feature well my mailbox has that Quote
radio_active Posted December 7, 2008 Author Posted December 7, 2008 Re: Changing a mailbox feature Your mailbox has what, "Delete all messages"??? Quote
AlabamaHit Posted December 9, 2008 Posted December 9, 2008 Re: Changing a mailbox feature just add mail_old to your mail table. make it add a day every day in the crons and let it delete the mail automatically and completely remove the delete features. that is what i did in my old game. The users could not delete mail. but the mail was deleted automatically every 10 days Quote
POG1 Posted December 9, 2008 Posted December 9, 2008 Re: Changing a mailbox feature You only want mails that the user can see in the mail table or it will slow the queries down. It would be best to store any hidden mails in a separate table or database. Quote
Karlos Posted December 9, 2008 Posted December 9, 2008 Re: Changing a mailbox feature You only want mails that the user can see in the mail table or it will slow the queries down. It would be best to store any hidden mails in a separate table or database. Maybe select only what you need from table??? Quote
POG1 Posted December 9, 2008 Posted December 9, 2008 Re: Changing a mailbox feature think about it.. the more records in a table the longer queries will take because it will have to search through more data, Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.