Vice City: Multiplayer

Server Development => Scripting and Server Management => Script Showroom => Topic started by: King on Jul 05, 2016, 04:13 AM

Title: Vicecity Roleplay Server
Post by: King on Jul 05, 2016, 04:13 AM
script : KIng
Credits : fuzzie , diego

Download Link : -- Link removed: Contains server/plugin files --

Make owner = your ip and type /test atleast once to load cars and make yourself admin. Uses Mysql database.

Mysql tables

CREATE TABLE Accounts ( Name VARCHAR(255), NameLower VARCHAR(255), Password VARCHAR(255), Cash INT, Bank INT, Robskill INT, Copskill INT, Wantedlevel INT, Level INT, LastUsedIP VARCHAR(255) );
CREATE TABLE Bans ( NameLower VARCHAR(255), UID VARCHAR(255), Reason VARCHAR(255) );
CREATE TABLE Gotoloc ( Name VARCHAR(32), x INT, y INT, z INT, Creator VARCHAR(32));
CREATE TABLE Cars ( ID NUMERIC, Cost VARCHAR(25), Owner TEXT, Shared TEXT )


Title: Re: Vicecity Roleplay Server
Post by: Thijn on Jul 05, 2016, 05:48 AM
Releasing your script with the plugins and server included is against the rules. Please upload just your script files, nothing else.



Saving coordinates as INTs isn't the best idea. You'll lose quite a bit of precision. Try playing around with floats instead.
Title: Re: Vicecity Roleplay Server
Post by: ysc3839 on Jul 05, 2016, 10:05 AM
Is it MySQL? MySQL doesn't support 'TEXT'.
Title: Re: Vicecity Roleplay Server
Post by: Murdock on Jul 05, 2016, 01:20 PM
Quote from: ysc3839 on Jul 05, 2016, 10:05 AMIs it MySQL? MySQL doesn't support 'TEXT'.

Yes it does (http://dev.mysql.com/doc/refman/5.7/en/blob.html)
Title: Re: Vicecity Roleplay Server
Post by: King on Jul 07, 2016, 04:13 AM
Updated
Quote from: King on Jul 05, 2016, 04:13 AMscript : KIng
Credits : fuzzie , diego

Download Link (https://forum.vc-mp.org/proxy.php?request=http%3A%2F%2Ffiles.thijn.ovh%2Fimg%2F86e6aa01b173e1f8fba4d5fb5d4cea06%2FVCRP%2520%282%29.zip&hash=22af994bc9d40c295f8eaaf73ec5b4d03fd82b5f) (http://files.thijn.ovh/download/86e6aa01b173e1f8fba4d5fb5d4cea06/VCRP%20(2).zip)
Make owner = your ip and type /test atleast once to load cars and make yourself admin. Uses Mysql database.

Mysql tables

CREATE TABLE Accounts ( Name VARCHAR(255), NameLower VARCHAR(255), Password VARCHAR(255), Cash INT, Bank INT, Robskill INT, Copskill INT, Wantedlevel INT, Level INT, LastUsedIP VARCHAR(255) );
CREATE TABLE Bans ( NameLower VARCHAR(255), UID VARCHAR(255), Reason VARCHAR(255) );
CREATE TABLE Gotoloc ( Name VARCHAR(32), x FLOAT, y FLOAT, z FLOAT, Creator VARCHAR(32));
CREATE TABLE Cars ( ID NUMERIC, Cost VARCHAR(25), Owner TEXT, Shared TEXT )



Title: Re: Vicecity Roleplay Server
Post by: Kewun on Aug 28, 2016, 03:01 PM
What is so roleplayish in "this" ?
Title: Re: Vicecity Roleplay Server
Post by: [TkD]MarineForce123 on Jun 28, 2017, 10:43 PM
Lol Link ReMoved
Title: Re: Vicecity Roleplay Server
Post by: Kelvinvenema on Apr 26, 2018, 06:56 PM
How to create The Tables my error is MYSQL DOES NOT EXIST

Title: Re: Vicecity Roleplay Server
Post by: =RK=MarineForce on Apr 26, 2018, 08:29 PM
me too xD?
Title: Re: Vicecity Roleplay Server
Post by: kennedyarz on Apr 26, 2018, 10:44 PM
covert to sqlite. easy
Title: Re: Vicecity Roleplay Server
Post by: =RK=MarineForce on Apr 27, 2018, 07:49 AM
how ?

    sqliteDB <- mysql_connect( "localhost", "root", "password", "vcmp" ); this error but i m remove this srver not coming
Title: Re: Vicecity Roleplay Server
Post by: Kelvinvenema on Apr 27, 2018, 09:27 AM
Quote from: =RK=MarineForce on Apr 27, 2018, 07:49 AMhow ?

    sqliteDB <- mysql_connect( "localhost", "root", "password", "vcmp" ); this error but i m remove this srver not coming


I hope it work ;)

Title: Re: Vicecity Roleplay Server
Post by: Kelvinvenema on Apr 27, 2018, 09:28 AM
Quote from: kennedyarz on Apr 26, 2018, 10:44 PMcovert to sqlite. easy


Can you changes it for me i send it on discord
Title: Re: Vicecity Roleplay Server
Post by: Kelvinvenema on May 04, 2018, 11:57 AM
Quote from: =RK=MarineForce on Apr 27, 2018, 07:49 AMhow ?

    sqliteDB <- mysql_connect( "localhost", "root", "password", "vcmp" ); this error but i m remove this srver not coming




Did you figure it out how to make details correct?