KDawg08

Re: Updated Mailbox [v1] If you used my DELETE READ mod for this mailbox please change it to the one posted 2 topics up! I fixed the bugs and it will only delete yours now.

Re: Check this idiot out... His demos are beautiful... NOT Gotta love how all accounts on all demo's are jailed lol. He shoulda been smart and removed password change and jailing users from WORKING so that admin couldn't do it in the demo... that woulda been my simple solution... What an idiot.

Re: FREE Bug Tracker Mod   Here is v1 version of the mod 2 posts up. <?php /*************************** Bug Tracker (1.0) made by oxidati0n -- Designed to make sure your bug asking days are over, Your players can efficiently report them, for those buggy players - It has most hacks removed. Such as HTML block, Javascript and PHP! Requires PHP version 4.44 minimum for this code to work! Created by oxidati0n! ***************************/ 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,$cm); $h->menuarea(); $sd=mysql_query("SELECT * FROM `bugtracker` WHERE `bt_from` = '$userid'"); if($_GET['x'] == "add" and mysql_num_rows($sd) < 7) { if($_POST['urgency'] and $_POST['description']) { //Secure the webpage. My favourite :> $_POST['description']=str_replace("/n", " ", strip_tags($_POST['description'])); $time=time(); //Insert the time log. $ip=$_SERVER['REMOTE_ADDR']; //The users IP - logged. ha ha! $nf="Not Fixed"; //The text for startup mysql_query("INSERT INTO `bugtracker` (`bt_id`, `bt_posted`, `bt_from`, `bt_description`, `bt_read`, `bt_replyfrom`, `bt_status`, `bt_replytext`, `bt_urgency`, `bt_iplogged`) VALUES ('NULL', '$time', '$userid', '$_POST[description]', '0', '0', '$nf', 'N/A', '$_POST[urgency]', '$ip');") or die("<center>Your report couldn't be processed at this time. Either contact an admin or try again later. Thanks and sorry for any inconvenience caused [url='bugtracker.php']Back[/url] </center>"); print "<center>Your bug report has initially been added! [url='bugtracker.php']Back[/url]</center> "; $h->endpage(); exit(); } else { print "<center><h3>Submit your report</h3></center> <center><table width=60% border=2 cellspacing=1 class='table'></center> <td><font color=red>Your IP logged: ".$_SERVER['REMOTE_ADDR']."</font> Your IP is logged for our benefit and yours, to ensure the reporting system is not being abused! Once submitted, your report will show as hidden to all other players except you and authorized staff. <hr /> NOTE: This is only to report bugs, If it's related to players post it on the "Report a Player" page. Bugs are errors/spelling mistakes, php disruption, file/page errors or a glitch in the game that allows an unfair advantage if exploited. </td></tr></table> <center><form action='bugtracker.php?x=add' method='post'> Urgency: <select name='urgency'><option value='Low'>Low</option> <option value='Medium'>Medium</option><option value='High'>High</option></select> Description (include as much detail as possible, page links and error messages will be helpful aswell): <textarea name='description' cols=60 rows=11></textarea> <input type=submit value='Submit Bug Report'></form> </center>"; $h->endpage(); exit(); } } else if($ir['user_level'] > 1 and $_GET['x'] == "remove" and $_GET['report']) { mysql_query("DELETE FROM `bugtracker` WHERE `bt_id` = '$_GET[report]'"); print "<center>Bug Report Row Removed [url='bugtracker.php']Back[/url]</center> "; $h->endpage(); exit(); } elseif($ir['user_level'] > 1 and $_GET['x'] == "reply" and $_GET['report']) { if($_POST['text']) { //Make sure the text is ready to go, clean and safe. $text=str_replace(array("<",">","/n"),array("","",""),$_POST['text']); $status=($_POST['status']); mysql_query("UPDATE `bugtracker` SET `bt_replyfrom` = '$userid', `bt_replytext` = '$text', `bt_status` = '$status' WHERE `bt_id` = '$_GET[report]'"); print "<center>Bug Report Row Edited [url='bugtracker.php']Back[/url]</center> "; $h->endpage(); exit(); } else { print "<center>[b]Make a reply[/b] <form action='bugtracker.php?x=reply&report=$_GET[report]' method='post'> Status: <select name='status'> <option value='Not Fixed'>Not Fixed</option> <option value='Not a Bug'>Not a Bug</option> <option value='Under Repair'>Under Repair</option> <option value='Fixed'>Fixed</option></select> Reply: <textarea name='text' cols=60 rows=11>Your reply here...</textarea> <input type=submit value='Submit Reply!'> </form></center>"; $h->endpage(); exit(); } } $_GET['st'] = abs((int) $_GET['st']); $st=($_GET['st']) ? $_GET['st'] : 0; print "<center><h3>Bug Reports</h3></center>"; $sd=mysql_query("SELECT * FROM `bugtracker` WHERE `bt_from` = '$userid'"); if(mysql_num_rows($sd) < 7) { print "<center>[url='bugtracker.php?x=add'][Add a Report][/url]</center> "; } print "<center>[b]You can submit several bug reports[/b] </center>"; if(!$_GET['selectBug']) { $reports=mysql_num_rows(mysql_query("SELECT * FROM `bugtracker`")); $shown=10; //How many rows should be shown in one row $pages=(int) ($reports/$shown)+1; if($membs % $shown == 1) { $pages--; } print "<center>Pages: "; for($i=1;$i <= $pages;$i++) { $stl=($i-1)*$shown; print "[url='bugtracker.php?st=$stl']$i[/url] </center>"; } } if($ir["user_level"] > 1) { $man="<th>Manage</th>"; $cols=8; mysql_query("UPDATE `bugtracker` SET `bt_read` = '1' WHERE `bt_read` = '0'"); } else { $cols=7; } print " <center><table width=90% border=2 cellspacing=1 class='table'></center> <tr style='background:darkred'> <th colspan={$cols}>Viewing all reported bugs - </th> </tr> <tr style='background:darkred'> <th>Report Number</th> <th>From</th> <th>Urgency</th> <th>Description</th> <th>Reply Comments</th> <th>Read</th> <th>Status</th> ".$man."</tr>"; if(!$_GET['selectBug']) { $q=mysql_query("SELECT * FROM `bugtracker` ORDER BY `bt_posted` DESC LIMIT $st,10"); } else { $q=mysql_query("SELECT * FROM `bugtracker` WHERE `bt_id` = '$_GET[selectBug]' LIMIT 1;"); } if(mysql_num_rows($q) == 0) { print "<tr style='background:darkred'> <td colspan={$cols}>There are no current reports been posted.</td> </tr>"; } while($r=mysql_fetch_array($q)) { if($r['bt_from'] == $userid or $ir['user_level'] == 2 or $ir['user_level'] == 3) { $user_q=mysql_query("SELECT * FROM `users` WHERE `userid` = '$r[bt_from]'"); $p=mysql_fetch_array($user_q); if($r['bt_replyfrom'] > 0) { $user_q2=mysql_query("SELECT * FROM `users` WHERE `userid` = '$r[bt_replyfrom]'"); $d=mysql_fetch_array($user_q2); } $x=$r["bt_id"]; if($r['bt_read'] == 1) { $re="<font color=green>[b]Read[/b]</font>"; } else { $re="<font color=red>[b]No[/b]</font>"; } print " <tr style='background:darkred'> <td align=center>".number_format($x)."</td> <td align=center>[url='viewuser.php?u={$x}']".$p['username']."[/url] [".$p['userid']."]</td> <td align=center>".$r['bt_urgency']."</td> <td align=center>".$r['bt_description']."</td> <td align=center>"; if($r['bt_replyfrom'] > 0) { print "[b]".$r['bt_replytext']." [i]Replied from [url='viewuser.php?u=$d[userid]']$d[username][/url][/i]"; } else { print "<center>You haven't been replied yet.</center>"; } print " </td> <td align=center>".$re."</td> <td align=center>$r[bt_status]</td>"; if($cols == 8) { print " <td align=center> <font color=black>IP Logged: [b]".$r['bt_iplogged']."[/b]</font> [url='bugtracker.php?x=remove&report={$x}']Remove[/url] [url='bugtracker.php?x=reply&report={$x}']Make Reply[/url] [url='mailbox.php?action=compose&ID={$p[']Mail User[/url] </td>"; } print "</tr>"; } else { print "<tr style='background:darkred'><center> <td align=center>Hidden</td> <td align=center>Hidden</td> <td align=center>Hidden</td> <td align=center>Hidden</td> <td align=center>Hidden</td> <td align=center>Hidden</td> <td align=center>Hidden</td> </center></tr>"; } } print "</table></center> "; if(!$_GET['selectBug']) { print "<center>Pages: "; for($i=1;$i <= $pages;$i++) { $stl=($i-1)*$shown; print "[url='bugtracker.php?st=$stl']$i[/url] </center>"; } } $h->endpage(); ?>   I tested it but only a quick fix test so if it doesn't work 100% let me know and i'll keep checking it for fixes.

Re: Updated Mailbox [v1] UPDATE!!! I FIXED THE DELETE READ AS IT WAS DELETING ALL USERS READ MESSAGES. IT WILL NOW ONLY DELETE YOUR PERSONAL READ MESSAGES. I also forgot to add info about the link so it's posted as well now. I added a new piece to this mod. I find it useful and it will also save LOADS of webspace along with getting rid of unneeded in game mails. I added a DELETE READ feature to delete messages you have already read. Find case 'send': mail_send(); break;   After it add case 'delread': mail_delread(); break; case 'delread2': mail_delread2(); break;   THEN FIND function mail_delete() { global $ir,$c,$userid,$h; mysql_query("DELETE FROM mail WHERE mail_id={$_GET['ID']} AND mail_to=$userid",$c); print "Message deleted. [url='mailbox.php']> Back[/url]"; }   Under it add function mail_delread() { global $ir,$c,$userid,$h; print "This will delete all the READ messages in your inbox. There is [b]NO[/b] undo, so be sure. [url='mailbox.php?action=delread2']> Yes, delete all READ messages[/url] [url='mailbox.php']> No, go back[/url]"; } function mail_delread2() { global $ir,$c,$userid,$h; $ccc=mysql_query("SELECT * FROM mail WHERE mail_to=$userid AND mail_read=1",$c); mysql_query("DELETE FROM mail WHERE mail_to=$userid AND mail_read=1",$c); print "All ".mysql_num_rows($ccc)." READ mails in your inbox were deleted. [url='mailbox.php']> Back[/url]"; }   FIND <td width=20% align=center>> [url='mailbox.php?action=archive'] Save[/url]</td> and under it add <td width=20% align=center>> [url='mailbox.php?action=delread'] Delete Read[/url]</td> I WOULD ALSO RECOMMEND CHANGING THE td width=20% to 16.6% if u want them to be centered properly. :) For v2 just change mysql_ to $db-> and it should be good to go. I'm not a great coder as I'm self teaching at the moment so feel free to let me know your thoughts on it. TESTED AND WORKS!!! Thanks Toxication for the attempt, but I found our first attempt was completely wrong. :P

How would i limit each person so if they sell their house, they can't buy it back til the end of the day?   Sorry for all the posts but these will also be good for future noobs and questions :)

How do i use logo.jpg for all my pages as i am now. BUT for specific pages like... SLOTS change it to something like casino.jpg?

Re: Quick SQL Error oh LMAO thanks :)

could someone tell me what is wrong in this? ALTER TABLE `users` ADD `pic` VARCHER( 255 ) NOT NULL DEFAULT 'http://www.twisteddenial.net/logo.jpg';

Re: FREE V2 NEW GAME STATS PAGE As I promised. Here is the FIXED V1 version.   <?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.*,h.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN houses h ON h.hWILL=u.maxwill WHERE u.userid=$userid",$c) or die(mysql_error()); $ir=mysql_fetch_array($is); check_level(); $fm=money_formatter($ir['money']); $bm=money_formatter($ir['bankmoney']); $cm=money_formatter($ir['crystals'],''); $qw=($ir['bankcrystal']); $s3=($ir['gangNAME']); $jb=($ir['jNAME']); $lv=date('F j, Y, g:i a',$ir['laston']); $h->userdata($ir,$lv,$fm,$cm); $h->menuarea(); $q=mysql_query("SELECT userid FROM users"); $membs=mysql_num_rows($q); $q=mysql_query("SELECT userid FROM users WHERE bankmoney>-1"); $banks=mysql_num_rows($q); $q=mysql_query("SELECT userid FROM users WHERE gender='Male'"); $male=mysql_num_rows($q); $q=mysql_query("SELECT userid FROM users WHERE gender='Female'"); $fem=mysql_num_rows($q); $total=0; $q=mysql_query("SELECT money FROM users"); while($r=mysql_fetch_array($q)) { $total+=$r['money']; } $avg=(int) ($total/$membs); $totalb=0; $q=mysql_query("SELECT bankmoney FROM users WHERE bankmoney>-1"); while($r=mysql_fetch_array($q)) { $totalb+=$r['bankmoney']; } $avgb=(int) ($totalb/$banks); $totalc=0; $q=mysql_query("SELECT crystals FROM users"); while($r=mysql_fetch_array($q)) { $totalc+=$r['crystals']; } $totali=0; $q=mysql_query("SELECT inv_qty FROM inventory"); while($r=mysql_fetch_array($q)) { $totali+=$r['inv_qty']; } $avgc=(int) ($totalc/$membs); $q=mysql_query("SELECT mail_id FROM mail"); $mail=mysql_num_rows($q); $q=mysql_query("SELECT evID FROM events"); $events=mysql_num_rows($q); $q=mysql_query("SELECT * FROM records WHERE recid=1",$c); $v=mysql_fetch_array($q); $q=mysql_query("SELECT username FROM users WHERE laston>unix_timestamp()-300*300 ORDER BY laston DESC",$c); $twsev=mysql_num_rows($q); $q=mysql_query("SELECT username FROM users WHERE laston>unix_timestamp()-60*60 ORDER BY laston DESC",$c); $lasthr=mysql_num_rows($q); $q=mysql_query("SELECT username,userid,laston FROM users WHERE laston>unix_timestamp()-15*60 ORDER BY laston DESC",$c); $fifteen=mysql_num_rows($q); if ($v['rec15']<$fifteen) {mysql_query("UPDATE records SET rec15=$fifteen WHERE recid=1",$c);} if ($v['rec24']<$twsev) {mysql_query("UPDATE records SET rec24=$twsev WHERE recid=1",$c);} if ($v['rec60']<$lasthr) {mysql_query("UPDATE records SET rec60=$lasthr WHERE recid=1",$c);} print "<h3>Twisted Denail Statistics</h3> You step into the Statistics Department and login to the service. You see some stats that interest you. <table width=75% cellspacing=1 class='table' border='1' bordercolor='#636363'> <tr> <th colspan=2>Users</th></tr> <tr><td colspan=2> There are currently <font color='red'>$membs</font> {$set['game_name']} players, <font color='green'>$male</font> males and <font color='green'>$fem</font> females.</td> </tr> <tr> <th colspan=2>Users Bank Statistics</th></tr> <tr><td colspan=2>Amount of players with bank accounts: <font color='red'>$banks</font></td> </tr> <tr><td colspan=2>Amount of cash in banks: <font color='red'>\$".money_formatter($totalb,"").". </font></td> </tr> <tr><td colspan=2>The average player has in their bank accnt: <font color='red'>\$".money_formatter($avgb,"").". </font></td> </tr> <tr><th>Users Money</th><th>Users Crystals</th></tr> <tr><td>Amount of cash in circulation: <font color='red'>\$".money_formatter($total,"").". </font></td> <td>Amount of crystals in circulation: <font color='red'>".money_formatter($totalc,"").". </font></td></tr> <tr><td>The average player has: <font color='red'>\$".money_formatter($avg,"").". </font></td> <td>The average player has: <font color='red'>".money_formatter($avgc,"")." </font>crystals.</td></tr> <tr><th>Mails/Events</th><th>Items</th></tr> <tr><td><font color='red'>".money_formatter($mail,"")."</font> mails and <font color='red'>".money_formatter($events,"")." </font>events have been sent.</td> <td>There are currently <font color='red'>".money_formatter($totali,"")." </font>items in circulation.</td></tr> <tr><th>Users Online Statistics</th><th>Users Online All Time Records</th></tr> <tr><td>Within the last 15 minutes: <font color='red'>$fifteen</font></td> <td>15 Minutes Record: <font color='red'>{$v['rec15']}</font></td></tr> <tr><td>Within the last hour: <font color='red'>$lasthr </font></td><td>1 Hour Record: <font color='red'>{$v['rec60']}</font></td></tr> <tr><td>Within the last 24 hours: <font color='red'>$twsev</font></td><td>1 Day Record: <font color='red'>{$v['rec24']}</font></td></tr> </table>"; $h->endpage(); ?>   I just changed the fetch_row's to fetch_array's for v1. Edit = Changed it from a quote to code lol. CODE TESTED AND WORKING!

Re: Free 2 - Gym LOL I think i love you now LMFAO. j/k Thanks so much, I never thought of that. forgot to look at this:

Re: HURRY ASAP HELP NEEDED well a couple hours i figure isn't a big backup needed just rollback. anyhow i think i found a way to stop the screwups... How do i remove X amount of days from ALL USERS in the game (to remove the days old that was added) and How do i remove X amount of days worth of interest in the game from everyones banks (both banks in game have standard interest) normal bank 2% and the cyber bank 7%. if i cant fix this game will be normal again :)

Re: HURRY ASAP HELP NEEDED anyhow i know u guys are smart, so... Is there any way you know of to back track in the database files about 2 hours without a complete personal backup?

Re: HURRY ASAP HELP NEEDED yup that's what happened but now i need to backtrack and i removed the cron folders i was too stupid to change those and didn't realize it til this happened.

Re: HURRY ASAP HELP NEEDED I heard there was a way i'm just not sure.. only things i have backups from in the last 2 hours are the crons but not the database itself last DB backup was a week ago. My game glitched and over 550days went by outta nowhere in under an hour while i was away and now everyone has BILLIONS and BILLIONS of dollars...

Is there a way to backtrack the phpmyadmin setup say... 2 hours backwards? last backup was 1wk 3days ago, this is highly important.

Re: Bookies Shop Not to be a critic but the description you left is very undescriptive... It gives a couple details but had me lookin like this... "WTF :?" Lol, maybe post a screenshot or 2 and explain it a little more?

Re: FREE V2 NEW GAME STATS PAGE V1 version is completely messed up i'll fix that later and repost it... Examples: Amount of cash in banks: $0. The average player has in their bank accnt: $0. Amount of cash in circulation: $0. Amount of crystals in circulation: 0. The average player has: $0. The average player has: 0 crystals. There are currently 0 items in circulation.

Re: Free 2 - Gym Fatal error: Call to undefined function mysql_fetch_single() in /home/teamms/public_html/gym.php on line 126 Twizted ^ That's v1 error.   I've bolded it for ya to see the error.

Re: Free 2 - Gym my_sql was a typo but idid replace it properly still didn't work takes me to login page

Re: +25% instead of +25 energy even when i input this one it gives me 25% but if i have 75% it drops to 25%...

Re: Free 2 - Gym Anyone? This would be greatly appreciated.

Re: Free 2 - Gym Hate to be a hassle but how would I convert this to V1? I replaced the require globals.php and the $db-> with my_sql but it forces me to the login page...

Re: Guess the next poster nope (new guy) -Matt-

Re: Fight turns to blank page... FIXED, This was from the random event script...

[11:14 am] jdilla342: kd i was attackin some1 and imy page has gone blank except the donation and stats bit [11:14 am] jdilla342: if i clike anything i will lose my exp This is one of the examples... If they click back they lose their exp. and if they click anything else or refresh it's still taking their exp. Any idea how i can fix this little bug? I've searched the forums and didn't see anything on this. Then again... People names there topics retardedly like... "Help me please" or "hhhhhheeeeeeeellllllpppppp" So that doesn't help much.