dodgerblue
May 20 2005, 11:04 AM
| | Hi. TIA for any help you give. (Even if just reading this post  )
OK, I need some help with this point system thing. I want to have on my forum, a game called Munjpets (which I have already installed, with the help of hype), and I want to link it to the posts of users such that they get credited points for the posts they make. They then use the points to play in the game.
I'm hazarding a guess that I will need to make one or more tables in mysql coincide for both the game and the forum posting.
My question is, what do I need to alter in mysql to make this work out?
I've got a very vague idea in my mind, and no clue whatsoever to go about carrying this out.
Appreciate any information you can give.
Thanks |
Reply
beeseven
May 21 2005, 12:04 AM
What I would do is have another field in the mySQL, like `points` or something. Then use cron jobs. http://www.trap17.com/forums/wanna-learn-c...-huh-t6317.htmlhttp://www.trap17.com/forums/cron-jobs-cro...anel-t6321.htmlIn the automatically executed PHP file, just put something like this: CODE <?php
$connect = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("users");
mysql_query("UPDATE `users` SET `points`=`points`-1");
mysql_close();
?> For this to work `points` must be a number type (probably INT).
Reply
dodgerblue
May 23 2005, 06:10 PM
I don't understand. Could you explain a bit clearer? Sorry. I actually found the sql entry in the table where the points are located, I just have no idea how to make the one store in the other instead. :S
Reply
badinfluence
May 23 2005, 07:16 PM
interesting.. i also wanna know how does trap17 point system work  but i was on phpBB user right now.. and i can configure out what you wanna do in phpBB by just simply install CashMOD and post credit to game credit, game score to game credit. and learning "how does that mod work" right now.. from invisionize, i found this point mod i think cronjob concept will be how the trap17 determine to decrese the member posting points day(time) by day(time).. i m noob and learner in coding, correct me if i m wrong.. 
Reply
dodgerblue
May 23 2005, 09:30 PM
It's okay, I've got it figured out. I installed the IBStore v3.0 for Invision 2.0 and it's working great. Just ask BuffaloHELP. 
Reply
Similar Topics
Keywords : setup, point, system, forum, mysql, data
- How Do I Find My Mysql Password? [resolved]
Cannot access my MySQL (5)
Very Disappointed With Data Center Migration
What do you think? (9) I am hopping mad. I have had nothing but grief since Trap 17 moved their Data Center (DC).
My site has been down more time than it has been up. I have had to contact Live Support at Xisto 4
times now in the last month. This is ridiculous. They fix things, it lasts a few days and my site
is down again. I am at my wits end. I have been told my support to contact Shree. I have
already communicated with him and he told me that things were solved 6/16, then whatever happened,
my site was lost completely and had to be restored from their backup. My whole acc....
Remote Access Mysql
(8) Is it possible to directly access my local database from my website? For example, if somebody
submits info on my website, the info they submitted would be transferred to my local database
directly. Is that possible? And if so, how do I set that up? The reason I don't want to upload
my database to my subdomain is because it would be difficult to keep the website database and my
local database in sync . . . or is there a way to do that? Thanks for any replies.....
Work Out My Name - Win 10 Forum Credits
(11) WORK OUT MY NAME WIN 10 Credits How to do it Simply go to this site
http://www.n4w.co.uk and use the info there as well as what you already know about me to work it
out Rules You must give a suitable reason for your answer and it must not be a guess.
You must not ask what my name on the forums or shoutbox of the supplied website Whoever does this
wins 10 credits... easy. WELL DONE RVALKASS FOR WINNING Also Well Done KansukeKojima Just
missed your chance!!! edit:You Get the Credits Thx to a Generous Rvalka....
Phpbb Mods That You Should Get For Your Phpbb3 Forum
only for phpBB3.0.x though... (9) For those of you who are hosted on Trap17 and using phpBB3.0.x you might want to consider adding
some mods... Some mods which I extremely highly recommend to get is: #1 "Anti-Bot Question" mod,
which adds a question like "can you see through glass?" (not actual example, result may vary),
according to many people who have tried the mod, it is REALLY useful at keeping low-medium level
advanced bots at bay, although some extremely complex advanced bots may still get through... I
personally don't have this mod, but I would install it if I have the time to... #2 "Evi....
Setup Forum
????? (2) How do we set up a forum with SMF? When I press extract, it downloads the file. This is messed up.....
Question About The Upgrade And The Mysql Usage ?
question about the upgrade and the mysql usage? (3) thanks for the upgrade but i do have question about it QUOTE Domain name zam.trap17.com
Hosting package Beta Subdomains 3 / 99 Parked Domains 0 / 9 Addon Domains 3 / 9 Mysql databases
1 / 99 PostgreSQL Databases 0 / 99 Disk usage 14.25 / 500.00 MB MySQL Disk usage 0.82 MB
Disk space available 485.75 MB Bandwidth (this month) 6.59 / 10240 MB Email accounts: 1 / 99
Email forwarders: 1 / unlimited Autoresponders: 0 / unlimited Email filters 0 / unlimited
Mailing lists: 0 / 99 FTP accounts 3 / 99 1-Bandwidth (this month) 6.59 / 10240 MB ....
My Ftp Issue. Forum Nonviewable.
(7) My situation: I started the cpanel process and clicked on fantastico to begin downloading phpBB2
automatically on it. It had told me it couldn't continue the process because there were items
that needed to be deleted, so I deleted everything, the mail regenerated itself fortunately, when I
reinstalled the phpBB2 discussion board via fantastico I looked at the ftp folder and then tried to
access the site via IE web browser. I got a 404 page. "Not Found The requested URL / was not found
on this server. Additionally, a 404 Not Found error was encountered while trying....
Installing Theme On Smf Forum
Need help doing it! (4) I was wondering, and I am horrible with Cpanels mind you, how to install a new theme. I have an smf
discussion board and I decided to download a theme from the theme place for smf. So it downloads,
and appears in winrar. When I extract it, it comes with a big pile of files, with 2 folders:
Language, and Images. First question is: Do I install these somewhere in the 'File manager'
in cpanel? Ok if yes: Where? Third: Do the main files, language , and image go in different
places? Fourth: There is about 4584305834098 image files, is there a quicker way to get ....
Help! Forum Error Please Reply
(4) I'm very sorry for making so many topics, but just now I can't get to my forum because of
this! QUOTE Fatal error: Cannot redeclare addlinenumbers() (previously declared in
/home/omega/public_html/Sources/Subs.php:3671) in /home/omega/public_html/Sources/Subs.php on line
3721 Help me please! (PS: sorry for being so dumb)....
Help: Mod Install On Forum
(3) Ok I feel really really stupid (Which I am when it comes to this) but anyway on the SMF forum, there
is a package manager, you click install, and it installs the mods on the forum. However, sometimes
it gives you a link, to download the mod. So yeah I download it, and it appears on my desktop as a
bunch of icons that only make a million tabs appear when opened. I was wondering where in the world
am I supposed to put these mods so that they will work? I have tried some things but they did
nothing... Please help! Why Don't I ever get any replies! ....
Glitch On This Forum? [resolved]
Picture not showing up (4) Hello, I hope this is the right place to post this, I couldn't find any other place where this
would fit. Weeks ago, I uploaded a picture to go with my username. Yet I notice it does not show
up, only when I click my username on the left of the forum, it shows up. I did notice that with
other users, their picture shows up next to (or underneath) their name. I was wondering why this is
happening. Thanks. ....
Hosting Forum Using Trap17? Help
(5) hello there, how can i host a forum using trap17, im a hosted member i can go thorw my cpanel, but i
wana host a forum to get members and stuff. so can someone plz tell me on how to code a forum or
creat a forum using trap17 cpanel or any other way.....
My Site Is Showing Trap17 Activation Page Only [resolved]
my forum is not showing with www path (2) Hello I have requested for the free hosting with my own domain name and everything is in orderbut i
am having this proble and here goes each time i type www.mysite.com instead of me seeing the home
page of my site what i will be seeing is the default trap17 page where it will tell the visitor
welcome to trap17 web hosting this domain is hosted with trap17 i have deleted the page creat my own
index page but still i am seeing this page now agian each time i type www.mysite.com/yabb.pl that is
the direct link to my forum script it wont open instead it will tell me can not f....
Request For Coders (lots To Do)
Assisting on the Development of a Forum Script (1) I recently got involved in a Forum software script which is being developed and thought I should let
everyone know that they need some assistance in the PHP, MySql, Html, and CSS areas. Also, some
Visual Designers would be quite useful. AEF Forum Software is the name of the project. It is
presently in version 1.0.3, and have some pretty cool features already, but in order to advance in
its standings against such Boards as IPB, phpbb, Yabb, etc, more features and Themes are required.
Good bunch of people working hard, but just not enough of us to do everything. Come h....
Question About Adding Message Board To Site
Using mysql? (5) Hi, Super simple question from a simple laddie! Is a MySql database a messageboard? If not
how can I set up a messageboard. Thanks. std split from another topic ....
Domains: Where To Find And How To Setup?
(7) Ok guys so im thinking about purchasing a domain, Im know that Trap17 does support the use of our
own domains but I have never set one up before. I was wonder if anyone knew where to get the
cheapest and most reliable domains from? and if I were to purchase one could somebody possibly help
set it up or something because I had a look through the cpanel but I couldn't really figure out
what to do. Thanks.....
Installing Phpbb Forum On My Site?
(5) Hello! I was just wondering how I go about installing the phpbb forum on my site. I assume I
go somewhere from the CPanel? I think someone told me that the CPanel has something that installs
it for me automatically. Thank you!....
Getting My Forum Online
(11) oke wel, i got my zip file uploadet on the file manager ( ty jlhaslip),now i have to instal it,so i
basicly got onto th einstall page where u put in ur database name and stuff, so i did and it
didn' t work, so i thought oH YEAH dumb i have to make a mysql database first, so i did that so
i filled in the form, with the name of the database and the username i made, so i press instal, and
i get errors. so basicly since my knowledge of either php or mysql databases is 0,0,i can't
figure it out, so my question is could an admin or mod, install it for me, i looke don....
Free Forum Service
Is it allowed? (3) Everybody knows of sites that can give you free forums like ipbfree, mnvisionfree, forumer, and many
others. My question is this, I read some where a while back that you were not allowed to have those
types of services on your board, meaning it was forbidden to have other people get boards and host
them on your site. I wanted to uploadf a scirpt that allowes you to have a service similar toi
those listed abov. Now I know that is against the ruoes, but I wanted to have a service like that,
but not enable everyone to be able to make oone. See I watned to make some cont....
Phpbb2.17 Mysql Problems
Just this week they started (4) The forum has been up and running for about a year and a half. It has been through numerous server
upgrades, etc, including the recent HDD change, but for some reason, just this week it started
throwing this error: QUOTE Could not obtain post/user information. DEBUG MODE
SQL Error : 145 Table './jlhaslip_phpbb2/phpbb_posts_text' is marked as crashed and should
be repaired SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email,
u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail,....
Smf Forum Board
Connection Problems (2) Hey, i just uploaded and installed Smf on my website. Everything is working fine with the forums
themselves, but every now and then i get 1 or 2 messages. Here they are. " Database Error: Lost
connection to MySQL server during query File: /home/justin/public_html/forums/Sources/Load.php Line:
1165 " " Connection Problems Sorry, SMF was unable to connect to the database. This may be caused by
the server being busy. Please try again later. " But i have all of my database information correct.
What does this mean and can anybody help me? Thanks ~Justin~....
99 Mysql Databases?
(2) I just got my account, and I was wondering: do we really get 99 MySql databases? I've read a
lot of the stuff about it, and it sounded like we only get one database, but my cPanel says that I
have "0 / 99" databases. If it's lying, it's not really a problem, because I could always
just prefix my tables, but I was just wondering why it would say that. If for some reason it was
letting me get more than one database, and I wasn't supposed to, I don't want to get my
account deleted. Does anyone know why it says that? /huh.gif" style="vertical-align:m....
Mysql Access Error[resolved]
(5) The MySQL server is Down, please look into this soon. I'm with Trap17 for nearly an year but
never faced any issues witht the free hosting so far, but his is the first time I'm facing this.
Please kindly look into this.....
Mysql Server Problems [resolved]
(3) hello, well since i installed php-nuke on my site's dir i have seen quite a lot of mysql SERVER
ERRORS, like that the server is going down so now and often is it due to my cms or is the server
having some probs ? this is what i just saw from the statistics: QUOTE Service Status
named up spamd up imap up cpsrvd up pop up eximstats failed syslogd up clamd failed mysql
(5.0.27-standard) failed httpd (1.3.37 (Unix)) up exim () failed exim-26 up ftpd failed Server
Load 16.50 (1 cpu) quote tags added. please use quote tags as needed. review trap17....
Suggestion For Free Forum To My Web Page
I have only tried Invisionfree.com (1) Well, my title and description says about it. I would like to find a nice forum for my web page.
Just test period. I have only tried invisionfree's forum and I did not see any problems with it.
It was really nice actually, but I don't know if there are any other free forums that are better
so suggestions, please!....
Cpanel And Mysql Problem. [resolved]
(3) hi all - i'm going to make this brief. my CMS (drupal 5.0) and forum (SMF 1.1.1) cannot connect
to the mysql db. however their files CAN still be accessed. I also tried uploading a file through an
ftp client and the file could be accessed. HOWEVER: cpanel cannot be accessed either. it simply
loads with a blank page. however both worked earlier today. so is there a problem with the server?
and if there is, will it be fixed?....
Is It Possible To Access The Mysql Remotely?
(10) I like to experiment with a lot of things and I was thinking of making a sort of instant messenger
in Python, but I want to let people have actual accounts so I need to be able to access the mySQL
remotely. If that's not possible, are we allowed to run Python scripts on the server?....
How To Crate Mysql Database?
urgent help (7) Hi everyone!
I'm trying to make in my site a page system that allows me to create users
account (with a foto for every user)...
I'm doing that in PHP, I learned all I have to
know about PHP and MY SQL. I know how to make new array and querries in the data base, only 1 think
is messing: ....
Installing Apache, Mysql, Phpmyadmin Locally
Solving the "php_mbstring.dll missing" (5) Since Trap17's CP provide the individual site's owner with goodies like MySql and
PhpMyAdmin, chances are some will want to make use of them. Well, it's fine enough to get that
on one's host (Gee! Thanks a lot, Trap17...) Knowing how the usual geek react, it might be
expected that most people considering to make use of a database on their site will want to do most
of the tedious job of developing and testing on their own local system before sending the wrapped-up
result on their domain/subdomain. This involves four basic steps (sorry for the compuwi....
Looking for setup, point, system, forum, mysql, data
|
|
Searching Video's for setup, point, system, forum, mysql, data
|
advertisement
|
|
Jul 25, 2008
