SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Gamemode Scripts

Reply
 
Thread Tools Display Modes
Old 20/09/2014, 12:13 AM   #21
iConvict
Huge Clucker
 
iConvict's Avatar
 
Join Date: May 2012
Posts: 212
Reputation: 111
Default Re: South Central Roleplay 0.20 by Emmet_

^ Can you explain what you in depth, If I'm gonna release something I'm not gonna allow a certain amount of people get the script and tell the rest to fuck off.
iConvict is offline   Reply With Quote
Old 20/09/2014, 12:15 AM   #22
fonia5
Gangsta
 
fonia5's Avatar
 
Join Date: Jun 2014
Location: United Kingdom
Posts: 870
Reputation: 116
Default Re: South Central Roleplay 0.20 by Emmet_

Quote:
Originally Posted by iConvict View Post
^ Can you explain what you in depth, If I'm gonna release something I'm not gonna allow a certain amount of people get the script and tell the rest to fuck off.
Are you talking to me?
fonia5 is offline   Reply With Quote
Old 20/09/2014, 12:17 AM   #23
iConvict
Huge Clucker
 
iConvict's Avatar
 
Join Date: May 2012
Posts: 212
Reputation: 111
Default Re: South Central Roleplay 0.20 by Emmet_

No, I'm talking to the guy above you.
iConvict is offline   Reply With Quote
Old 20/09/2014, 12:17 AM   #24
fonia5
Gangsta
 
fonia5's Avatar
 
Join Date: Jun 2014
Location: United Kingdom
Posts: 870
Reputation: 116
Default Re: South Central Roleplay 0.20 by Emmet_

Quote:
Originally Posted by iConvict View Post
No, I'm talking to the guy above you.
oh reply with Quote next time lol. got abit worried then.
fonia5 is offline   Reply With Quote
Old 20/09/2014, 12:24 AM   #25
DRIFT_HUNTER
High-roller
 
Join Date: Oct 2009
Posts: 2,106
Reputation: 128
Default Re: South Central Roleplay 0.20 by Emmet_

Quote:
Originally Posted by fonia5 View Post
work's perfectly for me to also can you help me with the billboards ?? i tryed to make don't no what i messed up here.


Code:
CREATE TABLE IF NOT EXISTS `billboards` ( 
	`bbID` int(12) NOT NULL AUTO_INCREMENT,
	`bbExists` int(12) NOT NULL AUTOD_INCREMENT,
	`bbName` varchar(32) DEFAULT NULL,
	`bbMessages` varchar(230) DEFAULT NULL,
	`bbOwner` int(12) DEFAULT "0",
	`bbPrice` int(12) DEFAULT "0",
	`bbRange` float DEFAULT "0",
	`bbPos` float DEFAULT "0",
	`bbText3D` float DEFAULT "0",
	PRIMARY KEY (`bbID`)
)   ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=94 ;
if it's all wrong lol am new to the Mysql scripting.
Here is bb table rebuilded by me (Looking at load function...)
Code:
CREATE TABLE IF NOT EXISTS `billboards` (
  `bbID` int(11) NOT NULL AUTO_INCREMENT,
  `bbName` varchar(32) DEFAULT NULL,
  `bbMessage` varchar(230) DEFAULT NULL,
  `bbOwner` int(11) NOT NULL DEFAULT '0',
  `bbPrice` int(11) NOT NULL DEFAULT '0',
  `bbRange` int(11) NOT NULL DEFAULT '0',
  `bbPosX` float NOT NULL DEFAULT '0',
  `bbPosY` float NOT NULL DEFAULT '0',
  `bbPosZ` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`bbID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
Only mistake i found is bbRange that is Integer for some reason... (I mean integer in GM script, while you set it to float which is completely logically...)
DRIFT_HUNTER is offline   Reply With Quote
Old 20/09/2014, 12:28 AM   #26
fonia5
Gangsta
 
fonia5's Avatar
 
Join Date: Jun 2014
Location: United Kingdom
Posts: 870
Reputation: 116
Default Re: South Central Roleplay 0.20 by Emmet_

Quote:
Originally Posted by DRIFT_HUNTER View Post
Here is bb table rebuilded by me (Looking at load function...)
Code:
CREATE TABLE IF NOT EXISTS `billboards` (
  `bbID` int(11) NOT NULL AUTO_INCREMENT,
  `bbName` varchar(32) DEFAULT NULL,
  `bbMessage` varchar(230) DEFAULT NULL,
  `bbOwner` int(11) NOT NULL DEFAULT '0',
  `bbPrice` int(11) NOT NULL DEFAULT '0',
  `bbRange` int(11) NOT NULL DEFAULT '0',
  `bbPosX` float NOT NULL DEFAULT '0',
  `bbPosY` float NOT NULL DEFAULT '0',
  `bbPosZ` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`bbID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
Only mistake i found is bbRange that is Integer for some reason... (I mean integer in GM script, while you set it to float which is completely logically...)
okay for some reason it didnt let me login i found something else you might think of why it wont let me register in.

Code:
CREATE TABLE IF NOT EXISTS `accounts` (
  `ID` int(12) NOT NULL AUTO_INCREMENT,
  `Username` varchar(24) DEFAULT NULL,
  `Password` varchar(129) DEFAULT NULL,
  `RegisterDate` varchar(36) DEFAULT NULL,
  `LoginDate` varchar(36) DEFAULT NULL,
  `IP` varchar(16) DEFAULT 'n/a',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2699 ;
am not sure if this is correct.

billboard work also showing a error saying unkown column `OwnsBillboards in `field list`
still not letting me spawn when i fill all the stuff in the black box.
fonia5 is offline   Reply With Quote
Old 20/09/2014, 12:45 AM   #27
DRIFT_HUNTER
High-roller
 
Join Date: Oct 2009
Posts: 2,106
Reputation: 128
Default Re: South Central Roleplay 0.20 by Emmet_

Quote:
Originally Posted by fonia5 View Post
okay for some reason it didnt let me login i found something else you might think of why it wont let me register in.

Code:
CREATE TABLE IF NOT EXISTS `accounts` (
  `ID` int(12) NOT NULL AUTO_INCREMENT,
  `Username` varchar(24) DEFAULT NULL,
  `Password` varchar(129) DEFAULT NULL,
  `RegisterDate` varchar(36) DEFAULT NULL,
  `LoginDate` varchar(36) DEFAULT NULL,
  `IP` varchar(16) DEFAULT 'n/a',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2699 ;
am not sure if this is correct.

billboard work also showing a error saying unkown column `OwnsBillboards in `field list`
still not letting me spawn when i fill all the stuff in the black box.
That character table is completely ok.

I guess (actually im sure) its OwnsBillboard (without S at the end), and its missing variable in mysql characters table (Shall be Integer).

Clearly these database structure is from older version and billboards were added in these one (script)...
DRIFT_HUNTER is offline   Reply With Quote
Old 20/09/2014, 12:51 AM   #28
fonia5
Gangsta
 
fonia5's Avatar
 
Join Date: Jun 2014
Location: United Kingdom
Posts: 870
Reputation: 116
Default Re: South Central Roleplay 0.20 by Emmet_

i added it like this.

Code:
`OwnsBillboard` varchar(36) DEFAULT NULL,
might not be correct because it's showing the error were should i make it in the account table?
fonia5 is offline   Reply With Quote
Old 20/09/2014, 01:09 AM   #29
DRIFT_HUNTER
High-roller
 
Join Date: Oct 2009
Posts: 2,106
Reputation: 128
Default Re: South Central Roleplay 0.20 by Emmet_

Quote:
Originally Posted by fonia5 View Post
i added it like this.

Code:
`OwnsBillboard` varchar(36) DEFAULT NULL,
might not be correct because it's showing the error were should i make it in the account table?
Told you it has to be integer...
And its all the same where...it wont affect anything...
DRIFT_HUNTER is offline   Reply With Quote
Old 20/09/2014, 01:14 AM   #30
fonia5
Gangsta
 
fonia5's Avatar
 
Join Date: Jun 2014
Location: United Kingdom
Posts: 870
Reputation: 116
Default Re: South Central Roleplay 0.20 by Emmet_

Quote:
Originally Posted by DRIFT_HUNTER View Post
Told you it has to be integer...
And its all the same where...it wont affect anything...
okay i got it fully function working now.
fonia5 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
South Central Roleplay - PD iConvict Screenshots and Videos 0 18/02/2014 09:03 PM


All times are GMT. The time now is 04:46 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.