SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 26/03/2020, 07:51 PM   #11
ShadowMortar
Big Clucker
 
ShadowMortar's Avatar
 
Join Date: Jul 2016
Location: Croatia
Posts: 167
Reputation: 31
Default Re: Faction System

Quote:
Originally Posted by Ukson View Post
I want to learn when INT goes, VARCHAR...
INT stands for integer ( 0, 1, 2, 3...)
FLOAT is approximate number data type ( 5.3, 99.19, 300.20... )
VARCHAR is character data which can contain numbers, letters and special characters( $h@d0w_123, Lel_1_#, ... )
BOOL for boolean variables ( in sql 0 stands for false, 1 stands for true )
(...)
> https://www.w3schools.com/sql/sql_datatypes.asp
__________________
Quote:
Originally Posted by CheezIt View Post
Follow your heart and own style.
Feel free to PM me if you need help.
ShadowMortar is online now   Reply With Quote
Old 26/03/2020, 07:56 PM   #12
Ukson
Little Clucker
 
Ukson's Avatar
 
Join Date: Jul 2015
Location: Serbian
Posts: 31
Reputation: 0
Default Re: Faction System

Thank you very much
Ukson is offline   Reply With Quote
Old 26/03/2020, 09:38 PM   #13
Ukson
Little Clucker
 
Ukson's Avatar
 
Join Date: Jul 2015
Location: Serbian
Posts: 31
Reputation: 0
Default Re: Faction System

I'll be looking for new errori
https://pastebin.com/Scf3sBh6
Ukson is offline   Reply With Quote
Old 26/03/2020, 09:54 PM   #14
l0gic
Big Clucker
 
Join Date: Aug 2019
Posts: 103
Reputation: 16
Default Re: Faction System

I think you should start from something simplier at the moment you are accesing field from database you havent even created. You have to use localhost/phpmyadmin for example to create them.
This gamemode what you have, must also have database.sql file, what you have to upload.
You don't create gamemode tabels with queries.
like this one for example
PHP Code:
CREATE TABLE IF NOT EXISTS `organizacije`( `IDINT(10NOT NULL UNIQUE, `tipINT(10NOT NULL, `intINT(10), `rank1VARCHAR(40NOT NULL, `rank2VARCHAR(40NOT NULL
                                           `
rank3VARCHAR(40NOT NULL, `rank4VARCHAR(40NOT NULL, `rank5VARCHAR(40NOT NULL, `rank6VARCHAR(40NOT NULL
                                           `
rank7VARCHAR(40NOT NULL, `liderVARCHAR(40NOT NULL, `skrVARCHAR(40NOT NULL ); 
__________________
Coding experience with: PAWN, Java, Python, Javascript, PHP and SQL for about 6 years.
l0gic is offline   Reply With Quote
Old 26/03/2020, 10:03 PM   #15
Ukson
Little Clucker
 
Ukson's Avatar
 
Join Date: Jul 2015
Location: Serbian
Posts: 31
Reputation: 0
Default Re: Faction System

I think I need to add more to this `skin`,` icon`...
https://imgur.com/f3DBbA0
Ukson is offline   Reply With Quote
Old 26/03/2020, 10:11 PM   #16
l0gic
Big Clucker
 
Join Date: Aug 2019
Posts: 103
Reputation: 16
Default Re: Faction System

yes thats right, you have to add those fields
__________________
Coding experience with: PAWN, Java, Python, Javascript, PHP and SQL for about 6 years.
l0gic is offline   Reply With Quote
Old 26/03/2020, 10:20 PM   #17
Ukson
Little Clucker
 
Ukson's Avatar
 
Join Date: Jul 2015
Location: Serbian
Posts: 31
Reputation: 0
Default Re: Faction System

Sorry just one more question in which order I make in the databases columns?
Ukson is offline   Reply With Quote
Old 26/03/2020, 10:29 PM   #18
l0gic
Big Clucker
 
Join Date: Aug 2019
Posts: 103
Reputation: 16
Default Re: Faction System

it doesnt matter, type must be right, integer, text etc.
__________________
Coding experience with: PAWN, Java, Python, Javascript, PHP and SQL for about 6 years.
l0gic is offline   Reply With Quote
Old 26/03/2020, 10:33 PM   #19
Ukson
Little Clucker
 
Ukson's Avatar
 
Join Date: Jul 2015
Location: Serbian
Posts: 31
Reputation: 0
Default Re: Faction System

Thank you very much
Ukson 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
Making faction system more than 1 faction Zeus666 Scripting Help 9 16/04/2018 10:10 AM
[FilterScript] [Request]Dynaimc Faction System and Crates System Doros Filterscripts 6 05/11/2017 05:48 PM
Faction System Jigsaw123 Scripting Help 3 26/09/2014 07:55 PM
Help with faction system Michael_Cuellar Scripting Help 3 12/04/2013 01:25 AM
Faction System ruben2812 Help Archive 1 29/05/2010 11:45 AM


All times are GMT. The time now is 09:35 AM.


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