Jump to content
MakeWebGames

Recommended Posts

Posted

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?

Posted

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.

Posted

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...

Posted

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.

Posted

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

Posted

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.

Posted

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???

Posted

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,

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...