spellbyte ®

Re: Max Stats the only files u need to change are the ones that change anything related to money editing, such as bank.php you would need to find (int) and change it to float, but to be able to have the max ability u need to edit the database tables, so in the users table you would change money, bankmoney, cybermoney and crystals to bigint (20) to allow all of the above to go higher than 2 billion

Re: How do You Code Php Tables at the risk of sounding dumb amongst all these superior programmers on here but what is the difference between a PHP table and an HTML table, my inferior intellect was always under the impression that a table was a table :?

Re: Max Stats it's not in any file, you need to go into your database, usually using phpmyadmin and change all the fields in the userstats table to bigint(20)

Re: Keywords your keywords would be in your header.php

Re: General PHP table Question for the younger game owners who have bitten off more than they can chew, check out http://www.w3schools.com/html/default.asp it is a valuable place to learn everything about the basic HTML side of your games, it also has some minor tips on PHP too

Re: INT and BIG INT I have seen bigint go upto 99, i'm not sure if it can go any higher though

Re: A question to sort out all the arguments over coding copyright..... I would be interested in the phone call, I'll contact you on MSN about it later

Re: A question to sort out all the arguments over coding copyright..... would this extend as far as taking a script that isn't functioning, i make it function could i then claim it as my script, with partial credit to the original owner?

Re: Cheap Hosting for a hosting company to offer that much un limited either leads me to believe that the connection speed would be so slow that it would take a week to load even a 1KB webpage let alone run a game, also for the price to be forever is just ridiculous, even if this was true how could the company make any money, it is obviously a reseller hosting plan that someone is doing and in my opinion using a server from a reseller is just pointless as the reseller tries to cram far too much onto the system and then overloads it,, isn't that right silverwolf :P my advice to anyone looking for a good host for their game or any web project that are on a restriced budget would be to start off with a well respected company such as www.lunarpages.com or www.bluehost.com, granted the annual plans can be a bit high for low budgets but you can pay bi-monthly. going for the "cheaper option" will only result in your users getting fed up of the load times and then going onto the next game/site

Re: TC Rips I have to agree that it is definately not a get rich quick scheme, same with anything, if you want to make a success of anything you have to work hard at it, i have often thought to myself why bother with it lol, but sense prevailed and i am still battling on, the more games that out there the better i think, a nice bit of healty competition never hurts anyone, hell it's all been said in this post, my point is that i totally agree that the more games the better

Re: Duties you change them in the edit user part of the admin panel

Re: item images right i am trying to add an extra field to add new item and edit item for the item pics, but when i add the link i get this error   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '://www.etw.de/windtunnel/ts/model.jpg)' at line 1   it works ok without the link in there, this is what i have added so far   print "<h3>Adding an item to the game</h3><form action='owner.php?action=newitemsub' method='post'> Item Name: <input type='text' name='itmname' value='' /> Item Desc.: <input type='text' name='itmdesc' value='' /> Item Type: ".itemtype_dropdown($c,'itmtype')." Item Buyable: <input type='checkbox' name='itmbuyable' checked='checked' /> Item Price: <input type='text' name='itmbuyprice' value='0' /> Item Sell Value: <input type='text' name='itmsellprice' value='0' /> Item Image URL: <input type='text' name='itmpic' value='' /> [b]Specialized[/b] Item Energy Regen (food only): <input type='text' name='energy' value='1' /> Item Health Regen (medical only): <input type='text' name='health' value='10' /> Power (weapons only): <input type='text' name='damage' value='10' /> Damage Off (armor only): <input type='text' name='Defence' value='10' /> Brave Booster (brave only): <input type='text' name='brave' value='10' /> Hospital time (hosptime only): <input type='text' name='hosptime' value='10' /> Lock Picks (jailtime only): <input type='text' name='jailtime' value='10' /> <input type='submit' value='Add Item To Game' /></form>"; } function new_item_submit() { global $ir,$c,$h; if(!isset($_POST['itmname']) || !isset($_POST['itmdesc']) || !isset($_POST['itmtype']) || !isset($_POST['itmbuyprice']) || !isset($_POST['itmsellprice'])) { print "You missed one or more of the fields. Please go back and try again. [url='owner.php?action=newitem']> Back[/url]"; $h->endpage(); exit; } $itmname=mysql_escape($_POST['itmname']); $itmdesc=mysql_escape($_POST['itmdesc']); if($_POST['itmbuyable'] == 'on') { $itmbuy=1; } else { $itmbuy=0; } $m=mysql_query("INSERT INTO items VALUES('',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy,{$_POST['itmpic']})",$c) or die(mysql_error()); if($_POST['itmtype'] == 1)   any thoughts please anyone?

Re: item images ahh yeah good point seanybob, thanks fopr pointing that one out

I have had several people asking me how to do this so i will post it here for all to see run this sql query ALTER TABLE `items` ADD `itmPIC` VARCHAR( 255 ) NOT NULL ; then simply add this to whatever page u want to display the picture it's really very simple or use this unedited inventory.php <?php session_start(); require "global_func.php"; if($_SESSION['loggedin']==0) { header("Location: login.php");exit; } $userid=$_SESSION['userid']; require "header.php"; $h = new headers; $h->startheaders(); include "mysql.php"; global $c; $is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error()); $ir=mysql_fetch_array($is); check_level(); $fm=money_formatter($ir['money']); $cm=money_formatter($ir['crystals']); $lv=date('F j, Y, g:i a',$ir['laston']); $h->userdata($ir,$lv,$fm); $h->menuarea(); $inv=mysql_query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_userid={$userid} ORDER BY i.itmtype ASC, i.itmname ASC",$c); if (mysql_num_rows($inv) == 0) { print "[b]You have no items![/b]"; } else { print "[b]Your items are listed below.[/b] </pre> <table width="100%">ImageItemSell ValueTotal Sell ValueLinks{$lt}[img={$r[]{$i['itmname']}"; if ($i['inv_qty'] > 1) { print " x{$i['inv_qty']}"; } print "\${$i['itmsellprice']}"; print "$".($i['itmsellprice']*$i['inv_qty']); print "[[url='iteminfo.php?ID={$i[']Info[/url]] [[url='itemsend.php?ID={$i[']Send[/url]] [[url='itemsell.php?ID={$i[']Sell[/url]]"; if($i['itmtypename'] == 'Food') { print " [[url='itemuse.php?ID={$i[']Use[/url]]"; } print "</table>";<br>}<br>$h->endpage();<br replace that if you have not modified your inventory.php before

I have recently had a major revamp on alphacrime and since then it seems that the exp isn't displaying correctly, i cant see why though, my exp is raising because i can see it gaining in the db, if anyone has any thoughts as to what can be causing this then please let me know i spose i better pastes what code i have at the moment   $enperc=(int) ($ir['energy']/$ir['maxenergy']*100); $wiperc=(int) ($ir['will']/$ir['maxwill']*100); $experc=(int) ( $ir['exp']/$ir['exp_needed']*100); $brperc=(int) ($ir['brave']/$ir['maxbrave']*100); $hpperc=(int) ($ir['hp']/$ir['maxhp']*100); $enopp=100-$enperc; $wiopp=100-$wiperc; $exopp=100-$experc; $bropp=100-$brperc; $hpopp=100-$hpperc; [size="1"][b]Life Force:[/b] {$enperc}% [url='crystaltemple.php?spend=refill'][Refill][/url][/size] [size="1"][b]Discipline:[/b] {$wiperc}%[/size] [size="1"][b]Focus:[/b] {$ir['brave']}/{$ir['maxbrave']}[/size] [size="1"][b]EXP:[/b] {$experc}%[/size] [size="1"][b]Health:[/b] {$hpperc}%[/size]   i have removed some of the code inbetween just incase it looks incomplete but thats the code for exp as far as i can see

Re: Free Advertising hi there jake, I'm all for cross advertising, if you contact me on [email protected], i'm sure we can come to some agreement, if you want to check my game out first you can do so at www.alphacrime.com

I have come up against a glitch, im not sure what file it is in, my users are using the gym but they are not automatically levelling up when they reach 100%, does anyone know what the problem could be

ok i thought i had this cracked but apparently not, My crimes dont seem to be giving any exp, here is what i have at the moment in docrime.php   $ec="\$sucrate=".str_replace(array("LEVEL","EXP","WILL","IQ"), array($ir['level'], $ir['exp'], $ir['will'], $ir['IQ']),$r['crimePERCFORM']).";"; eval($ec); print $r['crimeITEXT']; $ir['brave']-=$r['crimeBRAVE']; mysql_query("UPDATE users SET brave={$ir['brave']} WHERE userid=$userid",$c); if(rand(1,100) <= $sucrate) { print str_replace("{money}",$r['crimeSUCCESSMUNY'],$r['crimeSTEXT']); $ir['money']+=$r['crimeSUCCESSMUNY']; $ir['exp']+=(int) ($r['crimeSUCCESSMUNY']/8); if($r['crimeITEM'] > 0)   if it's not in there then it must be in the db entries for crimes

Re: Multi Account Issues fixed this, he was calling the mysql after the query for lastip

I have recently come across a problem with the jobpay cron file, it seems to be paying out money and stats to users who dont even have a job this is what i have at the moment <?php require "mysql.php"; global $c; mysql_query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET u.money=u.money+jr.jrPAY,us.strength=us.strength+jr.jrSTRG,us.labour=us.labour+jr.jrLABOURG,us.IQ=us.IQ+jr.jrIQG,u.exp=u.exp+(jr.jrPAY/20) WHERE u.job > 0 AND u.jobrank > 0",$c) or die("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON u.jobrank=jr.jrID SET u.money=u.money+jr.jrPAY,us.strength=us.strength+jr.jrSTRG,us.labour=us.labour+jr.jrLABOURG,us.IQ=us.IQ+jr.jrIQG WHERE u.job > 0 AND u.jobrank > 0 ".mysql_error()); ?>   I can only assume that it is this that is causing the problem of stats raising randomly and also they seem to be decreasing randomly too, if anyone has any thoughts i would be greatly appreciative

Free Loan Shark System well mine works fine, but then again i have modded mine a bit, got it tucked up nice and neat into the bank.php :P

bug report mod I have a problem when clearing reports from the admin page, instead of clearing off just the one that i click on, it removes every single report on there, any ideas on this?

validation mod  

validation mod thankyou so much for posting one of these, got a few questions though 1: how often does the cron need to be updated, i ask cos i haven't got a cron file called that, 2when i succesfuly enter the correct number, it says   You successfully validated, now bringing you back to what you were doing.   and then it just stays on that page, how can this be fixed?

User Notepad fraid not, it still allows me to edit another users notes I believe it needs some else statements, but i wouldn't know where to begin