Lotan Kane

Sure did.Just tried dropping all the tables and re-doing the sql's one by one,unfortunately still no luck.Re-did druglab,and drugmarket just to see if it would help,no change though.

Gettin this error when trying to purchase drugs: QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Query was SELECT `dID`,`drugTYPE`,`materialPRICE`,`drugCITY` FROM `drugs` WHERE `dID`= Looks like a great mod by the way.Thanx for taking the time to make it.

Hope i've posted this in the correct section. Been having a hard time finding either a decent paid or free Drug mod for v2.does'nt have to be the most advanced mod on earth but i'd atleast like a few of these options if not all: Grow/farm drugs make instantly available drugs to buy/sell ability to sell drugs in markets as items drugs have effect on player's stats (will,energy,brave,ect...) admin panel for drug managing anything else that sounds good,lol Most definitely willing to pay for it.Pm me or post here with offers,looking to purchase one today if possible.Thanx for any help,i know theres stuff like this out there.I've just had no luck finding it,lol. ps.also trying to find some sort of pet type mod,where you can train,and battle pets,also willing to purchase this.

Thanx wrx.I'm a retard and must have have overlooked that in the first post.I was up for close to 24 hours when i made that post last night.Anyhow,thanx again for pointin me in the right direction,your a gentleman and a scholar.

Sorry to bring up a semi-old topic,but i am getting this error after trying to make a meal, QUERY ERROR: Unknown column 'meal_eat' in 'field list' Query was UPDATE users SET meal_eat = meal_eat + 1, energy=20, hp=300 WHERE userid = 1   Thanx for any help with this issue.

Thank you Jordan.I'll give this a try here in a bit.Also thank you for offering help through msn.

Things appear to be correct,just tried a fresh install once again.I have'nt changed anything,all is still in it's original state. With that said,i must be doing something wrong,or overlooking something.Thank you for your help Magictallguy,i hope this is not an inconvenience. *after more testing i figured out that its only the mail and events that do not show a new count.Still trying to figure out why this is not working.Also noticed that it never shows as a new event or new message in the users table in the database.

I'm using V2,with no mods.I've tried uninstalling and re-installing multiple times and can not figure this out for the life of me.I dont have a whole lot of time,due to having a job,so i thought i'd take the easy route and ask some fellows who know a bit more about this script then myself. For some god awful reason the events,mail,jail,and hospital do not show a new count number next to them.They just sit at zero,no matter how many new events,mails or whatnot occur.I assume this is a simple fix,maybe,maybe not.But any insight as to why this is happening would be greatly appreciated. If any more info is needed,just say the word,and i'll provide as much as possible. :)

When i create new crimes,on mccode v2,everything seems to be working correclty except no matter how or what i set the crimeXP at it never increases the XP of my users.Anyone have any suggestions?Help is greatly appreciated.