Theogony Script

[laxplayer77alt]

[QUOTE=roleplay word;21243102]Stop being needy for a gamemode.[/QUOTE]

Stop bugging me to help you with all this sql shit for other gamemodes!

also lol cool gamemode

[H0rsey]

Too many networked variables.

[Deutsch]

[QUOTE=H0rsey;21263977]Too many networked variables.[/QUOTE]

It's a lag asker.

[roleplay word]

[QUOTE=H0rsey;21263977]Too many networked variables.[/QUOTE]

Just downloaded and looked through the code, fucking hell bang on my friend. [img]http://www.facepunch.com/fp/emoot/golfclap.gif[/img]

[Deutsch]

[QUOTE=roleplay word;21243102]Stop being needy for a gamemode.[/QUOTE]

Says you.

[Kirad]

Any progress for those mah squill tables?

[bfking]

[QUOTE=Kirad;21359942]Any progress for those mah squill tables?[/QUOTE]

nope if someone gets it done that would be very nice.

[Plankt0n]

Trying to sort this gamemode out, but however I have never heard of tmysql, which i assume is required. I tried to download it but I don't know how this work.

[url]http://www.productivity.org/projects/tmysql/[/url]

If anyone could point me in the right direction on how to "fix" tmysql that would be very appriciated.

I think i were looking for the wrong stuff.

[url]http://code.google.com/p/gmodmodules/source/browse/#svn/trunk/gm_tmysql2/Release[/url]

I download those files, I'm going to browse that site, and try to figure out where to place them/install them.

Edit again: I finally found this, :
[url]http://www.facepunch.com/showthread.php?t=241247[/url]
I think this is the real deal, if so I'm sorry for this post.

[deadeye536]

After an hour of reading Nori's code, I have come up with the all the tables except the admin table (very few references the actual structure, so I will need to take a few hours and figure that out). The config table still needs populating, but that [I]should[/I] not take too long. I also found a small bug in the escape function. Simply adding tostring() seemed to have fixed the issue.

Results so far, not too much to speak of, character selection/creation work fine, time is saved, items load, and factions/classes load. I can't say much for the properties and doors though, admin privlage don't work without the table.

[Globalnet]

[QUOTE=deadeye536;21602016]After an hour of reading Nori's code, I have come up with the all the tables except the admin table (very few references the actual structure, so I will need to take a few hours and figure that out). The config table still needs populating, but that [I]should[/I] not take too long. I also found a small bug in the escape function. Simply adding tostring() seemed to have fixed the issue.

Results so far, not too much to speak of, character selection/creation work fine, time is saved, items load, and factions/classes load. I can't say much for the properties and doors though, admin privlage don't work without the table.[/QUOTE]

Epic
Id love to see someone using this on a server.

[Deutsch]

I have the tables as well, the gamemode is absolutely excellent in the VGUI libary, but it is a resource hog.

[deadeye536]

[QUOTE=Deutsch;21631220]I have the tables as well, the gamemode is absolutely excellent in the VGUI libary, but it is a resource hog.[/QUOTE]

Agreed, the VGUI elements of this are great, however, gameplay, this script hardly seems like it can support anything close to a proper economy.

[erie1555]

[QUOTE=deadeye536;21602016]After an hour of reading Nori's code, I have come up with the all the tables except the admin table (very few references the actual structure, so I will need to take a few hours and figure that out). The config table still needs populating, but that [I]should[/I] not take too long. I also found a small bug in the escape function. Simply adding tostring() seemed to have fixed the issue.

Results so far, not too much to speak of, character selection/creation work fine, time is saved, items load, and factions/classes load. I can't say much for the properties and doors though, admin privlage don't work without the table.[/QUOTE]

Where would I add this?

[deadeye536]

[QUOTE=erie1555;21634762]Where would I add this?[/QUOTE]

Well, I ended up making several alterations to the init.lua file, to better fit the config. The gamemode still won't work at all if you don't have the SQL tables.

[editline]10:50PM[/editline]

Also, this gamemode requires a bit of knowledge of SQL to run, either that, or a basic understanding of how to use phpMyAdmin. The entire config is in the database, all admin data is stored in the database, etc.

[erie1555]

[QUOTE=deadeye536;21641280]Well, I ended up making several alterations to the init.lua file, to better fit the config. The gamemode still won't work at all if you don't have the SQL tables.

[editline]10:50PM[/editline]

Also, this gamemode requires a bit of knowledge of SQL to run, either that, or a basic understanding of how to use phpMyAdmin. The entire config is in the database, all admin data is stored in the database, etc.[/QUOTE]

I have the tables but I'm not sure what to edit in init.lua

[JWJ]

Considering I'm such a nice guy I just went ahead and rebuilt the SQL tables myself.
(I'm Nori if you haven't figured it out yet)

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `steamid` varchar(50) NOT NULL,
  `flags` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of admin
-- ----------------------------

-- ----------------------------
-- Table structure for `characters`
-- ----------------------------
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `model` varchar(500) NOT NULL,
  `money` int(100) NOT NULL,
  `loan` int(100) NOT NULL,
  `owner` varchar(50) NOT NULL,
  `faction` varchar(50) NOT NULL,
  `class` varchar(50) NOT NULL,
  `flags` longtext NOT NULL,
  `displaymodel` varchar(500) NOT NULL,
  `inventory` longtext NOT NULL,
  `occupation` varchar(100) NOT NULL,
  `description` longtext NOT NULL,
  `biography` longtext NOT NULL,
  `equipment` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of characters
-- ----------------------------

-- ----------------------------
-- Table structure for `config`
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `key` varchar(50) NOT NULL,
  `value` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES ('maxinventoryweight', '30');
INSERT INTO `config` VALUES ('default_money', '300');
INSERT INTO `config` VALUES ('time', '1 1 2012 1');

-- ----------------------------
-- Table structure for `doors`
-- ----------------------------
DROP TABLE IF EXISTS `doors`;
CREATE TABLE `doors` (
  `map` varchar(100) NOT NULL,
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `x` float(100,0) NOT NULL,
  `y` float(100,0) NOT NULL,
  `z` float(100,0) NOT NULL,
  `doorname` varchar(100) NOT NULL,
  `property` int(100) NOT NULL,
  `ownerkeys` longtext NOT NULL,
  `price` int(100) NOT NULL,
  `flags` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of doors
-- ----------------------------

-- ----------------------------
-- Table structure for `factionclass`
-- ----------------------------
DROP TABLE IF EXISTS `factionclass`;
CREATE TABLE `factionclass` (
  `id` varchar(50) NOT NULL,
  `type` varchar(1) NOT NULL,
  `enabled` varchar(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of factionclass
-- ----------------------------
INSERT INTO `factionclass` VALUES ('civilian', '1', '1');
INSERT INTO `factionclass` VALUES ('combine', '1', '1');
INSERT INTO `factionclass` VALUES ('resistance', '1', '1');
INSERT INTO `factionclass` VALUES ('citizen', '2', '1');
INSERT INTO `factionclass` VALUES ('cityadmin', '2', '1');
INSERT INTO `factionclass` VALUES ('eow', '2', '1');
INSERT INTO `factionclass` VALUES ('mp', '2', '1');
INSERT INTO `factionclass` VALUES ('ow', '2', '1');
INSERT INTO `factionclass` VALUES ('rebel', '2', '1');

-- ----------------------------
-- Table structure for `items`
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
  `name` varchar(100) NOT NULL,
  `enabled` varchar(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of items
-- ----------------------------
INSERT INTO `items` VALUES ('ration', '1');
INSERT INTO `items` VALUES ('rebelvest', '1');

-- ----------------------------
-- Table structure for `properties`
-- ----------------------------
DROP TABLE IF EXISTS `properties`;
CREATE TABLE `properties` (
  `map` varchar(100) NOT NULL,
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `doors` longtext NOT NULL,
  `flags` longtext NOT NULL,
  `price` int(100) NOT NULL,
  `ownerkeys` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of properties
-- ----------------------------

-- ----------------------------
-- Table structure for `tooltrust`
-- ----------------------------
DROP TABLE IF EXISTS `tooltrust`;
CREATE TABLE `tooltrust` (
  `steamid` varchar(50) NOT NULL,
  `tools` longtext NOT NULL,
  PRIMARY KEY (`steamid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of tooltrust
-- ----------------------------

Note that this gamemode was never supposed to be released, wasn't 100% polished up, it's not friendly to the common server host, it's not efficient at all, and it still has debugging shit everywhere.

Now only if I could finish CSG3..

[Abeevau]

[QUOTE=JWJ;21671804]Considering I'm such a nice guy I just went ahead and rebuilt the SQL tables myself.
(I'm Nori if you haven't figured it out yet)

-snip-

Note that this gamemode was never supposed to be released, wasn't 100% polished up, it's not friendly to the common server host, it's not efficient at all, and it still has debugging shit everywhere.

Now only if I could finish CSG3..[/QUOTE]

about time you made an alt :D

[Deutsch]

So what's the plan with G3 Nori, still not going to be released?

[Katsu63]

[QUOTE=Deutsch;21673612]So what's the plan with G3 Nori, still not going to be released?[/QUOTE]

Nori got a life :<

[JWJ]

[QUOTE=Katsu63;21674129]Nori got a life :<[/QUOTE]

:saddowns:

[connorclockwise]

Don't be sad Nori, I'm sure someone will put this to good use.

[SchumacherAlt]

Quite laggy, but the GUI elements are superb.

[Tokiz]

[QUOTE=SchumacherAlt;21688227]Quite laggy, but the GUI elements are superb.[/QUOTE]

Okey, how did you do?

I made a MySQL Database wihit phpMyAdmin localhost

then i ran the script from Singeplayer.

i also used [URL="http://www.facepunch.com/member.php?u=285357"]JWJ[/URL]'s a.k.a Nori's db.

do i need that tmysql wtf? :S

i also have latin1_swedish_ci at the DB's, do i need to change this maybe?

[Shadow_Hedgehog]

[QUOTE=JWJ;21671804]
(I'm Nori if you haven't figured it out yet)[/QUOTE]

Making a alt of a permabanned account...hmmm.

[QUOTE=Deutsch;21673612]So what's the plan with G3 Nori, still not going to be released?[/QUOTE]

I gave up all hope of any Cakescripts when he raged and made it pay to obtain, shame really.

[Tokiz]

[QUOTE=Tokiz;21761726]Okey, how did you do?

I made a MySQL Database wihit phpMyAdmin localhost

then i ran the script from Singeplayer.

i also used [URL="http://www.facepunch.com/member.php?u=285357"]JWJ[/URL]'s a.k.a Nori's db.

do i need that tmysql wtf? :S

i also have latin1_swedish_ci at the DB's, do i need to change this maybe?[/QUOTE]

NVM Fixed it. but i didn't like [URL="http://www.facepunch.com/showthread.php?p=21761726#post21761726"]Theogony Script[/URL] so i just wait for CakeScript G3 , atm im running Nexus :D

[alexanderk]

He isn't finishing G3

[roleplay word]

Thanks to me he isnt finishing G3.

[JWJ]

[QUOTE=roleplay word;21802256]Thanks to me he isnt finishing G3.[/QUOTE]

You give yourself too much credit.

[Grea$eMonkey]

[QUOTE=roleplay word;21802256]Thanks to me he isnt finishing G3.[/QUOTE]

That's nothing to be proud of.

[SchumacherAlt]

[QUOTE=roleplay word;21802256]Thanks to me he isnt finishing G3.[/QUOTE]

You're a fool, nothing to be proud of. G3 was coming along as a really nice piece of art. I think you're just trying to gain attention.