Cronus Posted May 31, 2007 Posted May 31, 2007 Item Market Logs Created By: Cronus Keeps track of all items sold and bought on the item market. Price: FREE Click here to download. Quote
HITMAN 17 Posted September 22, 2007 Posted September 22, 2007 Re: [mccode] [TGM] Item Market Logs [TGM] can u just paste it plz as i cant download it Quote
Reaper Posted July 16, 2008 Posted July 16, 2008 Re: [mccode] [TGM] Item Market Logs [TGM] thanks mate for this it will help me a lot on my game Quote
iR00T Posted July 16, 2008 Posted July 16, 2008 Re: [mccode] [TGM] Item Market Logs [TGM] i will post it here: SQL: -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 30, 2006 at 09:12 PM -- Server version: 4.1.21 -- PHP Version: 4.4.2 -- -- Database: `crewsofl_project` -- -- -------------------------------------------------------- -- -- Table structure for table `itemlogs` -- CREATE TABLE `itemlogs` ( `ilogID` int(11) NOT NULL auto_increment, `ilogBUYER` int(11) NOT NULL default '0', `ilogSELLER` int(11) NOT NULL default '0', `ilogITEM` varchar(255) NOT NULL default '', `ilogPRICE` int(25) NOT NULL default '0', `ilogTIME` int(11) NOT NULL default '0', PRIMARY KEY (`ilogID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; Installation file: 1. Add the following line to the item market page where the users actually receive the stuff: mysql_query("INSERT INTO itemlogs VALUES('',$userid,{$r['imADDER']},'{$r['itmname']}',{$r['imPRICE']},unix_timestamp());",$c); 2. Put in the mysql dump. 3. Insert the following as a function to your assistant/secretary/admin panels. Make sure to link to it and make a case; break; thing for it: function view_itemmarket_logs() { global $ir,$c,$h,$userid; print "<h3>Item Market Logs</h3> <table width=75% border=1> <tr style='background:gray'> <th>ID</th> <th>Time</th> <th>Buyer</th> <th>Seller</th> <th>Item</th> <th>Total Cost</th></tr>"; $q=mysql_query("SELECT * FROM itemlogs ORDER BY ilogTIME DESC",$c); while($r=mysql_fetch_array($q)) { $sell=mysql_query("SELECT * FROM users WHERE userid={$r['ilogSELLER']}",$c); $seller=mysql_fetch_array($sell); $buy=mysql_query("SELECT * FROM users WHERE userid={$r['ilogBUYER']}",$c); $buyer=mysql_fetch_array($buy); print"<tr><td>{$r['ilogID']}</td> <td>".date('F j, Y, g:i:s a',$r['ilogTIME'])."</td><td>{$buyer['username']}</td><td>{$seller['username']}</td> <td>{$r['ilogITEM']}</td> <td> \${$r['ilogPRICE']}</td></tr>"; } } Quote
iR00T Posted July 16, 2008 Posted July 16, 2008 Re: [mccode] [TGM] Item Market Logs [TGM] his mods are always confusing and never are the full version like says this *make a break thing for it some people Dont know how to do that so yeah* i bought a mod came wid just a file and sql not how to install it but its says u will need this add into viewuser im like near xD Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.