Welcome Guest ( Log In | Register )



2 Pages V  < 1 2  
 Reply to this topicStart new topic
> Making Something In Mysql Happen Only Once
PerHapsYouSeen
post Feb 20 2008, 11:35 AM
Post #11


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 23
Joined: 24-October 07
Member No.: 25,689
I don't know why my suggestion can not slove Feelay's problem ?

I make a column name 'last_received_points' which stores the last time he was received the bonus (supposing $last_received_points holds the last lever he was received bonus skillpoints)
then I combine with his lever, so it would exactly update just in once time
CODE
if ($user_level==5 and $last_received_points<5) {
update skillpoints;
}


if the user
QUOTE
"buy" health and strenght and stuff for theese points

I think it does not effect the last time he received bonus (or you can update it indepently if the user done sth above... if you want)
Go to the top of the page
 
+Quote Post
« Next Oldest · PHP · Next Newest »
 

2 Pages V  < 1 2
Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL Realtime Replication(4)
  2. Recover Tables From A MySQL .frm File(8)
  3. Flash Site Software(14)
  4. Making A Nice Looking Signature In Photoshop Cs(17)
  5. [PHP + MySQL] Encrypting Data(11)
  6. MySQL For EasyPHP Users(5)
  7. MySQL Output Database Question(18)
  8. Important: Basics Of Using PHP And MySQL(10)
  9. CuteNews: PHP-based Blog System - No MySQL(11)
  10. PHP & MySQL: Displaying Content From A Given ID(6)
  11. Navcat For MySQL(9)
  12. Qupis : Free Cpanel Web Hosting (one Line Text Ad At Bottom)(10)
  13. Making A Turn Based Game Like Ogame(9)
  14. Ajax + Php + Sql = Simply Superb! ( With Visitor Tracking )(11)
  15. Php Tutorial: Making A Shoutbox(12)
  1. Login System Using A Mysql Db(5)
  2. [php] Making Feeds Rss(3)
  3. How To: Display A Members/user List.(3)
  4. Any Website Provide Free Host Mysql Host?(4)
  5. Mysql Multiple Tables(1)
  6. Making Educational Game(4)
  7. What You Need Before You Can Create A Text-based Game..(7)
  8. Mysql Overhead(3)
  9. Help Making A Text Based Game.(8)
  10. Which Language Is Easy And Secure Today For Web Development(2)
  11. Login System(6)
  12. Small Issues About Mysql Connector/j 5.1(2)
  13. Making A Programming Language(6)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 5th December 2008 - 02:06 AM
Powered By IP.Board 2.2.1 © 2008  IPS, Inc.
Licensed to: Xisto Corporation