cmd

I understand, but I kind of want to make the website full dynamic.. that way I can have a table for all main usages, energy, will and brave and in that table I can have a column with the userID and obviously the current and max energy, will and brave.. then have another table lets for example call it spend, within that table just have userID and money, crystals etc.. I just want to know the benefits of having these usages dynamic?

You see i'm making my own script, so just struggling with ideas.. so you think I should just store the key_name (energy) and key_value(100) ? What if I wanted to store the maximum value it can be for a user? some users may have 150 energy, 100 energy and so on, what approach does McCodes take for this?

I've been contemplating this for awhile now therefore I've turned to you guys for some suggestion's I was just wondering whether making usages (energy, will, brave, money, crystals) dynamic would be a good idea? The reason why I'm thinking it is because I want to make it easier for myself to control energy from the staff panel? for example, perhaps I want to change the name of energy to something else quickly? I dont know, I just want some of your opinions guys. If making the usages dynamic is a good idea could you please give a brief explanation of how to do such DB designs? Thanks :)

Good point, but do you not think rather than having to constantly retrieve the users money, username constantly to be displayed in the top bar it would be better to just store in session? - - - Updated - - -   Nice idea, but using ASP.NET their is an alternative for this which is a global method.. Session_End.. says it in its name.. surely you can achieve the same thing? Just insert everything in the DB when the Session_End is called right?

Just a little question to get people's preferences (it's always good to see different opinions) so I was just wondering when it comes to games what are peoples preferences? Do you prefer to either store the users energy, will, brave, money etc in sessions or just keep retrieving from the database?

I'd say take a DB approach to storing ratings and so on rather than hardcoding stuff, that way it'd make the website a little more dynamic

I agree Dayo, your tables could be much more normalized.. having a table for just posts then having a table for topics for example, suggesstions, question, general discussion etc.. then have another table for ratings, within the ratings you want to put the userID and the ratingID then have another table for ratings, given that id 1 within the ratings table is thanks and 2 is dislike and 3 is like.. quick example: Post(postID, ownerID*, post, subject, topicID*) Topics(topicID, topic) Ratings(ratingID, rating) post_ratings(ratingID*, postID*, userID*) user_posts(*postID, comments) Given that the bold parts are PK's and the asterisks are FK's etc.. just a suggestion to clean up your tables :)

You could perhaps rather than doing a conditional statement to check if a row already exists if the user has already rated the same, rather than doing that, nest your current conditional statements within a TRY/CATCH? then obviously make your table fields unique (post and user id) then just instantly try and insert? If the row already exists it will fall into the catch statement, thats when you display an error "you've already rated this post".. just a suggestion :}

can i grab a beta key too =)

Having saying that... after actually checking out your website I withdraw my application. The website requires too much work. Design is really really bad, who was thinking of the UX when designing it?? God damn, I had to hover over the links to know what is what!! Really frustrating

Would take on the opportunity, however I don't want to be using PHP. Instead I want to build it with C# .NET. If you want it to be built using PHP then ill have to skip:)

You have got a point, but do you not think if you get the game right at first then surely their wouldn't be a huge spike between the 2 types of users.. for example 99% of people will have £10,000 max and then the 1% would be in the millions? Surely, just by implementing additional gym features it couldn't cause such thing?

Damn, you are good!! All of your ideas are very good and thank you for taking your time to give me some wild ideas:) I think personal gyms would be perfect but if you also had gang gyms do you not think it would make the game far too crazy like their'd be too many gyms i guess? Right now, I have: Different gym levels Personal gyms Is their any suggestions on how gangs can influence the gym gains?

Hi everyone, I've noticed that a lot of you are very creative and have unique ideas, i was just wondering since i'm implementing my own gym does anyone have any suggestions for the gym itself? To make it more specific, im looking for ideas that is just more than your standard RPG gyms, perhaps unlock new gyms at different levels or something? Can anyone else give any suggestions that makes the gym much more entertaining and exciting? I'm kind of bad when it comes to generating my own ideas but I hope you can help!

Good work Dayo, looking forward to it:) And Coly regarding your suggestion of having a div popping up when the inventory button is clicked, I'm confused.. Do you mean modal? If so, I think that would be a good idea