[advanced search]
 

Go Back   NamePros.com > Discussion > Web Design & Development > Programming

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.


Closed Thread
 
LinkBack Thread Tools
Old 10-20-2006, 08:12 AM   #1 (permalink)
Senior Member
 
SeanPreston's Avatar
 
Join Date: Nov 2005
Location: Staffordshire, UK
Posts: 1,054
50.00 NP$ (Donate)

SeanPreston is a splendid one to beholdSeanPreston is a splendid one to beholdSeanPreston is a splendid one to beholdSeanPreston is a splendid one to beholdSeanPreston is a splendid one to beholdSeanPreston is a splendid one to beholdSeanPreston is a splendid one to beholdSeanPreston is a splendid one to behold


help please!!!

Hi, im the owner of globalconflict.info. Its basically an online rpg game. Each member gets 500 attack points(1-10 are used for every time they attack another player). They are asposed to update every 24 hours but they dont. I am willing to go online every day and update the "attack points" table in phpmyadmin. Instead of going through every member and editing that feild, is there a way that i can reset them all to 500 realy quickly?
thanks
sean
__________________
Google - an idiots best friend, Search before you ask!

AjaxDen - Free Ajax Scripts!
SeanPreston is offline  
Old 10-21-2006, 11:03 AM   #2 (permalink)
New Member
 
Join Date: Apr 2006
Posts: 2
5.00 NP$ (Donate)

JulyWeb is an unknown quantity at this point


Hey there,

You will just have to run a SQL query, but can't say more unless you give more details on the database structure ...
JulyWeb is offline  
Old 10-21-2006, 12:34 PM   #3 (permalink)
Barru.
 
Barrucadu's Avatar
 
Join Date: Aug 2005
Location: East Yorkshire, England
Posts: 2,731
78.50 NP$ (Donate)

Barrucadu is a splendid one to beholdBarrucadu is a splendid one to beholdBarrucadu is a splendid one to beholdBarrucadu is a splendid one to beholdBarrucadu is a splendid one to beholdBarrucadu is a splendid one to beholdBarrucadu is a splendid one to behold


Just use this sql:

Code:
update [name of your users table] set [name of attacks field] = 500
You could put it into a script and set up a cron to run it every 24 hours.
Barrucadu is offline  
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Site Sponsors
Advertise your business at NamePros

All times are GMT -7. The time now is 04:07 AM.


Powered by: vBulletin® Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Template-Modifications by TMS
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85