Raised This Month: $ Target: $400
 0% 

SQL Help\code


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
|PJ| Shorty
Veteran Member
Join Date: Aug 2005
Location: Bavaria, Germany
Old 04-03-2009 , 15:46   Re: SQL Help\code
Reply With Quote #9

here is an example code, not tested but should work and you can see how this can be done.

select_user_db(id) search a player in the db. if exists store status and time-stamp from db to global vars, if not add the player to the db ( see line 98 )

update_user_db(id,status,timestamp) to update status and timestamp from a player in the db

delete_user_db(id) to delete a player from the db


if you need help feel free to ask
Attached Files
File Type: sma Get Plugin or Get Source (sqlx_example.sma - 776 views - 4.0 KB)
__________________
There are only 10 types of people in the world:
Those who understand binary, and those who donīt.

Last edited by |PJ| Shorty; 04-05-2009 at 19:06. Reason: 2. plugin update
|PJ| Shorty is offline
Send a message via ICQ to |PJ| Shorty Send a message via AIM to |PJ| Shorty Send a message via MSN to |PJ| Shorty Send a message via Yahoo to |PJ| Shorty Send a message via Skype™ to |PJ| Shorty
 



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

Forum Jump


All times are GMT -4. The time now is 08:53.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode