Jump to content
MakeWebGames

Recommended Posts

  • 3 months later...
  • 9 months later...
Posted

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>";

}

}

Posted

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...