Vicecity Roleplay Server

[King]

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 )

[Thijn]

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.

[ysc3839]

Is it MySQL? MySQL doesn't support 'TEXT'.

[Murdock]

Is it MySQL? MySQL doesn't support 'TEXT'.

Yes it does

[King]

Updated

script : KIng
Credits : fuzzie , diego

Download Link
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 )

[Kewun]

What is so roleplayish in "this" ?

[[TkD]MarineForce123]

Lol Link ReMoved

[Kelvinvenema]

How to create The Tables my error is MYSQL DOES NOT EXIST

[=RK=MarineForce]

me too xD?

[kennedyarz]

covert to sqlite. easy

[=RK=MarineForce]

how ?

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

[Kelvinvenema]

how ?

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

I hope it work

[Kelvinvenema]

covert to sqlite. easy

Can you changes it for me i send it on discord

[Kelvinvenema]

how ?

    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?