[GameMode] Everlast Gaming Script [by TheShadow]
#21

Great (:
Reply
#22

I can not download it please upload it some other place thank you
Reply
#23

Quote:
Originally Posted by Aarab
Посмотреть сообщение
Can someone explain me about the DATABASE shit? I tried to import this but it gives me an error.

Код:
TABLE 'users'
id
online
name
bank
ajailed
Warrent
AddInfo
paydays
dice
age
jobtime
money
reduce
OnTime
admin
mats
skin
jail
RB
c4
faction
rank
job
Gender
gunslot1,ammoslot1
...
...
gunslot19,ammoslot19
ban
ck
ip
rent
rentpay
pbook
pager
DetSkill
DrugsSkill
drugs
speeding
recklessdriving


TABLE 'houses'
owner(str,def=No)
bank(int)
id(int)
price(int)
x
y
z
pid
worldid
rooms
locked
info

TABLE `cellphones`
number(int)
ID(playerid)
shownum

TABLE `pager`
Number(int)
ID(playerid)

TABLE `groups`
leader

TABLE `ranks`
`1`,`2`,`3`,.....`20`,`300`

TABLE `factions` (FIRST ONE IS the CIVILIANS)
id
type
i
x
y
z
name
salary
diff


TABLE `pddatabase`
name (s)
reporter (s)
 //string (s)
reason(s)
date(s (d.d.d))
time(s (d.d.d))

TABLE `interiors`
id
int
x
y
z
a

TABLE `vehicles`
id
type
x
y
z
r
color1
color2
plate
armor
vid
windows
gpsed
lock
locked
price


TABLE `objects`
id
fid
mid
oid
state
message
x
y
z
rx
ry
rz
fast


TABLE `teleports`
id
x
y
z
i
pid
inhouse
w
x2
y2
z2
i2
inhouse2
w2

TABLE `admintems`
id
perm
name

TABLE `ranks`
id

TABLE `ATM`
ID x Y Z

TALBE `gpsarea`
id
r
string
`ranks`1
1=Last
2..9=NO
10=Oo
11=No
12...18=No
19=No 20=No 


TABLE `bugs`
reporter
bug

TABLE `reports`
id 
reporter 
reported 
hour
min
day
month
year
report
accepted
endreport

TABLE carlist
id
price

TABLE `mayors`
name
votes

TABLE `voted`
name

TABLE donated
name
What do you mean by "tried to import it"?


*Added new links
Reply
#24

Quote:
Originally Posted by -=TheShadow=-
Посмотреть сообщение
What do you mean by "tried to import it"?


*Added new links
He means he tried to import tables in MYSQL but (it wouldn't work)!
Reply
#25

Quote:
Originally Posted by Alex Magaсa
Посмотреть сообщение
He means he tried to import tables in MYSQL but (it wouldn't work)!
1. you have to create a databse, that something that i did not implent in the query.
2. after you create the database, you should run whats in the "code" as a quary, that should work, tell me if it doesnt.
3. Also you have to create a file "mysql.txt", the file hsould be in the follow style: ((* NOTE : For it to work you HAVE to delete the file "myserver.txt" from scriptfiles foulder ))

Код:
ip=*the ip of the sql server*
username=*usename*
pass=*password*
db=*name of the database*
Reply
#26

Lots of lines
Reply
#27

Quote:
Originally Posted by -=TheShadow=-
Посмотреть сообщение
What do you mean by "tried to import it"?


*Added new links
ty bro and i think i was a member of this Samp Game Server a long long long long long time ago i can not bel it's here now Thank You TheShadow for giving it to us +Rep Bro
Reply
#28

This looks like is was scripted fairly decently good job on that.
Reply
#29

Not bad for 13k lines xd.
Got all basic stuff nice.
Reply
#30

Thanks everyone, I added command list to the main topic (I bet i forgot some commands)
Reply
#31

Anyone here knows how I make myself admin?
Reply
#32

Do I have to create the mysql tables myself by the format you posted in this thread? or I just put this format somewhere? Thanks.
Reply
#33

Nice GM
Reply
#34

nice...
Reply
#35

Other links please? I wanna try this script. I can't download on your links.
Reply
#36

hey bro
how to fix?
and how to create a sql table?

Quote:

[16:51:41]
Connection to MySQL database: Successfull !
[16:51:41] Error in mysql_query: Table 'sgrp.donated' doesn't exist
[16:51:41] Error in mysql_query: Table 'sgrp.users' doesn't exist
[16:51:41] Error in mysql_query: Table 'sgrp.objects' doesn't exist
[16:51:41] Error in mysql_query: Table 'sgrp.objects' doesn't exist
[16:51:41] Error in mysql_store_result: Table 'sgrp.objects' doesn't exist

Reply
#37

Thank you
Reply
#38

Great, Keep going! (:
Reply


Forum Jump:


Users browsing this thread: 5 Guest(s)