[WIP] Usersystem [ Q: Should I remake? ]

[dzek (varez)]

Remi-X - there is NO NEED to forward any ports for LOCAL mysql server..

On typical home connection connecting to remote MySQL will be much too slow!

[Timic]

Someone have video how to make database?? -.-''

[dzek (varez)]

you only need to fill ONE form field and hit ENTER. lol. Is it THAT hard?

[attemptIt]

Can't wait till release : ]

[dzek (varez)]

Cannonball seems to be pretty inactive, there's a chance this project is dead then.

[attemptIt]

Hope not, maybe someone could ask him to give us the source and let someone else finish it.

[Cannonball]

Cannonball seems to be pretty inactive, there's a chance this project is dead then.

Actually, im still working on it hehe!

The system got expanded somewise. Most are bugfixes and new animations! So this will be updated soon

[rafull6]

Hello, guys! When I try to start User System - my Server falls down. Why? This resource outdated or what!?

[Castillo]

Do you have the Mysql module and the Mysql server?

[rafull6]

Yes, my MySQL module turned on. I have MySQL server too.

==================================================

Added:

Server just felling down when I am starting this resource.

[Castillo]

Check the server log, see why it's 'going down'.

[rafull6]

Here is it:

=========================================================== 
= Multi Theft Auto: San Andreas v1.0.5 
=========================================================== 
= Server name      : Zday mod 
= Server IP address:  
= Server port      : 22003 
=  
= Log file         : ..TASA/server/mods/deathmatch/logs/server.log 
= Maximum players  : 32 
= MTU packet size  : 1264 
= HTTP port        : 22005 
=========================================================== 
[2011-06-17 18:52:55] Resources: 221 loaded, 0 failed 
[2011-06-17 18:52:55] Querying game-monitor.com master server... success! 
[2011-06-17 18:52:56] Querying backup master server... success! 
[2011-06-17 18:52:56] MODULE: Loaded "MySQL 5.0 database module" (0.20) by "Alberto Alonso <[email protected]>" 
[2011-06-17 18:52:56] Starting resources................... 
[2011-06-17 18:52:57] Server started and is ready to accept connections! 
[2011-06-17 18:52:57] Type 'help' for a list of commands. 
[2011-06-17 18:54:10] start: Requested by RAFuLL 
[2011-06-17 18:54:10] Some files in 'superweapons' use deprecated functions. 
[2011-06-17 18:54:10] Use the 'upgrade' command to perform a basic upgrade of resources. 
[2011-06-17 18:54:10] Starting superweapons 
[2011-06-17 19:10:56] start: Requested by Console 
[2011-06-17 19:10:56] Starting usersystem 

After this information appears a window like this but it says next: "MTA Server.exe stopped working"

P.S. Sorry for the wrong screen. My native language is different.

[Orange]

update mysql module

[rafull6]

updating helped. Thank you very much!

[GTX]

Hello, i'm sorry if i bumping but i need assistance.

I have problems with shop, items won't show in the grid.

IMAGE(S):

http://screencast.com/t/7CEPXJsGm

http://www.screencast.com/users/GTX_/fo ... aba3ee9cd2

GUI:

http://www.screencast.com/users/GTX_/fo ... 28356e1005

The code:

  
-- phpMyAdmin SQL Dump 
-- version 3.3.9 
-- [url=http://www.phpmyadmin.net]http://www.phpmyadmin.net[/url] 
-- 
-- Host: localhost 
-- Generation Time: Aug 15, 2011 at 11:22  
-- Server version: 5.5.8 
-- PHP Version: 5.3.5 
  
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 
  
  
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 
/*!40101 SET NAMES utf8 */; 
  
-- 
-- Database: `usersystem` 
-- 
  
-- -------------------------------------------------------- 
  
-- 
-- Table structure for table `store_items` 
-- 
  
CREATE TABLE IF NOT EXISTS `store_items` ( 
  `id` int(255) NOT NULL AUTO_INCREMENT, 
  `itemname` varchar(80) NOT NULL, 
  `itemid` int(255) NOT NULL, 
  `itemvalue` int(255) NOT NULL DEFAULT '0', 
  `catagoryid` int(255) NOT NULL, 
  `type` varchar(255) NOT NULL, 
  PRIMARY KEY (`id`) 
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ; 
  
-- 
-- Dumping data for table `store_items` 
-- 
  
INSERT INTO `store_items` (`id`, `itemname`, `itemid`, `itemvalue`, `catagoryid`, `type`) VALUES 
(26, 'Shotgun', 25, 100, 0, 'weapon'); 
  

If someone knows the solution, please tell me.

P.S: I am kind of newbie with MySQL.

[qaisjp]

By default there are none, you have to add it yourself (through mysql, i use phpmyadmin)

[GTX]

By default there are none, you have to add it yourself (through mysql, i use phpmyadmin)

I have already added it but it seems something is wrong.

[GTX]

Bump

[Cannonball]

Since im thinking of doing a remake off this plugin, without MySQL but with SQL now I was wondering, how many people would want this system back?

Sincerly I would make it lotsa better offcourse. Gimme a shout and ill give it a go if theres enough people that want it

[GTX]

Yep, I think you should remake it

[AhmadQTR]

Yep, I think you should remake it

+1

You should make it easier for beginners who dosen't know how to setup mysql.

[Cannonball]

I have already started work on a version without MySQL, but with SQLLite databases. Sincerly you don't have to install any other programs to run this plugin.

Only thing holding me back is that I wont be writing this plugin for only 2 people, haha.

[DanHR]

If you are ever going to release this, you could try to add some true / false in the meta, so if someone who wants to use it doesnt want some function, he can just disable it on the meta

[Cannonball]

If you are ever going to release this, you could try to add some true / false in the meta, so if someone who wants to use it doesnt want some function, he can just disable it on the meta

Yea that could be an option.

For now, I was planning on rewriting it on SQL wich is far more compatible for most people here. As you can see they previously had alot off problems setting up a MySQL server and all that.

I have rewritten a small part now, it works absolutely great but I just need more people that want this plugin back again.

[Xeno]

You should remake it! I remember it when it worked and it was awesome.