Stat Inserting and withdrawing mod

[corruptcity || skalman]

ok here is the SQL for the mod

[mysql]

-- Table structure for table `implants`

--

CREATE TABLE IF NOT EXISTS `implants` (

`statid` int(11) NOT NULL AUTO_INCREMENT,

`userid` int(11) NOT NULL,

`stat` tinytext NOT NULL,

`amount` decimal(11,4) NOT NULL,

`stat_type` int(11) NOT NULL DEFAULT '0',

PRIMARY KEY (`statid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--

[/mysql]

[mysql]

-- Table structure for table `implant_market`

--

CREATE TABLE IF NOT EXISTS `implant_market` (

`marketid` int(11) NOT NULL AUTO_INCREMENT,

`statid` int(11) NOT NULL,

`userid` int(11) NOT NULL,

`stat_type` int(11) NOT NULL,

`amount` decimal(11,4) NOT NULL,

`price` int(11) NOT NULL,

PRIMARY KEY (`marketid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--

[/mysql]

[mysql]

-- Table structure for table `smarketlogs`

--

CREATE TABLE IF NOT EXISTS `smarketlogs` (

`smlid` int(11) NOT NULL AUTO_INCREMENT,

`statid` int(11) NOT NULL,

`userid` int(11) NOT NULL,

`stat_type` int(11) NOT NULL,

`amount` decimal(11,4) NOT NULL,

`price` int(11) NOT NULL,

`time` int(11) NOT NULL,

PRIMARY KEY (`smlid`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--

[/mysql]

ok still more to come

[corruptcity || skalman]

ok here is the statwithdraw.php

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

here is the statinsert.php

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

impinsert.php

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

still more to come

[corruptcity || skalman]

this is to statadd.php

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

im still working on the stat market page will paste it once done

i will also setup this mod on my testing site so that you can see it working before if you want to use it

the link will be http://tester.corruptcity.net

[Joshua]

+1 bro, I know you worked hard on this :)

[Diesel]

What exactly is the function of this mod?

[Curt]

it allows you to withdraw a % of a stat and creates a injection type item...and when this item is used it adds the % to your stat.

So you could give a friend some stats or even sell stats on the market...

hope u understand that..lol

cheers

[Gucci Mane]

I kno you been working hard on this lol I talk to you while you do lol def. plus 1 from me as I will be using this, I think this mabe should have been a paid mod though but just my opinion lol

[chicka]

This looks very interesting. What this will do for some games is, if the top players have huge stats and no money they can sell some of their stats become weak how ever become rich at the same time. For those who concentrate only on their stats, this could prove to be quite profiting for them.

[corruptcity || skalman]

ok you dont need to do any of them

[corruptcity || skalman]

ignore me

[Gucci Mane]

What?

[corruptcity || skalman]

doesnt matter it was about my last post it was working for me yesterday as my pc was playing funny buggers

[corruptcity || skalman]

ok peeps here it is the final page of the mod the stat market page

i have setup my tester site so you can see the mod in action

the site is http://tester.corruptcity.net

i have created 4 account demo through demo 4 and the passwords for all are abc123

all 3 links that you need are on the main menu stat withdraw, stat insert and stat market

before i post the code i would like to say thanks to Entropia for giving me the idea for the mod, Immortal Thug thanks m8 you help me alot even if i was a pain in the ass lol,

fbiss and others.

if you like the stat market im im thinking about making an item market like it which i will sell.

here is the code

statmarket.php

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[Joshua]

Gave this mod a test run last night.

2 things.

 

One, You didnt put what to Label Each .php page so it took me a few to figure it out =P

Two, I'll go through it, but I'm getting errors when trying to add stats to market. Page keeps refreshing like I didnt add, so :P

Other than that...I cant beleive you didnt make this a paid mod =)

[Joshua]

Ok.

 

With the changes you have to make with statadd.php it doesnt work properly.

If i use the original, it posts everything but the Stat into market, so i'm a bit closer to fixing.

 

on the Market itself, When removing my stat

QUERY ERROR: Duplicate entry '7' for key 1

Query was INSERT INTO implants (statid, userid, stat, amount, stat_type) VALUES ('7', '1','','14.0510','1')

Is the error i get :P

[corruptcity || skalman]

the reason why your gettin that error was when i was testing it out i commented out the delete query all you need to do is remove the // and it will work lol there is 1 on the statmarket page and the other 1 is on the statadd

[Joshua]

Meh Uncle, I can't get it to work >,<

Everything is 100% but the stat Add and statmarket for me

 

I had it posting to the market earlier but i copied your updated code and now it's not working :P

Cant remember wth i did to get it to work either or what has changed >,<

When it was posting to the market the STAT column was blank as well

[J_StrauD]

Im getting this error on the statadd page...

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tallica/public_html/class/class_db_mysql.php on line 71

[vampireduff]

There is a mod called 'statsmarket' I got it from here a while ago when this site was called CE. the statsmarket mod does the same as this. I have used it on my site at first the players where great with it. but after 1 week it seemed to die and no one used it after that.

I still give you a +1 though for the hard work you put in :)

[gideon prewett]

congrats on the mod i looks good i wont be useing it though but can i surgest u add a log system to it to stop multis sending stats to 1 player

[Mcfarlin]

lmfao at the announcement bro, that funny a hell.

very nice mod as well.