kcmajor36

I have no interest in messing with anyones stuff though, why is it just because I work on a game makes it a conflict of interest. I have no use for anyone elses stuff, The datacenter I go through requires me to offer guarantees, and they offer a in-house warranty. I am offering a chance for people to start up, and if not only to start up but to use this as next to free space cause I am sure no body wants to pay outrageous prices for the service provided the same just as the next guy. Because I dont. Now we can go one all day about how terrible I am because I am just trying to be generous and not charge stupid amounts of money, but I am not trying to limit people to next to nothing with "FREE", because truth be told nothing in this world is "FREE". Once again I don't want to siphon data from my users.

See I dont look at it as a competitive thing, I run a game because yeah my coding skills are rusty and its good sport, but all I do is modifications to the game and keep it running smooth, my partner is the one who owns the game. But in all fairness you are right I mean it would be a trust thing, but I mean it's there and if people want a server that works then there it is. I mean can you really trust ANYONE'S server?

Awesome it works now so what will I have to do to get the mail to send?

Hey guys just so everyone has an opportunity to start up like I did back in the day, I purchased a server, and I am offering a $5 one-time start up for anyone its $5 per domain and I will give you unmetered disk and bandwidth but of course there are a few basic ToS to follow but as long as you follow that I don't mind hosting anyone that wants it. I also provide reseller hosting for low-cost monthly fees ranging from $8 to 20/mo but it your interested I will be more than happy to provide you. It's only $5 !! Please message me for more details, I am currently reconstructing my site but the customer portal is open. Thanks!

Well see thats were im lost because this is the stock v2 mccode and its giving me problems that I have never encountered before. Now with the updated code its saying :QUERY ERROR: Unknown column 'effect1on' in 'field list'

I wanna say for this one this is the code that is generating it: Sending mail - function mail_send() { global $db,$ir,$c,$userid,$h; $subj=str_replace(array("\n"),array("<br />"),strip_tags($_POST['subject'])); $msg=str_replace(array("\n"),array("<br />"),strip_tags($_POST['message'])); if($_POST['user1'] && $_POST['user2']) { die("Please do not select a contact AND enter a username, only do one.<br /> <a href='mailbox.php'>> Back</a>"); } if(!$_POST['user1'] && !$_POST['user2']) { die("You must select a contact or enter a username.<br /> <a href='mailbox.php'>> Back</a>"); } $sendto=($_POST['user1']) ? $_POST['user1'] : $_POST['user2']; $q=$db->query("SELECT userid FROM users WHERE username='{$sendto}'"); if($db->num_rows($q)==0) { die("You cannot send mail to nonexistant users.<br /> <a href='mailbox.php'>> Back</a>"); } $to=$db->fetch_single($q); $db->query("INSERT INTO mail VALUES ('',0,$userid,$to,unix_timestamp(),'$subj','$msg')"); $db->query("UPDATE users SET new_mail=new_mail+1 WHERE userid={$to}"); print "Message sent.<br /> <a href='mailbox.php'>> Back</a>"; }   and creating items : function new_item_submit() { global $db,$ir,$c,$h; if($ir['user_level'] > 2) { die("403"); } 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.<br /> <a href='staff_items.php?action=newitem'>> Back</a>"; $h->endpage(); exit; } $itmname=$db->escape($_POST['itmname']); $itmdesc=$db->escape($_POST['itmdesc']); $weapon=abs((int) $_POST['weapon']); $armor=abs((int) $_POST['armor']); if($_POST['itmbuyable'] == 'on') { $itmbuy=1; } else { $itmbuy=0; } $efx1=$db->escape(serialize(array("stat" => $_POST['effect1stat'], "dir" => $_POST['effect1dir'], "inc_type" => $_POST['effect1type'], "inc_amount" => abs((int) $_POST['effect1amount'])))); $efx2=$db->escape(serialize(array("stat" => $_POST['effect2stat'], "dir" => $_POST['effect2dir'], "inc_type" => $_POST['effect2type'], "inc_amount" => abs((int) $_POST['effect2amount'])))); $efx3=$db->escape(serialize(array("stat" => $_POST['effect3stat'], "dir" => $_POST['effect3dir'], "inc_type" => $_POST['effect3type'], "inc_amount" => abs((int) $_POST['effect3amount'])))); $m=$db->query("INSERT INTO items VALUES('',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor)"); print "The {$_POST['itmname']} Item was added to the game."; stafflog_add("Created item {$_POST['itmname']}"); }

Alright I hate to do this but I have tried everything I can remember but thats apparently not good enough. I am having issues with v2 clean install of he script never had problems in the past, but I cant create items, or send messages with it popping up an SQL error saying something like this... "QUERY ERROR: Incorrect integer value: '' for column 'mail_id' at row 1" what is going on?!

I am in the same boat as you Cronus, been out working on the real world and blow off the dust on the keyboard, I am starting up a mccodes game Come by check it out sometime, gonna have a lot of work to do on it to get in out of the "stone-age". => http://corruptempires.com

I haven't been on here in a while, and the site has changed a lot but I was looking back and was wondering where the SQL lines are. anyone have an idea?

And I go to the error log and is doesn't say theres any error in chat script

Display errors is on but it wont show any errors it only shows a white page.. its VERY annoying.

Try again :P

Timestamp: 8/13/2013 11:09:19 PM Error: SyntaxError: syntax error Source File: http://offenderwars.tk/index.php Line: 1, Column: 22 Source Code: style.backgroundColor=

Im using a firefox browser. And my scripts are Mccodes v2

What do you mean?

Im having a problem... it wont move from the "loading chats" screen... wont let me post any messages or anything.

Slight Edit to clean it up but nice mod! +1 :) <html> <style> .table { background-color:#c3c3c3; } .table3 { background-color:#000000; } .table td { background-color:#DEDEDE; height:22px; } .table3 td { background-color:#CCCCCC; } td .alt { background-color:#EEEEEE; height:22px; } td .h { background-color: #2C2C2C; border: 1px solid #000000; width: 160px; padding: 2px 5px 3px 5px; font-size: 12px; color: #000000; border-radius: 2px; outline: none; } .table th { background-color: #2C2C2C; border: 1px solid #000000; width: 160px; padding: 2px 5px 3px 5px; font-size: 12px; color: #000000; border-radius: 2px; border-top-left-radius: 5px; border-top-right-radius: 5px; outline: none; } </style> </html> <?php $housequery=1; include_once "globals.php"; $awp=round($ir['attacks_won']/($ir['attacks_total'] > 0 ? $ir['attacks_total'] : 1)*100,2); $alp=round($ir['attacks_lost']/($ir['attacks_total'] > 0 ? $ir['attacks_total'] : 1)*100,2); $atp=round($ir['attacks_total']/($ir['total_total'] > 0 ? $ir['total_total'] : 1)*100,2); $dwp=round($ir['defends_won']/($ir['defends_total'] > 0 ? $ir['defends_total'] : 1)*100,2); $dlp=round($ir['defends_lost']/($ir['defends_total'] > 0 ? $ir['defends_total'] : 1)*100,2); $dtp=round($ir['defends_total']/($ir['total_total'] > 0 ? $ir['total_total'] : 1)*100,2); $twp=round($ir['total_won']/($ir['total_total'] > 0 ? $ir['total_total'] : 1)*100,2); $tlp=round($ir['total_lost']/($ir['total_total'] > 0 ? $ir['total_total'] : 1)*100,2); $bbb=$ir['attacks_won']+$ir['defends_won']; $TotalEXP = abs(@intval($ir['exp']/$ir['exp_needed']*100)); $BankMoney = ($ir['bankmoney'] == '-1') ? 'No Account!' : number_format($ir['bankmoney']); if ( !$ir['married'] ) { $marital="<font color='red'>No</font>"; } else { $k=$db->query("SELECT username FROM users WHERE userid={$ir['married']}", $c); $marital="<a href='viewuser.php?u={$ir['married']}' style='color:green;'>".mysql_result($k,0,0)."</a> "; $marital.="[<a href='marriage.php'>Manage</a>]"; $mair=$db->query("SELECT u.*, h.* FROM users u LEFT JOIN houses h ON h.hWILL=u.maxwill WHERE userid={$ir['married']}",$c); $ms=mysql_fetch_array($mair); } echo '<table width="55%" border="0" cellspacing="1" cellpadding="3" style="text-align:center;" class="table"> <tr> <th colspan="2">Updates</th> </tr> </table> '; echo '<table width="55%" border="0" cellspacing="1" cellpadding="3" style="text-align:center;" class="table"> <tr> <th colspan="3">General Info</th> </tr> <tr> <td width="50%"><b>Name:</b> '.stripslashes($ir['username']).'</td> <td width="50%"><b>Level:</b> '.number_format($ir['level']).'</td> </tr> <tr style="text-align:center;"> <td><b>EXP:</b> '.number_format($TotalEXP).'%</td> <td><b>Life:</b> '.number_format($ir['hp']).'/'.number_format($ir['maxhp']).'</td> </tr> <tr> <td><b>Money:</b> '.number_format($ir['money']).'</td> <td><b>Crystals:</b> '.number_format($ir['crystals']).'</td> </tr> <tr> <td><b>Crimes Passed:</b> '.number_format($ir['crimes']).'</td> <td><b>Total Busts:</b> '.number_format($ir['busts']).'</td> </tr> <tr> <td><b>Days Old:</b> '.number_format($ir['daysold']).'</td> <td><b>Married:</b> '.stripslashes($marital).'</td> </tr> <tr> <td><b>Bank Account:</b> '.$BankMoney.'</td> <td><b>Property:</b> '.stripslashes($ir['hNAME']).'</td> </tr> </table> '; $ts = $ir['strength'] + $ir['agility'] + $ir['guard'] + $ir['labour'] + $ir['IQ']; $ir['strank'] = get_rank($ir['strength'], 'strength'); $ir['agirank'] = get_rank($ir['agility'], 'agility'); $ir['guarank'] = get_rank($ir['guard'], 'guard'); $ir['labrank'] = get_rank($ir['labour'], 'labour'); $ir['IQrank'] = get_rank($ir['IQ'], 'IQ'); $tsrank = get_rank($ts, 'strength+agility+guard+labour+IQ'); $ir['strength'] = number_format($ir['strength']); $ir['agility'] = number_format($ir['agility']); $ir['guard'] = number_format($ir['guard']); $ir['labour'] = number_format($ir['labour']); $ir['IQ'] = number_format($ir['IQ']); $ts = number_format($ts); echo" <table width='55%' border='0' cellspacing='1' cellpadding='3' class='table' style='text-align:center;'> <tr> <th colspan='3'>Stats Info</th> </tr> <tr> <th width='33%'>Stat</th> <th width='33%'>Amount</th> <th width='34%'>Rank</th> </tr> <tr> <td>Strength</td> <td>{$ir['strength']} </td> <td>Rank: [Ranked: {$ir['strank']}</td> </tr> <tr> <td>Agility</td> <td>{$ir['agility']}</td> <td>Rank: [Ranked: {$ir['agirank']}]</td> </tr> <tr> <td>Guard</td> <td>{$ir['guard']}</td> <td>Rank: [Ranked: {$ir['guarank']}]</td> </tr> <tr> <td>Labour</td> <td>{$ir['labour']}</td> <td>Rank: [Ranked: {$ir['labrank']}]</td> </tr> <tr> <td>IQ</td> <td>{$ir['IQ']}</td> <td>Rank: [Ranked: {$ir['IQrank']}]</td> <tr> <td>Total Stats:</td> <td>{$ts}</td> <td>Rank: [Ranked: $tsrank]</td> </tr> </table><hr width=85%> "; echo " <table width='55%' border='0' cellspacing='1' cellpadding='3' class='table' style='text-align:center;'> <tr> <th colspan='3'>Finacial Info</th> </tr> <tr> <td>City Bank</td> <td>\${$ir['bankmoney']} </td> </tr> <tr> <td>Crystal Bank</td> <td>{$ir['crystalbank']} </td> </tr> <tr> <td>Cyber Bank</td> <td>{$ir['crybermoney']}</td> </tr> </table><hr width=85%> "; echo" <table cellspacing='1' border='0' cellpadding='0' class='table' width='85%'> <th colspan='5'><b><center>Attack Info</b></td></tr> <tr> <th>Attacking:</th> <td>Won: <b><font color='green'>{$ir['attacks_won']}</b></font> ($awp%)</td> <td>Lost: <b><font color='red'>{$ir['attacks_lost']}</font></b> ($alp%)</td> <td>Total: <b><font color='green'>{$ir['attacks_total']}</font></b> ($atp%)</td> </tr> <tr> <th>Defending:</th> <td>Won: <b><font color='green'>{$ir['defends_won']}</font></b> ($dwp%)</td> <td>Lost: <b><font color='red'>{$ir['defends_lost']}</b></font> ($dlp%)</td> <td>Total: <b><font color='green'>{$ir['defends_total']}</font></b> ($dtp%)</td> </tr> <tr> <th>Both:</th> <td>Won: <b><font color='green'>$bbb</font></b>($twp%)</td> <td>Lost: <b><font color='red'>{$ir['total_lost']}</font></b> ($tlp%)</td> <td>Grand Total: <b><font color='green'>{$ir['total_total']}</font></b> / Draw's: <b><font color='green'>{$ir['draws']}</font></b></td> </tr> </table> "; $_POST['pn_update'] = (isset($_POST['pn_update'])) ? strip_tags(stripslashes($_POST['pn_update'])) : ''; if (!empty($_POST['pn_update'])) { if (strlen($_POST['pn_update']) > 5000) { echo '<hr /><span style="font-weight:bold;">You may only enter 5000 or less characters here.</span>'; } else { $pn_update_db = $db->escape($_POST['pn_update']); $db->query( "UPDATE `users` SET `user_notepad` = '{$pn_update_db}' WHERE `userid` = {$userid}"); $ir['user_notepad'] = $_POST['pn_update']; echo '<span style="font-weight:bold;">Personal Notepad Updated!</span>'; } } echo "<hr width=85% />Your Personal Notepad:<hr width=85% /> <form action='index.php' method='post'> <textarea rows='10' cols='50' name='pn_update'>" . htmlentities($ir['user_notepad'], ENT_QUOTES, 'ISO-8859-1') . "</textarea><br /> <input type='submit' value='Update Notes!' /></form>"; $h->endpage(); ?>

Honestly I havent been on here in a while and i dont know how to add the tags on this new version of the forums.

Not a bad mod at all mate! Just need to use the break tags they help so things dont get clustered!:) heres a cleaner version!   <?php require "globals.php"; global $db,$ir,$c,$r,$userid,$h; if ($_GET['time']) { $time=$_GET['time']; } else { $time=15; } $cn=0; $lk=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-1440*60"); $aa=mysql_num_rows($lk); $ll=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-60*60"); $ab=mysql_num_rows($ll); $lm=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-45*60"); $ac=mysql_num_rows($lm); $ln=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-30*60"); $ad=mysql_num_rows($ln); $lo=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-15*60"); $ae=mysql_num_rows($lo); $he=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-1*60"); $hu=mysql_num_rows($he); $q=mysql_query("SELECT * FROM users WHERE laston>unix_timestamp()-{$time}*60 ORDER BY laston DESC"); ?> <table border="0" class=table width="100%" cellpading="0" cellspacing="0"> <tr> <td class=table> <h3>Statistics</h3> Users online in the last minute: <?php print"{$hu}"; ?><br /> Users online in the last 15 Minutes: <?php print"{$ae}"; ?><br /> Users online in the last 30 Minutes: <?php print"{$ad}"; ?><br /> Users online in the last 45 Minutes: <?php print"{$ac}"; ?><br /> Users online in the last 60 Minutes: <?php print"{$ab}"; ?><br /> Users online in the last 24 Hours: <?php print"{$aa}"; ?><br /> </td> <td class=table> <h3>Time Selecter</h3> <a href='usersonline.php?time=1'>(1 Min)</a><br /> <a href='usersonline.php?time=15'>(15 Mins)</a><br /> <a href='usersonline.php?time=30'>(30 Mins)</a><br /> <a href='usersonline.php?time=45'>(45 Mins)</a><br /> <a href='usersonline.php?time=60'">(60 Mins)</a><br /> <a href='usersonline.php?time=1440'>(24 Hours)</a><br /> </td> <td class=table> <h3>Legend</h3> Admins = <font color = Red>Red</font><br /> Secretaries = <font color = purple>Purple</font><br /> Moderators = <font color = blue>Blue</font><br /> Assistants = <font color = yellow>Yellow</font><br /> Members = <font color = Orange>Orange</font><br /> Donators = <img src='donator.gif' alt='Donator' /> & <font color = cyan>Cyan</font><br /> </td> <tr> </table> <table border="0" class=table width="100%" cellpading="0" cellspacing="0"> <tr> <td class=table> <h3></h3> </td> <td class=table> <u><b>Level</b></u> </td> <td class=table> <u> <b>User</b></u> </td> <td class=table> </td> <td class=table> <u> <b>Last Action</b></u> </td><br /> <td class=table> <u> <b> Time Online</b></u> <td class=table> </td> <td class=table> <u><b>User Actions</b></u> </td> </tr><hr /> <?php while($r=mysql_fetch_assoc($q)) { $la=time()-$r['laston']; $unit="secs"; if($la >= 60) { $la=(int) ($la/60); $unit="mins"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } $cn++; $name=$r['username']; $id=$r['userid']; $gangtag=$r['yourgangPREF']; if($r['donatordays'] > 0) { $donator="<img src='donator.gif' alt='Donator: {$r['donatordays']} Days Left' title='Donator: {$r['donatordays']} Days Left' />"; } if($r['donatordays'] == 0) { $donator=""; } if($r['user_level']== 2) { $staff="Administrator"; } if($r['user_level']== 3) { $staff="Secretary"; } if($r['user_level']== 4) { $staff="Assistant"; } if($r['user_level']== 5) { $staff="Moderator"; } if($r['user_level']== 1) { $staff="Member"; } if($r['donatordays'] > 0) { $donator="<img src='donator.gif' alt='Donator: {$r['donatordays']} Days Left' title='Donator: {$r['donatordays']} Days Left' />"; } if($r['donatordays'] == 0) { $donator=""; } if($r['user_level']== 2) { $name="<font color=gold>$name</font>"; } if($r['user_level']== 3) { $name="<font color=blue>$name</font>"; } if($r['user_level']== 4) { $name="<font color=purple>$name</font>"; } if($r['user_level']== 5) { $name="<font color=cyan>$name</font>"; } if($r['user_level']== 1) { $name="<font color=silver>$name</font>"; } $r['username']="<a href='viewuser.php?u={$r['userid']}'>$name $donator [$id]</a> | <b>$staff</b>"; print "<tr> <td class=table> $cn. </td> <td class=table> Level: {$r['level']} </td> <td class=table> {$r['username']} </td> <td class=table bgcolor='#000000'> <a href=rating.php?change=up&ID={$r['userid']}><img src=positive.gif height='12' width='12'></a> <b>{$r['rating']}</b> <a href=rating.php?change=down&ID={$r['userid']}><img src=negative.gif height='12' width='12'></a> </td> <td>"; print "</td> <td class=table> ($la $unit) </td> <td class=table>"; $lb=time()-$r['last_login']; $units="secs"; if($lb >= 60) { $lb=(int) ($lb/60); $units="mins"; } if($lb >= 60) { $lb=(int) ($lb/60); $units="hours"; if($lb >= 24) { $lb=(int) ($lb/24); $units="days"; } } if($r['laston'] <= time()-60*60) { $lb="Offline"; $unit=""; } print "{$lb} {$units}</td> <td>"; if($r['hospital'] > 0) { print"<td> [<a href='mailbox.php?action=compose&ID={$r['userid']}'><font color='{$r['colour']}'>Mail</font></a>] (In Hospital) </td>"; } if($r['jail'] > 0) { print"<td> [<a href='mailbox.php?action=compose&ID={$r['userid']}'><font color='{$r['colour']}'>Mail</font></a>] (In Jail) </td>"; } if($r['hospital'] == 0 AND $r['jail'] == 0) { print"<td> [<a href='attack.php?ID={$r['userid']}'><font color='{$r['colour']}'>Attack</font></a>] | [<a href='mailbox.php?action=compose&ID={$r['userid']}'><font color='{$r['colour']}'>Mail</font></a>] </td>"; } print"</tr>"; } ?> </td> </tr> </table><hr /> <?php $h->endpage(); ?>

Installer not working. Anyone have the SQL?

True that it is less lag, but others can view the file and see the IP's and hack or what ever they do. Just thought I'd share ;)

Okay I don't care atm if it is reversable I just want it encoded for free. By a local script. So if one of you guys could help me I would Greatly appreciate it.

You have a point but I can afford to purchase the big name stuff, and if it's encrypted by something they have never heard of then maybe they won't find out how to decrypt it. Please come on guys help me out.

I have made a PHP hosting and billing w/ Auto account set up scripts in PHP and MYSQL and I am going to sell it like WHMCS or iPanel/iHost, etc. and I don't want it to be Pirated.

As said above I need help ASAP. If someone can help me out and code me a fast but secure PHP lock and encrypter. Please someone help me ASAP It's needed VERY soon.